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_PVT

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 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 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 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 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 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 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 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 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 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 4421: End CSD_REPAIR_HISTORY_PVT;

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