DBA Data[Home] [Help]

APPS.CSD_PROCESS_UTIL dependencies on CSD_REPAIR_ESTIMATE

Line 324: p_estimate_line_rec IN CSD_REPAIR_ESTIMATE_PVT.REPAIR_ESTIMATE_LINE_REC,

320:
321:
322: PROCEDURE Convert_Est_to_Chg_rec
323: (
324: p_estimate_line_rec IN CSD_REPAIR_ESTIMATE_PVT.REPAIR_ESTIMATE_LINE_REC,
325: x_charges_rec OUT NOCOPY CS_CHARGE_DETAILS_PUB.CHARGES_REC_TYPE,
326: x_return_status OUT NOCOPY VARCHAR2
327: ) IS
328:

Line 3628: from csd_repair_estimate

3624: BEGIN
3625:
3626: select 'X'
3627: into l_dummy
3628: from csd_repair_estimate
3629: where repair_estimate_id = p_estimate_id;
3630:
3631: RETURN TRUE;
3632:

Line 3653: from csd_repair_estimate_lines

3649: BEGIN
3650:
3651: select 'X'
3652: into l_dummy
3653: from csd_repair_estimate_lines
3654: where repair_estimate_line_id = p_estimate_line_id;
3655:
3656: RETURN TRUE;
3657:

Line 3814: from csd_repair_estimate cre,

3810:
3811: Select
3812: sum(ced.after_warranty_cost)
3813: into l_amount
3814: from csd_repair_estimate cre,
3815: csd_repair_estimate_lines crel,
3816: cs_estimate_details ced,
3817: cs_txn_billing_types ctbt
3818: where cre.repair_estimate_id = crel.repair_estimate_id

Line 3815: csd_repair_estimate_lines crel,

3811: Select
3812: sum(ced.after_warranty_cost)
3813: into l_amount
3814: from csd_repair_estimate cre,
3815: csd_repair_estimate_lines crel,
3816: cs_estimate_details ced,
3817: cs_txn_billing_types ctbt
3818: where cre.repair_estimate_id = crel.repair_estimate_id
3819: and crel.estimate_detail_id = ced.estimate_detail_id

Line 3829: from csd_repair_estimate cre,

3825:
3826: Select
3827: sum(ced.after_warranty_cost)
3828: into l_amount
3829: from csd_repair_estimate cre,
3830: csd_repair_estimate_lines crel,
3831: cs_estimate_details ced,
3832: cs_txn_billing_types ctbt
3833: where cre.repair_estimate_id = crel.repair_estimate_id

Line 3830: csd_repair_estimate_lines crel,

3826: Select
3827: sum(ced.after_warranty_cost)
3828: into l_amount
3829: from csd_repair_estimate cre,
3830: csd_repair_estimate_lines crel,
3831: cs_estimate_details ced,
3832: cs_txn_billing_types ctbt
3833: where cre.repair_estimate_id = crel.repair_estimate_id
3834: and crel.estimate_detail_id = ced.estimate_detail_id

Line 3844: from csd_repair_estimate cre,

3840:
3841: Select
3842: sum(ced.after_warranty_cost)
3843: into l_amount
3844: from csd_repair_estimate cre,
3845: csd_repair_estimate_lines crel,
3846: cs_estimate_details ced,
3847: cs_txn_billing_types ctbt
3848: where cre.repair_estimate_id = crel.repair_estimate_id

Line 3845: csd_repair_estimate_lines crel,

3841: Select
3842: sum(ced.after_warranty_cost)
3843: into l_amount
3844: from csd_repair_estimate cre,
3845: csd_repair_estimate_lines crel,
3846: cs_estimate_details ced,
3847: cs_txn_billing_types ctbt
3848: where cre.repair_estimate_id = crel.repair_estimate_id
3849: and crel.estimate_detail_id = ced.estimate_detail_id

Line 3859: from csd_repair_estimate cre,

3855:
3856: Select
3857: sum(ced.after_warranty_cost)
3858: into l_amount
3859: from csd_repair_estimate cre,
3860: csd_repair_estimate_lines crel,
3861: cs_estimate_details ced
3862: where cre.repair_estimate_id = crel.repair_estimate_id
3863: and crel.estimate_detail_id = ced.estimate_detail_id

Line 3860: csd_repair_estimate_lines crel,

3856: Select
3857: sum(ced.after_warranty_cost)
3858: into l_amount
3859: from csd_repair_estimate cre,
3860: csd_repair_estimate_lines crel,
3861: cs_estimate_details ced
3862: where cre.repair_estimate_id = crel.repair_estimate_id
3863: and crel.estimate_detail_id = ced.estimate_detail_id
3864: and cre.repair_line_id = p_repair_line_id ;

Line 4480: FUNCTION ui_estimate_rec RETURN csd_repair_estimate_pvt.repair_estimate_rec

4476: BEGIN
4477: RETURN l_ro_rec;
4478: END repair_order_rec;
4479:
4480: FUNCTION ui_estimate_rec RETURN csd_repair_estimate_pvt.repair_estimate_rec
4481: IS
4482: l_est_rec csd_repair_estimate_pvt.repair_estimate_rec;
4483: BEGIN
4484: RETURN l_est_rec;

Line 4482: l_est_rec csd_repair_estimate_pvt.repair_estimate_rec;

4478: END repair_order_rec;
4479:
4480: FUNCTION ui_estimate_rec RETURN csd_repair_estimate_pvt.repair_estimate_rec
4481: IS
4482: l_est_rec csd_repair_estimate_pvt.repair_estimate_rec;
4483: BEGIN
4484: RETURN l_est_rec;
4485: END ui_estimate_rec ;
4486:

Line 4495: FUNCTION ui_estimate_line_rec RETURN csd_repair_estimate_pvt.repair_estimate_line_rec

4491: RETURN l_job_param_rec;
4492: END ui_job_parameter_rec ;
4493:
4494:
4495: FUNCTION ui_estimate_line_rec RETURN csd_repair_estimate_pvt.repair_estimate_line_rec
4496: IS
4497: l_est_line_rec csd_repair_estimate_pvt.repair_estimate_line_rec;
4498: BEGIN
4499: RETURN l_est_line_rec;

Line 4497: l_est_line_rec csd_repair_estimate_pvt.repair_estimate_line_rec;

4493:
4494:
4495: FUNCTION ui_estimate_line_rec RETURN csd_repair_estimate_pvt.repair_estimate_line_rec
4496: IS
4497: l_est_line_rec csd_repair_estimate_pvt.repair_estimate_line_rec;
4498: BEGIN
4499: RETURN l_est_line_rec;
4500: END ui_estimate_line_rec ;
4501: