APPS.PN_VAR_LINE_TEMPLATES_PKG dependencies on PN_VAR_LINE_TEMPLATES_ALL

Line 40: from PN_VAR_LINE_TEMPLATES_ALL

36: ) is
37:
38: cursor C is
39: select ROWID
40: from PN_VAR_LINE_TEMPLATES_ALL
41: where LINE_TEMPLATE_ID = X_LINE_TEMPLATE_ID
42: ;
43:
44: l_return_status VARCHAR2(30) := NULL;

Line 55: from PN_VAR_LINE_TEMPLATES_ALL bkdetails

51: -- We need to generate the breakpoints details number
52: -------------------------------------------------------
53: select nvl(max(bkdetails.LINE_DETAIL_NUM),0)
54: into X_LINE_DETAIL_NUM
55: from PN_VAR_LINE_TEMPLATES_ALL bkdetails
56: where bkdetails.AGREEMENT_TEMPLATE_ID = X_AGREEMENT_TEMPLATE_ID;
57:
58: X_LINE_DETAIL_NUM := X_LINE_DETAIL_NUM + 1;
59:

Line 69: insert into PN_VAR_LINE_TEMPLATES_ALL

65: into X_LINE_TEMPLATE_ID
66: from dual;
67: END IF;
68:
69: insert into PN_VAR_LINE_TEMPLATES_ALL
70: (
71: LINE_TEMPLATE_ID,
72: LINE_DETAIL_NUM,
73: AGREEMENT_TEMPLATE_ID,

Line 171: from PN_VAR_LINE_TEMPLATES_ALL

167: ) is
168:
169: cursor c1 is
170: select *
171: from PN_VAR_LINE_TEMPLATES_ALL
172: where LINE_TEMPLATE_ID = X_LINE_TEMPLATE_ID
173: for update of LINE_TEMPLATE_ID nowait;
174:
175: tlinfo c1%rowtype;

Line 383: update PN_VAR_LINE_TEMPLATES_ALL set

379:
380: PNP_DEBUG_PKG.debug ('PN_VAR_LINE_TEMPLATES_PKG.UPDATE_ROW (+)');
381:
382:
383: update PN_VAR_LINE_TEMPLATES_ALL set
384: LINE_TEMPLATE_ID = X_LINE_TEMPLATE_ID,
385: LINE_DETAIL_NUM = X_LINE_DETAIL_NUM,
386: AGREEMENT_TEMPLATE_ID = X_AGREEMENT_TEMPLATE_ID,
387: SALES_TYPE_CODE = X_SALES_TYPE_CODE,

Line 430: delete from PN_VAR_LINE_TEMPLATES_ALL

426: BEGIN
427:
428: PNP_DEBUG_PKG.debug ('PN_VAR_LINE_TEMPLATES_PKG.DELETE_ROW (+)');
429:
430: delete from PN_VAR_LINE_TEMPLATES_ALL
431: where LINE_TEMPLATE_ID = X_LINE_TEMPLATE_ID;
432:
433: if (sql%notfound) then
434: raise no_data_found;