DBA Data[Home] [Help]

APPS.CSI_PARTY_MERGE_PKG dependencies on CSI_SYSTEMS_H

Line 756: INSERT INTO csi_systems_h

752:
753: If p_parent_entity_name = 'HZ_PARTY_SITES' Then
754: v_no_of_rows := 0;
755:
756: INSERT INTO csi_systems_h
757: (system_history_id,
758: system_id,
759: transaction_id,
760: old_install_site_use_id,

Line 770: SELECT csi_systems_h_s.nextval,

766: last_update_date,
767: last_update_login,
768: object_version_number
769: )
770: SELECT csi_systems_h_s.nextval,
771: csb.system_id,
772: v_transaction_id,
773: p_from_fk_id,
774: p_to_fk_id,

Line 816: INSERT INTO csi_systems_h

812: Elsif p_parent_entity_name = 'HZ_PARTIES' Then
813:
814: v_no_of_rows := 0;
815:
816: INSERT INTO csi_systems_h
817: (
818: system_history_id,
819: system_id,
820: transaction_id,

Line 837: SELECT csi_systems_h_s.nextval,

833: last_update_date,
834: last_update_login,
835: object_version_number
836: )
837: SELECT csi_systems_h_s.nextval,
838: csb.system_id,
839: v_transaction_id,
840: decode( csb.ship_to_contact_id, p_from_fk_id, p_from_fk_id, null ),
841: decode( csb.ship_to_contact_id, p_from_fk_id, p_to_fk_id, null ),