DBA Data[Home] [Help]

APPS.OE_PRICING_CONT_PVT dependencies on OE_PRICE_LIST_PUB

Line 38: , p_Price_LHeader_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=

34: , p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type :=
35: OE_Pricing_Cont_PUB.G_MISS_AGREEMENT_REC
36: , p_old_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type :=
37: OE_Pricing_Cont_PUB.G_MISS_AGREEMENT_REC
38: , p_Price_LHeader_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=
39: OE_Price_List_PUB.G_MISS_PRICE_List_REC
40: , p_old_Price_LHeader_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=
41: OE_Price_List_PUB.G_MISS_PRICE_List_REC
42: , p_Discount_Header_rec IN OE_Pricing_Cont_PUB.Discount_Header_Rec_Type :=

Line 39: OE_Price_List_PUB.G_MISS_PRICE_List_REC

35: OE_Pricing_Cont_PUB.G_MISS_AGREEMENT_REC
36: , p_old_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type :=
37: OE_Pricing_Cont_PUB.G_MISS_AGREEMENT_REC
38: , p_Price_LHeader_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=
39: OE_Price_List_PUB.G_MISS_PRICE_List_REC
40: , p_old_Price_LHeader_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=
41: OE_Price_List_PUB.G_MISS_PRICE_List_REC
42: , p_Discount_Header_rec IN OE_Pricing_Cont_PUB.Discount_Header_Rec_Type :=
43: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_HEADER_REC

Line 40: , p_old_Price_LHeader_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=

36: , p_old_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type :=
37: OE_Pricing_Cont_PUB.G_MISS_AGREEMENT_REC
38: , p_Price_LHeader_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=
39: OE_Price_List_PUB.G_MISS_PRICE_List_REC
40: , p_old_Price_LHeader_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=
41: OE_Price_List_PUB.G_MISS_PRICE_List_REC
42: , p_Discount_Header_rec IN OE_Pricing_Cont_PUB.Discount_Header_Rec_Type :=
43: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_HEADER_REC
44: , p_old_Discount_Header_rec IN OE_Pricing_Cont_PUB.Discount_Header_Rec_Type :=

Line 41: OE_Price_List_PUB.G_MISS_PRICE_List_REC

37: OE_Pricing_Cont_PUB.G_MISS_AGREEMENT_REC
38: , p_Price_LHeader_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=
39: OE_Price_List_PUB.G_MISS_PRICE_List_REC
40: , p_old_Price_LHeader_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=
41: OE_Price_List_PUB.G_MISS_PRICE_List_REC
42: , p_Discount_Header_rec IN OE_Pricing_Cont_PUB.Discount_Header_Rec_Type :=
43: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_HEADER_REC
44: , p_old_Discount_Header_rec IN OE_Pricing_Cont_PUB.Discount_Header_Rec_Type :=
45: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_HEADER_REC

Line 46: , p_Price_LLine_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type :=

42: , p_Discount_Header_rec IN OE_Pricing_Cont_PUB.Discount_Header_Rec_Type :=
43: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_HEADER_REC
44: , p_old_Discount_Header_rec IN OE_Pricing_Cont_PUB.Discount_Header_Rec_Type :=
45: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_HEADER_REC
46: , p_Price_LLine_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type :=
47: OE_Price_List_PUB.G_MISS_PRICE_List_Line_TBL
48: , p_old_Price_LLine_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type :=
49: OE_Price_List_PUB.G_MISS_PRICE_List_Line_TBL
50: , p_Discount_Cust_tbl IN OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type :=

Line 47: OE_Price_List_PUB.G_MISS_PRICE_List_Line_TBL

43: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_HEADER_REC
44: , p_old_Discount_Header_rec IN OE_Pricing_Cont_PUB.Discount_Header_Rec_Type :=
45: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_HEADER_REC
46: , p_Price_LLine_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type :=
47: OE_Price_List_PUB.G_MISS_PRICE_List_Line_TBL
48: , p_old_Price_LLine_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type :=
49: OE_Price_List_PUB.G_MISS_PRICE_List_Line_TBL
50: , p_Discount_Cust_tbl IN OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type :=
51: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_CUST_TBL

Line 48: , p_old_Price_LLine_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type :=

44: , p_old_Discount_Header_rec IN OE_Pricing_Cont_PUB.Discount_Header_Rec_Type :=
45: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_HEADER_REC
46: , p_Price_LLine_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type :=
47: OE_Price_List_PUB.G_MISS_PRICE_List_Line_TBL
48: , p_old_Price_LLine_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type :=
49: OE_Price_List_PUB.G_MISS_PRICE_List_Line_TBL
50: , p_Discount_Cust_tbl IN OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type :=
51: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_CUST_TBL
52: , p_old_Discount_Cust_tbl IN OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type :=

Line 49: OE_Price_List_PUB.G_MISS_PRICE_List_Line_TBL

45: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_HEADER_REC
46: , p_Price_LLine_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type :=
47: OE_Price_List_PUB.G_MISS_PRICE_List_Line_TBL
48: , p_old_Price_LLine_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type :=
49: OE_Price_List_PUB.G_MISS_PRICE_List_Line_TBL
50: , p_Discount_Cust_tbl IN OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type :=
51: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_CUST_TBL
52: , p_old_Discount_Cust_tbl IN OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type :=
53: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_CUST_TBL

Line 64: , x_Price_LHeader_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type

60: , p_old_Price_Break_tbl IN OE_Pricing_Cont_PUB.Price_Break_Tbl_Type :=
61: OE_Pricing_Cont_PUB.G_MISS_PRICE_BREAK_TBL
62: , x_Contract_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Contract_Rec_Type
63: , x_Agreement_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Agreement_Rec_Type
64: , x_Price_LHeader_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type
65: , x_Discount_Header_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Discount_Header_Rec_Type
66: , x_Price_LLine_tbl OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Tbl_Type
67: , x_Discount_Cust_tbl OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type
68: , x_Discount_Line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type

Line 66: , x_Price_LLine_tbl OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Tbl_Type

62: , x_Contract_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Contract_Rec_Type
63: , x_Agreement_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Agreement_Rec_Type
64: , x_Price_LHeader_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type
65: , x_Discount_Header_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Discount_Header_Rec_Type
66: , x_Price_LLine_tbl OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Tbl_Type
67: , x_Discount_Cust_tbl OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type
68: , x_Discount_Line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type
69: , x_Price_Break_tbl OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Price_Break_Tbl_Type
70: );

Line 98: , p_Price_LHeader_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=

94: , p_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type :=
95: OE_Pricing_Cont_PUB.G_MISS_CONTRACT_REC
96: , p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type :=
97: OE_Pricing_Cont_PUB.G_MISS_AGREEMENT_REC
98: , p_Price_LHeader_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=
99: OE_Price_List_PUB.G_MISS_PRICE_List_REC
100: , p_Discount_Header_rec IN OE_Pricing_Cont_PUB.Discount_Header_Rec_Type :=
101: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_HEADER_REC
102: , p_Price_LLine_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type :=

Line 99: OE_Price_List_PUB.G_MISS_PRICE_List_REC

95: OE_Pricing_Cont_PUB.G_MISS_CONTRACT_REC
96: , p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type :=
97: OE_Pricing_Cont_PUB.G_MISS_AGREEMENT_REC
98: , p_Price_LHeader_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=
99: OE_Price_List_PUB.G_MISS_PRICE_List_REC
100: , p_Discount_Header_rec IN OE_Pricing_Cont_PUB.Discount_Header_Rec_Type :=
101: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_HEADER_REC
102: , p_Price_LLine_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type :=
103: OE_Price_List_PUB.G_MISS_PRICE_List_Line_TBL

Line 102: , p_Price_LLine_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type :=

98: , p_Price_LHeader_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=
99: OE_Price_List_PUB.G_MISS_PRICE_List_REC
100: , p_Discount_Header_rec IN OE_Pricing_Cont_PUB.Discount_Header_Rec_Type :=
101: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_HEADER_REC
102: , p_Price_LLine_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type :=
103: OE_Price_List_PUB.G_MISS_PRICE_List_Line_TBL
104: , p_Discount_Cust_tbl IN OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type :=
105: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_CUST_TBL
106: , p_Discount_Line_tbl IN OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type :=

Line 103: OE_Price_List_PUB.G_MISS_PRICE_List_Line_TBL

99: OE_Price_List_PUB.G_MISS_PRICE_List_REC
100: , p_Discount_Header_rec IN OE_Pricing_Cont_PUB.Discount_Header_Rec_Type :=
101: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_HEADER_REC
102: , p_Price_LLine_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type :=
103: OE_Price_List_PUB.G_MISS_PRICE_List_Line_TBL
104: , p_Discount_Cust_tbl IN OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type :=
105: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_CUST_TBL
106: , p_Discount_Line_tbl IN OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type :=
107: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_LINE_TBL

Line 112: , x_Price_LHeader_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type

108: , p_Price_Break_tbl IN OE_Pricing_Cont_PUB.Price_Break_Tbl_Type :=
109: OE_Pricing_Cont_PUB.G_MISS_PRICE_BREAK_TBL
110: , x_Contract_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Contract_Rec_Type
111: , x_Agreement_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Agreement_Rec_Type
112: , x_Price_LHeader_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type
113: , x_Discount_Header_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Discount_Header_Rec_Type
114: , x_Price_LLine_tbl OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Tbl_Type
115: , x_Discount_Cust_tbl OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type
116: , x_Discount_Line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type

Line 114: , x_Price_LLine_tbl OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Tbl_Type

110: , x_Contract_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Contract_Rec_Type
111: , x_Agreement_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Agreement_Rec_Type
112: , x_Price_LHeader_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type
113: , x_Discount_Header_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Discount_Header_Rec_Type
114: , x_Price_LLine_tbl OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Tbl_Type
115: , x_Discount_Cust_tbl OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type
116: , x_Discount_Line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type
117: , x_Price_Break_tbl OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Price_Break_Tbl_Type
118: );

Line 146: , x_Price_LHeader_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type

142: , p_pricing_contract_id IN NUMBER
143: , p_name IN VARCHAR2
144: , x_Contract_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Contract_Rec_Type
145: , x_Agreement_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Agreement_Rec_Type
146: , x_Price_LHeader_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type
147: , x_Discount_Header_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Discount_Header_Rec_Type
148: , x_Price_LLine_tbl OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Tbl_Type
149: , x_Discount_Cust_tbl OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type
150: , x_Discount_Line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type

Line 148: , x_Price_LLine_tbl OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Tbl_Type

144: , x_Contract_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Contract_Rec_Type
145: , x_Agreement_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Agreement_Rec_Type
146: , x_Price_LHeader_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type
147: , x_Discount_Header_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Discount_Header_Rec_Type
148: , x_Price_LLine_tbl OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Tbl_Type
149: , x_Discount_Cust_tbl OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type
150: , x_Discount_Line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type
151: , x_Price_Break_tbl OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Price_Break_Tbl_Type
152: );