APPS.PN_VAR_BKHD_DEFAULTS_PKG dependencies on PN_VAR_BKHD_DEFAULTS_ALL

Line 54: FROM pn_var_bkhd_defaults_all

50: ) is
51:
52: CURSOR C IS
53: SELECT ROWID
54: FROM pn_var_bkhd_defaults_all
55: WHERE bkhd_default_id = x_bkhd_default_id ;
56:
57: BEGIN
58:

Line 66: FROM pn_var_bkhd_defaults_all bkhd

62: -- We need t generate the line number
63: -------------------------------------------------------
64: SELECT nvl(max(bkhd.bkhd_detail_num),0)
65: INTO X_BKHD_DETAIL_NUM
66: FROM pn_var_bkhd_defaults_all bkhd
67: WHERE bkhd.bkhd_default_id = X_BKHD_DEFAULT_ID;
68:
69: X_BKHD_DETAIL_NUM := X_BKHD_DETAIL_NUM + 1;
70: -------------------------------------------------------

Line 79: insert into PN_VAR_BKHD_DEFAULTS_ALL

75: INTO X_BKHD_DEFAULT_ID
76: FROM dual;
77: END IF;
78:
79: insert into PN_VAR_BKHD_DEFAULTS_ALL
80: (
81: BKHD_DEFAULT_ID,
82: BKHD_DETAIL_NUM,
83: LINE_DEFAULT_ID,

Line 216: from PN_VAR_BKHD_DEFAULTS_ALL

212: ) is
213:
214: cursor c1 is select
215: *
216: from PN_VAR_BKHD_DEFAULTS_ALL
217: where BKHD_DEFAULT_ID = X_BKHD_DEFAULT_ID
218: for update of BKHD_DEFAULT_ID nowait;
219:
220: tlinfo c1%rowtype;

Line 480: UPDATE PN_VAR_BKHD_DEFAULTS_ALL SET

476: BEGIN
477:
478: PNP_DEBUG_PKG.debug ('PN_VAR_BKHD_DEFAULTS_PKG.UPDATE_ROW (+)');
479:
480: UPDATE PN_VAR_BKHD_DEFAULTS_ALL SET
481: LINE_DEFAULT_ID = X_LINE_DEFAULT_ID,
482: BKHD_DETAIL_NUM = X_BKHD_DETAIL_NUM,
483: BKPT_HEAD_TEMPLATE_ID = X_BKPT_HEAD_TEMPLATE_ID,
484: AGREEMENT_TEMPLATE_ID = X_AGREEMENT_TEMPLATE_ID,

Line 536: DELETE FROM PN_VAR_BKHD_DEFAULTS_ALL

532: BEGIN
533:
534: PNP_DEBUG_PKG.debug ('PN_VAR_BKHD_DEFAULTS_PKG.DELETE_ROW (+)'||X_BKHD_DEFAULT_ID);
535:
536: DELETE FROM PN_VAR_BKHD_DEFAULTS_ALL
537: WHERE BKHD_DEFAULT_ID = X_BKHD_DEFAULT_ID;
538:
539: IF (SQL%NOTFOUND) THEN
540: RAISE NO_DATA_FOUND;

Line 594: FROM pn_var_bkhd_defaults_all

590:
591: /* Get the details of breakpoint header default */
592: CURSOR bkhd_defaults_cur IS
593: SELECT *
594: FROM pn_var_bkhd_defaults_all
595: WHERE bkhd_default_id = x_bkhd_default_id;
596:
597: BEGIN
598:

Line 602: UPDATE pn_var_bkhd_defaults_all SET

598:
599: PNP_DEBUG_PKG.debug ('PN_VAR_BKHD_DEFAULTS_PKG.MODIFY_ROW (+)');
600:
601: FOR rec IN bkhd_defaults_cur LOOP
602: UPDATE pn_var_bkhd_defaults_all SET
603: line_default_id = NVL( x_line_default_id, rec.line_default_id),
604: bkhd_detail_num = NVL( x_bkhd_detail_num, rec.bkhd_detail_num ),
605: bkpt_head_template_id = NVL( x_bkpt_head_template_id, rec.bkpt_head_template_id),
606: agreement_template_id = NVL( x_agreement_template_id, rec.agreement_template_id ),