APPS.BOM_FILTER dependencies on BOM_EXPLOSIONS_ALL

Line 30: UPDATE BOM_EXPLOSIONS_ALL

26: l_st DATE := sysdate;
27: BEGIN
28:
29: -- Reset the flag
30: UPDATE BOM_EXPLOSIONS_ALL
31: SET HGRID_FLAG=NULL
32: WHERE HGRID_FLAG='Y'
33: AND group_id = p_GroupId
34: AND plan_level <> 0;

Line 40: UPDATE BOM_EXPLOSIONS_ALL SET hgrid_flag='Y' WHERE SORT_ORDER=p_ParamSortOrder(j) AND GROUP_ID=p_GroupId;

36: -- Update all the resultant rows to HGRID_FLAG='Y'
37: -- Code to handle if the SORT_ORDER array is empty.
38: IF p_ParamSortOrder IS NOT NULL AND p_ParamSortOrder.COUNT <> 0 THEN
39: FORALL j IN p_ParamSortOrder.FIRST .. p_ParamSortOrder.LAST
40: UPDATE BOM_EXPLOSIONS_ALL SET hgrid_flag='Y' WHERE SORT_ORDER=p_ParamSortOrder(j) AND GROUP_ID=p_GroupId;
41: END IF;
42: --dbms_output.put_line('applying filter: start: ' || to_char(l_st, 'mm-dd-yyyy hh24:mi:ss'));
43: --dbms_output.put_line('applying filter: end : ' || to_char(sysdate, 'mm-dd-yyyy hh24:mi:ss'));
44: EXCEPTION