DBA Data[Home] [Help]

APPS.PN_VAR_BKDT_DEFAULTS_PKG dependencies on PN_VAR_BKHD_DEFAULTS_ALL

Line 131: UPDATE pn_var_bkhd_defaults_all

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 (-)');

Line 385: UPDATE pn_var_bkhd_defaults_all

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 (-)');

Line 407: UPDATE pn_var_bkhd_defaults_all

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:

Line 515: UPDATE pn_var_bkhd_defaults_all

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;