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
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
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
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:
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
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:
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
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
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
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
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
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
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:
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
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
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 :=
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 :=
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 :=
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 :=
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
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
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
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
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
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: )
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
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;
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;
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;
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;
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]
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]
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]
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
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 :=
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
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 :=
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
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 :=
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
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
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
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
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
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
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: )
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
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;
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';
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;
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:
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;
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
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
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: )
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
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;
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';
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
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
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
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
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:
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
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
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
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
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
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
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
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
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;
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;
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;
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:
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