APPS.CSD_REPAIR_ACTUAL_LINES_PVT dependencies on CSD_REPAIR_ACTUALS

Line 65: lx_csd_actuals_rec CSD_REPAIR_ACTUALS_PVT.CSD_REPAIR_ACTUALS_REC_TYPE;

61: l_msg_index NUMBER;
62:
63: l_api_return_status VARCHAR2(3);
64: l_act_count NUMBER;
65: lx_csd_actuals_rec CSD_REPAIR_ACTUALS_PVT.CSD_REPAIR_ACTUALS_REC_TYPE;
66: lx_charges_rec CS_CHARGE_DETAILS_PUB.CHARGES_REC_TYPE;
67:
68: x_actual_header_id NUMBER := NULL;
69:

Line 177: from csd_repair_actuals

173: l_act_count := -1;
174:
175: select count(*)
176: into l_act_count
177: from csd_repair_actuals
178: where repair_line_id = px_CSD_ACTUAL_LINES_REC.repair_line_id;
179: Exception
180: when others then
181: IF ( Fnd_Log.Level_Exception >= G_debug_level) THEN

Line 225: FND_LOG.STRING(Fnd_Log.Level_Procedure,l_mod_name,'Calling csd_repair_actuals_pvt.create_repair_actuals');

221: lx_csd_actuals_rec.BILL_TO_PARTY_SITE_ID := NULL;
222:
223:
224: IF ( Fnd_Log.Level_Procedure >= G_debug_level) THEN
225: FND_LOG.STRING(Fnd_Log.Level_Procedure,l_mod_name,'Calling csd_repair_actuals_pvt.create_repair_actuals');
226: END IF;
227:
228: -- call API to create Repair Actuals header
229: csd_repair_actuals_pvt.create_repair_actuals

Line 229: csd_repair_actuals_pvt.create_repair_actuals

225: FND_LOG.STRING(Fnd_Log.Level_Procedure,l_mod_name,'Calling csd_repair_actuals_pvt.create_repair_actuals');
226: END IF;
227:
228: -- call API to create Repair Actuals header
229: csd_repair_actuals_pvt.create_repair_actuals
230: ( P_Api_Version => 1.0,
231: P_Commit => 'F',
232: P_Init_Msg_List => 'T',
233: p_validation_level => 10,

Line 234: px_CSD_REPAIR_ACTUALS_REC => lx_csd_actuals_rec,

230: ( P_Api_Version => 1.0,
231: P_Commit => 'F',
232: P_Init_Msg_List => 'T',
233: p_validation_level => 10,
234: px_CSD_REPAIR_ACTUALS_REC => lx_csd_actuals_rec,
235: X_Return_Status => x_return_status,
236: X_Msg_Count => x_msg_count,
237: X_Msg_Data => x_msg_data);
238:

Line 241: FND_LOG.STRING(Fnd_Log.Level_Procedure,l_mod_name,'csd_repair_actuals_pvt.create_repair_actuals failed');

237: X_Msg_Data => x_msg_data);
238:
239: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
240: IF ( Fnd_Log.Level_Procedure >= G_debug_level) THEN
241: FND_LOG.STRING(Fnd_Log.Level_Procedure,l_mod_name,'csd_repair_actuals_pvt.create_repair_actuals failed');
242: END IF;
243: RAISE FND_API.G_EXC_ERROR;
244: END IF;
245:

Line 264: from csd_repair_actuals

260: l_act_hdr := -1;
261:
262: select repair_actual_id
263: into l_act_hdr
264: from csd_repair_actuals
265: where repair_line_id = px_CSD_ACTUAL_LINES_REC.repair_line_id;
266: Exception
267: when others then
268: IF ( Fnd_Log.Level_Exception >= G_debug_level) THEN

Line 339: -- Call table handler CSD_REPAIR_ACTUALS_LINES_PKG.Insert_Row to

335: FND_LOG.STRING(Fnd_Log.Level_Statement,l_mod_name,'LAST_UPDATED_BY = '|| FND_GLOBAL.USER_ID);
336: END IF;
337:
338: BEGIN
339: -- Call table handler CSD_REPAIR_ACTUALS_LINES_PKG.Insert_Row to
340: -- insert the record into CSD_REPAIR_ACTUAL_LINES
341: -- Invoke table handler(CSD_REPAIR_ACTUAL_LINES_PKG.Insert_Row)
342: CSD_REPAIR_ACTUAL_LINES_PKG.Insert_Row(
343: px_REPAIR_ACTUAL_LINE_ID => px_CSD_ACTUAL_LINES_REC.REPAIR_ACTUAL_LINE_ID

Line 456: -- Call table handler CSD_REPAIR_ACTUALS_LINES_PKG.Insert_Row to

452: FND_LOG.STRING(Fnd_Log.Level_Statement,l_mod_name,'LAST_UPDATED_BY = '|| FND_GLOBAL.USER_ID);
453: END IF;
454:
455: BEGIN
456: -- Call table handler CSD_REPAIR_ACTUALS_LINES_PKG.Insert_Row to
457: -- insert the record into CSD_REPAIR_ACTUAL_LINES
458: -- Invoke table handler(CSD_REPAIR_ACTUAL_LINES_PKG.Insert_Row)
459: CSD_REPAIR_ACTUAL_LINES_PKG.Insert_Row(
460: px_REPAIR_ACTUAL_LINE_ID => px_CSD_ACTUAL_LINES_REC.REPAIR_ACTUAL_LINE_ID

Line 781: -- Call table handler CSD_REPAIR_ACTUALS_LINES_PKG.Insert_Row to

777: FND_LOG.STRING(Fnd_Log.Level_Procedure,l_mod_name,'Call to CSD_REPAIR_ACTUAL_LINES_REC_PKG.Insert_Row');
778: END IF;
779:
780: BEGIN
781: -- Call table handler CSD_REPAIR_ACTUALS_LINES_PKG.Insert_Row to
782: -- insert the record into CSD_REPAIR_ACTUAL_LINES
783: -- Invoke table handler(CSD_REPAIR_ACTUAL_LINES_PKG.Insert_Row)
784: CSD_REPAIR_ACTUAL_LINES_PKG.Insert_Row(
785: px_REPAIR_ACTUAL_LINE_ID => px_CSD_ACTUAL_LINES_REC.REPAIR_ACTUAL_LINE_ID