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_HISTORY_PVT dependencies on CSD_REPAIR_HISTORY

Line 1: PACKAGE BODY CSD_REPAIR_HISTORY_PVT as

1: PACKAGE BODY CSD_REPAIR_HISTORY_PVT as
2: /* $Header: csdvdrhb.pls 120.3.12020000.3 2013/04/04 09:32:49 subhat ship $ */
3: -- Start of Comments
4: -- Package name : CSD_REPAIR_HISTORY_PVT
5: -- Purpose :

Line 4: -- Package name : CSD_REPAIR_HISTORY_PVT

1: PACKAGE BODY CSD_REPAIR_HISTORY_PVT as
2: /* $Header: csdvdrhb.pls 120.3.12020000.3 2013/04/04 09:32:49 subhat ship $ */
3: -- Start of Comments
4: -- Package name : CSD_REPAIR_HISTORY_PVT
5: -- Purpose :
6: -- History :
7: -- 02/05/02 travi Added Object Version Number Column
8: -- NOTE :

Line 12: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSD_REPAIR_HISTORY_PVT';

8: -- NOTE :
9: -- End of Comments
10:
11:
12: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSD_REPAIR_HISTORY_PVT';
13: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csdvrehb.pls';
14:
15: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
16: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

Line 122: csd_gen_utility_pvt.add('CSD_REPAIR_HISTORY_PVT.Create_repair_history before Validate_repair_history');

118: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Validate_repair_history');
119:
120: -- Invoke validation procedures
121: IF (g_debug > 0 ) THEN
122: csd_gen_utility_pvt.add('CSD_REPAIR_HISTORY_PVT.Create_repair_history before Validate_repair_history');
123: END IF;
124:
125:
126: Validate_repair_history(

Line 136: csd_gen_utility_pvt.add('CSD_REPAIR_HISTORY_PVT.Create_repair_history after Validate_repair_history x_return_status'||x_return_status);

132: x_msg_count => x_msg_count,
133: x_msg_data => x_msg_data);
134:
135: IF (g_debug > 0 ) THEN
136: csd_gen_utility_pvt.add('CSD_REPAIR_HISTORY_PVT.Create_repair_history after Validate_repair_history x_return_status'||x_return_status);
137: END IF;
138:
139:
140: END IF;

Line 151: -- Invoke table handler(CSD_REPAIR_HISTORY_PKG.Insert_Row)

147:
148: -- Debug Message
149: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Calling create table handler');
150:
151: -- Invoke table handler(CSD_REPAIR_HISTORY_PKG.Insert_Row)
152: IF (g_debug > 0 ) THEN
153: csd_gen_utility_pvt.add('CSD_REPAIR_HISTORY_PVT.Create_repair_history before CSD_REPAIR_HISTORY_PKG.Insert_Row');
154: END IF;
155:

Line 153: csd_gen_utility_pvt.add('CSD_REPAIR_HISTORY_PVT.Create_repair_history before CSD_REPAIR_HISTORY_PKG.Insert_Row');

149: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Calling create table handler');
150:
151: -- Invoke table handler(CSD_REPAIR_HISTORY_PKG.Insert_Row)
152: IF (g_debug > 0 ) THEN
153: csd_gen_utility_pvt.add('CSD_REPAIR_HISTORY_PVT.Create_repair_history before CSD_REPAIR_HISTORY_PKG.Insert_Row');
154: END IF;
155:
156:
157: CSD_REPAIR_HISTORY_PKG.Insert_Row(

Line 157: CSD_REPAIR_HISTORY_PKG.Insert_Row(

153: csd_gen_utility_pvt.add('CSD_REPAIR_HISTORY_PVT.Create_repair_history before CSD_REPAIR_HISTORY_PKG.Insert_Row');
154: END IF;
155:
156:
157: CSD_REPAIR_HISTORY_PKG.Insert_Row(
158: px_REPAIR_HISTORY_ID => x_REPAIR_HISTORY_ID,
159: p_OBJECT_VERSION_NUMBER => 1, -- travi p_REPH_rec.OBJECT_VERSION_NUMBER,
160: p_REQUEST_ID => p_REPH_rec.REQUEST_ID,
161: p_PROGRAM_ID => p_REPH_rec.PROGRAM_ID,

Line 224: csd_gen_utility_pvt.add('CSD_REPAIR_HISTORY_PVT.Create_repair_history after CSD_REPAIR_HISTORY_PKG.Insert_Row x_return_status'||x_return_status);

220: p_LAST_UPDATE_LOGIN => p_REPH_rec.LAST_UPDATE_LOGIN);
221: -- Hint: Primary key should be returned.
222: -- x_REPAIR_HISTORY_ID := px_REPAIR_HISTORY_ID;
223: IF (g_debug > 0 ) THEN
224: csd_gen_utility_pvt.add('CSD_REPAIR_HISTORY_PVT.Create_repair_history after CSD_REPAIR_HISTORY_PKG.Insert_Row x_return_status'||x_return_status);
225: END IF;
226:
227:
228:

Line 384: From CSD_REPAIR_HISTORY

380: ATTRIBUTE13,
381: ATTRIBUTE14,
382: ATTRIBUTE15,
383: LAST_UPDATE_LOGIN
384: From CSD_REPAIR_HISTORY
385: -- Hint: Developer need to provide Where clause
386: For Update NOWAIT;
387: */
388: l_api_name CONSTANT VARCHAR2(30) := 'Update_repair_history';

Line 392: l_ref_REPH_rec CSD_repair_history_PVT.REPH_Rec_Type;

388: l_api_name CONSTANT VARCHAR2(30) := 'Update_repair_history';
389: l_api_version_number CONSTANT NUMBER := 1.0;
390: -- Local Variables
391: l_identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;
392: l_ref_REPH_rec CSD_repair_history_PVT.REPH_Rec_Type;
393: l_tar_REPH_rec CSD_repair_history_PVT.REPH_Rec_Type := P_REPH_Rec;
394: l_rowid ROWID;
395:
396: -- travi ovn validation

Line 393: l_tar_REPH_rec CSD_repair_history_PVT.REPH_Rec_Type := P_REPH_Rec;

389: l_api_version_number CONSTANT NUMBER := 1.0;
390: -- Local Variables
391: l_identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;
392: l_ref_REPH_rec CSD_repair_history_PVT.REPH_Rec_Type;
393: l_tar_REPH_rec CSD_repair_history_PVT.REPH_Rec_Type := P_REPH_Rec;
394: l_rowid ROWID;
395:
396: -- travi ovn validation
397: l_OBJECT_VERSION_NUMBER NUMBER;

Line 595: -- Invoke table handler(CSD_REPAIR_HISTORY_PKG.Update_Row)

591:
592: -- travi OBJECT_VERSION_NUMBER validation
593: l_OBJECT_VERSION_NUMBER := p_REPH_rec.OBJECT_VERSION_NUMBER + 1;
594:
595: -- Invoke table handler(CSD_REPAIR_HISTORY_PKG.Update_Row)
596: CSD_REPAIR_HISTORY_PKG.Update_Row(
597: p_REPAIR_HISTORY_ID => p_REPH_rec.REPAIR_HISTORY_ID,
598: p_OBJECT_VERSION_NUMBER => l_OBJECT_VERSION_NUMBER, -- travi p_REPH_rec.OBJECT_VERSION_NUMBER,
599: p_REQUEST_ID => p_REPH_rec.REQUEST_ID,

Line 596: CSD_REPAIR_HISTORY_PKG.Update_Row(

592: -- travi OBJECT_VERSION_NUMBER validation
593: l_OBJECT_VERSION_NUMBER := p_REPH_rec.OBJECT_VERSION_NUMBER + 1;
594:
595: -- Invoke table handler(CSD_REPAIR_HISTORY_PKG.Update_Row)
596: CSD_REPAIR_HISTORY_PKG.Update_Row(
597: p_REPAIR_HISTORY_ID => p_REPH_rec.REPAIR_HISTORY_ID,
598: p_OBJECT_VERSION_NUMBER => l_OBJECT_VERSION_NUMBER, -- travi p_REPH_rec.OBJECT_VERSION_NUMBER,
599: p_REQUEST_ID => p_REPH_rec.REQUEST_ID,
600: p_PROGRAM_ID => p_REPH_rec.PROGRAM_ID,

Line 818: -- Invoke table handler(CSD_REPAIR_HISTORY_PKG.Delete_Row)

814:
815: -- Debug Message
816: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Calling delete table handler');
817:
818: -- Invoke table handler(CSD_REPAIR_HISTORY_PKG.Delete_Row)
819: CSD_REPAIR_HISTORY_PKG.Delete_Row(
820: p_REPAIR_HISTORY_ID => p_REPH_rec.REPAIR_HISTORY_ID,
821: p_OBJECT_VERSION_NUMBER => p_REPH_rec.OBJECT_VERSION_NUMBER);
822: --

Line 819: CSD_REPAIR_HISTORY_PKG.Delete_Row(

815: -- Debug Message
816: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Calling delete table handler');
817:
818: -- Invoke table handler(CSD_REPAIR_HISTORY_PKG.Delete_Row)
819: CSD_REPAIR_HISTORY_PKG.Delete_Row(
820: p_REPAIR_HISTORY_ID => p_REPH_rec.REPAIR_HISTORY_ID,
821: p_OBJECT_VERSION_NUMBER => p_REPH_rec.OBJECT_VERSION_NUMBER);
822: --
823: -- End of API body

Line 899: P_REPH_Rec IN CSD_REPAIR_HISTORY_PVT.REPH_Rec_Type,

895:
896:
897: -- This procudure defines the columns for the Dynamic SQL.
898: PROCEDURE Define_Columns(
899: P_REPH_Rec IN CSD_REPAIR_HISTORY_PVT.REPH_Rec_Type,
900: p_cur_get_REPH IN NUMBER
901: )
902: IS
903: BEGIN

Line 907: -- define all columns for CSD_REPAIR_HISTORY_V view

903: BEGIN
904: -- Debug Message
905: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Define Columns Begins');
906:
907: -- define all columns for CSD_REPAIR_HISTORY_V view
908: dbms_sql.define_column(p_cur_get_REPH, 1, P_REPH_Rec.REPAIR_HISTORY_ID);
909: dbms_sql.define_column(p_cur_get_REPH, 2, P_REPH_Rec.REQUEST_ID);
910: dbms_sql.define_column(p_cur_get_REPH, 3, P_REPH_Rec.REPAIR_LINE_ID);
911: dbms_sql.define_column(p_cur_get_REPH, 4, P_REPH_Rec.EVENT_CODE, 30);

Line 970: X_REPH_Rec OUT NOCOPY CSD_REPAIR_HISTORY_PVT.REPH_Rec_Type

966:
967: -- This procudure gets column values by the Dynamic SQL.
968: PROCEDURE Get_Column_Values(
969: p_cur_get_REPH IN NUMBER,
970: X_REPH_Rec OUT NOCOPY CSD_REPAIR_HISTORY_PVT.REPH_Rec_Type
971: )
972: IS
973: BEGIN
974: -- Debug Message

Line 977: -- get all column values for CSD_REPAIR_HISTORY_V table

973: BEGIN
974: -- Debug Message
975: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Get Column Values Begins');
976:
977: -- get all column values for CSD_REPAIR_HISTORY_V table
978: dbms_sql.column_value(p_cur_get_REPH, 1, X_REPH_Rec.REPAIR_HISTORY_ID);
979: dbms_sql.column_value(p_cur_get_REPH, 2, X_REPH_Rec.REQUEST_ID);
980: dbms_sql.column_value(p_cur_get_REPH, 3, X_REPH_Rec.REPAIR_LINE_ID);
981: dbms_sql.column_value(p_cur_get_REPH, 4, X_REPH_Rec.EVENT_CODE);

Line 1038: p_order_by_rec IN CSD_REPAIR_HISTORY_PVT.REPH_sort_rec_type,

1034: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Get Column Values Ends');
1035: END Get_Column_Values;
1036:
1037: PROCEDURE Gen_REPH_order_cl(
1038: p_order_by_rec IN CSD_REPAIR_HISTORY_PVT.REPH_sort_rec_type,
1039: x_order_by_cl OUT NOCOPY VARCHAR2,
1040: x_return_status OUT NOCOPY VARCHAR2,
1041: x_msg_count OUT NOCOPY NUMBER,
1042: x_msg_data OUT NOCOPY VARCHAR2

Line 1081: P_REPH_Rec IN CSD_REPAIR_HISTORY_PVT.REPH_Rec_Type,

1077: END Gen_REPH_order_cl;
1078:
1079: -- This procedure bind the variables for the Dynamic SQL
1080: PROCEDURE Bind(
1081: P_REPH_Rec IN CSD_REPAIR_HISTORY_PVT.REPH_Rec_Type,
1082: -- Hint: Add more binding variables here
1083: p_cur_get_REPH IN NUMBER
1084: )
1085: IS

Line 1112: 'CSD_REPAIR_HISTORY_V.REPAIR_HISTORY_ID,' ||

1108: -- Debug Message
1109: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Generate Select Begins');
1110:
1111: x_select_cl := 'Select ' ||
1112: 'CSD_REPAIR_HISTORY_V.REPAIR_HISTORY_ID,' ||
1113: 'CSD_REPAIR_HISTORY_V.REQUEST_ID,' ||
1114: 'CSD_REPAIR_HISTORY_V.PROGRAM_ID,' ||
1115: 'CSD_REPAIR_HISTORY_V.PROGRAM_APPLICATION_ID,' ||
1116: 'CSD_REPAIR_HISTORY_V.PROGRAM_UPDATE_DATE,' ||

Line 1113: 'CSD_REPAIR_HISTORY_V.REQUEST_ID,' ||

1109: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Generate Select Begins');
1110:
1111: x_select_cl := 'Select ' ||
1112: 'CSD_REPAIR_HISTORY_V.REPAIR_HISTORY_ID,' ||
1113: 'CSD_REPAIR_HISTORY_V.REQUEST_ID,' ||
1114: 'CSD_REPAIR_HISTORY_V.PROGRAM_ID,' ||
1115: 'CSD_REPAIR_HISTORY_V.PROGRAM_APPLICATION_ID,' ||
1116: 'CSD_REPAIR_HISTORY_V.PROGRAM_UPDATE_DATE,' ||
1117: 'CSD_REPAIR_HISTORY_V.CREATED_BY,' ||

Line 1114: 'CSD_REPAIR_HISTORY_V.PROGRAM_ID,' ||

1110:
1111: x_select_cl := 'Select ' ||
1112: 'CSD_REPAIR_HISTORY_V.REPAIR_HISTORY_ID,' ||
1113: 'CSD_REPAIR_HISTORY_V.REQUEST_ID,' ||
1114: 'CSD_REPAIR_HISTORY_V.PROGRAM_ID,' ||
1115: 'CSD_REPAIR_HISTORY_V.PROGRAM_APPLICATION_ID,' ||
1116: 'CSD_REPAIR_HISTORY_V.PROGRAM_UPDATE_DATE,' ||
1117: 'CSD_REPAIR_HISTORY_V.CREATED_BY,' ||
1118: 'CSD_REPAIR_HISTORY_V.CREATION_DATE,' ||

Line 1115: 'CSD_REPAIR_HISTORY_V.PROGRAM_APPLICATION_ID,' ||

1111: x_select_cl := 'Select ' ||
1112: 'CSD_REPAIR_HISTORY_V.REPAIR_HISTORY_ID,' ||
1113: 'CSD_REPAIR_HISTORY_V.REQUEST_ID,' ||
1114: 'CSD_REPAIR_HISTORY_V.PROGRAM_ID,' ||
1115: 'CSD_REPAIR_HISTORY_V.PROGRAM_APPLICATION_ID,' ||
1116: 'CSD_REPAIR_HISTORY_V.PROGRAM_UPDATE_DATE,' ||
1117: 'CSD_REPAIR_HISTORY_V.CREATED_BY,' ||
1118: 'CSD_REPAIR_HISTORY_V.CREATION_DATE,' ||
1119: 'CSD_REPAIR_HISTORY_V.LAST_UPDATED_BY,' ||

Line 1116: 'CSD_REPAIR_HISTORY_V.PROGRAM_UPDATE_DATE,' ||

1112: 'CSD_REPAIR_HISTORY_V.REPAIR_HISTORY_ID,' ||
1113: 'CSD_REPAIR_HISTORY_V.REQUEST_ID,' ||
1114: 'CSD_REPAIR_HISTORY_V.PROGRAM_ID,' ||
1115: 'CSD_REPAIR_HISTORY_V.PROGRAM_APPLICATION_ID,' ||
1116: 'CSD_REPAIR_HISTORY_V.PROGRAM_UPDATE_DATE,' ||
1117: 'CSD_REPAIR_HISTORY_V.CREATED_BY,' ||
1118: 'CSD_REPAIR_HISTORY_V.CREATION_DATE,' ||
1119: 'CSD_REPAIR_HISTORY_V.LAST_UPDATED_BY,' ||
1120: 'CSD_REPAIR_HISTORY_V.LAST_UPDATE_DATE,' ||

Line 1117: 'CSD_REPAIR_HISTORY_V.CREATED_BY,' ||

1113: 'CSD_REPAIR_HISTORY_V.REQUEST_ID,' ||
1114: 'CSD_REPAIR_HISTORY_V.PROGRAM_ID,' ||
1115: 'CSD_REPAIR_HISTORY_V.PROGRAM_APPLICATION_ID,' ||
1116: 'CSD_REPAIR_HISTORY_V.PROGRAM_UPDATE_DATE,' ||
1117: 'CSD_REPAIR_HISTORY_V.CREATED_BY,' ||
1118: 'CSD_REPAIR_HISTORY_V.CREATION_DATE,' ||
1119: 'CSD_REPAIR_HISTORY_V.LAST_UPDATED_BY,' ||
1120: 'CSD_REPAIR_HISTORY_V.LAST_UPDATE_DATE,' ||
1121: 'CSD_REPAIR_HISTORY_V.LAST_UPDATE_LOGIN,' ||

Line 1118: 'CSD_REPAIR_HISTORY_V.CREATION_DATE,' ||

1114: 'CSD_REPAIR_HISTORY_V.PROGRAM_ID,' ||
1115: 'CSD_REPAIR_HISTORY_V.PROGRAM_APPLICATION_ID,' ||
1116: 'CSD_REPAIR_HISTORY_V.PROGRAM_UPDATE_DATE,' ||
1117: 'CSD_REPAIR_HISTORY_V.CREATED_BY,' ||
1118: 'CSD_REPAIR_HISTORY_V.CREATION_DATE,' ||
1119: 'CSD_REPAIR_HISTORY_V.LAST_UPDATED_BY,' ||
1120: 'CSD_REPAIR_HISTORY_V.LAST_UPDATE_DATE,' ||
1121: 'CSD_REPAIR_HISTORY_V.LAST_UPDATE_LOGIN,' ||
1122: 'CSD_REPAIR_HISTORY_V.REPAIR_LINE_ID,' ||

Line 1119: 'CSD_REPAIR_HISTORY_V.LAST_UPDATED_BY,' ||

1115: 'CSD_REPAIR_HISTORY_V.PROGRAM_APPLICATION_ID,' ||
1116: 'CSD_REPAIR_HISTORY_V.PROGRAM_UPDATE_DATE,' ||
1117: 'CSD_REPAIR_HISTORY_V.CREATED_BY,' ||
1118: 'CSD_REPAIR_HISTORY_V.CREATION_DATE,' ||
1119: 'CSD_REPAIR_HISTORY_V.LAST_UPDATED_BY,' ||
1120: 'CSD_REPAIR_HISTORY_V.LAST_UPDATE_DATE,' ||
1121: 'CSD_REPAIR_HISTORY_V.LAST_UPDATE_LOGIN,' ||
1122: 'CSD_REPAIR_HISTORY_V.REPAIR_LINE_ID,' ||
1123: 'CSD_REPAIR_HISTORY_V.EVENT_CODE,' ||

Line 1120: 'CSD_REPAIR_HISTORY_V.LAST_UPDATE_DATE,' ||

1116: 'CSD_REPAIR_HISTORY_V.PROGRAM_UPDATE_DATE,' ||
1117: 'CSD_REPAIR_HISTORY_V.CREATED_BY,' ||
1118: 'CSD_REPAIR_HISTORY_V.CREATION_DATE,' ||
1119: 'CSD_REPAIR_HISTORY_V.LAST_UPDATED_BY,' ||
1120: 'CSD_REPAIR_HISTORY_V.LAST_UPDATE_DATE,' ||
1121: 'CSD_REPAIR_HISTORY_V.LAST_UPDATE_LOGIN,' ||
1122: 'CSD_REPAIR_HISTORY_V.REPAIR_LINE_ID,' ||
1123: 'CSD_REPAIR_HISTORY_V.EVENT_CODE,' ||
1124: 'CSD_REPAIR_HISTORY_V.EVENT_MEANING,' ||

Line 1121: 'CSD_REPAIR_HISTORY_V.LAST_UPDATE_LOGIN,' ||

1117: 'CSD_REPAIR_HISTORY_V.CREATED_BY,' ||
1118: 'CSD_REPAIR_HISTORY_V.CREATION_DATE,' ||
1119: 'CSD_REPAIR_HISTORY_V.LAST_UPDATED_BY,' ||
1120: 'CSD_REPAIR_HISTORY_V.LAST_UPDATE_DATE,' ||
1121: 'CSD_REPAIR_HISTORY_V.LAST_UPDATE_LOGIN,' ||
1122: 'CSD_REPAIR_HISTORY_V.REPAIR_LINE_ID,' ||
1123: 'CSD_REPAIR_HISTORY_V.EVENT_CODE,' ||
1124: 'CSD_REPAIR_HISTORY_V.EVENT_MEANING,' ||
1125: 'CSD_REPAIR_HISTORY_V.EVENT_DATE,' ||

Line 1122: 'CSD_REPAIR_HISTORY_V.REPAIR_LINE_ID,' ||

1118: 'CSD_REPAIR_HISTORY_V.CREATION_DATE,' ||
1119: 'CSD_REPAIR_HISTORY_V.LAST_UPDATED_BY,' ||
1120: 'CSD_REPAIR_HISTORY_V.LAST_UPDATE_DATE,' ||
1121: 'CSD_REPAIR_HISTORY_V.LAST_UPDATE_LOGIN,' ||
1122: 'CSD_REPAIR_HISTORY_V.REPAIR_LINE_ID,' ||
1123: 'CSD_REPAIR_HISTORY_V.EVENT_CODE,' ||
1124: 'CSD_REPAIR_HISTORY_V.EVENT_MEANING,' ||
1125: 'CSD_REPAIR_HISTORY_V.EVENT_DATE,' ||
1126: 'CSD_REPAIR_HISTORY_V.QUANTITY,' ||

Line 1123: 'CSD_REPAIR_HISTORY_V.EVENT_CODE,' ||

1119: 'CSD_REPAIR_HISTORY_V.LAST_UPDATED_BY,' ||
1120: 'CSD_REPAIR_HISTORY_V.LAST_UPDATE_DATE,' ||
1121: 'CSD_REPAIR_HISTORY_V.LAST_UPDATE_LOGIN,' ||
1122: 'CSD_REPAIR_HISTORY_V.REPAIR_LINE_ID,' ||
1123: 'CSD_REPAIR_HISTORY_V.EVENT_CODE,' ||
1124: 'CSD_REPAIR_HISTORY_V.EVENT_MEANING,' ||
1125: 'CSD_REPAIR_HISTORY_V.EVENT_DATE,' ||
1126: 'CSD_REPAIR_HISTORY_V.QUANTITY,' ||
1127: 'CSD_REPAIR_HISTORY_V.PARAMN1,' ||

Line 1124: 'CSD_REPAIR_HISTORY_V.EVENT_MEANING,' ||

1120: 'CSD_REPAIR_HISTORY_V.LAST_UPDATE_DATE,' ||
1121: 'CSD_REPAIR_HISTORY_V.LAST_UPDATE_LOGIN,' ||
1122: 'CSD_REPAIR_HISTORY_V.REPAIR_LINE_ID,' ||
1123: 'CSD_REPAIR_HISTORY_V.EVENT_CODE,' ||
1124: 'CSD_REPAIR_HISTORY_V.EVENT_MEANING,' ||
1125: 'CSD_REPAIR_HISTORY_V.EVENT_DATE,' ||
1126: 'CSD_REPAIR_HISTORY_V.QUANTITY,' ||
1127: 'CSD_REPAIR_HISTORY_V.PARAMN1,' ||
1128: 'CSD_REPAIR_HISTORY_V.PARAMN2,' ||

Line 1125: 'CSD_REPAIR_HISTORY_V.EVENT_DATE,' ||

1121: 'CSD_REPAIR_HISTORY_V.LAST_UPDATE_LOGIN,' ||
1122: 'CSD_REPAIR_HISTORY_V.REPAIR_LINE_ID,' ||
1123: 'CSD_REPAIR_HISTORY_V.EVENT_CODE,' ||
1124: 'CSD_REPAIR_HISTORY_V.EVENT_MEANING,' ||
1125: 'CSD_REPAIR_HISTORY_V.EVENT_DATE,' ||
1126: 'CSD_REPAIR_HISTORY_V.QUANTITY,' ||
1127: 'CSD_REPAIR_HISTORY_V.PARAMN1,' ||
1128: 'CSD_REPAIR_HISTORY_V.PARAMN2,' ||
1129: 'CSD_REPAIR_HISTORY_V.PARAMN3,' ||

Line 1126: 'CSD_REPAIR_HISTORY_V.QUANTITY,' ||

1122: 'CSD_REPAIR_HISTORY_V.REPAIR_LINE_ID,' ||
1123: 'CSD_REPAIR_HISTORY_V.EVENT_CODE,' ||
1124: 'CSD_REPAIR_HISTORY_V.EVENT_MEANING,' ||
1125: 'CSD_REPAIR_HISTORY_V.EVENT_DATE,' ||
1126: 'CSD_REPAIR_HISTORY_V.QUANTITY,' ||
1127: 'CSD_REPAIR_HISTORY_V.PARAMN1,' ||
1128: 'CSD_REPAIR_HISTORY_V.PARAMN2,' ||
1129: 'CSD_REPAIR_HISTORY_V.PARAMN3,' ||
1130: 'CSD_REPAIR_HISTORY_V.PARAMN4,' ||

Line 1127: 'CSD_REPAIR_HISTORY_V.PARAMN1,' ||

1123: 'CSD_REPAIR_HISTORY_V.EVENT_CODE,' ||
1124: 'CSD_REPAIR_HISTORY_V.EVENT_MEANING,' ||
1125: 'CSD_REPAIR_HISTORY_V.EVENT_DATE,' ||
1126: 'CSD_REPAIR_HISTORY_V.QUANTITY,' ||
1127: 'CSD_REPAIR_HISTORY_V.PARAMN1,' ||
1128: 'CSD_REPAIR_HISTORY_V.PARAMN2,' ||
1129: 'CSD_REPAIR_HISTORY_V.PARAMN3,' ||
1130: 'CSD_REPAIR_HISTORY_V.PARAMN4,' ||
1131: 'CSD_REPAIR_HISTORY_V.PARAMN5,' ||

Line 1128: 'CSD_REPAIR_HISTORY_V.PARAMN2,' ||

1124: 'CSD_REPAIR_HISTORY_V.EVENT_MEANING,' ||
1125: 'CSD_REPAIR_HISTORY_V.EVENT_DATE,' ||
1126: 'CSD_REPAIR_HISTORY_V.QUANTITY,' ||
1127: 'CSD_REPAIR_HISTORY_V.PARAMN1,' ||
1128: 'CSD_REPAIR_HISTORY_V.PARAMN2,' ||
1129: 'CSD_REPAIR_HISTORY_V.PARAMN3,' ||
1130: 'CSD_REPAIR_HISTORY_V.PARAMN4,' ||
1131: 'CSD_REPAIR_HISTORY_V.PARAMN5,' ||
1132: 'CSD_REPAIR_HISTORY_V.PARAMN6,' ||

Line 1129: 'CSD_REPAIR_HISTORY_V.PARAMN3,' ||

1125: 'CSD_REPAIR_HISTORY_V.EVENT_DATE,' ||
1126: 'CSD_REPAIR_HISTORY_V.QUANTITY,' ||
1127: 'CSD_REPAIR_HISTORY_V.PARAMN1,' ||
1128: 'CSD_REPAIR_HISTORY_V.PARAMN2,' ||
1129: 'CSD_REPAIR_HISTORY_V.PARAMN3,' ||
1130: 'CSD_REPAIR_HISTORY_V.PARAMN4,' ||
1131: 'CSD_REPAIR_HISTORY_V.PARAMN5,' ||
1132: 'CSD_REPAIR_HISTORY_V.PARAMN6,' ||
1133: 'CSD_REPAIR_HISTORY_V.PARAMN7,' ||

Line 1130: 'CSD_REPAIR_HISTORY_V.PARAMN4,' ||

1126: 'CSD_REPAIR_HISTORY_V.QUANTITY,' ||
1127: 'CSD_REPAIR_HISTORY_V.PARAMN1,' ||
1128: 'CSD_REPAIR_HISTORY_V.PARAMN2,' ||
1129: 'CSD_REPAIR_HISTORY_V.PARAMN3,' ||
1130: 'CSD_REPAIR_HISTORY_V.PARAMN4,' ||
1131: 'CSD_REPAIR_HISTORY_V.PARAMN5,' ||
1132: 'CSD_REPAIR_HISTORY_V.PARAMN6,' ||
1133: 'CSD_REPAIR_HISTORY_V.PARAMN7,' ||
1134: 'CSD_REPAIR_HISTORY_V.PARAMN8,' ||

Line 1131: 'CSD_REPAIR_HISTORY_V.PARAMN5,' ||

1127: 'CSD_REPAIR_HISTORY_V.PARAMN1,' ||
1128: 'CSD_REPAIR_HISTORY_V.PARAMN2,' ||
1129: 'CSD_REPAIR_HISTORY_V.PARAMN3,' ||
1130: 'CSD_REPAIR_HISTORY_V.PARAMN4,' ||
1131: 'CSD_REPAIR_HISTORY_V.PARAMN5,' ||
1132: 'CSD_REPAIR_HISTORY_V.PARAMN6,' ||
1133: 'CSD_REPAIR_HISTORY_V.PARAMN7,' ||
1134: 'CSD_REPAIR_HISTORY_V.PARAMN8,' ||
1135: 'CSD_REPAIR_HISTORY_V.PARAMN9,' ||

Line 1132: 'CSD_REPAIR_HISTORY_V.PARAMN6,' ||

1128: 'CSD_REPAIR_HISTORY_V.PARAMN2,' ||
1129: 'CSD_REPAIR_HISTORY_V.PARAMN3,' ||
1130: 'CSD_REPAIR_HISTORY_V.PARAMN4,' ||
1131: 'CSD_REPAIR_HISTORY_V.PARAMN5,' ||
1132: 'CSD_REPAIR_HISTORY_V.PARAMN6,' ||
1133: 'CSD_REPAIR_HISTORY_V.PARAMN7,' ||
1134: 'CSD_REPAIR_HISTORY_V.PARAMN8,' ||
1135: 'CSD_REPAIR_HISTORY_V.PARAMN9,' ||
1136: 'CSD_REPAIR_HISTORY_V.PARAMN10,' ||

Line 1133: 'CSD_REPAIR_HISTORY_V.PARAMN7,' ||

1129: 'CSD_REPAIR_HISTORY_V.PARAMN3,' ||
1130: 'CSD_REPAIR_HISTORY_V.PARAMN4,' ||
1131: 'CSD_REPAIR_HISTORY_V.PARAMN5,' ||
1132: 'CSD_REPAIR_HISTORY_V.PARAMN6,' ||
1133: 'CSD_REPAIR_HISTORY_V.PARAMN7,' ||
1134: 'CSD_REPAIR_HISTORY_V.PARAMN8,' ||
1135: 'CSD_REPAIR_HISTORY_V.PARAMN9,' ||
1136: 'CSD_REPAIR_HISTORY_V.PARAMN10,' ||
1137: 'CSD_REPAIR_HISTORY_V.PARAMC1,' ||

Line 1134: 'CSD_REPAIR_HISTORY_V.PARAMN8,' ||

1130: 'CSD_REPAIR_HISTORY_V.PARAMN4,' ||
1131: 'CSD_REPAIR_HISTORY_V.PARAMN5,' ||
1132: 'CSD_REPAIR_HISTORY_V.PARAMN6,' ||
1133: 'CSD_REPAIR_HISTORY_V.PARAMN7,' ||
1134: 'CSD_REPAIR_HISTORY_V.PARAMN8,' ||
1135: 'CSD_REPAIR_HISTORY_V.PARAMN9,' ||
1136: 'CSD_REPAIR_HISTORY_V.PARAMN10,' ||
1137: 'CSD_REPAIR_HISTORY_V.PARAMC1,' ||
1138: 'CSD_REPAIR_HISTORY_V.PARAMC2,' ||

Line 1135: 'CSD_REPAIR_HISTORY_V.PARAMN9,' ||

1131: 'CSD_REPAIR_HISTORY_V.PARAMN5,' ||
1132: 'CSD_REPAIR_HISTORY_V.PARAMN6,' ||
1133: 'CSD_REPAIR_HISTORY_V.PARAMN7,' ||
1134: 'CSD_REPAIR_HISTORY_V.PARAMN8,' ||
1135: 'CSD_REPAIR_HISTORY_V.PARAMN9,' ||
1136: 'CSD_REPAIR_HISTORY_V.PARAMN10,' ||
1137: 'CSD_REPAIR_HISTORY_V.PARAMC1,' ||
1138: 'CSD_REPAIR_HISTORY_V.PARAMC2,' ||
1139: 'CSD_REPAIR_HISTORY_V.PARAMC3,' ||

Line 1136: 'CSD_REPAIR_HISTORY_V.PARAMN10,' ||

1132: 'CSD_REPAIR_HISTORY_V.PARAMN6,' ||
1133: 'CSD_REPAIR_HISTORY_V.PARAMN7,' ||
1134: 'CSD_REPAIR_HISTORY_V.PARAMN8,' ||
1135: 'CSD_REPAIR_HISTORY_V.PARAMN9,' ||
1136: 'CSD_REPAIR_HISTORY_V.PARAMN10,' ||
1137: 'CSD_REPAIR_HISTORY_V.PARAMC1,' ||
1138: 'CSD_REPAIR_HISTORY_V.PARAMC2,' ||
1139: 'CSD_REPAIR_HISTORY_V.PARAMC3,' ||
1140: 'CSD_REPAIR_HISTORY_V.PARAMC4,' ||

Line 1137: 'CSD_REPAIR_HISTORY_V.PARAMC1,' ||

1133: 'CSD_REPAIR_HISTORY_V.PARAMN7,' ||
1134: 'CSD_REPAIR_HISTORY_V.PARAMN8,' ||
1135: 'CSD_REPAIR_HISTORY_V.PARAMN9,' ||
1136: 'CSD_REPAIR_HISTORY_V.PARAMN10,' ||
1137: 'CSD_REPAIR_HISTORY_V.PARAMC1,' ||
1138: 'CSD_REPAIR_HISTORY_V.PARAMC2,' ||
1139: 'CSD_REPAIR_HISTORY_V.PARAMC3,' ||
1140: 'CSD_REPAIR_HISTORY_V.PARAMC4,' ||
1141: 'CSD_REPAIR_HISTORY_V.PARAMC5,' ||

Line 1138: 'CSD_REPAIR_HISTORY_V.PARAMC2,' ||

1134: 'CSD_REPAIR_HISTORY_V.PARAMN8,' ||
1135: 'CSD_REPAIR_HISTORY_V.PARAMN9,' ||
1136: 'CSD_REPAIR_HISTORY_V.PARAMN10,' ||
1137: 'CSD_REPAIR_HISTORY_V.PARAMC1,' ||
1138: 'CSD_REPAIR_HISTORY_V.PARAMC2,' ||
1139: 'CSD_REPAIR_HISTORY_V.PARAMC3,' ||
1140: 'CSD_REPAIR_HISTORY_V.PARAMC4,' ||
1141: 'CSD_REPAIR_HISTORY_V.PARAMC5,' ||
1142: 'CSD_REPAIR_HISTORY_V.PARAMC6,' ||

Line 1139: 'CSD_REPAIR_HISTORY_V.PARAMC3,' ||

1135: 'CSD_REPAIR_HISTORY_V.PARAMN9,' ||
1136: 'CSD_REPAIR_HISTORY_V.PARAMN10,' ||
1137: 'CSD_REPAIR_HISTORY_V.PARAMC1,' ||
1138: 'CSD_REPAIR_HISTORY_V.PARAMC2,' ||
1139: 'CSD_REPAIR_HISTORY_V.PARAMC3,' ||
1140: 'CSD_REPAIR_HISTORY_V.PARAMC4,' ||
1141: 'CSD_REPAIR_HISTORY_V.PARAMC5,' ||
1142: 'CSD_REPAIR_HISTORY_V.PARAMC6,' ||
1143: 'CSD_REPAIR_HISTORY_V.PARAMC7,' ||

Line 1140: 'CSD_REPAIR_HISTORY_V.PARAMC4,' ||

1136: 'CSD_REPAIR_HISTORY_V.PARAMN10,' ||
1137: 'CSD_REPAIR_HISTORY_V.PARAMC1,' ||
1138: 'CSD_REPAIR_HISTORY_V.PARAMC2,' ||
1139: 'CSD_REPAIR_HISTORY_V.PARAMC3,' ||
1140: 'CSD_REPAIR_HISTORY_V.PARAMC4,' ||
1141: 'CSD_REPAIR_HISTORY_V.PARAMC5,' ||
1142: 'CSD_REPAIR_HISTORY_V.PARAMC6,' ||
1143: 'CSD_REPAIR_HISTORY_V.PARAMC7,' ||
1144: 'CSD_REPAIR_HISTORY_V.PARAMC8,' ||

Line 1141: 'CSD_REPAIR_HISTORY_V.PARAMC5,' ||

1137: 'CSD_REPAIR_HISTORY_V.PARAMC1,' ||
1138: 'CSD_REPAIR_HISTORY_V.PARAMC2,' ||
1139: 'CSD_REPAIR_HISTORY_V.PARAMC3,' ||
1140: 'CSD_REPAIR_HISTORY_V.PARAMC4,' ||
1141: 'CSD_REPAIR_HISTORY_V.PARAMC5,' ||
1142: 'CSD_REPAIR_HISTORY_V.PARAMC6,' ||
1143: 'CSD_REPAIR_HISTORY_V.PARAMC7,' ||
1144: 'CSD_REPAIR_HISTORY_V.PARAMC8,' ||
1145: 'CSD_REPAIR_HISTORY_V.PARAMC9,' ||

Line 1142: 'CSD_REPAIR_HISTORY_V.PARAMC6,' ||

1138: 'CSD_REPAIR_HISTORY_V.PARAMC2,' ||
1139: 'CSD_REPAIR_HISTORY_V.PARAMC3,' ||
1140: 'CSD_REPAIR_HISTORY_V.PARAMC4,' ||
1141: 'CSD_REPAIR_HISTORY_V.PARAMC5,' ||
1142: 'CSD_REPAIR_HISTORY_V.PARAMC6,' ||
1143: 'CSD_REPAIR_HISTORY_V.PARAMC7,' ||
1144: 'CSD_REPAIR_HISTORY_V.PARAMC8,' ||
1145: 'CSD_REPAIR_HISTORY_V.PARAMC9,' ||
1146: 'CSD_REPAIR_HISTORY_V.PARAMC10,' ||

Line 1143: 'CSD_REPAIR_HISTORY_V.PARAMC7,' ||

1139: 'CSD_REPAIR_HISTORY_V.PARAMC3,' ||
1140: 'CSD_REPAIR_HISTORY_V.PARAMC4,' ||
1141: 'CSD_REPAIR_HISTORY_V.PARAMC5,' ||
1142: 'CSD_REPAIR_HISTORY_V.PARAMC6,' ||
1143: 'CSD_REPAIR_HISTORY_V.PARAMC7,' ||
1144: 'CSD_REPAIR_HISTORY_V.PARAMC8,' ||
1145: 'CSD_REPAIR_HISTORY_V.PARAMC9,' ||
1146: 'CSD_REPAIR_HISTORY_V.PARAMC10,' ||
1147: 'CSD_REPAIR_HISTORY_V.PARAMD1,' ||

Line 1144: 'CSD_REPAIR_HISTORY_V.PARAMC8,' ||

1140: 'CSD_REPAIR_HISTORY_V.PARAMC4,' ||
1141: 'CSD_REPAIR_HISTORY_V.PARAMC5,' ||
1142: 'CSD_REPAIR_HISTORY_V.PARAMC6,' ||
1143: 'CSD_REPAIR_HISTORY_V.PARAMC7,' ||
1144: 'CSD_REPAIR_HISTORY_V.PARAMC8,' ||
1145: 'CSD_REPAIR_HISTORY_V.PARAMC9,' ||
1146: 'CSD_REPAIR_HISTORY_V.PARAMC10,' ||
1147: 'CSD_REPAIR_HISTORY_V.PARAMD1,' ||
1148: 'CSD_REPAIR_HISTORY_V.PARAMD2,' ||

Line 1145: 'CSD_REPAIR_HISTORY_V.PARAMC9,' ||

1141: 'CSD_REPAIR_HISTORY_V.PARAMC5,' ||
1142: 'CSD_REPAIR_HISTORY_V.PARAMC6,' ||
1143: 'CSD_REPAIR_HISTORY_V.PARAMC7,' ||
1144: 'CSD_REPAIR_HISTORY_V.PARAMC8,' ||
1145: 'CSD_REPAIR_HISTORY_V.PARAMC9,' ||
1146: 'CSD_REPAIR_HISTORY_V.PARAMC10,' ||
1147: 'CSD_REPAIR_HISTORY_V.PARAMD1,' ||
1148: 'CSD_REPAIR_HISTORY_V.PARAMD2,' ||
1149: 'CSD_REPAIR_HISTORY_V.PARAMD3,' ||

Line 1146: 'CSD_REPAIR_HISTORY_V.PARAMC10,' ||

1142: 'CSD_REPAIR_HISTORY_V.PARAMC6,' ||
1143: 'CSD_REPAIR_HISTORY_V.PARAMC7,' ||
1144: 'CSD_REPAIR_HISTORY_V.PARAMC8,' ||
1145: 'CSD_REPAIR_HISTORY_V.PARAMC9,' ||
1146: 'CSD_REPAIR_HISTORY_V.PARAMC10,' ||
1147: 'CSD_REPAIR_HISTORY_V.PARAMD1,' ||
1148: 'CSD_REPAIR_HISTORY_V.PARAMD2,' ||
1149: 'CSD_REPAIR_HISTORY_V.PARAMD3,' ||
1150: 'CSD_REPAIR_HISTORY_V.PARAMD4,' ||

Line 1147: 'CSD_REPAIR_HISTORY_V.PARAMD1,' ||

1143: 'CSD_REPAIR_HISTORY_V.PARAMC7,' ||
1144: 'CSD_REPAIR_HISTORY_V.PARAMC8,' ||
1145: 'CSD_REPAIR_HISTORY_V.PARAMC9,' ||
1146: 'CSD_REPAIR_HISTORY_V.PARAMC10,' ||
1147: 'CSD_REPAIR_HISTORY_V.PARAMD1,' ||
1148: 'CSD_REPAIR_HISTORY_V.PARAMD2,' ||
1149: 'CSD_REPAIR_HISTORY_V.PARAMD3,' ||
1150: 'CSD_REPAIR_HISTORY_V.PARAMD4,' ||
1151: 'CSD_REPAIR_HISTORY_V.PARAMD5,' ||

Line 1148: 'CSD_REPAIR_HISTORY_V.PARAMD2,' ||

1144: 'CSD_REPAIR_HISTORY_V.PARAMC8,' ||
1145: 'CSD_REPAIR_HISTORY_V.PARAMC9,' ||
1146: 'CSD_REPAIR_HISTORY_V.PARAMC10,' ||
1147: 'CSD_REPAIR_HISTORY_V.PARAMD1,' ||
1148: 'CSD_REPAIR_HISTORY_V.PARAMD2,' ||
1149: 'CSD_REPAIR_HISTORY_V.PARAMD3,' ||
1150: 'CSD_REPAIR_HISTORY_V.PARAMD4,' ||
1151: 'CSD_REPAIR_HISTORY_V.PARAMD5,' ||
1152: 'CSD_REPAIR_HISTORY_V.PARAMD6,' ||

Line 1149: 'CSD_REPAIR_HISTORY_V.PARAMD3,' ||

1145: 'CSD_REPAIR_HISTORY_V.PARAMC9,' ||
1146: 'CSD_REPAIR_HISTORY_V.PARAMC10,' ||
1147: 'CSD_REPAIR_HISTORY_V.PARAMD1,' ||
1148: 'CSD_REPAIR_HISTORY_V.PARAMD2,' ||
1149: 'CSD_REPAIR_HISTORY_V.PARAMD3,' ||
1150: 'CSD_REPAIR_HISTORY_V.PARAMD4,' ||
1151: 'CSD_REPAIR_HISTORY_V.PARAMD5,' ||
1152: 'CSD_REPAIR_HISTORY_V.PARAMD6,' ||
1153: 'CSD_REPAIR_HISTORY_V.PARAMD7,' ||

Line 1150: 'CSD_REPAIR_HISTORY_V.PARAMD4,' ||

1146: 'CSD_REPAIR_HISTORY_V.PARAMC10,' ||
1147: 'CSD_REPAIR_HISTORY_V.PARAMD1,' ||
1148: 'CSD_REPAIR_HISTORY_V.PARAMD2,' ||
1149: 'CSD_REPAIR_HISTORY_V.PARAMD3,' ||
1150: 'CSD_REPAIR_HISTORY_V.PARAMD4,' ||
1151: 'CSD_REPAIR_HISTORY_V.PARAMD5,' ||
1152: 'CSD_REPAIR_HISTORY_V.PARAMD6,' ||
1153: 'CSD_REPAIR_HISTORY_V.PARAMD7,' ||
1154: 'CSD_REPAIR_HISTORY_V.PARAMD8,' ||

Line 1151: 'CSD_REPAIR_HISTORY_V.PARAMD5,' ||

1147: 'CSD_REPAIR_HISTORY_V.PARAMD1,' ||
1148: 'CSD_REPAIR_HISTORY_V.PARAMD2,' ||
1149: 'CSD_REPAIR_HISTORY_V.PARAMD3,' ||
1150: 'CSD_REPAIR_HISTORY_V.PARAMD4,' ||
1151: 'CSD_REPAIR_HISTORY_V.PARAMD5,' ||
1152: 'CSD_REPAIR_HISTORY_V.PARAMD6,' ||
1153: 'CSD_REPAIR_HISTORY_V.PARAMD7,' ||
1154: 'CSD_REPAIR_HISTORY_V.PARAMD8,' ||
1155: 'CSD_REPAIR_HISTORY_V.PARAMD9,' ||

Line 1152: 'CSD_REPAIR_HISTORY_V.PARAMD6,' ||

1148: 'CSD_REPAIR_HISTORY_V.PARAMD2,' ||
1149: 'CSD_REPAIR_HISTORY_V.PARAMD3,' ||
1150: 'CSD_REPAIR_HISTORY_V.PARAMD4,' ||
1151: 'CSD_REPAIR_HISTORY_V.PARAMD5,' ||
1152: 'CSD_REPAIR_HISTORY_V.PARAMD6,' ||
1153: 'CSD_REPAIR_HISTORY_V.PARAMD7,' ||
1154: 'CSD_REPAIR_HISTORY_V.PARAMD8,' ||
1155: 'CSD_REPAIR_HISTORY_V.PARAMD9,' ||
1156: 'CSD_REPAIR_HISTORY_V.PARAMD10,' ||

Line 1153: 'CSD_REPAIR_HISTORY_V.PARAMD7,' ||

1149: 'CSD_REPAIR_HISTORY_V.PARAMD3,' ||
1150: 'CSD_REPAIR_HISTORY_V.PARAMD4,' ||
1151: 'CSD_REPAIR_HISTORY_V.PARAMD5,' ||
1152: 'CSD_REPAIR_HISTORY_V.PARAMD6,' ||
1153: 'CSD_REPAIR_HISTORY_V.PARAMD7,' ||
1154: 'CSD_REPAIR_HISTORY_V.PARAMD8,' ||
1155: 'CSD_REPAIR_HISTORY_V.PARAMD9,' ||
1156: 'CSD_REPAIR_HISTORY_V.PARAMD10,' ||
1157: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE_CATEGORY,' ||

Line 1154: 'CSD_REPAIR_HISTORY_V.PARAMD8,' ||

1150: 'CSD_REPAIR_HISTORY_V.PARAMD4,' ||
1151: 'CSD_REPAIR_HISTORY_V.PARAMD5,' ||
1152: 'CSD_REPAIR_HISTORY_V.PARAMD6,' ||
1153: 'CSD_REPAIR_HISTORY_V.PARAMD7,' ||
1154: 'CSD_REPAIR_HISTORY_V.PARAMD8,' ||
1155: 'CSD_REPAIR_HISTORY_V.PARAMD9,' ||
1156: 'CSD_REPAIR_HISTORY_V.PARAMD10,' ||
1157: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE_CATEGORY,' ||
1158: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE1,' ||

Line 1155: 'CSD_REPAIR_HISTORY_V.PARAMD9,' ||

1151: 'CSD_REPAIR_HISTORY_V.PARAMD5,' ||
1152: 'CSD_REPAIR_HISTORY_V.PARAMD6,' ||
1153: 'CSD_REPAIR_HISTORY_V.PARAMD7,' ||
1154: 'CSD_REPAIR_HISTORY_V.PARAMD8,' ||
1155: 'CSD_REPAIR_HISTORY_V.PARAMD9,' ||
1156: 'CSD_REPAIR_HISTORY_V.PARAMD10,' ||
1157: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE_CATEGORY,' ||
1158: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE1,' ||
1159: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE2,' ||

Line 1156: 'CSD_REPAIR_HISTORY_V.PARAMD10,' ||

1152: 'CSD_REPAIR_HISTORY_V.PARAMD6,' ||
1153: 'CSD_REPAIR_HISTORY_V.PARAMD7,' ||
1154: 'CSD_REPAIR_HISTORY_V.PARAMD8,' ||
1155: 'CSD_REPAIR_HISTORY_V.PARAMD9,' ||
1156: 'CSD_REPAIR_HISTORY_V.PARAMD10,' ||
1157: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE_CATEGORY,' ||
1158: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE1,' ||
1159: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE2,' ||
1160: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE3,' ||

Line 1157: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE_CATEGORY,' ||

1153: 'CSD_REPAIR_HISTORY_V.PARAMD7,' ||
1154: 'CSD_REPAIR_HISTORY_V.PARAMD8,' ||
1155: 'CSD_REPAIR_HISTORY_V.PARAMD9,' ||
1156: 'CSD_REPAIR_HISTORY_V.PARAMD10,' ||
1157: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE_CATEGORY,' ||
1158: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE1,' ||
1159: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE2,' ||
1160: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE3,' ||
1161: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE4,' ||

Line 1158: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE1,' ||

1154: 'CSD_REPAIR_HISTORY_V.PARAMD8,' ||
1155: 'CSD_REPAIR_HISTORY_V.PARAMD9,' ||
1156: 'CSD_REPAIR_HISTORY_V.PARAMD10,' ||
1157: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE_CATEGORY,' ||
1158: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE1,' ||
1159: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE2,' ||
1160: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE3,' ||
1161: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE4,' ||
1162: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE5,' ||

Line 1159: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE2,' ||

1155: 'CSD_REPAIR_HISTORY_V.PARAMD9,' ||
1156: 'CSD_REPAIR_HISTORY_V.PARAMD10,' ||
1157: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE_CATEGORY,' ||
1158: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE1,' ||
1159: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE2,' ||
1160: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE3,' ||
1161: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE4,' ||
1162: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE5,' ||
1163: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE6,' ||

Line 1160: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE3,' ||

1156: 'CSD_REPAIR_HISTORY_V.PARAMD10,' ||
1157: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE_CATEGORY,' ||
1158: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE1,' ||
1159: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE2,' ||
1160: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE3,' ||
1161: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE4,' ||
1162: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE5,' ||
1163: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE6,' ||
1164: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE7,' ||

Line 1161: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE4,' ||

1157: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE_CATEGORY,' ||
1158: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE1,' ||
1159: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE2,' ||
1160: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE3,' ||
1161: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE4,' ||
1162: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE5,' ||
1163: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE6,' ||
1164: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE7,' ||
1165: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE8,' ||

Line 1162: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE5,' ||

1158: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE1,' ||
1159: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE2,' ||
1160: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE3,' ||
1161: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE4,' ||
1162: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE5,' ||
1163: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE6,' ||
1164: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE7,' ||
1165: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE8,' ||
1166: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE9,' ||

Line 1163: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE6,' ||

1159: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE2,' ||
1160: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE3,' ||
1161: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE4,' ||
1162: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE5,' ||
1163: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE6,' ||
1164: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE7,' ||
1165: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE8,' ||
1166: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE9,' ||
1167: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE10,' ||

Line 1164: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE7,' ||

1160: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE3,' ||
1161: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE4,' ||
1162: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE5,' ||
1163: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE6,' ||
1164: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE7,' ||
1165: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE8,' ||
1166: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE9,' ||
1167: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE10,' ||
1168: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE11,' ||

Line 1165: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE8,' ||

1161: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE4,' ||
1162: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE5,' ||
1163: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE6,' ||
1164: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE7,' ||
1165: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE8,' ||
1166: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE9,' ||
1167: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE10,' ||
1168: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE11,' ||
1169: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE12,' ||

Line 1166: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE9,' ||

1162: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE5,' ||
1163: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE6,' ||
1164: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE7,' ||
1165: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE8,' ||
1166: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE9,' ||
1167: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE10,' ||
1168: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE11,' ||
1169: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE12,' ||
1170: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE13,' ||

Line 1167: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE10,' ||

1163: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE6,' ||
1164: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE7,' ||
1165: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE8,' ||
1166: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE9,' ||
1167: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE10,' ||
1168: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE11,' ||
1169: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE12,' ||
1170: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE13,' ||
1171: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE14,' ||

Line 1168: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE11,' ||

1164: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE7,' ||
1165: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE8,' ||
1166: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE9,' ||
1167: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE10,' ||
1168: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE11,' ||
1169: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE12,' ||
1170: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE13,' ||
1171: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE14,' ||
1172: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE15,' ||

Line 1169: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE12,' ||

1165: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE8,' ||
1166: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE9,' ||
1167: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE10,' ||
1168: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE11,' ||
1169: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE12,' ||
1170: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE13,' ||
1171: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE14,' ||
1172: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE15,' ||
1173: 'CSD_REPAIR_HISTORY_V.OBJECT_VERSION_NUMBER' ||

Line 1170: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE13,' ||

1166: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE9,' ||
1167: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE10,' ||
1168: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE11,' ||
1169: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE12,' ||
1170: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE13,' ||
1171: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE14,' ||
1172: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE15,' ||
1173: 'CSD_REPAIR_HISTORY_V.OBJECT_VERSION_NUMBER' ||
1174: 'from CSD_REPAIR_HISTORY_V';

Line 1171: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE14,' ||

1167: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE10,' ||
1168: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE11,' ||
1169: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE12,' ||
1170: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE13,' ||
1171: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE14,' ||
1172: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE15,' ||
1173: 'CSD_REPAIR_HISTORY_V.OBJECT_VERSION_NUMBER' ||
1174: 'from CSD_REPAIR_HISTORY_V';
1175: -- Debug Message

Line 1172: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE15,' ||

1168: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE11,' ||
1169: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE12,' ||
1170: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE13,' ||
1171: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE14,' ||
1172: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE15,' ||
1173: 'CSD_REPAIR_HISTORY_V.OBJECT_VERSION_NUMBER' ||
1174: 'from CSD_REPAIR_HISTORY_V';
1175: -- Debug Message
1176: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Generate Select Ends');

Line 1173: 'CSD_REPAIR_HISTORY_V.OBJECT_VERSION_NUMBER' ||

1169: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE12,' ||
1170: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE13,' ||
1171: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE14,' ||
1172: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE15,' ||
1173: 'CSD_REPAIR_HISTORY_V.OBJECT_VERSION_NUMBER' ||
1174: 'from CSD_REPAIR_HISTORY_V';
1175: -- Debug Message
1176: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Generate Select Ends');
1177:

Line 1174: 'from CSD_REPAIR_HISTORY_V';

1170: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE13,' ||
1171: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE14,' ||
1172: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE15,' ||
1173: 'CSD_REPAIR_HISTORY_V.OBJECT_VERSION_NUMBER' ||
1174: 'from CSD_REPAIR_HISTORY_V';
1175: -- Debug Message
1176: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Generate Select Ends');
1177:
1178: END Gen_Select;

Line 1181: P_REPH_Rec IN CSD_REPAIR_HISTORY_PVT.REPH_Rec_Type,

1177:
1178: END Gen_Select;
1179:
1180: PROCEDURE Gen_REPH_Where(
1181: P_REPH_Rec IN CSD_REPAIR_HISTORY_PVT.REPH_Rec_Type,
1182: x_REPH_where OUT NOCOPY VARCHAR2
1183: )
1184: IS
1185: -- cursors to check if wildcard values '%' and '_' have been passed

Line 1345: l_REPH_rec CSD_REPAIR_HISTORY_Pvt.REPH_Rec_Type;

1341: l_flex_where VARCHAR2(2000) := NULL;
1342: l_counter NUMBER;
1343:
1344: -- Local scratch record
1345: l_REPH_rec CSD_REPAIR_HISTORY_Pvt.REPH_Rec_Type;
1346: l_crit_REPH_rec CSD_REPAIR_HISTORY_Pvt.REPH_Rec_Type;
1347: BEGIN
1348: -- Standard Start of API savepoint
1349: SAVEPOINT GET_REPAIR_HISTORY_PVT;

Line 1346: l_crit_REPH_rec CSD_REPAIR_HISTORY_Pvt.REPH_Rec_Type;

1342: l_counter NUMBER;
1343:
1344: -- Local scratch record
1345: l_REPH_rec CSD_REPAIR_HISTORY_Pvt.REPH_Rec_Type;
1346: l_crit_REPH_rec CSD_REPAIR_HISTORY_Pvt.REPH_Rec_Type;
1347: BEGIN
1348: -- Standard Start of API savepoint
1349: SAVEPOINT GET_REPAIR_HISTORY_PVT;
1350:

Line 1408: l_flex_where_tbl_type(l_counter).name := 'CSD_REPAIR_HISTORY_V.attribute' || l_counter;

1404: -- Generate Where clause for flex fields
1405: -- Hint: Developer can use table/view alias in the From clause generated in Gen_Select procedure
1406:
1407: FOR l_counter IN 1..15 LOOP
1408: l_flex_where_tbl_type(l_counter).name := 'CSD_REPAIR_HISTORY_V.attribute' || l_counter;
1409: END LOOP;
1410:
1411: l_flex_where_tbl_type(16).name := 'CSD_REPAIR_HISTORY_V.attribute_category';
1412: l_flex_where_tbl_type(1).value := P_REPH_Rec.attribute1;

Line 1411: l_flex_where_tbl_type(16).name := 'CSD_REPAIR_HISTORY_V.attribute_category';

1407: FOR l_counter IN 1..15 LOOP
1408: l_flex_where_tbl_type(l_counter).name := 'CSD_REPAIR_HISTORY_V.attribute' || l_counter;
1409: END LOOP;
1410:
1411: l_flex_where_tbl_type(16).name := 'CSD_REPAIR_HISTORY_V.attribute_category';
1412: l_flex_where_tbl_type(1).value := P_REPH_Rec.attribute1;
1413: l_flex_where_tbl_type(2).value := P_REPH_Rec.attribute2;
1414: l_flex_where_tbl_type(3).value := P_REPH_Rec.attribute3;
1415: l_flex_where_tbl_type(4).value := P_REPH_Rec.attribute4;

Line 3366: csd_gen_utility_pvt.add('CSD_REPAIR_HISTORY_PVT.Validate_OBJECT_VERSION_NUMBER in create we get null ovn');

3362:
3363: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
3364: THEN
3365: IF (g_debug > 0 ) THEN
3366: csd_gen_utility_pvt.add('CSD_REPAIR_HISTORY_PVT.Validate_OBJECT_VERSION_NUMBER in create we get null ovn');
3367: END IF;
3368:
3369: IF (g_debug > 0 ) THEN
3370: csd_gen_utility_pvt.add('CSD_REPAIR_HISTORY_PVT.Validate_OBJECT_VERSION_NUMBER ovn '||to_char(p_OBJECT_VERSION_NUMBER));

Line 3370: csd_gen_utility_pvt.add('CSD_REPAIR_HISTORY_PVT.Validate_OBJECT_VERSION_NUMBER ovn '||to_char(p_OBJECT_VERSION_NUMBER));

3366: csd_gen_utility_pvt.add('CSD_REPAIR_HISTORY_PVT.Validate_OBJECT_VERSION_NUMBER in create we get null ovn');
3367: END IF;
3368:
3369: IF (g_debug > 0 ) THEN
3370: csd_gen_utility_pvt.add('CSD_REPAIR_HISTORY_PVT.Validate_OBJECT_VERSION_NUMBER ovn '||to_char(p_OBJECT_VERSION_NUMBER));
3371: END IF;
3372:
3373:
3374: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

Line 3378: csd_gen_utility_pvt.add('CSD_REPAIR_HISTORY_PVT.Validate_OBJECT_VERSION_NUMBER in update');

3374: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
3375: THEN
3376:
3377: IF (g_debug > 0 ) THEN
3378: csd_gen_utility_pvt.add('CSD_REPAIR_HISTORY_PVT.Validate_OBJECT_VERSION_NUMBER in update');
3379: END IF;
3380:
3381: IF (g_debug > 0 ) THEN
3382: csd_gen_utility_pvt.add('CSD_REPAIR_HISTORY_PVT.Validate_OBJECT_VERSION_NUMBER ovn from form '||to_char(p_OBJECT_VERSION_NUMBER));

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

3378: csd_gen_utility_pvt.add('CSD_REPAIR_HISTORY_PVT.Validate_OBJECT_VERSION_NUMBER in update');
3379: END IF;
3380:
3381: IF (g_debug > 0 ) THEN
3382: csd_gen_utility_pvt.add('CSD_REPAIR_HISTORY_PVT.Validate_OBJECT_VERSION_NUMBER ovn from form '||to_char(p_OBJECT_VERSION_NUMBER));
3383: END IF;
3384:
3385:
3386: -- verify if data is valid

Line 3389: FROM CSD_REPAIR_HISTORY

3385:
3386: -- verify if data is valid
3387: SELECT OBJECT_VERSION_NUMBER
3388: INTO l_OBJECT_VERSION_NUMBER
3389: FROM CSD_REPAIR_HISTORY
3390: WHERE REPAIR_HISTORY_ID = P_REPAIR_HISTORY_ID;
3391:
3392: IF (g_debug > 0 ) THEN
3393: csd_gen_utility_pvt.add('CSD_REPAIR_HISTORY_PVT.Validate_OBJECT_VERSION_NUMBER ovn from db '||to_char(l_OBJECT_VERSION_NUMBER));

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

3389: FROM CSD_REPAIR_HISTORY
3390: WHERE REPAIR_HISTORY_ID = P_REPAIR_HISTORY_ID;
3391:
3392: IF (g_debug > 0 ) THEN
3393: csd_gen_utility_pvt.add('CSD_REPAIR_HISTORY_PVT.Validate_OBJECT_VERSION_NUMBER ovn from db '||to_char(l_OBJECT_VERSION_NUMBER));
3394: END IF;
3395:
3396:
3397: if (l_OBJECT_VERSION_NUMBER <> p_OBJECT_VERSION_NUMBER) then

Line 3402: csd_gen_utility_pvt.add('CSD_REPAIR_HISTORY_PVT.Validate_OBJECT_VERSION_NUMBER ovn mismatch error');

3398: -- data is not valid
3399: x_return_status := FND_API.G_RET_STS_ERROR;
3400:
3401: IF (g_debug > 0 ) THEN
3402: csd_gen_utility_pvt.add('CSD_REPAIR_HISTORY_PVT.Validate_OBJECT_VERSION_NUMBER ovn mismatch error');
3403: END IF;
3404:
3405:
3406: end if;

Line 3979: l_ref_REPH_rec CSD_REPAIR_HISTORY_Pvt.REPH_Rec_Type;

3975: -- variables --
3976: l_repair_detail VARCHAR2(2000);
3977: l_attachments_copied VARCHAR2(1000);
3978: l_attachments_not_copied VARCHAR2(1000);
3979: l_ref_REPH_rec CSD_REPAIR_HISTORY_Pvt.REPH_Rec_Type;
3980: l_user_name VARCHAR2(100);
3981: l_status_meaning VARCHAR2(80);
3982:
3983: -- bug#13698799 auto create ro, parent ro

Line 4049: From CSD_REPAIR_HISTORY

4045: ,ATTRIBUTE13
4046: ,ATTRIBUTE14
4047: ,ATTRIBUTE15
4048: ,OBJECT_VERSION_NUMBER
4049: From CSD_REPAIR_HISTORY
4050: where repair_history_id = p_REPAIR_HISTORY_ID;
4051:
4052: Cursor c_get_user_name(p_user_id number) is
4053: select user_name

Line 4421: End CSD_REPAIR_HISTORY_PVT;

4417: END GET_HISTORY_DETAIL;
4418:
4419:
4420:
4421: End CSD_REPAIR_HISTORY_PVT;