APPS.CSI_PARTY_MERGE_PKG dependencies on CSI_ITEM_INSTANCES_H

Line 227: INSERT INTO CSI_ITEM_INSTANCES_H

223:
224: csi_t_gen_utility_pvt.ADD('Insert record to history.');
225:
226: BEGIN
227: INSERT INTO CSI_ITEM_INSTANCES_H
228: (
229: INSTANCE_HISTORY_ID
230: ,INSTANCE_ID
231: ,TRANSACTION_ID

Line 245: CSI_ITEM_INSTANCES_H_S.nextval

241: ,OLD_INST_LOC_ID
242: ,NEW_INST_LOC_ID
243: )
244: SELECT
245: CSI_ITEM_INSTANCES_H_S.nextval
246: ,cii.INSTANCE_ID
247: ,v_transaction_id
248: ,decode( cii.location_id, p_from_fk_id, cii.location_id, null )
249: ,decode( cii.location_id, p_from_fk_id, p_to_fk_id, null )

Line 279: UPDATE csi_item_instances_h cih

275:
276: EXCEPTION
277: WHEN DUP_VAL_ON_INDEX THEN
278: BEGIN
279: UPDATE csi_item_instances_h cih
280: SET cih.new_location_id = decode(cih.new_location_id, p_from_fk_id, p_to_fk_id),
281: cih.new_inst_loc_id = decode(cih.new_inst_loc_id, p_from_fk_id, p_to_fk_id),
282: last_update_date = sysdate
283: WHERE cih.transaction_id = v_transaction_id

Line 286: FROM csi_item_instances_h cii2

282: last_update_date = sysdate
283: WHERE cih.transaction_id = v_transaction_id
284: AND cih.instance_history_id IN
285: (SELECT cii2.instance_history_id
286: FROM csi_item_instances_h cii2
287: WHERE(cii2.new_location_id = p_from_fk_id OR cii2.new_inst_loc_id = p_from_fk_id)
288: AND cii2.transaction_id = v_transaction_id);
289: EXCEPTION
290: WHEN others THEN