1: PACKAGE BODY QP_Formula_Util AS
2: /* $Header: QPXUPRFB.pls 120.1 2005/06/12 23:13:25 appldev $ */
3:
4: -- Global constant holding the package name
5:
2: /* $Header: QPXUPRFB.pls 120.1 2005/06/12 23:13:25 appldev $ */
3:
4: -- Global constant holding the package name
5:
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'QP_Formula_Util';
7:
8: -- Procedure Clear_Dependent_Attr
9:
10: PROCEDURE Clear_Dependent_Attr
32:
33: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.attribute1,p_old_FORMULA_rec.attribute1)
34: THEN
35: l_index := l_index + 1;
36: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_ATTRIBUTE1;
37: END IF;
38:
39: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.attribute10,p_old_FORMULA_rec.attribute10)
40: THEN
38:
39: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.attribute10,p_old_FORMULA_rec.attribute10)
40: THEN
41: l_index := l_index + 1;
42: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_ATTRIBUTE10;
43: END IF;
44:
45: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.attribute11,p_old_FORMULA_rec.attribute11)
46: THEN
44:
45: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.attribute11,p_old_FORMULA_rec.attribute11)
46: THEN
47: l_index := l_index + 1;
48: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_ATTRIBUTE11;
49: END IF;
50:
51: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.attribute12,p_old_FORMULA_rec.attribute12)
52: THEN
50:
51: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.attribute12,p_old_FORMULA_rec.attribute12)
52: THEN
53: l_index := l_index + 1;
54: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_ATTRIBUTE12;
55: END IF;
56:
57: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.attribute13,p_old_FORMULA_rec.attribute13)
58: THEN
56:
57: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.attribute13,p_old_FORMULA_rec.attribute13)
58: THEN
59: l_index := l_index + 1;
60: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_ATTRIBUTE13;
61: END IF;
62:
63: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.attribute14,p_old_FORMULA_rec.attribute14)
64: THEN
62:
63: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.attribute14,p_old_FORMULA_rec.attribute14)
64: THEN
65: l_index := l_index + 1;
66: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_ATTRIBUTE14;
67: END IF;
68:
69: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.attribute15,p_old_FORMULA_rec.attribute15)
70: THEN
68:
69: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.attribute15,p_old_FORMULA_rec.attribute15)
70: THEN
71: l_index := l_index + 1;
72: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_ATTRIBUTE15;
73: END IF;
74:
75: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.attribute2,p_old_FORMULA_rec.attribute2)
76: THEN
74:
75: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.attribute2,p_old_FORMULA_rec.attribute2)
76: THEN
77: l_index := l_index + 1;
78: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_ATTRIBUTE2;
79: END IF;
80:
81: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.attribute3,p_old_FORMULA_rec.attribute3)
82: THEN
80:
81: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.attribute3,p_old_FORMULA_rec.attribute3)
82: THEN
83: l_index := l_index + 1;
84: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_ATTRIBUTE3;
85: END IF;
86:
87: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.attribute4,p_old_FORMULA_rec.attribute4)
88: THEN
86:
87: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.attribute4,p_old_FORMULA_rec.attribute4)
88: THEN
89: l_index := l_index + 1;
90: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_ATTRIBUTE4;
91: END IF;
92:
93: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.attribute5,p_old_FORMULA_rec.attribute5)
94: THEN
92:
93: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.attribute5,p_old_FORMULA_rec.attribute5)
94: THEN
95: l_index := l_index + 1;
96: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_ATTRIBUTE5;
97: END IF;
98:
99: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.attribute6,p_old_FORMULA_rec.attribute6)
100: THEN
98:
99: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.attribute6,p_old_FORMULA_rec.attribute6)
100: THEN
101: l_index := l_index + 1;
102: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_ATTRIBUTE6;
103: END IF;
104:
105: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.attribute7,p_old_FORMULA_rec.attribute7)
106: THEN
104:
105: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.attribute7,p_old_FORMULA_rec.attribute7)
106: THEN
107: l_index := l_index + 1;
108: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_ATTRIBUTE7;
109: END IF;
110:
111: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.attribute8,p_old_FORMULA_rec.attribute8)
112: THEN
110:
111: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.attribute8,p_old_FORMULA_rec.attribute8)
112: THEN
113: l_index := l_index + 1;
114: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_ATTRIBUTE8;
115: END IF;
116:
117: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.attribute9,p_old_FORMULA_rec.attribute9)
118: THEN
116:
117: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.attribute9,p_old_FORMULA_rec.attribute9)
118: THEN
119: l_index := l_index + 1;
120: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_ATTRIBUTE9;
121: END IF;
122:
123: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.context,p_old_FORMULA_rec.context)
124: THEN
122:
123: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.context,p_old_FORMULA_rec.context)
124: THEN
125: l_index := l_index + 1;
126: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_CONTEXT;
127: END IF;
128:
129: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.created_by,p_old_FORMULA_rec.created_by)
130: THEN
128:
129: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.created_by,p_old_FORMULA_rec.created_by)
130: THEN
131: l_index := l_index + 1;
132: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_CREATED_BY;
133: END IF;
134:
135: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.creation_date,p_old_FORMULA_rec.creation_date)
136: THEN
134:
135: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.creation_date,p_old_FORMULA_rec.creation_date)
136: THEN
137: l_index := l_index + 1;
138: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_CREATION_DATE;
139: END IF;
140:
141: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.description,p_old_FORMULA_rec.description)
142: THEN
140:
141: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.description,p_old_FORMULA_rec.description)
142: THEN
143: l_index := l_index + 1;
144: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_DESCRIPTION;
145: END IF;
146:
147: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.end_date_active,p_old_FORMULA_rec.end_date_active)
148: THEN
146:
147: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.end_date_active,p_old_FORMULA_rec.end_date_active)
148: THEN
149: l_index := l_index + 1;
150: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_END_DATE_ACTIVE;
151: END IF;
152:
153: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.formula,p_old_FORMULA_rec.formula)
154: THEN
152:
153: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.formula,p_old_FORMULA_rec.formula)
154: THEN
155: l_index := l_index + 1;
156: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_FORMULA;
157: END IF;
158:
159: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.last_updated_by,p_old_FORMULA_rec.last_updated_by)
160: THEN
158:
159: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.last_updated_by,p_old_FORMULA_rec.last_updated_by)
160: THEN
161: l_index := l_index + 1;
162: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_LAST_UPDATED_BY;
163: END IF;
164:
165: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.last_update_date,p_old_FORMULA_rec.last_update_date)
166: THEN
164:
165: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.last_update_date,p_old_FORMULA_rec.last_update_date)
166: THEN
167: l_index := l_index + 1;
168: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_LAST_UPDATE_DATE;
169: END IF;
170:
171: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.last_update_login,p_old_FORMULA_rec.last_update_login)
172: THEN
170:
171: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.last_update_login,p_old_FORMULA_rec.last_update_login)
172: THEN
173: l_index := l_index + 1;
174: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_LAST_UPDATE_LOGIN;
175: END IF;
176:
177: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.name,p_old_FORMULA_rec.name)
178: THEN
176:
177: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.name,p_old_FORMULA_rec.name)
178: THEN
179: l_index := l_index + 1;
180: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_NAME;
181: END IF;
182:
183: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.price_formula_id,p_old_FORMULA_rec.price_formula_id)
184: THEN
182:
183: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.price_formula_id,p_old_FORMULA_rec.price_formula_id)
184: THEN
185: l_index := l_index + 1;
186: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_PRICE_FORMULA;
187: END IF;
188:
189: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.start_date_active,p_old_FORMULA_rec.start_date_active)
190: THEN
188:
189: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.start_date_active,p_old_FORMULA_rec.start_date_active)
190: THEN
191: l_index := l_index + 1;
192: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_START_DATE_ACTIVE;
193: END IF;
194:
195: ELSIF p_attr_id = G_ATTRIBUTE1 THEN
196: l_index := l_index + 1;
193: END IF;
194:
195: ELSIF p_attr_id = G_ATTRIBUTE1 THEN
196: l_index := l_index + 1;
197: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_ATTRIBUTE1;
198: ELSIF p_attr_id = G_ATTRIBUTE10 THEN
199: l_index := l_index + 1;
200: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_ATTRIBUTE10;
201: ELSIF p_attr_id = G_ATTRIBUTE11 THEN
196: l_index := l_index + 1;
197: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_ATTRIBUTE1;
198: ELSIF p_attr_id = G_ATTRIBUTE10 THEN
199: l_index := l_index + 1;
200: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_ATTRIBUTE10;
201: ELSIF p_attr_id = G_ATTRIBUTE11 THEN
202: l_index := l_index + 1;
203: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_ATTRIBUTE11;
204: ELSIF p_attr_id = G_ATTRIBUTE12 THEN
199: l_index := l_index + 1;
200: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_ATTRIBUTE10;
201: ELSIF p_attr_id = G_ATTRIBUTE11 THEN
202: l_index := l_index + 1;
203: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_ATTRIBUTE11;
204: ELSIF p_attr_id = G_ATTRIBUTE12 THEN
205: l_index := l_index + 1;
206: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_ATTRIBUTE12;
207: ELSIF p_attr_id = G_ATTRIBUTE13 THEN
202: l_index := l_index + 1;
203: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_ATTRIBUTE11;
204: ELSIF p_attr_id = G_ATTRIBUTE12 THEN
205: l_index := l_index + 1;
206: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_ATTRIBUTE12;
207: ELSIF p_attr_id = G_ATTRIBUTE13 THEN
208: l_index := l_index + 1;
209: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_ATTRIBUTE13;
210: ELSIF p_attr_id = G_ATTRIBUTE14 THEN
205: l_index := l_index + 1;
206: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_ATTRIBUTE12;
207: ELSIF p_attr_id = G_ATTRIBUTE13 THEN
208: l_index := l_index + 1;
209: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_ATTRIBUTE13;
210: ELSIF p_attr_id = G_ATTRIBUTE14 THEN
211: l_index := l_index + 1;
212: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_ATTRIBUTE14;
213: ELSIF p_attr_id = G_ATTRIBUTE15 THEN
208: l_index := l_index + 1;
209: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_ATTRIBUTE13;
210: ELSIF p_attr_id = G_ATTRIBUTE14 THEN
211: l_index := l_index + 1;
212: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_ATTRIBUTE14;
213: ELSIF p_attr_id = G_ATTRIBUTE15 THEN
214: l_index := l_index + 1;
215: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_ATTRIBUTE15;
216: ELSIF p_attr_id = G_ATTRIBUTE2 THEN
211: l_index := l_index + 1;
212: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_ATTRIBUTE14;
213: ELSIF p_attr_id = G_ATTRIBUTE15 THEN
214: l_index := l_index + 1;
215: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_ATTRIBUTE15;
216: ELSIF p_attr_id = G_ATTRIBUTE2 THEN
217: l_index := l_index + 1;
218: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_ATTRIBUTE2;
219: ELSIF p_attr_id = G_ATTRIBUTE3 THEN
214: l_index := l_index + 1;
215: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_ATTRIBUTE15;
216: ELSIF p_attr_id = G_ATTRIBUTE2 THEN
217: l_index := l_index + 1;
218: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_ATTRIBUTE2;
219: ELSIF p_attr_id = G_ATTRIBUTE3 THEN
220: l_index := l_index + 1;
221: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_ATTRIBUTE3;
222: ELSIF p_attr_id = G_ATTRIBUTE4 THEN
217: l_index := l_index + 1;
218: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_ATTRIBUTE2;
219: ELSIF p_attr_id = G_ATTRIBUTE3 THEN
220: l_index := l_index + 1;
221: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_ATTRIBUTE3;
222: ELSIF p_attr_id = G_ATTRIBUTE4 THEN
223: l_index := l_index + 1;
224: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_ATTRIBUTE4;
225: ELSIF p_attr_id = G_ATTRIBUTE5 THEN
220: l_index := l_index + 1;
221: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_ATTRIBUTE3;
222: ELSIF p_attr_id = G_ATTRIBUTE4 THEN
223: l_index := l_index + 1;
224: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_ATTRIBUTE4;
225: ELSIF p_attr_id = G_ATTRIBUTE5 THEN
226: l_index := l_index + 1;
227: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_ATTRIBUTE5;
228: ELSIF p_attr_id = G_ATTRIBUTE6 THEN
223: l_index := l_index + 1;
224: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_ATTRIBUTE4;
225: ELSIF p_attr_id = G_ATTRIBUTE5 THEN
226: l_index := l_index + 1;
227: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_ATTRIBUTE5;
228: ELSIF p_attr_id = G_ATTRIBUTE6 THEN
229: l_index := l_index + 1;
230: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_ATTRIBUTE6;
231: ELSIF p_attr_id = G_ATTRIBUTE7 THEN
226: l_index := l_index + 1;
227: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_ATTRIBUTE5;
228: ELSIF p_attr_id = G_ATTRIBUTE6 THEN
229: l_index := l_index + 1;
230: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_ATTRIBUTE6;
231: ELSIF p_attr_id = G_ATTRIBUTE7 THEN
232: l_index := l_index + 1;
233: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_ATTRIBUTE7;
234: ELSIF p_attr_id = G_ATTRIBUTE8 THEN
229: l_index := l_index + 1;
230: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_ATTRIBUTE6;
231: ELSIF p_attr_id = G_ATTRIBUTE7 THEN
232: l_index := l_index + 1;
233: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_ATTRIBUTE7;
234: ELSIF p_attr_id = G_ATTRIBUTE8 THEN
235: l_index := l_index + 1;
236: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_ATTRIBUTE8;
237: ELSIF p_attr_id = G_ATTRIBUTE9 THEN
232: l_index := l_index + 1;
233: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_ATTRIBUTE7;
234: ELSIF p_attr_id = G_ATTRIBUTE8 THEN
235: l_index := l_index + 1;
236: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_ATTRIBUTE8;
237: ELSIF p_attr_id = G_ATTRIBUTE9 THEN
238: l_index := l_index + 1;
239: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_ATTRIBUTE9;
240: ELSIF p_attr_id = G_CONTEXT THEN
235: l_index := l_index + 1;
236: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_ATTRIBUTE8;
237: ELSIF p_attr_id = G_ATTRIBUTE9 THEN
238: l_index := l_index + 1;
239: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_ATTRIBUTE9;
240: ELSIF p_attr_id = G_CONTEXT THEN
241: l_index := l_index + 1;
242: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_CONTEXT;
243: ELSIF p_attr_id = G_CREATED_BY THEN
238: l_index := l_index + 1;
239: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_ATTRIBUTE9;
240: ELSIF p_attr_id = G_CONTEXT THEN
241: l_index := l_index + 1;
242: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_CONTEXT;
243: ELSIF p_attr_id = G_CREATED_BY THEN
244: l_index := l_index + 1;
245: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_CREATED_BY;
246: ELSIF p_attr_id = G_CREATION_DATE THEN
241: l_index := l_index + 1;
242: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_CONTEXT;
243: ELSIF p_attr_id = G_CREATED_BY THEN
244: l_index := l_index + 1;
245: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_CREATED_BY;
246: ELSIF p_attr_id = G_CREATION_DATE THEN
247: l_index := l_index + 1;
248: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_CREATION_DATE;
249: ELSIF p_attr_id = G_DESCRIPTION THEN
244: l_index := l_index + 1;
245: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_CREATED_BY;
246: ELSIF p_attr_id = G_CREATION_DATE THEN
247: l_index := l_index + 1;
248: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_CREATION_DATE;
249: ELSIF p_attr_id = G_DESCRIPTION THEN
250: l_index := l_index + 1;
251: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_DESCRIPTION;
252: ELSIF p_attr_id = G_END_DATE_ACTIVE THEN
247: l_index := l_index + 1;
248: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_CREATION_DATE;
249: ELSIF p_attr_id = G_DESCRIPTION THEN
250: l_index := l_index + 1;
251: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_DESCRIPTION;
252: ELSIF p_attr_id = G_END_DATE_ACTIVE THEN
253: l_index := l_index + 1;
254: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_END_DATE_ACTIVE;
255: ELSIF p_attr_id = G_FORMULA THEN
250: l_index := l_index + 1;
251: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_DESCRIPTION;
252: ELSIF p_attr_id = G_END_DATE_ACTIVE THEN
253: l_index := l_index + 1;
254: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_END_DATE_ACTIVE;
255: ELSIF p_attr_id = G_FORMULA THEN
256: l_index := l_index + 1;
257: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_FORMULA;
258: ELSIF p_attr_id = G_LAST_UPDATED_BY THEN
253: l_index := l_index + 1;
254: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_END_DATE_ACTIVE;
255: ELSIF p_attr_id = G_FORMULA THEN
256: l_index := l_index + 1;
257: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_FORMULA;
258: ELSIF p_attr_id = G_LAST_UPDATED_BY THEN
259: l_index := l_index + 1;
260: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_LAST_UPDATED_BY;
261: ELSIF p_attr_id = G_LAST_UPDATE_DATE THEN
256: l_index := l_index + 1;
257: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_FORMULA;
258: ELSIF p_attr_id = G_LAST_UPDATED_BY THEN
259: l_index := l_index + 1;
260: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_LAST_UPDATED_BY;
261: ELSIF p_attr_id = G_LAST_UPDATE_DATE THEN
262: l_index := l_index + 1;
263: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_LAST_UPDATE_DATE;
264: ELSIF p_attr_id = G_LAST_UPDATE_LOGIN THEN
259: l_index := l_index + 1;
260: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_LAST_UPDATED_BY;
261: ELSIF p_attr_id = G_LAST_UPDATE_DATE THEN
262: l_index := l_index + 1;
263: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_LAST_UPDATE_DATE;
264: ELSIF p_attr_id = G_LAST_UPDATE_LOGIN THEN
265: l_index := l_index + 1;
266: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_LAST_UPDATE_LOGIN;
267: ELSIF p_attr_id = G_NAME THEN
262: l_index := l_index + 1;
263: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_LAST_UPDATE_DATE;
264: ELSIF p_attr_id = G_LAST_UPDATE_LOGIN THEN
265: l_index := l_index + 1;
266: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_LAST_UPDATE_LOGIN;
267: ELSIF p_attr_id = G_NAME THEN
268: l_index := l_index + 1;
269: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_NAME;
270: ELSIF p_attr_id = G_PRICE_FORMULA THEN
265: l_index := l_index + 1;
266: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_LAST_UPDATE_LOGIN;
267: ELSIF p_attr_id = G_NAME THEN
268: l_index := l_index + 1;
269: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_NAME;
270: ELSIF p_attr_id = G_PRICE_FORMULA THEN
271: l_index := l_index + 1;
272: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_PRICE_FORMULA;
273: ELSIF p_attr_id = G_START_DATE_ACTIVE THEN
268: l_index := l_index + 1;
269: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_NAME;
270: ELSIF p_attr_id = G_PRICE_FORMULA THEN
271: l_index := l_index + 1;
272: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_PRICE_FORMULA;
273: ELSIF p_attr_id = G_START_DATE_ACTIVE THEN
274: l_index := l_index + 1;
275: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_START_DATE_ACTIVE;
276: END IF;
271: l_index := l_index + 1;
272: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_PRICE_FORMULA;
273: ELSIF p_attr_id = G_START_DATE_ACTIVE THEN
274: l_index := l_index + 1;
275: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_START_DATE_ACTIVE;
276: END IF;
277:
278: oe_debug_pub.add('Leaving proc clear_dependent_attr in Formula Util Pkg');
279: END Clear_Dependent_Attr;
1247: RETURN l_FORMULA_rec;
1248:
1249: END Get_Ids;
1250:
1251: END QP_Formula_Util;