APPS.EGO_ITEM_WS_PVT dependencies on EGO_PUB_BAT_PARAMS_B

Line 2000: SELECT CHAR_VALUE INTO l_alt_desg FROM EGO_PUB_BAT_PARAMS_B

1996: IF (l_item_id_tab.Count = 0) THEN
1997: RAISE e_invalid_batch_id;
1998: END IF;
1999:
2000: SELECT CHAR_VALUE INTO l_alt_desg FROM EGO_PUB_BAT_PARAMS_B
2001: WHERE type_id=l_batch_id AND Upper(parameter_name) ='STRUCTURE_NAME';
2002:
2003: /* Need to check for below */
2004: SELECT DATE_VALUE INTO l_rev_date FROM EGO_PUB_BAT_PARAMS_B

Line 2004: SELECT DATE_VALUE INTO l_rev_date FROM EGO_PUB_BAT_PARAMS_B

2000: SELECT CHAR_VALUE INTO l_alt_desg FROM EGO_PUB_BAT_PARAMS_B
2001: WHERE type_id=l_batch_id AND Upper(parameter_name) ='STRUCTURE_NAME';
2002:
2003: /* Need to check for below */
2004: SELECT DATE_VALUE INTO l_rev_date FROM EGO_PUB_BAT_PARAMS_B
2005: WHERE type_id=l_batch_id AND Upper(parameter_name) ='EXPLOSION_DATE';
2006:
2007: -- Bug 8683213 : Start
2008: BEGIN

Line 2009: SELECT NUMERIC_VALUE INTO l_levels_to_explode FROM EGO_PUB_BAT_PARAMS_B

2005: WHERE type_id=l_batch_id AND Upper(parameter_name) ='EXPLOSION_DATE';
2006:
2007: -- Bug 8683213 : Start
2008: BEGIN
2009: SELECT NUMERIC_VALUE INTO l_levels_to_explode FROM EGO_PUB_BAT_PARAMS_B
2010: WHERE type_id = l_batch_id AND Upper(parameter_name) ='LEVELS_TO_EXPLODE';
2011:
2012: IF (l_levels_to_explode < 0) OR (l_levels_to_explode > 60) THEN
2013: l_levels_to_explode := 60;

Line 2024: SELECT NUMERIC_VALUE INTO l_explode_option FROM EGO_PUB_BAT_PARAMS_B

2020:
2021: -- Bug 12922355 : Start honor explode option in batch mode also.
2022: BEGIN
2023: -- Read the value for explode option.
2024: SELECT NUMERIC_VALUE INTO l_explode_option FROM EGO_PUB_BAT_PARAMS_B
2025: WHERE type_id = l_batch_id AND Upper(parameter_name) ='EXPLODE_OPTION';
2026: EXCEPTION
2027: WHEN NO_DATA_FOUND THEN
2028: -- Default Current option if user do not provide any value.

Line 2034: SELECT CHAR_VALUE INTO l_expl_std_bom FROM EGO_PUB_BAT_PARAMS_B

2030: END;
2031: -- Bug 12922355 : End
2032:
2033: -- Bug 8752314 : CMR Change
2034: SELECT CHAR_VALUE INTO l_expl_std_bom FROM EGO_PUB_BAT_PARAMS_B
2035: WHERE type_id=l_batch_id AND Upper(parameter_name) ='EXPLODE_STD_BOM';
2036:
2037: FOR i IN 1..l_item_id_tab.Count
2038: LOOP

Line 4728: SELECT CHAR_VALUE INTO l_structure_name FROM EGO_PUB_BAT_PARAMS_B

4724: from EGO_PUB_WS_CONFIG
4725: where parameter_name = 'BATCH_ID'
4726: and session_id = p_session_id;
4727:
4728: SELECT CHAR_VALUE INTO l_structure_name FROM EGO_PUB_BAT_PARAMS_B
4729: WHERE type_id=l_batch_id AND Upper(parameter_name) ='STRUCTURE_NAME';
4730: END IF;
4731:
4732: EGO_DATA_SECURITY.get_security_predicate