DBA Data[Home] [Help]

APPS.PN_VAR_BKDT_DEFAULTS_PKG dependencies on PN_VAR_BKHD_DEFAULTS_ALL

Line 163: UPDATE pn_var_bkhd_defaults_all

159: RAISE NO_DATA_FOUND;
160: END IF;
161: CLOSE c;
162:
163: UPDATE pn_var_bkhd_defaults_all
164: SET bkpt_update_flag = 'Y'
165: WHERE bkhd_default_id = x_bkhd_default_id;
166:
167: PNP_DEBUG_PKG.debug ('PN_VAR_BKDT_DEFAULTS_PKG.INSERT_ROW (-)');

Line 417: UPDATE pn_var_bkhd_defaults_all

413: IF (SQL%NOTFOUND) THEN
414: RAISE NO_DATA_FOUND;
415: END IF;
416:
417: UPDATE pn_var_bkhd_defaults_all
418: SET bkpt_update_flag = 'Y'
419: WHERE bkhd_default_id = x_bkhd_default_id;
420:
421: PNP_DEBUG_PKG.debug ('PN_VAR_BKDT_DEFAULTS_PKG.UPDATE_ROW (-)');

Line 439: UPDATE pn_var_bkhd_defaults_all

435:
436: PNP_DEBUG_PKG.debug ('PN_VAR_BKDT_DEFAULTS_PKG.DELETE_ROW (+)');
437:
438: FOR rec IN bkhd_default LOOP
439: UPDATE pn_var_bkhd_defaults_all
440: SET bkpt_update_flag = 'Y'
441: WHERE bkhd_default_id = rec.bkhd_default_id;
442: END LOOP;
443:

Line 547: UPDATE pn_var_bkhd_defaults_all

543: IF (SQL%NOTFOUND) THEN
544: RAISE NO_DATA_FOUND;
545: END IF;
546:
547: UPDATE pn_var_bkhd_defaults_all
548: SET bkpt_update_flag = 'Y'
549: WHERE bkhd_default_id = x_bkhd_default_id;
550:
551: END LOOP;