APPS.PN_VAR_VOL_HIST_PKG dependencies on PN_VAR_LINES_ALL

Line 204: UPDATE pn_var_lines_all

200: RAISE NO_DATA_FOUND;
201: END IF;
202: CLOSE c;
203:
204: UPDATE pn_var_lines_all
205: SET sales_vol_update_flag = 'Y'
206: WHERE line_item_id = x_line_item_id;
207:
208: PNP_DEBUG_PKG.debug ('PN_VAR_VOL_HIST_PKG.INSERT_ROW (-)');

Line 622: UPDATE pn_var_lines_all

618: IF (sql%notfound) THEN
619: RAISE NO_DATA_FOUND;
620: END IF;
621:
622: UPDATE pn_var_lines_all
623: SET sales_vol_update_flag = 'Y'
624: WHERE line_item_id = x_line_item_id;
625:
626: PNP_DEBUG_PKG.debug ('PN_VAR_VOL_HIST_PKG.UPDATE_ROW (-)');

Line 655: UPDATE pn_var_lines_all

651: /* Update the sales_vol_update_flag to 'Y' for line for which volume history
652: is deleted */
653: FOR rec IN line_item_cur LOOP
654:
655: UPDATE pn_var_lines_all
656: SET sales_vol_update_flag = 'Y'
657: WHERE line_item_id = rec.line_item_id;
658:
659: END LOOP;

Line 822: UPDATE pn_var_lines_all

818: IF (sql%notfound) THEN
819: RAISE NO_DATA_FOUND;
820: END IF;
821:
822: UPDATE pn_var_lines_all
823: SET sales_vol_update_flag = 'Y'
824: WHERE line_item_id = x_line_item_id;
825:
826: END LOOP;