eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.QP_PRICE_LIST_GRP dependencies on QP_PRICE_LIST_PUB

Line 11: ( p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type

7:
8: -- Forward declaration of Procedure Id_To_Value
9:
10: PROCEDURE Id_To_Value
11: ( p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type
12: , p_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type
13: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
14: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type
15: , x_PRICE_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type

Line 12: , p_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type

8: -- Forward declaration of Procedure Id_To_Value
9:
10: PROCEDURE Id_To_Value
11: ( p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type
12: , p_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type
13: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
14: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type
15: , x_PRICE_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type
16: , x_PRICE_LIST_LINE_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type

Line 14: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type

10: PROCEDURE Id_To_Value
11: ( p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type
12: , p_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type
13: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
14: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type
15: , x_PRICE_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type
16: , x_PRICE_LIST_LINE_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
17: , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type
18: , x_PRICING_ATTR_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type

Line 15: , x_PRICE_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type

11: ( p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type
12: , p_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type
13: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
14: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type
15: , x_PRICE_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type
16: , x_PRICE_LIST_LINE_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
17: , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type
18: , x_PRICING_ATTR_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type
19: );

Line 16: , x_PRICE_LIST_LINE_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type

12: , p_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type
13: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
14: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type
15: , x_PRICE_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type
16: , x_PRICE_LIST_LINE_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
17: , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type
18: , x_PRICING_ATTR_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type
19: );
20:

Line 18: , x_PRICING_ATTR_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type

14: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type
15: , x_PRICE_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type
16: , x_PRICE_LIST_LINE_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
17: , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type
18: , x_PRICING_ATTR_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type
19: );
20:
21: -- Forward declaration of procedure Value_To_Id
22:

Line 25: , p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type

21: -- Forward declaration of procedure Value_To_Id
22:
23: PROCEDURE Value_To_Id
24: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
25: , p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type
26: , p_PRICE_LIST_val_rec IN QP_Price_List_PUB.Price_List_Val_Rec_Type
27: , p_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type
28: , p_PRICE_LIST_LINE_val_tbl IN QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
29: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type

Line 26: , p_PRICE_LIST_val_rec IN QP_Price_List_PUB.Price_List_Val_Rec_Type

22:
23: PROCEDURE Value_To_Id
24: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
25: , p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type
26: , p_PRICE_LIST_val_rec IN QP_Price_List_PUB.Price_List_Val_Rec_Type
27: , p_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type
28: , p_PRICE_LIST_LINE_val_tbl IN QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
29: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
30: , p_QUALIFIERS_val_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type

Line 27: , p_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type

23: PROCEDURE Value_To_Id
24: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
25: , p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type
26: , p_PRICE_LIST_val_rec IN QP_Price_List_PUB.Price_List_Val_Rec_Type
27: , p_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type
28: , p_PRICE_LIST_LINE_val_tbl IN QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
29: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
30: , p_QUALIFIERS_val_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type
31: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type

Line 28: , p_PRICE_LIST_LINE_val_tbl IN QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type

24: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
25: , p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type
26: , p_PRICE_LIST_val_rec IN QP_Price_List_PUB.Price_List_Val_Rec_Type
27: , p_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type
28: , p_PRICE_LIST_LINE_val_tbl IN QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
29: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
30: , p_QUALIFIERS_val_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type
31: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type
32: , p_PRICING_ATTR_val_tbl IN QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type

Line 31: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type

27: , p_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type
28: , p_PRICE_LIST_LINE_val_tbl IN QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
29: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
30: , p_QUALIFIERS_val_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type
31: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type
32: , p_PRICING_ATTR_val_tbl IN QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type
33: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
34: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
35: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type

Line 32: , p_PRICING_ATTR_val_tbl IN QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type

28: , p_PRICE_LIST_LINE_val_tbl IN QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
29: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
30: , p_QUALIFIERS_val_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type
31: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type
32: , p_PRICING_ATTR_val_tbl IN QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type
33: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
34: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
35: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
36: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type

Line 33: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type

29: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
30: , p_QUALIFIERS_val_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type
31: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type
32: , p_PRICING_ATTR_val_tbl IN QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type
33: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
34: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
35: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
36: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
37: );

Line 34: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type

30: , p_QUALIFIERS_val_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type
31: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type
32: , p_PRICING_ATTR_val_tbl IN QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type
33: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
34: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
35: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
36: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
37: );
38:

Line 36: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type

32: , p_PRICING_ATTR_val_tbl IN QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type
33: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
34: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
35: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
36: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
37: );
38:
39: -- Start of Comments
40: -- API name Process_Price_List

Line 63: , p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type :=

59: , p_commit IN VARCHAR2 := FND_API.G_FALSE
60: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
61: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
62: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
63: , p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type :=
64: QP_Price_List_PUB.G_MISS_PRICE_LIST_REC
65: , p_PRICE_LIST_val_rec IN QP_Price_List_PUB.Price_List_Val_Rec_Type :=
66: QP_Price_List_PUB.G_MISS_PRICE_LIST_VAL_REC
67: , p_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=

Line 64: QP_Price_List_PUB.G_MISS_PRICE_LIST_REC

60: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
61: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
62: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
63: , p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type :=
64: QP_Price_List_PUB.G_MISS_PRICE_LIST_REC
65: , p_PRICE_LIST_val_rec IN QP_Price_List_PUB.Price_List_Val_Rec_Type :=
66: QP_Price_List_PUB.G_MISS_PRICE_LIST_VAL_REC
67: , p_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=
68: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL

Line 65: , p_PRICE_LIST_val_rec IN QP_Price_List_PUB.Price_List_Val_Rec_Type :=

61: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
62: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
63: , p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type :=
64: QP_Price_List_PUB.G_MISS_PRICE_LIST_REC
65: , p_PRICE_LIST_val_rec IN QP_Price_List_PUB.Price_List_Val_Rec_Type :=
66: QP_Price_List_PUB.G_MISS_PRICE_LIST_VAL_REC
67: , p_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=
68: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
69: , p_PRICE_LIST_LINE_val_tbl IN QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type :=

Line 66: QP_Price_List_PUB.G_MISS_PRICE_LIST_VAL_REC

62: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
63: , p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type :=
64: QP_Price_List_PUB.G_MISS_PRICE_LIST_REC
65: , p_PRICE_LIST_val_rec IN QP_Price_List_PUB.Price_List_Val_Rec_Type :=
66: QP_Price_List_PUB.G_MISS_PRICE_LIST_VAL_REC
67: , p_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=
68: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
69: , p_PRICE_LIST_LINE_val_tbl IN QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type :=
70: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_VAL_TBL

Line 67: , p_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=

63: , p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type :=
64: QP_Price_List_PUB.G_MISS_PRICE_LIST_REC
65: , p_PRICE_LIST_val_rec IN QP_Price_List_PUB.Price_List_Val_Rec_Type :=
66: QP_Price_List_PUB.G_MISS_PRICE_LIST_VAL_REC
67: , p_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=
68: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
69: , p_PRICE_LIST_LINE_val_tbl IN QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type :=
70: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_VAL_TBL
71: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type :=

Line 68: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL

64: QP_Price_List_PUB.G_MISS_PRICE_LIST_REC
65: , p_PRICE_LIST_val_rec IN QP_Price_List_PUB.Price_List_Val_Rec_Type :=
66: QP_Price_List_PUB.G_MISS_PRICE_LIST_VAL_REC
67: , p_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=
68: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
69: , p_PRICE_LIST_LINE_val_tbl IN QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type :=
70: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_VAL_TBL
71: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type :=
72: QP_Price_List_PUB.G_MISS_QUALIFIERS_TBL

Line 69: , p_PRICE_LIST_LINE_val_tbl IN QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type :=

65: , p_PRICE_LIST_val_rec IN QP_Price_List_PUB.Price_List_Val_Rec_Type :=
66: QP_Price_List_PUB.G_MISS_PRICE_LIST_VAL_REC
67: , p_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=
68: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
69: , p_PRICE_LIST_LINE_val_tbl IN QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type :=
70: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_VAL_TBL
71: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type :=
72: QP_Price_List_PUB.G_MISS_QUALIFIERS_TBL
73: , p_QUALIFIERS_val_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type :=

Line 70: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_VAL_TBL

66: QP_Price_List_PUB.G_MISS_PRICE_LIST_VAL_REC
67: , p_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=
68: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
69: , p_PRICE_LIST_LINE_val_tbl IN QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type :=
70: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_VAL_TBL
71: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type :=
72: QP_Price_List_PUB.G_MISS_QUALIFIERS_TBL
73: , p_QUALIFIERS_val_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type :=
74: QP_Price_List_PUB.G_MISS_QUALIFIERS_VAL_TBL

Line 72: QP_Price_List_PUB.G_MISS_QUALIFIERS_TBL

68: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
69: , p_PRICE_LIST_LINE_val_tbl IN QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type :=
70: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_VAL_TBL
71: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type :=
72: QP_Price_List_PUB.G_MISS_QUALIFIERS_TBL
73: , p_QUALIFIERS_val_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type :=
74: QP_Price_List_PUB.G_MISS_QUALIFIERS_VAL_TBL
75: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=
76: QP_Price_List_PUB.G_MISS_PRICING_ATTR_TBL

Line 74: QP_Price_List_PUB.G_MISS_QUALIFIERS_VAL_TBL

70: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_VAL_TBL
71: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type :=
72: QP_Price_List_PUB.G_MISS_QUALIFIERS_TBL
73: , p_QUALIFIERS_val_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type :=
74: QP_Price_List_PUB.G_MISS_QUALIFIERS_VAL_TBL
75: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=
76: QP_Price_List_PUB.G_MISS_PRICING_ATTR_TBL
77: , p_PRICING_ATTR_val_tbl IN QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type :=
78: QP_Price_List_PUB.G_MISS_PRICING_ATTR_VAL_TBL

Line 75: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=

71: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type :=
72: QP_Price_List_PUB.G_MISS_QUALIFIERS_TBL
73: , p_QUALIFIERS_val_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type :=
74: QP_Price_List_PUB.G_MISS_QUALIFIERS_VAL_TBL
75: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=
76: QP_Price_List_PUB.G_MISS_PRICING_ATTR_TBL
77: , p_PRICING_ATTR_val_tbl IN QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type :=
78: QP_Price_List_PUB.G_MISS_PRICING_ATTR_VAL_TBL
79: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type

Line 76: QP_Price_List_PUB.G_MISS_PRICING_ATTR_TBL

72: QP_Price_List_PUB.G_MISS_QUALIFIERS_TBL
73: , p_QUALIFIERS_val_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type :=
74: QP_Price_List_PUB.G_MISS_QUALIFIERS_VAL_TBL
75: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=
76: QP_Price_List_PUB.G_MISS_PRICING_ATTR_TBL
77: , p_PRICING_ATTR_val_tbl IN QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type :=
78: QP_Price_List_PUB.G_MISS_PRICING_ATTR_VAL_TBL
79: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
80: , x_PRICE_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type

Line 77: , p_PRICING_ATTR_val_tbl IN QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type :=

73: , p_QUALIFIERS_val_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type :=
74: QP_Price_List_PUB.G_MISS_QUALIFIERS_VAL_TBL
75: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=
76: QP_Price_List_PUB.G_MISS_PRICING_ATTR_TBL
77: , p_PRICING_ATTR_val_tbl IN QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type :=
78: QP_Price_List_PUB.G_MISS_PRICING_ATTR_VAL_TBL
79: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
80: , x_PRICE_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type
81: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type

Line 78: QP_Price_List_PUB.G_MISS_PRICING_ATTR_VAL_TBL

74: QP_Price_List_PUB.G_MISS_QUALIFIERS_VAL_TBL
75: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=
76: QP_Price_List_PUB.G_MISS_PRICING_ATTR_TBL
77: , p_PRICING_ATTR_val_tbl IN QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type :=
78: QP_Price_List_PUB.G_MISS_PRICING_ATTR_VAL_TBL
79: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
80: , x_PRICE_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type
81: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
82: , x_PRICE_LIST_LINE_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type

Line 79: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type

75: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=
76: QP_Price_List_PUB.G_MISS_PRICING_ATTR_TBL
77: , p_PRICING_ATTR_val_tbl IN QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type :=
78: QP_Price_List_PUB.G_MISS_PRICING_ATTR_VAL_TBL
79: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
80: , x_PRICE_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type
81: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
82: , x_PRICE_LIST_LINE_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
83: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type

Line 80: , x_PRICE_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type

76: QP_Price_List_PUB.G_MISS_PRICING_ATTR_TBL
77: , p_PRICING_ATTR_val_tbl IN QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type :=
78: QP_Price_List_PUB.G_MISS_PRICING_ATTR_VAL_TBL
79: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
80: , x_PRICE_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type
81: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
82: , x_PRICE_LIST_LINE_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
83: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
84: , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type

Line 81: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type

77: , p_PRICING_ATTR_val_tbl IN QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type :=
78: QP_Price_List_PUB.G_MISS_PRICING_ATTR_VAL_TBL
79: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
80: , x_PRICE_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type
81: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
82: , x_PRICE_LIST_LINE_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
83: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
84: , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type
85: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type

Line 82: , x_PRICE_LIST_LINE_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type

78: QP_Price_List_PUB.G_MISS_PRICING_ATTR_VAL_TBL
79: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
80: , x_PRICE_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type
81: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
82: , x_PRICE_LIST_LINE_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
83: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
84: , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type
85: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
86: , x_PRICING_ATTR_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type

Line 85: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type

81: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
82: , x_PRICE_LIST_LINE_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
83: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
84: , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type
85: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
86: , x_PRICING_ATTR_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type
87: )
88: IS
89: l_api_version_number CONSTANT NUMBER := 1.0;

Line 86: , x_PRICING_ATTR_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type

82: , x_PRICE_LIST_LINE_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
83: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
84: , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type
85: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
86: , x_PRICING_ATTR_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type
87: )
88: IS
89: l_api_version_number CONSTANT NUMBER := 1.0;
90: l_api_name CONSTANT VARCHAR2(30):= 'Process_Price_List';

Line 93: l_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;

89: l_api_version_number CONSTANT NUMBER := 1.0;
90: l_api_name CONSTANT VARCHAR2(30):= 'Process_Price_List';
91: l_control_rec QP_GLOBALS.Control_Rec_Type;
92: l_return_status VARCHAR2(1);
93: l_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
94: l_p_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
95: l_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
96: l_p_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
97: l_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;

Line 94: l_p_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;

90: l_api_name CONSTANT VARCHAR2(30):= 'Process_Price_List';
91: l_control_rec QP_GLOBALS.Control_Rec_Type;
92: l_return_status VARCHAR2(1);
93: l_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
94: l_p_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
95: l_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
96: l_p_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
97: l_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
98: l_p_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;

Line 95: l_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;

91: l_control_rec QP_GLOBALS.Control_Rec_Type;
92: l_return_status VARCHAR2(1);
93: l_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
94: l_p_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
95: l_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
96: l_p_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
97: l_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
98: l_p_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
99: l_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;

Line 96: l_p_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;

92: l_return_status VARCHAR2(1);
93: l_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
94: l_p_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
95: l_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
96: l_p_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
97: l_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
98: l_p_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
99: l_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
100: l_p_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;

Line 99: l_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;

95: l_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
96: l_p_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
97: l_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
98: l_p_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
99: l_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
100: l_p_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
101: l_installed_status VARCHAR2(1);
102: l_request_type_code VARCHAR2(3);
103: BEGIN

Line 100: l_p_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;

96: l_p_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
97: l_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
98: l_p_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
99: l_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
100: l_p_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
101: l_installed_status VARCHAR2(1);
102: l_request_type_code VARCHAR2(3);
103: BEGIN
104:

Line 284: , p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type :=

280: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
281: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
282: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
283: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
284: , p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type :=
285: QP_Price_List_PUB.G_MISS_PRICE_LIST_REC
286: , p_PRICE_LIST_val_rec IN QP_Price_List_PUB.Price_List_Val_Rec_Type :=
287: QP_Price_List_PUB.G_MISS_PRICE_LIST_VAL_REC
288: , p_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=

Line 285: QP_Price_List_PUB.G_MISS_PRICE_LIST_REC

281: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
282: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
283: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
284: , p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type :=
285: QP_Price_List_PUB.G_MISS_PRICE_LIST_REC
286: , p_PRICE_LIST_val_rec IN QP_Price_List_PUB.Price_List_Val_Rec_Type :=
287: QP_Price_List_PUB.G_MISS_PRICE_LIST_VAL_REC
288: , p_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=
289: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL

Line 286: , p_PRICE_LIST_val_rec IN QP_Price_List_PUB.Price_List_Val_Rec_Type :=

282: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
283: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
284: , p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type :=
285: QP_Price_List_PUB.G_MISS_PRICE_LIST_REC
286: , p_PRICE_LIST_val_rec IN QP_Price_List_PUB.Price_List_Val_Rec_Type :=
287: QP_Price_List_PUB.G_MISS_PRICE_LIST_VAL_REC
288: , p_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=
289: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
290: , p_PRICE_LIST_LINE_val_tbl IN QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type :=

Line 287: QP_Price_List_PUB.G_MISS_PRICE_LIST_VAL_REC

283: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
284: , p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type :=
285: QP_Price_List_PUB.G_MISS_PRICE_LIST_REC
286: , p_PRICE_LIST_val_rec IN QP_Price_List_PUB.Price_List_Val_Rec_Type :=
287: QP_Price_List_PUB.G_MISS_PRICE_LIST_VAL_REC
288: , p_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=
289: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
290: , p_PRICE_LIST_LINE_val_tbl IN QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type :=
291: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_VAL_TBL

Line 288: , p_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=

284: , p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type :=
285: QP_Price_List_PUB.G_MISS_PRICE_LIST_REC
286: , p_PRICE_LIST_val_rec IN QP_Price_List_PUB.Price_List_Val_Rec_Type :=
287: QP_Price_List_PUB.G_MISS_PRICE_LIST_VAL_REC
288: , p_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=
289: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
290: , p_PRICE_LIST_LINE_val_tbl IN QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type :=
291: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_VAL_TBL
292: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type :=

Line 289: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL

285: QP_Price_List_PUB.G_MISS_PRICE_LIST_REC
286: , p_PRICE_LIST_val_rec IN QP_Price_List_PUB.Price_List_Val_Rec_Type :=
287: QP_Price_List_PUB.G_MISS_PRICE_LIST_VAL_REC
288: , p_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=
289: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
290: , p_PRICE_LIST_LINE_val_tbl IN QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type :=
291: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_VAL_TBL
292: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type :=
293: QP_Price_List_PUB.G_MISS_QUALIFIERS_TBL

Line 290: , p_PRICE_LIST_LINE_val_tbl IN QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type :=

286: , p_PRICE_LIST_val_rec IN QP_Price_List_PUB.Price_List_Val_Rec_Type :=
287: QP_Price_List_PUB.G_MISS_PRICE_LIST_VAL_REC
288: , p_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=
289: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
290: , p_PRICE_LIST_LINE_val_tbl IN QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type :=
291: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_VAL_TBL
292: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type :=
293: QP_Price_List_PUB.G_MISS_QUALIFIERS_TBL
294: , p_QUALIFIERS_val_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type :=

Line 291: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_VAL_TBL

287: QP_Price_List_PUB.G_MISS_PRICE_LIST_VAL_REC
288: , p_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=
289: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
290: , p_PRICE_LIST_LINE_val_tbl IN QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type :=
291: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_VAL_TBL
292: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type :=
293: QP_Price_List_PUB.G_MISS_QUALIFIERS_TBL
294: , p_QUALIFIERS_val_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type :=
295: QP_Price_List_PUB.G_MISS_QUALIFIERS_VAL_TBL

Line 293: QP_Price_List_PUB.G_MISS_QUALIFIERS_TBL

289: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
290: , p_PRICE_LIST_LINE_val_tbl IN QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type :=
291: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_VAL_TBL
292: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type :=
293: QP_Price_List_PUB.G_MISS_QUALIFIERS_TBL
294: , p_QUALIFIERS_val_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type :=
295: QP_Price_List_PUB.G_MISS_QUALIFIERS_VAL_TBL
296: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=
297: QP_Price_List_PUB.G_MISS_PRICING_ATTR_TBL

Line 295: QP_Price_List_PUB.G_MISS_QUALIFIERS_VAL_TBL

291: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_VAL_TBL
292: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type :=
293: QP_Price_List_PUB.G_MISS_QUALIFIERS_TBL
294: , p_QUALIFIERS_val_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type :=
295: QP_Price_List_PUB.G_MISS_QUALIFIERS_VAL_TBL
296: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=
297: QP_Price_List_PUB.G_MISS_PRICING_ATTR_TBL
298: , p_PRICING_ATTR_val_tbl IN QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type :=
299: QP_Price_List_PUB.G_MISS_PRICING_ATTR_VAL_TBL

Line 296: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=

292: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type :=
293: QP_Price_List_PUB.G_MISS_QUALIFIERS_TBL
294: , p_QUALIFIERS_val_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type :=
295: QP_Price_List_PUB.G_MISS_QUALIFIERS_VAL_TBL
296: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=
297: QP_Price_List_PUB.G_MISS_PRICING_ATTR_TBL
298: , p_PRICING_ATTR_val_tbl IN QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type :=
299: QP_Price_List_PUB.G_MISS_PRICING_ATTR_VAL_TBL
300: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type

Line 297: QP_Price_List_PUB.G_MISS_PRICING_ATTR_TBL

293: QP_Price_List_PUB.G_MISS_QUALIFIERS_TBL
294: , p_QUALIFIERS_val_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type :=
295: QP_Price_List_PUB.G_MISS_QUALIFIERS_VAL_TBL
296: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=
297: QP_Price_List_PUB.G_MISS_PRICING_ATTR_TBL
298: , p_PRICING_ATTR_val_tbl IN QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type :=
299: QP_Price_List_PUB.G_MISS_PRICING_ATTR_VAL_TBL
300: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
301: , x_PRICE_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type

Line 298: , p_PRICING_ATTR_val_tbl IN QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type :=

294: , p_QUALIFIERS_val_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type :=
295: QP_Price_List_PUB.G_MISS_QUALIFIERS_VAL_TBL
296: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=
297: QP_Price_List_PUB.G_MISS_PRICING_ATTR_TBL
298: , p_PRICING_ATTR_val_tbl IN QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type :=
299: QP_Price_List_PUB.G_MISS_PRICING_ATTR_VAL_TBL
300: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
301: , x_PRICE_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type
302: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type

Line 299: QP_Price_List_PUB.G_MISS_PRICING_ATTR_VAL_TBL

295: QP_Price_List_PUB.G_MISS_QUALIFIERS_VAL_TBL
296: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=
297: QP_Price_List_PUB.G_MISS_PRICING_ATTR_TBL
298: , p_PRICING_ATTR_val_tbl IN QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type :=
299: QP_Price_List_PUB.G_MISS_PRICING_ATTR_VAL_TBL
300: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
301: , x_PRICE_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type
302: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
303: , x_PRICE_LIST_LINE_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type

Line 300: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type

296: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=
297: QP_Price_List_PUB.G_MISS_PRICING_ATTR_TBL
298: , p_PRICING_ATTR_val_tbl IN QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type :=
299: QP_Price_List_PUB.G_MISS_PRICING_ATTR_VAL_TBL
300: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
301: , x_PRICE_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type
302: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
303: , x_PRICE_LIST_LINE_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
304: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type

Line 301: , x_PRICE_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type

297: QP_Price_List_PUB.G_MISS_PRICING_ATTR_TBL
298: , p_PRICING_ATTR_val_tbl IN QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type :=
299: QP_Price_List_PUB.G_MISS_PRICING_ATTR_VAL_TBL
300: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
301: , x_PRICE_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type
302: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
303: , x_PRICE_LIST_LINE_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
304: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
305: , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type

Line 302: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type

298: , p_PRICING_ATTR_val_tbl IN QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type :=
299: QP_Price_List_PUB.G_MISS_PRICING_ATTR_VAL_TBL
300: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
301: , x_PRICE_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type
302: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
303: , x_PRICE_LIST_LINE_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
304: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
305: , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type
306: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type

Line 303: , x_PRICE_LIST_LINE_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type

299: QP_Price_List_PUB.G_MISS_PRICING_ATTR_VAL_TBL
300: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
301: , x_PRICE_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type
302: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
303: , x_PRICE_LIST_LINE_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
304: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
305: , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type
306: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
307: , x_PRICING_ATTR_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type

Line 306: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type

302: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
303: , x_PRICE_LIST_LINE_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
304: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
305: , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type
306: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
307: , x_PRICING_ATTR_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type
308: )
309: IS
310: l_api_version_number CONSTANT NUMBER := 1.0;

Line 307: , x_PRICING_ATTR_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type

303: , x_PRICE_LIST_LINE_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
304: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
305: , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type
306: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
307: , x_PRICING_ATTR_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type
308: )
309: IS
310: l_api_version_number CONSTANT NUMBER := 1.0;
311: l_api_name CONSTANT VARCHAR2(30):= 'Lock_Price_List';

Line 313: l_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;

309: IS
310: l_api_version_number CONSTANT NUMBER := 1.0;
311: l_api_name CONSTANT VARCHAR2(30):= 'Lock_Price_List';
312: l_return_status VARCHAR2(1);
313: l_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
314: l_p_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
315: l_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
316: l_p_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
317: l_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;

Line 314: l_p_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;

310: l_api_version_number CONSTANT NUMBER := 1.0;
311: l_api_name CONSTANT VARCHAR2(30):= 'Lock_Price_List';
312: l_return_status VARCHAR2(1);
313: l_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
314: l_p_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
315: l_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
316: l_p_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
317: l_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
318: l_p_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;

Line 315: l_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;

311: l_api_name CONSTANT VARCHAR2(30):= 'Lock_Price_List';
312: l_return_status VARCHAR2(1);
313: l_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
314: l_p_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
315: l_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
316: l_p_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
317: l_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
318: l_p_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
319: l_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;

Line 316: l_p_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;

312: l_return_status VARCHAR2(1);
313: l_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
314: l_p_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
315: l_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
316: l_p_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
317: l_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
318: l_p_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
319: l_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
320: l_p_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;

Line 319: l_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;

315: l_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
316: l_p_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
317: l_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
318: l_p_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
319: l_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
320: l_p_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
321: BEGIN
322:
323: -- Standard call to check for call compatibility

Line 320: l_p_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;

316: l_p_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
317: l_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
318: l_p_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
319: l_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
320: l_p_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
321: BEGIN
322:
323: -- Standard call to check for call compatibility
324:

Line 478: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type

474: , p_list_header_id IN NUMBER :=
475: FND_API.G_MISS_NUM
476: , p_list_header IN VARCHAR2 :=
477: FND_API.G_MISS_CHAR
478: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
479: , x_PRICE_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type
480: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
481: , x_PRICE_LIST_LINE_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
482: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type

Line 479: , x_PRICE_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type

475: FND_API.G_MISS_NUM
476: , p_list_header IN VARCHAR2 :=
477: FND_API.G_MISS_CHAR
478: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
479: , x_PRICE_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type
480: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
481: , x_PRICE_LIST_LINE_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
482: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
483: , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type

Line 480: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type

476: , p_list_header IN VARCHAR2 :=
477: FND_API.G_MISS_CHAR
478: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
479: , x_PRICE_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type
480: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
481: , x_PRICE_LIST_LINE_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
482: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
483: , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type
484: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type

Line 481: , x_PRICE_LIST_LINE_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type

477: FND_API.G_MISS_CHAR
478: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
479: , x_PRICE_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type
480: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
481: , x_PRICE_LIST_LINE_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
482: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
483: , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type
484: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
485: , x_PRICING_ATTR_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type

Line 484: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type

480: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
481: , x_PRICE_LIST_LINE_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
482: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
483: , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type
484: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
485: , x_PRICING_ATTR_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type
486: )
487: IS
488: l_api_version_number CONSTANT NUMBER := 1.0;

Line 485: , x_PRICING_ATTR_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type

481: , x_PRICE_LIST_LINE_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
482: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
483: , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type
484: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
485: , x_PRICING_ATTR_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type
486: )
487: IS
488: l_api_version_number CONSTANT NUMBER := 1.0;
489: l_api_name CONSTANT VARCHAR2(30):= 'Get_Price_List';

Line 491: l_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;

487: IS
488: l_api_version_number CONSTANT NUMBER := 1.0;
489: l_api_name CONSTANT VARCHAR2(30):= 'Get_Price_List';
490: l_list_header_id NUMBER := p_list_header_id;
491: l_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
492: l_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
493: l_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
494: l_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
495: BEGIN

Line 492: l_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;

488: l_api_version_number CONSTANT NUMBER := 1.0;
489: l_api_name CONSTANT VARCHAR2(30):= 'Get_Price_List';
490: l_list_header_id NUMBER := p_list_header_id;
491: l_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
492: l_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
493: l_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
494: l_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
495: BEGIN
496:

Line 494: l_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;

490: l_list_header_id NUMBER := p_list_header_id;
491: l_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
492: l_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
493: l_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
494: l_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
495: BEGIN
496:
497: -- Standard call to check for call compatibility
498:

Line 652: ( p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type

648:
649: -- Procedure Id_To_Value
650:
651: PROCEDURE Id_To_Value
652: ( p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type
653: , p_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type
654: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
655: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type
656: , x_PRICE_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type

Line 653: , p_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type

649: -- Procedure Id_To_Value
650:
651: PROCEDURE Id_To_Value
652: ( p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type
653: , p_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type
654: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
655: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type
656: , x_PRICE_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type
657: , x_PRICE_LIST_LINE_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type

Line 655: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type

651: PROCEDURE Id_To_Value
652: ( p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type
653: , p_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type
654: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
655: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type
656: , x_PRICE_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type
657: , x_PRICE_LIST_LINE_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
658: , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type
659: , x_PRICING_ATTR_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type

Line 656: , x_PRICE_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type

652: ( p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type
653: , p_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type
654: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
655: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type
656: , x_PRICE_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type
657: , x_PRICE_LIST_LINE_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
658: , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type
659: , x_PRICING_ATTR_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type
660: )

Line 657: , x_PRICE_LIST_LINE_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type

653: , p_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type
654: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
655: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type
656: , x_PRICE_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type
657: , x_PRICE_LIST_LINE_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
658: , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type
659: , x_PRICING_ATTR_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type
660: )
661: IS

Line 659: , x_PRICING_ATTR_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type

655: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type
656: , x_PRICE_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type
657: , x_PRICE_LIST_LINE_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
658: , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type
659: , x_PRICING_ATTR_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type
660: )
661: IS
662: BEGIN
663:

Line 710: , p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type

706: -- Procedure Value_To_Id
707:
708: PROCEDURE Value_To_Id
709: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
710: , p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type
711: , p_PRICE_LIST_val_rec IN QP_Price_List_PUB.Price_List_Val_Rec_Type
712: , p_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type
713: , p_PRICE_LIST_LINE_val_tbl IN QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
714: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type

Line 711: , p_PRICE_LIST_val_rec IN QP_Price_List_PUB.Price_List_Val_Rec_Type

707:
708: PROCEDURE Value_To_Id
709: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
710: , p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type
711: , p_PRICE_LIST_val_rec IN QP_Price_List_PUB.Price_List_Val_Rec_Type
712: , p_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type
713: , p_PRICE_LIST_LINE_val_tbl IN QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
714: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
715: , p_QUALIFIERS_val_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type

Line 712: , p_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type

708: PROCEDURE Value_To_Id
709: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
710: , p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type
711: , p_PRICE_LIST_val_rec IN QP_Price_List_PUB.Price_List_Val_Rec_Type
712: , p_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type
713: , p_PRICE_LIST_LINE_val_tbl IN QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
714: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
715: , p_QUALIFIERS_val_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type
716: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type

Line 713: , p_PRICE_LIST_LINE_val_tbl IN QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type

709: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
710: , p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type
711: , p_PRICE_LIST_val_rec IN QP_Price_List_PUB.Price_List_Val_Rec_Type
712: , p_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type
713: , p_PRICE_LIST_LINE_val_tbl IN QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
714: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
715: , p_QUALIFIERS_val_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type
716: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type
717: , p_PRICING_ATTR_val_tbl IN QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type

Line 716: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type

712: , p_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type
713: , p_PRICE_LIST_LINE_val_tbl IN QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
714: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
715: , p_QUALIFIERS_val_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type
716: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type
717: , p_PRICING_ATTR_val_tbl IN QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type
718: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
719: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
720: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type

Line 717: , p_PRICING_ATTR_val_tbl IN QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type

713: , p_PRICE_LIST_LINE_val_tbl IN QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
714: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
715: , p_QUALIFIERS_val_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type
716: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type
717: , p_PRICING_ATTR_val_tbl IN QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type
718: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
719: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
720: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
721: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type

Line 718: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type

714: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
715: , p_QUALIFIERS_val_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type
716: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type
717: , p_PRICING_ATTR_val_tbl IN QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type
718: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
719: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
720: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
721: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
722: )

Line 719: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type

715: , p_QUALIFIERS_val_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type
716: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type
717: , p_PRICING_ATTR_val_tbl IN QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type
718: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
719: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
720: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
721: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
722: )
723: IS

Line 721: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type

717: , p_PRICING_ATTR_val_tbl IN QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type
718: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
719: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
720: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
721: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
722: )
723: IS
724: l_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
725: l_PRICE_LIST_LINE_rec QP_Price_list_PUB.Price_List_Line_Rec_Type;

Line 724: l_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;

720: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
721: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
722: )
723: IS
724: l_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
725: l_PRICE_LIST_LINE_rec QP_Price_list_PUB.Price_List_Line_Rec_Type;
726: l_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
727: l_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
728: l_index BINARY_INTEGER;

Line 725: l_PRICE_LIST_LINE_rec QP_Price_list_PUB.Price_List_Line_Rec_Type;

721: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
722: )
723: IS
724: l_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
725: l_PRICE_LIST_LINE_rec QP_Price_list_PUB.Price_List_Line_Rec_Type;
726: l_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
727: l_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
728: l_index BINARY_INTEGER;
729: BEGIN

Line 727: l_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;

723: IS
724: l_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
725: l_PRICE_LIST_LINE_rec QP_Price_list_PUB.Price_List_Line_Rec_Type;
726: l_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
727: l_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
728: l_index BINARY_INTEGER;
729: BEGIN
730:
731: -- Init x_return_status.