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_EXT_PROCESSES

Line 470: l_ext_trans_type ecx_ext_processes.ext_type%type;

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
474: select transaction_id from ecx_transactions;

Line 471: l_ext_trans_subtype ecx_ext_processes.ext_subtype%type;

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
474: select transaction_id from ecx_transactions;
475:

Line 477: select ext_type, ext_subtype from ecx_ext_processes ecxextpc where ecxextpc.transaction_id = p_trans_id;

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;**/
481:

Line 672: l_ext_trans_type ecx_ext_processes.ext_type%type;

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,
676: p_int_trans_subtype in ecx_transactions.transaction_subtype%type) is

Line 673: l_ext_trans_subtype ecx_ext_processes.ext_subtype%type;

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,
676: p_int_trans_subtype in ecx_transactions.transaction_subtype%type) is
677: select transaction_id

Line 692: select ext_type, ext_subtype from ecx_ext_processes ecxextpc where ecxextpc.transaction_id = p_trans_id;

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