APPS.PN_VAR_BKPTS_HEAD_PKG dependencies on PN_VAR_BKPTS_HEAD_ALL

Line 50: FROM PN_VAR_BKPTS_HEAD_ALL

46: X_BKPT_UPDATE_FLAG in VARCHAR2)
47: IS
48: CURSOR C IS
49: SELECT ROWID
50: FROM PN_VAR_BKPTS_HEAD_ALL
51: WHERE BKPT_HEADER_ID = X_BKPT_HEADER_ID;
52:
53: BEGIN
54:

Line 67: INSERT INTO PN_VAR_BKPTS_HEAD_ALL

63: INTO X_BKPT_HEADER_ID
64: FROM dual;
65: END IF;
66:
67: INSERT INTO PN_VAR_BKPTS_HEAD_ALL
68: (
69: BKPT_HEADER_ID,
70: LAST_UPDATE_DATE,
71: LAST_UPDATED_BY,

Line 201: FROM PN_VAR_BKPTS_HEAD_ALL

197: IS
198:
199: CURSOR c1 IS
200: SELECT *
201: FROM PN_VAR_BKPTS_HEAD_ALL
202: WHERE BKPT_HEADER_ID = X_BKPT_HEADER_ID
203: FOR UPDATE OF BKPT_HEADER_ID NOWAIT;
204:
205: tlinfo c1%rowtype;

Line 422: UPDATE PN_VAR_BKPTS_HEAD_ALL SET

418: BEGIN
419:
420: PNP_DEBUG_PKG.debug ('PN_VAR_BKPTS_HEAD_PKG.UPDATE_ROW (+)');
421:
422: UPDATE PN_VAR_BKPTS_HEAD_ALL SET
423: LINE_ITEM_ID = X_LINE_ITEM_ID,
424: PERIOD_ID = X_PERIOD_ID,
425: BREAK_TYPE = X_BREAK_TYPE,
426: BASE_RENT_TYPE = X_BASE_RENT_TYPE,

Line 485: FROM pn_var_bkpts_head_all

481: FOR UPDATE OF bkpt_detail_id NOWAIT;
482:
483: CURSOR line_item_cur IS
484: SELECT line_item_id
485: FROM pn_var_bkpts_head_all
486: WHERE bkpt_header_id = x_bkpt_header_id;
487:
488: BEGIN
489:

Line 503: DELETE FROM PN_VAR_BKPTS_HEAD_ALL

499: SET bkpt_update_flag = 'Y'
500: WHERE line_item_id = rec.line_item_id;
501: END LOOP;
502:
503: DELETE FROM PN_VAR_BKPTS_HEAD_ALL
504: WHERE BKPT_HEADER_ID = X_BKPT_HEADER_ID;
505:
506: IF (SQL%NOTFOUND) THEN
507: RAISE NO_DATA_FOUND;