DBA Data[Home] [Help]

APPS.CSD_REPAIR_JOB_XREF_PVT dependencies on CSD_REPAIR_JOB_XREF_PVT

Line 1: PACKAGE BODY CSD_REPAIR_JOB_XREF_PVT as

1: PACKAGE BODY CSD_REPAIR_JOB_XREF_PVT as
2: /* $Header: csdvdrjb.pls 115.13 2003/09/15 21:34:28 sragunat ship $ */
3: -- Start of Comments
4: -- Package name : CSD_REPAIR_JOB_XREF_PVT
5: -- Purpose :

Line 4: -- Package name : CSD_REPAIR_JOB_XREF_PVT

1: PACKAGE BODY CSD_REPAIR_JOB_XREF_PVT as
2: /* $Header: csdvdrjb.pls 115.13 2003/09/15 21:34:28 sragunat ship $ */
3: -- Start of Comments
4: -- Package name : CSD_REPAIR_JOB_XREF_PVT
5: -- Purpose :
6: -- History : Added Inventory_Item_ID and Item_Revison Columns -- travi
7: -- History : 01/17/2002, TRAVI added column OBJECT_VERSION_NUMBER
8: -- History : 08/20/2003, Shiv Ragunathan, 11.5.10 Changes: Made

Line 16: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSD_REPAIR_JOB_XREF_PVT';

12: -- NOTE :
13: -- End of Comments
14:
15:
16: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSD_REPAIR_JOB_XREF_PVT';
17: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csdvrjxb.pls';
18:
19: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
20: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

Line 318: l_ref_REPJOBXREF_rec CSD_repair_job_xref_PVT.REPJOBXREF_Rec_Type;

314: l_api_name CONSTANT VARCHAR2(30) := 'Update_repjobxref';
315: l_api_version_number CONSTANT NUMBER := 2.0;
316: -- Local Variables
317: l_identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;
318: l_ref_REPJOBXREF_rec CSD_repair_job_xref_PVT.REPJOBXREF_Rec_Type;
319: l_tar_REPJOBXREF_rec CSD_repair_job_xref_PVT.REPJOBXREF_Rec_Type := P_REPJOBXREF_Rec;
320: l_rowid ROWID;
321: BEGIN
322: -- Standard Start of API savepoint

Line 319: l_tar_REPJOBXREF_rec CSD_repair_job_xref_PVT.REPJOBXREF_Rec_Type := P_REPJOBXREF_Rec;

315: l_api_version_number CONSTANT NUMBER := 2.0;
316: -- Local Variables
317: l_identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;
318: l_ref_REPJOBXREF_rec CSD_repair_job_xref_PVT.REPJOBXREF_Rec_Type;
319: l_tar_REPJOBXREF_rec CSD_repair_job_xref_PVT.REPJOBXREF_Rec_Type := P_REPJOBXREF_Rec;
320: l_rowid ROWID;
321: BEGIN
322: -- Standard Start of API savepoint
323: SAVEPOINT UPDATE_REPJOBXREF_PVT;

Line 1681: csd_gen_utility_pvt.add('CSD_REPAIR_JOB_XREF_PVT.Validate_OBJECT_VERSION_NUMBER in procedure');

1677:
1678: BEGIN
1679:
1680: IF (g_debug > 0 ) THEN
1681: csd_gen_utility_pvt.add('CSD_REPAIR_JOB_XREF_PVT.Validate_OBJECT_VERSION_NUMBER in procedure');
1682: END IF;
1683:
1684:
1685: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1699: csd_gen_utility_pvt.add('CSD_REPAIR_JOB_XREF_PVT.Validate_OBJECT_VERSION_NUMBER in create');

1695: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1696: THEN
1697:
1698: IF (g_debug > 0 ) THEN
1699: csd_gen_utility_pvt.add('CSD_REPAIR_JOB_XREF_PVT.Validate_OBJECT_VERSION_NUMBER in create');
1700: END IF;
1701:
1702: IF (g_debug > 0 ) THEN
1703: csd_gen_utility_pvt.add('CSD_REPAIR_JOB_XREF_PVT.Validate_OBJECT_VERSION_NUMBER ovn '||to_char(p_OBJECT_VERSION_NUMBER));

Line 1703: csd_gen_utility_pvt.add('CSD_REPAIR_JOB_XREF_PVT.Validate_OBJECT_VERSION_NUMBER ovn '||to_char(p_OBJECT_VERSION_NUMBER));

1699: csd_gen_utility_pvt.add('CSD_REPAIR_JOB_XREF_PVT.Validate_OBJECT_VERSION_NUMBER in create');
1700: END IF;
1701:
1702: IF (g_debug > 0 ) THEN
1703: csd_gen_utility_pvt.add('CSD_REPAIR_JOB_XREF_PVT.Validate_OBJECT_VERSION_NUMBER ovn '||to_char(p_OBJECT_VERSION_NUMBER));
1704: END IF;
1705:
1706:
1707: -- verify if data is valid

Line 1717: csd_gen_utility_pvt.add('CSD_REPAIR_JOB_XREF_PVT.Validate_OBJECT_VERSION_NUMBER in update');

1713: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
1714: THEN
1715:
1716: IF (g_debug > 0 ) THEN
1717: csd_gen_utility_pvt.add('CSD_REPAIR_JOB_XREF_PVT.Validate_OBJECT_VERSION_NUMBER in update');
1718: END IF;
1719:
1720: IF (g_debug > 0 ) THEN
1721: csd_gen_utility_pvt.add('CSD_REPAIR_JOB_XREF_PVT.Validate_OBJECT_VERSION_NUMBER ovn from form '||to_char(p_OBJECT_VERSION_NUMBER));

Line 1721: csd_gen_utility_pvt.add('CSD_REPAIR_JOB_XREF_PVT.Validate_OBJECT_VERSION_NUMBER ovn from form '||to_char(p_OBJECT_VERSION_NUMBER));

1717: csd_gen_utility_pvt.add('CSD_REPAIR_JOB_XREF_PVT.Validate_OBJECT_VERSION_NUMBER in update');
1718: END IF;
1719:
1720: IF (g_debug > 0 ) THEN
1721: csd_gen_utility_pvt.add('CSD_REPAIR_JOB_XREF_PVT.Validate_OBJECT_VERSION_NUMBER ovn from form '||to_char(p_OBJECT_VERSION_NUMBER));
1722: END IF;
1723:
1724:
1725: -- verify if data is valid

Line 1732: csd_gen_utility_pvt.add('CSD_REPAIR_JOB_XREF_PVT.Validate_OBJECT_VERSION_NUMBER ovn from db '||to_char(l_OBJECT_VERSION_NUMBER));

1728: FROM CSD_REPAIR_JOB_XREF
1729: WHERE REPAIR_JOB_XREF_ID = P_REPAIR_JOB_XREF_ID;
1730:
1731: IF (g_debug > 0 ) THEN
1732: csd_gen_utility_pvt.add('CSD_REPAIR_JOB_XREF_PVT.Validate_OBJECT_VERSION_NUMBER ovn from db '||to_char(l_OBJECT_VERSION_NUMBER));
1733: END IF;
1734:
1735:
1736: if (l_OBJECT_VERSION_NUMBER <> p_OBJECT_VERSION_NUMBER) then

Line 1741: csd_gen_utility_pvt.add('CSD_REPAIR_JOB_XREF_PVT.Validate_OBJECT_VERSION_NUMBER ovn mismatch error');

1737: -- data is not valid
1738: x_return_status := FND_API.G_RET_STS_ERROR;
1739:
1740: IF (g_debug > 0 ) THEN
1741: csd_gen_utility_pvt.add('CSD_REPAIR_JOB_XREF_PVT.Validate_OBJECT_VERSION_NUMBER ovn mismatch error');
1742: END IF;
1743:
1744:
1745: end if;

Line 1941: End CSD_REPair_JOB_XREF_PVT;

1937: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: ' || l_api_name || 'end');
1938:
1939: END Validate_repjobxref;
1940:
1941: End CSD_REPair_JOB_XREF_PVT;