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.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 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 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 300: Update CSD_REPAIR_HISTORY

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
302: OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER),
303: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
304: PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID),

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 380: DELETE FROM CSD_REPAIR_HISTORY

376: p_REPAIR_HISTORY_ID NUMBER,
377: p_OBJECT_VERSION_NUMBER NUMBER)
378: IS
379: BEGIN
380: DELETE FROM CSD_REPAIR_HISTORY
381: WHERE REPAIR_HISTORY_ID = p_REPAIR_HISTORY_ID;
382: If (SQL%NOTFOUND) then
383: RAISE NO_DATA_FOUND;
384: End If;

Line 454: FROM CSD_REPAIR_HISTORY

450:
451: IS
452: CURSOR C IS
453: SELECT *
454: FROM CSD_REPAIR_HISTORY
455: WHERE REPAIR_HISTORY_ID = p_REPAIR_HISTORY_ID
456: FOR UPDATE of REPAIR_HISTORY_ID NOWAIT;
457: Recinfo C%ROWTYPE;
458: BEGIN

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;