24: , p_commit IN VARCHAR2 := FND_API.G_FALSE
25: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
26: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
27: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
28: , p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type :=
29: QP_Price_List_PUB.G_MISS_PRICE_LIST_REC
30: , p_PRICE_LIST_val_rec IN QP_Price_List_PUB.Price_List_Val_Rec_Type :=
31: QP_Price_List_PUB.G_MISS_PRICE_LIST_VAL_REC
32: , p_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=
25: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
26: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
27: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
28: , p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type :=
29: QP_Price_List_PUB.G_MISS_PRICE_LIST_REC
30: , p_PRICE_LIST_val_rec IN QP_Price_List_PUB.Price_List_Val_Rec_Type :=
31: QP_Price_List_PUB.G_MISS_PRICE_LIST_VAL_REC
32: , p_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=
33: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
26: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
27: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
28: , p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type :=
29: QP_Price_List_PUB.G_MISS_PRICE_LIST_REC
30: , p_PRICE_LIST_val_rec IN QP_Price_List_PUB.Price_List_Val_Rec_Type :=
31: QP_Price_List_PUB.G_MISS_PRICE_LIST_VAL_REC
32: , p_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=
33: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
34: , p_PRICE_LIST_LINE_val_tbl IN QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type :=
27: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
28: , p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type :=
29: QP_Price_List_PUB.G_MISS_PRICE_LIST_REC
30: , p_PRICE_LIST_val_rec IN QP_Price_List_PUB.Price_List_Val_Rec_Type :=
31: QP_Price_List_PUB.G_MISS_PRICE_LIST_VAL_REC
32: , p_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=
33: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
34: , p_PRICE_LIST_LINE_val_tbl IN QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type :=
35: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_VAL_TBL
28: , p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type :=
29: QP_Price_List_PUB.G_MISS_PRICE_LIST_REC
30: , p_PRICE_LIST_val_rec IN QP_Price_List_PUB.Price_List_Val_Rec_Type :=
31: QP_Price_List_PUB.G_MISS_PRICE_LIST_VAL_REC
32: , p_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=
33: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
34: , p_PRICE_LIST_LINE_val_tbl IN QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type :=
35: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_VAL_TBL
36: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type :=
29: QP_Price_List_PUB.G_MISS_PRICE_LIST_REC
30: , p_PRICE_LIST_val_rec IN QP_Price_List_PUB.Price_List_Val_Rec_Type :=
31: QP_Price_List_PUB.G_MISS_PRICE_LIST_VAL_REC
32: , p_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=
33: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
34: , p_PRICE_LIST_LINE_val_tbl IN QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type :=
35: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_VAL_TBL
36: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type :=
37: QP_Price_List_PUB.G_MISS_QUALIFIERS_TBL
30: , p_PRICE_LIST_val_rec IN QP_Price_List_PUB.Price_List_Val_Rec_Type :=
31: QP_Price_List_PUB.G_MISS_PRICE_LIST_VAL_REC
32: , p_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=
33: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
34: , p_PRICE_LIST_LINE_val_tbl IN QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type :=
35: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_VAL_TBL
36: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type :=
37: QP_Price_List_PUB.G_MISS_QUALIFIERS_TBL
38: , p_QUALIFIERS_val_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type :=
31: QP_Price_List_PUB.G_MISS_PRICE_LIST_VAL_REC
32: , p_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=
33: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
34: , p_PRICE_LIST_LINE_val_tbl IN QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type :=
35: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_VAL_TBL
36: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type :=
37: QP_Price_List_PUB.G_MISS_QUALIFIERS_TBL
38: , p_QUALIFIERS_val_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type :=
39: QP_Price_List_PUB.G_MISS_QUALIFIERS_VAL_TBL
33: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
34: , p_PRICE_LIST_LINE_val_tbl IN QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type :=
35: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_VAL_TBL
36: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type :=
37: QP_Price_List_PUB.G_MISS_QUALIFIERS_TBL
38: , p_QUALIFIERS_val_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type :=
39: QP_Price_List_PUB.G_MISS_QUALIFIERS_VAL_TBL
40: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=
41: QP_Price_List_PUB.G_MISS_PRICING_ATTR_TBL
35: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_VAL_TBL
36: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type :=
37: QP_Price_List_PUB.G_MISS_QUALIFIERS_TBL
38: , p_QUALIFIERS_val_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type :=
39: QP_Price_List_PUB.G_MISS_QUALIFIERS_VAL_TBL
40: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=
41: QP_Price_List_PUB.G_MISS_PRICING_ATTR_TBL
42: , p_PRICING_ATTR_val_tbl IN QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type :=
43: QP_Price_List_PUB.G_MISS_PRICING_ATTR_VAL_TBL
36: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type :=
37: QP_Price_List_PUB.G_MISS_QUALIFIERS_TBL
38: , p_QUALIFIERS_val_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type :=
39: QP_Price_List_PUB.G_MISS_QUALIFIERS_VAL_TBL
40: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=
41: QP_Price_List_PUB.G_MISS_PRICING_ATTR_TBL
42: , p_PRICING_ATTR_val_tbl IN QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type :=
43: QP_Price_List_PUB.G_MISS_PRICING_ATTR_VAL_TBL
44: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
37: QP_Price_List_PUB.G_MISS_QUALIFIERS_TBL
38: , p_QUALIFIERS_val_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type :=
39: QP_Price_List_PUB.G_MISS_QUALIFIERS_VAL_TBL
40: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=
41: QP_Price_List_PUB.G_MISS_PRICING_ATTR_TBL
42: , p_PRICING_ATTR_val_tbl IN QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type :=
43: QP_Price_List_PUB.G_MISS_PRICING_ATTR_VAL_TBL
44: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
45: , x_PRICE_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type
38: , p_QUALIFIERS_val_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type :=
39: QP_Price_List_PUB.G_MISS_QUALIFIERS_VAL_TBL
40: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=
41: QP_Price_List_PUB.G_MISS_PRICING_ATTR_TBL
42: , p_PRICING_ATTR_val_tbl IN QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type :=
43: QP_Price_List_PUB.G_MISS_PRICING_ATTR_VAL_TBL
44: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
45: , x_PRICE_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type
46: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
39: QP_Price_List_PUB.G_MISS_QUALIFIERS_VAL_TBL
40: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=
41: QP_Price_List_PUB.G_MISS_PRICING_ATTR_TBL
42: , p_PRICING_ATTR_val_tbl IN QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type :=
43: QP_Price_List_PUB.G_MISS_PRICING_ATTR_VAL_TBL
44: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
45: , x_PRICE_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type
46: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
47: , x_PRICE_LIST_LINE_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
40: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=
41: QP_Price_List_PUB.G_MISS_PRICING_ATTR_TBL
42: , p_PRICING_ATTR_val_tbl IN QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type :=
43: QP_Price_List_PUB.G_MISS_PRICING_ATTR_VAL_TBL
44: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
45: , x_PRICE_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type
46: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
47: , x_PRICE_LIST_LINE_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
48: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
41: QP_Price_List_PUB.G_MISS_PRICING_ATTR_TBL
42: , p_PRICING_ATTR_val_tbl IN QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type :=
43: QP_Price_List_PUB.G_MISS_PRICING_ATTR_VAL_TBL
44: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
45: , x_PRICE_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type
46: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
47: , x_PRICE_LIST_LINE_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
48: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
49: , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type
42: , p_PRICING_ATTR_val_tbl IN QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type :=
43: QP_Price_List_PUB.G_MISS_PRICING_ATTR_VAL_TBL
44: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
45: , x_PRICE_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type
46: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
47: , x_PRICE_LIST_LINE_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
48: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
49: , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type
50: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
43: QP_Price_List_PUB.G_MISS_PRICING_ATTR_VAL_TBL
44: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
45: , x_PRICE_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type
46: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
47: , x_PRICE_LIST_LINE_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
48: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
49: , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type
50: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
51: , x_PRICING_ATTR_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type
46: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
47: , x_PRICE_LIST_LINE_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
48: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
49: , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type
50: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
51: , x_PRICING_ATTR_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type
52: );
53:
54: -- Start of Comments
47: , x_PRICE_LIST_LINE_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
48: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
49: , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type
50: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
51: , x_PRICING_ATTR_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type
52: );
53:
54: -- Start of Comments
55: -- API name Lock_Price_List
73: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
74: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
75: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
76: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
77: , p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type :=
78: QP_Price_List_PUB.G_MISS_PRICE_LIST_REC
79: , p_PRICE_LIST_val_rec IN QP_Price_List_PUB.Price_List_Val_Rec_Type :=
80: QP_Price_List_PUB.G_MISS_PRICE_LIST_VAL_REC
81: , p_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=
74: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
75: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
76: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
77: , p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type :=
78: QP_Price_List_PUB.G_MISS_PRICE_LIST_REC
79: , p_PRICE_LIST_val_rec IN QP_Price_List_PUB.Price_List_Val_Rec_Type :=
80: QP_Price_List_PUB.G_MISS_PRICE_LIST_VAL_REC
81: , p_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=
82: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
75: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
76: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
77: , p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type :=
78: QP_Price_List_PUB.G_MISS_PRICE_LIST_REC
79: , p_PRICE_LIST_val_rec IN QP_Price_List_PUB.Price_List_Val_Rec_Type :=
80: QP_Price_List_PUB.G_MISS_PRICE_LIST_VAL_REC
81: , p_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=
82: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
83: , p_PRICE_LIST_LINE_val_tbl IN QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type :=
76: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
77: , p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type :=
78: QP_Price_List_PUB.G_MISS_PRICE_LIST_REC
79: , p_PRICE_LIST_val_rec IN QP_Price_List_PUB.Price_List_Val_Rec_Type :=
80: QP_Price_List_PUB.G_MISS_PRICE_LIST_VAL_REC
81: , p_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=
82: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
83: , p_PRICE_LIST_LINE_val_tbl IN QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type :=
84: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_VAL_TBL
77: , p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type :=
78: QP_Price_List_PUB.G_MISS_PRICE_LIST_REC
79: , p_PRICE_LIST_val_rec IN QP_Price_List_PUB.Price_List_Val_Rec_Type :=
80: QP_Price_List_PUB.G_MISS_PRICE_LIST_VAL_REC
81: , p_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=
82: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
83: , p_PRICE_LIST_LINE_val_tbl IN QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type :=
84: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_VAL_TBL
85: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type :=
78: QP_Price_List_PUB.G_MISS_PRICE_LIST_REC
79: , p_PRICE_LIST_val_rec IN QP_Price_List_PUB.Price_List_Val_Rec_Type :=
80: QP_Price_List_PUB.G_MISS_PRICE_LIST_VAL_REC
81: , p_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=
82: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
83: , p_PRICE_LIST_LINE_val_tbl IN QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type :=
84: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_VAL_TBL
85: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type :=
86: QP_Price_List_PUB.G_MISS_QUALIFIERS_TBL
79: , p_PRICE_LIST_val_rec IN QP_Price_List_PUB.Price_List_Val_Rec_Type :=
80: QP_Price_List_PUB.G_MISS_PRICE_LIST_VAL_REC
81: , p_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=
82: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
83: , p_PRICE_LIST_LINE_val_tbl IN QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type :=
84: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_VAL_TBL
85: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type :=
86: QP_Price_List_PUB.G_MISS_QUALIFIERS_TBL
87: , p_QUALIFIERS_val_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type :=
80: QP_Price_List_PUB.G_MISS_PRICE_LIST_VAL_REC
81: , p_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=
82: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
83: , p_PRICE_LIST_LINE_val_tbl IN QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type :=
84: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_VAL_TBL
85: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type :=
86: QP_Price_List_PUB.G_MISS_QUALIFIERS_TBL
87: , p_QUALIFIERS_val_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type :=
88: QP_Price_List_PUB.G_MISS_QUALIFIERS_VAL_TBL
82: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
83: , p_PRICE_LIST_LINE_val_tbl IN QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type :=
84: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_VAL_TBL
85: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type :=
86: QP_Price_List_PUB.G_MISS_QUALIFIERS_TBL
87: , p_QUALIFIERS_val_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type :=
88: QP_Price_List_PUB.G_MISS_QUALIFIERS_VAL_TBL
89: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=
90: QP_Price_List_PUB.G_MISS_PRICING_ATTR_TBL
84: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_VAL_TBL
85: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type :=
86: QP_Price_List_PUB.G_MISS_QUALIFIERS_TBL
87: , p_QUALIFIERS_val_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type :=
88: QP_Price_List_PUB.G_MISS_QUALIFIERS_VAL_TBL
89: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=
90: QP_Price_List_PUB.G_MISS_PRICING_ATTR_TBL
91: , p_PRICING_ATTR_val_tbl IN QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type :=
92: QP_Price_List_PUB.G_MISS_PRICING_ATTR_VAL_TBL
85: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type :=
86: QP_Price_List_PUB.G_MISS_QUALIFIERS_TBL
87: , p_QUALIFIERS_val_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type :=
88: QP_Price_List_PUB.G_MISS_QUALIFIERS_VAL_TBL
89: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=
90: QP_Price_List_PUB.G_MISS_PRICING_ATTR_TBL
91: , p_PRICING_ATTR_val_tbl IN QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type :=
92: QP_Price_List_PUB.G_MISS_PRICING_ATTR_VAL_TBL
93: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
86: QP_Price_List_PUB.G_MISS_QUALIFIERS_TBL
87: , p_QUALIFIERS_val_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type :=
88: QP_Price_List_PUB.G_MISS_QUALIFIERS_VAL_TBL
89: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=
90: QP_Price_List_PUB.G_MISS_PRICING_ATTR_TBL
91: , p_PRICING_ATTR_val_tbl IN QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type :=
92: QP_Price_List_PUB.G_MISS_PRICING_ATTR_VAL_TBL
93: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
94: , x_PRICE_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type
87: , p_QUALIFIERS_val_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type :=
88: QP_Price_List_PUB.G_MISS_QUALIFIERS_VAL_TBL
89: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=
90: QP_Price_List_PUB.G_MISS_PRICING_ATTR_TBL
91: , p_PRICING_ATTR_val_tbl IN QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type :=
92: QP_Price_List_PUB.G_MISS_PRICING_ATTR_VAL_TBL
93: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
94: , x_PRICE_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type
95: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
88: QP_Price_List_PUB.G_MISS_QUALIFIERS_VAL_TBL
89: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=
90: QP_Price_List_PUB.G_MISS_PRICING_ATTR_TBL
91: , p_PRICING_ATTR_val_tbl IN QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type :=
92: QP_Price_List_PUB.G_MISS_PRICING_ATTR_VAL_TBL
93: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
94: , x_PRICE_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type
95: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
96: , x_PRICE_LIST_LINE_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
89: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=
90: QP_Price_List_PUB.G_MISS_PRICING_ATTR_TBL
91: , p_PRICING_ATTR_val_tbl IN QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type :=
92: QP_Price_List_PUB.G_MISS_PRICING_ATTR_VAL_TBL
93: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
94: , x_PRICE_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type
95: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
96: , x_PRICE_LIST_LINE_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
97: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
90: QP_Price_List_PUB.G_MISS_PRICING_ATTR_TBL
91: , p_PRICING_ATTR_val_tbl IN QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type :=
92: QP_Price_List_PUB.G_MISS_PRICING_ATTR_VAL_TBL
93: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
94: , x_PRICE_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type
95: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
96: , x_PRICE_LIST_LINE_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
97: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
98: , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type
91: , p_PRICING_ATTR_val_tbl IN QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type :=
92: QP_Price_List_PUB.G_MISS_PRICING_ATTR_VAL_TBL
93: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
94: , x_PRICE_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type
95: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
96: , x_PRICE_LIST_LINE_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
97: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
98: , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type
99: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
92: QP_Price_List_PUB.G_MISS_PRICING_ATTR_VAL_TBL
93: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
94: , x_PRICE_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type
95: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
96: , x_PRICE_LIST_LINE_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
97: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
98: , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type
99: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
100: , x_PRICING_ATTR_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type
95: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
96: , x_PRICE_LIST_LINE_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
97: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
98: , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type
99: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
100: , x_PRICING_ATTR_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type
101: );
102:
103: -- Start of Comments
96: , x_PRICE_LIST_LINE_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
97: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
98: , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type
99: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
100: , x_PRICING_ATTR_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type
101: );
102:
103: -- Start of Comments
104: -- API name Get_Price_List
126: , p_list_header_id IN NUMBER :=
127: FND_API.G_MISS_NUM
128: , p_list_header IN VARCHAR2 :=
129: FND_API.G_MISS_CHAR
130: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
131: , x_PRICE_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type
132: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
133: , x_PRICE_LIST_LINE_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
134: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
127: FND_API.G_MISS_NUM
128: , p_list_header IN VARCHAR2 :=
129: FND_API.G_MISS_CHAR
130: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
131: , x_PRICE_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type
132: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
133: , x_PRICE_LIST_LINE_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
134: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
135: , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type
128: , p_list_header IN VARCHAR2 :=
129: FND_API.G_MISS_CHAR
130: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
131: , x_PRICE_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type
132: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
133: , x_PRICE_LIST_LINE_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
134: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
135: , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type
136: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
129: FND_API.G_MISS_CHAR
130: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
131: , x_PRICE_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type
132: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
133: , x_PRICE_LIST_LINE_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
134: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
135: , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type
136: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
137: , x_PRICING_ATTR_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type
132: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
133: , x_PRICE_LIST_LINE_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
134: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
135: , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type
136: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
137: , x_PRICING_ATTR_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type
138: );
139:
140: END QP_Price_List_GRP;
133: , x_PRICE_LIST_LINE_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
134: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
135: , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type
136: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
137: , x_PRICING_ATTR_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type
138: );
139:
140: END QP_Price_List_GRP;