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 STANDARD

Line 993: l_standard_code ecx_standards.standard_code%type;

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
997:

Line 994: l_standard_type ecx_standards.standard_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
997:
998:

Line 1020: l_standard_code := wf_engine.GetItemAttrText ( itemtype => itemtype,

1016: itemkey => itemkey,
1017: aname => 'ECX_PARTY_TYPE',
1018: ignore_notfound => true);
1019:
1020: l_standard_code := wf_engine.GetItemAttrText ( itemtype => itemtype,
1021: itemkey => itemkey,
1022: aname => 'ECX_MESSAGE_STANDARD',
1023: ignore_notfound => true);
1024: l_standard_type := wf_engine.GetItemAttrText ( itemtype => itemtype,

Line 1022: aname => 'ECX_MESSAGE_STANDARD',

1018: ignore_notfound => true);
1019:
1020: l_standard_code := wf_engine.GetItemAttrText ( itemtype => itemtype,
1021: itemkey => itemkey,
1022: aname => 'ECX_MESSAGE_STANDARD',
1023: ignore_notfound => true);
1024: l_standard_type := wf_engine.GetItemAttrText ( itemtype => itemtype,
1025: itemkey => itemkey,
1026: aname => 'ECX_MESSAGE_TYPE',

Line 1024: l_standard_type := wf_engine.GetItemAttrText ( itemtype => itemtype,

1020: l_standard_code := wf_engine.GetItemAttrText ( itemtype => itemtype,
1021: itemkey => itemkey,
1022: aname => 'ECX_MESSAGE_STANDARD',
1023: ignore_notfound => true);
1024: l_standard_type := wf_engine.GetItemAttrText ( itemtype => itemtype,
1025: itemkey => itemkey,
1026: aname => 'ECX_MESSAGE_TYPE',
1027: ignore_notfound => true);
1028: l_party_site_id := wf_engine.GetItemAttrText(

Line 1038: ecx_standards es,

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,
1038: ecx_standards es,
1039: ecx_tp_details etd,
1040: ecx_tp_headers eth,
1041: ecx_transactions et,
1042: fnd_user usr

Line 1045: and eep.standard_id = es.standard_id

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
1046: and es.standard_code = l_standard_code
1047: and es.standard_type = nvl(l_standard_type,'XML')
1048: and et.transaction_id = eep.transaction_id
1049: and etd.ext_process_id = eep.ext_process_id

Line 1046: and es.standard_code = l_standard_code

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
1046: and es.standard_code = l_standard_code
1047: and es.standard_type = nvl(l_standard_type,'XML')
1048: and et.transaction_id = eep.transaction_id
1049: and etd.ext_process_id = eep.ext_process_id
1050: and eth.party_site_id = l_party_site_id

Line 1047: and es.standard_type = nvl(l_standard_type,'XML')

1043: where eep.ext_type = l_transaction_type
1044: and eep.ext_subtype = l_transaction_subtype
1045: and eep.standard_id = es.standard_id
1046: and es.standard_code = l_standard_code
1047: and es.standard_type = nvl(l_standard_type,'XML')
1048: and et.transaction_id = eep.transaction_id
1049: and etd.ext_process_id = eep.ext_process_id
1050: and eth.party_site_id = l_party_site_id
1051: and (eth.party_type = l_party_type or l_party_type is null)