DBA Data[Home] [Help]

APPS.CSI_PARTY_MERGE_PKG dependencies on CSI_SYSTEMS_H

Line 682: INSERT INTO csi_systems_h

678:
679: If p_parent_entity_name = 'HZ_PARTY_SITES' Then
680: v_no_of_rows := 0;
681:
682: INSERT INTO csi_systems_h
683: (system_history_id,
684: system_id,
685: transaction_id,
686: old_install_site_use_id,

Line 696: SELECT csi_systems_h_s.nextval,

692: last_update_date,
693: last_update_login,
694: object_version_number
695: )
696: SELECT csi_systems_h_s.nextval,
697: csb.system_id,
698: v_transaction_id,
699: p_from_fk_id,
700: p_to_fk_id,

Line 742: INSERT INTO csi_systems_h

738: Elsif p_parent_entity_name = 'HZ_PARTIES' Then
739:
740: v_no_of_rows := 0;
741:
742: INSERT INTO csi_systems_h
743: (
744: system_history_id,
745: system_id,
746: transaction_id,

Line 763: SELECT csi_systems_h_s.nextval,

759: last_update_date,
760: last_update_login,
761: object_version_number
762: )
763: SELECT csi_systems_h_s.nextval,
764: csb.system_id,
765: v_transaction_id,
766: decode( csb.ship_to_contact_id, p_from_fk_id, p_from_fk_id, null ),
767: decode( csb.ship_to_contact_id, p_from_fk_id, p_to_fk_id, null ),