[Home] [Help]
PACKAGE: APPS.QP_MODIFIER_LIST_UTIL
Source
1 PACKAGE QP_Modifier_List_Util AUTHID CURRENT_USER AS
2 /* $Header: QPXUMLHS.pls 120.2 2005/06/20 23:06:40 appldev ship $ */
3
4 -- Attributes global constants
5 /*
6 G_ATTRIBUTE1 CONSTANT NUMBER := 1;
7 G_ATTRIBUTE10 CONSTANT NUMBER := 2;
8 G_ATTRIBUTE11 CONSTANT NUMBER := 3;
9 G_ATTRIBUTE12 CONSTANT NUMBER := 4;
10 G_ATTRIBUTE13 CONSTANT NUMBER := 5;
11 G_ATTRIBUTE14 CONSTANT NUMBER := 6;
12 G_ATTRIBUTE15 CONSTANT NUMBER := 7;
13 G_ATTRIBUTE2 CONSTANT NUMBER := 8;
14 G_ATTRIBUTE3 CONSTANT NUMBER := 9;
15 G_ATTRIBUTE4 CONSTANT NUMBER := 10;
16 G_ATTRIBUTE5 CONSTANT NUMBER := 11;
17 G_ATTRIBUTE6 CONSTANT NUMBER := 12;
18 G_ATTRIBUTE7 CONSTANT NUMBER := 13;
19 G_ATTRIBUTE8 CONSTANT NUMBER := 14;
20 G_ATTRIBUTE9 CONSTANT NUMBER := 15;
21 G_AUTOMATIC CONSTANT NUMBER := 16;
22 G_COMMENTS CONSTANT NUMBER := 17;
23 G_CONTEXT CONSTANT NUMBER := 18;
24 G_CREATED_BY CONSTANT NUMBER := 19;
25 G_CREATION_DATE CONSTANT NUMBER := 20;
26 G_CURRENCY CONSTANT NUMBER := 21;
27 G_DISCOUNT_LINES CONSTANT NUMBER := 22;
28 G_END_DATE_ACTIVE CONSTANT NUMBER := 23;
29 G_FREIGHT_TERMS CONSTANT NUMBER := 24;
30 G_GSA_INDICATOR CONSTANT NUMBER := 25;
31 G_LAST_UPDATED_BY CONSTANT NUMBER := 26;
32 G_LAST_UPDATE_DATE CONSTANT NUMBER := 27;
33 G_LAST_UPDATE_LOGIN CONSTANT NUMBER := 28;
34 G_LIST_HEADER CONSTANT NUMBER := 29;
35 G_LIST_TYPE CONSTANT NUMBER := 30;
36 G_PROGRAM_APPLICATION CONSTANT NUMBER := 31;
37 G_PROGRAM CONSTANT NUMBER := 32;
38 G_PROGRAM_UPDATE_DATE CONSTANT NUMBER := 33;
39 G_PRORATE CONSTANT NUMBER := 34;
40 G_REQUEST CONSTANT NUMBER := 35;
41 G_ROUNDING_FACTOR CONSTANT NUMBER := 36;
42 G_SHIP_METHOD CONSTANT NUMBER := 37;
43 G_START_DATE_ACTIVE CONSTANT NUMBER := 38;
44 G_TERMS CONSTANT NUMBER := 39;
45 G_VERSION_NO CONSTANT NUMBER := 40;
46 G_SOURCE_SYSTEM_CODE CONSTANT NUMBER := 44;
47 G_ACTIVE_FLAG CONSTANT NUMBER := 45;
48 G_PARENT_LIST_HEADER_ID CONSTANT NUMBER := 46;
49 G_START_DATE_ACTIVE_FIRST CONSTANT NUMBER := 47;
50 G_END_DATE_ACTIVE_FIRST CONSTANT NUMBER := 48;
51 G_ACTIVE_DATE_FIRST_TYPE CONSTANT NUMBER := 49;
52 G_NAME CONSTANT NUMBER := 50;
53 G_DESCRIPTION CONSTANT NUMBER := 51;
54 G_START_DATE_ACTIVE_SECOND CONSTANT NUMBER := 52;
55 G_END_DATE_ACTIVE_SECOND CONSTANT NUMBER := 53;
56 G_ACTIVE_DATE_SECOND_TYPE CONSTANT NUMBER := 54;
57 G_MAX_ATTR_ID CONSTANT NUMBER := 55;
58 */
59
60
61
62 G_ATTRIBUTE1 CONSTANT NUMBER := 1;
63 G_ATTRIBUTE10 CONSTANT NUMBER := 2;
64 G_ATTRIBUTE11 CONSTANT NUMBER := 3;
65 G_ATTRIBUTE12 CONSTANT NUMBER := 4;
66 G_ATTRIBUTE13 CONSTANT NUMBER := 5;
67 G_ATTRIBUTE14 CONSTANT NUMBER := 6;
68 G_ATTRIBUTE15 CONSTANT NUMBER := 7;
69 G_ATTRIBUTE2 CONSTANT NUMBER := 8;
70 G_ATTRIBUTE3 CONSTANT NUMBER := 9;
71 G_ATTRIBUTE4 CONSTANT NUMBER := 10;
72 G_ATTRIBUTE5 CONSTANT NUMBER := 11;
73 G_ATTRIBUTE6 CONSTANT NUMBER := 12;
74 G_ATTRIBUTE7 CONSTANT NUMBER := 13;
75 G_ATTRIBUTE8 CONSTANT NUMBER := 14;
76 G_ATTRIBUTE9 CONSTANT NUMBER := 15;
77 G_AUTOMATIC CONSTANT NUMBER := 16;
78 G_COMMENTS CONSTANT NUMBER := 17;
79 G_CONTEXT CONSTANT NUMBER := 18;
80 G_CREATED_BY CONSTANT NUMBER := 19;
81 G_CREATION_DATE CONSTANT NUMBER := 20;
82 G_CURRENCY CONSTANT NUMBER := 21;
83 G_DISCOUNT_LINES CONSTANT NUMBER := 22;
84 G_END_DATE_ACTIVE CONSTANT NUMBER := 23;
85 G_FREIGHT_TERMS CONSTANT NUMBER := 24;
86 G_GSA_INDICATOR CONSTANT NUMBER := 25;
87 G_LAST_UPDATED_BY CONSTANT NUMBER := 26;
88 G_LAST_UPDATE_DATE CONSTANT NUMBER := 27;
89 G_LAST_UPDATE_LOGIN CONSTANT NUMBER := 28;
90 G_LIST_HEADER CONSTANT NUMBER := 29;
91 G_LIST_TYPE CONSTANT NUMBER := 30;
92 G_PROGRAM_APPLICATION CONSTANT NUMBER := 31;
93 G_PROGRAM CONSTANT NUMBER := 32;
94 G_PROGRAM_UPDATE_DATE CONSTANT NUMBER := 33;
95 G_PRORATE CONSTANT NUMBER := 34;
96 G_REQUEST CONSTANT NUMBER := 35;
97 G_ROUNDING_FACTOR CONSTANT NUMBER := 36;
98 G_SHIP_METHOD CONSTANT NUMBER := 37;
99 G_START_DATE_ACTIVE CONSTANT NUMBER := 38;
100 G_TERMS CONSTANT NUMBER := 39;
101 G_VERSION_NO CONSTANT NUMBER := 40;
102 G_PARENT_LIST_HEADER_ID CONSTANT NUMBER := 41;
103 G_ACTIVE_DATE_FIRST_TYPE CONSTANT NUMBER := 42;
104 G_START_DATE_ACTIVE_FIRST CONSTANT NUMBER := 43;
105 G_END_DATE_ACTIVE_FIRST CONSTANT NUMBER := 44;
106 G_ACTIVE_DATE_SECOND_TYPE CONSTANT NUMBER := 45;
107 G_START_DATE_ACTIVE_SECOND CONSTANT NUMBER := 46;
108 G_GLOBAL_FLAG CONSTANT NUMBER := 47;
109 G_END_DATE_ACTIVE_SECOND CONSTANT NUMBER := 48;
110 G_ACTIVE_FLAG CONSTANT NUMBER := 49;
111 G_ASK_FOR CONSTANT NUMBER := 50;
112 G_NAME CONSTANT NUMBER := 51;
113 G_DESCRIPTION CONSTANT NUMBER := 52;
114 G_SOURCE_SYSTEM_CODE CONSTANT NUMBER := 53;
115 G_MAX_ATTR_ID CONSTANT NUMBER := 54;
116 G_PTE_CODE CONSTANT NUMBER := 55;
117 -- Blanket pricing
118 G_LIST_SOURCE_CODE CONSTANT NUMBER := 56;
119 G_ORIG_SYSTEM_HEADER_REF CONSTANT NUMBER := 57;
120 G_SHAREABLE_FLAG CONSTANT NUMBER := 58;
121 --added for MOAC
122 G_ORG_ID CONSTANT NUMBER := 59;
123
124
125
126
127
128 -- Procedure Clear_Dependent_Attr
129
130 PROCEDURE Clear_Dependent_Attr
131 ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
132 , p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type
133 , p_old_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type :=
134 QP_Modifiers_PUB.G_MISS_MODIFIER_LIST_REC
135 , x_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifier_List_Rec_Type
136 );
137
138 -- Procedure Apply_Attribute_Changes
139
140 PROCEDURE Apply_Attribute_Changes
141 ( p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type
142 , p_old_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type :=
143 QP_Modifiers_PUB.G_MISS_MODIFIER_LIST_REC
144 , x_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifier_List_Rec_Type
145 );
146
147 -- Function Complete_Record
148
149 FUNCTION Complete_Record
150 ( p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type
151 , p_old_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type
152 ) RETURN QP_Modifiers_PUB.Modifier_List_Rec_Type;
153
154 -- Function Convert_Miss_To_Null
155
156 FUNCTION Convert_Miss_To_Null
157 ( p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type
158 ) RETURN QP_Modifiers_PUB.Modifier_List_Rec_Type;
159
160 -- Procedure Update_Row
161
162 PROCEDURE Update_Row
163 ( p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type
164 );
165
166 -- Procedure Insert_Row
167
168 PROCEDURE Insert_Row
169 ( p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type
170 );
171
172 -- Procedure Delete_Row
173
174 PROCEDURE Delete_Row
175 ( p_list_header_id IN NUMBER
176 );
177
178 -- Function Query_Row
179
180 FUNCTION Query_Row
181 ( p_list_header_id IN NUMBER
182 ) RETURN QP_Modifiers_PUB.Modifier_List_Rec_Type;
183
184 -- Procedure lock_Row
185 --
186
187 PROCEDURE Lock_Row
188 ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
189 , p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type
190 , x_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifier_List_Rec_Type
191 );
192
193 -- Function Get_Values
194
195 FUNCTION Get_Values
196 ( p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type
197 , p_old_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type :=
198 QP_Modifiers_PUB.G_MISS_MODIFIER_LIST_REC
199 ) RETURN QP_Modifiers_PUB.Modifier_List_Val_Rec_Type;
200
201 -- Function Get_Ids
202
203 FUNCTION Get_Ids
204 ( p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type
205 , p_MODIFIER_LIST_val_rec IN QP_Modifiers_PUB.Modifier_List_Val_Rec_Type
206 ) RETURN QP_Modifiers_PUB.Modifier_List_Rec_Type;
207
208 FUNCTION Get_Segment_Level_for_Group
209 (p_list_header_id IN NUMBER
210 ,p_list_line_id IN NUMBER
211 ,p_qualifier_grouping_no IN NUMBER
212 ) RETURN VARCHAR2;
213
214 END QP_Modifier_List_Util;