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_ITEM_WS_PVT dependencies on XMLSEQUENCE

Line 2409: TABLE(XMLSequence(

2405: SELECT Upper(Nvl(extractValue(ret_pay, '/ReturnPayload'),'Y'))
2406: INTO l_retpayload
2407: FROM (SELECT Value(retpay) ret_pay
2408: FROM EGO_PUB_WS_PARAMS i,
2409: TABLE(XMLSequence(
2410: extract(i.xmlcontent, '/itemQueryParameters/PublishEntities/ReturnPayload') )) retpay
2411: WHERE session_id=p_session_id
2412: );
2413:

Line 2430: TABLE(XMLSequence(

2426: SELECT extractValue(lang, '/ListOfLanguages/LanguageCode'), extractValue(lang, '/ListOfLanguages/LanguageName')
2427: BULK COLLECT INTO l_lang_code_tab, l_lang_name_tab
2428: FROM (SELECT Value(lang) lang
2429: FROM EGO_PUB_WS_PARAMS i,
2430: TABLE(XMLSequence(
2431: extract(i.xmlcontent, '/itemQueryParameters/PublishEntities/ListOfLanguages') )) lang
2432: WHERE session_id= p_session_id
2433: );
2434: -- Bug 12749057 : End

Line 2527: TABLE(XMLSequence(

2523: SELECT Nvl(extractValue(uda_ag, '/OperationalAttributeGroups'),'Y')
2524: INTO L_PUBLISH_OP_ATTR_GROUPS
2525: FROM (SELECT Value(udaag) uda_ag
2526: FROM EGO_PUB_WS_PARAMS i,
2527: TABLE(XMLSequence(
2528: extract(i.xmlcontent, '/itemQueryParameters/PublishEntities/OperationalAttributeGroups') )) udaag
2529: WHERE session_id=p_session_id
2530: );
2531:

Line 2610: TABLE(XMLSequence(

2606: SELECT Nvl(extractValue(uda_ag, '/ItemCatalog'),'Y')
2607: INTO L_PUBLISH_ITEM_CATALOG
2608: FROM (SELECT Value(udaag) uda_ag
2609: FROM EGO_PUB_WS_PARAMS i,
2610: TABLE(XMLSequence(
2611: extract(i.xmlcontent, '/itemQueryParameters/PublishEntities/PublishOperationalAttributeGroups/ItemCatalog') )) udaag
2612: WHERE session_id=p_session_id
2613: );
2614:

Line 2632: TABLE(XMLSequence(

2628: SELECT Nvl(extractValue(uda_ag, '/InventoryCharacteristics'),'Y')
2629: INTO L_PUBLISH_INV_CHARS
2630: FROM (SELECT Value(udaag) uda_ag
2631: FROM EGO_PUB_WS_PARAMS i,
2632: TABLE(XMLSequence(
2633: extract(i.xmlcontent, '/itemQueryParameters/PublishEntities/PublishOperationalAttributeGroups/InventoryCharacteristics') )) udaag
2634: WHERE session_id=p_session_id
2635: );
2636:

Line 2655: TABLE(XMLSequence(

2651: SELECT Nvl(extractValue(uda_ag, '/PhysicalCharacteristics'),'Y')
2652: INTO L_PUBLISH_PHY_CHARS
2653: FROM (SELECT Value(udaag) uda_ag
2654: FROM EGO_PUB_WS_PARAMS i,
2655: TABLE(XMLSequence(
2656: extract(i.xmlcontent, '/itemQueryParameters/PublishEntities/PublishOperationalAttributeGroups/PhysicalCharacteristics') )) udaag
2657: WHERE session_id=p_session_id
2658: );
2659:

Line 2678: TABLE(XMLSequence(

2674: SELECT Nvl(extractValue(uda_ag, '/BillsOfMaterialCharacteristics'),'Y')
2675: INTO L_PUBLISH_BOM_CHARS
2676: FROM (SELECT Value(udaag) uda_ag
2677: FROM EGO_PUB_WS_PARAMS i,
2678: TABLE(XMLSequence(
2679: extract(i.xmlcontent, '/itemQueryParameters/PublishEntities/PublishOperationalAttributeGroups/BillsOfMaterialCharacteristics') )) udaag
2680: WHERE session_id=p_session_id
2681: );
2682:

Line 2701: TABLE(XMLSequence(

2697: SELECT Nvl(extractValue(uda_ag, '/WorkInProcessCharacteristics'),'Y')
2698: INTO L_PUBLISH_WIP_CHARS
2699: FROM (SELECT Value(udaag) uda_ag
2700: FROM EGO_PUB_WS_PARAMS i,
2701: TABLE(XMLSequence(
2702: extract(i.xmlcontent, '/itemQueryParameters/PublishEntities/PublishOperationalAttributeGroups/WorkInProcessCharacteristics') )) udaag
2703: WHERE session_id=p_session_id
2704: );
2705:

Line 2723: TABLE(XMLSequence(

2719: SELECT Nvl(extractValue(uda_ag, '/CostingCharacteristics'),'Y')
2720: INTO L_PUBLISH_COST_CHARS
2721: FROM (SELECT Value(udaag) uda_ag
2722: FROM EGO_PUB_WS_PARAMS i,
2723: TABLE(XMLSequence(
2724: extract(i.xmlcontent, '/itemQueryParameters/PublishEntities/PublishOperationalAttributeGroups/CostingCharacteristics') )) udaag
2725: WHERE session_id=p_session_id
2726: );
2727:

Line 2745: TABLE(XMLSequence(

2741: SELECT Nvl(extractValue(uda_ag, '/ProcessingLeadTimeCharacteristics'),'Y')
2742: INTO L_PUBLISH_PLT_CHARS
2743: FROM (SELECT Value(udaag) uda_ag
2744: FROM EGO_PUB_WS_PARAMS i,
2745: TABLE(XMLSequence(
2746: extract(i.xmlcontent, '/itemQueryParameters/PublishEntities/PublishOperationalAttributeGroups/ProcessingLeadTimeCharacteristics') )) udaag
2747: WHERE session_id=p_session_id
2748: );
2749:

Line 2767: TABLE(XMLSequence(

2763: SELECT Nvl(extractValue(uda_ag, '/PlanningCharacteristics'),'Y')
2764: INTO L_PUBLISH_PLAN_CHARS
2765: FROM (SELECT Value(udaag) uda_ag
2766: FROM EGO_PUB_WS_PARAMS i,
2767: TABLE(XMLSequence(
2768: extract(i.xmlcontent, '/itemQueryParameters/PublishEntities/PublishOperationalAttributeGroups/PlanningCharacteristics') )) udaag
2769: WHERE session_id=p_session_id
2770: );
2771:

Line 2789: TABLE(XMLSequence(

2785: SELECT Nvl(extractValue(uda_ag, '/PurchasingCharacteristics'),'Y')
2786: INTO L_PUBLISH_PURCHASE_CHARS
2787: FROM (SELECT Value(udaag) uda_ag
2788: FROM EGO_PUB_WS_PARAMS i,
2789: TABLE(XMLSequence(
2790: extract(i.xmlcontent, '/itemQueryParameters/PublishEntities/PublishOperationalAttributeGroups/PurchasingCharacteristics') )) udaag
2791: WHERE session_id=p_session_id
2792: );
2793:

Line 2811: TABLE(XMLSequence(

2807: SELECT Nvl(extractValue(uda_ag, '/OrderManagementCharacteristics'),'Y')
2808: INTO L_PUBLISH_OM_CHARS
2809: FROM (SELECT Value(udaag) uda_ag
2810: FROM EGO_PUB_WS_PARAMS i,
2811: TABLE(XMLSequence(
2812: extract(i.xmlcontent, '/itemQueryParameters/PublishEntities/PublishOperationalAttributeGroups/OrderManagementCharacteristics') )) udaag
2813: WHERE session_id=p_session_id
2814: );
2815:

Line 2833: TABLE(XMLSequence(

2829: SELECT Nvl(extractValue(uda_ag, '/ReceivingCharacteristics'),'Y')
2830: INTO L_PUBLISH_RECEIVE_CHARS
2831: FROM (SELECT Value(udaag) uda_ag
2832: FROM EGO_PUB_WS_PARAMS i,
2833: TABLE(XMLSequence(
2834: extract(i.xmlcontent, '/itemQueryParameters/PublishEntities/PublishOperationalAttributeGroups/ReceivingCharacteristics') )) udaag
2835: WHERE session_id=p_session_id
2836: );
2837:

Line 2855: TABLE(XMLSequence(

2851: SELECT Nvl(extractValue(uda_ag, '/InvoicingCharacteristics'),'Y')
2852: INTO L_PUBLISH_INVOICE_CHARS
2853: FROM (SELECT Value(udaag) uda_ag
2854: FROM EGO_PUB_WS_PARAMS i,
2855: TABLE(XMLSequence(
2856: extract(i.xmlcontent, '/itemQueryParameters/PublishEntities/PublishOperationalAttributeGroups/InvoicingCharacteristics') )) udaag
2857: WHERE session_id=p_session_id
2858: );
2859:

Line 2877: TABLE(XMLSequence(

2873: SELECT Nvl(extractValue(uda_ag, '/WebOptionsCharacteristics'),'Y')
2874: INTO L_PUBLISH_WEBOPT_CHARS
2875: FROM (SELECT Value(udaag) uda_ag
2876: FROM EGO_PUB_WS_PARAMS i,
2877: TABLE(XMLSequence(
2878: extract(i.xmlcontent, '/itemQueryParameters/PublishEntities/PublishOperationalAttributeGroups/WebOptionsCharacteristics') )) udaag
2879: WHERE session_id=p_session_id
2880: );
2881:

Line 2899: TABLE(XMLSequence(

2895: SELECT Nvl(extractValue(uda_ag, '/ServiceCharacteristics'),'Y')
2896: INTO L_PUBLISH_SERVICE_CHARS
2897: FROM (SELECT Value(udaag) uda_ag
2898: FROM EGO_PUB_WS_PARAMS i,
2899: TABLE(XMLSequence(
2900: extract(i.xmlcontent, '/itemQueryParameters/PublishEntities/PublishOperationalAttributeGroups/ServiceCharacteristics') )) udaag
2901: WHERE session_id=p_session_id
2902: );
2903:

Line 2921: TABLE(XMLSequence(

2917: SELECT Nvl(extractValue(uda_ag, '/AssetCharacteristics'),'Y')
2918: INTO L_PUBLISH_ASSET_CHARS
2919: FROM (SELECT Value(udaag) uda_ag
2920: FROM EGO_PUB_WS_PARAMS i,
2921: TABLE(XMLSequence(
2922: extract(i.xmlcontent, '/itemQueryParameters/PublishEntities/PublishOperationalAttributeGroups/AssetCharacteristics') )) udaag
2923: WHERE session_id=p_session_id
2924: );
2925:

Line 2943: TABLE(XMLSequence(

2939: SELECT Nvl(extractValue(uda_ag, '/ProcessMfgCharacteristics'),'Y')
2940: INTO L_PUBLISH_PMFG_CHARS
2941: FROM (SELECT Value(udaag) uda_ag
2942: FROM EGO_PUB_WS_PARAMS i,
2943: TABLE(XMLSequence(
2944: extract(i.xmlcontent, '/itemQueryParameters/PublishEntities/PublishOperationalAttributeGroups/ProcessMfgCharacteristics') )) udaag
2945: WHERE session_id=p_session_id
2946: );
2947:

Line 2967: TABLE(XMLSequence(

2963: SELECT Nvl(extractValue(uda_ag, '/UserDefinedAttributeGroups'),'Y')
2964: INTO L_PUBLISH_UDA_GROUPS
2965: FROM (SELECT Value(udaag) uda_ag
2966: FROM EGO_PUB_WS_PARAMS i,
2967: TABLE(XMLSequence(
2968: extract(i.xmlcontent, '/itemQueryParameters/PublishEntities/UserDefinedAttributeGroups') )) udaag
2969: WHERE session_id=p_session_id
2970: );
2971:

Line 2990: TABLE(XMLSequence(

2986: SELECT Nvl(extractValue(uda_ag, '/ItemRevision'),'Y')
2987: INTO L_PUBLISH_ITEM_REVISION
2988: FROM (SELECT Value(udaag) uda_ag
2989: FROM EGO_PUB_WS_PARAMS i,
2990: TABLE(XMLSequence(
2991: extract(i.xmlcontent, '/itemQueryParameters/PublishEntities/ItemRevision') )) udaag
2992: WHERE session_id=p_session_id
2993: );
2994:

Line 3012: TABLE(XMLSequence(

3008: SELECT Nvl(extractValue(uda_ag, '/TransactionAttributes'),'Y')
3009: INTO L_PUBLISH_TRANSACTION_ATTRS
3010: FROM (SELECT Value(udaag) uda_ag
3011: FROM EGO_PUB_WS_PARAMS i,
3012: TABLE(XMLSequence(
3013: extract(i.xmlcontent, '/itemQueryParameters/PublishEntities/TransactionAttributes') )) udaag
3014: WHERE session_id=p_session_id
3015: );
3016:

Line 3035: TABLE(XMLSequence(

3031: SELECT Nvl(extractValue(uda_ag, '/RelatedItems'),'Y')
3032: INTO L_PUBLISH_RELATED_ITEMS
3033: FROM (SELECT Value(udaag) uda_ag
3034: FROM EGO_PUB_WS_PARAMS i,
3035: TABLE(XMLSequence(
3036: extract(i.xmlcontent, '/itemQueryParameters/PublishEntities/RelatedItems') )) udaag
3037: WHERE session_id=p_session_id
3038: );
3039:

Line 3058: TABLE(XMLSequence(

3054: SELECT Nvl(extractValue(uda_ag, '/CustomerItems'),'Y')
3055: INTO L_PUBLISH_CUSTOMER_ITEMS
3056: FROM (SELECT Value(udaag) uda_ag
3057: FROM EGO_PUB_WS_PARAMS i,
3058: TABLE(XMLSequence(
3059: extract(i.xmlcontent, '/itemQueryParameters/PublishEntities/CustomerItems') )) udaag
3060: WHERE session_id=p_session_id
3061: );
3062:

Line 3081: TABLE(XMLSequence(

3077: SELECT Nvl(extractValue(uda_ag, '/ManufacturerPartNumbers'),'Y')
3078: INTO L_PUBLISH_MFGPART_NUMBERS
3079: FROM (SELECT Value(udaag) uda_ag
3080: FROM EGO_PUB_WS_PARAMS i,
3081: TABLE(XMLSequence(
3082: extract(i.xmlcontent, '/itemQueryParameters/PublishEntities/ManufacturerPartNumbers') )) udaag
3083: WHERE session_id=p_session_id
3084: );
3085:

Line 3103: TABLE(XMLSequence(

3099: SELECT Nvl(extractValue(uda_ag, '/GTINCrossReferences'),'Y')
3100: INTO L_PUBLISH_GTIN_XREFS
3101: FROM (SELECT Value(udaag) uda_ag
3102: FROM EGO_PUB_WS_PARAMS i,
3103: TABLE(XMLSequence(
3104: extract(i.xmlcontent, '/itemQueryParameters/PublishEntities/GTINCrossReferences') )) udaag
3105: WHERE session_id=p_session_id
3106: );
3107:

Line 3126: TABLE(XMLSequence(

3122: SELECT Nvl(extractValue(uda_ag, '/AlternateCategoryAssignments'),'Y')
3123: INTO L_PUBLISH_ALTCAT_ASSIGNMENTS
3124: FROM (SELECT Value(udaag) uda_ag
3125: FROM EGO_PUB_WS_PARAMS i,
3126: TABLE(XMLSequence(
3127: extract(i.xmlcontent, '/itemQueryParameters/PublishEntities/AlternateCategoryAssignments') )) udaag
3128: WHERE session_id=p_session_id
3129: );
3130:

Line 3148: TABLE(XMLSequence(

3144: SELECT Nvl(extractValue(uda_ag, '/SupplierAssignments'),'Y')
3145: INTO L_PUBLISH_SUPPLIER_ASSIGNMNETS
3146: FROM (SELECT Value(udaag) uda_ag
3147: FROM EGO_PUB_WS_PARAMS i,
3148: TABLE(XMLSequence(
3149: extract(i.xmlcontent, '/itemQueryParameters/PublishEntities/SupplierAssignments') )) udaag
3150: WHERE session_id=p_session_id
3151: );
3152:

Line 3184: TABLE(XMLSequence(

3180: SELECT extractValue(uda_ag, '/AttributeGroupId')
3181: BULK COLLECT INTO l_uda_attr_id_tab
3182: FROM (SELECT Value(udaag) uda_ag
3183: FROM EGO_PUB_WS_PARAMS i,
3184: TABLE(XMLSequence(
3185: extract(i.xmlcontent, '/itemQueryParameters/PublishEntities/ListOfPublishUserDefinedAttributeGroups/AttributeGroupId') )) udaag
3186: WHERE session_id=p_session_id
3187: );
3188:

Line 3193: TABLE(XMLSequence(

3189: SELECT extractValue(uda_ag, '/AttributeGroupName')
3190: BULK COLLECT INTO l_uda_attr_name_tab
3191: FROM (SELECT Value(udaag) uda_ag
3192: FROM EGO_PUB_WS_PARAMS i,
3193: TABLE(XMLSequence(
3194: extract(i.xmlcontent, '/itemQueryParameters/PublishEntities/ListOfPublishUserDefinedAttributeGroups/AttributeGroupName') )) udaag
3195: WHERE session_id=p_session_id
3196: );
3197:

Line 3326: TABLE(XMLSequence(

3322: SELECT extractValue(ta_attr, '/AttributeId')
3323: BULK COLLECT INTO l_ta_attr_id_tab
3324: FROM (SELECT Value(ta) ta_attr
3325: FROM EGO_PUB_WS_PARAMS i,
3326: TABLE(XMLSequence(
3327: extract(i.xmlcontent, '/itemQueryParameters/PublishEntities/ListOfPublishTransactionAttributes/AttributeId') )) ta
3328: WHERE session_id=p_session_id
3329: );
3330:

Line 3335: TABLE(XMLSequence(

3331: SELECT extractValue(ta_attr, '/AttributeName')
3332: BULK COLLECT INTO l_ta_attr_name_tab
3333: FROM (SELECT Value(ta) ta_attr
3334: FROM EGO_PUB_WS_PARAMS i,
3335: TABLE(XMLSequence(
3336: extract(i.xmlcontent, '/itemQueryParameters/PublishEntities/ListOfPublishTransactionAttributes/AttributeName') )) ta
3337: WHERE session_id=p_session_id
3338: );
3339:

Line 3570: TABLE(XMLSequence(extract(i.xmlcontent, '/itemQueryParameters/InventoryItemName'))) itemName

3566: l_segment_17, l_segment_18 ,
3567: l_segment_19, l_segment_20
3568: FROM (SELECT Value(itemName) segments
3569: FROM EGO_PUB_WS_PARAMS i,
3570: TABLE(XMLSequence(extract(i.xmlcontent, '/itemQueryParameters/InventoryItemName'))) itemName
3571: WHERE session_id = p_session_id
3572: );
3573:
3574: IF ( l_segment_1 IS NULL AND l_segment_2 IS NULL AND

Line 3795: TABLE(XMLSequence(

3791: SELECT Nvl(extractValue(item_id, '/InventoryItemId'),-1)
3792: BULK COLLECT INTO l_item_id_tab
3793: FROM (SELECT Value(itemId) item_id
3794: FROM EGO_PUB_WS_PARAMS i,
3795: TABLE(XMLSequence(
3796: extract(i.xmlcontent, '/itemQueryParameters/ItemsList/InventoryItemId') )) itemId
3797: WHERE session_id=p_session_id
3798: );
3799:

Line 3824: TABLE(XMLSequence(extract(i.xmlcontent, '/itemQueryParameters/ItemsList/InventoryItemName'))) itemName

3820: l_segment_17_tab, l_segment_18_tab,
3821: l_segment_19_tab, l_segment_20_tab
3822: FROM (SELECT Value(itemName) segments
3823: FROM EGO_PUB_WS_PARAMS i,
3824: TABLE(XMLSequence(extract(i.xmlcontent, '/itemQueryParameters/ItemsList/InventoryItemName'))) itemName
3825: WHERE session_id = p_session_id
3826: );
3827: IF l_segment_1_tab.Count > 0 THEN
3828: l_list_segments := TRUE;

Line 3842: TABLE(XMLSequence(

3838: SELECT Nvl(extractValue(org_id, '/OrganizationId'), -1)
3839: BULK COLLECT INTO l_org_id_tab
3840: FROM (SELECT Value(orgId) org_id
3841: FROM EGO_PUB_WS_PARAMS i,
3842: TABLE(XMLSequence(
3843: extract(i.xmlcontent, '/itemQueryParameters/ItemsList/OrganizationId') )) orgId
3844: WHERE session_id=p_session_id
3845: );
3846:

Line 3851: TABLE(XMLSequence(

3847: SELECT extractValue(org_code, '/OrganizationCode')
3848: BULK COLLECT INTO l_org_code_tab
3849: FROM (SELECT Value(orgCode) org_code
3850: FROM EGO_PUB_WS_PARAMS i,
3851: TABLE(XMLSequence(
3852: extract(i.xmlcontent, '/itemQueryParameters/ItemsList/OrganizationCode') )) orgCode
3853: WHERE session_id=p_session_id
3854: );
3855:

Line 3860: TABLE(XMLSequence(

3856: SELECT Nvl(extractValue(rev_id, '/RevisionId'), -1)
3857: BULK COLLECT INTO l_rev_id_tab
3858: FROM (SELECT Value(revId) rev_id
3859: FROM EGO_PUB_WS_PARAMS i,
3860: TABLE(XMLSequence(
3861: extract(i.xmlcontent, '/itemQueryParameters/ItemsList/RevisionId') )) revId
3862: WHERE session_id=p_session_id
3863: );
3864:

Line 3869: TABLE(XMLSequence(

3865: SELECT extractValue(rev_lable, '/Revision')
3866: BULK COLLECT INTO l_rev_tab
3867: FROM (SELECT Value(rev) rev_lable
3868: FROM EGO_PUB_WS_PARAMS i,
3869: TABLE(XMLSequence(
3870: extract(i.xmlcontent, '/itemQueryParameters/ItemsList/Revision') )) rev
3871: WHERE session_id=p_session_id
3872: );
3873:

Line 3944: TABLE(XMLSequence(extract(i.xmlcontent, '/itemQueryParameters/ItemsList') )) itemsList

3940: l_rev_id_tab,
3941: l_rev_tab
3942: FROM ( SELECT Value(itemsList) items_list
3943: FROM EGO_PUB_WS_PARAMS i,
3944: TABLE(XMLSequence(extract(i.xmlcontent, '/itemQueryParameters/ItemsList') )) itemsList
3945: WHERE session_id = p_session_id
3946: );
3947:
3948: l_invalid_items_count := 0;