355: G_MISS_MODIFIERS_REC Modifiers_Rec_Type;
356: G_MISS_MODIFIERS_VAL_REC Modifiers_Val_Rec_Type;
357: G_MISS_MODIFIERS_TBL Modifiers_Tbl_Type;
358: G_MISS_MODIFIERS_VAL_TBL Modifiers_Val_Tbl_Type;
359: G_MISS_QUALIFIERS_REC QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
360: G_MISS_QUALIFIERS_VAL_REC QP_Qualifier_Rules_PUB.Qualifiers_Val_Rec_Type;
361: G_MISS_QUALIFIERS_TBL QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
362: G_MISS_QUALIFIERS_VAL_TBL QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
363: G_MISS_PRICING_ATTR_REC Pricing_Attr_Rec_Type;
356: G_MISS_MODIFIERS_VAL_REC Modifiers_Val_Rec_Type;
357: G_MISS_MODIFIERS_TBL Modifiers_Tbl_Type;
358: G_MISS_MODIFIERS_VAL_TBL Modifiers_Val_Tbl_Type;
359: G_MISS_QUALIFIERS_REC QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
360: G_MISS_QUALIFIERS_VAL_REC QP_Qualifier_Rules_PUB.Qualifiers_Val_Rec_Type;
361: G_MISS_QUALIFIERS_TBL QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
362: G_MISS_QUALIFIERS_VAL_TBL QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
363: G_MISS_PRICING_ATTR_REC Pricing_Attr_Rec_Type;
364: G_MISS_PRICING_ATTR_VAL_REC Pricing_Attr_Val_Rec_Type;
357: G_MISS_MODIFIERS_TBL Modifiers_Tbl_Type;
358: G_MISS_MODIFIERS_VAL_TBL Modifiers_Val_Tbl_Type;
359: G_MISS_QUALIFIERS_REC QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
360: G_MISS_QUALIFIERS_VAL_REC QP_Qualifier_Rules_PUB.Qualifiers_Val_Rec_Type;
361: G_MISS_QUALIFIERS_TBL QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
362: G_MISS_QUALIFIERS_VAL_TBL QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
363: G_MISS_PRICING_ATTR_REC Pricing_Attr_Rec_Type;
364: G_MISS_PRICING_ATTR_VAL_REC Pricing_Attr_Val_Rec_Type;
365: G_MISS_PRICING_ATTR_TBL Pricing_Attr_Tbl_Type;
358: G_MISS_MODIFIERS_VAL_TBL Modifiers_Val_Tbl_Type;
359: G_MISS_QUALIFIERS_REC QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
360: G_MISS_QUALIFIERS_VAL_REC QP_Qualifier_Rules_PUB.Qualifiers_Val_Rec_Type;
361: G_MISS_QUALIFIERS_TBL QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
362: G_MISS_QUALIFIERS_VAL_TBL QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
363: G_MISS_PRICING_ATTR_REC Pricing_Attr_Rec_Type;
364: G_MISS_PRICING_ATTR_VAL_REC Pricing_Attr_Val_Rec_Type;
365: G_MISS_PRICING_ATTR_TBL Pricing_Attr_Tbl_Type;
366: G_MISS_PRICING_ATTR_VAL_TBL Pricing_Attr_Val_Tbl_Type;
399: , p_MODIFIERS_tbl IN QP_MODIFIERS_PUB.Modifiers_Tbl_Type :=
400: QP_MODIFIERS_PUB.G_MISS_MODIFIERS_TBL
401: , p_MODIFIERS_val_tbl IN QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type :=
402: QP_MODIFIERS_PUB.G_MISS_MODIFIERS_VAL_TBL
403: , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type :=
404: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_TBL
405: , p_QUALIFIERS_val_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type :=
406: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_VAL_TBL
407: , p_PRICING_ATTR_tbl IN QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type :=
400: QP_MODIFIERS_PUB.G_MISS_MODIFIERS_TBL
401: , p_MODIFIERS_val_tbl IN QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type :=
402: QP_MODIFIERS_PUB.G_MISS_MODIFIERS_VAL_TBL
403: , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type :=
404: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_TBL
405: , p_QUALIFIERS_val_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type :=
406: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_VAL_TBL
407: , p_PRICING_ATTR_tbl IN QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type :=
408: QP_MODIFIERS_PUB.G_MISS_PRICING_ATTR_TBL
401: , p_MODIFIERS_val_tbl IN QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type :=
402: QP_MODIFIERS_PUB.G_MISS_MODIFIERS_VAL_TBL
403: , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type :=
404: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_TBL
405: , p_QUALIFIERS_val_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type :=
406: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_VAL_TBL
407: , p_PRICING_ATTR_tbl IN QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type :=
408: QP_MODIFIERS_PUB.G_MISS_PRICING_ATTR_TBL
409: , p_PRICING_ATTR_val_tbl IN QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type :=
402: QP_MODIFIERS_PUB.G_MISS_MODIFIERS_VAL_TBL
403: , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type :=
404: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_TBL
405: , p_QUALIFIERS_val_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type :=
406: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_VAL_TBL
407: , p_PRICING_ATTR_tbl IN QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type :=
408: QP_MODIFIERS_PUB.G_MISS_PRICING_ATTR_TBL
409: , p_PRICING_ATTR_val_tbl IN QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type :=
410: QP_MODIFIERS_PUB.G_MISS_PRICING_ATTR_VAL_TBL
411: , x_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifier_List_Rec_Type
412: , x_MODIFIER_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type
413: , x_MODIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifiers_Tbl_Type
414: , x_MODIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type
415: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
416: , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type
417: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
418: , x_PRICING_ATTR_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type
419: );
412: , x_MODIFIER_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type
413: , x_MODIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifiers_Tbl_Type
414: , x_MODIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type
415: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
416: , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type
417: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
418: , x_PRICING_ATTR_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type
419: );
420:
448: , p_MODIFIERS_tbl IN QP_MODIFIERS_PUB.Modifiers_Tbl_Type :=
449: QP_MODIFIERS_PUB.G_MISS_MODIFIERS_TBL
450: , p_MODIFIERS_val_tbl IN QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type :=
451: QP_MODIFIERS_PUB.G_MISS_MODIFIERS_VAL_TBL
452: , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type :=
453: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_TBL
454: , p_QUALIFIERS_val_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type :=
455: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_VAL_TBL
456: , p_PRICING_ATTR_tbl IN QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type :=
449: QP_MODIFIERS_PUB.G_MISS_MODIFIERS_TBL
450: , p_MODIFIERS_val_tbl IN QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type :=
451: QP_MODIFIERS_PUB.G_MISS_MODIFIERS_VAL_TBL
452: , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type :=
453: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_TBL
454: , p_QUALIFIERS_val_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type :=
455: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_VAL_TBL
456: , p_PRICING_ATTR_tbl IN QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type :=
457: QP_MODIFIERS_PUB.G_MISS_PRICING_ATTR_TBL
450: , p_MODIFIERS_val_tbl IN QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type :=
451: QP_MODIFIERS_PUB.G_MISS_MODIFIERS_VAL_TBL
452: , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type :=
453: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_TBL
454: , p_QUALIFIERS_val_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type :=
455: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_VAL_TBL
456: , p_PRICING_ATTR_tbl IN QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type :=
457: QP_MODIFIERS_PUB.G_MISS_PRICING_ATTR_TBL
458: , p_PRICING_ATTR_val_tbl IN QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type :=
451: QP_MODIFIERS_PUB.G_MISS_MODIFIERS_VAL_TBL
452: , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type :=
453: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_TBL
454: , p_QUALIFIERS_val_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type :=
455: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_VAL_TBL
456: , p_PRICING_ATTR_tbl IN QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type :=
457: QP_MODIFIERS_PUB.G_MISS_PRICING_ATTR_TBL
458: , p_PRICING_ATTR_val_tbl IN QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type :=
459: QP_MODIFIERS_PUB.G_MISS_PRICING_ATTR_VAL_TBL
460: , x_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifier_List_Rec_Type
461: , x_MODIFIER_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type
462: , x_MODIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifiers_Tbl_Type
463: , x_MODIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type
464: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
465: , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type
466: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
467: , x_PRICING_ATTR_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type
468: );
461: , x_MODIFIER_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type
462: , x_MODIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifiers_Tbl_Type
463: , x_MODIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type
464: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
465: , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type
466: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
467: , x_PRICING_ATTR_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type
468: );
469:
497: , x_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifier_List_Rec_Type
498: , x_MODIFIER_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type
499: , x_MODIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifiers_Tbl_Type
500: , x_MODIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type
501: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
502: , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type
503: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
504: , x_PRICING_ATTR_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type
505: );
498: , x_MODIFIER_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type
499: , x_MODIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifiers_Tbl_Type
500: , x_MODIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type
501: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
502: , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type
503: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
504: , x_PRICING_ATTR_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type
505: );
506: