DBA Data[Home] [Help]

APPS.CSD_REPAIR_HISTORY_PKG dependencies on CSD_GEN_UTILITY_PVT

Line 14: l_debug NUMBER := csd_gen_utility_pvt.g_debug_level;

10:
11:
12: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSD_REPAIR_HISTORY_PKG';
13: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csdtrehb.pls';
14: l_debug NUMBER := csd_gen_utility_pvt.g_debug_level;
15:
16: -- travi 020502 obj ver num
17: PROCEDURE Insert_Row(
18: px_REPAIR_HISTORY_ID IN OUT NOCOPY NUMBER,

Line 90: csd_gen_utility_pvt.add('CSD_REPAIR_HISTORY_PKG.Insert_Row before inserting');

86: CLOSE C2;
87: End If;
88: -- travi 020502 obj ver num
89: IF l_debug > 0 THEN
90: csd_gen_utility_pvt.add('CSD_REPAIR_HISTORY_PKG.Insert_Row before inserting');
91: END IF;
92:
93: INSERT INTO CSD_REPAIR_HISTORY(
94: REPAIR_HISTORY_ID,

Line 224: csd_gen_utility_pvt.add('CSD_REPAIR_HISTORY_PKG.Insert_Row after inserting');

220: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
221: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
222: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN));
223: IF l_debug > 0 THEN
224: csd_gen_utility_pvt.add('CSD_REPAIR_HISTORY_PKG.Insert_Row after inserting');
225: END IF;
226:
227: End Insert_Row;
228:

Line 297: csd_gen_utility_pvt.add('CSD_REPAIR_HISTORY_PKG.Update_Row before update');

293: IS
294: BEGIN
295: -- travi 020502 obj ver num
296: IF l_debug = 'Y' THEN
297: csd_gen_utility_pvt.add('CSD_REPAIR_HISTORY_PKG.Update_Row before update');
298: END IF;
299:
300: Update CSD_REPAIR_HISTORY
301: SET

Line 367: csd_gen_utility_pvt.add('CSD_REPAIR_HISTORY_PKG.Update_Row after update ');

363: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
364: where REPAIR_HISTORY_ID = p_REPAIR_HISTORY_ID;
365:
366: IF l_debug = 'Y' THEN
367: csd_gen_utility_pvt.add('CSD_REPAIR_HISTORY_PKG.Update_Row after update ');
368: END IF;
369:
370: If (SQL%NOTFOUND) then
371: RAISE NO_DATA_FOUND;