APPS.CSI_ACCT_MERGE_PKG dependencies on CSI_TRANSACTIONS

Line 521: FROM csi_transactions

517: csi_t_gen_utility_pvt.add('set_num-'||set_num);
518: csi_t_gen_utility_pvt.add('req_id-'||req_id);
519: SELECT transaction_id
520: INTO v_transaction_id
521: FROM csi_transactions
522: WHERE source_line_ref_id = req_id
523: AND source_line_ref = set_num;
524:
525: p_txn_rec.transaction_id := v_transaction_id;

Line 1654: FROM csi_transactions

1650: 1.2 set the transaction_inserted_flag = 'Y'
1651: ------*/
1652: SELECT count(*)
1653: INTO v_transaction_cnt
1654: FROM csi_transactions
1655: WHERE source_line_ref_id = req_id
1656: AND source_line_ref = set_num;
1657:
1658: write_to_cr_log( 'CSI : Transaction record count for '

Line 1668: FROM csi_transactions

1664: BEGIN -- { select csi_transaction
1665: error_str := '005';
1666: SELECT transaction_id
1667: INTO v_transaction_id
1668: FROM csi_transactions
1669: WHERE source_line_ref_id = req_id
1670: AND source_line_ref = set_num;
1671:
1672: v_transaction_exists := 'Y';

Line 1698: SELECT csi_transactions_s.nextval

1694:
1695: write_to_cr_log( 'CSI : Transaction type record id ' || to_char(v_transaction_type_id) );
1696:
1697: error_str := '007';
1698: SELECT csi_transactions_s.nextval
1699: INTO v_transaction_id
1700: FROM dual;
1701:
1702: write_to_cr_log( 'CSI : Transaction id from sequence ' || to_char(v_transaction_id) );

Line 1705: INSERT INTO csi_transactions

1701:
1702: write_to_cr_log( 'CSI : Transaction id from sequence ' || to_char(v_transaction_id) );
1703:
1704: error_str := '008';
1705: INSERT INTO csi_transactions
1706: (
1707: transaction_id ,
1708: transaction_date ,
1709: source_transaction_date ,