391: QP_GLOBALS.G_MISS_CONTROL_REC
392: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
393: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
394: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
395: , p_MODIFIER_LIST_rec IN QP_MODIFIERS_PUB.Modifier_List_Rec_Type :=
396: QP_MODIFIERS_PUB.G_MISS_MODIFIER_LIST_REC
397: , p_MODIFIER_LIST_val_rec IN QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type :=
398: QP_MODIFIERS_PUB.G_MISS_MODIFIER_LIST_VAL_REC
399: , p_MODIFIERS_tbl IN QP_MODIFIERS_PUB.Modifiers_Tbl_Type :=
392: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
393: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
394: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
395: , p_MODIFIER_LIST_rec IN QP_MODIFIERS_PUB.Modifier_List_Rec_Type :=
396: QP_MODIFIERS_PUB.G_MISS_MODIFIER_LIST_REC
397: , p_MODIFIER_LIST_val_rec IN QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type :=
398: QP_MODIFIERS_PUB.G_MISS_MODIFIER_LIST_VAL_REC
399: , p_MODIFIERS_tbl IN QP_MODIFIERS_PUB.Modifiers_Tbl_Type :=
400: QP_MODIFIERS_PUB.G_MISS_MODIFIERS_TBL
393: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
394: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
395: , p_MODIFIER_LIST_rec IN QP_MODIFIERS_PUB.Modifier_List_Rec_Type :=
396: QP_MODIFIERS_PUB.G_MISS_MODIFIER_LIST_REC
397: , p_MODIFIER_LIST_val_rec IN QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type :=
398: QP_MODIFIERS_PUB.G_MISS_MODIFIER_LIST_VAL_REC
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 :=
394: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
395: , p_MODIFIER_LIST_rec IN QP_MODIFIERS_PUB.Modifier_List_Rec_Type :=
396: QP_MODIFIERS_PUB.G_MISS_MODIFIER_LIST_REC
397: , p_MODIFIER_LIST_val_rec IN QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type :=
398: QP_MODIFIERS_PUB.G_MISS_MODIFIER_LIST_VAL_REC
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
395: , p_MODIFIER_LIST_rec IN QP_MODIFIERS_PUB.Modifier_List_Rec_Type :=
396: QP_MODIFIERS_PUB.G_MISS_MODIFIER_LIST_REC
397: , p_MODIFIER_LIST_val_rec IN QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type :=
398: QP_MODIFIERS_PUB.G_MISS_MODIFIER_LIST_VAL_REC
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 :=
396: QP_MODIFIERS_PUB.G_MISS_MODIFIER_LIST_REC
397: , p_MODIFIER_LIST_val_rec IN QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type :=
398: QP_MODIFIERS_PUB.G_MISS_MODIFIER_LIST_VAL_REC
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
397: , p_MODIFIER_LIST_val_rec IN QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type :=
398: QP_MODIFIERS_PUB.G_MISS_MODIFIER_LIST_VAL_REC
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 :=
398: QP_MODIFIERS_PUB.G_MISS_MODIFIER_LIST_VAL_REC
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
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
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
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
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
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
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
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
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
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:
421: -- Start of Comments
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:
421: -- Start of Comments
422: -- API name Lock_Modifiers
440: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
441: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
442: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
443: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
444: , p_MODIFIER_LIST_rec IN QP_MODIFIERS_PUB.Modifier_List_Rec_Type :=
445: QP_MODIFIERS_PUB.G_MISS_MODIFIER_LIST_REC
446: , p_MODIFIER_LIST_val_rec IN QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type :=
447: QP_MODIFIERS_PUB.G_MISS_MODIFIER_LIST_VAL_REC
448: , p_MODIFIERS_tbl IN QP_MODIFIERS_PUB.Modifiers_Tbl_Type :=
441: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
442: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
443: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
444: , p_MODIFIER_LIST_rec IN QP_MODIFIERS_PUB.Modifier_List_Rec_Type :=
445: QP_MODIFIERS_PUB.G_MISS_MODIFIER_LIST_REC
446: , p_MODIFIER_LIST_val_rec IN QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type :=
447: QP_MODIFIERS_PUB.G_MISS_MODIFIER_LIST_VAL_REC
448: , p_MODIFIERS_tbl IN QP_MODIFIERS_PUB.Modifiers_Tbl_Type :=
449: QP_MODIFIERS_PUB.G_MISS_MODIFIERS_TBL
442: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
443: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
444: , p_MODIFIER_LIST_rec IN QP_MODIFIERS_PUB.Modifier_List_Rec_Type :=
445: QP_MODIFIERS_PUB.G_MISS_MODIFIER_LIST_REC
446: , p_MODIFIER_LIST_val_rec IN QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type :=
447: QP_MODIFIERS_PUB.G_MISS_MODIFIER_LIST_VAL_REC
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 :=
443: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
444: , p_MODIFIER_LIST_rec IN QP_MODIFIERS_PUB.Modifier_List_Rec_Type :=
445: QP_MODIFIERS_PUB.G_MISS_MODIFIER_LIST_REC
446: , p_MODIFIER_LIST_val_rec IN QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type :=
447: QP_MODIFIERS_PUB.G_MISS_MODIFIER_LIST_VAL_REC
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
444: , p_MODIFIER_LIST_rec IN QP_MODIFIERS_PUB.Modifier_List_Rec_Type :=
445: QP_MODIFIERS_PUB.G_MISS_MODIFIER_LIST_REC
446: , p_MODIFIER_LIST_val_rec IN QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type :=
447: QP_MODIFIERS_PUB.G_MISS_MODIFIER_LIST_VAL_REC
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 :=
445: QP_MODIFIERS_PUB.G_MISS_MODIFIER_LIST_REC
446: , p_MODIFIER_LIST_val_rec IN QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type :=
447: QP_MODIFIERS_PUB.G_MISS_MODIFIER_LIST_VAL_REC
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
446: , p_MODIFIER_LIST_val_rec IN QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type :=
447: QP_MODIFIERS_PUB.G_MISS_MODIFIER_LIST_VAL_REC
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 :=
447: QP_MODIFIERS_PUB.G_MISS_MODIFIER_LIST_VAL_REC
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
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
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
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
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
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
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
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
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
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:
470: -- Start of Comments
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:
470: -- Start of Comments
471: -- API name Get_Modifiers
493: , p_list_header_id IN NUMBER :=
494: FND_API.G_MISS_NUM
495: , p_list_header IN VARCHAR2 :=
496: FND_API.G_MISS_CHAR
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
494: FND_API.G_MISS_NUM
495: , p_list_header IN VARCHAR2 :=
496: FND_API.G_MISS_CHAR
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
495: , p_list_header IN VARCHAR2 :=
496: FND_API.G_MISS_CHAR
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
496: FND_API.G_MISS_CHAR
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
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:
507: END QP_Modifiers_GRP;
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:
507: END QP_Modifiers_GRP;