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 469: /** l_int_trans_id ecx_transactions.transaction_id%type;

465: delCounter number(4);
466: l_commitFlag boolean :=true;
467: l_runtimeonly boolean := false;
468:
469: /** l_int_trans_id ecx_transactions.transaction_id%type;
470: l_ext_trans_type ecx_ext_processes.ext_type%type;
471: l_ext_trans_subtype ecx_ext_processes.ext_subtype%type;
472:
473: cursor get_itrans is

Line 474: select transaction_id from ecx_transactions;

470: l_ext_trans_type ecx_ext_processes.ext_type%type;
471: l_ext_trans_subtype ecx_ext_processes.ext_subtype%type;
472:
473: cursor get_itrans is
474: select transaction_id from ecx_transactions;
475:
476: cursor get_ext_trans(p_trans_id in ecx_transactions.transaction_id%type) is
477: select ext_type, ext_subtype from ecx_ext_processes ecxextpc where ecxextpc.transaction_id = p_trans_id;
478:

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

472:
473: cursor get_itrans is
474: select transaction_id from ecx_transactions;
475:
476: cursor get_ext_trans(p_trans_id in ecx_transactions.transaction_id%type) is
477: select ext_type, ext_subtype from ecx_ext_processes ecxextpc where ecxextpc.transaction_id = p_trans_id;
478:
479: TYPE t_int_trans_id_tl is TABLE of ecx_transactions.transaction_id%type;
480: v_int_trans_id_tl t_int_trans_id_tl;**/

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

475:
476: cursor get_ext_trans(p_trans_id in ecx_transactions.transaction_id%type) is
477: select ext_type, ext_subtype from ecx_ext_processes ecxextpc where ecxextpc.transaction_id = p_trans_id;
478:
479: TYPE t_int_trans_id_tl is TABLE of ecx_transactions.transaction_id%type;
480: v_int_trans_id_tl t_int_trans_id_tl;**/
481:
482:
483: /**TYPE t_msg_id_tl is TABLE of ecx_doclogs.msgid%type;

Line 671: l_int_trans_id ecx_transactions.transaction_id%type;

667: todate in date default null,
668: docommit in boolean default true
669: ) IS
670:
671: l_int_trans_id ecx_transactions.transaction_id%type;
672: l_ext_trans_type ecx_ext_processes.ext_type%type;
673: l_ext_trans_subtype ecx_ext_processes.ext_subtype%type;
674:
675: cursor get_itrans_ts(p_int_trans_type ecx_transactions.transaction_type%type,

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

671: l_int_trans_id ecx_transactions.transaction_id%type;
672: l_ext_trans_type ecx_ext_processes.ext_type%type;
673: l_ext_trans_subtype ecx_ext_processes.ext_subtype%type;
674:
675: cursor get_itrans_ts(p_int_trans_type ecx_transactions.transaction_type%type,
676: p_int_trans_subtype in ecx_transactions.transaction_subtype%type) is
677: select transaction_id
678: from ecx_transactions
679: WHERE transaction_type = p_int_trans_type AND

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

672: l_ext_trans_type ecx_ext_processes.ext_type%type;
673: l_ext_trans_subtype ecx_ext_processes.ext_subtype%type;
674:
675: cursor get_itrans_ts(p_int_trans_type ecx_transactions.transaction_type%type,
676: p_int_trans_subtype in ecx_transactions.transaction_subtype%type) is
677: select transaction_id
678: from ecx_transactions
679: WHERE transaction_type = p_int_trans_type AND
680: transaction_subtype = p_int_trans_subtype;

Line 678: from ecx_transactions

674:
675: cursor get_itrans_ts(p_int_trans_type ecx_transactions.transaction_type%type,
676: p_int_trans_subtype in ecx_transactions.transaction_subtype%type) is
677: select transaction_id
678: from ecx_transactions
679: WHERE transaction_type = p_int_trans_type AND
680: transaction_subtype = p_int_trans_subtype;
681: cursor get_itrans_t(p_int_trans_type ecx_transactions.transaction_type%type) is
682: select transaction_id

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

677: select transaction_id
678: from ecx_transactions
679: WHERE transaction_type = p_int_trans_type AND
680: transaction_subtype = p_int_trans_subtype;
681: cursor get_itrans_t(p_int_trans_type ecx_transactions.transaction_type%type) is
682: select transaction_id
683: from ecx_transactions
684: WHERE transaction_type = p_int_trans_type;
685: cursor get_itrans_s(p_int_trans_subtype in ecx_transactions.transaction_subtype%type) is

Line 683: from ecx_transactions

679: WHERE transaction_type = p_int_trans_type AND
680: transaction_subtype = p_int_trans_subtype;
681: cursor get_itrans_t(p_int_trans_type ecx_transactions.transaction_type%type) is
682: select transaction_id
683: from ecx_transactions
684: WHERE transaction_type = p_int_trans_type;
685: cursor get_itrans_s(p_int_trans_subtype in ecx_transactions.transaction_subtype%type) is
686: select transaction_id
687: from ecx_transactions

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

681: cursor get_itrans_t(p_int_trans_type ecx_transactions.transaction_type%type) is
682: select transaction_id
683: from ecx_transactions
684: WHERE transaction_type = p_int_trans_type;
685: cursor get_itrans_s(p_int_trans_subtype in ecx_transactions.transaction_subtype%type) is
686: select transaction_id
687: from ecx_transactions
688: WHERE transaction_subtype = p_int_trans_subtype;
689: Cursor get_itrans is

Line 687: from ecx_transactions

683: from ecx_transactions
684: WHERE transaction_type = p_int_trans_type;
685: cursor get_itrans_s(p_int_trans_subtype in ecx_transactions.transaction_subtype%type) is
686: select transaction_id
687: from ecx_transactions
688: WHERE transaction_subtype = p_int_trans_subtype;
689: Cursor get_itrans is
690: select transaction_id from ecx_transactions;
691: cursor get_ext_trans(p_trans_id in ecx_transactions.transaction_id%type) is

Line 690: select transaction_id from ecx_transactions;

686: select transaction_id
687: from ecx_transactions
688: WHERE transaction_subtype = p_int_trans_subtype;
689: Cursor get_itrans is
690: select transaction_id from ecx_transactions;
691: cursor get_ext_trans(p_trans_id in ecx_transactions.transaction_id%type) is
692: select ext_type, ext_subtype from ecx_ext_processes ecxextpc where ecxextpc.transaction_id = p_trans_id;
693:
694: TYPE t_int_trans_id_tl is TABLE of ecx_transactions.transaction_id%type;

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

687: from ecx_transactions
688: WHERE transaction_subtype = p_int_trans_subtype;
689: Cursor get_itrans is
690: select transaction_id from ecx_transactions;
691: cursor get_ext_trans(p_trans_id in ecx_transactions.transaction_id%type) is
692: select ext_type, ext_subtype from ecx_ext_processes ecxextpc where ecxextpc.transaction_id = p_trans_id;
693:
694: TYPE t_int_trans_id_tl is TABLE of ecx_transactions.transaction_id%type;
695: v_int_trans_id_tl t_int_trans_id_tl;

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

690: select transaction_id from ecx_transactions;
691: cursor get_ext_trans(p_trans_id in ecx_transactions.transaction_id%type) is
692: select ext_type, ext_subtype from ecx_ext_processes ecxextpc where ecxextpc.transaction_id = p_trans_id;
693:
694: TYPE t_int_trans_id_tl is TABLE of ecx_transactions.transaction_id%type;
695: v_int_trans_id_tl t_int_trans_id_tl;
696:
697: BEGIN
698: if (transaction_type is not null and transaction_subtype is not null) then