DBA Data[Home] [Help]

APPS.WIP_WS_UTIL dependencies on WIP_WS_SHORTAGE

Line 1356: WIP_WS_SHORTAGE.g_pref_id_comp_short, WIP_WS_SHORTAGE.g_pref_level_id_site, WIP_WS_SHORTAGE.g_pref_val_mast_org_att, to_char(p_org_id));

1352: l_shortage_calc_level NUMBER;
1353: BEGIN
1354: --Bug 6889755 - Return component shortage depending on the calculation level setup
1355: l_row_seq_num := wip_ws_util.get_multival_pref_seq(
1356: WIP_WS_SHORTAGE.g_pref_id_comp_short, WIP_WS_SHORTAGE.g_pref_level_id_site, WIP_WS_SHORTAGE.g_pref_val_mast_org_att, to_char(p_org_id));
1357:
1358: l_shortage_calc_level := wip_ws_util.get_multival_pref_val_code(
1359: WIP_WS_SHORTAGE.g_pref_id_comp_short, WIP_WS_SHORTAGE.g_pref_level_id_site, l_row_seq_num, WIP_WS_SHORTAGE.g_pref_val_calclevel_att);
1360: --End Bug 6889755

Line 1359: WIP_WS_SHORTAGE.g_pref_id_comp_short, WIP_WS_SHORTAGE.g_pref_level_id_site, l_row_seq_num, WIP_WS_SHORTAGE.g_pref_val_calclevel_att);

1355: l_row_seq_num := wip_ws_util.get_multival_pref_seq(
1356: WIP_WS_SHORTAGE.g_pref_id_comp_short, WIP_WS_SHORTAGE.g_pref_level_id_site, WIP_WS_SHORTAGE.g_pref_val_mast_org_att, to_char(p_org_id));
1357:
1358: l_shortage_calc_level := wip_ws_util.get_multival_pref_val_code(
1359: WIP_WS_SHORTAGE.g_pref_id_comp_short, WIP_WS_SHORTAGE.g_pref_level_id_site, l_row_seq_num, WIP_WS_SHORTAGE.g_pref_val_calclevel_att);
1360: --End Bug 6889755
1361:
1362: --Bug 6889755 - added IF condition and the ELSE block for subinv level check
1363: IF (l_shortage_calc_level = ORG_CALCULATION_LEVEL) THEN