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 :
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
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(
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,
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
383: APP_EXCEPTION.RAISE_EXCEPTION;
384: End If;
385: END Lock_Row;
386:
387: End CSD_REPAIR_JOB_XREF_PKG;