[Home] [Help]
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
554: /* */
555: /* Change History : Created 25th June2005 by Vijay */
556: /*------------------------------------------------------------------------*/
557:
558: PROCEDURE DEFAULT_EST_HDR_REC(p_estimate_hdr_rec IN OUT NOCOPY Csd_Repair_Estimate_Pub.estimate_hdr_Rec) IS
559: -- Cursor to get the object version number and repair quantity
560: -- and SR summary
561: CURSOR CUR_REPAIR_LINE(p_Repair_line_id NUMBER) IS
562: SELECT A.QUANTITY, A.OBJECT_VERSION_NUMBER, B.SUMMARY, B.INCIDENT_ID
608: /* DEscription: Validate the defaulted estimates header record */
609: /* */
610: /* Change History : Created 25th June2005 by Vijay */
611: /*------------------------------------------------------------------------*/
612: PROCEDURE VALIDATE_DEFAULTED_EST_HDR(p_estimate_hdr_rec IN Csd_Repair_Estimate_Pub.estimate_hdr_Rec,
613: p_validation_level IN NUMBER) IS
614:
615: l_api_name CONSTANT VARCHAR2(30) := 'VALIDATE_DEFAULTED_EST_HDR';
616:
647: /* DEscription: Creates the record required for private api */
648: /* */
649: /* Change History : Created 25th June2005 by Vijay */
650: /*------------------------------------------------------------------------*/
651: PROCEDURE COPY_TO_EST_HDR_REC(p_estimate_hdr_rec IN Csd_Repair_Estimate_Pub.estimate_hdr_Rec,
652: x_est_pvt_hdr_rec OUT NOCOPY Csd_Repair_Estimate_Pvt.REPAIR_ESTIMATE_REC) IS
653: BEGIN
654:
655: IF (p_estimate_hdr_rec.repair_estimate_id IS NOT NULL) then
762: /* DEscription: Creates the record required for private update api */
763: /* */
764: /* Change History : Created 25th June2005 by Vijay */
765: /*------------------------------------------------------------------------*/
766: PROCEDURE COPY_TO_EST_HDR_REC_UPD(p_estimate_hdr_rec IN Csd_Repair_Estimate_Pub.estimate_hdr_Rec,
767: x_est_pvt_hdr_rec OUT NOCOPY Csd_Repair_Estimate_Pvt.REPAIR_ESTIMATE_REC) IS
768: BEGIN
769: -- swai: bug 9462789
770: x_est_pvt_hdr_rec.repair_estimate_id := p_estimate_hdr_rec.repair_estimate_id;
863: /* */
864: /* Change History : Created 25th June2005 by Vijay */
865: /*-------------------------------------------------------*/
866:
867: PROCEDURE VALIDATE_EST_LINE_REC(p_estimate_line_rec IN Csd_Repair_Estimate_Pub.estimate_line_Rec,
868: p_validation_level IN NUMBER) IS
869:
870: l_api_name CONSTANT VARCHAR2(30) := 'VALIDATE_EST_LINE_REC';
871: l_order_number varchar2(30);
970: /* */
971: /* Change History : Created 25th June2005 by Vijay */
972: /*------------------------------------------------------------------------*/
973:
974: PROCEDURE DEFAULT_EST_LINE_REC(px_estimate_line_rec IN OUT NOCOPY Csd_Repair_Estimate_Pub.estimate_line_Rec) IS
975: -- cursor to get nocharge flag, txn_type and validate txn_billing_type
976: CURSOR CUR_NO_CHARGE_FLAG(p_txn_billing_Type_id NUMBER) IS
977: SELECT NVL(ctt.no_charge_flag, 'N') no_charge_flag,
978: ctt.transaction_Type_id
1269: /* DEscription: Validate the defaulted estimates header record */
1270: /* */
1271: /* Change History : Created 25th June2005 by Vijay */
1272: /*------------------------------------------------------------------------*/
1273: PROCEDURE VALIDATE_DEFAULTED_EST_LINE(p_estimate_line_rec IN Csd_Repair_Estimate_Pub.estimate_line_Rec,
1274: p_validation_level IN NUMBER) IS
1275:
1276: -- cursor to get the item attributes.
1277: -- revision control = 'N' when revision control_Code <>2
1370: /* DEscription: Copy the pricing attributes into a separate rec */
1371: /* */
1372: /* Change History : Created 25th June2005 by Vijay */
1373: /*------------------------------------------------------------------------*/
1374: FUNCTION get_pricing_rec(p_estimate_line_rec IN Csd_Repair_Estimate_Pub.ESTIMATE_LINE_REC)
1375: RETURN Csd_Process_Util.PRICING_ATTR_REC IS
1376: l_pricing_rec Csd_Process_Util.PRICING_ATTR_REC;
1377: BEGIN
1378: l_pricing_rec.pricing_context := p_estimate_line_rec.pricing_context;
1481:
1482:
1483: /*------------------------------------------------------------------------*/
1484: /* procedure name: COPY_TO_EST_PVT_LINE_REC */
1485: /* Description: Copy values from CSD_REPAIR_ESTIMATE_PUB.estimate_line_rec*/
1486: /* to CSD_REPAIR_ESTIMATE_PVT.repair_estimate_line_rec */
1487: /* */
1488: /* Change History : Created 05 Dec 2011 by yvchen: bug 12545399 */
1489: /*------------------------------------------------------------------------*/
1486: /* to CSD_REPAIR_ESTIMATE_PVT.repair_estimate_line_rec */
1487: /* */
1488: /* Change History : Created 05 Dec 2011 by yvchen: bug 12545399 */
1489: /*------------------------------------------------------------------------*/
1490: PROCEDURE COPY_TO_EST_PVT_LINE_REC(p_estimate_line_rec IN Csd_Repair_Estimate_Pub.estimate_line_Rec,
1491: x_est_pvt_line_rec IN OUT NOCOPY Csd_Repair_Estimate_Pvt.REPAIR_ESTIMATE_LINE_REC) IS
1492: BEGIN
1493: IF (p_estimate_line_rec.repair_estimate_line_id IS NOT NULL) then
1494: x_est_pvt_line_rec.repair_estimate_line_id := p_estimate_line_rec.repair_estimate_line_id ;