APPS.PN_VAR_BKPTS_DET_PKG dependencies on PN_VAR_BKPTS_DET_ALL

Line 55: FROM PN_VAR_BKPTS_DET_ALL

51: IS
52:
53: CURSOR C IS
54: SELECT ROWID
55: FROM PN_VAR_BKPTS_DET_ALL
56: WHERE BKPT_DETAIL_ID = X_BKPT_DETAIL_ID
57: ;
58:
59: l_return_status VARCHAR2(30) := NULL;

Line 70: FROM PN_VAR_BKPTS_DET_ALL bkdetails

66: -- We need to generate the breakpoints details number
67: -------------------------------------------------------
68: SELECT nvl(max(bkdetails.BKPT_DETAIL_NUM),0)
69: INTO X_BKPT_DETAIL_NUM
70: FROM PN_VAR_BKPTS_DET_ALL bkdetails
71: WHERE bkdetails.BKPT_HEADER_ID = X_BKPT_HEADER_ID;
72:
73: X_BKPT_DETAIL_NUM := X_BKPT_DETAIL_NUM + 1;
74:

Line 98: INSERT INTO PN_VAR_BKPTS_DET_ALL

94: IF (l_return_status IS NOT NULL) THEN
95: APP_EXCEPTION.Raise_Exception;
96: END IF;*/
97:
98: INSERT INTO PN_VAR_BKPTS_DET_ALL
99: (
100: BKPT_DETAIL_ID,
101: BKPT_DETAIL_NUM,
102: LAST_UPDATE_DATE,

Line 240: FROM PN_VAR_BKPTS_DET_ALL

236: IS
237:
238: CURSOR c1 IS
239: SELECT *
240: FROM PN_VAR_BKPTS_DET_ALL
241: WHERE BKPT_DETAIL_ID = X_BKPT_DETAIL_ID
242: FOR UPDATE OF BKPT_DETAIL_ID nowait;
243:
244: tlinfo c1%rowtype;

Line 504: UPDATE PN_VAR_BKPTS_DET_ALL SET

500: IF (l_return_status IS NOT NULL) THEN
501: APP_EXCEPTION.Raise_Exception;
502: END IF;*/
503:
504: UPDATE PN_VAR_BKPTS_DET_ALL SET
505: BKPT_DETAIL_NUM = X_BKPT_DETAIL_NUM,
506: BKPT_HEADER_ID = X_BKPT_HEADER_ID,
507: BKPT_START_DATE = X_BKPT_START_DATE,
508: BKPT_END_DATE = X_BKPT_END_DATE,

Line 568: FROM pn_var_bkpts_det_all

564: CURSOR line_item_cur IS
565: SELECT line_item_id
566: FROM pn_var_bkpts_head_all
567: WHERE Bkpt_Header_id = (SELECT bkpt_header_id
568: FROM pn_var_bkpts_det_all
569: WHERE bkpt_detail_id = x_bkpt_detail_id);
570:
571: BEGIN
572:

Line 581: DELETE FROM PN_VAR_BKPTS_DET_ALL

577: SET bkpt_update_flag = 'Y'
578: WHERE line_item_id = rec.line_item_id;
579: END LOOP;
580:
581: DELETE FROM PN_VAR_BKPTS_DET_ALL
582: WHERE BKPT_DETAIL_ID = X_BKPT_DETAIL_ID;
583:
584: IF (SQL%NOTFOUND) THEN
585: RAISE NO_DATA_FOUND;

Line 617: FROM pn_var_bkpts_det_all bkd

613: FROM dual
614: WHERE not exists
615: (
616: SELECT 1
617: FROM pn_var_bkpts_det_all bkd
618: WHERE NVL(bkd.PERIOD_BKPT_VOL_END,(x_period_vol_start+1)) > (x_period_vol_start)
619: AND ((x_bkpt_detail_id is null) or
620: (bkd.bkpt_detail_id <> x_bkpt_detail_id))
621: AND bkd.bkpt_header_id = x_bkpt_header_id