APPS.PN_VAR_VOL_HIST_PKG dependencies on PN_VAR_VOL_HIST_ALL

Line 62: FROM PN_VAR_VOL_HIST_ALL

58: )
59: IS
60: CURSOR C IS
61: SELECT ROWID
62: FROM PN_VAR_VOL_HIST_ALL
63: WHERE VOL_HIST_ID = X_VOL_HIST_ID;
64:
65: l_return_daily_amount NUMBER := 0;
66:

Line 76: FROM PN_VAR_VOL_HIST_ALL hist

72: -- We need to generate the volume history number
73: -------------------------------------------------------
74: SELECT nvl(max(hist.VOL_HIST_NUM),0)
75: INTO X_VOL_HIST_NUM
76: FROM PN_VAR_VOL_HIST_ALL hist
77: WHERE hist.LINE_ITEM_ID = X_LINE_ITEM_ID;
78:
79: X_VOL_HIST_NUM := X_VOL_HIST_NUM + 1;
80:

Line 99: INSERT INTO PN_VAR_VOL_HIST_ALL

95: X_START_DATE,
96: X_END_DATE
97: );
98:
99: INSERT INTO PN_VAR_VOL_HIST_ALL
100: (
101: VOL_HIST_ID,
102: VOL_HIST_NUM,
103: LAST_UPDATE_DATE,

Line 263: FROM PN_VAR_VOL_HIST_ALL

259: IS
260:
261: CURSOR c1 IS
262: SELECT *
263: FROM PN_VAR_VOL_HIST_ALL
264: WHERE VOL_HIST_ID = X_VOL_HIST_ID
265: FOR UPDATE OF VOL_HIST_ID NOWAIT;
266:
267: tlinfo c1%rowtype;

Line 572: UPDATE PN_VAR_VOL_HIST_ALL

568: X_START_DATE,
569: X_END_DATE
570: );
571:
572: UPDATE PN_VAR_VOL_HIST_ALL
573: SET
574: VOL_HIST_NUM = X_VOL_HIST_NUM,
575: LINE_ITEM_ID = X_LINE_ITEM_ID,
576: PERIOD_ID = X_PERIOD_ID,

Line 644: FROM pn_var_vol_hist_all

640:
641: /* Get the details of line item id for thsi volume history */
642: CURSOR line_item_cur IS
643: SELECT line_item_id
644: FROM pn_var_vol_hist_all
645: WHERE vol_hist_id = x_vol_hist_id;
646:
647: BEGIN
648:

Line 663: DELETE FROM PN_VAR_VOL_HIST_ALL

659: END LOOP;
660:
661:
662:
663: DELETE FROM PN_VAR_VOL_HIST_ALL
664: WHERE VOL_HIST_ID = X_VOL_HIST_ID;
665:
666: IF (sql%notfound) THEN
667: RAISE NO_DATA_FOUND;

Line 754: FROM pn_var_vol_hist_all

750:
751: /* Get the details of breakpoint details default */
752: CURSOR vol_his_cur IS
753: SELECT *
754: FROM pn_var_vol_hist_all
755: WHERE vol_hist_id = x_vol_hist_id;
756:
757:
758: BEGIN

Line 772: UPDATE PN_VAR_VOL_HIST_ALL

768: NVL(x_start_date, rec.start_date),
769: NVL(x_end_date, rec.end_date)
770: );
771:
772: UPDATE PN_VAR_VOL_HIST_ALL
773: SET
774: vol_hist_num = NVL( x_vol_hist_num, rec.vol_hist_num),
775: line_item_id = x_line_item_id,
776: period_id = NVL( x_period_id, rec.period_id),