DBA Data[Home] [Help]

APPS.CSD_REPAIR_JOB_XREF_PKG dependencies on CSD_REPAIR_JOB_XREF_PKG

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 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 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 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;