APPS.OE_PRICING_CONT_PUB dependencies on QP_PRICE_LIST_PUB

Line 12: , p_Price_LHeader_rec IN QP_Price_List_PUB.Price_List_Rec_Type

8: -- Forward declaration of Procedure Id_To_Value
9:
10: PROCEDURE Id_To_Value
11: ( p_Agreement_rec IN Agreement_Rec_Type
12: , p_Price_LHeader_rec IN QP_Price_List_PUB.Price_List_Rec_Type
13: , p_Price_LLine_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type
14: , p_Pricing_Attr_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type
15: , x_Agreement_val_rec OUT NOCOPY /* file.sql.39 change */ Agreement_Val_Rec_Type
16: , x_Price_LHeader_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type

Line 13: , p_Price_LLine_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type

9:
10: PROCEDURE Id_To_Value
11: ( p_Agreement_rec IN Agreement_Rec_Type
12: , p_Price_LHeader_rec IN QP_Price_List_PUB.Price_List_Rec_Type
13: , p_Price_LLine_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type
14: , p_Pricing_Attr_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type
15: , x_Agreement_val_rec OUT NOCOPY /* file.sql.39 change */ Agreement_Val_Rec_Type
16: , x_Price_LHeader_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type
17: , x_Price_LLine_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_Agreement_rec IN Agreement_Rec_Type
12: , p_Price_LHeader_rec IN QP_Price_List_PUB.Price_List_Rec_Type
13: , p_Price_LLine_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type
14: , p_Pricing_Attr_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type
15: , x_Agreement_val_rec OUT NOCOPY /* file.sql.39 change */ Agreement_Val_Rec_Type
16: , x_Price_LHeader_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type
17: , x_Price_LLine_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_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 16: , x_Price_LHeader_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type

12: , p_Price_LHeader_rec IN QP_Price_List_PUB.Price_List_Rec_Type
13: , p_Price_LLine_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type
14: , p_Pricing_Attr_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type
15: , x_Agreement_val_rec OUT NOCOPY /* file.sql.39 change */ Agreement_Val_Rec_Type
16: , x_Price_LHeader_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type
17: , x_Price_LLine_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_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 17: , x_Price_LLine_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type

13: , p_Price_LLine_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type
14: , p_Pricing_Attr_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type
15: , x_Agreement_val_rec OUT NOCOPY /* file.sql.39 change */ Agreement_Val_Rec_Type
16: , x_Price_LHeader_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type
17: , x_Price_LLine_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_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

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_Agreement_val_rec OUT NOCOPY /* file.sql.39 change */ Agreement_Val_Rec_Type
16: , x_Price_LHeader_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type
17: , x_Price_LLine_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_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 27: , p_Price_LHeader_rec IN QP_Price_List_PUB.Price_List_Rec_Type

23: PROCEDURE Value_To_Id
24: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
25: , p_Agreement_rec IN Agreement_Rec_Type
26: , p_Agreement_val_rec IN Agreement_Val_Rec_Type
27: , p_Price_LHeader_rec IN QP_Price_List_PUB.Price_List_Rec_Type
28: , p_Price_LHeader_val_rec IN QP_Price_List_PUB.Price_List_Val_Rec_Type
29: , p_Price_LLine_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type
30: , p_Price_LLine_val_tbl IN QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
31: , p_Pricing_Attr_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type

Line 28: , p_Price_LHeader_val_rec IN QP_Price_List_PUB.Price_List_Val_Rec_Type

24: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
25: , p_Agreement_rec IN Agreement_Rec_Type
26: , p_Agreement_val_rec IN Agreement_Val_Rec_Type
27: , p_Price_LHeader_rec IN QP_Price_List_PUB.Price_List_Rec_Type
28: , p_Price_LHeader_val_rec IN QP_Price_List_PUB.Price_List_Val_Rec_Type
29: , p_Price_LLine_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type
30: , p_Price_LLine_val_tbl IN QP_Price_List_PUB.Price_List_Line_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 29: , p_Price_LLine_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type

25: , p_Agreement_rec IN Agreement_Rec_Type
26: , p_Agreement_val_rec IN Agreement_Val_Rec_Type
27: , p_Price_LHeader_rec IN QP_Price_List_PUB.Price_List_Rec_Type
28: , p_Price_LHeader_val_rec IN QP_Price_List_PUB.Price_List_Val_Rec_Type
29: , p_Price_LLine_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type
30: , p_Price_LLine_val_tbl IN QP_Price_List_PUB.Price_List_Line_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_Agreement_rec OUT NOCOPY /* file.sql.39 change */ Agreement_Rec_Type

Line 30: , p_Price_LLine_val_tbl IN QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type

26: , p_Agreement_val_rec IN Agreement_Val_Rec_Type
27: , p_Price_LHeader_rec IN QP_Price_List_PUB.Price_List_Rec_Type
28: , p_Price_LHeader_val_rec IN QP_Price_List_PUB.Price_List_Val_Rec_Type
29: , p_Price_LLine_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type
30: , p_Price_LLine_val_tbl IN QP_Price_List_PUB.Price_List_Line_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_Agreement_rec OUT NOCOPY /* file.sql.39 change */ Agreement_Rec_Type
34: , x_Price_LHeader_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type

Line 31: , p_Pricing_Attr_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type

27: , p_Price_LHeader_rec IN QP_Price_List_PUB.Price_List_Rec_Type
28: , p_Price_LHeader_val_rec IN QP_Price_List_PUB.Price_List_Val_Rec_Type
29: , p_Price_LLine_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type
30: , p_Price_LLine_val_tbl IN QP_Price_List_PUB.Price_List_Line_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_Agreement_rec OUT NOCOPY /* file.sql.39 change */ Agreement_Rec_Type
34: , x_Price_LHeader_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
35: , x_Price_LLine_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type

Line 32: , p_Pricing_Attr_val_tbl IN QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type

28: , p_Price_LHeader_val_rec IN QP_Price_List_PUB.Price_List_Val_Rec_Type
29: , p_Price_LLine_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type
30: , p_Price_LLine_val_tbl IN QP_Price_List_PUB.Price_List_Line_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_Agreement_rec OUT NOCOPY /* file.sql.39 change */ Agreement_Rec_Type
34: , x_Price_LHeader_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
35: , x_Price_LLine_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
36: , x_Pricing_Attr_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type

Line 34: , x_Price_LHeader_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type

30: , p_Price_LLine_val_tbl IN QP_Price_List_PUB.Price_List_Line_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_Agreement_rec OUT NOCOPY /* file.sql.39 change */ Agreement_Rec_Type
34: , x_Price_LHeader_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
35: , x_Price_LLine_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
36: , x_Pricing_Attr_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
37: );
38:

Line 35: , x_Price_LLine_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_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_Agreement_rec OUT NOCOPY /* file.sql.39 change */ Agreement_Rec_Type
34: , x_Price_LHeader_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
35: , x_Price_LLine_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_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

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_Agreement_rec OUT NOCOPY /* file.sql.39 change */ Agreement_Rec_Type
34: , x_Price_LHeader_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
35: , x_Price_LLine_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_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_Agreement

Line 67: , p_Price_LHeader_rec IN QP_Price_List_PUB.Price_List_Rec_Type :=

63: , p_Agreement_rec IN Agreement_Rec_Type :=
64: G_MISS_AGREEMENT_REC
65: , p_Agreement_val_rec IN Agreement_Val_Rec_Type :=
66: G_MISS_AGREEMENT_VAL_REC
67: , p_Price_LHeader_rec IN QP_Price_List_PUB.Price_List_Rec_Type :=
68: G_MISS_PRICE_LIST_REC
69: , p_Price_LHeader_val_rec IN QP_Price_List_PUB.Price_List_Val_Rec_Type :=
70: G_MISS_PRICE_LIST_VAL_REC
71: , p_Price_LLine_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=

Line 69: , p_Price_LHeader_val_rec IN QP_Price_List_PUB.Price_List_Val_Rec_Type :=

65: , p_Agreement_val_rec IN Agreement_Val_Rec_Type :=
66: G_MISS_AGREEMENT_VAL_REC
67: , p_Price_LHeader_rec IN QP_Price_List_PUB.Price_List_Rec_Type :=
68: G_MISS_PRICE_LIST_REC
69: , p_Price_LHeader_val_rec IN QP_Price_List_PUB.Price_List_Val_Rec_Type :=
70: G_MISS_PRICE_LIST_VAL_REC
71: , p_Price_LLine_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=
72: G_MISS_PRICE_LIST_LINE_TBL
73: , p_Price_LLine_val_tbl IN QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type :=

Line 71: , p_Price_LLine_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=

67: , p_Price_LHeader_rec IN QP_Price_List_PUB.Price_List_Rec_Type :=
68: G_MISS_PRICE_LIST_REC
69: , p_Price_LHeader_val_rec IN QP_Price_List_PUB.Price_List_Val_Rec_Type :=
70: G_MISS_PRICE_LIST_VAL_REC
71: , p_Price_LLine_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=
72: G_MISS_PRICE_LIST_LINE_TBL
73: , p_Price_LLine_val_tbl IN QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type :=
74: G_MISS_PRICE_LIST_LINE_VAL_TBL
75: , p_Pricing_Attr_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=

Line 73: , p_Price_LLine_val_tbl IN QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type :=

69: , p_Price_LHeader_val_rec IN QP_Price_List_PUB.Price_List_Val_Rec_Type :=
70: G_MISS_PRICE_LIST_VAL_REC
71: , p_Price_LLine_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=
72: G_MISS_PRICE_LIST_LINE_TBL
73: , p_Price_LLine_val_tbl IN QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type :=
74: G_MISS_PRICE_LIST_LINE_VAL_TBL
75: , p_Pricing_Attr_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=
76: G_MISS_PRICING_ATTR_TBL
77: , p_Pricing_Attr_val_tbl IN QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type :=

Line 75: , p_Pricing_Attr_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=

71: , p_Price_LLine_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=
72: G_MISS_PRICE_LIST_LINE_TBL
73: , p_Price_LLine_val_tbl IN QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type :=
74: G_MISS_PRICE_LIST_LINE_VAL_TBL
75: , p_Pricing_Attr_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=
76: G_MISS_PRICING_ATTR_TBL
77: , p_Pricing_Attr_val_tbl IN QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type :=
78: G_MISS_PRICING_ATTR_VAL_TBL
79: , x_Agreement_rec OUT NOCOPY /* file.sql.39 change */ Agreement_Rec_Type

Line 77: , p_Pricing_Attr_val_tbl IN QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type :=

73: , p_Price_LLine_val_tbl IN QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type :=
74: G_MISS_PRICE_LIST_LINE_VAL_TBL
75: , p_Pricing_Attr_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=
76: G_MISS_PRICING_ATTR_TBL
77: , p_Pricing_Attr_val_tbl IN QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type :=
78: G_MISS_PRICING_ATTR_VAL_TBL
79: , x_Agreement_rec OUT NOCOPY /* file.sql.39 change */ Agreement_Rec_Type
80: , x_Agreement_val_rec OUT NOCOPY /* file.sql.39 change */ Agreement_Val_Rec_Type
81: , x_Price_LHeader_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type

Line 81: , x_Price_LHeader_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type

77: , p_Pricing_Attr_val_tbl IN QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type :=
78: G_MISS_PRICING_ATTR_VAL_TBL
79: , x_Agreement_rec OUT NOCOPY /* file.sql.39 change */ Agreement_Rec_Type
80: , x_Agreement_val_rec OUT NOCOPY /* file.sql.39 change */ Agreement_Val_Rec_Type
81: , x_Price_LHeader_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
82: , x_Price_LHeader_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type
83: , x_Price_LLine_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
84: , x_Price_LLine_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_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_LHeader_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type

78: G_MISS_PRICING_ATTR_VAL_TBL
79: , x_Agreement_rec OUT NOCOPY /* file.sql.39 change */ Agreement_Rec_Type
80: , x_Agreement_val_rec OUT NOCOPY /* file.sql.39 change */ Agreement_Val_Rec_Type
81: , x_Price_LHeader_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
82: , x_Price_LHeader_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type
83: , x_Price_LLine_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
84: , x_Price_LLine_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_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 83: , x_Price_LLine_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type

79: , x_Agreement_rec OUT NOCOPY /* file.sql.39 change */ Agreement_Rec_Type
80: , x_Agreement_val_rec OUT NOCOPY /* file.sql.39 change */ Agreement_Val_Rec_Type
81: , x_Price_LHeader_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
82: , x_Price_LHeader_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type
83: , x_Price_LLine_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
84: , x_Price_LLine_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_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: , p_check_duplicate_lines IN VARCHAR2 DEFAULT NULL --5024919, 5018856, 5024801

Line 84: , x_Price_LLine_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type

80: , x_Agreement_val_rec OUT NOCOPY /* file.sql.39 change */ Agreement_Val_Rec_Type
81: , x_Price_LHeader_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
82: , x_Price_LHeader_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type
83: , x_Price_LLine_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
84: , x_Price_LLine_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_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: , p_check_duplicate_lines IN VARCHAR2 DEFAULT NULL --5024919, 5018856, 5024801
88: )

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

81: , x_Price_LHeader_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
82: , x_Price_LHeader_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type
83: , x_Price_LLine_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
84: , x_Price_LLine_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_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: , p_check_duplicate_lines IN VARCHAR2 DEFAULT NULL --5024919, 5018856, 5024801
88: )
89: IS

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_LHeader_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type
83: , x_Price_LLine_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
84: , x_Price_LLine_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_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: , p_check_duplicate_lines IN VARCHAR2 DEFAULT NULL --5024919, 5018856, 5024801
88: )
89: IS
90: l_api_version_number CONSTANT NUMBER := 1.0;

Line 97: l_Price_LHeader_rec QP_Price_List_PUB.Price_List_Rec_Type;

93: l_control_rec_dummy OE_GLOBALS.Control_Rec_Type;
94:
95: l_return_status VARCHAR2(1);
96: l_Agreement_rec Agreement_Rec_Type;
97: l_Price_LHeader_rec QP_Price_List_PUB.Price_List_Rec_Type;
98: l_Price_LHeader_rec_dummy OE_Price_List_PUB.Price_List_Rec_Type;
99: l_Price_LLine_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
100: l_Price_LLine_tbl_dummy OE_Price_List_PUB.Price_List_Line_Tbl_Type;
101: l_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;

Line 99: l_Price_LLine_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;

95: l_return_status VARCHAR2(1);
96: l_Agreement_rec Agreement_Rec_Type;
97: l_Price_LHeader_rec QP_Price_List_PUB.Price_List_Rec_Type;
98: l_Price_LHeader_rec_dummy OE_Price_List_PUB.Price_List_Rec_Type;
99: l_Price_LLine_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
100: l_Price_LLine_tbl_dummy OE_Price_List_PUB.Price_List_Line_Tbl_Type;
101: l_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
102: x_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type; --4949185, 5530054
103: l_Pricing_Attr_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;

Line 103: l_Pricing_Attr_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;

99: l_Price_LLine_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
100: l_Price_LLine_tbl_dummy OE_Price_List_PUB.Price_List_Line_Tbl_Type;
101: l_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
102: x_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type; --4949185, 5530054
103: l_Pricing_Attr_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
104: l_installed_status VARCHAR2(1);
105:
106: l_Contract_rec Contract_Rec_Type;
107: l_Discount_Header_rec Discount_Header_Rec_Type;

Line 112: l_p_Price_LHeader_rec QP_Price_List_PUB.Price_List_Rec_Type;--[prarasto]

108: l_Discount_Cust_tbl Discount_Cust_Tbl_Type;
109: l_Discount_Line_tbl Discount_Line_Tbl_Type;
110: l_Price_Break_tbl Price_Break_Tbl_Type;
111:
112: l_p_Price_LHeader_rec QP_Price_List_PUB.Price_List_Rec_Type;--[prarasto]
113: l_p_Price_LLine_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type; --[prarasto]
114: l_p_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type; --[prarasto]
115: l_p_Pricing_Attr_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type; --[prarasto]
116: l_p_Contract_rec Contract_Rec_Type; --[prarasto]

Line 113: l_p_Price_LLine_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type; --[prarasto]

109: l_Discount_Line_tbl Discount_Line_Tbl_Type;
110: l_Price_Break_tbl Price_Break_Tbl_Type;
111:
112: l_p_Price_LHeader_rec QP_Price_List_PUB.Price_List_Rec_Type;--[prarasto]
113: l_p_Price_LLine_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type; --[prarasto]
114: l_p_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type; --[prarasto]
115: l_p_Pricing_Attr_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type; --[prarasto]
116: l_p_Contract_rec Contract_Rec_Type; --[prarasto]
117: l_p_Agreement_rec Agreement_Rec_Type; --[prarasto]

Line 115: l_p_Pricing_Attr_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type; --[prarasto]

111:
112: l_p_Price_LHeader_rec QP_Price_List_PUB.Price_List_Rec_Type;--[prarasto]
113: l_p_Price_LLine_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type; --[prarasto]
114: l_p_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type; --[prarasto]
115: l_p_Pricing_Attr_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type; --[prarasto]
116: l_p_Contract_rec Contract_Rec_Type; --[prarasto]
117: l_p_Agreement_rec Agreement_Rec_Type; --[prarasto]
118: l_p_Price_LHeader_rec_dummy OE_Price_List_PUB.Price_List_Rec_Type; --[prarasto]
119: l_p_Discount_Header_rec Discount_Header_Rec_Type; --[prarasto]

Line 418: , p_Price_LHeader_rec IN QP_Price_List_PUB.Price_List_Rec_Type :=

414: , p_Agreement_rec IN Agreement_Rec_Type :=
415: G_MISS_AGREEMENT_REC
416: , p_Agreement_val_rec IN Agreement_Val_Rec_Type :=
417: G_MISS_AGREEMENT_VAL_REC
418: , p_Price_LHeader_rec IN QP_Price_List_PUB.Price_List_Rec_Type :=
419: G_MISS_PRICE_List_REC
420: -- QP_Price_List_PUB.G_MISS_PRICE_List_REC --2449157
421: , p_Price_LHeader_val_rec IN QP_Price_List_PUB.Price_List_Val_Rec_Type :=
422: G_MISS_PRICE_List_VAL_REC

Line 420: -- QP_Price_List_PUB.G_MISS_PRICE_List_REC --2449157

416: , p_Agreement_val_rec IN Agreement_Val_Rec_Type :=
417: G_MISS_AGREEMENT_VAL_REC
418: , p_Price_LHeader_rec IN QP_Price_List_PUB.Price_List_Rec_Type :=
419: G_MISS_PRICE_List_REC
420: -- QP_Price_List_PUB.G_MISS_PRICE_List_REC --2449157
421: , p_Price_LHeader_val_rec IN QP_Price_List_PUB.Price_List_Val_Rec_Type :=
422: G_MISS_PRICE_List_VAL_REC
423: -- QP_Price_List_PUB.G_MISS_PRICE_List_VAL_REC --2449157
424: , p_Price_LLine_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=

Line 421: , p_Price_LHeader_val_rec IN QP_Price_List_PUB.Price_List_Val_Rec_Type :=

417: G_MISS_AGREEMENT_VAL_REC
418: , p_Price_LHeader_rec IN QP_Price_List_PUB.Price_List_Rec_Type :=
419: G_MISS_PRICE_List_REC
420: -- QP_Price_List_PUB.G_MISS_PRICE_List_REC --2449157
421: , p_Price_LHeader_val_rec IN QP_Price_List_PUB.Price_List_Val_Rec_Type :=
422: G_MISS_PRICE_List_VAL_REC
423: -- QP_Price_List_PUB.G_MISS_PRICE_List_VAL_REC --2449157
424: , p_Price_LLine_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=
425: G_MISS_PRICE_List_Line_TBL

Line 423: -- QP_Price_List_PUB.G_MISS_PRICE_List_VAL_REC --2449157

419: G_MISS_PRICE_List_REC
420: -- QP_Price_List_PUB.G_MISS_PRICE_List_REC --2449157
421: , p_Price_LHeader_val_rec IN QP_Price_List_PUB.Price_List_Val_Rec_Type :=
422: G_MISS_PRICE_List_VAL_REC
423: -- QP_Price_List_PUB.G_MISS_PRICE_List_VAL_REC --2449157
424: , p_Price_LLine_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=
425: G_MISS_PRICE_List_Line_TBL
426: -- QP_Price_List_PUB.G_MISS_PRICE_List_Line_TBL --2449157
427: , p_Price_LLine_val_tbl IN QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type :=

Line 424: , p_Price_LLine_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=

420: -- QP_Price_List_PUB.G_MISS_PRICE_List_REC --2449157
421: , p_Price_LHeader_val_rec IN QP_Price_List_PUB.Price_List_Val_Rec_Type :=
422: G_MISS_PRICE_List_VAL_REC
423: -- QP_Price_List_PUB.G_MISS_PRICE_List_VAL_REC --2449157
424: , p_Price_LLine_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=
425: G_MISS_PRICE_List_Line_TBL
426: -- QP_Price_List_PUB.G_MISS_PRICE_List_Line_TBL --2449157
427: , p_Price_LLine_val_tbl IN QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type :=
428: G_MISS_PRICE_List_Line_VAL_TBL

Line 426: -- QP_Price_List_PUB.G_MISS_PRICE_List_Line_TBL --2449157

422: G_MISS_PRICE_List_VAL_REC
423: -- QP_Price_List_PUB.G_MISS_PRICE_List_VAL_REC --2449157
424: , p_Price_LLine_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=
425: G_MISS_PRICE_List_Line_TBL
426: -- QP_Price_List_PUB.G_MISS_PRICE_List_Line_TBL --2449157
427: , p_Price_LLine_val_tbl IN QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type :=
428: G_MISS_PRICE_List_Line_VAL_TBL
429: -- QP_Price_List_PUB.G_MISS_PRICE_List_Line_VAL_TBL --2449157
430: , p_Pricing_Attr_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=

Line 427: , p_Price_LLine_val_tbl IN QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type :=

423: -- QP_Price_List_PUB.G_MISS_PRICE_List_VAL_REC --2449157
424: , p_Price_LLine_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=
425: G_MISS_PRICE_List_Line_TBL
426: -- QP_Price_List_PUB.G_MISS_PRICE_List_Line_TBL --2449157
427: , p_Price_LLine_val_tbl IN QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type :=
428: G_MISS_PRICE_List_Line_VAL_TBL
429: -- QP_Price_List_PUB.G_MISS_PRICE_List_Line_VAL_TBL --2449157
430: , p_Pricing_Attr_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=
431: G_MISS_PRICING_ATTR_TBL

Line 429: -- QP_Price_List_PUB.G_MISS_PRICE_List_Line_VAL_TBL --2449157

425: G_MISS_PRICE_List_Line_TBL
426: -- QP_Price_List_PUB.G_MISS_PRICE_List_Line_TBL --2449157
427: , p_Price_LLine_val_tbl IN QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type :=
428: G_MISS_PRICE_List_Line_VAL_TBL
429: -- QP_Price_List_PUB.G_MISS_PRICE_List_Line_VAL_TBL --2449157
430: , p_Pricing_Attr_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=
431: G_MISS_PRICING_ATTR_TBL
432: , p_Pricing_Attr_val_tbl IN QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type :=
433: G_MISS_PRICING_ATTR_VAL_TBL

Line 430: , p_Pricing_Attr_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=

426: -- QP_Price_List_PUB.G_MISS_PRICE_List_Line_TBL --2449157
427: , p_Price_LLine_val_tbl IN QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type :=
428: G_MISS_PRICE_List_Line_VAL_TBL
429: -- QP_Price_List_PUB.G_MISS_PRICE_List_Line_VAL_TBL --2449157
430: , p_Pricing_Attr_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=
431: G_MISS_PRICING_ATTR_TBL
432: , p_Pricing_Attr_val_tbl IN QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type :=
433: G_MISS_PRICING_ATTR_VAL_TBL
434: , x_Agreement_rec OUT NOCOPY /* file.sql.39 change */ Agreement_Rec_Type

Line 432: , p_Pricing_Attr_val_tbl IN QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type :=

428: G_MISS_PRICE_List_Line_VAL_TBL
429: -- QP_Price_List_PUB.G_MISS_PRICE_List_Line_VAL_TBL --2449157
430: , p_Pricing_Attr_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=
431: G_MISS_PRICING_ATTR_TBL
432: , p_Pricing_Attr_val_tbl IN QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type :=
433: G_MISS_PRICING_ATTR_VAL_TBL
434: , x_Agreement_rec OUT NOCOPY /* file.sql.39 change */ Agreement_Rec_Type
435: , x_Agreement_val_rec OUT NOCOPY /* file.sql.39 change */ Agreement_Val_Rec_Type
436: , x_Price_LHeader_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type

Line 436: , x_Price_LHeader_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type

432: , p_Pricing_Attr_val_tbl IN QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type :=
433: G_MISS_PRICING_ATTR_VAL_TBL
434: , x_Agreement_rec OUT NOCOPY /* file.sql.39 change */ Agreement_Rec_Type
435: , x_Agreement_val_rec OUT NOCOPY /* file.sql.39 change */ Agreement_Val_Rec_Type
436: , x_Price_LHeader_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
437: , x_Price_LHeader_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type
438: , x_Price_LLine_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
439: , x_Price_LLine_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
440: , x_Pricing_Attr_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type

Line 437: , x_Price_LHeader_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type

433: G_MISS_PRICING_ATTR_VAL_TBL
434: , x_Agreement_rec OUT NOCOPY /* file.sql.39 change */ Agreement_Rec_Type
435: , x_Agreement_val_rec OUT NOCOPY /* file.sql.39 change */ Agreement_Val_Rec_Type
436: , x_Price_LHeader_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
437: , x_Price_LHeader_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type
438: , x_Price_LLine_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
439: , x_Price_LLine_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
440: , x_Pricing_Attr_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
441: , x_Pricing_Attr_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type

Line 438: , x_Price_LLine_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type

434: , x_Agreement_rec OUT NOCOPY /* file.sql.39 change */ Agreement_Rec_Type
435: , x_Agreement_val_rec OUT NOCOPY /* file.sql.39 change */ Agreement_Val_Rec_Type
436: , x_Price_LHeader_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
437: , x_Price_LHeader_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type
438: , x_Price_LLine_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
439: , x_Price_LLine_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
440: , x_Pricing_Attr_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
441: , x_Pricing_Attr_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type
442: )

Line 439: , x_Price_LLine_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type

435: , x_Agreement_val_rec OUT NOCOPY /* file.sql.39 change */ Agreement_Val_Rec_Type
436: , x_Price_LHeader_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
437: , x_Price_LHeader_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type
438: , x_Price_LLine_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
439: , x_Price_LLine_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
440: , x_Pricing_Attr_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
441: , x_Pricing_Attr_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type
442: )
443: IS

Line 440: , x_Pricing_Attr_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type

436: , x_Price_LHeader_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
437: , x_Price_LHeader_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type
438: , x_Price_LLine_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
439: , x_Price_LLine_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
440: , x_Pricing_Attr_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
441: , x_Pricing_Attr_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type
442: )
443: IS
444: l_api_version_number CONSTANT NUMBER := 1.0;

Line 441: , x_Pricing_Attr_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type

437: , x_Price_LHeader_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type
438: , x_Price_LLine_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
439: , x_Price_LLine_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
440: , x_Pricing_Attr_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
441: , x_Pricing_Attr_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type
442: )
443: IS
444: l_api_version_number CONSTANT NUMBER := 1.0;
445: l_api_name CONSTANT VARCHAR2(30):= 'Lock_Agreement';

Line 448: l_Price_LHeader_rec QP_Price_List_PUB.Price_List_Rec_Type;

444: l_api_version_number CONSTANT NUMBER := 1.0;
445: l_api_name CONSTANT VARCHAR2(30):= 'Lock_Agreement';
446: l_return_status VARCHAR2(1);
447: l_Agreement_rec Agreement_Rec_Type;
448: l_Price_LHeader_rec QP_Price_List_PUB.Price_List_Rec_Type;
449: l_Price_LHeader_rec_dummy OE_Price_List_PUB.Price_List_Rec_Type;
450: l_Price_LLine_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
451: l_Price_LLine_tbl_dummy OE_Price_List_PUB.Price_List_Line_Tbl_Type;
452: l_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;

Line 450: l_Price_LLine_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;

446: l_return_status VARCHAR2(1);
447: l_Agreement_rec Agreement_Rec_Type;
448: l_Price_LHeader_rec QP_Price_List_PUB.Price_List_Rec_Type;
449: l_Price_LHeader_rec_dummy OE_Price_List_PUB.Price_List_Rec_Type;
450: l_Price_LLine_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
451: l_Price_LLine_tbl_dummy OE_Price_List_PUB.Price_List_Line_Tbl_Type;
452: l_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
453: l_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
454:

Line 453: l_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;

449: l_Price_LHeader_rec_dummy OE_Price_List_PUB.Price_List_Rec_Type;
450: l_Price_LLine_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
451: l_Price_LLine_tbl_dummy OE_Price_List_PUB.Price_List_Line_Tbl_Type;
452: l_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
453: l_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
454:
455: l_Contract_rec Contract_Rec_Type;
456: l_Discount_Header_rec Discount_Header_Rec_Type;
457: l_Discount_Cust_tbl OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type;

Line 661: , x_Price_LHeader_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type

657: /*, p_agreement IN VARCHAR2 := FND_API.G_MISS_CHAR
658: , p_revision IN VARCHAR2 := FND_API.G_MISS_CHAR */
659: , x_Agreement_rec OUT NOCOPY /* file.sql.39 change */ Agreement_Rec_Type
660: , x_Agreement_val_rec OUT NOCOPY /* file.sql.39 change */ Agreement_Val_Rec_Type
661: , x_Price_LHeader_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
662: , x_Price_LHeader_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type
663: , x_Price_LLine_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
664: , x_Price_LLine_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
665: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type

Line 662: , x_Price_LHeader_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type

658: , p_revision IN VARCHAR2 := FND_API.G_MISS_CHAR */
659: , x_Agreement_rec OUT NOCOPY /* file.sql.39 change */ Agreement_Rec_Type
660: , x_Agreement_val_rec OUT NOCOPY /* file.sql.39 change */ Agreement_Val_Rec_Type
661: , x_Price_LHeader_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
662: , x_Price_LHeader_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type
663: , x_Price_LLine_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
664: , x_Price_LLine_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
665: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
666: , x_Pricing_Attr_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type

Line 663: , x_Price_LLine_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type

659: , x_Agreement_rec OUT NOCOPY /* file.sql.39 change */ Agreement_Rec_Type
660: , x_Agreement_val_rec OUT NOCOPY /* file.sql.39 change */ Agreement_Val_Rec_Type
661: , x_Price_LHeader_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
662: , x_Price_LHeader_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type
663: , x_Price_LLine_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
664: , x_Price_LLine_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
665: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
666: , x_Pricing_Attr_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type
667: )

Line 664: , x_Price_LLine_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type

660: , x_Agreement_val_rec OUT NOCOPY /* file.sql.39 change */ Agreement_Val_Rec_Type
661: , x_Price_LHeader_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
662: , x_Price_LHeader_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type
663: , x_Price_LLine_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
664: , x_Price_LLine_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
665: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
666: , x_Pricing_Attr_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type
667: )
668: IS

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

661: , x_Price_LHeader_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
662: , x_Price_LHeader_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type
663: , x_Price_LLine_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
664: , x_Price_LLine_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
665: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
666: , x_Pricing_Attr_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type
667: )
668: IS
669: l_api_version_number CONSTANT NUMBER := 1.0;

Line 666: , x_Pricing_Attr_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type

662: , x_Price_LHeader_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type
663: , x_Price_LLine_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
664: , x_Price_LLine_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
665: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
666: , x_Pricing_Attr_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type
667: )
668: IS
669: l_api_version_number CONSTANT NUMBER := 1.0;
670: l_api_name CONSTANT VARCHAR2(30):= 'Get_Agreement';

Line 808: , p_Price_LHeader_rec IN QP_Price_List_PUB.Price_List_Rec_Type

804: -- Procedure Id_To_Value
805:
806: PROCEDURE Id_To_Value
807: ( p_Agreement_rec IN Agreement_Rec_Type
808: , p_Price_LHeader_rec IN QP_Price_List_PUB.Price_List_Rec_Type
809: , p_Price_LLine_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type
810: , p_Pricing_Attr_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type
811: , x_Agreement_val_rec OUT NOCOPY /* file.sql.39 change */ Agreement_Val_Rec_Type
812: , x_Price_LHeader_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type

Line 809: , p_Price_LLine_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type

805:
806: PROCEDURE Id_To_Value
807: ( p_Agreement_rec IN Agreement_Rec_Type
808: , p_Price_LHeader_rec IN QP_Price_List_PUB.Price_List_Rec_Type
809: , p_Price_LLine_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type
810: , p_Pricing_Attr_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type
811: , x_Agreement_val_rec OUT NOCOPY /* file.sql.39 change */ Agreement_Val_Rec_Type
812: , x_Price_LHeader_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type
813: , x_Price_LLine_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type

Line 810: , p_Pricing_Attr_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type

806: PROCEDURE Id_To_Value
807: ( p_Agreement_rec IN Agreement_Rec_Type
808: , p_Price_LHeader_rec IN QP_Price_List_PUB.Price_List_Rec_Type
809: , p_Price_LLine_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type
810: , p_Pricing_Attr_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type
811: , x_Agreement_val_rec OUT NOCOPY /* file.sql.39 change */ Agreement_Val_Rec_Type
812: , x_Price_LHeader_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type
813: , x_Price_LLine_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
814: , x_Pricing_Attr_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type

Line 812: , x_Price_LHeader_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type

808: , p_Price_LHeader_rec IN QP_Price_List_PUB.Price_List_Rec_Type
809: , p_Price_LLine_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type
810: , p_Pricing_Attr_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type
811: , x_Agreement_val_rec OUT NOCOPY /* file.sql.39 change */ Agreement_Val_Rec_Type
812: , x_Price_LHeader_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type
813: , x_Price_LLine_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
814: , x_Pricing_Attr_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type
815: )
816: IS

Line 813: , x_Price_LLine_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type

809: , p_Price_LLine_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type
810: , p_Pricing_Attr_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type
811: , x_Agreement_val_rec OUT NOCOPY /* file.sql.39 change */ Agreement_Val_Rec_Type
812: , x_Price_LHeader_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type
813: , x_Price_LLine_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
814: , x_Pricing_Attr_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type
815: )
816: IS
817:

Line 814: , x_Pricing_Attr_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type

810: , p_Pricing_Attr_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type
811: , x_Agreement_val_rec OUT NOCOPY /* file.sql.39 change */ Agreement_Val_Rec_Type
812: , x_Price_LHeader_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type
813: , x_Price_LLine_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
814: , x_Pricing_Attr_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type
815: )
816: IS
817:
818: BEGIN

Line 866: , p_Price_LHeader_rec IN QP_Price_List_PUB.Price_List_Rec_Type

862: PROCEDURE Value_To_Id
863: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
864: , p_Agreement_rec IN Agreement_Rec_Type
865: , p_Agreement_val_rec IN Agreement_Val_Rec_Type
866: , p_Price_LHeader_rec IN QP_Price_List_PUB.Price_List_Rec_Type
867: , p_Price_LHeader_val_rec IN QP_Price_List_PUB.Price_List_Val_Rec_Type
868: , p_Price_LLine_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type
869: , p_Price_LLine_val_tbl IN QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
870: , p_Pricing_Attr_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type

Line 867: , p_Price_LHeader_val_rec IN QP_Price_List_PUB.Price_List_Val_Rec_Type

863: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
864: , p_Agreement_rec IN Agreement_Rec_Type
865: , p_Agreement_val_rec IN Agreement_Val_Rec_Type
866: , p_Price_LHeader_rec IN QP_Price_List_PUB.Price_List_Rec_Type
867: , p_Price_LHeader_val_rec IN QP_Price_List_PUB.Price_List_Val_Rec_Type
868: , p_Price_LLine_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type
869: , p_Price_LLine_val_tbl IN QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
870: , p_Pricing_Attr_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type
871: , p_Pricing_Attr_val_tbl IN QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type

Line 868: , p_Price_LLine_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type

864: , p_Agreement_rec IN Agreement_Rec_Type
865: , p_Agreement_val_rec IN Agreement_Val_Rec_Type
866: , p_Price_LHeader_rec IN QP_Price_List_PUB.Price_List_Rec_Type
867: , p_Price_LHeader_val_rec IN QP_Price_List_PUB.Price_List_Val_Rec_Type
868: , p_Price_LLine_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type
869: , p_Price_LLine_val_tbl IN QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
870: , p_Pricing_Attr_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type
871: , p_Pricing_Attr_val_tbl IN QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type
872: , x_Agreement_rec OUT NOCOPY /* file.sql.39 change */ Agreement_Rec_Type

Line 869: , p_Price_LLine_val_tbl IN QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type

865: , p_Agreement_val_rec IN Agreement_Val_Rec_Type
866: , p_Price_LHeader_rec IN QP_Price_List_PUB.Price_List_Rec_Type
867: , p_Price_LHeader_val_rec IN QP_Price_List_PUB.Price_List_Val_Rec_Type
868: , p_Price_LLine_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type
869: , p_Price_LLine_val_tbl IN QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
870: , p_Pricing_Attr_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type
871: , p_Pricing_Attr_val_tbl IN QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type
872: , x_Agreement_rec OUT NOCOPY /* file.sql.39 change */ Agreement_Rec_Type
873: , x_Price_LHeader_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type

Line 870: , p_Pricing_Attr_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type

866: , p_Price_LHeader_rec IN QP_Price_List_PUB.Price_List_Rec_Type
867: , p_Price_LHeader_val_rec IN QP_Price_List_PUB.Price_List_Val_Rec_Type
868: , p_Price_LLine_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type
869: , p_Price_LLine_val_tbl IN QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
870: , p_Pricing_Attr_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type
871: , p_Pricing_Attr_val_tbl IN QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type
872: , x_Agreement_rec OUT NOCOPY /* file.sql.39 change */ Agreement_Rec_Type
873: , x_Price_LHeader_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
874: , x_Price_LLine_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type

Line 871: , p_Pricing_Attr_val_tbl IN QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type

867: , p_Price_LHeader_val_rec IN QP_Price_List_PUB.Price_List_Val_Rec_Type
868: , p_Price_LLine_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type
869: , p_Price_LLine_val_tbl IN QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
870: , p_Pricing_Attr_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type
871: , p_Pricing_Attr_val_tbl IN QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type
872: , x_Agreement_rec OUT NOCOPY /* file.sql.39 change */ Agreement_Rec_Type
873: , x_Price_LHeader_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
874: , x_Price_LLine_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
875: , x_Pricing_Attr_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type

Line 873: , x_Price_LHeader_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type

869: , p_Price_LLine_val_tbl IN QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
870: , p_Pricing_Attr_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type
871: , p_Pricing_Attr_val_tbl IN QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type
872: , x_Agreement_rec OUT NOCOPY /* file.sql.39 change */ Agreement_Rec_Type
873: , x_Price_LHeader_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
874: , x_Price_LLine_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
875: , x_Pricing_Attr_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
876: )
877: IS

Line 874: , x_Price_LLine_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type

870: , p_Pricing_Attr_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type
871: , p_Pricing_Attr_val_tbl IN QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type
872: , x_Agreement_rec OUT NOCOPY /* file.sql.39 change */ Agreement_Rec_Type
873: , x_Price_LHeader_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
874: , x_Price_LLine_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
875: , x_Pricing_Attr_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
876: )
877: IS
878: l_Agreement_rec Agreement_Rec_Type;

Line 875: , x_Pricing_Attr_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type

871: , p_Pricing_Attr_val_tbl IN QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type
872: , x_Agreement_rec OUT NOCOPY /* file.sql.39 change */ Agreement_Rec_Type
873: , x_Price_LHeader_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
874: , x_Price_LLine_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
875: , x_Pricing_Attr_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
876: )
877: IS
878: l_Agreement_rec Agreement_Rec_Type;
879: l_Price_LHeader_rec QP_Price_List_PUB.Price_List_Rec_Type;

Line 879: l_Price_LHeader_rec QP_Price_List_PUB.Price_List_Rec_Type;

875: , x_Pricing_Attr_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
876: )
877: IS
878: l_Agreement_rec Agreement_Rec_Type;
879: l_Price_LHeader_rec QP_Price_List_PUB.Price_List_Rec_Type;
880: l_Price_LLine_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
881: l_Pricing_Attr_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
882:
883: l_index BINARY_INTEGER;

Line 880: l_Price_LLine_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;

876: )
877: IS
878: l_Agreement_rec Agreement_Rec_Type;
879: l_Price_LHeader_rec QP_Price_List_PUB.Price_List_Rec_Type;
880: l_Price_LLine_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
881: l_Pricing_Attr_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
882:
883: l_index BINARY_INTEGER;
884:

Line 881: l_Pricing_Attr_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;

877: IS
878: l_Agreement_rec Agreement_Rec_Type;
879: l_Price_LHeader_rec QP_Price_List_PUB.Price_List_Rec_Type;
880: l_Price_LLine_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
881: l_Pricing_Attr_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
882:
883: l_index BINARY_INTEGER;
884:
885: BEGIN