APPS.CSI_PARTY_MERGE_PKG dependencies on CSI_TRANSACTIONS

Line 145: FROM csi_transactions

141: End;
142:
143: SELECT transaction_id
144: INTO v_transaction_id
145: FROM csi_transactions
146: WHERE source_line_ref_id = p_batch_id AND
147: transaction_type_id = v_transaction_type_id;
148:
149: Exception

Line 157: SELECT CSI_TRANSACTIONS_S.nextval

153: Begin
154:
155: Begin
156:
157: SELECT CSI_TRANSACTIONS_S.nextval
158: INTO v_transaction_id
159: FROM dual;
160:
161: End;

Line 163: INSERT INTO csi_transactions(

159: FROM dual;
160:
161: End;
162:
163: INSERT INTO csi_transactions(
164: transaction_id
165: ,transaction_date
166: ,source_transaction_date
167: ,transaction_type_id

Line 398: FROM csi_transactions

394: raise txn_type_not_found_error;
395: End;
396: SELECT transaction_id
397: INTO v_transaction_id
398: FROM csi_transactions
399: WHERE source_line_ref_id = p_batch_id
400: AND transaction_type_id = v_transaction_type_id;
401: Exception
402: When no_data_found Then

Line 405: SELECT CSI_TRANSACTIONS_S.nextval

401: Exception
402: When no_data_found Then
403: Begin
404: Begin
405: SELECT CSI_TRANSACTIONS_S.nextval
406: INTO v_transaction_id
407: FROM dual;
408: End;
409: INSERT INTO csi_transactions

Line 409: INSERT INTO csi_transactions

405: SELECT CSI_TRANSACTIONS_S.nextval
406: INTO v_transaction_id
407: FROM dual;
408: End;
409: INSERT INTO csi_transactions
410: (
411: transaction_id
412: ,transaction_date
413: ,source_transaction_date

Line 635: FROM csi_transactions

631: End;
632:
633: SELECT transaction_id
634: INTO v_transaction_id
635: FROM csi_transactions
636: WHERE source_line_ref_id = p_batch_id
637: AND transaction_type_id = v_transaction_type_id;
638:
639: EXCEPTION

Line 645: SELECT CSI_TRANSACTIONS_S.nextval

641:
642: Begin
643:
644: Begin
645: SELECT CSI_TRANSACTIONS_S.nextval
646: INTO v_transaction_id
647: FROM dual;
648: End;
649:

Line 650: INSERT INTO csi_transactions(

646: INTO v_transaction_id
647: FROM dual;
648: End;
649:
650: INSERT INTO csi_transactions(
651: transaction_id
652: ,transaction_date
653: ,source_transaction_date
654: ,transaction_type_id