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 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 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 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 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 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 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 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 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 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 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;