DBA Data[Home] [Help]

APPS.PN_VAR_LINE_TEMPLATES_PKG dependencies on PNP_DEBUG_PKG

Line 48: PNP_DEBUG_PKG.debug ('PN_VAR_LINE_TEMPLATES_PKG.INSERT_ROW (+)');

44: l_return_status VARCHAR2(30) := NULL;
45:
46: BEGIN
47:
48: PNP_DEBUG_PKG.debug ('PN_VAR_LINE_TEMPLATES_PKG.INSERT_ROW (+)');
49:
50: -------------------------------------------------------
51: -- We need to generate the breakpoints details number
52: -------------------------------------------------------

Line 138: PNP_DEBUG_PKG.debug ('PN_VAR_LINE_TEMPLATES_PKG.INSERT_ROW (-)');

134: raise no_data_found;
135: end if;
136: close c;
137:
138: PNP_DEBUG_PKG.debug ('PN_VAR_LINE_TEMPLATES_PKG.INSERT_ROW (-)');
139:
140: END INSERT_ROW;
141:
142: -----------------------------------------------------------------------

Line 179: PNP_DEBUG_PKG.debug ('PN_VAR_LINE_TEMPLATES_PKG.LOCK_ROW (+)');

175: tlinfo c1%rowtype;
176:
177: BEGIN
178:
179: PNP_DEBUG_PKG.debug ('PN_VAR_LINE_TEMPLATES_PKG.LOCK_ROW (+)');
180:
181: open c1;
182: fetch c1 into tlinfo;
183: if (c1%notfound) then

Line 342: PNP_DEBUG_PKG.debug ('PN_VAR_LINE_TEMPLATES_PKG.LOCK_ROW (-)');

338: else
339: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE15', to_char(tlinfo.ATTRIBUTE15));
340: end if;
341:
342: PNP_DEBUG_PKG.debug ('PN_VAR_LINE_TEMPLATES_PKG.LOCK_ROW (-)');
343:
344: END LOCK_ROW;
345:
346: -----------------------------------------------------------------------

Line 380: PNP_DEBUG_PKG.debug ('PN_VAR_LINE_TEMPLATES_PKG.UPDATE_ROW (+)');

376: l_return_status VARCHAR2(30) := NULL;
377:
378: BEGIN
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,

Line 415: PNP_DEBUG_PKG.debug ('PN_VAR_LINE_TEMPLATES_PKG.UPDATE_ROW (+)');

411: if (sql%notfound) then
412: raise no_data_found;
413: end if;
414:
415: PNP_DEBUG_PKG.debug ('PN_VAR_LINE_TEMPLATES_PKG.UPDATE_ROW (+)');
416:
417: END UPDATE_ROW;
418:
419: -----------------------------------------------------------------------

Line 428: PNP_DEBUG_PKG.debug ('PN_VAR_LINE_TEMPLATES_PKG.DELETE_ROW (+)');

424: ) is
425:
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:

Line 437: PNP_DEBUG_PKG.debug ('PN_VAR_LINE_TEMPLATES_PKG.DELETE_ROW (-)');

433: if (sql%notfound) then
434: raise no_data_found;
435: end if;
436:
437: PNP_DEBUG_PKG.debug ('PN_VAR_LINE_TEMPLATES_PKG.DELETE_ROW (-)');
438:
439: END DELETE_ROW;
440:
441: END PN_VAR_LINE_TEMPLATES_PKG;