APPS.ECX_TP_API dependencies on ECX_EXT_PROCESSES

Line 608: x_queue_name ecx_ext_processes.queue_name%type;

604:
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;

Line 790: select 1,direction from ecx_ext_processes

786: select 1 from ecx_tp_headers
787: where tp_header_id = p_tp_header_id;
788:
789: Cursor c2 Is
790: select 1,direction from ecx_ext_processes
791: where ext_process_id = p_ext_process_id;
792:
793: Cursor c3 Is
794: select map_id from ecx_mappings

Line 809: Select 1 from ecx_tp_details tp,ecx_ext_processes ep

805: /* Start changes for bug #2183619 */
806: Cursor c6(p_ext_type_in VARCHAR2,p_ext_subtype_in VARCHAR2,
807: p_standard_id_in NUMBER,p_direction_in VARCHAR2,
808: p_source_tp_location_code_in VARCHAR2) Is
809: Select 1 from ecx_tp_details tp,ecx_ext_processes ep
810: where tp.ext_process_id=ep.ext_process_id
811: And ep.ext_type = p_ext_type_in
812: And ep.ext_subtype = p_ext_subtype_in
813: And ep.standard_id = p_standard_id_in

Line 822: from ecx_ext_processes ext,

818: p_transaction_subtype_in VARCHAR2) is
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

Line 833: from ecx_ext_processes

829: and tran.transaction_subtype
830: = p_transaction_subtype_in );
831: Cursor c8(p_ext_process_id_in NUMBER) is
832: select ext_type,ext_subtype,standard_id,direction
833: from ecx_ext_processes
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

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 857: i_direction ecx_ext_processes.direction%type;

853:
854: num number := 0;
855: i_map_id number:=0;
856: encrypt_password ecx_tp_details.password%type;
857: i_direction ecx_ext_processes.direction%type;
858:
859: /* Added declartions for Bug #2183619 */
860: p_ext_type varchar2(80);
861: p_ext_subtype varchar2(80);

Line 1329: i_ext_type ecx_ext_processes.ext_type%type;

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:
1333: begin

Line 1330: i_ext_subtype ecx_ext_processes.ext_subtype%type;

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:
1333: begin
1334: x_return_status := ECX_UTIL_API.G_NO_ERROR;

Line 1331: i_queue_name ecx_ext_processes.queue_name%type;

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:
1333: begin
1334: x_return_status := ECX_UTIL_API.G_NO_ERROR;
1335: x_msg := null;

Line 1462: select direction from ecx_ext_processes

1458: select map_id from ecx_mappings
1459: where map_code = p_map_code;
1460:
1461: cursor c2 is
1462: select direction from ecx_ext_processes
1463: where ext_process_id = p_ext_process_id;
1464:
1465: cursor c3 is
1466: select 1 from ecx_tp_details

Line 1482: Select tp_detail_id from ecx_tp_details tp,ecx_ext_processes ep

1478: Cursor c6(p_ext_type_in VARCHAR2,p_ext_subtype_in VARCHAR2,
1479: p_standard_id_in NUMBER,p_direction_in VARCHAR2,
1480: p_source_tp_location_code_in VARCHAR2,
1481: p_tp_detail_id_in NUMBER) Is
1482: Select tp_detail_id from ecx_tp_details tp,ecx_ext_processes ep
1483: where tp.ext_process_id=ep.ext_process_id
1484: And ep.ext_type = p_ext_type_in
1485: And ep.ext_subtype = p_ext_subtype_in
1486: And ep.standard_id = p_standard_id_in

Line 1498: from ecx_ext_processes ext,

1494: select 1 from ecx_tp_details
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

Line 1509: from ecx_ext_processes

1505: and tran.transaction_subtype
1506: = p_transaction_subtype_in );
1507: Cursor c8(p_ext_process_id_in NUMBER) is
1508: select ext_type,ext_subtype,standard_id,direction
1509: from ecx_ext_processes
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

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