APPS.CSD_REPAIR_HISTORY_PKG dependencies on CSD_REPAIR_HISTORY_PKG

Line 1: PACKAGE BODY CSD_REPAIR_HISTORY_PKG as

1: PACKAGE BODY CSD_REPAIR_HISTORY_PKG as
2: /* $Header: csdtdrhb.pls 120.2 2011/12/05 07:13:08 yvchen ship $ */
3: -- Start of Comments
4: -- Package name : CSD_REPAIR_HISTORY_PKG
5: -- Purpose :

Line 4: -- Package name : CSD_REPAIR_HISTORY_PKG

1: PACKAGE BODY CSD_REPAIR_HISTORY_PKG as
2: /* $Header: csdtdrhb.pls 120.2 2011/12/05 07:13:08 yvchen ship $ */
3: -- Start of Comments
4: -- Package name : CSD_REPAIR_HISTORY_PKG
5: -- Purpose :
6: -- History :
7: -- 02/05/02 travi Added Object Version Number Column
8: -- NOTE :

Line 12: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSD_REPAIR_HISTORY_PKG';

8: -- NOTE :
9: -- End of Comments
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

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;

Line 659: End CSD_REPAIR_HISTORY_PKG;

655: APP_EXCEPTION.RAISE_EXCEPTION;
656: End If;
657: END Lock_Row;
658:
659: End CSD_REPAIR_HISTORY_PKG;