APPS.PN_VAR_LINE_DEFAULTS_PKG dependencies on PN_VAR_LINE_DEFAULTS_ALL

Line 50: from PN_VAR_LINE_DEFAULTS_ALL

46: ) IS
47:
48: CURSOR C is
49: select ROWID
50: from PN_VAR_LINE_DEFAULTS_ALL
51: where LINE_DEFAULT_ID = X_LINE_DEFAULT_ID
52: ;
53:
54: begin

Line 64: from PN_VAR_LINE_DEFAULTS_ALL lines

60: -- We need to generate the line number
61: -------------------------------------------------------
62: select nvl(max(lines.LINE_NUM),0)
63: into X_LINE_NUM
64: from PN_VAR_LINE_DEFAULTS_ALL lines
65: where lines.VAR_RENT_ID = X_VAR_RENT_ID;
66:
67: X_LINE_NUM := X_LINE_NUM + 1;
68:

Line 78: insert into PN_VAR_LINE_DEFAULTS_ALL

74: into X_LINE_DEFAULT_ID
75: from dual;
76: END IF;
77:
78: insert into PN_VAR_LINE_DEFAULTS_ALL
79: (
80: LINE_DEFAULT_ID,
81: LINE_NUM,
82: VAR_RENT_ID,

Line 201: from PN_VAR_LINE_DEFAULTS_ALL

197: ) is
198:
199: cursor c1 is select
200: *
201: from PN_VAR_LINE_DEFAULTS_ALL
202: where LINE_DEFAULT_ID = X_LINE_DEFAULT_ID
203: for update of LINE_DEFAULT_ID nowait;
204:
205: begin

Line 415: update PN_VAR_LINE_DEFAULTS_ALL set

411: begin
412:
413: PNP_DEBUG_PKG.debug ('PN_VAR_LINE_DEFAULTS_PKG.UPDATE_ROW (+)');
414:
415: update PN_VAR_LINE_DEFAULTS_ALL set
416: LINE_NUM = X_LINE_NUM,
417: VAR_RENT_ID = X_VAR_RENT_ID,
418: SALES_TYPE_CODE = X_SALES_TYPE_CODE,
419: ITEM_CATEGORY_CODE = X_ITEM_CATEGORY_CODE,

Line 487: DELETE FROM PN_VAR_LINE_DEFAULTS_ALL

483: FOR rec IN line_items LOOP
484: pn_var_lines_pkg.delete_row (rec.line_item_id);
485: END LOOP;
486:
487: DELETE FROM PN_VAR_LINE_DEFAULTS_ALL
488: WHERE LINE_DEFAULT_ID = X_LINE_DEFAULT_ID;
489:
490: IF (sql%notfound) THEN
491: RAISE NO_DATA_FOUND;