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_DOCUMENT dependencies on STANDARD

Line 97: ecx_standards es,

93: i_party_site_id,
94: i_confirmation
95: from ecx_ext_processes eep,
96: ecx_transactions et,
97: ecx_standards es,
98: ecx_tp_headers eth,
99: ecx_tp_details etd
100: where et.transaction_type = p_transaction_type
101: and et.transaction_subtype = p_transaction_subtype

Line 105: and eep.standard_id = es.standard_id

101: and et.transaction_subtype = p_transaction_subtype
102: and (p_party_type is null or eth.party_type = p_party_type)
103: and eep.transaction_id = et.transaction_id
104: and eep.direction = 'OUT'
105: and eep.standard_id = es.standard_id
106: and es.standard_code = 'OAG'
107: and etd.source_tp_location_code = i_location_code
108: and etd.tp_header_id = eth.tp_header_id
109: and etd.ext_process_id = eep.ext_process_id;

Line 106: and es.standard_code = 'OAG'

102: and (p_party_type is null or eth.party_type = p_party_type)
103: and eep.transaction_id = et.transaction_id
104: and eep.direction = 'OUT'
105: and eep.standard_id = es.standard_id
106: and es.standard_code = 'OAG'
107: and etd.source_tp_location_code = i_location_code
108: and etd.tp_header_id = eth.tp_header_id
109: and etd.ext_process_id = eep.ext_process_id;
110: --and rownum < 2;

Line 167: p_message_standard in varchar2,

163: p_transaction_subtype in varchar2,
164: p_document_id in varchar2,
165: p_map_code in varchar2,
166: p_message_type in varchar2,
167: p_message_standard in varchar2,
168: p_party_id in varchar2,
169: p_party_site_id in varchar2,
170: p_party_type in varchar2,
171: p_ext_type in varchar2,

Line 210: ecx_debug.log(l_statement,'p_message_standard',p_message_standard,i_method_name);

206: ecx_debug.log(l_statement,'p_transaction_subtype',p_transaction_subtype,i_method_name);
207: ecx_debug.log(l_statement,'p_document_id',p_document_id,i_method_name);
208: ecx_debug.log(l_statement,'p_map_code',p_map_code,i_method_name);
209: ecx_debug.log(l_statement,'p_message_type',p_message_type,i_method_name);
210: ecx_debug.log(l_statement,'p_message_standard',p_message_standard,i_method_name);
211: ecx_debug.log(l_statement,'p_party_id',p_party_id,i_method_name);
212: ecx_debug.log(l_statement,'p_party_site_id',p_party_site_id,i_method_name);
213: ecx_debug.log(l_statement,'p_party_type',p_party_type,i_method_name);
214: ecx_debug.log(l_statement,'p_ext_type',p_ext_type,i_method_name);

Line 240: p_message_standard,

236: p_transaction_subtype,
237: p_document_id,
238: p_map_code,
239: p_message_type,
240: p_message_standard,
241: p_party_id,
242: p_party_site_id,
243: p_party_type,
244: p_ext_type,

Line 294: i_standard_type OUT NOCOPY varchar2,

290: i_transaction_subtype IN varchar2,
291: i_party_id IN varchar2,
292: i_party_site_id IN varchar2,
293: i_party_type IN OUT NOCOPY varchar2,--bug #2183619
294: i_standard_type OUT NOCOPY varchar2,
295: i_standard_code OUT NOCOPY varchar2,
296: i_ext_type OUT NOCOPY varchar2,
297: i_ext_subtype OUT NOCOPY varchar2,
298: i_source_code OUT NOCOPY varchar2,

Line 295: i_standard_code OUT NOCOPY varchar2,

291: i_party_id IN varchar2,
292: i_party_site_id IN varchar2,
293: i_party_type IN OUT NOCOPY varchar2,--bug #2183619
294: i_standard_type OUT NOCOPY varchar2,
295: i_standard_code OUT NOCOPY varchar2,
296: i_ext_type OUT NOCOPY varchar2,
297: i_ext_subtype OUT NOCOPY varchar2,
298: i_source_code OUT NOCOPY varchar2,
299: i_destination_code OUT NOCOPY varchar2,

Line 357: select es.standard_type standard_type,

353: raise ecx_transaction_not_defined;
354: End;
355: begin
356: -- Added check for party type for bug #2183619
357: select es.standard_type standard_type,
358: es.standard_code standard_code,
359: source_tp_location_code source,
360: external_tp_location_code destination,
361: protocol_type,

Line 358: es.standard_code standard_code,

354: End;
355: begin
356: -- Added check for party type for bug #2183619
357: select es.standard_type standard_type,
358: es.standard_code standard_code,
359: source_tp_location_code source,
360: external_tp_location_code destination,
361: protocol_type,
362: protocol_address,

Line 375: into i_standard_type,

371: eep.ext_subtype ext_subtype,
372: eth.party_type party_type,
373: eth.tp_header_id tp_header_id,
374: etd.tp_detail_id
375: into i_standard_type,
376: i_standard_code,
377: i_source_code,
378: i_destination_code,
379: i_destination_type,

Line 376: i_standard_code,

372: eth.party_type party_type,
373: eth.tp_header_id tp_header_id,
374: etd.tp_detail_id
375: into i_standard_type,
376: i_standard_code,
377: i_source_code,
378: i_destination_code,
379: i_destination_type,
380: i_destination_address,

Line 397: ecx_standards es,

393: from ecx_tp_details etd,
394: ecx_tp_headers eth,
395: ecx_ext_processes eep,
396: ecx_transactions et,
397: ecx_standards es,
398: ecx_mappings em
399: where ( eth.party_id = i_party_id or i_party_id is null )
400: and eth.party_site_id = i_party_site_id
401: and eth.party_type = et.party_type

Line 407: and es.standard_id = eep.standard_id

403: and et.transaction_type = i_transaction_type
404: and et.transaction_subtype = i_transaction_subtype
405: and (i_party_type is null or et.party_type = i_party_type)
406: and et.transaction_id = eep.transaction_id
407: and es.standard_id = eep.standard_id
408: and eep.ext_process_id = etd.ext_process_id
409: and eep.direction = 'OUT'
410: and em.map_id = etd.map_id;
411: exception

Line 470: ecx_debug.log(l_statement,'i_standard_type',i_standard_type,i_method_name);

466: end if;
467:
468: if(l_statementEnabled) then
469: ecx_debug.log(l_statement,'i_party_type',i_party_type,i_method_name);
470: ecx_debug.log(l_statement,'i_standard_type',i_standard_type,i_method_name);
471: ecx_debug.log(l_statement,'i_standard_code',i_standard_code,i_method_name);
472: ecx_debug.log(l_statement,'i_ext_type',i_ext_type,i_method_name);
473: ecx_debug.log(l_statement,'i_ext_subtype',i_ext_subtype,i_method_name);
474: ecx_debug.log(l_statement,'i_source_code',i_source_code,i_method_name);

Line 471: ecx_debug.log(l_statement,'i_standard_code',i_standard_code,i_method_name);

467:
468: if(l_statementEnabled) then
469: ecx_debug.log(l_statement,'i_party_type',i_party_type,i_method_name);
470: ecx_debug.log(l_statement,'i_standard_type',i_standard_type,i_method_name);
471: ecx_debug.log(l_statement,'i_standard_code',i_standard_code,i_method_name);
472: ecx_debug.log(l_statement,'i_ext_type',i_ext_type,i_method_name);
473: ecx_debug.log(l_statement,'i_ext_subtype',i_ext_subtype,i_method_name);
474: ecx_debug.log(l_statement,'i_source_code',i_source_code,i_method_name);
475: ecx_debug.log(l_statement,'i_destination_code',i_destination_code,i_method_name);

Line 604: p_message_standard OUT NOCOPY varchar2,

600: p_party_type IN OUT NOCOPY varchar2,
601: p_party_id OUT NOCOPY varchar2,
602: p_party_site_id OUT NOCOPY varchar2,
603: p_message_type OUT NOCOPY varchar2,
604: p_message_standard OUT NOCOPY varchar2,
605: p_ext_type OUT NOCOPY varchar2,
606: p_ext_subtype OUT NOCOPY varchar2,
607: p_source_code OUT NOCOPY varchar2,
608: p_destination_code OUT NOCOPY varchar2,

Line 658: p_message_standard,

654: p_party_id,
655: p_party_site_id,
656: p_party_type,
657: p_message_type,
658: p_message_standard,
659: p_ext_type,
660: p_ext_subtype,
661: p_source_code,
662: p_destination_code,

Line 733: p_message_standard varchar2(200);

729: i_path varchar2(80);
730: v_message system.ecx_outengobj;
731:
732: p_message_type varchar2(200);
733: p_message_standard varchar2(200);
734: p_ext_type varchar2(200);
735: p_ext_subtype varchar2(200);
736: p_destination_type varchar2(200);
737: p_destination_address ecx_tp_details.protocol_address%TYPE;

Line 865: p_message_standard, p_ext_type, p_ext_subtype, p_source_code,

861: party_id, party_site_id,
862: document_id, ecx_utils.i_ret_code,
863: ecx_utils.i_errbuf, trigger_id,
864: p_party_type, p_party_id, p_party_site_id, p_message_type,
865: p_message_standard, p_ext_type, p_ext_subtype, p_source_code,
866: p_destination_code, p_destination_type, p_destination_address,
867: p_username, p_password, p_map_code,
868: p_queue_name, ecx_utils.g_rec_tp_id);
869:

Line 895: p_message_standard,

891: transaction_subtype,
892: document_id,
893: p_map_code,
894: p_message_type,
895: p_message_standard,
896: p_party_id,
897: p_party_site_id,
898: p_party_type,
899: p_ext_type,

Line 1067: p_message_standard varchar2(200);

1063: i_path varchar2(80);
1064: v_message system.ecx_outengobj;
1065:
1066: p_message_type varchar2(200);
1067: p_message_standard varchar2(200);
1068: p_ext_type varchar2(200);
1069: p_ext_subtype varchar2(200);
1070: p_destination_type varchar2(200);
1071: p_username ecx_tp_details.username%TYPE;

Line 1218: p_message_standard, p_ext_type, p_ext_subtype, p_source_code,

1214: party_id, party_site_id,
1215: document_id, ecx_utils.i_ret_code,
1216: ecx_utils.i_errbuf, trigger_id,
1217: p_party_type, p_party_id, p_party_site_id, p_message_type,
1218: p_message_standard, p_ext_type, p_ext_subtype, p_source_code,
1219: p_destination_code, p_destination_type, p_destination_address,
1220: p_username, p_password, p_map_code,
1221: p_queue_name, ecx_utils.g_rec_tp_id);
1222:

Line 1248: p_message_standard,

1244: p_party_type,
1245: document_id,
1246: p_map_code,
1247: p_message_type,
1248: p_message_standard,
1249: p_ext_type,
1250: p_ext_subtype,
1251: p_source_code,
1252: p_destination_type,

Line 1517: p_message_standard varchar2(200);

1513: errmsg OUT NOCOPY VARCHAR2
1514: )
1515: is
1516: p_message_type varchar2(200);
1517: p_message_standard varchar2(200);
1518: p_ext_type varchar2(200);
1519: p_ext_subtype varchar2(200);
1520: p_destination_type varchar2(200);
1521: p_username ecx_tp_details.username%TYPE;

Line 1541: p_message_standard,

1537: party_id,
1538: party_site_id,
1539: p_party_type,
1540: p_message_type,
1541: p_message_standard,
1542: p_ext_type,
1543: p_ext_subtype,
1544: p_source_code,
1545: p_destination_code,

Line 1630: p_message_standard varchar2(200);

1626: errmsg OUT NOCOPY VARCHAR2
1627: )
1628: is
1629: p_message_type varchar2(200);
1630: p_message_standard varchar2(200);
1631: p_destination_type varchar2(200);
1632: p_username ecx_tp_details.username%TYPE;
1633: p_password ecx_tp_details.password%TYPE;
1634: p_map_code varchar2(200);

Line 1649: p_message_standard,

1645: party_id,
1646: party_site_id,
1647: p_party_type,
1648: p_message_type,
1649: p_message_standard,
1650: ext_type,
1651: ext_subtype,
1652: source_code,
1653: destination_code,

Line 1707: standard_type OUT NOCOPY varchar2,

1703: transaction_subtype IN varchar2,
1704: party_id IN varchar2,
1705: party_site_id IN varchar2,
1706: party_type IN OUT NOCOPY varchar2, --bug #2183619
1707: standard_type OUT NOCOPY varchar2,
1708: standard_code OUT NOCOPY varchar2,
1709: ext_type OUT NOCOPY varchar2,
1710: ext_subtype OUT NOCOPY varchar2,
1711: source_code OUT NOCOPY varchar2,

Line 1708: standard_code OUT NOCOPY varchar2,

1704: party_id IN varchar2,
1705: party_site_id IN varchar2,
1706: party_type IN OUT NOCOPY varchar2, --bug #2183619
1707: standard_type OUT NOCOPY varchar2,
1708: standard_code OUT NOCOPY varchar2,
1709: ext_type OUT NOCOPY varchar2,
1710: ext_subtype OUT NOCOPY varchar2,
1711: source_code OUT NOCOPY varchar2,
1712: destination_code OUT NOCOPY varchar2,

Line 1732: standard_type,

1728: transaction_subtype,
1729: party_id,
1730: party_site_id,
1731: party_type,
1732: standard_type,
1733: standard_code,
1734: ext_type,
1735: ext_subtype,
1736: source_code,

Line 1733: standard_code,

1729: party_id,
1730: party_site_id,
1731: party_type,
1732: standard_type,
1733: standard_code,
1734: ext_type,
1735: ext_subtype,
1736: source_code,
1737: destination_code,

Line 1779: message_standard,

1775:
1776: Cursor c1(l_msgid in RAW) is
1777: Select msgid,
1778: message_type,
1779: message_standard,
1780: transaction_type,
1781: transaction_subtype,
1782: document_number,
1783: party_type,

Line 1807: p_message_standard in varchar2,

1803: (
1804: p_ext_type IN varchar2,
1805: p_ext_subtype IN varchar2,
1806: p_party_ext_code in varchar2,
1807: p_message_standard in varchar2,
1808: p_message_type in varchar2
1809: )
1810: is
1811: select etd.protocol_type,

Line 1820: ecx_standards es

1816: hub_id,
1817: hub_user_id
1818: from ecx_tp_details etd,
1819: ecx_ext_processes eep,
1820: ecx_standards es
1821: where etd.source_tp_location_code = p_party_ext_code
1822: and eep.ext_type = p_ext_type
1823: and eep.ext_subtype = p_ext_subtype
1824: and eep.ext_process_id = etd.ext_process_id

Line 1825: and eep.standard_id = es.standard_id

1821: where etd.source_tp_location_code = p_party_ext_code
1822: and eep.ext_type = p_ext_type
1823: and eep.ext_subtype = p_ext_subtype
1824: and eep.ext_process_id = etd.ext_process_id
1825: and eep.standard_id = es.standard_id
1826: and es.standard_code = p_message_standard
1827: and es.standard_type = nvl(p_message_type, 'XML')
1828: and eep.direction = 'OUT';
1829:

Line 1826: and es.standard_code = p_message_standard

1822: and eep.ext_type = p_ext_type
1823: and eep.ext_subtype = p_ext_subtype
1824: and eep.ext_process_id = etd.ext_process_id
1825: and eep.standard_id = es.standard_id
1826: and es.standard_code = p_message_standard
1827: and es.standard_type = nvl(p_message_type, 'XML')
1828: and eep.direction = 'OUT';
1829:
1830: c1_rec c1%ROWTYPE;

Line 1827: and es.standard_type = nvl(p_message_type, 'XML')

1823: and eep.ext_subtype = p_ext_subtype
1824: and eep.ext_process_id = etd.ext_process_id
1825: and eep.standard_id = es.standard_id
1826: and es.standard_code = p_message_standard
1827: and es.standard_type = nvl(p_message_type, 'XML')
1828: and eep.direction = 'OUT';
1829:
1830: c1_rec c1%ROWTYPE;
1831:

Line 1891: c1_rec.message_standard,

1887: (
1888: c1_rec.transaction_type,
1889: c1_rec.transaction_subtype,
1890: c1_rec.party_site_id,
1891: c1_rec.message_standard,
1892: c1_rec.message_type
1893: );
1894:
1895: fetch c_tp_details into

Line 1950: i_event.addParameterToList('MESSAGE_STANDARD', c1_rec.message_standard);

1946: wf_event_t.initialize(i_event);
1947: i_event.addParameterToList('RESEND', 'Y');
1948: i_event.addParameterToList('ECX_MSG_ID', c1_rec.msgid);
1949: i_event.addParameterToList('MESSAGE_TYPE', c1_rec.message_type);
1950: i_event.addParameterToList('MESSAGE_STANDARD', c1_rec.message_standard);
1951: i_event.addParameterToList('TRANSACTION_TYPE', c1_rec.transaction_type);
1952: i_event.addParameterToList('TRANSACTION_SUBTYPE', c1_rec.transaction_subtype);
1953: i_event.addParameterToList('DOCUMENT_NUMBER', c1_rec.document_number);
1954: i_event.addParameterToList('PARTY_TYPE', c1_rec.party_type);

Line 2060: ecx_standards es,

2056: from ecx_tp_details etd,
2057: ecx_tp_headers eth,
2058: ecx_ext_processes eep,
2059: ecx_transactions et,
2060: ecx_standards es,
2061: ecx_mappings em
2062: where ( eth.party_id = i_party_id or i_party_id is null )
2063: and eth.party_site_id = i_party_site_id
2064: and eth.party_type = et.party_type

Line 2070: and es.standard_id = eep.standard_id

2066: and et.transaction_type = i_transaction_type
2067: and et.transaction_subtype = i_transaction_subtype
2068: and (i_party_type is null or et.party_type = i_party_type)
2069: and et.transaction_id = eep.transaction_id
2070: and es.standard_id = eep.standard_id
2071: and eep.ext_process_id = etd.ext_process_id
2072: and eep.direction = 'OUT'
2073: and em.map_id = etd.map_id;
2074: