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_WF_ERRORS dependencies on ECX_TRANSACTIONS

Line 989: l_transaction_type ecx_transactions.transaction_type%type;

985: i_wf_email_address varchar2(200);
986: i_wf_display_name varchar2(200);
987: i_email_addr varchar2(200);
988: l_params wf_parameter_list_t;
989: l_transaction_type ecx_transactions.transaction_type%type;
990: l_transaction_subtype ecx_transactions.transaction_subtype%type;
991: l_party_type ecx_transactions.party_type%type;
992: i_transaction_id ecx_transactions.transaction_id%type;
993: l_standard_code ecx_standards.standard_code%type;

Line 990: l_transaction_subtype ecx_transactions.transaction_subtype%type;

986: i_wf_display_name varchar2(200);
987: i_email_addr varchar2(200);
988: l_params wf_parameter_list_t;
989: l_transaction_type ecx_transactions.transaction_type%type;
990: l_transaction_subtype ecx_transactions.transaction_subtype%type;
991: l_party_type ecx_transactions.party_type%type;
992: i_transaction_id ecx_transactions.transaction_id%type;
993: l_standard_code ecx_standards.standard_code%type;
994: l_standard_type ecx_standards.standard_type%type;

Line 991: l_party_type ecx_transactions.party_type%type;

987: i_email_addr varchar2(200);
988: l_params wf_parameter_list_t;
989: l_transaction_type ecx_transactions.transaction_type%type;
990: l_transaction_subtype ecx_transactions.transaction_subtype%type;
991: l_party_type ecx_transactions.party_type%type;
992: i_transaction_id ecx_transactions.transaction_id%type;
993: l_standard_code ecx_standards.standard_code%type;
994: l_standard_type ecx_standards.standard_type%type;
995: l_party_site_id ecx_tp_details.source_tp_location_code%type;

Line 992: i_transaction_id ecx_transactions.transaction_id%type;

988: l_params wf_parameter_list_t;
989: l_transaction_type ecx_transactions.transaction_type%type;
990: l_transaction_subtype ecx_transactions.transaction_subtype%type;
991: l_party_type ecx_transactions.party_type%type;
992: i_transaction_id ecx_transactions.transaction_id%type;
993: l_standard_code ecx_standards.standard_code%type;
994: l_standard_type ecx_standards.standard_type%type;
995: l_party_site_id ecx_tp_details.source_tp_location_code%type;
996: Begin

Line 1033: /Get transaction owner email from ecx_transactions from the userid/

1029: itemtype => itemtype,
1030: itemkey => itemkey,
1031: aname => 'ECX_PARTY_SITE_ID');
1032:
1033: /**Get transaction owner email from ecx_transactions from the userid**/
1034: begin
1035: select distinct et.transaction_id,usr.email_address
1036: into i_transaction_id,i_email_addr
1037: from ecx_ext_processes eep,

Line 1041: ecx_transactions et,

1037: from ecx_ext_processes eep,
1038: ecx_standards es,
1039: ecx_tp_details etd,
1040: ecx_tp_headers eth,
1041: ecx_transactions et,
1042: fnd_user usr
1043: where eep.ext_type = l_transaction_type
1044: and eep.ext_subtype = l_transaction_subtype
1045: and eep.standard_id = es.standard_id