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