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 455: l_ext_trans_type ecx_ext_processes.ext_type%type;

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

Line 456: l_ext_trans_subtype ecx_ext_processes.ext_subtype%type;

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

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

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

Line 657: l_ext_trans_type ecx_ext_processes.ext_type%type;

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

Line 658: l_ext_trans_subtype ecx_ext_processes.ext_subtype%type;

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

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

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