APPS.CSD_REPAIR_HISTORY_PKG dependencies on CSD_REPAIR_HISTORY

Line 1: PACKAGE BODY CSD_REPAIR_HISTORY_PKG as

1: PACKAGE BODY CSD_REPAIR_HISTORY_PKG as
2: /* $Header: csdtdrhb.pls 120.1 2006/02/24 17:05:28 mshirkol noship $ */
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.1 2006/02/24 17:05:28 mshirkol noship $ */
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 81: CURSOR C2 IS SELECT CSD_REPAIR_HISTORY_S1.nextval FROM sys.dual;

77: p_ATTRIBUTE15 VARCHAR2,
78: p_LAST_UPDATE_LOGIN NUMBER)
79:
80: IS
81: CURSOR C2 IS SELECT CSD_REPAIR_HISTORY_S1.nextval FROM sys.dual;
82: BEGIN
83: If (px_REPAIR_HISTORY_ID IS NULL) OR (px_REPAIR_HISTORY_ID = FND_API.G_MISS_NUM) then
84: OPEN C2;
85: FETCH C2 INTO px_REPAIR_HISTORY_ID;

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 93: INSERT INTO CSD_REPAIR_HISTORY(

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,
95: OBJECT_VERSION_NUMBER,
96: REQUEST_ID,
97: PROGRAM_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 296: Update CSD_REPAIR_HISTORY

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
298: OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER),
299: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
300: PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID),

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;

Line 374: DELETE FROM CSD_REPAIR_HISTORY

370: p_REPAIR_HISTORY_ID NUMBER,
371: p_OBJECT_VERSION_NUMBER NUMBER)
372: IS
373: BEGIN
374: DELETE FROM CSD_REPAIR_HISTORY
375: WHERE REPAIR_HISTORY_ID = p_REPAIR_HISTORY_ID;
376: If (SQL%NOTFOUND) then
377: RAISE NO_DATA_FOUND;
378: End If;

Line 448: FROM CSD_REPAIR_HISTORY

444:
445: IS
446: CURSOR C IS
447: SELECT *
448: FROM CSD_REPAIR_HISTORY
449: WHERE REPAIR_HISTORY_ID = p_REPAIR_HISTORY_ID
450: FOR UPDATE of REPAIR_HISTORY_ID NOWAIT;
451: Recinfo C%ROWTYPE;
452: BEGIN

Line 653: End CSD_REPAIR_HISTORY_PKG;

649: APP_EXCEPTION.RAISE_EXCEPTION;
650: End If;
651: END Lock_Row;
652:
653: End CSD_REPAIR_HISTORY_PKG;