APPS.CSI_ACCT_MERGE_PKG dependencies on CSI_TRANSACTIONS

Line 485: FROM csi_transactions

481: --
482: BEGIN
483: SELECT transaction_id
484: INTO v_transaction_id
485: FROM csi_transactions
486: WHERE source_line_ref_id = req_id
487: AND source_line_ref = set_num;
488:
489: p_txn_rec.transaction_id := v_transaction_id;

Line 1622: FROM csi_transactions

1618: 1.2 set the transaction_inserted_flag = 'Y'
1619: ------*/
1620: SELECT count(*)
1621: INTO v_transaction_cnt
1622: FROM csi_transactions
1623: WHERE source_line_ref_id = req_id
1624: AND source_line_ref = set_num;
1625:
1626: write_to_cr_log( 'CSI : Transaction record count for '

Line 1636: FROM csi_transactions

1632: BEGIN -- { select csi_transaction
1633: error_str := '005';
1634: SELECT transaction_id
1635: INTO v_transaction_id
1636: FROM csi_transactions
1637: WHERE source_line_ref_id = req_id
1638: AND source_line_ref = set_num;
1639:
1640: v_transaction_exists := 'Y';

Line 1666: SELECT csi_transactions_s.nextval

1662:
1663: write_to_cr_log( 'CSI : Transaction type record id ' || to_char(v_transaction_type_id) );
1664:
1665: error_str := '007';
1666: SELECT csi_transactions_s.nextval
1667: INTO v_transaction_id
1668: FROM dual;
1669:
1670: write_to_cr_log( 'CSI : Transaction id from sequence ' || to_char(v_transaction_id) );

Line 1673: INSERT INTO csi_transactions

1669:
1670: write_to_cr_log( 'CSI : Transaction id from sequence ' || to_char(v_transaction_id) );
1671:
1672: error_str := '008';
1673: INSERT INTO csi_transactions
1674: (
1675: transaction_id ,
1676: transaction_date ,
1677: source_transaction_date ,