DBA Data[Home] [Help]

APPS.OE_PRICING_CONT_PUB dependencies on OE_PRICE_LIST_PUB

Line 98: l_Price_LHeader_rec_dummy OE_Price_List_PUB.Price_List_Rec_Type;

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

Line 100: l_Price_LLine_tbl_dummy OE_Price_List_PUB.Price_List_Line_Tbl_Type;

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);

Line 118: l_p_Price_LHeader_rec_dummy OE_Price_List_PUB.Price_List_Rec_Type; --[prarasto]

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]

Line 120: l_p_Price_LLine_tbl_dummy OE_Price_List_PUB.Price_List_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:

Line 449: l_Price_LHeader_rec_dummy OE_Price_List_PUB.Price_List_Rec_Type;

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;

Line 451: l_Price_LLine_tbl_dummy OE_Price_List_PUB.Price_List_Line_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;

Line 464: l_p_Price_LHeader_rec_dummy OE_Price_List_PUB.Price_List_Rec_Type; --[prarasto]

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]

Line 466: l_p_Price_LLine_tbl_dummy OE_Price_List_PUB.Price_List_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

Line 673: l_Price_LHeader_rec OE_Price_List_PUB.Price_List_Rec_Type;

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;

Line 674: l_Price_LLine_tbl OE_Price_List_PUB.Price_List_Line_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;

Line 676: l_PRICING_ATTR_tbl OE_Price_List_PUB.Pricing_Attr_Tbl_Type;

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

Line 677: l_x_PRICING_ATTR_tbl OE_Price_List_PUB.Pricing_Attr_Tbl_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
681: