eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSD_REPAIR_JOB_XREF_PVT dependencies on CSD_REPAIR_JOB_XREF

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 144: -- Invoke table handler(CSD_REPAIR_JOB_XREF_PKG.Insert_Row)

140:
141: -- Debug Message
142: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Calling create table handler');
143:
144: -- Invoke table handler(CSD_REPAIR_JOB_XREF_PKG.Insert_Row)
145: CSD_REPAIR_JOB_XREF_PKG.Insert_Row(
146: px_REPAIR_JOB_XREF_ID => x_REPAIR_JOB_XREF_ID,
147: p_CREATED_BY => G_USER_ID,
148: p_CREATION_DATE => SYSDATE,

Line 145: CSD_REPAIR_JOB_XREF_PKG.Insert_Row(

141: -- Debug Message
142: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Calling create table handler');
143:
144: -- Invoke table handler(CSD_REPAIR_JOB_XREF_PKG.Insert_Row)
145: CSD_REPAIR_JOB_XREF_PKG.Insert_Row(
146: px_REPAIR_JOB_XREF_ID => x_REPAIR_JOB_XREF_ID,
147: p_CREATED_BY => G_USER_ID,
148: p_CREATION_DATE => SYSDATE,
149: p_LAST_UPDATED_BY => G_USER_ID,

Line 309: From CSD_REPAIR_JOB_XREF

305: ATTRIBUTE13,
306: ATTRIBUTE14,
307: ATTRIBUTE15,
308: QUANTITY_COMPLETED
309: From CSD_REPAIR_JOB_XREF
310: -- Hint: Developer need to provide Where clause
311: For Update OBJECT_VERSION_NUMBER NOWAIT;
312: -- travi added the OBJECT_VERSION_NUMBER to above line
313: */

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 487: -- Invoke table handler(CSD_REPAIR_JOB_XREF_PKG.Update_Row)

483: -- Debug Message
484: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Calling update table handler');
485:
486: -- travi changes
487: -- Invoke table handler(CSD_REPAIR_JOB_XREF_PKG.Update_Row)
488: CSD_REPAIR_JOB_XREF_PKG.Update_Row(
489: p_REPAIR_JOB_XREF_ID => p_REPJOBXREF_rec.REPAIR_JOB_XREF_ID,
490: p_CREATED_BY => G_USER_ID,
491: p_CREATION_DATE => SYSDATE,

Line 488: CSD_REPAIR_JOB_XREF_PKG.Update_Row(

484: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Calling update table handler');
485:
486: -- travi changes
487: -- Invoke table handler(CSD_REPAIR_JOB_XREF_PKG.Update_Row)
488: CSD_REPAIR_JOB_XREF_PKG.Update_Row(
489: p_REPAIR_JOB_XREF_ID => p_REPJOBXREF_rec.REPAIR_JOB_XREF_ID,
490: p_CREATED_BY => G_USER_ID,
491: p_CREATION_DATE => SYSDATE,
492: p_LAST_UPDATED_BY => G_USER_ID,

Line 678: -- Invoke table handler(CSD_REPAIR_JOB_XREF_PKG.Delete_Row)

674: */
675: -- Debug Message
676: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Calling delete table handler');
677:
678: -- Invoke table handler(CSD_REPAIR_JOB_XREF_PKG.Delete_Row)
679: CSD_REPAIR_JOB_XREF_PKG.Delete_Row(
680: p_REPAIR_JOB_XREF_ID => p_REPJOBXREF_rec.REPAIR_JOB_XREF_ID);
681: --
682: -- End of API body

Line 679: CSD_REPAIR_JOB_XREF_PKG.Delete_Row(

675: -- Debug Message
676: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Calling delete table handler');
677:
678: -- Invoke table handler(CSD_REPAIR_JOB_XREF_PKG.Delete_Row)
679: CSD_REPAIR_JOB_XREF_PKG.Delete_Row(
680: p_REPAIR_JOB_XREF_ID => p_REPJOBXREF_rec.REPAIR_JOB_XREF_ID);
681: --
682: -- End of API body
683: --

Line 767: -- define all columns for CSD_REPAIR_JOB_XREF_V view

763: -- Debug Message
764: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Define Columns Begins');
765:
766: -- travi changes
767: -- define all columns for CSD_REPAIR_JOB_XREF_V view
768: dbms_sql.define_column(p_cur_get_REPJOBXREF, 1, P_REPJOBXREF_Rec.REPAIR_JOB_XREF_ID);
769: dbms_sql.define_column(p_cur_get_REPJOBXREF, 2, P_REPJOBXREF_Rec.REPAIR_LINE_ID);
770: dbms_sql.define_column(p_cur_get_REPJOBXREF, 3, P_REPJOBXREF_Rec.WIP_ENTITY_ID);
771: dbms_sql.define_column(p_cur_get_REPJOBXREF, 4, P_REPJOBXREF_Rec.GROUP_ID);

Line 811: -- get all column values for CSD_REPAIR_JOB_XREF_V table

807: -- Debug Message
808: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Get Column Values Begins');
809:
810: -- travi changes
811: -- get all column values for CSD_REPAIR_JOB_XREF_V table
812: dbms_sql.column_value(p_cur_get_REPJOBXREF, 1, X_REPJOBXREF_Rec.REPAIR_JOB_XREF_ID);
813: dbms_sql.column_value(p_cur_get_REPJOBXREF, 2, X_REPJOBXREF_Rec.REPAIR_LINE_ID);
814: dbms_sql.column_value(p_cur_get_REPJOBXREF, 3, X_REPJOBXREF_Rec.WIP_ENTITY_ID);
815: dbms_sql.column_value(p_cur_get_REPJOBXREF, 4, X_REPJOBXREF_Rec.GROUP_ID);

Line 920: 'CSD_REPAIR_JOB_XREF_V.REPAIR_JOB_XREF_ID,' ||

916: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Generate Select Begins');
917:
918: -- travi changes
919: x_select_cl := 'Select ' ||
920: 'CSD_REPAIR_JOB_XREF_V.REPAIR_JOB_XREF_ID,' ||
921: 'CSD_REPAIR_JOB_XREF_V.CREATED_BY,' ||
922: 'CSD_REPAIR_JOB_XREF_V.CREATION_DATE,' ||
923: 'CSD_REPAIR_JOB_XREF_V.LAST_UPDATED_BY,' ||
924: 'CSD_REPAIR_JOB_XREF_V.LAST_UPDATE_DATE,' ||

Line 921: 'CSD_REPAIR_JOB_XREF_V.CREATED_BY,' ||

917:
918: -- travi changes
919: x_select_cl := 'Select ' ||
920: 'CSD_REPAIR_JOB_XREF_V.REPAIR_JOB_XREF_ID,' ||
921: 'CSD_REPAIR_JOB_XREF_V.CREATED_BY,' ||
922: 'CSD_REPAIR_JOB_XREF_V.CREATION_DATE,' ||
923: 'CSD_REPAIR_JOB_XREF_V.LAST_UPDATED_BY,' ||
924: 'CSD_REPAIR_JOB_XREF_V.LAST_UPDATE_DATE,' ||
925: 'CSD_REPAIR_JOB_XREF_V.LAST_UPDATE_LOGIN,' ||

Line 922: 'CSD_REPAIR_JOB_XREF_V.CREATION_DATE,' ||

918: -- travi changes
919: x_select_cl := 'Select ' ||
920: 'CSD_REPAIR_JOB_XREF_V.REPAIR_JOB_XREF_ID,' ||
921: 'CSD_REPAIR_JOB_XREF_V.CREATED_BY,' ||
922: 'CSD_REPAIR_JOB_XREF_V.CREATION_DATE,' ||
923: 'CSD_REPAIR_JOB_XREF_V.LAST_UPDATED_BY,' ||
924: 'CSD_REPAIR_JOB_XREF_V.LAST_UPDATE_DATE,' ||
925: 'CSD_REPAIR_JOB_XREF_V.LAST_UPDATE_LOGIN,' ||
926: 'CSD_REPAIR_JOB_XREF_V.REPAIR_LINE_ID,' ||

Line 923: 'CSD_REPAIR_JOB_XREF_V.LAST_UPDATED_BY,' ||

919: x_select_cl := 'Select ' ||
920: 'CSD_REPAIR_JOB_XREF_V.REPAIR_JOB_XREF_ID,' ||
921: 'CSD_REPAIR_JOB_XREF_V.CREATED_BY,' ||
922: 'CSD_REPAIR_JOB_XREF_V.CREATION_DATE,' ||
923: 'CSD_REPAIR_JOB_XREF_V.LAST_UPDATED_BY,' ||
924: 'CSD_REPAIR_JOB_XREF_V.LAST_UPDATE_DATE,' ||
925: 'CSD_REPAIR_JOB_XREF_V.LAST_UPDATE_LOGIN,' ||
926: 'CSD_REPAIR_JOB_XREF_V.REPAIR_LINE_ID,' ||
927: 'CSD_REPAIR_JOB_XREF_V.WIP_ENTITY_ID,' ||

Line 924: 'CSD_REPAIR_JOB_XREF_V.LAST_UPDATE_DATE,' ||

920: 'CSD_REPAIR_JOB_XREF_V.REPAIR_JOB_XREF_ID,' ||
921: 'CSD_REPAIR_JOB_XREF_V.CREATED_BY,' ||
922: 'CSD_REPAIR_JOB_XREF_V.CREATION_DATE,' ||
923: 'CSD_REPAIR_JOB_XREF_V.LAST_UPDATED_BY,' ||
924: 'CSD_REPAIR_JOB_XREF_V.LAST_UPDATE_DATE,' ||
925: 'CSD_REPAIR_JOB_XREF_V.LAST_UPDATE_LOGIN,' ||
926: 'CSD_REPAIR_JOB_XREF_V.REPAIR_LINE_ID,' ||
927: 'CSD_REPAIR_JOB_XREF_V.WIP_ENTITY_ID,' ||
928: 'CSD_REPAIR_JOB_XREF_V.GROUP_ID,' ||

Line 925: 'CSD_REPAIR_JOB_XREF_V.LAST_UPDATE_LOGIN,' ||

921: 'CSD_REPAIR_JOB_XREF_V.CREATED_BY,' ||
922: 'CSD_REPAIR_JOB_XREF_V.CREATION_DATE,' ||
923: 'CSD_REPAIR_JOB_XREF_V.LAST_UPDATED_BY,' ||
924: 'CSD_REPAIR_JOB_XREF_V.LAST_UPDATE_DATE,' ||
925: 'CSD_REPAIR_JOB_XREF_V.LAST_UPDATE_LOGIN,' ||
926: 'CSD_REPAIR_JOB_XREF_V.REPAIR_LINE_ID,' ||
927: 'CSD_REPAIR_JOB_XREF_V.WIP_ENTITY_ID,' ||
928: 'CSD_REPAIR_JOB_XREF_V.GROUP_ID,' ||
929: 'CSD_REPAIR_JOB_XREF_V.ORGANIZATION_ID,' ||

Line 926: 'CSD_REPAIR_JOB_XREF_V.REPAIR_LINE_ID,' ||

922: 'CSD_REPAIR_JOB_XREF_V.CREATION_DATE,' ||
923: 'CSD_REPAIR_JOB_XREF_V.LAST_UPDATED_BY,' ||
924: 'CSD_REPAIR_JOB_XREF_V.LAST_UPDATE_DATE,' ||
925: 'CSD_REPAIR_JOB_XREF_V.LAST_UPDATE_LOGIN,' ||
926: 'CSD_REPAIR_JOB_XREF_V.REPAIR_LINE_ID,' ||
927: 'CSD_REPAIR_JOB_XREF_V.WIP_ENTITY_ID,' ||
928: 'CSD_REPAIR_JOB_XREF_V.GROUP_ID,' ||
929: 'CSD_REPAIR_JOB_XREF_V.ORGANIZATION_ID,' ||
930: 'CSD_REPAIR_JOB_XREF_V.QUANTITY,' ||

Line 927: 'CSD_REPAIR_JOB_XREF_V.WIP_ENTITY_ID,' ||

923: 'CSD_REPAIR_JOB_XREF_V.LAST_UPDATED_BY,' ||
924: 'CSD_REPAIR_JOB_XREF_V.LAST_UPDATE_DATE,' ||
925: 'CSD_REPAIR_JOB_XREF_V.LAST_UPDATE_LOGIN,' ||
926: 'CSD_REPAIR_JOB_XREF_V.REPAIR_LINE_ID,' ||
927: 'CSD_REPAIR_JOB_XREF_V.WIP_ENTITY_ID,' ||
928: 'CSD_REPAIR_JOB_XREF_V.GROUP_ID,' ||
929: 'CSD_REPAIR_JOB_XREF_V.ORGANIZATION_ID,' ||
930: 'CSD_REPAIR_JOB_XREF_V.QUANTITY,' ||
931: 'CSD_REPAIR_JOB_XREF_V.INVENTORY_ITEM_ID,' ||

Line 928: 'CSD_REPAIR_JOB_XREF_V.GROUP_ID,' ||

924: 'CSD_REPAIR_JOB_XREF_V.LAST_UPDATE_DATE,' ||
925: 'CSD_REPAIR_JOB_XREF_V.LAST_UPDATE_LOGIN,' ||
926: 'CSD_REPAIR_JOB_XREF_V.REPAIR_LINE_ID,' ||
927: 'CSD_REPAIR_JOB_XREF_V.WIP_ENTITY_ID,' ||
928: 'CSD_REPAIR_JOB_XREF_V.GROUP_ID,' ||
929: 'CSD_REPAIR_JOB_XREF_V.ORGANIZATION_ID,' ||
930: 'CSD_REPAIR_JOB_XREF_V.QUANTITY,' ||
931: 'CSD_REPAIR_JOB_XREF_V.INVENTORY_ITEM_ID,' ||
932: 'CSD_REPAIR_JOB_XREF_V.ITEM_REVISION,' ||

Line 929: 'CSD_REPAIR_JOB_XREF_V.ORGANIZATION_ID,' ||

925: 'CSD_REPAIR_JOB_XREF_V.LAST_UPDATE_LOGIN,' ||
926: 'CSD_REPAIR_JOB_XREF_V.REPAIR_LINE_ID,' ||
927: 'CSD_REPAIR_JOB_XREF_V.WIP_ENTITY_ID,' ||
928: 'CSD_REPAIR_JOB_XREF_V.GROUP_ID,' ||
929: 'CSD_REPAIR_JOB_XREF_V.ORGANIZATION_ID,' ||
930: 'CSD_REPAIR_JOB_XREF_V.QUANTITY,' ||
931: 'CSD_REPAIR_JOB_XREF_V.INVENTORY_ITEM_ID,' ||
932: 'CSD_REPAIR_JOB_XREF_V.ITEM_REVISION,' ||
933: 'CSD_REPAIR_JOB_XREF_V.OBJECT_VERSION_NUMBER,' ||

Line 930: 'CSD_REPAIR_JOB_XREF_V.QUANTITY,' ||

926: 'CSD_REPAIR_JOB_XREF_V.REPAIR_LINE_ID,' ||
927: 'CSD_REPAIR_JOB_XREF_V.WIP_ENTITY_ID,' ||
928: 'CSD_REPAIR_JOB_XREF_V.GROUP_ID,' ||
929: 'CSD_REPAIR_JOB_XREF_V.ORGANIZATION_ID,' ||
930: 'CSD_REPAIR_JOB_XREF_V.QUANTITY,' ||
931: 'CSD_REPAIR_JOB_XREF_V.INVENTORY_ITEM_ID,' ||
932: 'CSD_REPAIR_JOB_XREF_V.ITEM_REVISION,' ||
933: 'CSD_REPAIR_JOB_XREF_V.OBJECT_VERSION_NUMBER,' ||
934: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE_CATEGORY,' ||

Line 931: 'CSD_REPAIR_JOB_XREF_V.INVENTORY_ITEM_ID,' ||

927: 'CSD_REPAIR_JOB_XREF_V.WIP_ENTITY_ID,' ||
928: 'CSD_REPAIR_JOB_XREF_V.GROUP_ID,' ||
929: 'CSD_REPAIR_JOB_XREF_V.ORGANIZATION_ID,' ||
930: 'CSD_REPAIR_JOB_XREF_V.QUANTITY,' ||
931: 'CSD_REPAIR_JOB_XREF_V.INVENTORY_ITEM_ID,' ||
932: 'CSD_REPAIR_JOB_XREF_V.ITEM_REVISION,' ||
933: 'CSD_REPAIR_JOB_XREF_V.OBJECT_VERSION_NUMBER,' ||
934: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE_CATEGORY,' ||
935: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE1,' ||

Line 932: 'CSD_REPAIR_JOB_XREF_V.ITEM_REVISION,' ||

928: 'CSD_REPAIR_JOB_XREF_V.GROUP_ID,' ||
929: 'CSD_REPAIR_JOB_XREF_V.ORGANIZATION_ID,' ||
930: 'CSD_REPAIR_JOB_XREF_V.QUANTITY,' ||
931: 'CSD_REPAIR_JOB_XREF_V.INVENTORY_ITEM_ID,' ||
932: 'CSD_REPAIR_JOB_XREF_V.ITEM_REVISION,' ||
933: 'CSD_REPAIR_JOB_XREF_V.OBJECT_VERSION_NUMBER,' ||
934: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE_CATEGORY,' ||
935: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE1,' ||
936: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE2,' ||

Line 933: 'CSD_REPAIR_JOB_XREF_V.OBJECT_VERSION_NUMBER,' ||

929: 'CSD_REPAIR_JOB_XREF_V.ORGANIZATION_ID,' ||
930: 'CSD_REPAIR_JOB_XREF_V.QUANTITY,' ||
931: 'CSD_REPAIR_JOB_XREF_V.INVENTORY_ITEM_ID,' ||
932: 'CSD_REPAIR_JOB_XREF_V.ITEM_REVISION,' ||
933: 'CSD_REPAIR_JOB_XREF_V.OBJECT_VERSION_NUMBER,' ||
934: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE_CATEGORY,' ||
935: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE1,' ||
936: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE2,' ||
937: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE3,' ||

Line 934: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE_CATEGORY,' ||

930: 'CSD_REPAIR_JOB_XREF_V.QUANTITY,' ||
931: 'CSD_REPAIR_JOB_XREF_V.INVENTORY_ITEM_ID,' ||
932: 'CSD_REPAIR_JOB_XREF_V.ITEM_REVISION,' ||
933: 'CSD_REPAIR_JOB_XREF_V.OBJECT_VERSION_NUMBER,' ||
934: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE_CATEGORY,' ||
935: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE1,' ||
936: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE2,' ||
937: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE3,' ||
938: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE4,' ||

Line 935: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE1,' ||

931: 'CSD_REPAIR_JOB_XREF_V.INVENTORY_ITEM_ID,' ||
932: 'CSD_REPAIR_JOB_XREF_V.ITEM_REVISION,' ||
933: 'CSD_REPAIR_JOB_XREF_V.OBJECT_VERSION_NUMBER,' ||
934: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE_CATEGORY,' ||
935: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE1,' ||
936: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE2,' ||
937: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE3,' ||
938: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE4,' ||
939: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE5,' ||

Line 936: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE2,' ||

932: 'CSD_REPAIR_JOB_XREF_V.ITEM_REVISION,' ||
933: 'CSD_REPAIR_JOB_XREF_V.OBJECT_VERSION_NUMBER,' ||
934: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE_CATEGORY,' ||
935: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE1,' ||
936: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE2,' ||
937: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE3,' ||
938: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE4,' ||
939: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE5,' ||
940: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE6,' ||

Line 937: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE3,' ||

933: 'CSD_REPAIR_JOB_XREF_V.OBJECT_VERSION_NUMBER,' ||
934: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE_CATEGORY,' ||
935: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE1,' ||
936: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE2,' ||
937: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE3,' ||
938: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE4,' ||
939: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE5,' ||
940: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE6,' ||
941: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE7,' ||

Line 938: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE4,' ||

934: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE_CATEGORY,' ||
935: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE1,' ||
936: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE2,' ||
937: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE3,' ||
938: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE4,' ||
939: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE5,' ||
940: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE6,' ||
941: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE7,' ||
942: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE8,' ||

Line 939: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE5,' ||

935: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE1,' ||
936: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE2,' ||
937: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE3,' ||
938: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE4,' ||
939: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE5,' ||
940: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE6,' ||
941: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE7,' ||
942: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE8,' ||
943: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE9,' ||

Line 940: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE6,' ||

936: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE2,' ||
937: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE3,' ||
938: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE4,' ||
939: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE5,' ||
940: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE6,' ||
941: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE7,' ||
942: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE8,' ||
943: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE9,' ||
944: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE10,' ||

Line 941: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE7,' ||

937: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE3,' ||
938: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE4,' ||
939: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE5,' ||
940: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE6,' ||
941: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE7,' ||
942: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE8,' ||
943: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE9,' ||
944: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE10,' ||
945: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE11,' ||

Line 942: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE8,' ||

938: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE4,' ||
939: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE5,' ||
940: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE6,' ||
941: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE7,' ||
942: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE8,' ||
943: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE9,' ||
944: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE10,' ||
945: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE11,' ||
946: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE12,' ||

Line 943: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE9,' ||

939: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE5,' ||
940: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE6,' ||
941: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE7,' ||
942: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE8,' ||
943: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE9,' ||
944: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE10,' ||
945: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE11,' ||
946: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE12,' ||
947: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE13,' ||

Line 944: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE10,' ||

940: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE6,' ||
941: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE7,' ||
942: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE8,' ||
943: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE9,' ||
944: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE10,' ||
945: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE11,' ||
946: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE12,' ||
947: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE13,' ||
948: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE14,' ||

Line 945: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE11,' ||

941: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE7,' ||
942: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE8,' ||
943: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE9,' ||
944: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE10,' ||
945: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE11,' ||
946: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE12,' ||
947: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE13,' ||
948: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE14,' ||
949: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE15,' ||

Line 946: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE12,' ||

942: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE8,' ||
943: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE9,' ||
944: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE10,' ||
945: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE11,' ||
946: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE12,' ||
947: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE13,' ||
948: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE14,' ||
949: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE15,' ||
950: 'CSD_REPAIR_JOB_XREF_V.QUANTITY_COMPLETED,' ||

Line 947: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE13,' ||

943: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE9,' ||
944: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE10,' ||
945: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE11,' ||
946: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE12,' ||
947: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE13,' ||
948: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE14,' ||
949: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE15,' ||
950: 'CSD_REPAIR_JOB_XREF_V.QUANTITY_COMPLETED,' ||
951: 'from CSD_REPAIR_JOB_XREF_V';

Line 948: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE14,' ||

944: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE10,' ||
945: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE11,' ||
946: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE12,' ||
947: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE13,' ||
948: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE14,' ||
949: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE15,' ||
950: 'CSD_REPAIR_JOB_XREF_V.QUANTITY_COMPLETED,' ||
951: 'from CSD_REPAIR_JOB_XREF_V';
952: -- Debug Message

Line 949: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE15,' ||

945: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE11,' ||
946: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE12,' ||
947: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE13,' ||
948: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE14,' ||
949: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE15,' ||
950: 'CSD_REPAIR_JOB_XREF_V.QUANTITY_COMPLETED,' ||
951: 'from CSD_REPAIR_JOB_XREF_V';
952: -- Debug Message
953: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Generate Select Ends');

Line 950: 'CSD_REPAIR_JOB_XREF_V.QUANTITY_COMPLETED,' ||

946: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE12,' ||
947: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE13,' ||
948: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE14,' ||
949: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE15,' ||
950: 'CSD_REPAIR_JOB_XREF_V.QUANTITY_COMPLETED,' ||
951: 'from CSD_REPAIR_JOB_XREF_V';
952: -- Debug Message
953: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Generate Select Ends');
954:

Line 951: 'from CSD_REPAIR_JOB_XREF_V';

947: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE13,' ||
948: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE14,' ||
949: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE15,' ||
950: 'CSD_REPAIR_JOB_XREF_V.QUANTITY_COMPLETED,' ||
951: 'from CSD_REPAIR_JOB_XREF_V';
952: -- Debug Message
953: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Generate Select Ends');
954:
955: END Gen_Select;

Line 1185: l_flex_where_tbl_type(l_counter).name := 'CSD_REPAIR_JOB_XREF_V.attribute' || l_counter;

1181: -- Generate Where clause for flex fields
1182: -- Hint: Developer can use table/view alias in the From clause generated in Gen_Select procedure
1183:
1184: FOR l_counter IN 1..15 LOOP
1185: l_flex_where_tbl_type(l_counter).name := 'CSD_REPAIR_JOB_XREF_V.attribute' || l_counter;
1186: END LOOP;
1187:
1188: l_flex_where_tbl_type(16).name := 'CSD_REPAIR_JOB_XREF_V.attribute_category';
1189: l_flex_where_tbl_type(1).value := P_REPJOBXREF_Rec.attribute1;

Line 1188: l_flex_where_tbl_type(16).name := 'CSD_REPAIR_JOB_XREF_V.attribute_category';

1184: FOR l_counter IN 1..15 LOOP
1185: l_flex_where_tbl_type(l_counter).name := 'CSD_REPAIR_JOB_XREF_V.attribute' || l_counter;
1186: END LOOP;
1187:
1188: l_flex_where_tbl_type(16).name := 'CSD_REPAIR_JOB_XREF_V.attribute_category';
1189: l_flex_where_tbl_type(1).value := P_REPJOBXREF_Rec.attribute1;
1190: l_flex_where_tbl_type(2).value := P_REPJOBXREF_Rec.attribute2;
1191: l_flex_where_tbl_type(3).value := P_REPJOBXREF_Rec.attribute3;
1192: l_flex_where_tbl_type(4).value := P_REPJOBXREF_Rec.attribute4;

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 1728: FROM CSD_REPAIR_JOB_XREF

1724:
1725: -- verify if data is valid
1726: SELECT OBJECT_VERSION_NUMBER
1727: INTO 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));

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;