3433: l_msg_data varchar2(2000);
3434:
3435: p_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
3436: p_Agreement_val_rec OE_Pricing_Cont_PUB.Agreement_Val_Rec_Type;
3437: p_price_list_rec QP_PRICE_LIST_PUB.Price_List_Rec_Type;
3438: p_price_list_val_rec QP_PRICE_LIST_PUB.Price_List_Val_Rec_Type;
3439:
3440: p_price_list_line_tbl QP_PRICE_LIST_PUB.Price_List_Line_Tbl_Type;
3441: p_price_list_line_val_tbl QP_PRICE_LIST_PUB.Price_List_Line_Val_Tbl_Type;
3434:
3435: p_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
3436: p_Agreement_val_rec OE_Pricing_Cont_PUB.Agreement_Val_Rec_Type;
3437: p_price_list_rec QP_PRICE_LIST_PUB.Price_List_Rec_Type;
3438: p_price_list_val_rec QP_PRICE_LIST_PUB.Price_List_Val_Rec_Type;
3439:
3440: p_price_list_line_tbl QP_PRICE_LIST_PUB.Price_List_Line_Tbl_Type;
3441: p_price_list_line_val_tbl QP_PRICE_LIST_PUB.Price_List_Line_Val_Tbl_Type;
3442:
3436: p_Agreement_val_rec OE_Pricing_Cont_PUB.Agreement_Val_Rec_Type;
3437: p_price_list_rec QP_PRICE_LIST_PUB.Price_List_Rec_Type;
3438: p_price_list_val_rec QP_PRICE_LIST_PUB.Price_List_Val_Rec_Type;
3439:
3440: p_price_list_line_tbl QP_PRICE_LIST_PUB.Price_List_Line_Tbl_Type;
3441: p_price_list_line_val_tbl QP_PRICE_LIST_PUB.Price_List_Line_Val_Tbl_Type;
3442:
3443: p_pricing_attr_tbl QP_PRICE_LIST_PUB.Pricing_Attr_Tbl_Type;
3444: p_pricing_attr_val_tbl QP_PRICE_LIST_PUB.Pricing_Attr_Val_Tbl_Type;
3437: p_price_list_rec QP_PRICE_LIST_PUB.Price_List_Rec_Type;
3438: p_price_list_val_rec QP_PRICE_LIST_PUB.Price_List_Val_Rec_Type;
3439:
3440: p_price_list_line_tbl QP_PRICE_LIST_PUB.Price_List_Line_Tbl_Type;
3441: p_price_list_line_val_tbl QP_PRICE_LIST_PUB.Price_List_Line_Val_Tbl_Type;
3442:
3443: p_pricing_attr_tbl QP_PRICE_LIST_PUB.Pricing_Attr_Tbl_Type;
3444: p_pricing_attr_val_tbl QP_PRICE_LIST_PUB.Pricing_Attr_Val_Tbl_Type;
3445:
3439:
3440: p_price_list_line_tbl QP_PRICE_LIST_PUB.Price_List_Line_Tbl_Type;
3441: p_price_list_line_val_tbl QP_PRICE_LIST_PUB.Price_List_Line_Val_Tbl_Type;
3442:
3443: p_pricing_attr_tbl QP_PRICE_LIST_PUB.Pricing_Attr_Tbl_Type;
3444: p_pricing_attr_val_tbl QP_PRICE_LIST_PUB.Pricing_Attr_Val_Tbl_Type;
3445:
3446: x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
3447: x_Agreement_val_rec OE_Pricing_Cont_PUB.Agreement_Val_Rec_Type;
3440: p_price_list_line_tbl QP_PRICE_LIST_PUB.Price_List_Line_Tbl_Type;
3441: p_price_list_line_val_tbl QP_PRICE_LIST_PUB.Price_List_Line_Val_Tbl_Type;
3442:
3443: p_pricing_attr_tbl QP_PRICE_LIST_PUB.Pricing_Attr_Tbl_Type;
3444: p_pricing_attr_val_tbl QP_PRICE_LIST_PUB.Pricing_Attr_Val_Tbl_Type;
3445:
3446: x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
3447: x_Agreement_val_rec OE_Pricing_Cont_PUB.Agreement_Val_Rec_Type;
3448:
3445:
3446: x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
3447: x_Agreement_val_rec OE_Pricing_Cont_PUB.Agreement_Val_Rec_Type;
3448:
3449: x_price_list_rec QP_PRICE_LIST_PUB.Price_List_Rec_Type;
3450: x_price_list_val_rec QP_PRICE_LIST_PUB.Price_List_Val_Rec_Type;
3451:
3452: x_price_list_line_tbl QP_PRICE_LIST_PUB.Price_List_Line_Tbl_Type;
3453: x_price_list_line_val_tbl QP_PRICE_LIST_PUB.Price_List_Line_Val_Tbl_Type;
3446: x_Agreement_rec OE_Pricing_Cont_PUB.Agreement_Rec_Type;
3447: x_Agreement_val_rec OE_Pricing_Cont_PUB.Agreement_Val_Rec_Type;
3448:
3449: x_price_list_rec QP_PRICE_LIST_PUB.Price_List_Rec_Type;
3450: x_price_list_val_rec QP_PRICE_LIST_PUB.Price_List_Val_Rec_Type;
3451:
3452: x_price_list_line_tbl QP_PRICE_LIST_PUB.Price_List_Line_Tbl_Type;
3453: x_price_list_line_val_tbl QP_PRICE_LIST_PUB.Price_List_Line_Val_Tbl_Type;
3454:
3448:
3449: x_price_list_rec QP_PRICE_LIST_PUB.Price_List_Rec_Type;
3450: x_price_list_val_rec QP_PRICE_LIST_PUB.Price_List_Val_Rec_Type;
3451:
3452: x_price_list_line_tbl QP_PRICE_LIST_PUB.Price_List_Line_Tbl_Type;
3453: x_price_list_line_val_tbl QP_PRICE_LIST_PUB.Price_List_Line_Val_Tbl_Type;
3454:
3455: x_pricing_attr_tbl QP_PRICE_LIST_PUB.Pricing_Attr_Tbl_Type;
3456: x_pricing_attr_val_tbl QP_PRICE_LIST_PUB.Pricing_Attr_Val_Tbl_Type;
3449: x_price_list_rec QP_PRICE_LIST_PUB.Price_List_Rec_Type;
3450: x_price_list_val_rec QP_PRICE_LIST_PUB.Price_List_Val_Rec_Type;
3451:
3452: x_price_list_line_tbl QP_PRICE_LIST_PUB.Price_List_Line_Tbl_Type;
3453: x_price_list_line_val_tbl QP_PRICE_LIST_PUB.Price_List_Line_Val_Tbl_Type;
3454:
3455: x_pricing_attr_tbl QP_PRICE_LIST_PUB.Pricing_Attr_Tbl_Type;
3456: x_pricing_attr_val_tbl QP_PRICE_LIST_PUB.Pricing_Attr_Val_Tbl_Type;
3457:
3451:
3452: x_price_list_line_tbl QP_PRICE_LIST_PUB.Price_List_Line_Tbl_Type;
3453: x_price_list_line_val_tbl QP_PRICE_LIST_PUB.Price_List_Line_Val_Tbl_Type;
3454:
3455: x_pricing_attr_tbl QP_PRICE_LIST_PUB.Pricing_Attr_Tbl_Type;
3456: x_pricing_attr_val_tbl QP_PRICE_LIST_PUB.Pricing_Attr_Val_Tbl_Type;
3457:
3458: BEGIN
3459:
3452: x_price_list_line_tbl QP_PRICE_LIST_PUB.Price_List_Line_Tbl_Type;
3453: x_price_list_line_val_tbl QP_PRICE_LIST_PUB.Price_List_Line_Val_Tbl_Type;
3454:
3455: x_pricing_attr_tbl QP_PRICE_LIST_PUB.Pricing_Attr_Tbl_Type;
3456: x_pricing_attr_val_tbl QP_PRICE_LIST_PUB.Pricing_Attr_Val_Tbl_Type;
3457:
3458: BEGIN
3459:
3460: