APPS.CSI_ACCT_MERGE_PKG dependencies on CSI_SYSTEMS_H

Line 1748: FROM csi_systems_h

1744: BEGIN -- { Update systems history
1745:
1746: SELECT count(*)
1747: INTO v_transaction_cnt
1748: FROM csi_systems_h
1749: WHERE transaction_id = v_transaction_id
1750: AND system_id = PRIMARY_KEY_ID_LIST(I);
1751:
1752: write_to_cr_log( 'CSI : Transaction history record count '|| to_char(v_transaction_cnt) );

Line 1757: FROM csi_systems_h

1753:
1754: error_str := '009';
1755: SELECT system_history_id
1756: INTO v_system_history_id
1757: FROM csi_systems_h
1758: WHERE transaction_id = v_transaction_id
1759: AND system_id = PRIMARY_KEY_ID_LIST(I);
1760:
1761: write_to_cr_log( 'CSI : Transaction history record id '|| to_char(v_system_history_id) );

Line 1764: UPDATE csi_systems_h

1760:
1761: write_to_cr_log( 'CSI : Transaction history record id '|| to_char(v_system_history_id) );
1762:
1763: error_str := '010';
1764: UPDATE csi_systems_h
1765: SET old_customer_id = NUM_COL1_ORIG_LIST(I) ,
1766: new_customer_id = NUM_COL1_NEW_LIST(I) ,
1767: old_bill_to_site_use_id = NUM_COL2_ORIG_LIST(I) ,
1768: new_bill_to_site_use_id = NUM_COL2_NEW_LIST(I) ,

Line 1783: INSERT INTO csi_systems_h

1779:
1780: write_to_cr_log( 'CSI : No system history record found ' );
1781:
1782: error_str := '011';
1783: INSERT INTO csi_systems_h
1784: (
1785: system_history_id ,
1786: system_id ,
1787: transaction_id ,

Line 1804: csi_systems_h_s.nextval ,

1800: object_version_number
1801: )
1802: VALUES
1803: (
1804: csi_systems_h_s.nextval ,
1805: PRIMARY_KEY_ID_LIST(I) ,
1806: v_transaction_id ,
1807: NUM_COL1_ORIG_LIST(I) ,
1808: NUM_COL1_NEW_LIST(I) ,