eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.QP_FORMULA_UTIL dependencies on QP_FORMULA_UTIL

Line 1: PACKAGE BODY QP_Formula_Util AS

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:

Line 6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'QP_Formula_Util';

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

Line 36: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_ATTRIBUTE1;

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

Line 42: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_ATTRIBUTE10;

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

Line 48: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_ATTRIBUTE11;

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

Line 54: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_ATTRIBUTE12;

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

Line 60: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_ATTRIBUTE13;

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

Line 66: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_ATTRIBUTE14;

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

Line 72: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_ATTRIBUTE15;

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

Line 78: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_ATTRIBUTE2;

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

Line 84: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_ATTRIBUTE3;

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

Line 90: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_ATTRIBUTE4;

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

Line 96: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_ATTRIBUTE5;

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

Line 102: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_ATTRIBUTE6;

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

Line 108: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_ATTRIBUTE7;

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

Line 114: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_ATTRIBUTE8;

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

Line 120: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_ATTRIBUTE9;

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

Line 126: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_CONTEXT;

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

Line 132: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_CREATED_BY;

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

Line 138: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_CREATION_DATE;

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

Line 144: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_DESCRIPTION;

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

Line 150: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_END_DATE_ACTIVE;

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

Line 156: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_FORMULA;

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

Line 162: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_LAST_UPDATED_BY;

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

Line 168: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_LAST_UPDATE_DATE;

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

Line 174: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_LAST_UPDATE_LOGIN;

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

Line 180: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_NAME;

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

Line 186: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_PRICE_FORMULA;

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

Line 192: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_START_DATE_ACTIVE;

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;

Line 197: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_ATTRIBUTE1;

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

Line 200: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_ATTRIBUTE10;

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

Line 203: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_ATTRIBUTE11;

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

Line 206: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_ATTRIBUTE12;

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

Line 209: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_ATTRIBUTE13;

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

Line 212: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_ATTRIBUTE14;

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

Line 215: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_ATTRIBUTE15;

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

Line 218: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_ATTRIBUTE2;

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

Line 221: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_ATTRIBUTE3;

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

Line 224: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_ATTRIBUTE4;

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

Line 227: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_ATTRIBUTE5;

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

Line 230: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_ATTRIBUTE6;

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

Line 233: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_ATTRIBUTE7;

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

Line 236: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_ATTRIBUTE8;

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

Line 239: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_ATTRIBUTE9;

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

Line 242: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_CONTEXT;

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

Line 245: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_CREATED_BY;

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

Line 248: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_CREATION_DATE;

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

Line 251: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_DESCRIPTION;

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

Line 254: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_END_DATE_ACTIVE;

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

Line 257: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_FORMULA;

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

Line 260: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_LAST_UPDATED_BY;

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

Line 263: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_LAST_UPDATE_DATE;

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

Line 266: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_LAST_UPDATE_LOGIN;

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

Line 269: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_NAME;

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

Line 272: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_PRICE_FORMULA;

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;

Line 275: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_START_DATE_ACTIVE;

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;

Line 1251: END QP_Formula_Util;

1247: RETURN l_FORMULA_rec;
1248:
1249: END Get_Ids;
1250:
1251: END QP_Formula_Util;