DBA Data[Home] [Help]

APPS.CSD_PROCESS_UTIL dependencies on CSD_REPAIR_ESTIMATE

Line 332: p_estimate_line_rec IN CSD_REPAIR_ESTIMATE_PVT.REPAIR_ESTIMATE_LINE_REC,

328:
329:
330: PROCEDURE Convert_Est_to_Chg_rec
331: (
332: p_estimate_line_rec IN CSD_REPAIR_ESTIMATE_PVT.REPAIR_ESTIMATE_LINE_REC,
333: x_charges_rec OUT NOCOPY CS_CHARGE_DETAILS_PUB.CHARGES_REC_TYPE,
334: x_return_status OUT NOCOPY VARCHAR2
335: ) IS
336:

Line 3859: from csd_repair_estimate

3855: BEGIN
3856:
3857: select 'X'
3858: into l_dummy
3859: from csd_repair_estimate
3860: where repair_estimate_id = p_estimate_id;
3861:
3862: RETURN TRUE;
3863:

Line 3884: from csd_repair_estimate_lines

3880: BEGIN
3881:
3882: select 'X'
3883: into l_dummy
3884: from csd_repair_estimate_lines
3885: where repair_estimate_line_id = p_estimate_line_id;
3886:
3887: RETURN TRUE;
3888:

Line 4045: from csd_repair_estimate cre,

4041:
4042: Select
4043: sum(ced.after_warranty_cost)
4044: into l_amount
4045: from csd_repair_estimate cre,
4046: csd_repair_estimate_lines crel,
4047: cs_estimate_details ced,
4048: cs_txn_billing_types ctbt
4049: where cre.repair_estimate_id = crel.repair_estimate_id

Line 4046: csd_repair_estimate_lines crel,

4042: Select
4043: sum(ced.after_warranty_cost)
4044: into l_amount
4045: from csd_repair_estimate cre,
4046: csd_repair_estimate_lines crel,
4047: cs_estimate_details ced,
4048: cs_txn_billing_types ctbt
4049: where cre.repair_estimate_id = crel.repair_estimate_id
4050: and crel.estimate_detail_id = ced.estimate_detail_id

Line 4060: from csd_repair_estimate cre,

4056:
4057: Select
4058: sum(ced.after_warranty_cost)
4059: into l_amount
4060: from csd_repair_estimate cre,
4061: csd_repair_estimate_lines crel,
4062: cs_estimate_details ced,
4063: cs_txn_billing_types ctbt
4064: where cre.repair_estimate_id = crel.repair_estimate_id

Line 4061: csd_repair_estimate_lines crel,

4057: Select
4058: sum(ced.after_warranty_cost)
4059: into l_amount
4060: from csd_repair_estimate cre,
4061: csd_repair_estimate_lines crel,
4062: cs_estimate_details ced,
4063: cs_txn_billing_types ctbt
4064: where cre.repair_estimate_id = crel.repair_estimate_id
4065: and crel.estimate_detail_id = ced.estimate_detail_id

Line 4075: from csd_repair_estimate cre,

4071:
4072: Select
4073: sum(ced.after_warranty_cost)
4074: into l_amount
4075: from csd_repair_estimate cre,
4076: csd_repair_estimate_lines crel,
4077: cs_estimate_details ced,
4078: cs_txn_billing_types ctbt
4079: where cre.repair_estimate_id = crel.repair_estimate_id

Line 4076: csd_repair_estimate_lines crel,

4072: Select
4073: sum(ced.after_warranty_cost)
4074: into l_amount
4075: from csd_repair_estimate cre,
4076: csd_repair_estimate_lines crel,
4077: cs_estimate_details ced,
4078: cs_txn_billing_types ctbt
4079: where cre.repair_estimate_id = crel.repair_estimate_id
4080: and crel.estimate_detail_id = ced.estimate_detail_id

Line 4090: from csd_repair_estimate cre,

4086:
4087: Select
4088: sum(ced.after_warranty_cost)
4089: into l_amount
4090: from csd_repair_estimate cre,
4091: csd_repair_estimate_lines crel,
4092: cs_estimate_details ced
4093: where cre.repair_estimate_id = crel.repair_estimate_id
4094: and crel.estimate_detail_id = ced.estimate_detail_id

Line 4091: csd_repair_estimate_lines crel,

4087: Select
4088: sum(ced.after_warranty_cost)
4089: into l_amount
4090: from csd_repair_estimate cre,
4091: csd_repair_estimate_lines crel,
4092: cs_estimate_details ced
4093: where cre.repair_estimate_id = crel.repair_estimate_id
4094: and crel.estimate_detail_id = ced.estimate_detail_id
4095: and cre.repair_line_id = p_repair_line_id ;

Line 4746: FUNCTION ui_estimate_rec RETURN csd_repair_estimate_pvt.repair_estimate_rec

4742: BEGIN
4743: RETURN l_ro_rec;
4744: END repair_order_rec;
4745:
4746: FUNCTION ui_estimate_rec RETURN csd_repair_estimate_pvt.repair_estimate_rec
4747: IS
4748: l_est_rec csd_repair_estimate_pvt.repair_estimate_rec;
4749: BEGIN
4750: RETURN l_est_rec;

Line 4748: l_est_rec csd_repair_estimate_pvt.repair_estimate_rec;

4744: END repair_order_rec;
4745:
4746: FUNCTION ui_estimate_rec RETURN csd_repair_estimate_pvt.repair_estimate_rec
4747: IS
4748: l_est_rec csd_repair_estimate_pvt.repair_estimate_rec;
4749: BEGIN
4750: RETURN l_est_rec;
4751: END ui_estimate_rec ;
4752:

Line 4761: FUNCTION ui_estimate_line_rec RETURN csd_repair_estimate_pvt.repair_estimate_line_rec

4757: RETURN l_job_param_rec;
4758: END ui_job_parameter_rec ;
4759:
4760:
4761: FUNCTION ui_estimate_line_rec RETURN csd_repair_estimate_pvt.repair_estimate_line_rec
4762: IS
4763: l_est_line_rec csd_repair_estimate_pvt.repair_estimate_line_rec;
4764: BEGIN
4765: RETURN l_est_line_rec;

Line 4763: l_est_line_rec csd_repair_estimate_pvt.repair_estimate_line_rec;

4759:
4760:
4761: FUNCTION ui_estimate_line_rec RETURN csd_repair_estimate_pvt.repair_estimate_line_rec
4762: IS
4763: l_est_line_rec csd_repair_estimate_pvt.repair_estimate_line_rec;
4764: BEGIN
4765: RETURN l_est_line_rec;
4766: END ui_estimate_line_rec ;
4767: