DBA Data[Home] [Help]

APPS.PN_VAR_BKPTS_DET_PKG dependencies on PN_VAR_LINES_ALL

Line 186: UPDATE pn_var_lines_all

182: END IF;
183: CLOSE c;
184:
185: IF x_bkdt_default_id IS NULL THEN
186: UPDATE pn_var_lines_all
187: SET bkpt_update_flag = 'Y'
188: WHERE line_item_id IN (SELECT line_item_id
189: FROM pn_var_bkpts_head_all
190: WHERE bkpt_header_id = x_bkpt_header_id);

Line 544: UPDATE pn_var_lines_all

540: IF (SQL%NOTFOUND) THEN
541: RAISE NO_DATA_FOUND;
542: END IF;
543:
544: UPDATE pn_var_lines_all
545: SET bkpt_update_flag = 'Y'
546: WHERE line_item_id IN (SELECT line_item_id
547: FROM pn_var_bkpts_head_all
548: WHERE bkpt_header_id = x_bkpt_header_id);

Line 576: UPDATE pn_var_lines_all

572:
573: PNP_DEBUG_PKG.debug ('PN_VAR_LINES_PKG.DELETE_ROW (+)');
574:
575: FOR rec IN line_item_cur LOOP
576: UPDATE pn_var_lines_all
577: SET bkpt_update_flag = 'Y'
578: WHERE line_item_id = rec.line_item_id;
579: END LOOP;
580: