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.EGO_PUBLICATION_PKG dependencies on XMLTYPE

Line 8: x_doc OUT NOCOPY xmltype,

4: PROCEDURE getUDAAttributes
5: (
6: extension_id IN NUMBER,
7: p_language IN VARCHAR2,
8: x_doc OUT NOCOPY xmltype,
9: x_error_message OUT NOCOPY VARCHAR2
10: )
11: IS
12:

Line 17: x_temp xmltype;

13: -- language_clause varchar2(2000);
14: ext_id NUMBER;
15: x_query varchar2(4000);
16: no_extId_exception EXCEPTION;
17: x_temp xmltype;
18:
19: CURSOR C1(p_ext_id NUMBER,p_lang VARCHAR2) IS
20: Select xmlElement("Attribute",xmlElement("Id",attribute_id),
21: xmlElement("Name",attribute_name),

Line 155: x_doc OUT NOCOPY XMLTYPE,

151: PROCEDURE getItemIdentification
152: (
153: inventory_item_id IN NUMBER,
154: organization_id IN NUMBER,
155: x_doc OUT NOCOPY XMLTYPE,
156: x_error_message OUT NOCOPY VARCHAR2
157: )
158:
159: IS

Line 174: x_temp xmltype;

170:
171: itemId number;
172: orgId number;
173: orgIdStr varchar2(2000);
174: x_temp xmltype;
175: x_query varchar2(2000);
176: no_pk_exception EXCEPTION;
177:
178: BEGIN

Line 226: x_doc OUT NOCOPY XMLTYPE,

222: (
223: inventory_item_id IN NUMBER,
224: organization_id IN NUMBER,
225: p_language IN VARCHAR2,
226: x_doc OUT NOCOPY XMLTYPE,
227: x_error_message OUT NOCOPY VARCHAR2
228: )
229: IS
230:

Line 233: x_temp xmltype;

229: IS
230:
231: itemId NUMBER;
232: orgId NUMBER;
233: x_temp xmltype;
234: no_pk_exception EXCEPTION;
235: lifecycle varchar2(2000);
236: lifecycle_phase varchar2(2000);
237: -- language_clause varchar2(2000);

Line 360: x_doc OUT NOCOPY xmltype,

356: inventory_item_id IN NUMBER,
357: organization_id IN NUMBER,
358: extension_id IN NUMBER,
359: p_language IN VARCHAR2,
360: x_doc OUT NOCOPY xmltype,
361: x_error_message OUT NOCOPY VARCHAR2
362: )
363: IS
364:

Line 365: x_temp xmltype;

361: x_error_message OUT NOCOPY VARCHAR2
362: )
363: IS
364:
365: x_temp xmltype;
366: itemId number;
367: orgId number;
368: x_uda xmltype;
369: no_pk_exception EXCEPTION;

Line 368: x_uda xmltype;

364:
365: x_temp xmltype;
366: itemId number;
367: orgId number;
368: x_uda xmltype;
369: no_pk_exception EXCEPTION;
370:
371:
372:

Line 464: x_doc OUT NOCOPY XMLTYPE,

460: PROCEDURE getCategoryAttributes
461: (
462: category_id IN NUMBER,
463: getFlexAttributesFlag IN CHAR,
464: x_doc OUT NOCOPY XMLTYPE,
465: x_error_message OUT NOCOPY VARCHAR2
466: )
467:
468: IS

Line 495: x_prim xmltype;

491: ----------------- ---------------------------------------
492: ----------------- --------------------
493:
494: catId number;
495: x_prim xmltype;
496: x_desc xmltype;
497: x_temp xmltype;
498: -- language_clause varchar2(2000);
499: x_query varchar2(2000);

Line 496: x_desc xmltype;

492: ----------------- --------------------
493:
494: catId number;
495: x_prim xmltype;
496: x_desc xmltype;
497: x_temp xmltype;
498: -- language_clause varchar2(2000);
499: x_query varchar2(2000);
500: no_catId_exception EXCEPTION;

Line 497: x_temp xmltype;

493:
494: catId number;
495: x_prim xmltype;
496: x_desc xmltype;
497: x_temp xmltype;
498: -- language_clause varchar2(2000);
499: x_query varchar2(2000);
500: no_catId_exception EXCEPTION;
501:

Line 577: x_doc OUT NOCOPY xmltype,

573: catalogId IN NUMBER,
574: parentCategoryId IN NUMBER,
575: categoryId IN NUMBER,
576: p_language IN VARCHAR2,
577: x_doc OUT NOCOPY xmltype,
578: x_error_message OUT NOCOPY VARCHAR2
579: )
580: IS
581:

Line 583: x_iden xmltype;

579: )
580: IS
581:
582: cat_set_id number;
583: x_iden xmltype;
584: x_desc xmltype;
585: x_temp1 xmltype;
586: x_temp2 xmltype;
587: x_temp2_child xmltype;

Line 584: x_desc xmltype;

580: IS
581:
582: cat_set_id number;
583: x_iden xmltype;
584: x_desc xmltype;
585: x_temp1 xmltype;
586: x_temp2 xmltype;
587: x_temp2_child xmltype;
588: x_query varchar2(2000);

Line 585: x_temp1 xmltype;

581:
582: cat_set_id number;
583: x_iden xmltype;
584: x_desc xmltype;
585: x_temp1 xmltype;
586: x_temp2 xmltype;
587: x_temp2_child xmltype;
588: x_query varchar2(2000);
589: -- language_clause varchar2(2000);

Line 586: x_temp2 xmltype;

582: cat_set_id number;
583: x_iden xmltype;
584: x_desc xmltype;
585: x_temp1 xmltype;
586: x_temp2 xmltype;
587: x_temp2_child xmltype;
588: x_query varchar2(2000);
589: -- language_clause varchar2(2000);
590: no_calg_id_exception EXCEPTION;

Line 587: x_temp2_child xmltype;

583: x_iden xmltype;
584: x_desc xmltype;
585: x_temp1 xmltype;
586: x_temp2 xmltype;
587: x_temp2_child xmltype;
588: x_query varchar2(2000);
589: -- language_clause varchar2(2000);
590: no_calg_id_exception EXCEPTION;
591:

Line 707: x_doc OUT NOCOPY xmltype,

703: catalogId IN NUMBER,
704: parentCategoryId IN NUMBER,
705: categoryId IN NUMBER,
706: p_language IN VARCHAR2,
707: x_doc OUT NOCOPY xmltype,
708: x_error_message OUT NOCOPY VARCHAR2
709: )
710: -- Display Empty Description Tag
711: IS

Line 737: x_iden xmltype;

733: ------------- ---------------------------------------------
734: ------------- --------------------------------------
735:
736: cat_set_id number;
737: x_iden xmltype;
738: x_desc xmltype;
739: x_temp1 xmltype;
740: x_temp2 xmltype;
741: x_temp2_child xmltype;

Line 738: x_desc xmltype;

734: ------------- --------------------------------------
735:
736: cat_set_id number;
737: x_iden xmltype;
738: x_desc xmltype;
739: x_temp1 xmltype;
740: x_temp2 xmltype;
741: x_temp2_child xmltype;
742: x_cat xmltype;

Line 739: x_temp1 xmltype;

735:
736: cat_set_id number;
737: x_iden xmltype;
738: x_desc xmltype;
739: x_temp1 xmltype;
740: x_temp2 xmltype;
741: x_temp2_child xmltype;
742: x_cat xmltype;
743: x_query varchar2(2000);

Line 740: x_temp2 xmltype;

736: cat_set_id number;
737: x_iden xmltype;
738: x_desc xmltype;
739: x_temp1 xmltype;
740: x_temp2 xmltype;
741: x_temp2_child xmltype;
742: x_cat xmltype;
743: x_query varchar2(2000);
744: -- language_clause varchar2(2000);

Line 741: x_temp2_child xmltype;

737: x_iden xmltype;
738: x_desc xmltype;
739: x_temp1 xmltype;
740: x_temp2 xmltype;
741: x_temp2_child xmltype;
742: x_cat xmltype;
743: x_query varchar2(2000);
744: -- language_clause varchar2(2000);
745: no_calg_id_exception EXCEPTION;

Line 742: x_cat xmltype;

738: x_desc xmltype;
739: x_temp1 xmltype;
740: x_temp2 xmltype;
741: x_temp2_child xmltype;
742: x_cat xmltype;
743: x_query varchar2(2000);
744: -- language_clause varchar2(2000);
745: no_calg_id_exception EXCEPTION;
746:

Line 843: x_doc OUT NOCOPY XMLTYPE,

839: (
840: p_api_version IN NUMBER,
841: p_supplier_id IN NUMBER,
842: p_language IN VARCHAR2, -- If none is passed all languages are returned back
843: x_doc OUT NOCOPY XMLTYPE,
844: x_error_message OUT NOCOPY VARCHAR2
845: )
846: IS
847: BEGIN

Line 914: x_doc OUT NOCOPY XMLTYPE,

910: p_api_version IN NUMBER,
911: p_supplier_id IN NUMBER,
912: p_supplier_site_id IN NUMBER,
913: p_language IN VARCHAR2, -- If none is passed all languages are returned back
914: x_doc OUT NOCOPY XMLTYPE,
915: x_error_message OUT NOCOPY VARCHAR2
916: )
917: IS
918: BEGIN

Line 997: x_doc OUT NOCOPY XMLTYPE,

993: p_organization_id IN NUMBER, -- Item Identifier2
994: p_supplierId IN NUMBER, -- Supplier Identifier
995: p_extension_id IN NUMBER, -- pk for identifying the row in ext values table
996: p_language IN VARCHAR2,
997: x_doc OUT NOCOPY XMLTYPE,
998: x_error_message OUT NOCOPY VARCHAR2
999: )
1000: IS
1001: l_data_level_id NUMBER;

Line 1002: l_item_base_info XMLTYPE;

998: x_error_message OUT NOCOPY VARCHAR2
999: )
1000: IS
1001: l_data_level_id NUMBER;
1002: l_item_base_info XMLTYPE;
1003: l_item_id_info XMLTYPE;
1004: l_supplier_info XMLTYPE;
1005: l_uda_xml XMLTYPE;
1006:

Line 1003: l_item_id_info XMLTYPE;

999: )
1000: IS
1001: l_data_level_id NUMBER;
1002: l_item_base_info XMLTYPE;
1003: l_item_id_info XMLTYPE;
1004: l_supplier_info XMLTYPE;
1005: l_uda_xml XMLTYPE;
1006:
1007: BEGIN

Line 1004: l_supplier_info XMLTYPE;

1000: IS
1001: l_data_level_id NUMBER;
1002: l_item_base_info XMLTYPE;
1003: l_item_id_info XMLTYPE;
1004: l_supplier_info XMLTYPE;
1005: l_uda_xml XMLTYPE;
1006:
1007: BEGIN
1008: -- 1. get_data_level_id for the data_level_internal_name

Line 1005: l_uda_xml XMLTYPE;

1001: l_data_level_id NUMBER;
1002: l_item_base_info XMLTYPE;
1003: l_item_id_info XMLTYPE;
1004: l_supplier_info XMLTYPE;
1005: l_uda_xml XMLTYPE;
1006:
1007: BEGIN
1008: -- 1. get_data_level_id for the data_level_internal_name
1009: l_data_level_id := getDataLevelId(G_ITM_SUP_DATA_LVL);

Line 1117: x_doc OUT NOCOPY xmltype,

1113: p_supplierId IN NUMBER,
1114: p_site_id IN NUMBER,
1115: p_extension_id IN NUMBER,
1116: p_language IN VARCHAR2, -- If none is passed all languages are returned back
1117: x_doc OUT NOCOPY xmltype,
1118: x_error_message OUT NOCOPY varchar2
1119: )
1120: IS
1121: l_data_level_id NUMBER;

Line 1122: l_item_base_info XMLTYPE;

1118: x_error_message OUT NOCOPY varchar2
1119: )
1120: IS
1121: l_data_level_id NUMBER;
1122: l_item_base_info XMLTYPE;
1123: l_item_id_info XMLTYPE;
1124: l_supplier_site_info XMLTYPE;
1125: l_uda_xml XMLTYPE;
1126:

Line 1123: l_item_id_info XMLTYPE;

1119: )
1120: IS
1121: l_data_level_id NUMBER;
1122: l_item_base_info XMLTYPE;
1123: l_item_id_info XMLTYPE;
1124: l_supplier_site_info XMLTYPE;
1125: l_uda_xml XMLTYPE;
1126:
1127: BEGIN

Line 1124: l_supplier_site_info XMLTYPE;

1120: IS
1121: l_data_level_id NUMBER;
1122: l_item_base_info XMLTYPE;
1123: l_item_id_info XMLTYPE;
1124: l_supplier_site_info XMLTYPE;
1125: l_uda_xml XMLTYPE;
1126:
1127: BEGIN
1128: -- 1. get_data_level_id for the data_level_internal_name

Line 1125: l_uda_xml XMLTYPE;

1121: l_data_level_id NUMBER;
1122: l_item_base_info XMLTYPE;
1123: l_item_id_info XMLTYPE;
1124: l_supplier_site_info XMLTYPE;
1125: l_uda_xml XMLTYPE;
1126:
1127: BEGIN
1128: -- 1. get_data_level_id for the data_level_internal_name
1129: l_data_level_id := getDataLevelId(G_ITM_SUP_SITE_DATA_LVL);

Line 1201: RETURN XMLTYPE

1197: (
1198: p_inventory_item_id IN NUMBER,
1199: p_organization_id IN NUMBER
1200: )
1201: RETURN XMLTYPE
1202: IS
1203: l_item_info_xml XMLTYPE;
1204: l_error_message VARCHAR2(4000);
1205: BEGIN

Line 1203: l_item_info_xml XMLTYPE;

1199: p_organization_id IN NUMBER
1200: )
1201: RETURN XMLTYPE
1202: IS
1203: l_item_info_xml XMLTYPE;
1204: l_error_message VARCHAR2(4000);
1205: BEGIN
1206: getItemIdentification
1207: (

Line 1261: x_doc OUT NOCOPY XMLTYPE,

1257: p_structure_id IN NUMBER,
1258: p_component_id IN NUMBER,
1259: p_language IN VARCHAR2, -- If none is passed all languages are returned back
1260: p_get_first_level_comps IN VARCHAR2,
1261: x_doc OUT NOCOPY XMLTYPE,
1262: x_error_message OUT NOCOPY VARCHAR2
1263: )
1264: IS
1265: l_assly_item_id NUMBER;

Line 1269: l_assly_item_info_xml XMLTYPE;

1265: l_assly_item_id NUMBER;
1266: l_assly_item_org_id NUMBER;
1267: l_comp_item_id NUMBER;
1268:
1269: l_assly_item_info_xml XMLTYPE;
1270: l_comp_item_info_xml XMLTYPE;
1271:
1272: BEGIN
1273: -- TBD : debug :print input vars here

Line 1270: l_comp_item_info_xml XMLTYPE;

1266: l_assly_item_org_id NUMBER;
1267: l_comp_item_id NUMBER;
1268:
1269: l_assly_item_info_xml XMLTYPE;
1270: l_comp_item_info_xml XMLTYPE;
1271:
1272: BEGIN
1273: -- TBD : debug :print input vars here
1274:

Line 1424: x_doc OUT NOCOPY xmltype,

1420: p_organization_id IN NUMBER,
1421: p_catalog_id IN NUMBER,
1422: p_category_id IN NUMBER,
1423: p_language IN VARCHAR2, -- If none is passed all languages are returned back
1424: x_doc OUT NOCOPY xmltype,
1425: x_error_message OUT NOCOPY varchar2
1426: )
1427: IS
1428: l_item_id_info XMLTYPE;

Line 1428: l_item_id_info XMLTYPE;

1424: x_doc OUT NOCOPY xmltype,
1425: x_error_message OUT NOCOPY varchar2
1426: )
1427: IS
1428: l_item_id_info XMLTYPE;
1429: l_item_base_info XMLTYPE;
1430: l_catalog_info XMLTYPE;
1431: l_category_info XMLTYPE;
1432: BEGIN

Line 1429: l_item_base_info XMLTYPE;

1425: x_error_message OUT NOCOPY varchar2
1426: )
1427: IS
1428: l_item_id_info XMLTYPE;
1429: l_item_base_info XMLTYPE;
1430: l_catalog_info XMLTYPE;
1431: l_category_info XMLTYPE;
1432: BEGIN
1433: -- 1. fetch item id and base clauses

Line 1430: l_catalog_info XMLTYPE;

1426: )
1427: IS
1428: l_item_id_info XMLTYPE;
1429: l_item_base_info XMLTYPE;
1430: l_catalog_info XMLTYPE;
1431: l_category_info XMLTYPE;
1432: BEGIN
1433: -- 1. fetch item id and base clauses
1434:

Line 1431: l_category_info XMLTYPE;

1427: IS
1428: l_item_id_info XMLTYPE;
1429: l_item_base_info XMLTYPE;
1430: l_catalog_info XMLTYPE;
1431: l_category_info XMLTYPE;
1432: BEGIN
1433: -- 1. fetch item id and base clauses
1434:
1435: getItemIdentification(