APPS.ECX_TP_API dependencies on ECX_TRANSACTIONS

Line 609: x_transaction_description ecx_transactions_tl.transaction_description%type;

605: x_ext_process_id number := 0;
606: x_transaction_id number := 0;
607: x_standard_id number := 0;
608: x_queue_name ecx_ext_processes.queue_name%type;
609: x_transaction_description ecx_transactions_tl.transaction_description%type;
610:
611: Begin
612: x_return_status := ECX_UTIL_API.G_NO_ERROR;
613: x_msg := null;

Line 654: ecx_transactions_api.retrieve_external_transaction(

650: return;
651: end if;
652: /* Bug #2183619, Added two additional input parameters for
653: External Type and Subtype */
654: ecx_transactions_api.retrieve_external_transaction(
655: p_transaction_type => p_transaction_type,
656: p_transaction_subtype => p_transaction_subtype,
657: p_party_type => p_party_type,
658: p_standard => p_standard_code,

Line 823: ecx_transactions tran

819: select 1 from ecx_tp_details
820: where tp_header_id = p_tp_header_id_in
821: and ext_process_id in ( select ext.ext_process_id
822: from ecx_ext_processes ext,
823: ecx_transactions tran
824: where ext.direction = 'OUT'
825: and ext.transaction_id
826: = tran.transaction_id
827: and tran.transaction_type

Line 838: from ecx_transactions et,ecx_ext_processes eep

834: where ext_process_id=p_ext_process_id_in;
835:
836: Cursor c9 (p_ext_process_id_in NUMBER) is
837: select transaction_type,transaction_subtype
838: from ecx_transactions et,ecx_ext_processes eep
839: where eep.ext_process_id = p_ext_process_id_in
840: and et.transaction_id = eep.transaction_id;
841:
842: /* End of changes for bug #2183619*/

Line 1328: i_transaction_description ecx_transactions_tl.transaction_description%type;

1324: i_company_admin_email varchar2(250);
1325: i_ext_process_id number;
1326: i_transaction_id number;
1327: i_standard_id number;
1328: i_transaction_description ecx_transactions_tl.transaction_description%type;
1329: i_ext_type ecx_ext_processes.ext_type%type;
1330: i_ext_subtype ecx_ext_processes.ext_subtype%type;
1331: i_queue_name ecx_ext_processes.queue_name%type;
1332:

Line 1379: ecx_transactions_api.retrieve_external_transaction(

1375:
1376:
1377: /* Bug #2183619, Added two additional input parameters for
1378: External Type and Subtype */
1379: ecx_transactions_api.retrieve_external_transaction(
1380: p_transaction_type => p_transaction_type,
1381: p_transaction_subtype => p_transaction_subtype,
1382: p_party_type => p_party_type,
1383: p_standard => p_standard_code,

Line 1499: ecx_transactions tran

1495: where tp_header_id = p_tp_header_id_in
1496: and tp_detail_id <> p_tp_detail_id_in
1497: and ext_process_id in ( select ext.ext_process_id
1498: from ecx_ext_processes ext,
1499: ecx_transactions tran
1500: where ext.direction = 'OUT'
1501: and ext.transaction_id
1502: = tran.transaction_id
1503: and tran.transaction_type

Line 1514: from ecx_transactions et,ecx_ext_processes eep

1510: where ext_process_id=p_ext_process_id_in;
1511:
1512: Cursor c9 (p_ext_process_id_in NUMBER) is
1513: select transaction_type,transaction_subtype
1514: from ecx_transactions et,ecx_ext_processes eep
1515: where eep.ext_process_id = p_ext_process_id_in
1516: and et.transaction_id = eep.transaction_id;
1517:
1518: Cursor c10 (p_tp_detail_id_in NUMBER) is