APPS.PN_VAR_LINES_PKG dependencies on PN_VAR_LINES_ALL

Line 48: FROM PN_VAR_LINES_ALL

44: )
45: IS
46: CURSOR C IS
47: SELECT ROWID
48: FROM PN_VAR_LINES_ALL
49: WHERE LINE_ITEM_ID = X_LINE_ITEM_ID;
50:
51: BEGIN
52:

Line 60: FROM PN_VAR_LINES_ALL lines

56: -- We need to generate the line number
57: -------------------------------------------------------
58: SELECT nvl(max(lines.LINE_ITEM_NUM),0)
59: INTO X_LINE_ITEM_NUM
60: FROM PN_VAR_LINES_ALL lines
61: WHERE lines.PERIOD_ID = X_PERIOD_ID;
62:
63: X_LINE_ITEM_NUM := X_LINE_ITEM_NUM + 1;
64:

Line 74: INSERT INTO PN_VAR_LINES_ALL

70: INTO X_LINE_ITEM_ID
71: FROM dual;
72: END IF;
73:
74: INSERT INTO PN_VAR_LINES_ALL
75: (
76: LINE_ITEM_ID,
77: LINE_ITEM_NUM,
78: LAST_UPDATE_DATE,

Line 197: FROM PN_VAR_LINES_ALL

193: )
194: IS
195: CURSOR c1 IS
196: SELECT *
197: FROM PN_VAR_LINES_ALL
198: WHERE LINE_ITEM_ID = X_LINE_ITEM_ID
199: FOR UPDATE OF LINE_ITEM_ID NOWAIT;
200:
201: tlinfo c1%rowtype;

Line 417: UPDATE PN_VAR_LINES_ALL

413: BEGIN
414:
415: PNP_DEBUG_PKG.debug ('PN_VAR_LINES_PKG.UPDATE_ROW (+)');
416:
417: UPDATE PN_VAR_LINES_ALL
418: SET
419: LINE_ITEM_NUM = X_LINE_ITEM_NUM,
420: PERIOD_ID = X_PERIOD_ID,
421: SALES_TYPE_CODE = X_SALES_TYPE_CODE,

Line 469: FROM pn_var_lines_all

465: IS
466: -- Get the details of
467: CURSOR line_info_cur IS
468: SELECT period_id, var_rent_id
469: FROM pn_var_lines_all
470: WHERE line_item_id = x_line_item_id;
471:
472: BEGIN
473:

Line 482: DELETE from PN_VAR_LINES_ALL

478: NULL;
479: --pn_var_trx_pkg.delete_transactions (var_rent_id, period_id, x_line_item_id);
480: END LOOP;
481:
482: DELETE from PN_VAR_LINES_ALL
483: WHERE LINE_ITEM_ID = X_LINE_ITEM_ID;
484:
485: IF (sql%notfound) THEN
486: RAISE NO_DATA_FOUND;