APPS.CSI_ACCT_MERGE_PKG dependencies on CSI_SYSTEMS_H

Line 1716: FROM csi_systems_h

1712: BEGIN -- { Update systems history
1713:
1714: SELECT count(*)
1715: INTO v_transaction_cnt
1716: FROM csi_systems_h
1717: WHERE transaction_id = v_transaction_id
1718: AND system_id = PRIMARY_KEY_ID_LIST(I);
1719:
1720: write_to_cr_log( 'CSI : Transaction history record count '|| to_char(v_transaction_cnt) );

Line 1725: FROM csi_systems_h

1721:
1722: error_str := '009';
1723: SELECT system_history_id
1724: INTO v_system_history_id
1725: FROM csi_systems_h
1726: WHERE transaction_id = v_transaction_id
1727: AND system_id = PRIMARY_KEY_ID_LIST(I);
1728:
1729: write_to_cr_log( 'CSI : Transaction history record id '|| to_char(v_system_history_id) );

Line 1732: UPDATE csi_systems_h

1728:
1729: write_to_cr_log( 'CSI : Transaction history record id '|| to_char(v_system_history_id) );
1730:
1731: error_str := '010';
1732: UPDATE csi_systems_h
1733: SET old_customer_id = NUM_COL1_ORIG_LIST(I) ,
1734: new_customer_id = NUM_COL1_NEW_LIST(I) ,
1735: old_bill_to_site_use_id = NUM_COL2_ORIG_LIST(I) ,
1736: new_bill_to_site_use_id = NUM_COL2_NEW_LIST(I) ,

Line 1751: INSERT INTO csi_systems_h

1747:
1748: write_to_cr_log( 'CSI : No system history record found ' );
1749:
1750: error_str := '011';
1751: INSERT INTO csi_systems_h
1752: (
1753: system_history_id ,
1754: system_id ,
1755: transaction_id ,

Line 1772: csi_systems_h_s.nextval ,

1768: object_version_number
1769: )
1770: VALUES
1771: (
1772: csi_systems_h_s.nextval ,
1773: PRIMARY_KEY_ID_LIST(I) ,
1774: v_transaction_id ,
1775: NUM_COL1_ORIG_LIST(I) ,
1776: NUM_COL1_NEW_LIST(I) ,