DBA Data[Home] [Help]

APPS.OE_BLANKET_PRICING_UTIL dependencies on QP_PRICE_LIST_PUB

Line 457: gpr_price_list_rec QP_PRICE_LIST_PUB.Price_List_Rec_Type;

453: )
454: IS
455: gpr_msg_count number := 0;
456: gpr_msg_data varchar2(2000);
457: gpr_price_list_rec QP_PRICE_LIST_PUB.Price_List_Rec_Type;
458: gpr_price_list_line_tbl QP_PRICE_LIST_PUB.Price_List_Line_Tbl_Type;
459: ppr_price_list_rec QP_PRICE_LIST_PUB.Price_List_Rec_Type;
460: ppr_price_list_val_rec QP_PRICE_LIST_PUB.Price_List_Val_Rec_Type;
461: ppr_price_list_line_tbl QP_PRICE_LIST_PUB.Price_List_Line_Tbl_Type;

Line 458: gpr_price_list_line_tbl QP_PRICE_LIST_PUB.Price_List_Line_Tbl_Type;

454: IS
455: gpr_msg_count number := 0;
456: gpr_msg_data varchar2(2000);
457: gpr_price_list_rec QP_PRICE_LIST_PUB.Price_List_Rec_Type;
458: gpr_price_list_line_tbl QP_PRICE_LIST_PUB.Price_List_Line_Tbl_Type;
459: ppr_price_list_rec QP_PRICE_LIST_PUB.Price_List_Rec_Type;
460: ppr_price_list_val_rec QP_PRICE_LIST_PUB.Price_List_Val_Rec_Type;
461: ppr_price_list_line_tbl QP_PRICE_LIST_PUB.Price_List_Line_Tbl_Type;
462: ppr_price_list_line_val_tbl QP_PRICE_LIST_PUB.Price_List_Line_Val_Tbl_Type;

Line 459: ppr_price_list_rec QP_PRICE_LIST_PUB.Price_List_Rec_Type;

455: gpr_msg_count number := 0;
456: gpr_msg_data varchar2(2000);
457: gpr_price_list_rec QP_PRICE_LIST_PUB.Price_List_Rec_Type;
458: gpr_price_list_line_tbl QP_PRICE_LIST_PUB.Price_List_Line_Tbl_Type;
459: ppr_price_list_rec QP_PRICE_LIST_PUB.Price_List_Rec_Type;
460: ppr_price_list_val_rec QP_PRICE_LIST_PUB.Price_List_Val_Rec_Type;
461: ppr_price_list_line_tbl QP_PRICE_LIST_PUB.Price_List_Line_Tbl_Type;
462: ppr_price_list_line_val_tbl QP_PRICE_LIST_PUB.Price_List_Line_Val_Tbl_Type;
463: ppr_qualifiers_tbl QP_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;

Line 460: ppr_price_list_val_rec QP_PRICE_LIST_PUB.Price_List_Val_Rec_Type;

456: gpr_msg_data varchar2(2000);
457: gpr_price_list_rec QP_PRICE_LIST_PUB.Price_List_Rec_Type;
458: gpr_price_list_line_tbl QP_PRICE_LIST_PUB.Price_List_Line_Tbl_Type;
459: ppr_price_list_rec QP_PRICE_LIST_PUB.Price_List_Rec_Type;
460: ppr_price_list_val_rec QP_PRICE_LIST_PUB.Price_List_Val_Rec_Type;
461: ppr_price_list_line_tbl QP_PRICE_LIST_PUB.Price_List_Line_Tbl_Type;
462: ppr_price_list_line_val_tbl QP_PRICE_LIST_PUB.Price_List_Line_Val_Tbl_Type;
463: ppr_qualifiers_tbl QP_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
464: ppr_qualifiers_val_tbl QP_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type;

Line 461: ppr_price_list_line_tbl QP_PRICE_LIST_PUB.Price_List_Line_Tbl_Type;

457: gpr_price_list_rec QP_PRICE_LIST_PUB.Price_List_Rec_Type;
458: gpr_price_list_line_tbl QP_PRICE_LIST_PUB.Price_List_Line_Tbl_Type;
459: ppr_price_list_rec QP_PRICE_LIST_PUB.Price_List_Rec_Type;
460: ppr_price_list_val_rec QP_PRICE_LIST_PUB.Price_List_Val_Rec_Type;
461: ppr_price_list_line_tbl QP_PRICE_LIST_PUB.Price_List_Line_Tbl_Type;
462: ppr_price_list_line_val_tbl QP_PRICE_LIST_PUB.Price_List_Line_Val_Tbl_Type;
463: ppr_qualifiers_tbl QP_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
464: ppr_qualifiers_val_tbl QP_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type;
465: ppr_pricing_attr_tbl QP_PRICE_LIST_PUB.Pricing_Attr_Tbl_Type;

Line 462: ppr_price_list_line_val_tbl QP_PRICE_LIST_PUB.Price_List_Line_Val_Tbl_Type;

458: gpr_price_list_line_tbl QP_PRICE_LIST_PUB.Price_List_Line_Tbl_Type;
459: ppr_price_list_rec QP_PRICE_LIST_PUB.Price_List_Rec_Type;
460: ppr_price_list_val_rec QP_PRICE_LIST_PUB.Price_List_Val_Rec_Type;
461: ppr_price_list_line_tbl QP_PRICE_LIST_PUB.Price_List_Line_Tbl_Type;
462: ppr_price_list_line_val_tbl QP_PRICE_LIST_PUB.Price_List_Line_Val_Tbl_Type;
463: ppr_qualifiers_tbl QP_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
464: ppr_qualifiers_val_tbl QP_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type;
465: ppr_pricing_attr_tbl QP_PRICE_LIST_PUB.Pricing_Attr_Tbl_Type;
466: ppr_pricing_attr_val_tbl QP_PRICE_LIST_PUB.Pricing_Attr_Val_Tbl_Type;

Line 465: ppr_pricing_attr_tbl QP_PRICE_LIST_PUB.Pricing_Attr_Tbl_Type;

461: ppr_price_list_line_tbl QP_PRICE_LIST_PUB.Price_List_Line_Tbl_Type;
462: ppr_price_list_line_val_tbl QP_PRICE_LIST_PUB.Price_List_Line_Val_Tbl_Type;
463: ppr_qualifiers_tbl QP_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
464: ppr_qualifiers_val_tbl QP_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type;
465: ppr_pricing_attr_tbl QP_PRICE_LIST_PUB.Pricing_Attr_Tbl_Type;
466: ppr_pricing_attr_val_tbl QP_PRICE_LIST_PUB.Pricing_Attr_Val_Tbl_Type;
467: --
468: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
469: --

Line 466: ppr_pricing_attr_val_tbl QP_PRICE_LIST_PUB.Pricing_Attr_Val_Tbl_Type;

462: ppr_price_list_line_val_tbl QP_PRICE_LIST_PUB.Price_List_Line_Val_Tbl_Type;
463: ppr_qualifiers_tbl QP_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
464: ppr_qualifiers_val_tbl QP_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type;
465: ppr_pricing_attr_tbl QP_PRICE_LIST_PUB.Pricing_Attr_Tbl_Type;
466: ppr_pricing_attr_val_tbl QP_PRICE_LIST_PUB.Pricing_Attr_Val_Tbl_Type;
467: --
468: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
469: --
470: BEGIN

Line 633: l_price_list_tbl QP_Price_List_PUB.Price_List_Tbl_Type;

629: )
630: IS
631: l_qp_list_line_id NUMBER;
632: l_mod_list_line_id NUMBER;
633: l_price_list_tbl QP_Price_List_PUB.Price_List_Tbl_Type;
634: l_modifier_list_tbl QP_Modifiers_PUB.Modifier_List_Tbl_Type;
635: l_return_status VARCHAR2(30);
636: l_msg_count NUMBER;
637: l_msg_data VARCHAR2(2000);