APPS.CSD_ESTIMATE_UTILS_PVT dependencies on CSD_REPAIR_ESTIMATE_PUB

Line 497: PROCEDURE validate_est_hdr_rec(p_estimate_hdr_rec IN Csd_Repair_Estimate_Pub.estimate_hdr_Rec ,

493: /* */
494: /* Change History : Created 25th June2005 by Vijay */
495: /*-------------------------------------------------------*/
496:
497: PROCEDURE validate_est_hdr_rec(p_estimate_hdr_rec IN Csd_Repair_Estimate_Pub.estimate_hdr_Rec ,
498: p_validation_level IN NUMBER) IS
499: --Cursor definition to check the existing repair estimate header record for the
500: -- given repair order line.
501: CURSOR CUR_ESTIMATE_HDR(p_repair_line_id NUMBER) IS

Line 556: PROCEDURE DEFAULT_EST_HDR_REC(p_estimate_hdr_rec IN OUT NOCOPY Csd_Repair_Estimate_Pub.estimate_hdr_Rec) IS

552: /* */
553: /* Change History : Created 25th June2005 by Vijay */
554: /*------------------------------------------------------------------------*/
555:
556: PROCEDURE DEFAULT_EST_HDR_REC(p_estimate_hdr_rec IN OUT NOCOPY Csd_Repair_Estimate_Pub.estimate_hdr_Rec) IS
557: -- Cursor to get the object version number and repair quantity
558: -- and SR summary
559: CURSOR CUR_REPAIR_LINE(p_Repair_line_id NUMBER) IS
560: SELECT A.QUANTITY, A.OBJECT_VERSION_NUMBER, B.SUMMARY, B.INCIDENT_ID

Line 610: PROCEDURE VALIDATE_DEFAULTED_EST_HDR(p_estimate_hdr_rec IN Csd_Repair_Estimate_Pub.estimate_hdr_Rec,

606: /* DEscription: Validate the defaulted estimates header record */
607: /* */
608: /* Change History : Created 25th June2005 by Vijay */
609: /*------------------------------------------------------------------------*/
610: PROCEDURE VALIDATE_DEFAULTED_EST_HDR(p_estimate_hdr_rec IN Csd_Repair_Estimate_Pub.estimate_hdr_Rec,
611: p_validation_level IN NUMBER) IS
612:
613: l_api_name CONSTANT VARCHAR2(30) := 'VALIDATE_DEFAULTED_EST_HDR';
614:

Line 644: PROCEDURE COPY_TO_EST_HDR_REC(p_estimate_hdr_rec IN Csd_Repair_Estimate_Pub.estimate_hdr_Rec,

640: /* DEscription: Creates the record required for private api */
641: /* */
642: /* Change History : Created 25th June2005 by Vijay */
643: /*------------------------------------------------------------------------*/
644: PROCEDURE COPY_TO_EST_HDR_REC(p_estimate_hdr_rec IN Csd_Repair_Estimate_Pub.estimate_hdr_Rec,
645: x_est_pvt_hdr_rec OUT NOCOPY Csd_Repair_Estimate_Pvt.REPAIR_ESTIMATE_REC) IS
646: BEGIN
647:
648: IF (p_estimate_hdr_rec.repair_estimate_id IS NOT NULL) then

Line 754: PROCEDURE COPY_TO_EST_HDR_REC_UPD(p_estimate_hdr_rec IN Csd_Repair_Estimate_Pub.estimate_hdr_Rec,

750: /* DEscription: Creates the record required for private update api */
751: /* */
752: /* Change History : Created 25th June2005 by Vijay */
753: /*------------------------------------------------------------------------*/
754: PROCEDURE COPY_TO_EST_HDR_REC_UPD(p_estimate_hdr_rec IN Csd_Repair_Estimate_Pub.estimate_hdr_Rec,
755: x_est_pvt_hdr_rec OUT NOCOPY Csd_Repair_Estimate_Pvt.REPAIR_ESTIMATE_REC) IS
756: BEGIN
757:
758: IF (p_estimate_hdr_rec.note_id IS NOT NULL) then

Line 842: PROCEDURE VALIDATE_EST_LINE_REC(p_estimate_line_rec IN Csd_Repair_Estimate_Pub.estimate_line_Rec,

838: /* */
839: /* Change History : Created 25th June2005 by Vijay */
840: /*-------------------------------------------------------*/
841:
842: PROCEDURE VALIDATE_EST_LINE_REC(p_estimate_line_rec IN Csd_Repair_Estimate_Pub.estimate_line_Rec,
843: p_validation_level IN NUMBER) IS
844:
845: l_api_name CONSTANT VARCHAR2(30) := 'VALIDATE_EST_LINE_REC';
846: l_order_number varchar2(30);

Line 949: PROCEDURE DEFAULT_EST_LINE_REC(px_estimate_line_rec IN OUT NOCOPY Csd_Repair_Estimate_Pub.estimate_line_Rec) IS

945: /* */
946: /* Change History : Created 25th June2005 by Vijay */
947: /*------------------------------------------------------------------------*/
948:
949: PROCEDURE DEFAULT_EST_LINE_REC(px_estimate_line_rec IN OUT NOCOPY Csd_Repair_Estimate_Pub.estimate_line_Rec) IS
950: -- cursor to get nocharge flag, txn_type and validate txn_billing_type
951: CURSOR CUR_NO_CHARGE_FLAG(p_txn_billing_Type_id NUMBER) IS
952: SELECT NVL(ctt.no_charge_flag, 'N') no_charge_flag,
953: ctt.transaction_Type_id

Line 1248: PROCEDURE VALIDATE_DEFAULTED_EST_LINE(p_estimate_line_rec IN Csd_Repair_Estimate_Pub.estimate_line_Rec,

1244: /* DEscription: Validate the defaulted estimates header record */
1245: /* */
1246: /* Change History : Created 25th June2005 by Vijay */
1247: /*------------------------------------------------------------------------*/
1248: PROCEDURE VALIDATE_DEFAULTED_EST_LINE(p_estimate_line_rec IN Csd_Repair_Estimate_Pub.estimate_line_Rec,
1249: p_validation_level IN NUMBER) IS
1250:
1251: -- cursor to get the item attributes.
1252: -- revision control = 'N' when revision control_Code <>2

Line 1349: FUNCTION get_pricing_rec(p_estimate_line_rec IN Csd_Repair_Estimate_Pub.ESTIMATE_LINE_REC)

1345: /* DEscription: Copy the pricing attributes into a separate rec */
1346: /* */
1347: /* Change History : Created 25th June2005 by Vijay */
1348: /*------------------------------------------------------------------------*/
1349: FUNCTION get_pricing_rec(p_estimate_line_rec IN Csd_Repair_Estimate_Pub.ESTIMATE_LINE_REC)
1350: RETURN Csd_Process_Util.PRICING_ATTR_REC IS
1351: l_pricing_rec Csd_Process_Util.PRICING_ATTR_REC;
1352: BEGIN
1353: l_pricing_rec.pricing_context := p_estimate_line_rec.pricing_context;