29: QP_GLOBALS.G_MISS_CONTROL_REC
30: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
31: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
32: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
33: , p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type :=
34: QP_Price_List_PUB.G_MISS_PRICE_LIST_REC
35: , p_old_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type :=
36: QP_Price_List_PUB.G_MISS_PRICE_LIST_REC
37: , p_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=
30: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
31: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
32: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
33: , p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type :=
34: QP_Price_List_PUB.G_MISS_PRICE_LIST_REC
35: , p_old_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type :=
36: QP_Price_List_PUB.G_MISS_PRICE_LIST_REC
37: , p_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=
38: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
31: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
32: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
33: , p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type :=
34: QP_Price_List_PUB.G_MISS_PRICE_LIST_REC
35: , p_old_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type :=
36: QP_Price_List_PUB.G_MISS_PRICE_LIST_REC
37: , p_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=
38: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
39: , p_old_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=
32: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
33: , p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type :=
34: QP_Price_List_PUB.G_MISS_PRICE_LIST_REC
35: , p_old_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type :=
36: QP_Price_List_PUB.G_MISS_PRICE_LIST_REC
37: , p_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=
38: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
39: , p_old_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=
40: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
33: , p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type :=
34: QP_Price_List_PUB.G_MISS_PRICE_LIST_REC
35: , p_old_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type :=
36: QP_Price_List_PUB.G_MISS_PRICE_LIST_REC
37: , p_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=
38: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
39: , p_old_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=
40: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
41: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type :=
34: QP_Price_List_PUB.G_MISS_PRICE_LIST_REC
35: , p_old_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type :=
36: QP_Price_List_PUB.G_MISS_PRICE_LIST_REC
37: , p_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=
38: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
39: , p_old_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=
40: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
41: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type :=
42: QP_Price_List_PUB.G_MISS_QUALIFIERS_TBL
35: , p_old_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type :=
36: QP_Price_List_PUB.G_MISS_PRICE_LIST_REC
37: , p_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=
38: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
39: , p_old_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=
40: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
41: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type :=
42: QP_Price_List_PUB.G_MISS_QUALIFIERS_TBL
43: , p_old_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type :=
36: QP_Price_List_PUB.G_MISS_PRICE_LIST_REC
37: , p_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=
38: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
39: , p_old_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=
40: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
41: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type :=
42: QP_Price_List_PUB.G_MISS_QUALIFIERS_TBL
43: , p_old_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type :=
44: QP_Price_List_PUB.G_MISS_QUALIFIERS_TBL
38: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
39: , p_old_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=
40: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
41: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type :=
42: QP_Price_List_PUB.G_MISS_QUALIFIERS_TBL
43: , p_old_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type :=
44: QP_Price_List_PUB.G_MISS_QUALIFIERS_TBL
45: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=
46: QP_Price_List_PUB.G_MISS_PRICING_ATTR_TBL
40: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
41: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type :=
42: QP_Price_List_PUB.G_MISS_QUALIFIERS_TBL
43: , p_old_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type :=
44: QP_Price_List_PUB.G_MISS_QUALIFIERS_TBL
45: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=
46: QP_Price_List_PUB.G_MISS_PRICING_ATTR_TBL
47: , p_old_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=
48: QP_Price_List_PUB.G_MISS_PRICING_ATTR_TBL
41: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type :=
42: QP_Price_List_PUB.G_MISS_QUALIFIERS_TBL
43: , p_old_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type :=
44: QP_Price_List_PUB.G_MISS_QUALIFIERS_TBL
45: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=
46: QP_Price_List_PUB.G_MISS_PRICING_ATTR_TBL
47: , p_old_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=
48: QP_Price_List_PUB.G_MISS_PRICING_ATTR_TBL
49: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
42: QP_Price_List_PUB.G_MISS_QUALIFIERS_TBL
43: , p_old_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type :=
44: QP_Price_List_PUB.G_MISS_QUALIFIERS_TBL
45: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=
46: QP_Price_List_PUB.G_MISS_PRICING_ATTR_TBL
47: , p_old_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=
48: QP_Price_List_PUB.G_MISS_PRICING_ATTR_TBL
49: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
50: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
43: , p_old_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type :=
44: QP_Price_List_PUB.G_MISS_QUALIFIERS_TBL
45: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=
46: QP_Price_List_PUB.G_MISS_PRICING_ATTR_TBL
47: , p_old_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=
48: QP_Price_List_PUB.G_MISS_PRICING_ATTR_TBL
49: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
50: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
51: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
44: QP_Price_List_PUB.G_MISS_QUALIFIERS_TBL
45: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=
46: QP_Price_List_PUB.G_MISS_PRICING_ATTR_TBL
47: , p_old_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=
48: QP_Price_List_PUB.G_MISS_PRICING_ATTR_TBL
49: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
50: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
51: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
52: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
45: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=
46: QP_Price_List_PUB.G_MISS_PRICING_ATTR_TBL
47: , p_old_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=
48: QP_Price_List_PUB.G_MISS_PRICING_ATTR_TBL
49: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
50: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
51: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
52: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
53: );
46: QP_Price_List_PUB.G_MISS_PRICING_ATTR_TBL
47: , p_old_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=
48: QP_Price_List_PUB.G_MISS_PRICING_ATTR_TBL
49: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
50: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
51: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
52: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
53: );
54:
48: QP_Price_List_PUB.G_MISS_PRICING_ATTR_TBL
49: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
50: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
51: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
52: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
53: );
54:
55: -- Start of Comments
56: -- API name Lock_Price_List
73: , p_init_msg_list 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_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=
80: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
81: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_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_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=
80: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
81: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type :=
82: QP_Price_List_PUB.G_MISS_QUALIFIERS_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_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=
80: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
81: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type :=
82: QP_Price_List_PUB.G_MISS_QUALIFIERS_TBL
83: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_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_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=
80: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
81: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type :=
82: QP_Price_List_PUB.G_MISS_QUALIFIERS_TBL
83: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=
84: QP_Price_List_PUB.G_MISS_PRICING_ATTR_TBL
78: QP_Price_List_PUB.G_MISS_PRICE_LIST_REC
79: , p_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=
80: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
81: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type :=
82: QP_Price_List_PUB.G_MISS_QUALIFIERS_TBL
83: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=
84: QP_Price_List_PUB.G_MISS_PRICING_ATTR_TBL
85: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
86: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
79: , p_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=
80: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
81: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type :=
82: QP_Price_List_PUB.G_MISS_QUALIFIERS_TBL
83: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=
84: QP_Price_List_PUB.G_MISS_PRICING_ATTR_TBL
85: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
86: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
87: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
80: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
81: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type :=
82: QP_Price_List_PUB.G_MISS_QUALIFIERS_TBL
83: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=
84: QP_Price_List_PUB.G_MISS_PRICING_ATTR_TBL
85: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
86: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
87: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
88: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
81: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type :=
82: QP_Price_List_PUB.G_MISS_QUALIFIERS_TBL
83: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=
84: QP_Price_List_PUB.G_MISS_PRICING_ATTR_TBL
85: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
86: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
87: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
88: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
89: );
82: QP_Price_List_PUB.G_MISS_QUALIFIERS_TBL
83: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=
84: QP_Price_List_PUB.G_MISS_PRICING_ATTR_TBL
85: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
86: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
87: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
88: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
89: );
90:
84: QP_Price_List_PUB.G_MISS_PRICING_ATTR_TBL
85: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
86: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
87: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
88: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
89: );
90:
91: -- Start of Comments
92: -- API name Get_Price_List
110: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
111: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
112: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
113: , p_list_header_id IN NUMBER
114: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
115: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
116: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
117: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
118: );
111: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
112: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
113: , p_list_header_id IN NUMBER
114: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
115: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
116: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
117: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
118: );
119:
113: , p_list_header_id IN NUMBER
114: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
115: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
116: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
117: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
118: );
119:
120: END QP_LIST_HEADERS_PVT;