DBA Data[Home] [Help]

APPS.EGO_ITEM_WS_PVT dependencies on STANDARD

Line 2061: existsNode(xmlcontent, '/itemQueryParameters/BomExploderParameters/ExplodeStandard') -- Bug 8752314 : CMR Change

2057: END IF;
2058:
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:

Line 2091: SELECT nvl(extractValue(xmlcontent, '/itemQueryParameters/BomExploderParameters/ExplodeStandard'),'Y')

2087: END IF;
2088:
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