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 220: csd_gen_utility_pvt.add('CSD_REPAIR_HISTORY_PKG.Insert_Row after inserting');

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

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

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

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

357: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
358: where REPAIR_HISTORY_ID = p_REPAIR_HISTORY_ID;
359:
360: IF l_debug = 'Y' THEN
361: csd_gen_utility_pvt.add('CSD_REPAIR_HISTORY_PKG.Update_Row after update ');
362: END IF;
363:
364: If (SQL%NOTFOUND) then
365: RAISE NO_DATA_FOUND;