Oracle Apps Technical Stuff
Wednesday, October 5, 2016
Script to get the Child Instances (Subject id) for requested Parent Instance (Object id ) in Install Base.
›
CREATE OR REPLACE FUNCTION get_children( p_object_id IN NUMBER) RETURN csi_datastructures_pub.ii_relationship_tbl IS -- l_rel_...
Thursday, September 8, 2016
API for Expire Instance relationship in Oracle install base
›
PROCEDURE csi_expire_relationship( p_object_id IN NUMBER) IS l_relationship_rec csi_datastructures_pub.ii_re...
API to create Instance relationship in Oracle install Base
›
PROCEDURE csi_create_relationship( p_relationship_tbl IN csi_datastructures_pub.ii_relationship_tbl , x_return_status ...
API to Expire Instance in Oracle Install Base
›
DECLARE l_record_status VARCHAR2(1); l_sv_status VARCHAR2(2000); ...
Sunday, September 4, 2016
API to swap Service contract for Newly created Install Base with Old install base
›
DECLARE p_transaction_type VARCHAR2(50); p_instance_id NUMBER; p_new_instance_id NUMBER;...
‹
›
Home
View web version