APPS.CSD_REPAIR_JOB_XREF_PKG dependencies on CSD_REPAIR_JOB_XREF

Line 1: PACKAGE BODY CSD_REPAIR_JOB_XREF_PKG as

1: PACKAGE BODY CSD_REPAIR_JOB_XREF_PKG as
2: /* $Header: csdtdrjb.pls 115.12 2003/09/15 21:32:59 sragunat ship $ */
3: -- Start of Comments
4: -- Package name : CSD_REPAIR_JOB_XREF_PKG
5: -- Purpose :

Line 4: -- Package name : CSD_REPAIR_JOB_XREF_PKG

1: PACKAGE BODY CSD_REPAIR_JOB_XREF_PKG as
2: /* $Header: csdtdrjb.pls 115.12 2003/09/15 21:32:59 sragunat ship $ */
3: -- Start of Comments
4: -- Package name : CSD_REPAIR_JOB_XREF_PKG
5: -- Purpose :
6: -- History : Added Columns Inventory_Item_ID and Item_Revision -- travi
7: -- History : 01/17/2002, TRAVI added column OBJECT_VERSION_NUMBER
8: -- History : 08/20/2003, Shiv Ragunathan, 11.5.10 Changes: Added parameters

Line 15: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSD_REPAIR_JOB_XREF_PKG';

11: -- NOTE :
12: -- End of Comments
13:
14:
15: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSD_REPAIR_JOB_XREF_PKG';
16: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csdtrjxb.pls';
17: l_debug NUMBER := csd_gen_utility_pvt.g_debug_level;
18:
19: PROCEDURE Insert_Row(

Line 57: CURSOR C2 IS SELECT CSD_REPAIR_JOB_XREF_S1.nextval FROM sys.dual;

53: p_ATTRIBUTE15 VARCHAR2,
54: P_QUANTITY_COMPLETED NUMBER)
55:
56: IS
57: CURSOR C2 IS SELECT CSD_REPAIR_JOB_XREF_S1.nextval FROM sys.dual;
58: BEGIN
59: If (px_REPAIR_JOB_XREF_ID IS NULL) OR (px_REPAIR_JOB_XREF_ID = FND_API.G_MISS_NUM) then
60: OPEN C2;
61: FETCH C2 INTO px_REPAIR_JOB_XREF_ID;

Line 66: csd_gen_utility_pvt.add('CSD_REPAIR_JOB_XREF_PKG.Insert_Row OVN : '||to_char(p_OBJECT_VERSION_NUMBER));

62: CLOSE C2;
63: End If;
64:
65: IF l_debug > 0 THEN
66: csd_gen_utility_pvt.add('CSD_REPAIR_JOB_XREF_PKG.Insert_Row OVN : '||to_char(p_OBJECT_VERSION_NUMBER));
67: END IF;
68:
69: INSERT INTO CSD_REPAIR_JOB_XREF(
70: REPAIR_JOB_XREF_ID,

Line 69: INSERT INTO CSD_REPAIR_JOB_XREF(

65: IF l_debug > 0 THEN
66: csd_gen_utility_pvt.add('CSD_REPAIR_JOB_XREF_PKG.Insert_Row OVN : '||to_char(p_OBJECT_VERSION_NUMBER));
67: END IF;
68:
69: INSERT INTO CSD_REPAIR_JOB_XREF(
70: REPAIR_JOB_XREF_ID,
71: CREATED_BY,
72: CREATION_DATE,
73: LAST_UPDATED_BY,

Line 180: csd_gen_utility_pvt.add('CSD_REPAIR_JOB_XREF_PKG.Update_Row OVN : '||to_char(p_OBJECT_VERSION_NUMBER));

176: IS
177: BEGIN
178:
179: IF l_debug > 0 THEN
180: csd_gen_utility_pvt.add('CSD_REPAIR_JOB_XREF_PKG.Update_Row OVN : '||to_char(p_OBJECT_VERSION_NUMBER));
181: END IF;
182:
183: Update CSD_REPAIR_JOB_XREF
184: SET

Line 183: Update CSD_REPAIR_JOB_XREF

179: IF l_debug > 0 THEN
180: csd_gen_utility_pvt.add('CSD_REPAIR_JOB_XREF_PKG.Update_Row OVN : '||to_char(p_OBJECT_VERSION_NUMBER));
181: END IF;
182:
183: Update CSD_REPAIR_JOB_XREF
184: SET
185: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
186: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
187: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),

Line 229: DELETE FROM CSD_REPAIR_JOB_XREF

225: PROCEDURE Delete_Row(
226: p_REPAIR_JOB_XREF_ID NUMBER)
227: IS
228: BEGIN
229: DELETE FROM CSD_REPAIR_JOB_XREF
230: WHERE REPAIR_JOB_XREF_ID = p_REPAIR_JOB_XREF_ID;
231: If (SQL%NOTFOUND) then
232: RAISE NO_DATA_FOUND;
233: End If;

Line 272: FROM CSD_REPAIR_JOB_XREF

268:
269: IS
270: CURSOR C IS
271: SELECT *
272: FROM CSD_REPAIR_JOB_XREF
273: WHERE REPAIR_JOB_XREF_ID = p_REPAIR_JOB_XREF_ID
274: FOR UPDATE of REPAIR_JOB_XREF_ID NOWAIT;
275: Recinfo C%ROWTYPE;
276: BEGIN

Line 387: End CSD_REPAIR_JOB_XREF_PKG;

383: APP_EXCEPTION.RAISE_EXCEPTION;
384: End If;
385: END Lock_Row;
386:
387: End CSD_REPAIR_JOB_XREF_PKG;