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 184: from PN_VAR_BKDT_DEFAULTS_ALL

180: ) is
181:
182: cursor c1 is select
183: *
184: from PN_VAR_BKDT_DEFAULTS_ALL
185: where BKDT_DEFAULT_ID = X_BKDT_DEFAULT_ID
186: for update of BKDT_DEFAULT_ID nowait;
187: begin
188:

Line 346: UPDATE PN_VAR_BKDT_DEFAULTS_ALL SET

342: BEGIN
343:
344: PNP_DEBUG_PKG.debug ('PN_VAR_BKDT_DEFAULTS_PKG.UPDATE_ROW (+)');
345:
346: UPDATE PN_VAR_BKDT_DEFAULTS_ALL SET
347: BKDT_DETAIL_NUM = X_BKDT_DETAIL_NUM,
348: BKHD_DEFAULT_ID = X_BKHD_DEFAULT_ID,
349: BKDT_START_DATE = X_BKDT_START_DATE,
350: BKDT_END_DATE = X_BKDT_END_DATE,

Line 400: FROM pn_var_bkdt_defaults_all

396: procedure DELETE_ROW ( X_BKDT_DEFAULT_ID in NUMBER)
397: IS
398: CURSOR bkhd_default IS
399: SELECT bkhd_default_id
400: FROM pn_var_bkdt_defaults_all
401: WHERE bkdt_default_id = x_bkdt_default_id;
402: BEGIN
403:
404: PNP_DEBUG_PKG.debug ('PN_VAR_BKDT_DEFAULTS_PKG.DELETE_ROW (+)');

Line 412: DELETE FROM pn_var_bkdt_defaults_all

408: SET bkpt_update_flag = 'Y'
409: WHERE bkhd_default_id = rec.bkhd_default_id;
410: END LOOP;
411:
412: DELETE FROM pn_var_bkdt_defaults_all
413: WHERE bkdt_default_id = x_bkdt_default_id;
414:
415: IF (SQL%NOTFOUND) THEN
416: RAISE NO_DATA_FOUND;

Line 468: FROM pn_var_bkdt_defaults_all

464:
465: /* Get the details of breakpoint details default */
466: CURSOR bkdt_defaults_cur IS
467: SELECT *
468: FROM pn_var_bkdt_defaults_all
469: WHERE bkdt_default_id = x_bkdt_default_id;
470:
471: BEGIN
472:

Line 476: UPDATE PN_VAR_BKDT_DEFAULTS_ALL SET

472:
473: PNP_DEBUG_PKG.debug ('PN_VAR_BKDT_DEFAULTS_PKG.MODIFY_ROW (+)');
474:
475: FOR rec IN bkdt_defaults_cur LOOP
476: UPDATE PN_VAR_BKDT_DEFAULTS_ALL SET
477: BKDT_DETAIL_NUM = NVL( x_bkdt_detail_num, rec.bkdt_detail_num),
478: BKHD_DEFAULT_ID = x_bkhd_default_id,
479: BKDT_START_DATE = NVL( x_bkdt_start_date, rec.bkdt_start_date),
480: BKDT_END_DATE = NVL( x_bkdt_end_date, rec.bkdt_end_date),