[Home] [Help]
PACKAGE: APPS.QP_MODIFIERS_UTIL
Source
1 PACKAGE QP_Modifiers_Util AUTHID CURRENT_USER AS
2 /* $Header: QPXUMLLS.pls 120.2.12020000.2 2013/01/31 13:51:44 jputta ship $ */
3
4 -- Attributes global constants
5
6 G_ARITHMETIC_OPERATOR 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_AUTOMATIC CONSTANT NUMBER := 17;
23 --G_BASE_QTY CONSTANT NUMBER := 18;
24 --G_BASE_UOM CONSTANT NUMBER := 19;
25 G_COMMENTS CONSTANT NUMBER := 20;
26 G_CONTEXT CONSTANT NUMBER := 21;
27 G_CREATED_BY CONSTANT NUMBER := 22;
28 G_CREATION_DATE CONSTANT NUMBER := 23;
29 G_EFFECTIVE_PERIOD_UOM CONSTANT NUMBER := 24;
30 G_END_DATE_ACTIVE CONSTANT NUMBER := 25;
31 G_ESTIM_ACCRUAL_RATE CONSTANT NUMBER := 26;
32 G_GENERATE_USING_FORMULA CONSTANT NUMBER := 27;
33 G_INVENTORY_ITEM CONSTANT NUMBER := 28;
34 G_LAST_UPDATED_BY CONSTANT NUMBER := 29;
35 G_LAST_UPDATE_DATE CONSTANT NUMBER := 30;
36 G_LAST_UPDATE_LOGIN CONSTANT NUMBER := 31;
37 G_LIST_HEADER CONSTANT NUMBER := 32;
38 G_LIST_LINE CONSTANT NUMBER := 33;
39 G_LIST_LINE_TYPE CONSTANT NUMBER := 34;
40 G_LIST_PRICE CONSTANT NUMBER := 35;
41 G_MODIFIER_LEVEL CONSTANT NUMBER := 36;
42 G_NUMBER_EFFECTIVE_PERIODS CONSTANT NUMBER := 37;
43 G_OPERAND CONSTANT NUMBER := 38;
44 G_ORGANIZATION CONSTANT NUMBER := 39;
45 G_OVERRIDE CONSTANT NUMBER := 40;
46 G_PERCENT_PRICE CONSTANT NUMBER := 41;
47 G_PRICE_BREAK_TYPE CONSTANT NUMBER := 42;
48 G_PRICE_BY_FORMULA CONSTANT NUMBER := 43;
49 G_PRIMARY_UOM CONSTANT NUMBER := 44;
50 G_PRINT_ON_INVOICE CONSTANT NUMBER := 45;
51 G_PROGRAM_APPLICATION CONSTANT NUMBER := 46;
52 G_PROGRAM CONSTANT NUMBER := 47;
53 G_PROGRAM_UPDATE_DATE CONSTANT NUMBER := 48;
54 G_REBATE_TRANSACTION_TYPE CONSTANT NUMBER := 49;
55 G_RELATED_ITEM CONSTANT NUMBER := 50;
56 G_RELATIONSHIP_TYPE CONSTANT NUMBER := 51;
57 G_REPRICE CONSTANT NUMBER := 52;
58 G_REQUEST CONSTANT NUMBER := 53;
59 G_REVISION CONSTANT NUMBER := 54;
60 G_REVISION_DATE CONSTANT NUMBER := 55;
61 G_REVISION_REASON CONSTANT NUMBER := 56;
62 G_START_DATE_ACTIVE CONSTANT NUMBER := 57;
63 G_SUBSTITUTION_ATTRIBUTE CONSTANT NUMBER := 58;
64 G_SUBSTITUTION_CONTEXT CONSTANT NUMBER := 59;
65 G_SUBSTITUTION_VALUE CONSTANT NUMBER := 60;
66 G_ACCRUAL_FLAG CONSTANT NUMBER := 61;
67 G_PRICING_GROUP_SEQUENCE CONSTANT NUMBER := 62;
68 G_INCOMPATIBILITY_GRP_CODE CONSTANT NUMBER := 63;
69 G_LIST_LINE_NO CONSTANT NUMBER := 64;
70 G_PRICING_PHASE CONSTANT NUMBER := 65;
71 G_PRODUCT_PRECEDENCE CONSTANT NUMBER := 66;
72 G_EXPIRATION_PERIOD_START_DATE CONSTANT NUMBER := 67;
73 G_NUMBER_EXPIRATION_PERIODS CONSTANT NUMBER := 68;
74 G_EXPIRATION_PERIOD_UOM CONSTANT NUMBER := 69;
75 G_EXPIRATION_DATE CONSTANT NUMBER := 70;
76 G_ESTIM_GL_VALUE CONSTANT NUMBER := 71;
77 G_BENEFIT_PRICE_LIST_LINE CONSTANT NUMBER := 72;
78 --G_RECURRING_FLAG CONSTANT NUMBER := 73;
79 G_BENEFIT_LIMIT CONSTANT NUMBER := 74;
80 G_CHARGE_TYPE CONSTANT NUMBER := 75;
81 G_CHARGE_SUBTYPE CONSTANT NUMBER := 76;
82 G_BENEFIT_QTY CONSTANT NUMBER := 77;
83 G_BENEFIT_UOM CONSTANT NUMBER := 78;
84 G_ACCRUAL_CONVERSION_RATE CONSTANT NUMBER := 79;
85 G_PRORATION_TYPE CONSTANT NUMBER := 80;
86 G_INCLUDE_ON_RETURNS_FLAG CONSTANT NUMBER := 81;
87 G_FROM_RLTD_MODIFIER CONSTANT NUMBER := 82;
88 G_TO_RLTD_MODIFIER CONSTANT NUMBER := 83;
89 G_RLTD_MODIFIER_GRP_NO CONSTANT NUMBER := 84;
90 G_RLTD_MODIFIER_GRP_TYPE CONSTANT NUMBER := 85;
91 G_RLTD_MODIFIER_ID CONSTANT NUMBER := 90;
92 G_MAX_ATTR_ID CONSTANT NUMBER := 89;
93 G_QUALIFICATION_IND CONSTANT NUMBER := 87;
94 G_NET_AMOUNT CONSTANT NUMBER := 86;
95 G_ACCUM_ATTRIBUTE CONSTANT NUMBER := 88;
96 G_CONTINUOUS_PRICE_BREAK_FLAG CONSTANT NUMBER := 89; --Continuous Price Breaks
97 G_SERVICE_DURATION CONSTANT NUMBER := 90; -- service project
98 G_SERVICE_PERIOD CONSTANT NUMBER := 91; -- service project
99
100 -- Procedure Clear_Dependent_Attr
101
102 PROCEDURE Clear_Dependent_Attr
103 ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
104 , p_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type
105 , p_old_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type :=
106 QP_Modifiers_PUB.G_MISS_MODIFIERS_REC
107 , x_MODIFIERS_rec OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifiers_Rec_Type
108 );
109
110 -- Procedure Apply_Attribute_Changes
111
112 PROCEDURE Apply_Attribute_Changes
113 ( p_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type
114 , p_old_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type :=
115 QP_Modifiers_PUB.G_MISS_MODIFIERS_REC
116 , x_MODIFIERS_rec OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifiers_Rec_Type
117 );
118
119 -- Function Complete_Record
120
121 FUNCTION Complete_Record
122 ( p_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type
123 , p_old_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type
124 ) RETURN QP_Modifiers_PUB.Modifiers_Rec_Type;
125
126 -- Function Convert_Miss_To_Null
127
128 FUNCTION Convert_Miss_To_Null
129 ( p_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type
130 ) RETURN QP_Modifiers_PUB.Modifiers_Rec_Type;
131
132 -- Procedure Update_Row
133
134 PROCEDURE Update_Row
135 ( p_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type
136 );
137
138 -- Procedure Insert_Row
139
140 PROCEDURE Insert_Row
141 ( p_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type
142 );
143
144 -- Procedure Delete_Row
145
146 PROCEDURE Delete_Row
147 ( p_list_line_id IN NUMBER
148 );
149
150 -- Function Query_Row
151
152 FUNCTION Query_Row
153 ( p_list_line_id IN NUMBER
154 ) RETURN QP_Modifiers_PUB.Modifiers_Rec_Type;
155
156 -- Function Query_Rows
157
158 --
159
160 FUNCTION Query_Rows
161 ( p_list_line_id IN NUMBER :=
162 FND_API.G_MISS_NUM
163 , p_list_header_id IN NUMBER :=
164 FND_API.G_MISS_NUM
165 ) RETURN QP_Modifiers_PUB.Modifiers_Tbl_Type;
166
167 -- Procedure lock_Row
168 --
169
170 PROCEDURE Lock_Row
171 ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
172 , p_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type
173 , x_MODIFIERS_rec OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifiers_Rec_Type
174 );
175
176 -- Function Get_Values
177
178 FUNCTION Get_Values
179 ( p_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type
180 , p_old_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type :=
181 QP_Modifiers_PUB.G_MISS_MODIFIERS_REC
182 ) RETURN QP_Modifiers_PUB.Modifiers_Val_Rec_Type;
183
184 -- Function Get_Ids
185
186 FUNCTION Get_Ids
187 ( p_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type
188 , p_MODIFIERS_val_rec IN QP_Modifiers_PUB.Modifiers_Val_Rec_Type
189 ) RETURN QP_Modifiers_PUB.Modifiers_Rec_Type;
190
191
192
193 Procedure Pre_Write_Process
194 ( p_MODIFIERS_rec IN QP_Modifiers_PUB.MODIFIERS_rec_Type
195 , p_old_MODIFIERS_rec IN QP_Modifiers_PUB.MODIFIERS_rec_Type
196 := QP_Modifiers_PUB.G_MISS_MODIFIERS_rec
197 , x_MODIFIERS_rec OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.MODIFIERS_rec_Type
198 );
199 ------------------fix for bug 3756625
200 Procedure Log_Update_Phases_DL
201 ( p_MODIFIERS_rec IN QP_Modifiers_PUB.MODIFIERS_rec_Type
202 ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
203
204 END QP_Modifiers_Util;