DBA Data[Home] [Help]

APPS.PN_VAR_BKPTS_HEAD_PKG dependencies on PN_VAR_LINES_ALL

Line 151: UPDATE pn_var_lines_all

147: END IF;
148: CLOSE c;
149:
150: IF NVL(x_bkpt_update_flag, 'Y') = 'Y' THEN
151: UPDATE pn_var_lines_all
152: SET bkpt_update_flag = 'Y'
153: WHERE line_item_id = x_line_item_id;
154: END IF;
155:

Line 459: UPDATE pn_var_lines_all

455: IF (SQL%NOTFOUND) THEN
456: RAISE NO_DATA_FOUND;
457: END IF;
458:
459: UPDATE pn_var_lines_all
460: SET bkpt_update_flag = 'Y'
461: WHERE line_item_id = x_line_item_id;
462:
463: PNP_DEBUG_PKG.debug ('PN_VAR_BKPTS_HEAD_PKG.UPDATE_ROW (-)');

Line 498: UPDATE pn_var_lines_all

494: PN_VAR_BKPTS_DET_PKG.DELETE_ROW ( X_BKPT_DETAIL_ID =>i.bkpt_detail_id );
495: END LOOP;
496:
497: FOR rec IN line_item_cur LOOP
498: UPDATE pn_var_lines_all
499: SET bkpt_update_flag = 'Y'
500: WHERE line_item_id = rec.line_item_id;
501: END LOOP;
502: