APPS.PN_VAR_BKDT_DEFAULTS_PKG dependencies on PN_VAR_BKDT_DEFAULTS_ALL

Line 52: FROM PN_VAR_BKDT_DEFAULTS_ALL

48: ) is
49:
50: CURSOR C IS
51: SELECT ROWID
52: FROM PN_VAR_BKDT_DEFAULTS_ALL
53: WHERE BKDT_DEFAULT_ID = X_BKDT_DEFAULT_ID;
54:
55: BEGIN
56:

Line 64: FROM PN_VAR_BKDT_DEFAULTS_ALL bkdt

60: -- We need to generate the line number
61: -------------------------------------------------------
62: SELECT nvl(max(bkdt.BKDT_DETAIL_NUM),0)
63: INTO X_BKDT_DETAIL_NUM
64: FROM PN_VAR_BKDT_DEFAULTS_ALL bkdt
65: WHERE bkdt.BKHD_DEFAULT_ID = X_BKHD_DEFAULT_ID;
66:
67: X_BKDT_DETAIL_NUM := X_BKDT_DETAIL_NUM + 1;
68:

Line 78: INSERT INTO PN_VAR_BKDT_DEFAULTS_ALL

74: INTO X_BKDT_DEFAULT_ID
75: FROM dual;
76: END IF;
77:
78: INSERT INTO PN_VAR_BKDT_DEFAULTS_ALL
79: (
80: BKDT_DETAIL_NUM,
81: BKHD_DEFAULT_ID,
82: LAST_UPDATE_DATE,

Line 216: from PN_VAR_BKDT_DEFAULTS_ALL

212: ) is
213:
214: cursor c1 is select
215: *
216: from PN_VAR_BKDT_DEFAULTS_ALL
217: where BKDT_DEFAULT_ID = X_BKDT_DEFAULT_ID
218: for update of BKDT_DEFAULT_ID nowait;
219: begin
220:

Line 378: UPDATE PN_VAR_BKDT_DEFAULTS_ALL SET

374: BEGIN
375:
376: PNP_DEBUG_PKG.debug ('PN_VAR_BKDT_DEFAULTS_PKG.UPDATE_ROW (+)');
377:
378: UPDATE PN_VAR_BKDT_DEFAULTS_ALL SET
379: BKDT_DETAIL_NUM = X_BKDT_DETAIL_NUM,
380: BKHD_DEFAULT_ID = X_BKHD_DEFAULT_ID,
381: BKDT_START_DATE = X_BKDT_START_DATE,
382: BKDT_END_DATE = X_BKDT_END_DATE,

Line 432: FROM pn_var_bkdt_defaults_all

428: procedure DELETE_ROW ( X_BKDT_DEFAULT_ID in NUMBER)
429: IS
430: CURSOR bkhd_default IS
431: SELECT bkhd_default_id
432: FROM pn_var_bkdt_defaults_all
433: WHERE bkdt_default_id = x_bkdt_default_id;
434: BEGIN
435:
436: PNP_DEBUG_PKG.debug ('PN_VAR_BKDT_DEFAULTS_PKG.DELETE_ROW (+)');

Line 444: DELETE FROM pn_var_bkdt_defaults_all

440: SET bkpt_update_flag = 'Y'
441: WHERE bkhd_default_id = rec.bkhd_default_id;
442: END LOOP;
443:
444: DELETE FROM pn_var_bkdt_defaults_all
445: WHERE bkdt_default_id = x_bkdt_default_id;
446:
447: IF (SQL%NOTFOUND) THEN
448: RAISE NO_DATA_FOUND;

Line 500: FROM pn_var_bkdt_defaults_all

496:
497: /* Get the details of breakpoint details default */
498: CURSOR bkdt_defaults_cur IS
499: SELECT *
500: FROM pn_var_bkdt_defaults_all
501: WHERE bkdt_default_id = x_bkdt_default_id;
502:
503: BEGIN
504:

Line 508: UPDATE PN_VAR_BKDT_DEFAULTS_ALL SET

504:
505: PNP_DEBUG_PKG.debug ('PN_VAR_BKDT_DEFAULTS_PKG.MODIFY_ROW (+)');
506:
507: FOR rec IN bkdt_defaults_cur LOOP
508: UPDATE PN_VAR_BKDT_DEFAULTS_ALL SET
509: BKDT_DETAIL_NUM = NVL( x_bkdt_detail_num, rec.bkdt_detail_num),
510: BKHD_DEFAULT_ID = x_bkhd_default_id,
511: BKDT_START_DATE = NVL( x_bkdt_start_date, rec.bkdt_start_date),
512: BKDT_END_DATE = NVL( x_bkdt_end_date, rec.bkdt_end_date),