[Home] [Help]
PACKAGE: APPS.OE_PRICE_BREAK_UTIL
Source
1 PACKAGE OE_Price_Break_Util AUTHID CURRENT_USER AS
2 /* $Header: OEXUDPBS.pls 115.0 99/07/15 19:27:22 porting shi $ */
3
4 -- Attributes global constants
5
6 G_AMOUNT CONSTANT NUMBER := 1;
7 G_ATTRIBUTE1 CONSTANT NUMBER := 2;
8 G_ATTRIBUTE10 CONSTANT NUMBER := 3;
9 G_ATTRIBUTE11 CONSTANT NUMBER := 4;
10 G_ATTRIBUTE12 CONSTANT NUMBER := 5;
11 G_ATTRIBUTE13 CONSTANT NUMBER := 6;
12 G_ATTRIBUTE14 CONSTANT NUMBER := 7;
13 G_ATTRIBUTE15 CONSTANT NUMBER := 8;
14 G_ATTRIBUTE2 CONSTANT NUMBER := 9;
15 G_ATTRIBUTE3 CONSTANT NUMBER := 10;
16 G_ATTRIBUTE4 CONSTANT NUMBER := 11;
17 G_ATTRIBUTE5 CONSTANT NUMBER := 12;
18 G_ATTRIBUTE6 CONSTANT NUMBER := 13;
19 G_ATTRIBUTE7 CONSTANT NUMBER := 14;
20 G_ATTRIBUTE8 CONSTANT NUMBER := 15;
21 G_ATTRIBUTE9 CONSTANT NUMBER := 16;
22 G_CONTEXT CONSTANT NUMBER := 17;
23 G_CREATED_BY CONSTANT NUMBER := 18;
24 G_CREATION_DATE CONSTANT NUMBER := 19;
25 G_DISCOUNT_LINE CONSTANT NUMBER := 20;
26 G_END_DATE_ACTIVE CONSTANT NUMBER := 21;
27 G_LAST_UPDATED_BY CONSTANT NUMBER := 22;
28 G_LAST_UPDATE_DATE CONSTANT NUMBER := 23;
29 G_LAST_UPDATE_LOGIN CONSTANT NUMBER := 24;
30 G_METHOD_TYPE CONSTANT NUMBER := 25;
31 G_PERCENT CONSTANT NUMBER := 26;
32 G_PRICE CONSTANT NUMBER := 27;
33 G_PRICE_BREAK_HIGH CONSTANT NUMBER := 28;
34 G_PRICE_BREAK_LOW CONSTANT NUMBER := 29;
35 G_PROGRAM_APPLICATION CONSTANT NUMBER := 30;
36 G_PROGRAM CONSTANT NUMBER := 31;
37 G_PROGRAM_UPDATE_DATE CONSTANT NUMBER := 32;
38 G_REQUEST CONSTANT NUMBER := 33;
39 G_START_DATE_ACTIVE CONSTANT NUMBER := 34;
40 G_UNIT CONSTANT NUMBER := 35;
41 G_MAX_ATTR_ID CONSTANT NUMBER := 36;
42
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 );
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 );
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
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
78 ( p_Price_Break_rec IN OE_Pricing_Cont_PUB.Price_Break_Rec_Type
79 );
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
89 PROCEDURE Delete_Row
90 ( p_discount_line_id IN NUMBER
91 , p_method_type_code IN VARCHAR2
92 , p_price_break_high IN NUMBER
93 , p_price_break_low IN NUMBER
94 );
95
96 -- Function Query_Row
97
98 FUNCTION Query_Row
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 --
108
109 FUNCTION Query_Rows
110 ( p_discount_line_id IN NUMBER :=
111 FND_API.G_MISS_NUM
112 , p_method_type_code IN VARCHAR2 :=
113 FND_API.G_MISS_CHAR
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
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
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
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;