eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ECX_PURGE dependencies on ECX_TRANSACTIONS

Line 454: /** l_int_trans_id ecx_transactions.transaction_id%type;

450: delCounter number(4);
451: l_commitFlag boolean :=true;
452: l_runtimeonly boolean := false;
453:
454: /** l_int_trans_id ecx_transactions.transaction_id%type;
455: l_ext_trans_type ecx_ext_processes.ext_type%type;
456: l_ext_trans_subtype ecx_ext_processes.ext_subtype%type;
457:
458: cursor get_itrans is

Line 459: select transaction_id from ecx_transactions;

455: l_ext_trans_type ecx_ext_processes.ext_type%type;
456: l_ext_trans_subtype ecx_ext_processes.ext_subtype%type;
457:
458: cursor get_itrans is
459: select transaction_id from ecx_transactions;
460:
461: cursor get_ext_trans(p_trans_id in ecx_transactions.transaction_id%type) is
462: select ext_type, ext_subtype from ecx_ext_processes ecxextpc where ecxextpc.transaction_id = p_trans_id;
463:

Line 461: cursor get_ext_trans(p_trans_id in ecx_transactions.transaction_id%type) is

457:
458: cursor get_itrans is
459: select transaction_id from ecx_transactions;
460:
461: cursor get_ext_trans(p_trans_id in ecx_transactions.transaction_id%type) is
462: select ext_type, ext_subtype from ecx_ext_processes ecxextpc where ecxextpc.transaction_id = p_trans_id;
463:
464: TYPE t_int_trans_id_tl is TABLE of ecx_transactions.transaction_id%type;
465: v_int_trans_id_tl t_int_trans_id_tl;**/

Line 464: TYPE t_int_trans_id_tl is TABLE of ecx_transactions.transaction_id%type;

460:
461: cursor get_ext_trans(p_trans_id in ecx_transactions.transaction_id%type) is
462: select ext_type, ext_subtype from ecx_ext_processes ecxextpc where ecxextpc.transaction_id = p_trans_id;
463:
464: TYPE t_int_trans_id_tl is TABLE of ecx_transactions.transaction_id%type;
465: v_int_trans_id_tl t_int_trans_id_tl;**/
466:
467:
468: /**TYPE t_msg_id_tl is TABLE of ecx_doclogs.msgid%type;

Line 656: l_int_trans_id ecx_transactions.transaction_id%type;

652: todate in date default null,
653: docommit in boolean default true
654: ) IS
655:
656: l_int_trans_id ecx_transactions.transaction_id%type;
657: l_ext_trans_type ecx_ext_processes.ext_type%type;
658: l_ext_trans_subtype ecx_ext_processes.ext_subtype%type;
659:
660: cursor get_itrans_ts(p_int_trans_type ecx_transactions.transaction_type%type,

Line 660: cursor get_itrans_ts(p_int_trans_type ecx_transactions.transaction_type%type,

656: l_int_trans_id ecx_transactions.transaction_id%type;
657: l_ext_trans_type ecx_ext_processes.ext_type%type;
658: l_ext_trans_subtype ecx_ext_processes.ext_subtype%type;
659:
660: cursor get_itrans_ts(p_int_trans_type ecx_transactions.transaction_type%type,
661: p_int_trans_subtype in ecx_transactions.transaction_subtype%type) is
662: select transaction_id
663: from ecx_transactions
664: WHERE transaction_type = p_int_trans_type AND

Line 661: p_int_trans_subtype in ecx_transactions.transaction_subtype%type) is

657: l_ext_trans_type ecx_ext_processes.ext_type%type;
658: l_ext_trans_subtype ecx_ext_processes.ext_subtype%type;
659:
660: cursor get_itrans_ts(p_int_trans_type ecx_transactions.transaction_type%type,
661: p_int_trans_subtype in ecx_transactions.transaction_subtype%type) is
662: select transaction_id
663: from ecx_transactions
664: WHERE transaction_type = p_int_trans_type AND
665: transaction_subtype = p_int_trans_subtype;

Line 663: from ecx_transactions

659:
660: cursor get_itrans_ts(p_int_trans_type ecx_transactions.transaction_type%type,
661: p_int_trans_subtype in ecx_transactions.transaction_subtype%type) is
662: select transaction_id
663: from ecx_transactions
664: WHERE transaction_type = p_int_trans_type AND
665: transaction_subtype = p_int_trans_subtype;
666: cursor get_itrans_t(p_int_trans_type ecx_transactions.transaction_type%type) is
667: select transaction_id

Line 666: cursor get_itrans_t(p_int_trans_type ecx_transactions.transaction_type%type) is

662: select transaction_id
663: from ecx_transactions
664: WHERE transaction_type = p_int_trans_type AND
665: transaction_subtype = p_int_trans_subtype;
666: cursor get_itrans_t(p_int_trans_type ecx_transactions.transaction_type%type) is
667: select transaction_id
668: from ecx_transactions
669: WHERE transaction_type = p_int_trans_type;
670: cursor get_itrans_s(p_int_trans_subtype in ecx_transactions.transaction_subtype%type) is

Line 668: from ecx_transactions

664: WHERE transaction_type = p_int_trans_type AND
665: transaction_subtype = p_int_trans_subtype;
666: cursor get_itrans_t(p_int_trans_type ecx_transactions.transaction_type%type) is
667: select transaction_id
668: from ecx_transactions
669: WHERE transaction_type = p_int_trans_type;
670: cursor get_itrans_s(p_int_trans_subtype in ecx_transactions.transaction_subtype%type) is
671: select transaction_id
672: from ecx_transactions

Line 670: cursor get_itrans_s(p_int_trans_subtype in ecx_transactions.transaction_subtype%type) is

666: cursor get_itrans_t(p_int_trans_type ecx_transactions.transaction_type%type) is
667: select transaction_id
668: from ecx_transactions
669: WHERE transaction_type = p_int_trans_type;
670: cursor get_itrans_s(p_int_trans_subtype in ecx_transactions.transaction_subtype%type) is
671: select transaction_id
672: from ecx_transactions
673: WHERE transaction_subtype = p_int_trans_subtype;
674: Cursor get_itrans is

Line 672: from ecx_transactions

668: from ecx_transactions
669: WHERE transaction_type = p_int_trans_type;
670: cursor get_itrans_s(p_int_trans_subtype in ecx_transactions.transaction_subtype%type) is
671: select transaction_id
672: from ecx_transactions
673: WHERE transaction_subtype = p_int_trans_subtype;
674: Cursor get_itrans is
675: select transaction_id from ecx_transactions;
676: cursor get_ext_trans(p_trans_id in ecx_transactions.transaction_id%type) is

Line 675: select transaction_id from ecx_transactions;

671: select transaction_id
672: from ecx_transactions
673: WHERE transaction_subtype = p_int_trans_subtype;
674: Cursor get_itrans is
675: select transaction_id from ecx_transactions;
676: cursor get_ext_trans(p_trans_id in ecx_transactions.transaction_id%type) is
677: select ext_type, ext_subtype from ecx_ext_processes ecxextpc where ecxextpc.transaction_id = p_trans_id;
678:
679: TYPE t_int_trans_id_tl is TABLE of ecx_transactions.transaction_id%type;

Line 676: cursor get_ext_trans(p_trans_id in ecx_transactions.transaction_id%type) is

672: from ecx_transactions
673: WHERE transaction_subtype = p_int_trans_subtype;
674: Cursor get_itrans is
675: select transaction_id from ecx_transactions;
676: cursor get_ext_trans(p_trans_id in ecx_transactions.transaction_id%type) is
677: select ext_type, ext_subtype from ecx_ext_processes ecxextpc where ecxextpc.transaction_id = p_trans_id;
678:
679: TYPE t_int_trans_id_tl is TABLE of ecx_transactions.transaction_id%type;
680: v_int_trans_id_tl t_int_trans_id_tl;

Line 679: TYPE t_int_trans_id_tl is TABLE of ecx_transactions.transaction_id%type;

675: select transaction_id from ecx_transactions;
676: cursor get_ext_trans(p_trans_id in ecx_transactions.transaction_id%type) is
677: select ext_type, ext_subtype from ecx_ext_processes ecxextpc where ecxextpc.transaction_id = p_trans_id;
678:
679: TYPE t_int_trans_id_tl is TABLE of ecx_transactions.transaction_id%type;
680: v_int_trans_id_tl t_int_trans_id_tl;
681:
682: BEGIN
683: if (transaction_type is not null and transaction_subtype is not null) then