43: -- Procedure Clear_Dependent_Attr
44:
45: PROCEDURE Clear_Dependent_Attr
46: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
47: , p_Price_Break_rec IN OE_Pricing_Cont_PUB.Price_Break_Rec_Type
48: , p_old_Price_Break_rec IN OE_Pricing_Cont_PUB.Price_Break_Rec_Type :=
49: OE_Pricing_Cont_PUB.G_MISS_PRICE_BREAK_REC
50: , x_Price_Break_rec OUT OE_Pricing_Cont_PUB.Price_Break_Rec_Type
51: );
44:
45: PROCEDURE Clear_Dependent_Attr
46: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
47: , p_Price_Break_rec IN OE_Pricing_Cont_PUB.Price_Break_Rec_Type
48: , p_old_Price_Break_rec IN OE_Pricing_Cont_PUB.Price_Break_Rec_Type :=
49: OE_Pricing_Cont_PUB.G_MISS_PRICE_BREAK_REC
50: , x_Price_Break_rec OUT OE_Pricing_Cont_PUB.Price_Break_Rec_Type
51: );
52:
45: PROCEDURE Clear_Dependent_Attr
46: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
47: , p_Price_Break_rec IN OE_Pricing_Cont_PUB.Price_Break_Rec_Type
48: , p_old_Price_Break_rec IN OE_Pricing_Cont_PUB.Price_Break_Rec_Type :=
49: OE_Pricing_Cont_PUB.G_MISS_PRICE_BREAK_REC
50: , x_Price_Break_rec OUT OE_Pricing_Cont_PUB.Price_Break_Rec_Type
51: );
52:
53: -- Procedure Apply_Attribute_Changes
46: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
47: , p_Price_Break_rec IN OE_Pricing_Cont_PUB.Price_Break_Rec_Type
48: , p_old_Price_Break_rec IN OE_Pricing_Cont_PUB.Price_Break_Rec_Type :=
49: OE_Pricing_Cont_PUB.G_MISS_PRICE_BREAK_REC
50: , x_Price_Break_rec OUT OE_Pricing_Cont_PUB.Price_Break_Rec_Type
51: );
52:
53: -- Procedure Apply_Attribute_Changes
54:
52:
53: -- Procedure Apply_Attribute_Changes
54:
55: PROCEDURE Apply_Attribute_Changes
56: ( p_Price_Break_rec IN OE_Pricing_Cont_PUB.Price_Break_Rec_Type
57: , p_old_Price_Break_rec IN OE_Pricing_Cont_PUB.Price_Break_Rec_Type :=
58: OE_Pricing_Cont_PUB.G_MISS_PRICE_BREAK_REC
59: , x_Price_Break_rec OUT OE_Pricing_Cont_PUB.Price_Break_Rec_Type
60: );
53: -- Procedure Apply_Attribute_Changes
54:
55: PROCEDURE Apply_Attribute_Changes
56: ( p_Price_Break_rec IN OE_Pricing_Cont_PUB.Price_Break_Rec_Type
57: , p_old_Price_Break_rec IN OE_Pricing_Cont_PUB.Price_Break_Rec_Type :=
58: OE_Pricing_Cont_PUB.G_MISS_PRICE_BREAK_REC
59: , x_Price_Break_rec OUT OE_Pricing_Cont_PUB.Price_Break_Rec_Type
60: );
61:
54:
55: PROCEDURE Apply_Attribute_Changes
56: ( p_Price_Break_rec IN OE_Pricing_Cont_PUB.Price_Break_Rec_Type
57: , p_old_Price_Break_rec IN OE_Pricing_Cont_PUB.Price_Break_Rec_Type :=
58: OE_Pricing_Cont_PUB.G_MISS_PRICE_BREAK_REC
59: , x_Price_Break_rec OUT OE_Pricing_Cont_PUB.Price_Break_Rec_Type
60: );
61:
62: -- Function Complete_Record
55: PROCEDURE Apply_Attribute_Changes
56: ( p_Price_Break_rec IN OE_Pricing_Cont_PUB.Price_Break_Rec_Type
57: , p_old_Price_Break_rec IN OE_Pricing_Cont_PUB.Price_Break_Rec_Type :=
58: OE_Pricing_Cont_PUB.G_MISS_PRICE_BREAK_REC
59: , x_Price_Break_rec OUT OE_Pricing_Cont_PUB.Price_Break_Rec_Type
60: );
61:
62: -- Function Complete_Record
63:
61:
62: -- Function Complete_Record
63:
64: FUNCTION Complete_Record
65: ( p_Price_Break_rec IN OE_Pricing_Cont_PUB.Price_Break_Rec_Type
66: , p_old_Price_Break_rec IN OE_Pricing_Cont_PUB.Price_Break_Rec_Type
67: ) RETURN OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
68:
69: -- Function Convert_Miss_To_Null
62: -- Function Complete_Record
63:
64: FUNCTION Complete_Record
65: ( p_Price_Break_rec IN OE_Pricing_Cont_PUB.Price_Break_Rec_Type
66: , p_old_Price_Break_rec IN OE_Pricing_Cont_PUB.Price_Break_Rec_Type
67: ) RETURN OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
68:
69: -- Function Convert_Miss_To_Null
70:
63:
64: FUNCTION Complete_Record
65: ( p_Price_Break_rec IN OE_Pricing_Cont_PUB.Price_Break_Rec_Type
66: , p_old_Price_Break_rec IN OE_Pricing_Cont_PUB.Price_Break_Rec_Type
67: ) RETURN OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
68:
69: -- Function Convert_Miss_To_Null
70:
71: FUNCTION Convert_Miss_To_Null
68:
69: -- Function Convert_Miss_To_Null
70:
71: FUNCTION Convert_Miss_To_Null
72: ( p_Price_Break_rec IN OE_Pricing_Cont_PUB.Price_Break_Rec_Type
73: ) RETURN OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
74:
75: -- Procedure Update_Row
76:
69: -- Function Convert_Miss_To_Null
70:
71: FUNCTION Convert_Miss_To_Null
72: ( p_Price_Break_rec IN OE_Pricing_Cont_PUB.Price_Break_Rec_Type
73: ) RETURN OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
74:
75: -- Procedure Update_Row
76:
77: PROCEDURE Update_Row
74:
75: -- Procedure Update_Row
76:
77: PROCEDURE Update_Row
78: ( p_Price_Break_rec IN OE_Pricing_Cont_PUB.Price_Break_Rec_Type
79: );
80:
81: -- Procedure Insert_Row
82:
80:
81: -- Procedure Insert_Row
82:
83: PROCEDURE Insert_Row
84: ( p_Price_Break_rec IN OE_Pricing_Cont_PUB.Price_Break_Rec_Type
85: );
86:
87: -- Procedure Delete_Row
88:
99: ( p_discount_line_id IN NUMBER
100: , p_method_type_code IN VARCHAR2
101: , p_price_break_high IN NUMBER
102: , p_price_break_low IN NUMBER
103: ) RETURN OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
104:
105: -- Function Query_Rows
106:
107: --
114: , p_price_break_high IN NUMBER :=
115: FND_API.G_MISS_NUM
116: , p_price_break_low IN NUMBER :=
117: FND_API.G_MISS_NUM
118: ) RETURN OE_Pricing_Cont_PUB.Price_Break_Tbl_Type;
119:
120: -- Procedure lock_Row
121: --
122:
121: --
122:
123: PROCEDURE Lock_Row
124: ( x_return_status OUT VARCHAR2
125: , p_Price_Break_rec IN OE_Pricing_Cont_PUB.Price_Break_Rec_Type
126: , x_Price_Break_rec OUT OE_Pricing_Cont_PUB.Price_Break_Rec_Type
127: );
128:
129: -- Function Get_Values
122:
123: PROCEDURE Lock_Row
124: ( x_return_status OUT VARCHAR2
125: , p_Price_Break_rec IN OE_Pricing_Cont_PUB.Price_Break_Rec_Type
126: , x_Price_Break_rec OUT OE_Pricing_Cont_PUB.Price_Break_Rec_Type
127: );
128:
129: -- Function Get_Values
130:
128:
129: -- Function Get_Values
130:
131: FUNCTION Get_Values
132: ( p_Price_Break_rec IN OE_Pricing_Cont_PUB.Price_Break_Rec_Type
133: , p_old_Price_Break_rec IN OE_Pricing_Cont_PUB.Price_Break_Rec_Type :=
134: OE_Pricing_Cont_PUB.G_MISS_PRICE_BREAK_REC
135: ) RETURN OE_Pricing_Cont_PUB.Price_Break_Val_Rec_Type;
136:
129: -- Function Get_Values
130:
131: FUNCTION Get_Values
132: ( p_Price_Break_rec IN OE_Pricing_Cont_PUB.Price_Break_Rec_Type
133: , p_old_Price_Break_rec IN OE_Pricing_Cont_PUB.Price_Break_Rec_Type :=
134: OE_Pricing_Cont_PUB.G_MISS_PRICE_BREAK_REC
135: ) RETURN OE_Pricing_Cont_PUB.Price_Break_Val_Rec_Type;
136:
137: -- Function Get_Ids
130:
131: FUNCTION Get_Values
132: ( p_Price_Break_rec IN OE_Pricing_Cont_PUB.Price_Break_Rec_Type
133: , p_old_Price_Break_rec IN OE_Pricing_Cont_PUB.Price_Break_Rec_Type :=
134: OE_Pricing_Cont_PUB.G_MISS_PRICE_BREAK_REC
135: ) RETURN OE_Pricing_Cont_PUB.Price_Break_Val_Rec_Type;
136:
137: -- Function Get_Ids
138:
131: FUNCTION Get_Values
132: ( p_Price_Break_rec IN OE_Pricing_Cont_PUB.Price_Break_Rec_Type
133: , p_old_Price_Break_rec IN OE_Pricing_Cont_PUB.Price_Break_Rec_Type :=
134: OE_Pricing_Cont_PUB.G_MISS_PRICE_BREAK_REC
135: ) RETURN OE_Pricing_Cont_PUB.Price_Break_Val_Rec_Type;
136:
137: -- Function Get_Ids
138:
139: FUNCTION Get_Ids
136:
137: -- Function Get_Ids
138:
139: FUNCTION Get_Ids
140: ( p_Price_Break_rec IN OE_Pricing_Cont_PUB.Price_Break_Rec_Type
141: , p_Price_Break_val_rec IN OE_Pricing_Cont_PUB.Price_Break_Val_Rec_Type
142: ) RETURN OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
143:
144: END OE_Price_Break_Util;
137: -- Function Get_Ids
138:
139: FUNCTION Get_Ids
140: ( p_Price_Break_rec IN OE_Pricing_Cont_PUB.Price_Break_Rec_Type
141: , p_Price_Break_val_rec IN OE_Pricing_Cont_PUB.Price_Break_Val_Rec_Type
142: ) RETURN OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
143:
144: END OE_Price_Break_Util;
138:
139: FUNCTION Get_Ids
140: ( p_Price_Break_rec IN OE_Pricing_Cont_PUB.Price_Break_Rec_Type
141: , p_Price_Break_val_rec IN OE_Pricing_Cont_PUB.Price_Break_Val_Rec_Type
142: ) RETURN OE_Pricing_Cont_PUB.Price_Break_Rec_Type;
143:
144: END OE_Price_Break_Util;