94:
95: l_return_status VARCHAR2(1);
96: l_Agreement_rec Agreement_Rec_Type;
97: l_Price_LHeader_rec QP_Price_List_PUB.Price_List_Rec_Type;
98: l_Price_LHeader_rec_dummy OE_Price_List_PUB.Price_List_Rec_Type;
99: l_Price_LLine_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
100: l_Price_LLine_tbl_dummy OE_Price_List_PUB.Price_List_Line_Tbl_Type;
101: l_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
102: x_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type; --4949185, 5530054
96: l_Agreement_rec Agreement_Rec_Type;
97: l_Price_LHeader_rec QP_Price_List_PUB.Price_List_Rec_Type;
98: l_Price_LHeader_rec_dummy OE_Price_List_PUB.Price_List_Rec_Type;
99: l_Price_LLine_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
100: l_Price_LLine_tbl_dummy OE_Price_List_PUB.Price_List_Line_Tbl_Type;
101: l_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
102: x_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type; --4949185, 5530054
103: l_Pricing_Attr_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
104: l_installed_status VARCHAR2(1);
114: l_p_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type; --[prarasto]
115: l_p_Pricing_Attr_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type; --[prarasto]
116: l_p_Contract_rec Contract_Rec_Type; --[prarasto]
117: l_p_Agreement_rec Agreement_Rec_Type; --[prarasto]
118: l_p_Price_LHeader_rec_dummy OE_Price_List_PUB.Price_List_Rec_Type; --[prarasto]
119: l_p_Discount_Header_rec Discount_Header_Rec_Type; --[prarasto]
120: l_p_Price_LLine_tbl_dummy OE_Price_List_PUB.Price_List_Line_Tbl_Type; --[prarasto]
121: l_p_Discount_Cust_tbl Discount_Cust_Tbl_Type; --[prarasto]
122: l_p_Discount_Line_tbl Discount_Line_Tbl_Type; --[prarasto]
116: l_p_Contract_rec Contract_Rec_Type; --[prarasto]
117: l_p_Agreement_rec Agreement_Rec_Type; --[prarasto]
118: l_p_Price_LHeader_rec_dummy OE_Price_List_PUB.Price_List_Rec_Type; --[prarasto]
119: l_p_Discount_Header_rec Discount_Header_Rec_Type; --[prarasto]
120: l_p_Price_LLine_tbl_dummy OE_Price_List_PUB.Price_List_Line_Tbl_Type; --[prarasto]
121: l_p_Discount_Cust_tbl Discount_Cust_Tbl_Type; --[prarasto]
122: l_p_Discount_Line_tbl Discount_Line_Tbl_Type; --[prarasto]
123: l_p_Price_Break_tbl Price_Break_Tbl_Type; --[prarasto]
124:
445: l_api_name CONSTANT VARCHAR2(30):= 'Lock_Agreement';
446: l_return_status VARCHAR2(1);
447: l_Agreement_rec Agreement_Rec_Type;
448: l_Price_LHeader_rec QP_Price_List_PUB.Price_List_Rec_Type;
449: l_Price_LHeader_rec_dummy OE_Price_List_PUB.Price_List_Rec_Type;
450: l_Price_LLine_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
451: l_Price_LLine_tbl_dummy OE_Price_List_PUB.Price_List_Line_Tbl_Type;
452: l_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
453: l_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
447: l_Agreement_rec Agreement_Rec_Type;
448: l_Price_LHeader_rec QP_Price_List_PUB.Price_List_Rec_Type;
449: l_Price_LHeader_rec_dummy OE_Price_List_PUB.Price_List_Rec_Type;
450: l_Price_LLine_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
451: l_Price_LLine_tbl_dummy OE_Price_List_PUB.Price_List_Line_Tbl_Type;
452: l_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
453: l_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
454:
455: l_Contract_rec Contract_Rec_Type;
460:
461:
462: l_p_Contract_rec Contract_Rec_Type; --[prarasto]
463: l_p_Agreement_rec Agreement_Rec_Type; --[prarasto]
464: l_p_Price_LHeader_rec_dummy OE_Price_List_PUB.Price_List_Rec_Type; --[prarasto]
465: l_p_Discount_Header_rec Discount_Header_Rec_Type; --[prarasto]
466: l_p_Price_LLine_tbl_dummy OE_Price_List_PUB.Price_List_Line_Tbl_Type; --[prarasto]
467: l_p_Discount_Cust_tbl Discount_Cust_Tbl_Type; --[prarasto]
468: l_p_Discount_Line_tbl Discount_Line_Tbl_Type; --[prarasto]
462: l_p_Contract_rec Contract_Rec_Type; --[prarasto]
463: l_p_Agreement_rec Agreement_Rec_Type; --[prarasto]
464: l_p_Price_LHeader_rec_dummy OE_Price_List_PUB.Price_List_Rec_Type; --[prarasto]
465: l_p_Discount_Header_rec Discount_Header_Rec_Type; --[prarasto]
466: l_p_Price_LLine_tbl_dummy OE_Price_List_PUB.Price_List_Line_Tbl_Type; --[prarasto]
467: l_p_Discount_Cust_tbl Discount_Cust_Tbl_Type; --[prarasto]
468: l_p_Discount_Line_tbl Discount_Line_Tbl_Type; --[prarasto]
469: l_p_Price_Break_tbl Price_Break_Tbl_Type; --[prarasto]
470: BEGIN
669: l_api_version_number CONSTANT NUMBER := 1.0;
670: l_api_name CONSTANT VARCHAR2(30):= 'Get_Agreement';
671: l_agreement_id NUMBER := p_agreement_id;
672: l_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
673: l_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
674: l_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
675: l_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
676: l_PRICING_ATTR_tbl OE_Price_List_PUB.Pricing_Attr_Tbl_Type;
677: l_x_PRICING_ATTR_tbl OE_Price_List_PUB.Pricing_Attr_Tbl_Type;
670: l_api_name CONSTANT VARCHAR2(30):= 'Get_Agreement';
671: l_agreement_id NUMBER := p_agreement_id;
672: l_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
673: l_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
674: l_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
675: l_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
676: l_PRICING_ATTR_tbl OE_Price_List_PUB.Pricing_Attr_Tbl_Type;
677: l_x_PRICING_ATTR_tbl OE_Price_List_PUB.Pricing_Attr_Tbl_Type;
678: l_pricing_contract_id NUMBER;
672: l_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
673: l_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
674: l_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
675: l_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
676: l_PRICING_ATTR_tbl OE_Price_List_PUB.Pricing_Attr_Tbl_Type;
677: l_x_PRICING_ATTR_tbl OE_Price_List_PUB.Pricing_Attr_Tbl_Type;
678: l_pricing_contract_id NUMBER;
679:
680: BEGIN
673: l_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;
674: l_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
675: l_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
676: l_PRICING_ATTR_tbl OE_Price_List_PUB.Pricing_Attr_Tbl_Type;
677: l_x_PRICING_ATTR_tbl OE_Price_List_PUB.Pricing_Attr_Tbl_Type;
678: l_pricing_contract_id NUMBER;
679:
680: BEGIN
681: