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 EGO_PUB_WS_PARAMS

Line 1704: FROM EGO_PUB_WS_PARAMS

1700: -- p_search_str = '/itemQueryParameters/BatchId' for Batch
1701:
1702: SELECT existsNode(xmlcontent, p_search_str)
1703: INTO l_exists
1704: FROM EGO_PUB_WS_PARAMS
1705: WHERE session_id = p_session_id;
1706:
1707: IF l_exists=1 THEN
1708: /*If node exist for 'BatchId' then extractValue for BatchId'*/

Line 1711: FROM EGO_PUB_WS_PARAMS

1707: IF l_exists=1 THEN
1708: /*If node exist for 'BatchId' then extractValue for BatchId'*/
1709: SELECT Nvl(extractValue(xmlcontent,p_search_str),-1)
1710: INTO l_batch_id
1711: FROM EGO_PUB_WS_PARAMS
1712: WHERE session_id = p_session_id;
1713: END IF;
1714:
1715: IF(l_exists <> 1 or (l_exists = 1 and l_batch_id = -1)) THEN

Line 1720: FROM EGO_PUB_WS_PARAMS

1716:
1717: SELECT existsNode(xmlcontent, '/itemQueryParameters/InventoryItemId') ,
1718: existsNode(xmlcontent, '/itemQueryParameters/InventoryItemName')
1719: INTO l_exists_inv_id , l_exists_inv_name
1720: FROM EGO_PUB_WS_PARAMS
1721: WHERE session_id = p_session_id;
1722:
1723: SELECT existsNode(xmlcontent, '/itemQueryParameters/OrganizationId') ,
1724: existsNode(xmlcontent, '/itemQueryParameters/OrganizationCode')

Line 1726: FROM EGO_PUB_WS_PARAMS

1722:
1723: SELECT existsNode(xmlcontent, '/itemQueryParameters/OrganizationId') ,
1724: existsNode(xmlcontent, '/itemQueryParameters/OrganizationCode')
1725: INTO l_exists_org_id , l_exists_org_code
1726: FROM EGO_PUB_WS_PARAMS
1727: WHERE session_id = p_session_id;
1728:
1729: SELECT existsNode(xmlcontent, '/itemQueryParameters/RevisionId') ,
1730: existsNode(xmlcontent, '/itemQueryParameters/Revision') ,

Line 1733: FROM EGO_PUB_WS_PARAMS

1729: SELECT existsNode(xmlcontent, '/itemQueryParameters/RevisionId') ,
1730: existsNode(xmlcontent, '/itemQueryParameters/Revision') ,
1731: existsNode(xmlcontent, '/itemQueryParameters/RevisionDate')
1732: INTO l_exists_rev_id , l_exists_revision, l_exists_rev_date
1733: FROM EGO_PUB_WS_PARAMS
1734: WHERE session_id = p_session_id;
1735:
1736: process_non_batch_flow(p_session_id,
1737: p_odi_session_id,

Line 2049: FROM EGO_PUB_WS_PARAMS

2045: IF (l_mode <> 'MODE') THEN
2046: -- Process the details for NON - Batch Mode
2047: SELECT existsNode(xmlcontent, '/itemQueryParameters/StructureName')
2048: INTO l_exists_struct_name
2049: FROM EGO_PUB_WS_PARAMS
2050: WHERE session_id = p_session_id;
2051:
2052: IF (l_exists_struct_name = 1) THEN
2053: SELECT extractValue(xmlcontent, '/itemQueryParameters/StructureName')

Line 2055: FROM EGO_PUB_WS_PARAMS

2051:
2052: IF (l_exists_struct_name = 1) THEN
2053: SELECT extractValue(xmlcontent, '/itemQueryParameters/StructureName')
2054: INTO l_alt_desg
2055: FROM EGO_PUB_WS_PARAMS
2056: WHERE session_id = p_session_id;
2057: END IF;
2058:
2059: SELECT existsNode(xmlcontent, '/itemQueryParameters/BomExploderParameters/LevelsToExplode'),

Line 2063: FROM EGO_PUB_WS_PARAMS

2059: SELECT existsNode(xmlcontent, '/itemQueryParameters/BomExploderParameters/LevelsToExplode'),
2060: existsNode(xmlcontent, '/itemQueryParameters/BomExploderParameters/ExplodeOption'),
2061: existsNode(xmlcontent, '/itemQueryParameters/BomExploderParameters/ExplodeStandard') -- Bug 8752314 : CMR Change
2062: INTO l_exists_levels_to_explode, l_exists_explode_option, l_exists_explode_std
2063: FROM EGO_PUB_WS_PARAMS
2064: WHERE session_id = p_session_id;
2065:
2066: IF (l_exists_levels_to_explode = 1) THEN
2067: SELECT nvl(extractValue(xmlcontent, '/itemQueryParameters/BomExploderParameters/LevelsToExplode'),60)

Line 2069: FROM EGO_PUB_WS_PARAMS

2065:
2066: IF (l_exists_levels_to_explode = 1) THEN
2067: SELECT nvl(extractValue(xmlcontent, '/itemQueryParameters/BomExploderParameters/LevelsToExplode'),60)
2068: INTO l_levels_to_explode
2069: FROM EGO_PUB_WS_PARAMS
2070: WHERE session_id = p_session_id;
2071: ELSE
2072: l_levels_to_explode := 60;
2073: END IF;

Line 2083: FROM EGO_PUB_WS_PARAMS

2079: -- By Default the explode option should be Current.
2080: IF (l_exists_explode_option = 1) THEN
2081: SELECT nvl(extractValue(xmlcontent, '/itemQueryParameters/BomExploderParameters/ExplodeOption'),2)
2082: INTO l_explode_option
2083: FROM EGO_PUB_WS_PARAMS
2084: WHERE session_id = p_session_id;
2085: ELSE
2086: l_explode_option := 2;
2087: END IF;

Line 2093: FROM EGO_PUB_WS_PARAMS

2089: -- Bug 8752314 : CMR Change
2090: IF (l_exists_explode_std = 1) THEN
2091: SELECT nvl(extractValue(xmlcontent, '/itemQueryParameters/BomExploderParameters/ExplodeStandard'),'Y')
2092: INTO l_expl_std_bom
2093: FROM EGO_PUB_WS_PARAMS
2094: WHERE session_id = p_session_id;
2095: ELSE
2096: l_expl_std_bom := 'Y';
2097: END IF;

Line 2398: FROM EGO_PUB_WS_PARAMS

2394:
2395: /* Below Code is added for Chunking, extract configurable parameter 'ReturnPayload' */
2396: SELECT existsNode(xmlcontent, '/itemQueryParameters/PublishEntities/ReturnPayload')
2397: INTO l_node_exists
2398: FROM EGO_PUB_WS_PARAMS
2399: WHERE session_id = p_session_id;
2400:
2401: IF (l_node_exists = 0) THEN
2402: INSERT INTO EGO_PUB_WS_CONFIG (session_id,odi_session_id,Parameter_Name,Data_Type,Date_Value,Char_value,Numeric_Value,creation_date,created_by)

Line 2408: FROM EGO_PUB_WS_PARAMS i,

2404: ELSE
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: );

Line 2429: FROM EGO_PUB_WS_PARAMS i,

2425: -- Bug 12749057 : Start
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: );

Line 2519: FROM EGO_PUB_WS_PARAMS

2515: END IF;
2516:
2517: SELECT existsNode(xmlcontent, '/itemQueryParameters/PublishEntities/OperationalAttributeGroups')
2518: INTO l_node_exists
2519: FROM EGO_PUB_WS_PARAMS
2520: WHERE session_id = p_session_id;
2521:
2522: IF (l_node_exists = 1) THEN
2523: SELECT Nvl(extractValue(uda_ag, '/OperationalAttributeGroups'),'Y')

Line 2526: FROM EGO_PUB_WS_PARAMS i,

2522: IF (l_node_exists = 1) THEN
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: );

Line 2543: FROM EGO_PUB_WS_PARAMS

2539: END IF; -- (l_node_exists = 1) for Operational Ags
2540:
2541: SELECT existsNode(xmlcontent, '/itemQueryParameters/PublishEntities/PublishOperationalAttributeGroups')
2542: INTO l_node_exists
2543: FROM EGO_PUB_WS_PARAMS
2544: WHERE session_id = p_session_id;
2545:
2546: IF (l_node_exists = 0) THEN
2547: -- insert 'Y' for all the operational attributes groups

Line 2599: FROM EGO_PUB_WS_PARAMS

2595:
2596: ELSE
2597: SELECT existsNode(xmlcontent, '/itemQueryParameters/PublishEntities/PublishOperationalAttributeGroups/ItemCatalog')
2598: INTO l_node_exists
2599: FROM EGO_PUB_WS_PARAMS
2600: WHERE session_id = p_session_id;
2601:
2602: IF (l_node_exists = 0) THEN
2603: INSERT INTO EGO_PUB_WS_CONFIG ( session_id,odi_session_id,Parameter_Name,Data_Type,Date_Value,Char_value,Numeric_Value,creation_date,created_by)

Line 2609: FROM EGO_PUB_WS_PARAMS i,

2605: ELSE
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: );

Line 2621: FROM EGO_PUB_WS_PARAMS

2617: END IF;
2618:
2619: SELECT existsNode(xmlcontent, '/itemQueryParameters/PublishEntities/PublishOperationalAttributeGroups/InventoryCharacteristics')
2620: INTO l_node_exists
2621: FROM EGO_PUB_WS_PARAMS
2622: WHERE session_id = p_session_id;
2623:
2624: IF (l_node_exists = 0) THEN
2625: INSERT INTO EGO_PUB_WS_CONFIG ( session_id,odi_session_id,Parameter_Name,Data_Type,Date_Value,Char_value,Numeric_Value,creation_date,created_by)

Line 2631: FROM EGO_PUB_WS_PARAMS i,

2627: ELSE
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: );

Line 2644: FROM EGO_PUB_WS_PARAMS

2640: END IF;
2641:
2642: SELECT existsNode(xmlcontent, '/itemQueryParameters/PublishEntities/PublishOperationalAttributeGroups/PhysicalCharacteristics')
2643: INTO l_node_exists
2644: FROM EGO_PUB_WS_PARAMS
2645: WHERE session_id = p_session_id;
2646:
2647: IF (l_node_exists = 0) THEN
2648: INSERT INTO EGO_PUB_WS_CONFIG ( session_id,odi_session_id,Parameter_Name,Data_Type,Date_Value,Char_value,Numeric_Value,creation_date,created_by)

Line 2654: FROM EGO_PUB_WS_PARAMS i,

2650: ELSE
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: );

Line 2667: FROM EGO_PUB_WS_PARAMS

2663:
2664:
2665: SELECT existsNode(xmlcontent, '/itemQueryParameters/PublishEntities/PublishOperationalAttributeGroups/BillsOfMaterialCharacteristics')
2666: INTO l_node_exists
2667: FROM EGO_PUB_WS_PARAMS
2668: WHERE session_id = p_session_id;
2669:
2670: IF (l_node_exists = 0) THEN
2671: INSERT INTO EGO_PUB_WS_CONFIG ( session_id,odi_session_id,Parameter_Name,Data_Type,Date_Value,Char_value,Numeric_Value,creation_date,created_by)

Line 2677: FROM EGO_PUB_WS_PARAMS i,

2673: ELSE
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: );

Line 2690: FROM EGO_PUB_WS_PARAMS

2686:
2687:
2688: SELECT existsNode(xmlcontent, '/itemQueryParameters/PublishEntities/PublishOperationalAttributeGroups/WorkInProcessCharacteristics')
2689: INTO l_node_exists
2690: FROM EGO_PUB_WS_PARAMS
2691: WHERE session_id = p_session_id;
2692:
2693: IF (l_node_exists = 0) THEN
2694: INSERT INTO EGO_PUB_WS_CONFIG ( session_id,odi_session_id,Parameter_Name,Data_Type,Date_Value,Char_value,Numeric_Value,creation_date,created_by)

Line 2700: FROM EGO_PUB_WS_PARAMS i,

2696: ELSE
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: );

Line 2712: FROM EGO_PUB_WS_PARAMS

2708: END IF;
2709:
2710: SELECT existsNode(xmlcontent, '/itemQueryParameters/PublishEntities/PublishOperationalAttributeGroups/CostingCharacteristics')
2711: INTO l_node_exists
2712: FROM EGO_PUB_WS_PARAMS
2713: WHERE session_id = p_session_id;
2714:
2715: IF (l_node_exists = 0) THEN
2716: INSERT INTO EGO_PUB_WS_CONFIG ( session_id,odi_session_id,Parameter_Name,Data_Type,Date_Value,Char_value,Numeric_Value,creation_date,created_by)

Line 2722: FROM EGO_PUB_WS_PARAMS i,

2718: ELSE
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: );

Line 2734: FROM EGO_PUB_WS_PARAMS

2730: END IF;
2731:
2732: SELECT existsNode(xmlcontent, '/itemQueryParameters/PublishEntities/PublishOperationalAttributeGroups/ProcessingLeadTimeCharacteristics')
2733: INTO l_node_exists
2734: FROM EGO_PUB_WS_PARAMS
2735: WHERE session_id = p_session_id;
2736:
2737: IF (l_node_exists = 0) THEN
2738: INSERT INTO EGO_PUB_WS_CONFIG ( session_id,odi_session_id,Parameter_Name,Data_Type,Date_Value,Char_value,Numeric_Value,creation_date,created_by)

Line 2744: FROM EGO_PUB_WS_PARAMS i,

2740: ELSE
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: );

Line 2756: FROM EGO_PUB_WS_PARAMS

2752: END IF;
2753:
2754: SELECT existsNode(xmlcontent, '/itemQueryParameters/PublishEntities/PublishOperationalAttributeGroups/PlanningCharacteristics')
2755: INTO l_node_exists
2756: FROM EGO_PUB_WS_PARAMS
2757: WHERE session_id = p_session_id;
2758:
2759: IF (l_node_exists = 0) THEN
2760: INSERT INTO EGO_PUB_WS_CONFIG ( session_id,odi_session_id,Parameter_Name,Data_Type,Date_Value,Char_value,Numeric_Value,creation_date,created_by)

Line 2766: FROM EGO_PUB_WS_PARAMS i,

2762: ELSE
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: );

Line 2778: FROM EGO_PUB_WS_PARAMS

2774: END IF;
2775:
2776: SELECT existsNode(xmlcontent, '/itemQueryParameters/PublishEntities/PublishOperationalAttributeGroups/PurchasingCharacteristics')
2777: INTO l_node_exists
2778: FROM EGO_PUB_WS_PARAMS
2779: WHERE session_id = p_session_id;
2780:
2781: IF (l_node_exists = 0) THEN
2782: INSERT INTO EGO_PUB_WS_CONFIG ( session_id,odi_session_id,Parameter_Name,Data_Type,Date_Value,Char_value,Numeric_Value,creation_date,created_by)

Line 2788: FROM EGO_PUB_WS_PARAMS i,

2784: ELSE
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: );

Line 2800: FROM EGO_PUB_WS_PARAMS

2796: END IF;
2797:
2798: SELECT existsNode(xmlcontent, '/itemQueryParameters/PublishEntities/PublishOperationalAttributeGroups/OrderManagementCharacteristics')
2799: INTO l_node_exists
2800: FROM EGO_PUB_WS_PARAMS
2801: WHERE session_id = p_session_id;
2802:
2803: IF (l_node_exists = 0) THEN
2804: INSERT INTO EGO_PUB_WS_CONFIG ( session_id,odi_session_id,Parameter_Name,Data_Type,Date_Value,Char_value,Numeric_Value,creation_date,created_by)

Line 2810: FROM EGO_PUB_WS_PARAMS i,

2806: ELSE
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: );

Line 2822: FROM EGO_PUB_WS_PARAMS

2818: END IF;
2819:
2820: SELECT existsNode(xmlcontent, '/itemQueryParameters/PublishEntities/PublishOperationalAttributeGroups/ReceivingCharacteristics')
2821: INTO l_node_exists
2822: FROM EGO_PUB_WS_PARAMS
2823: WHERE session_id = p_session_id;
2824:
2825: IF (l_node_exists = 0) THEN
2826: INSERT INTO EGO_PUB_WS_CONFIG ( session_id,odi_session_id,Parameter_Name,Data_Type,Date_Value,Char_value,Numeric_Value,creation_date,created_by)

Line 2832: FROM EGO_PUB_WS_PARAMS i,

2828: ELSE
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: );

Line 2844: FROM EGO_PUB_WS_PARAMS

2840: END IF;
2841:
2842: SELECT existsNode(xmlcontent, '/itemQueryParameters/PublishEntities/PublishOperationalAttributeGroups/InvoicingCharacteristics')
2843: INTO l_node_exists
2844: FROM EGO_PUB_WS_PARAMS
2845: WHERE session_id = p_session_id;
2846:
2847: IF (l_node_exists = 0) THEN
2848: INSERT INTO EGO_PUB_WS_CONFIG ( session_id,odi_session_id,Parameter_Name,Data_Type,Date_Value,Char_value,Numeric_Value,creation_date,created_by)

Line 2854: FROM EGO_PUB_WS_PARAMS i,

2850: ELSE
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: );

Line 2866: FROM EGO_PUB_WS_PARAMS

2862: END IF;
2863:
2864: SELECT existsNode(xmlcontent, '/itemQueryParameters/PublishEntities/PublishOperationalAttributeGroups/WebOptionsCharacteristics')
2865: INTO l_node_exists
2866: FROM EGO_PUB_WS_PARAMS
2867: WHERE session_id = p_session_id;
2868:
2869: IF (l_node_exists = 0) THEN
2870: INSERT INTO EGO_PUB_WS_CONFIG ( session_id,odi_session_id,Parameter_Name,Data_Type,Date_Value,Char_value,Numeric_Value,creation_date,created_by)

Line 2876: FROM EGO_PUB_WS_PARAMS i,

2872: ELSE
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: );

Line 2888: FROM EGO_PUB_WS_PARAMS

2884: END IF;
2885:
2886: SELECT existsNode(xmlcontent, '/itemQueryParameters/PublishEntities/PublishOperationalAttributeGroups/ServiceCharacteristics')
2887: INTO l_node_exists
2888: FROM EGO_PUB_WS_PARAMS
2889: WHERE session_id = p_session_id;
2890:
2891: IF (l_node_exists = 0) THEN
2892: INSERT INTO EGO_PUB_WS_CONFIG ( session_id,odi_session_id,Parameter_Name,Data_Type,Date_Value,Char_value,Numeric_Value,creation_date,created_by)

Line 2898: FROM EGO_PUB_WS_PARAMS i,

2894: ELSE
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: );

Line 2910: FROM EGO_PUB_WS_PARAMS

2906: END IF;
2907:
2908: SELECT existsNode(xmlcontent, '/itemQueryParameters/PublishEntities/PublishOperationalAttributeGroups/AssetCharacteristics')
2909: INTO l_node_exists
2910: FROM EGO_PUB_WS_PARAMS
2911: WHERE session_id = p_session_id;
2912:
2913: IF (l_node_exists = 0) THEN
2914: INSERT INTO EGO_PUB_WS_CONFIG ( session_id,odi_session_id,Parameter_Name,Data_Type,Date_Value,Char_value,Numeric_Value,creation_date,created_by)

Line 2920: FROM EGO_PUB_WS_PARAMS i,

2916: ELSE
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: );

Line 2932: FROM EGO_PUB_WS_PARAMS

2928: END IF;
2929:
2930: SELECT existsNode(xmlcontent, '/itemQueryParameters/PublishEntities/PublishOperationalAttributeGroups/ProcessMfgCharacteristics')
2931: INTO l_node_exists
2932: FROM EGO_PUB_WS_PARAMS
2933: WHERE session_id = p_session_id;
2934:
2935: IF (l_node_exists = 0) THEN
2936: INSERT INTO EGO_PUB_WS_CONFIG ( session_id,odi_session_id,Parameter_Name,Data_Type,Date_Value,Char_value,Numeric_Value,creation_date,created_by)

Line 2942: FROM EGO_PUB_WS_PARAMS i,

2938: ELSE
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: );

Line 2956: FROM EGO_PUB_WS_PARAMS

2952: END IF; -- (l_node_exists = 0) for Publish Operational Ags
2953:
2954: SELECT existsNode(xmlcontent, '/itemQueryParameters/PublishEntities/UserDefinedAttributeGroups')
2955: INTO l_node_exists
2956: FROM EGO_PUB_WS_PARAMS
2957: WHERE session_id = p_session_id;
2958:
2959: IF (l_node_exists = 0) THEN
2960: INSERT INTO EGO_PUB_WS_CONFIG ( session_id,odi_session_id,Parameter_Name,Data_Type,Date_Value,Char_value,Numeric_Value,creation_date,created_by)

Line 2966: FROM EGO_PUB_WS_PARAMS i,

2962: ELSE
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: );

Line 2979: FROM EGO_PUB_WS_PARAMS

2975:
2976:
2977: SELECT existsNode(xmlcontent, '/itemQueryParameters/PublishEntities/ItemRevision')
2978: INTO l_node_exists
2979: FROM EGO_PUB_WS_PARAMS
2980: WHERE session_id = p_session_id;
2981:
2982: IF (l_node_exists = 0) THEN
2983: INSERT INTO EGO_PUB_WS_CONFIG ( session_id,odi_session_id,Parameter_Name,Data_Type,Date_Value,Char_value,Numeric_Value,creation_date,created_by)

Line 2989: FROM EGO_PUB_WS_PARAMS i,

2985: ELSE
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: );

Line 3001: FROM EGO_PUB_WS_PARAMS

2997: END IF;
2998:
2999: SELECT existsNode(xmlcontent, '/itemQueryParameters/PublishEntities/TransactionAttributes')
3000: INTO l_node_exists
3001: FROM EGO_PUB_WS_PARAMS
3002: WHERE session_id = p_session_id;
3003:
3004: IF (l_node_exists = 0) THEN
3005: INSERT INTO EGO_PUB_WS_CONFIG ( session_id,odi_session_id,Parameter_Name,Data_Type,Date_Value,Char_value,Numeric_Value,creation_date,created_by)

Line 3011: FROM EGO_PUB_WS_PARAMS i,

3007: ELSE
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: );

Line 3024: FROM EGO_PUB_WS_PARAMS

3020: END IF;
3021:
3022: SELECT existsNode(xmlcontent, '/itemQueryParameters/PublishEntities/RelatedItems')
3023: INTO l_node_exists
3024: FROM EGO_PUB_WS_PARAMS
3025: WHERE session_id = p_session_id;
3026:
3027: IF (l_node_exists = 0) THEN
3028: INSERT INTO EGO_PUB_WS_CONFIG ( session_id,odi_session_id,Parameter_Name,Data_Type,Date_Value,Char_value,Numeric_Value,creation_date,created_by)

Line 3034: FROM EGO_PUB_WS_PARAMS i,

3030: ELSE
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: );

Line 3047: FROM EGO_PUB_WS_PARAMS

3043:
3044:
3045: SELECT existsNode(xmlcontent, '/itemQueryParameters/PublishEntities/CustomerItems')
3046: INTO l_node_exists
3047: FROM EGO_PUB_WS_PARAMS
3048: WHERE session_id = p_session_id;
3049:
3050: IF (l_node_exists = 0) THEN
3051: INSERT INTO EGO_PUB_WS_CONFIG ( session_id,odi_session_id,Parameter_Name,Data_Type,Date_Value,Char_value,Numeric_Value,creation_date,created_by)

Line 3057: FROM EGO_PUB_WS_PARAMS i,

3053: ELSE
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: );

Line 3070: FROM EGO_PUB_WS_PARAMS

3066: END IF;
3067:
3068: SELECT existsNode(xmlcontent, '/itemQueryParameters/PublishEntities/ManufacturerPartNumbers')
3069: INTO l_node_exists
3070: FROM EGO_PUB_WS_PARAMS
3071: WHERE session_id = p_session_id;
3072:
3073: IF (l_node_exists = 0) THEN
3074: INSERT INTO EGO_PUB_WS_CONFIG ( session_id,odi_session_id,Parameter_Name,Data_Type,Date_Value,Char_value,Numeric_Value,creation_date,created_by)

Line 3080: FROM EGO_PUB_WS_PARAMS i,

3076: ELSE
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: );

Line 3092: FROM EGO_PUB_WS_PARAMS

3088: END IF;
3089:
3090: SELECT existsNode(xmlcontent, '/itemQueryParameters/PublishEntities/GTINCrossReferences')
3091: INTO l_node_exists
3092: FROM EGO_PUB_WS_PARAMS
3093: WHERE session_id = p_session_id;
3094:
3095: IF (l_node_exists = 0) THEN
3096: INSERT INTO EGO_PUB_WS_CONFIG ( session_id,odi_session_id,Parameter_Name,Data_Type,Date_Value,Char_value,Numeric_Value,creation_date,created_by)

Line 3102: FROM EGO_PUB_WS_PARAMS i,

3098: ELSE
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: );

Line 3114: FROM EGO_PUB_WS_PARAMS

3110: END IF;
3111:
3112: SELECT existsNode(xmlcontent, '/itemQueryParameters/PublishEntities/AlternateCategoryAssignments')
3113: INTO l_node_exists
3114: FROM EGO_PUB_WS_PARAMS
3115: WHERE session_id = p_session_id;
3116:
3117: IF (l_node_exists = 0) THEN
3118: INSERT INTO EGO_PUB_WS_CONFIG ( session_id,odi_session_id,Parameter_Name,Data_Type,Date_Value,Char_value,Numeric_Value,creation_date,created_by)

Line 3125: FROM EGO_PUB_WS_PARAMS i,

3121: ELSE
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: );

Line 3137: FROM EGO_PUB_WS_PARAMS

3133: END IF;
3134:
3135: SELECT existsNode(xmlcontent, '/itemQueryParameters/PublishEntities/SupplierAssignments')
3136: INTO l_node_exists
3137: FROM EGO_PUB_WS_PARAMS
3138: WHERE session_id = p_session_id;
3139:
3140: IF (l_node_exists = 0) THEN
3141: INSERT INTO EGO_PUB_WS_CONFIG ( session_id,odi_session_id,Parameter_Name,Data_Type,Date_Value,Char_value,Numeric_Value,creation_date,created_by)

Line 3147: FROM EGO_PUB_WS_PARAMS i,

3143: ELSE
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: );

Line 3168: FROM EGO_PUB_WS_PARAMS

3164: /* Process for UDAS */
3165:
3166: SELECT existsNode(xmlcontent, '/itemQueryParameters/PublishEntities/ListOfPublishUserDefinedAttributeGroups')
3167: INTO l_node_exists
3168: FROM EGO_PUB_WS_PARAMS
3169: WHERE session_id = p_session_id;
3170:
3171:
3172: IF (l_node_exists = 1) THEN -- (l_node_exists = 1) for list of pub udags

Line 3176: FROM EGO_PUB_WS_PARAMS

3172: IF (l_node_exists = 1) THEN -- (l_node_exists = 1) for list of pub udags
3173: SELECT existsNode(xmlcontent, '/itemQueryParameters/PublishEntities/ListOfPublishUserDefinedAttributeGroups/AttributeGroupId') ,
3174: existsNode(xmlcontent, '/itemQueryParameters/PublishEntities/ListOfPublishUserDefinedAttributeGroups/AttributeGroupName')
3175: INTO l_node_exists_ag_id, l_node_exists_ag_name
3176: FROM EGO_PUB_WS_PARAMS
3177: WHERE session_id = p_session_id;
3178:
3179: IF (l_node_exists_ag_id <> 0 AND l_node_exists_ag_name <> 0) THEN
3180: SELECT extractValue(uda_ag, '/AttributeGroupId')

Line 3183: FROM EGO_PUB_WS_PARAMS i,

3179: IF (l_node_exists_ag_id <> 0 AND l_node_exists_ag_name <> 0) THEN
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: );

Line 3192: FROM EGO_PUB_WS_PARAMS i,

3188:
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: );

Line 3310: FROM EGO_PUB_WS_PARAMS

3306: /* Process for Transaction Attributes */
3307:
3308: SELECT existsNode(xmlcontent, '/itemQueryParameters/PublishEntities/ListOfPublishTransactionAttributes')
3309: INTO l_node_exists
3310: FROM EGO_PUB_WS_PARAMS
3311: WHERE session_id = p_session_id;
3312:
3313:
3314: IF (l_node_exists = 1) THEN -- (l_node_exists = 1) for list of pub udags

Line 3318: FROM EGO_PUB_WS_PARAMS

3314: IF (l_node_exists = 1) THEN -- (l_node_exists = 1) for list of pub udags
3315: SELECT existsNode(xmlcontent, '/itemQueryParameters/PublishEntities/ListOfPublishTransactionAttributes/AttributeId') ,
3316: existsNode(xmlcontent, '/itemQueryParameters/PublishEntities/ListOfPublishTransactionAttributes/AttributeName')
3317: INTO l_node_exists_ta_id, l_node_exists_ta_name
3318: FROM EGO_PUB_WS_PARAMS
3319: WHERE session_id = p_session_id;
3320:
3321: IF (l_node_exists_ta_id <> 0 AND l_node_exists_ta_name <> 0) THEN
3322: SELECT extractValue(ta_attr, '/AttributeId')

Line 3325: FROM EGO_PUB_WS_PARAMS i,

3321: IF (l_node_exists_ta_id <> 0 AND l_node_exists_ta_name <> 0) THEN
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: );

Line 3334: FROM EGO_PUB_WS_PARAMS i,

3330:
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: );

Line 3542: FROM EGO_PUB_WS_PARAMS

3538: -- HMDM Flow
3539: IF (p_exists_inv_id = 1) THEN
3540: SELECT Nvl(extractValue(xmlcontent, '/itemQueryParameters/InventoryItemId'), -1)
3541: INTO l_inv_id
3542: FROM EGO_PUB_WS_PARAMS
3543: WHERE session_id = p_session_id;
3544: END IF; -- end of p_exists_inv_id = 1
3545:
3546: IF (p_exists_inv_name = 1) THEN

Line 3569: FROM EGO_PUB_WS_PARAMS i,

3565: l_segment_15, l_segment_16 ,
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:

Line 3596: FROM EGO_PUB_WS_PARAMS

3592:
3593: -- If Inventory Item Id or Item Name are not given then Check for List Flow
3594: SELECT existsNode(xmlcontent, '/itemQueryParameters/ItemsList')
3595: INTO l_exists_items_list
3596: FROM EGO_PUB_WS_PARAMS
3597: WHERE session_id = p_session_id;
3598:
3599: IF l_exists_items_list = 1
3600: THEN

Line 3613: FROM EGO_PUB_WS_PARAMS

3609:
3610: IF (p_exists_org_id = 1) THEN
3611: SELECT Nvl(extractValue(xmlcontent, '/itemQueryParameters/OrganizationId'), -1)
3612: INTO l_org_id
3613: FROM EGO_PUB_WS_PARAMS
3614: WHERE session_id = p_session_id;
3615: END IF; -- end of p_exists_org_id = 1
3616:
3617: IF (p_exists_org_code = 1) THEN

Line 3620: FROM EGO_PUB_WS_PARAMS

3616:
3617: IF (p_exists_org_code = 1) THEN
3618: SELECT extractValue(xmlcontent, '/itemQueryParameters/OrganizationCode')
3619: INTO l_org_code
3620: FROM EGO_PUB_WS_PARAMS
3621: WHERE session_id = p_session_id;
3622: END IF; -- end of p_exists_org_code = 1
3623:
3624: IF (l_org_id = -1 AND l_org_code IS NULL) THEN

Line 3631: FROM EGO_PUB_WS_PARAMS

3627: ELSE
3628: IF (p_exists_rev_id = 1) THEN
3629: SELECT Nvl(extractValue(xmlcontent, '/itemQueryParameters/RevisionId'), -1)
3630: INTO l_rev_id
3631: FROM EGO_PUB_WS_PARAMS
3632: WHERE session_id = p_session_id;
3633: END IF; -- end of (p_exists_rev_id = 1)
3634:
3635: IF (p_exists_revision = 1) THEN

Line 3638: FROM EGO_PUB_WS_PARAMS

3634:
3635: IF (p_exists_revision = 1) THEN
3636: SELECT extractValue(xmlcontent, '/itemQueryParameters/Revision')
3637: INTO l_revision
3638: FROM EGO_PUB_WS_PARAMS
3639: WHERE session_id = p_session_id;
3640: END IF; -- end of (p_exists_revision = 1)
3641:
3642: IF (p_exists_rev_date = 1) THEN

Line 3645: FROM EGO_PUB_WS_PARAMS

3641:
3642: IF (p_exists_rev_date = 1) THEN
3643: SELECT To_Date(extractValue(xmlcontent, '/itemQueryParameters/RevisionDate'), 'YYYY.MM.DD HH24:MI:SS')
3644: INTO l_rev_date
3645: FROM EGO_PUB_WS_PARAMS
3646: WHERE session_id = p_session_id;
3647: END IF; -- end of (p_exists_rev_date = 1)
3648:
3649: IF (l_rev_id = -1 AND l_revision IS NULL AND l_rev_date IS NULL) THEN

Line 3772: FROM EGO_PUB_WS_PARAMS

3768: ELSE
3769: -- List Flow
3770: SELECT existsNode(xmlcontent, '/itemQueryParameters/ItemsList')
3771: INTO l_exists_items_list
3772: FROM EGO_PUB_WS_PARAMS
3773: WHERE session_id = p_session_id;
3774:
3775: IF l_exists_items_list = 1
3776: THEN

Line 3794: FROM EGO_PUB_WS_PARAMS i,

3790: /*
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: );

Line 3823: FROM EGO_PUB_WS_PARAMS i,

3819: l_segment_15_tab, l_segment_16_tab,
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

Line 3841: FROM EGO_PUB_WS_PARAMS i,

3837:
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: );

Line 3850: FROM EGO_PUB_WS_PARAMS i,

3846:
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: );

Line 3859: FROM EGO_PUB_WS_PARAMS i,

3855:
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: );

Line 3868: FROM EGO_PUB_WS_PARAMS i,

3864:
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: );

Line 3943: FROM EGO_PUB_WS_PARAMS i,

3939: l_org_code_tab,
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:

Line 3977: FROM EGO_PUB_WS_PARAMS

3973: -- Bug 8659192 : Start
3974: IF (p_exists_rev_date = 1) THEN
3975: SELECT To_Date(extractValue(xmlcontent, '/itemQueryParameters/RevisionDate'),'YYYY.MM.DD HH24:MI:SS')
3976: INTO l_rev_date
3977: FROM EGO_PUB_WS_PARAMS
3978: WHERE session_id = p_session_id;
3979: END IF; -- end of (p_exists_rev_date = 1)
3980: -- Bug 8659192 : End
3981:

Line 4107: FROM EGO_PUB_WS_PARAMS

4103: END IF;
4104: ELSE
4105: SELECT To_Date(extractValue(xmlcontent, '/itemQueryParameters/RevisionDate'),'YYYY.MM.DD HH24:MI:SS')
4106: INTO l_rev_date
4107: FROM EGO_PUB_WS_PARAMS
4108: WHERE session_id = p_session_id;
4109:
4110: POPULATE_REVISION_DETAILS(p_session_id ,
4111: p_odi_session_id ,

Line 4155: FROM EGO_PUB_WS_PARAMS

4151: END IF;
4152:
4153: SELECT To_Date(extractValue(xmlcontent, '/itemQueryParameters/RevisionDate'),'YYYY.MM.DD HH24:MI:SS')
4154: INTO l_rev_date
4155: FROM EGO_PUB_WS_PARAMS
4156: WHERE session_id = p_session_id;
4157:
4158: POPULATE_REVISION_DETAILS(p_session_id ,
4159: p_odi_session_id ,

Line 4960: from EGO_PUB_WS_PARAMS

4956:
4957: --retrieving batchId from input XML
4958: select to_number(extractValue(xmlcontent, '/itemQueryParameters/BatchId'))
4959: into l_batch_id
4960: from EGO_PUB_WS_PARAMS
4961: where session_id = p_session_id;
4962:
4963: --retrieving user_id and responsability
4964: select created_by, responsibility_id

Line 4990: from EGO_PUB_WS_PARAMS

4986: ELSIF l_mode = 'LIST' OR l_mode = 'HMDM' THEN
4987:
4988: select fnd_user_name, responsibility_name, responsibility_appl_name, security_group_name
4989: into l_fnd_user_name, l_responsibility_name, l_responsibility_appl_name, l_security_group_name
4990: from EGO_PUB_WS_PARAMS
4991: where session_id = p_session_id;
4992:
4993: INSERT INTO EGO_PUB_WS_CONFIG (session_id,
4994: odi_session_id,