127: RAISE NO_DATA_FOUND;
128: END IF;
129: CLOSE c;
130:
131: UPDATE pn_var_bkhd_defaults_all
132: SET bkpt_update_flag = 'Y'
133: WHERE bkhd_default_id = x_bkhd_default_id;
134:
135: PNP_DEBUG_PKG.debug ('PN_VAR_BKDT_DEFAULTS_PKG.INSERT_ROW (-)');
381: IF (SQL%NOTFOUND) THEN
382: RAISE NO_DATA_FOUND;
383: END IF;
384:
385: UPDATE pn_var_bkhd_defaults_all
386: SET bkpt_update_flag = 'Y'
387: WHERE bkhd_default_id = x_bkhd_default_id;
388:
389: PNP_DEBUG_PKG.debug ('PN_VAR_BKDT_DEFAULTS_PKG.UPDATE_ROW (-)');
403:
404: PNP_DEBUG_PKG.debug ('PN_VAR_BKDT_DEFAULTS_PKG.DELETE_ROW (+)');
405:
406: FOR rec IN bkhd_default LOOP
407: UPDATE pn_var_bkhd_defaults_all
408: SET bkpt_update_flag = 'Y'
409: WHERE bkhd_default_id = rec.bkhd_default_id;
410: END LOOP;
411:
511: IF (SQL%NOTFOUND) THEN
512: RAISE NO_DATA_FOUND;
513: END IF;
514:
515: UPDATE pn_var_bkhd_defaults_all
516: SET bkpt_update_flag = 'Y'
517: WHERE bkhd_default_id = x_bkhd_default_id;
518:
519: END LOOP;