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 115.8 2002/11/12 21:33:51 sangigup 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 115.8 2002/11/12 21:33:51 sangigup 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 222: 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);

218: p_LAST_UPDATE_LOGIN => p_REPH_rec.LAST_UPDATE_LOGIN);
219: -- Hint: Primary key should be returned.
220: -- x_REPAIR_HISTORY_ID := px_REPAIR_HISTORY_ID;
221: IF (g_debug > 0 ) THEN
222: 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);
223: END IF;
224:
225:
226:

Line 382: From CSD_REPAIR_HISTORY

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

Line 390: l_ref_REPH_rec CSD_repair_history_PVT.REPH_Rec_Type;

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

Line 391: l_tar_REPH_rec CSD_repair_history_PVT.REPH_Rec_Type := P_REPH_Rec;

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

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

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

Line 594: CSD_REPAIR_HISTORY_PKG.Update_Row(

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

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

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

Line 815: CSD_REPAIR_HISTORY_PKG.Delete_Row(

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

Line 895: P_REPH_Rec IN CSD_REPAIR_HISTORY_PVT.REPH_Rec_Type,

891:
892:
893: -- This procudure defines the columns for the Dynamic SQL.
894: PROCEDURE Define_Columns(
895: P_REPH_Rec IN CSD_REPAIR_HISTORY_PVT.REPH_Rec_Type,
896: p_cur_get_REPH IN NUMBER
897: )
898: IS
899: BEGIN

Line 903: -- define all columns for CSD_REPAIR_HISTORY_V view

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

Line 966: X_REPH_Rec OUT NOCOPY CSD_REPAIR_HISTORY_PVT.REPH_Rec_Type

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

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

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

Line 1034: p_order_by_rec IN CSD_REPAIR_HISTORY_PVT.REPH_sort_rec_type,

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

Line 1077: P_REPH_Rec IN CSD_REPAIR_HISTORY_PVT.REPH_Rec_Type,

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

Line 1108: 'CSD_REPAIR_HISTORY_V.REPAIR_HISTORY_ID,' ||

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

Line 1109: 'CSD_REPAIR_HISTORY_V.REQUEST_ID,' ||

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

Line 1110: 'CSD_REPAIR_HISTORY_V.PROGRAM_ID,' ||

1106:
1107: x_select_cl := 'Select ' ||
1108: 'CSD_REPAIR_HISTORY_V.REPAIR_HISTORY_ID,' ||
1109: 'CSD_REPAIR_HISTORY_V.REQUEST_ID,' ||
1110: 'CSD_REPAIR_HISTORY_V.PROGRAM_ID,' ||
1111: 'CSD_REPAIR_HISTORY_V.PROGRAM_APPLICATION_ID,' ||
1112: 'CSD_REPAIR_HISTORY_V.PROGRAM_UPDATE_DATE,' ||
1113: 'CSD_REPAIR_HISTORY_V.CREATED_BY,' ||
1114: 'CSD_REPAIR_HISTORY_V.CREATION_DATE,' ||

Line 1111: 'CSD_REPAIR_HISTORY_V.PROGRAM_APPLICATION_ID,' ||

1107: x_select_cl := 'Select ' ||
1108: 'CSD_REPAIR_HISTORY_V.REPAIR_HISTORY_ID,' ||
1109: 'CSD_REPAIR_HISTORY_V.REQUEST_ID,' ||
1110: 'CSD_REPAIR_HISTORY_V.PROGRAM_ID,' ||
1111: 'CSD_REPAIR_HISTORY_V.PROGRAM_APPLICATION_ID,' ||
1112: 'CSD_REPAIR_HISTORY_V.PROGRAM_UPDATE_DATE,' ||
1113: 'CSD_REPAIR_HISTORY_V.CREATED_BY,' ||
1114: 'CSD_REPAIR_HISTORY_V.CREATION_DATE,' ||
1115: 'CSD_REPAIR_HISTORY_V.LAST_UPDATED_BY,' ||

Line 1112: 'CSD_REPAIR_HISTORY_V.PROGRAM_UPDATE_DATE,' ||

1108: 'CSD_REPAIR_HISTORY_V.REPAIR_HISTORY_ID,' ||
1109: 'CSD_REPAIR_HISTORY_V.REQUEST_ID,' ||
1110: 'CSD_REPAIR_HISTORY_V.PROGRAM_ID,' ||
1111: 'CSD_REPAIR_HISTORY_V.PROGRAM_APPLICATION_ID,' ||
1112: 'CSD_REPAIR_HISTORY_V.PROGRAM_UPDATE_DATE,' ||
1113: 'CSD_REPAIR_HISTORY_V.CREATED_BY,' ||
1114: 'CSD_REPAIR_HISTORY_V.CREATION_DATE,' ||
1115: 'CSD_REPAIR_HISTORY_V.LAST_UPDATED_BY,' ||
1116: 'CSD_REPAIR_HISTORY_V.LAST_UPDATE_DATE,' ||

Line 1113: 'CSD_REPAIR_HISTORY_V.CREATED_BY,' ||

1109: 'CSD_REPAIR_HISTORY_V.REQUEST_ID,' ||
1110: 'CSD_REPAIR_HISTORY_V.PROGRAM_ID,' ||
1111: 'CSD_REPAIR_HISTORY_V.PROGRAM_APPLICATION_ID,' ||
1112: 'CSD_REPAIR_HISTORY_V.PROGRAM_UPDATE_DATE,' ||
1113: 'CSD_REPAIR_HISTORY_V.CREATED_BY,' ||
1114: 'CSD_REPAIR_HISTORY_V.CREATION_DATE,' ||
1115: 'CSD_REPAIR_HISTORY_V.LAST_UPDATED_BY,' ||
1116: 'CSD_REPAIR_HISTORY_V.LAST_UPDATE_DATE,' ||
1117: 'CSD_REPAIR_HISTORY_V.LAST_UPDATE_LOGIN,' ||

Line 1114: 'CSD_REPAIR_HISTORY_V.CREATION_DATE,' ||

1110: 'CSD_REPAIR_HISTORY_V.PROGRAM_ID,' ||
1111: 'CSD_REPAIR_HISTORY_V.PROGRAM_APPLICATION_ID,' ||
1112: 'CSD_REPAIR_HISTORY_V.PROGRAM_UPDATE_DATE,' ||
1113: 'CSD_REPAIR_HISTORY_V.CREATED_BY,' ||
1114: 'CSD_REPAIR_HISTORY_V.CREATION_DATE,' ||
1115: 'CSD_REPAIR_HISTORY_V.LAST_UPDATED_BY,' ||
1116: 'CSD_REPAIR_HISTORY_V.LAST_UPDATE_DATE,' ||
1117: 'CSD_REPAIR_HISTORY_V.LAST_UPDATE_LOGIN,' ||
1118: 'CSD_REPAIR_HISTORY_V.REPAIR_LINE_ID,' ||

Line 1115: 'CSD_REPAIR_HISTORY_V.LAST_UPDATED_BY,' ||

1111: 'CSD_REPAIR_HISTORY_V.PROGRAM_APPLICATION_ID,' ||
1112: 'CSD_REPAIR_HISTORY_V.PROGRAM_UPDATE_DATE,' ||
1113: 'CSD_REPAIR_HISTORY_V.CREATED_BY,' ||
1114: 'CSD_REPAIR_HISTORY_V.CREATION_DATE,' ||
1115: 'CSD_REPAIR_HISTORY_V.LAST_UPDATED_BY,' ||
1116: 'CSD_REPAIR_HISTORY_V.LAST_UPDATE_DATE,' ||
1117: 'CSD_REPAIR_HISTORY_V.LAST_UPDATE_LOGIN,' ||
1118: 'CSD_REPAIR_HISTORY_V.REPAIR_LINE_ID,' ||
1119: 'CSD_REPAIR_HISTORY_V.EVENT_CODE,' ||

Line 1116: 'CSD_REPAIR_HISTORY_V.LAST_UPDATE_DATE,' ||

1112: 'CSD_REPAIR_HISTORY_V.PROGRAM_UPDATE_DATE,' ||
1113: 'CSD_REPAIR_HISTORY_V.CREATED_BY,' ||
1114: 'CSD_REPAIR_HISTORY_V.CREATION_DATE,' ||
1115: 'CSD_REPAIR_HISTORY_V.LAST_UPDATED_BY,' ||
1116: 'CSD_REPAIR_HISTORY_V.LAST_UPDATE_DATE,' ||
1117: 'CSD_REPAIR_HISTORY_V.LAST_UPDATE_LOGIN,' ||
1118: 'CSD_REPAIR_HISTORY_V.REPAIR_LINE_ID,' ||
1119: 'CSD_REPAIR_HISTORY_V.EVENT_CODE,' ||
1120: 'CSD_REPAIR_HISTORY_V.EVENT_MEANING,' ||

Line 1117: 'CSD_REPAIR_HISTORY_V.LAST_UPDATE_LOGIN,' ||

1113: 'CSD_REPAIR_HISTORY_V.CREATED_BY,' ||
1114: 'CSD_REPAIR_HISTORY_V.CREATION_DATE,' ||
1115: 'CSD_REPAIR_HISTORY_V.LAST_UPDATED_BY,' ||
1116: 'CSD_REPAIR_HISTORY_V.LAST_UPDATE_DATE,' ||
1117: 'CSD_REPAIR_HISTORY_V.LAST_UPDATE_LOGIN,' ||
1118: 'CSD_REPAIR_HISTORY_V.REPAIR_LINE_ID,' ||
1119: 'CSD_REPAIR_HISTORY_V.EVENT_CODE,' ||
1120: 'CSD_REPAIR_HISTORY_V.EVENT_MEANING,' ||
1121: 'CSD_REPAIR_HISTORY_V.EVENT_DATE,' ||

Line 1118: 'CSD_REPAIR_HISTORY_V.REPAIR_LINE_ID,' ||

1114: 'CSD_REPAIR_HISTORY_V.CREATION_DATE,' ||
1115: 'CSD_REPAIR_HISTORY_V.LAST_UPDATED_BY,' ||
1116: 'CSD_REPAIR_HISTORY_V.LAST_UPDATE_DATE,' ||
1117: 'CSD_REPAIR_HISTORY_V.LAST_UPDATE_LOGIN,' ||
1118: 'CSD_REPAIR_HISTORY_V.REPAIR_LINE_ID,' ||
1119: 'CSD_REPAIR_HISTORY_V.EVENT_CODE,' ||
1120: 'CSD_REPAIR_HISTORY_V.EVENT_MEANING,' ||
1121: 'CSD_REPAIR_HISTORY_V.EVENT_DATE,' ||
1122: 'CSD_REPAIR_HISTORY_V.QUANTITY,' ||

Line 1119: 'CSD_REPAIR_HISTORY_V.EVENT_CODE,' ||

1115: 'CSD_REPAIR_HISTORY_V.LAST_UPDATED_BY,' ||
1116: 'CSD_REPAIR_HISTORY_V.LAST_UPDATE_DATE,' ||
1117: 'CSD_REPAIR_HISTORY_V.LAST_UPDATE_LOGIN,' ||
1118: 'CSD_REPAIR_HISTORY_V.REPAIR_LINE_ID,' ||
1119: 'CSD_REPAIR_HISTORY_V.EVENT_CODE,' ||
1120: 'CSD_REPAIR_HISTORY_V.EVENT_MEANING,' ||
1121: 'CSD_REPAIR_HISTORY_V.EVENT_DATE,' ||
1122: 'CSD_REPAIR_HISTORY_V.QUANTITY,' ||
1123: 'CSD_REPAIR_HISTORY_V.PARAMN1,' ||

Line 1120: 'CSD_REPAIR_HISTORY_V.EVENT_MEANING,' ||

1116: 'CSD_REPAIR_HISTORY_V.LAST_UPDATE_DATE,' ||
1117: 'CSD_REPAIR_HISTORY_V.LAST_UPDATE_LOGIN,' ||
1118: 'CSD_REPAIR_HISTORY_V.REPAIR_LINE_ID,' ||
1119: 'CSD_REPAIR_HISTORY_V.EVENT_CODE,' ||
1120: 'CSD_REPAIR_HISTORY_V.EVENT_MEANING,' ||
1121: 'CSD_REPAIR_HISTORY_V.EVENT_DATE,' ||
1122: 'CSD_REPAIR_HISTORY_V.QUANTITY,' ||
1123: 'CSD_REPAIR_HISTORY_V.PARAMN1,' ||
1124: 'CSD_REPAIR_HISTORY_V.PARAMN2,' ||

Line 1121: 'CSD_REPAIR_HISTORY_V.EVENT_DATE,' ||

1117: 'CSD_REPAIR_HISTORY_V.LAST_UPDATE_LOGIN,' ||
1118: 'CSD_REPAIR_HISTORY_V.REPAIR_LINE_ID,' ||
1119: 'CSD_REPAIR_HISTORY_V.EVENT_CODE,' ||
1120: 'CSD_REPAIR_HISTORY_V.EVENT_MEANING,' ||
1121: 'CSD_REPAIR_HISTORY_V.EVENT_DATE,' ||
1122: 'CSD_REPAIR_HISTORY_V.QUANTITY,' ||
1123: 'CSD_REPAIR_HISTORY_V.PARAMN1,' ||
1124: 'CSD_REPAIR_HISTORY_V.PARAMN2,' ||
1125: 'CSD_REPAIR_HISTORY_V.PARAMN3,' ||

Line 1122: 'CSD_REPAIR_HISTORY_V.QUANTITY,' ||

1118: 'CSD_REPAIR_HISTORY_V.REPAIR_LINE_ID,' ||
1119: 'CSD_REPAIR_HISTORY_V.EVENT_CODE,' ||
1120: 'CSD_REPAIR_HISTORY_V.EVENT_MEANING,' ||
1121: 'CSD_REPAIR_HISTORY_V.EVENT_DATE,' ||
1122: 'CSD_REPAIR_HISTORY_V.QUANTITY,' ||
1123: 'CSD_REPAIR_HISTORY_V.PARAMN1,' ||
1124: 'CSD_REPAIR_HISTORY_V.PARAMN2,' ||
1125: 'CSD_REPAIR_HISTORY_V.PARAMN3,' ||
1126: 'CSD_REPAIR_HISTORY_V.PARAMN4,' ||

Line 1123: 'CSD_REPAIR_HISTORY_V.PARAMN1,' ||

1119: 'CSD_REPAIR_HISTORY_V.EVENT_CODE,' ||
1120: 'CSD_REPAIR_HISTORY_V.EVENT_MEANING,' ||
1121: 'CSD_REPAIR_HISTORY_V.EVENT_DATE,' ||
1122: 'CSD_REPAIR_HISTORY_V.QUANTITY,' ||
1123: 'CSD_REPAIR_HISTORY_V.PARAMN1,' ||
1124: 'CSD_REPAIR_HISTORY_V.PARAMN2,' ||
1125: 'CSD_REPAIR_HISTORY_V.PARAMN3,' ||
1126: 'CSD_REPAIR_HISTORY_V.PARAMN4,' ||
1127: 'CSD_REPAIR_HISTORY_V.PARAMN5,' ||

Line 1124: 'CSD_REPAIR_HISTORY_V.PARAMN2,' ||

1120: 'CSD_REPAIR_HISTORY_V.EVENT_MEANING,' ||
1121: 'CSD_REPAIR_HISTORY_V.EVENT_DATE,' ||
1122: 'CSD_REPAIR_HISTORY_V.QUANTITY,' ||
1123: 'CSD_REPAIR_HISTORY_V.PARAMN1,' ||
1124: 'CSD_REPAIR_HISTORY_V.PARAMN2,' ||
1125: 'CSD_REPAIR_HISTORY_V.PARAMN3,' ||
1126: 'CSD_REPAIR_HISTORY_V.PARAMN4,' ||
1127: 'CSD_REPAIR_HISTORY_V.PARAMN5,' ||
1128: 'CSD_REPAIR_HISTORY_V.PARAMN6,' ||

Line 1125: 'CSD_REPAIR_HISTORY_V.PARAMN3,' ||

1121: 'CSD_REPAIR_HISTORY_V.EVENT_DATE,' ||
1122: 'CSD_REPAIR_HISTORY_V.QUANTITY,' ||
1123: 'CSD_REPAIR_HISTORY_V.PARAMN1,' ||
1124: 'CSD_REPAIR_HISTORY_V.PARAMN2,' ||
1125: 'CSD_REPAIR_HISTORY_V.PARAMN3,' ||
1126: 'CSD_REPAIR_HISTORY_V.PARAMN4,' ||
1127: 'CSD_REPAIR_HISTORY_V.PARAMN5,' ||
1128: 'CSD_REPAIR_HISTORY_V.PARAMN6,' ||
1129: 'CSD_REPAIR_HISTORY_V.PARAMN7,' ||

Line 1126: 'CSD_REPAIR_HISTORY_V.PARAMN4,' ||

1122: 'CSD_REPAIR_HISTORY_V.QUANTITY,' ||
1123: 'CSD_REPAIR_HISTORY_V.PARAMN1,' ||
1124: 'CSD_REPAIR_HISTORY_V.PARAMN2,' ||
1125: 'CSD_REPAIR_HISTORY_V.PARAMN3,' ||
1126: 'CSD_REPAIR_HISTORY_V.PARAMN4,' ||
1127: 'CSD_REPAIR_HISTORY_V.PARAMN5,' ||
1128: 'CSD_REPAIR_HISTORY_V.PARAMN6,' ||
1129: 'CSD_REPAIR_HISTORY_V.PARAMN7,' ||
1130: 'CSD_REPAIR_HISTORY_V.PARAMN8,' ||

Line 1127: 'CSD_REPAIR_HISTORY_V.PARAMN5,' ||

1123: 'CSD_REPAIR_HISTORY_V.PARAMN1,' ||
1124: 'CSD_REPAIR_HISTORY_V.PARAMN2,' ||
1125: 'CSD_REPAIR_HISTORY_V.PARAMN3,' ||
1126: 'CSD_REPAIR_HISTORY_V.PARAMN4,' ||
1127: 'CSD_REPAIR_HISTORY_V.PARAMN5,' ||
1128: 'CSD_REPAIR_HISTORY_V.PARAMN6,' ||
1129: 'CSD_REPAIR_HISTORY_V.PARAMN7,' ||
1130: 'CSD_REPAIR_HISTORY_V.PARAMN8,' ||
1131: 'CSD_REPAIR_HISTORY_V.PARAMN9,' ||

Line 1128: 'CSD_REPAIR_HISTORY_V.PARAMN6,' ||

1124: 'CSD_REPAIR_HISTORY_V.PARAMN2,' ||
1125: 'CSD_REPAIR_HISTORY_V.PARAMN3,' ||
1126: 'CSD_REPAIR_HISTORY_V.PARAMN4,' ||
1127: 'CSD_REPAIR_HISTORY_V.PARAMN5,' ||
1128: 'CSD_REPAIR_HISTORY_V.PARAMN6,' ||
1129: 'CSD_REPAIR_HISTORY_V.PARAMN7,' ||
1130: 'CSD_REPAIR_HISTORY_V.PARAMN8,' ||
1131: 'CSD_REPAIR_HISTORY_V.PARAMN9,' ||
1132: 'CSD_REPAIR_HISTORY_V.PARAMN10,' ||

Line 1129: 'CSD_REPAIR_HISTORY_V.PARAMN7,' ||

1125: 'CSD_REPAIR_HISTORY_V.PARAMN3,' ||
1126: 'CSD_REPAIR_HISTORY_V.PARAMN4,' ||
1127: 'CSD_REPAIR_HISTORY_V.PARAMN5,' ||
1128: 'CSD_REPAIR_HISTORY_V.PARAMN6,' ||
1129: 'CSD_REPAIR_HISTORY_V.PARAMN7,' ||
1130: 'CSD_REPAIR_HISTORY_V.PARAMN8,' ||
1131: 'CSD_REPAIR_HISTORY_V.PARAMN9,' ||
1132: 'CSD_REPAIR_HISTORY_V.PARAMN10,' ||
1133: 'CSD_REPAIR_HISTORY_V.PARAMC1,' ||

Line 1130: 'CSD_REPAIR_HISTORY_V.PARAMN8,' ||

1126: 'CSD_REPAIR_HISTORY_V.PARAMN4,' ||
1127: 'CSD_REPAIR_HISTORY_V.PARAMN5,' ||
1128: 'CSD_REPAIR_HISTORY_V.PARAMN6,' ||
1129: 'CSD_REPAIR_HISTORY_V.PARAMN7,' ||
1130: 'CSD_REPAIR_HISTORY_V.PARAMN8,' ||
1131: 'CSD_REPAIR_HISTORY_V.PARAMN9,' ||
1132: 'CSD_REPAIR_HISTORY_V.PARAMN10,' ||
1133: 'CSD_REPAIR_HISTORY_V.PARAMC1,' ||
1134: 'CSD_REPAIR_HISTORY_V.PARAMC2,' ||

Line 1131: 'CSD_REPAIR_HISTORY_V.PARAMN9,' ||

1127: 'CSD_REPAIR_HISTORY_V.PARAMN5,' ||
1128: 'CSD_REPAIR_HISTORY_V.PARAMN6,' ||
1129: 'CSD_REPAIR_HISTORY_V.PARAMN7,' ||
1130: 'CSD_REPAIR_HISTORY_V.PARAMN8,' ||
1131: 'CSD_REPAIR_HISTORY_V.PARAMN9,' ||
1132: 'CSD_REPAIR_HISTORY_V.PARAMN10,' ||
1133: 'CSD_REPAIR_HISTORY_V.PARAMC1,' ||
1134: 'CSD_REPAIR_HISTORY_V.PARAMC2,' ||
1135: 'CSD_REPAIR_HISTORY_V.PARAMC3,' ||

Line 1132: 'CSD_REPAIR_HISTORY_V.PARAMN10,' ||

1128: 'CSD_REPAIR_HISTORY_V.PARAMN6,' ||
1129: 'CSD_REPAIR_HISTORY_V.PARAMN7,' ||
1130: 'CSD_REPAIR_HISTORY_V.PARAMN8,' ||
1131: 'CSD_REPAIR_HISTORY_V.PARAMN9,' ||
1132: 'CSD_REPAIR_HISTORY_V.PARAMN10,' ||
1133: 'CSD_REPAIR_HISTORY_V.PARAMC1,' ||
1134: 'CSD_REPAIR_HISTORY_V.PARAMC2,' ||
1135: 'CSD_REPAIR_HISTORY_V.PARAMC3,' ||
1136: 'CSD_REPAIR_HISTORY_V.PARAMC4,' ||

Line 1133: 'CSD_REPAIR_HISTORY_V.PARAMC1,' ||

1129: 'CSD_REPAIR_HISTORY_V.PARAMN7,' ||
1130: 'CSD_REPAIR_HISTORY_V.PARAMN8,' ||
1131: 'CSD_REPAIR_HISTORY_V.PARAMN9,' ||
1132: 'CSD_REPAIR_HISTORY_V.PARAMN10,' ||
1133: 'CSD_REPAIR_HISTORY_V.PARAMC1,' ||
1134: 'CSD_REPAIR_HISTORY_V.PARAMC2,' ||
1135: 'CSD_REPAIR_HISTORY_V.PARAMC3,' ||
1136: 'CSD_REPAIR_HISTORY_V.PARAMC4,' ||
1137: 'CSD_REPAIR_HISTORY_V.PARAMC5,' ||

Line 1134: 'CSD_REPAIR_HISTORY_V.PARAMC2,' ||

1130: 'CSD_REPAIR_HISTORY_V.PARAMN8,' ||
1131: 'CSD_REPAIR_HISTORY_V.PARAMN9,' ||
1132: 'CSD_REPAIR_HISTORY_V.PARAMN10,' ||
1133: 'CSD_REPAIR_HISTORY_V.PARAMC1,' ||
1134: 'CSD_REPAIR_HISTORY_V.PARAMC2,' ||
1135: 'CSD_REPAIR_HISTORY_V.PARAMC3,' ||
1136: 'CSD_REPAIR_HISTORY_V.PARAMC4,' ||
1137: 'CSD_REPAIR_HISTORY_V.PARAMC5,' ||
1138: 'CSD_REPAIR_HISTORY_V.PARAMC6,' ||

Line 1135: 'CSD_REPAIR_HISTORY_V.PARAMC3,' ||

1131: 'CSD_REPAIR_HISTORY_V.PARAMN9,' ||
1132: 'CSD_REPAIR_HISTORY_V.PARAMN10,' ||
1133: 'CSD_REPAIR_HISTORY_V.PARAMC1,' ||
1134: 'CSD_REPAIR_HISTORY_V.PARAMC2,' ||
1135: 'CSD_REPAIR_HISTORY_V.PARAMC3,' ||
1136: 'CSD_REPAIR_HISTORY_V.PARAMC4,' ||
1137: 'CSD_REPAIR_HISTORY_V.PARAMC5,' ||
1138: 'CSD_REPAIR_HISTORY_V.PARAMC6,' ||
1139: 'CSD_REPAIR_HISTORY_V.PARAMC7,' ||

Line 1136: 'CSD_REPAIR_HISTORY_V.PARAMC4,' ||

1132: 'CSD_REPAIR_HISTORY_V.PARAMN10,' ||
1133: 'CSD_REPAIR_HISTORY_V.PARAMC1,' ||
1134: 'CSD_REPAIR_HISTORY_V.PARAMC2,' ||
1135: 'CSD_REPAIR_HISTORY_V.PARAMC3,' ||
1136: 'CSD_REPAIR_HISTORY_V.PARAMC4,' ||
1137: 'CSD_REPAIR_HISTORY_V.PARAMC5,' ||
1138: 'CSD_REPAIR_HISTORY_V.PARAMC6,' ||
1139: 'CSD_REPAIR_HISTORY_V.PARAMC7,' ||
1140: 'CSD_REPAIR_HISTORY_V.PARAMC8,' ||

Line 1137: 'CSD_REPAIR_HISTORY_V.PARAMC5,' ||

1133: 'CSD_REPAIR_HISTORY_V.PARAMC1,' ||
1134: 'CSD_REPAIR_HISTORY_V.PARAMC2,' ||
1135: 'CSD_REPAIR_HISTORY_V.PARAMC3,' ||
1136: 'CSD_REPAIR_HISTORY_V.PARAMC4,' ||
1137: 'CSD_REPAIR_HISTORY_V.PARAMC5,' ||
1138: 'CSD_REPAIR_HISTORY_V.PARAMC6,' ||
1139: 'CSD_REPAIR_HISTORY_V.PARAMC7,' ||
1140: 'CSD_REPAIR_HISTORY_V.PARAMC8,' ||
1141: 'CSD_REPAIR_HISTORY_V.PARAMC9,' ||

Line 1138: 'CSD_REPAIR_HISTORY_V.PARAMC6,' ||

1134: 'CSD_REPAIR_HISTORY_V.PARAMC2,' ||
1135: 'CSD_REPAIR_HISTORY_V.PARAMC3,' ||
1136: 'CSD_REPAIR_HISTORY_V.PARAMC4,' ||
1137: 'CSD_REPAIR_HISTORY_V.PARAMC5,' ||
1138: 'CSD_REPAIR_HISTORY_V.PARAMC6,' ||
1139: 'CSD_REPAIR_HISTORY_V.PARAMC7,' ||
1140: 'CSD_REPAIR_HISTORY_V.PARAMC8,' ||
1141: 'CSD_REPAIR_HISTORY_V.PARAMC9,' ||
1142: 'CSD_REPAIR_HISTORY_V.PARAMC10,' ||

Line 1139: 'CSD_REPAIR_HISTORY_V.PARAMC7,' ||

1135: 'CSD_REPAIR_HISTORY_V.PARAMC3,' ||
1136: 'CSD_REPAIR_HISTORY_V.PARAMC4,' ||
1137: 'CSD_REPAIR_HISTORY_V.PARAMC5,' ||
1138: 'CSD_REPAIR_HISTORY_V.PARAMC6,' ||
1139: 'CSD_REPAIR_HISTORY_V.PARAMC7,' ||
1140: 'CSD_REPAIR_HISTORY_V.PARAMC8,' ||
1141: 'CSD_REPAIR_HISTORY_V.PARAMC9,' ||
1142: 'CSD_REPAIR_HISTORY_V.PARAMC10,' ||
1143: 'CSD_REPAIR_HISTORY_V.PARAMD1,' ||

Line 1140: 'CSD_REPAIR_HISTORY_V.PARAMC8,' ||

1136: 'CSD_REPAIR_HISTORY_V.PARAMC4,' ||
1137: 'CSD_REPAIR_HISTORY_V.PARAMC5,' ||
1138: 'CSD_REPAIR_HISTORY_V.PARAMC6,' ||
1139: 'CSD_REPAIR_HISTORY_V.PARAMC7,' ||
1140: 'CSD_REPAIR_HISTORY_V.PARAMC8,' ||
1141: 'CSD_REPAIR_HISTORY_V.PARAMC9,' ||
1142: 'CSD_REPAIR_HISTORY_V.PARAMC10,' ||
1143: 'CSD_REPAIR_HISTORY_V.PARAMD1,' ||
1144: 'CSD_REPAIR_HISTORY_V.PARAMD2,' ||

Line 1141: 'CSD_REPAIR_HISTORY_V.PARAMC9,' ||

1137: 'CSD_REPAIR_HISTORY_V.PARAMC5,' ||
1138: 'CSD_REPAIR_HISTORY_V.PARAMC6,' ||
1139: 'CSD_REPAIR_HISTORY_V.PARAMC7,' ||
1140: 'CSD_REPAIR_HISTORY_V.PARAMC8,' ||
1141: 'CSD_REPAIR_HISTORY_V.PARAMC9,' ||
1142: 'CSD_REPAIR_HISTORY_V.PARAMC10,' ||
1143: 'CSD_REPAIR_HISTORY_V.PARAMD1,' ||
1144: 'CSD_REPAIR_HISTORY_V.PARAMD2,' ||
1145: 'CSD_REPAIR_HISTORY_V.PARAMD3,' ||

Line 1142: 'CSD_REPAIR_HISTORY_V.PARAMC10,' ||

1138: 'CSD_REPAIR_HISTORY_V.PARAMC6,' ||
1139: 'CSD_REPAIR_HISTORY_V.PARAMC7,' ||
1140: 'CSD_REPAIR_HISTORY_V.PARAMC8,' ||
1141: 'CSD_REPAIR_HISTORY_V.PARAMC9,' ||
1142: 'CSD_REPAIR_HISTORY_V.PARAMC10,' ||
1143: 'CSD_REPAIR_HISTORY_V.PARAMD1,' ||
1144: 'CSD_REPAIR_HISTORY_V.PARAMD2,' ||
1145: 'CSD_REPAIR_HISTORY_V.PARAMD3,' ||
1146: 'CSD_REPAIR_HISTORY_V.PARAMD4,' ||

Line 1143: 'CSD_REPAIR_HISTORY_V.PARAMD1,' ||

1139: 'CSD_REPAIR_HISTORY_V.PARAMC7,' ||
1140: 'CSD_REPAIR_HISTORY_V.PARAMC8,' ||
1141: 'CSD_REPAIR_HISTORY_V.PARAMC9,' ||
1142: 'CSD_REPAIR_HISTORY_V.PARAMC10,' ||
1143: 'CSD_REPAIR_HISTORY_V.PARAMD1,' ||
1144: 'CSD_REPAIR_HISTORY_V.PARAMD2,' ||
1145: 'CSD_REPAIR_HISTORY_V.PARAMD3,' ||
1146: 'CSD_REPAIR_HISTORY_V.PARAMD4,' ||
1147: 'CSD_REPAIR_HISTORY_V.PARAMD5,' ||

Line 1144: 'CSD_REPAIR_HISTORY_V.PARAMD2,' ||

1140: 'CSD_REPAIR_HISTORY_V.PARAMC8,' ||
1141: 'CSD_REPAIR_HISTORY_V.PARAMC9,' ||
1142: 'CSD_REPAIR_HISTORY_V.PARAMC10,' ||
1143: 'CSD_REPAIR_HISTORY_V.PARAMD1,' ||
1144: 'CSD_REPAIR_HISTORY_V.PARAMD2,' ||
1145: 'CSD_REPAIR_HISTORY_V.PARAMD3,' ||
1146: 'CSD_REPAIR_HISTORY_V.PARAMD4,' ||
1147: 'CSD_REPAIR_HISTORY_V.PARAMD5,' ||
1148: 'CSD_REPAIR_HISTORY_V.PARAMD6,' ||

Line 1145: 'CSD_REPAIR_HISTORY_V.PARAMD3,' ||

1141: 'CSD_REPAIR_HISTORY_V.PARAMC9,' ||
1142: 'CSD_REPAIR_HISTORY_V.PARAMC10,' ||
1143: 'CSD_REPAIR_HISTORY_V.PARAMD1,' ||
1144: 'CSD_REPAIR_HISTORY_V.PARAMD2,' ||
1145: 'CSD_REPAIR_HISTORY_V.PARAMD3,' ||
1146: 'CSD_REPAIR_HISTORY_V.PARAMD4,' ||
1147: 'CSD_REPAIR_HISTORY_V.PARAMD5,' ||
1148: 'CSD_REPAIR_HISTORY_V.PARAMD6,' ||
1149: 'CSD_REPAIR_HISTORY_V.PARAMD7,' ||

Line 1146: 'CSD_REPAIR_HISTORY_V.PARAMD4,' ||

1142: 'CSD_REPAIR_HISTORY_V.PARAMC10,' ||
1143: 'CSD_REPAIR_HISTORY_V.PARAMD1,' ||
1144: 'CSD_REPAIR_HISTORY_V.PARAMD2,' ||
1145: 'CSD_REPAIR_HISTORY_V.PARAMD3,' ||
1146: 'CSD_REPAIR_HISTORY_V.PARAMD4,' ||
1147: 'CSD_REPAIR_HISTORY_V.PARAMD5,' ||
1148: 'CSD_REPAIR_HISTORY_V.PARAMD6,' ||
1149: 'CSD_REPAIR_HISTORY_V.PARAMD7,' ||
1150: 'CSD_REPAIR_HISTORY_V.PARAMD8,' ||

Line 1147: 'CSD_REPAIR_HISTORY_V.PARAMD5,' ||

1143: 'CSD_REPAIR_HISTORY_V.PARAMD1,' ||
1144: 'CSD_REPAIR_HISTORY_V.PARAMD2,' ||
1145: 'CSD_REPAIR_HISTORY_V.PARAMD3,' ||
1146: 'CSD_REPAIR_HISTORY_V.PARAMD4,' ||
1147: 'CSD_REPAIR_HISTORY_V.PARAMD5,' ||
1148: 'CSD_REPAIR_HISTORY_V.PARAMD6,' ||
1149: 'CSD_REPAIR_HISTORY_V.PARAMD7,' ||
1150: 'CSD_REPAIR_HISTORY_V.PARAMD8,' ||
1151: 'CSD_REPAIR_HISTORY_V.PARAMD9,' ||

Line 1148: 'CSD_REPAIR_HISTORY_V.PARAMD6,' ||

1144: 'CSD_REPAIR_HISTORY_V.PARAMD2,' ||
1145: 'CSD_REPAIR_HISTORY_V.PARAMD3,' ||
1146: 'CSD_REPAIR_HISTORY_V.PARAMD4,' ||
1147: 'CSD_REPAIR_HISTORY_V.PARAMD5,' ||
1148: 'CSD_REPAIR_HISTORY_V.PARAMD6,' ||
1149: 'CSD_REPAIR_HISTORY_V.PARAMD7,' ||
1150: 'CSD_REPAIR_HISTORY_V.PARAMD8,' ||
1151: 'CSD_REPAIR_HISTORY_V.PARAMD9,' ||
1152: 'CSD_REPAIR_HISTORY_V.PARAMD10,' ||

Line 1149: 'CSD_REPAIR_HISTORY_V.PARAMD7,' ||

1145: 'CSD_REPAIR_HISTORY_V.PARAMD3,' ||
1146: 'CSD_REPAIR_HISTORY_V.PARAMD4,' ||
1147: 'CSD_REPAIR_HISTORY_V.PARAMD5,' ||
1148: 'CSD_REPAIR_HISTORY_V.PARAMD6,' ||
1149: 'CSD_REPAIR_HISTORY_V.PARAMD7,' ||
1150: 'CSD_REPAIR_HISTORY_V.PARAMD8,' ||
1151: 'CSD_REPAIR_HISTORY_V.PARAMD9,' ||
1152: 'CSD_REPAIR_HISTORY_V.PARAMD10,' ||
1153: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE_CATEGORY,' ||

Line 1150: 'CSD_REPAIR_HISTORY_V.PARAMD8,' ||

1146: 'CSD_REPAIR_HISTORY_V.PARAMD4,' ||
1147: 'CSD_REPAIR_HISTORY_V.PARAMD5,' ||
1148: 'CSD_REPAIR_HISTORY_V.PARAMD6,' ||
1149: 'CSD_REPAIR_HISTORY_V.PARAMD7,' ||
1150: 'CSD_REPAIR_HISTORY_V.PARAMD8,' ||
1151: 'CSD_REPAIR_HISTORY_V.PARAMD9,' ||
1152: 'CSD_REPAIR_HISTORY_V.PARAMD10,' ||
1153: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE_CATEGORY,' ||
1154: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE1,' ||

Line 1151: 'CSD_REPAIR_HISTORY_V.PARAMD9,' ||

1147: 'CSD_REPAIR_HISTORY_V.PARAMD5,' ||
1148: 'CSD_REPAIR_HISTORY_V.PARAMD6,' ||
1149: 'CSD_REPAIR_HISTORY_V.PARAMD7,' ||
1150: 'CSD_REPAIR_HISTORY_V.PARAMD8,' ||
1151: 'CSD_REPAIR_HISTORY_V.PARAMD9,' ||
1152: 'CSD_REPAIR_HISTORY_V.PARAMD10,' ||
1153: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE_CATEGORY,' ||
1154: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE1,' ||
1155: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE2,' ||

Line 1152: 'CSD_REPAIR_HISTORY_V.PARAMD10,' ||

1148: 'CSD_REPAIR_HISTORY_V.PARAMD6,' ||
1149: 'CSD_REPAIR_HISTORY_V.PARAMD7,' ||
1150: 'CSD_REPAIR_HISTORY_V.PARAMD8,' ||
1151: 'CSD_REPAIR_HISTORY_V.PARAMD9,' ||
1152: 'CSD_REPAIR_HISTORY_V.PARAMD10,' ||
1153: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE_CATEGORY,' ||
1154: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE1,' ||
1155: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE2,' ||
1156: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE3,' ||

Line 1153: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE_CATEGORY,' ||

1149: 'CSD_REPAIR_HISTORY_V.PARAMD7,' ||
1150: 'CSD_REPAIR_HISTORY_V.PARAMD8,' ||
1151: 'CSD_REPAIR_HISTORY_V.PARAMD9,' ||
1152: 'CSD_REPAIR_HISTORY_V.PARAMD10,' ||
1153: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE_CATEGORY,' ||
1154: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE1,' ||
1155: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE2,' ||
1156: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE3,' ||
1157: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE4,' ||

Line 1154: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE1,' ||

1150: 'CSD_REPAIR_HISTORY_V.PARAMD8,' ||
1151: 'CSD_REPAIR_HISTORY_V.PARAMD9,' ||
1152: 'CSD_REPAIR_HISTORY_V.PARAMD10,' ||
1153: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE_CATEGORY,' ||
1154: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE1,' ||
1155: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE2,' ||
1156: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE3,' ||
1157: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE4,' ||
1158: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE5,' ||

Line 1155: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE2,' ||

1151: 'CSD_REPAIR_HISTORY_V.PARAMD9,' ||
1152: 'CSD_REPAIR_HISTORY_V.PARAMD10,' ||
1153: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE_CATEGORY,' ||
1154: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE1,' ||
1155: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE2,' ||
1156: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE3,' ||
1157: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE4,' ||
1158: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE5,' ||
1159: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE6,' ||

Line 1156: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE3,' ||

1152: 'CSD_REPAIR_HISTORY_V.PARAMD10,' ||
1153: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE_CATEGORY,' ||
1154: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE1,' ||
1155: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE2,' ||
1156: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE3,' ||
1157: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE4,' ||
1158: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE5,' ||
1159: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE6,' ||
1160: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE7,' ||

Line 1157: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE4,' ||

1153: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE_CATEGORY,' ||
1154: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE1,' ||
1155: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE2,' ||
1156: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE3,' ||
1157: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE4,' ||
1158: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE5,' ||
1159: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE6,' ||
1160: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE7,' ||
1161: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE8,' ||

Line 1158: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE5,' ||

1154: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE1,' ||
1155: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE2,' ||
1156: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE3,' ||
1157: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE4,' ||
1158: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE5,' ||
1159: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE6,' ||
1160: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE7,' ||
1161: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE8,' ||
1162: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE9,' ||

Line 1159: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE6,' ||

1155: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE2,' ||
1156: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE3,' ||
1157: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE4,' ||
1158: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE5,' ||
1159: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE6,' ||
1160: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE7,' ||
1161: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE8,' ||
1162: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE9,' ||
1163: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE10,' ||

Line 1160: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE7,' ||

1156: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE3,' ||
1157: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE4,' ||
1158: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE5,' ||
1159: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE6,' ||
1160: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE7,' ||
1161: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE8,' ||
1162: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE9,' ||
1163: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE10,' ||
1164: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE11,' ||

Line 1161: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE8,' ||

1157: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE4,' ||
1158: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE5,' ||
1159: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE6,' ||
1160: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE7,' ||
1161: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE8,' ||
1162: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE9,' ||
1163: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE10,' ||
1164: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE11,' ||
1165: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE12,' ||

Line 1162: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE9,' ||

1158: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE5,' ||
1159: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE6,' ||
1160: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE7,' ||
1161: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE8,' ||
1162: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE9,' ||
1163: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE10,' ||
1164: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE11,' ||
1165: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE12,' ||
1166: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE13,' ||

Line 1163: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE10,' ||

1159: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE6,' ||
1160: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE7,' ||
1161: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE8,' ||
1162: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE9,' ||
1163: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE10,' ||
1164: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE11,' ||
1165: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE12,' ||
1166: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE13,' ||
1167: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE14,' ||

Line 1164: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE11,' ||

1160: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE7,' ||
1161: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE8,' ||
1162: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE9,' ||
1163: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE10,' ||
1164: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE11,' ||
1165: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE12,' ||
1166: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE13,' ||
1167: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE14,' ||
1168: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE15,' ||

Line 1165: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE12,' ||

1161: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE8,' ||
1162: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE9,' ||
1163: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE10,' ||
1164: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE11,' ||
1165: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE12,' ||
1166: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE13,' ||
1167: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE14,' ||
1168: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE15,' ||
1169: 'CSD_REPAIR_HISTORY_V.OBJECT_VERSION_NUMBER' ||

Line 1166: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE13,' ||

1162: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE9,' ||
1163: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE10,' ||
1164: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE11,' ||
1165: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE12,' ||
1166: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE13,' ||
1167: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE14,' ||
1168: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE15,' ||
1169: 'CSD_REPAIR_HISTORY_V.OBJECT_VERSION_NUMBER' ||
1170: 'from CSD_REPAIR_HISTORY_V';

Line 1167: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE14,' ||

1163: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE10,' ||
1164: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE11,' ||
1165: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE12,' ||
1166: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE13,' ||
1167: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE14,' ||
1168: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE15,' ||
1169: 'CSD_REPAIR_HISTORY_V.OBJECT_VERSION_NUMBER' ||
1170: 'from CSD_REPAIR_HISTORY_V';
1171: -- Debug Message

Line 1168: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE15,' ||

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

Line 1169: 'CSD_REPAIR_HISTORY_V.OBJECT_VERSION_NUMBER' ||

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

Line 1170: 'from CSD_REPAIR_HISTORY_V';

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

Line 1177: P_REPH_Rec IN CSD_REPAIR_HISTORY_PVT.REPH_Rec_Type,

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

Line 1341: l_REPH_rec CSD_REPAIR_HISTORY_Pvt.REPH_Rec_Type;

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

Line 1342: l_crit_REPH_rec CSD_REPAIR_HISTORY_Pvt.REPH_Rec_Type;

1338: l_counter NUMBER;
1339:
1340: -- Local scratch record
1341: l_REPH_rec CSD_REPAIR_HISTORY_Pvt.REPH_Rec_Type;
1342: l_crit_REPH_rec CSD_REPAIR_HISTORY_Pvt.REPH_Rec_Type;
1343: BEGIN
1344: -- Standard Start of API savepoint
1345: SAVEPOINT GET_REPAIR_HISTORY_PVT;
1346:

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

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

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

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

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

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

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

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

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

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

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

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

Line 3385: FROM CSD_REPAIR_HISTORY

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

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

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

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

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

Line 3962: End CSD_REPAIR_HISTORY_PVT;

3958: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: ' || l_api_name || 'end');
3959:
3960: END Validate_repair_history;
3961:
3962: End CSD_REPAIR_HISTORY_PVT;