DBA Data[Home] [Help]

APPS.CSD_REPAIRS_GRP dependencies on CSD_REPAIR_ESTIMATE

Line 683: 'Calling CSD_REPAIR_ESTIMATE_PVT.get_total_estimated_charge ');

679: if (l_event_code is not null) then
680:
681: if (lc_proc_level >= lc_debug_level) then
682: FND_LOG.STRING(lc_proc_level, lc_mod_name,
683: 'Calling CSD_REPAIR_ESTIMATE_PVT.get_total_estimated_charge ');
684: end if;
685: -- get estimate_total sum of charge from csd_repair_estimates_v
686: CSD_REPAIR_ESTIMATE_PVT.get_total_estimated_charge (
687: p_repair_line_id => p_repair_line_id,

Line 685: -- get estimate_total sum of charge from csd_repair_estimates_v

681: if (lc_proc_level >= lc_debug_level) then
682: FND_LOG.STRING(lc_proc_level, lc_mod_name,
683: 'Calling CSD_REPAIR_ESTIMATE_PVT.get_total_estimated_charge ');
684: end if;
685: -- get estimate_total sum of charge from csd_repair_estimates_v
686: CSD_REPAIR_ESTIMATE_PVT.get_total_estimated_charge (
687: p_repair_line_id => p_repair_line_id,
688: x_estimated_charge => l_estimate_total,
689: x_return_status => l_return_status

Line 686: CSD_REPAIR_ESTIMATE_PVT.get_total_estimated_charge (

682: FND_LOG.STRING(lc_proc_level, lc_mod_name,
683: 'Calling CSD_REPAIR_ESTIMATE_PVT.get_total_estimated_charge ');
684: end if;
685: -- get estimate_total sum of charge from csd_repair_estimates_v
686: CSD_REPAIR_ESTIMATE_PVT.get_total_estimated_charge (
687: p_repair_line_id => p_repair_line_id,
688: x_estimated_charge => l_estimate_total,
689: x_return_status => l_return_status
690: );

Line 698: 'Returned from CSD_REPAIR_ESTIMATE_PVT.get_total_estimated_charge. l_estimate_total=' || l_estimate_total);

694:
695:
696: if (lc_proc_level >= lc_debug_level) then
697: FND_LOG.STRING(lc_proc_level, lc_mod_name,
698: 'Returned from CSD_REPAIR_ESTIMATE_PVT.get_total_estimated_charge. l_estimate_total=' || l_estimate_total);
699: FND_LOG.STRING(lc_proc_level, lc_mod_name,
700: 'Calling CSD_TO_FORM_REPAIR_HISTORY.Validate_And_Write ');
701: end if;
702: CSD_TO_FORM_REPAIR_HISTORY.Validate_And_Write

Line 1104: l_rep_est_rec CSD_REPAIR_ESTIMATE_PVT.REPAIR_ESTIMATE_REC;

1100: l_estimate_status VARCHAR2(30);
1101: l_event_code VARCHAR2(30);
1102:
1103: l_rep_ord_rec CSD_REPAIRS_PUB.REPLN_REC_TYPE;
1104: l_rep_est_rec CSD_REPAIR_ESTIMATE_PVT.REPAIR_ESTIMATE_REC;
1105: l_rep_group_rec CSD_REPAIR_GROUPS_PVT.REPAIR_ORDER_GROUP_REC;
1106:
1107: Cursor c_repairs_for_approval ( p_repair_group_id number) is
1108: Select rep.repair_line_id

Line 1115: , csd_repair_estimate est

1111: , rep.object_version_number rep_ovn
1112: , est.repair_estimate_id
1113: , est.object_version_number est_ovn
1114: from csd_repairs rep
1115: , csd_repair_estimate est
1116: where rep.repair_group_id = p_repair_group_id
1117: and rep.repair_line_id = est.repair_line_id
1118: and est.estimate_status = 'BID';
1119:

Line 1335: csd_repair_estimate_pvt.update_repair_estimate

1331: l_rep_est_rec.estimate_status := l_estimate_status;
1332: if (g_debug > 0) then
1333: csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Group_Approval_Status Update RO estimate call');
1334: end if;
1335: csd_repair_estimate_pvt.update_repair_estimate
1336: (p_api_version => 1.0,
1337: p_commit => 'F',
1338: p_init_msg_list => 'T',
1339: p_validation_level => fnd_api.g_valid_level_full,

Line 1350: csd_gen_utility_pvt.ADD('csd_repair_estimate_pvt.update_repair_estimate failed ');

1346: end if;
1347: -- Check return status from the above procedure call
1348: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
1349: if (g_debug > 0) then
1350: csd_gen_utility_pvt.ADD('csd_repair_estimate_pvt.update_repair_estimate failed ');
1351: end if;
1352: RAISE FND_API.G_EXC_ERROR;
1353: --ROLLBACK TO UPDATE_GRP_APPV_STATUS;
1354: --return;

Line 1365: -- update to group is done in the call csd_repair_estimate_pvt.update_repair_estimate

1361:
1362: END LOOP;
1363: -- End of API body.
1364:
1365: -- update to group is done in the call csd_repair_estimate_pvt.update_repair_estimate
1366: -- repair group object version number is not returned in this case
1367:
1368: -------------------------------
1369: -- Standard check for p_commit

Line 1452: l_rep_est_rec CSD_REPAIR_ESTIMATE_PVT.REPAIR_ESTIMATE_REC;

1448: l_estimate_status VARCHAR2(30);
1449: l_event_code VARCHAR2(30);
1450:
1451: l_rep_ord_rec CSD_REPAIRS_PUB.REPLN_REC_TYPE;
1452: l_rep_est_rec CSD_REPAIR_ESTIMATE_PVT.REPAIR_ESTIMATE_REC;
1453: l_rep_group_rec CSD_REPAIR_GROUPS_PVT.REPAIR_ORDER_GROUP_REC;
1454:
1455: Cursor c_repairs_for_Reject ( p_repair_group_id number) is
1456: Select rep.repair_line_id

Line 1463: , csd_repair_estimate est

1459: , rep.object_version_number rep_ovn
1460: , est.repair_estimate_id
1461: , est.object_version_number est_ovn
1462: from csd_repairs rep
1463: , csd_repair_estimate est
1464: where rep.repair_group_id = p_repair_group_id
1465: and rep.repair_line_id = est.repair_line_id;
1466:
1467:

Line 1683: csd_repair_estimate_pvt.update_repair_estimate

1679: l_rep_est_rec.estimate_status := l_estimate_status;
1680: if (g_debug > 0) then
1681: csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Group_Reject_Status Update RO estimate call');
1682: end if;
1683: csd_repair_estimate_pvt.update_repair_estimate
1684: (p_api_version => 1.0,
1685: p_commit => 'F',
1686: p_init_msg_list => 'T',
1687: p_validation_level => fnd_api.g_valid_level_full,

Line 1698: csd_gen_utility_pvt.ADD('csd_repair_estimate_pvt.update_repair_estimate failed ');

1694: end if;
1695: -- Check return status from the above procedure call
1696: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
1697: if (g_debug > 0) then
1698: csd_gen_utility_pvt.ADD('csd_repair_estimate_pvt.update_repair_estimate failed ');
1699: end if;
1700: RAISE FND_API.G_EXC_ERROR;
1701: --ROLLBACK TO UPDATE_GRP_REJT_STATUS;
1702: --return;

Line 1713: -- update to group is done in the call csd_repair_estimate_pvt.update_repair_estimate

1709:
1710: END LOOP;
1711: -- End of API body.
1712:
1713: -- update to group is done in the call csd_repair_estimate_pvt.update_repair_estimate
1714: -- repair group object version number is not returned in this case
1715:
1716: -------------------------------
1717: -- Standard check for p_commit