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

APPS.OE_PRICING_CONT_PVT dependencies on OE_PRICING_CONT_PUB

Line 30: , p_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type :=

26: OE_GLOBALS.G_MISS_CONTROL_REC
27: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
28: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
29: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
30: , p_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type :=
31: OE_Pricing_Cont_PUB.G_MISS_CONTRACT_REC
32: , p_old_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type :=
33: OE_Pricing_Cont_PUB.G_MISS_CONTRACT_REC
34: , p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type :=

Line 31: OE_Pricing_Cont_PUB.G_MISS_CONTRACT_REC

27: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
28: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
29: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
30: , p_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type :=
31: OE_Pricing_Cont_PUB.G_MISS_CONTRACT_REC
32: , p_old_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type :=
33: OE_Pricing_Cont_PUB.G_MISS_CONTRACT_REC
34: , p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type :=
35: OE_Pricing_Cont_PUB.G_MISS_AGREEMENT_REC

Line 32: , p_old_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type :=

28: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
29: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
30: , p_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type :=
31: OE_Pricing_Cont_PUB.G_MISS_CONTRACT_REC
32: , p_old_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type :=
33: OE_Pricing_Cont_PUB.G_MISS_CONTRACT_REC
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 :=

Line 33: OE_Pricing_Cont_PUB.G_MISS_CONTRACT_REC

29: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
30: , p_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type :=
31: OE_Pricing_Cont_PUB.G_MISS_CONTRACT_REC
32: , p_old_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type :=
33: OE_Pricing_Cont_PUB.G_MISS_CONTRACT_REC
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

Line 34: , p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type :=

30: , p_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type :=
31: OE_Pricing_Cont_PUB.G_MISS_CONTRACT_REC
32: , p_old_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type :=
33: OE_Pricing_Cont_PUB.G_MISS_CONTRACT_REC
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 :=

Line 35: OE_Pricing_Cont_PUB.G_MISS_AGREEMENT_REC

31: OE_Pricing_Cont_PUB.G_MISS_CONTRACT_REC
32: , p_old_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type :=
33: OE_Pricing_Cont_PUB.G_MISS_CONTRACT_REC
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

Line 36: , p_old_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type :=

32: , p_old_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type :=
33: OE_Pricing_Cont_PUB.G_MISS_CONTRACT_REC
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 :=

Line 37: OE_Pricing_Cont_PUB.G_MISS_AGREEMENT_REC

33: OE_Pricing_Cont_PUB.G_MISS_CONTRACT_REC
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

Line 42: , p_Discount_Header_rec IN OE_Pricing_Cont_PUB.Discount_Header_Rec_Type :=

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
46: , p_Price_LLine_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type :=

Line 43: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_HEADER_REC

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
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

Line 44: , p_old_Discount_Header_rec IN OE_Pricing_Cont_PUB.Discount_Header_Rec_Type :=

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
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 :=

Line 45: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_HEADER_REC

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
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

Line 50: , p_Discount_Cust_tbl IN OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type :=

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
54: , p_Discount_Line_tbl IN OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type :=

Line 51: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_CUST_TBL

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
54: , p_Discount_Line_tbl IN OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type :=
55: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_LINE_TBL

Line 52: , p_old_Discount_Cust_tbl IN OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type :=

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
54: , p_Discount_Line_tbl IN OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type :=
55: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_LINE_TBL
56: , p_old_Discount_Line_tbl IN OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type :=

Line 53: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_CUST_TBL

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
54: , p_Discount_Line_tbl IN OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type :=
55: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_LINE_TBL
56: , p_old_Discount_Line_tbl IN OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type :=
57: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_LINE_TBL

Line 54: , p_Discount_Line_tbl IN OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type :=

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
54: , p_Discount_Line_tbl IN OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type :=
55: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_LINE_TBL
56: , p_old_Discount_Line_tbl IN OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type :=
57: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_LINE_TBL
58: , p_Price_Break_tbl IN OE_Pricing_Cont_PUB.Price_Break_Tbl_Type :=

Line 55: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_LINE_TBL

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
54: , p_Discount_Line_tbl IN OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type :=
55: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_LINE_TBL
56: , p_old_Discount_Line_tbl IN OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type :=
57: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_LINE_TBL
58: , p_Price_Break_tbl IN OE_Pricing_Cont_PUB.Price_Break_Tbl_Type :=
59: OE_Pricing_Cont_PUB.G_MISS_PRICE_BREAK_TBL

Line 56: , p_old_Discount_Line_tbl IN OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type :=

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
54: , p_Discount_Line_tbl IN OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type :=
55: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_LINE_TBL
56: , p_old_Discount_Line_tbl IN OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type :=
57: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_LINE_TBL
58: , p_Price_Break_tbl IN OE_Pricing_Cont_PUB.Price_Break_Tbl_Type :=
59: OE_Pricing_Cont_PUB.G_MISS_PRICE_BREAK_TBL
60: , p_old_Price_Break_tbl IN OE_Pricing_Cont_PUB.Price_Break_Tbl_Type :=

Line 57: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_LINE_TBL

53: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_CUST_TBL
54: , p_Discount_Line_tbl IN OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type :=
55: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_LINE_TBL
56: , p_old_Discount_Line_tbl IN OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type :=
57: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_LINE_TBL
58: , p_Price_Break_tbl IN OE_Pricing_Cont_PUB.Price_Break_Tbl_Type :=
59: OE_Pricing_Cont_PUB.G_MISS_PRICE_BREAK_TBL
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

Line 58: , p_Price_Break_tbl IN OE_Pricing_Cont_PUB.Price_Break_Tbl_Type :=

54: , p_Discount_Line_tbl IN OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type :=
55: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_LINE_TBL
56: , p_old_Discount_Line_tbl IN OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type :=
57: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_LINE_TBL
58: , p_Price_Break_tbl IN OE_Pricing_Cont_PUB.Price_Break_Tbl_Type :=
59: OE_Pricing_Cont_PUB.G_MISS_PRICE_BREAK_TBL
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

Line 59: OE_Pricing_Cont_PUB.G_MISS_PRICE_BREAK_TBL

55: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_LINE_TBL
56: , p_old_Discount_Line_tbl IN OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type :=
57: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_LINE_TBL
58: , p_Price_Break_tbl IN OE_Pricing_Cont_PUB.Price_Break_Tbl_Type :=
59: OE_Pricing_Cont_PUB.G_MISS_PRICE_BREAK_TBL
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

Line 60: , p_old_Price_Break_tbl IN OE_Pricing_Cont_PUB.Price_Break_Tbl_Type :=

56: , p_old_Discount_Line_tbl IN OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type :=
57: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_LINE_TBL
58: , p_Price_Break_tbl IN OE_Pricing_Cont_PUB.Price_Break_Tbl_Type :=
59: OE_Pricing_Cont_PUB.G_MISS_PRICE_BREAK_TBL
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

Line 61: OE_Pricing_Cont_PUB.G_MISS_PRICE_BREAK_TBL

57: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_LINE_TBL
58: , p_Price_Break_tbl IN OE_Pricing_Cont_PUB.Price_Break_Tbl_Type :=
59: OE_Pricing_Cont_PUB.G_MISS_PRICE_BREAK_TBL
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

Line 62: , x_Contract_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Contract_Rec_Type

58: , p_Price_Break_tbl IN OE_Pricing_Cont_PUB.Price_Break_Tbl_Type :=
59: OE_Pricing_Cont_PUB.G_MISS_PRICE_BREAK_TBL
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

Line 63: , x_Agreement_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Agreement_Rec_Type

59: OE_Pricing_Cont_PUB.G_MISS_PRICE_BREAK_TBL
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

Line 65: , x_Discount_Header_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Discount_Header_Rec_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
69: , x_Price_Break_tbl OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Price_Break_Tbl_Type

Line 67: , x_Discount_Cust_tbl OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Discount_Cust_Tbl_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: );
71:

Line 68: , x_Discount_Line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Discount_Line_Tbl_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: );
71:
72: -- Start of Comments

Line 69: , x_Price_Break_tbl OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Price_Break_Tbl_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: );
71:
72: -- Start of Comments
73: -- API name Lock_Pricing_Cont

Line 94: , p_Contract_rec IN OE_Pricing_Cont_PUB.Contract_Rec_Type :=

90: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
91: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
92: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
93: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
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 :=

Line 95: OE_Pricing_Cont_PUB.G_MISS_CONTRACT_REC

91: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
92: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
93: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
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

Line 96: , p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type :=

92: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
93: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
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 :=

Line 97: OE_Pricing_Cont_PUB.G_MISS_AGREEMENT_REC

93: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
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

Line 100: , p_Discount_Header_rec IN OE_Pricing_Cont_PUB.Discount_Header_Rec_Type :=

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
104: , p_Discount_Cust_tbl IN OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type :=

Line 101: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_HEADER_REC

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
104: , p_Discount_Cust_tbl IN OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type :=
105: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_CUST_TBL

Line 104: , p_Discount_Cust_tbl IN OE_Pricing_Cont_PUB.Discount_Cust_Tbl_Type :=

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
108: , p_Price_Break_tbl IN OE_Pricing_Cont_PUB.Price_Break_Tbl_Type :=

Line 105: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_CUST_TBL

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
108: , p_Price_Break_tbl IN OE_Pricing_Cont_PUB.Price_Break_Tbl_Type :=
109: OE_Pricing_Cont_PUB.G_MISS_PRICE_BREAK_TBL

Line 106: , p_Discount_Line_tbl IN OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type :=

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
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

Line 107: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_LINE_TBL

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
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

Line 108: , p_Price_Break_tbl IN OE_Pricing_Cont_PUB.Price_Break_Tbl_Type :=

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
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

Line 109: OE_Pricing_Cont_PUB.G_MISS_PRICE_BREAK_TBL

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
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

Line 110: , x_Contract_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Contract_Rec_Type

106: , p_Discount_Line_tbl IN OE_Pricing_Cont_PUB.Discount_Line_Tbl_Type :=
107: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_LINE_TBL
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

Line 111: , x_Agreement_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Agreement_Rec_Type

107: OE_Pricing_Cont_PUB.G_MISS_DISCOUNT_LINE_TBL
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

Line 113: , x_Discount_Header_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Discount_Header_Rec_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
117: , x_Price_Break_tbl OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Price_Break_Tbl_Type

Line 115: , x_Discount_Cust_tbl OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Discount_Cust_Tbl_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: );
119:

Line 116: , x_Discount_Line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Discount_Line_Tbl_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: );
119:
120: -- Start of Comments

Line 117: , x_Price_Break_tbl OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Price_Break_Tbl_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: );
119:
120: -- Start of Comments
121: -- API name Get_Pricing_Cont

Line 144: , x_Contract_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Contract_Rec_Type

140: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
141: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
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

Line 145: , x_Agreement_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Agreement_Rec_Type

141: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
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

Line 147: , x_Discount_Header_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Discount_Header_Rec_Type

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
151: , x_Price_Break_tbl OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Price_Break_Tbl_Type

Line 149: , x_Discount_Cust_tbl OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Discount_Cust_Tbl_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: );
153:

Line 150: , x_Discount_Line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Discount_Line_Tbl_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: );
153:
154:

Line 151: , x_Price_Break_tbl OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Price_Break_Tbl_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: );
153:
154:
155: /*Included this procedure in public to be used by vgulati for his upgrade script to upgrade agreements -- spgopal*/