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_SEG_UTIL dependencies on QP_SEG_UTIL

Line 1: PACKAGE BODY QP_Seg_Util AS

1: PACKAGE BODY QP_Seg_Util AS
2: /* $Header: QPXUSEGB.pls 120.2 2005/08/03 07:36:58 srashmi noship $ */
3:
4: -- Global constant holding the package name
5:

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

2: /* $Header: QPXUSEGB.pls 120.2 2005/08/03 07:36:58 srashmi noship $ */
3:
4: -- Global constant holding the package name
5:
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'QP_Seg_Util';
7:
8: -- Procedure Clear_Dependent_Attr
9:
10: PROCEDURE p_compile_flexfields(p_segment_mapping_column in varchar2)

Line 86: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE1;

82:
83: IF NOT QP_GLOBALS.Equal(p_SEG_rec.attribute1,p_old_SEG_rec.attribute1)
84: THEN
85: l_index := l_index + 1;
86: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE1;
87: END IF;
88:
89: IF NOT QP_GLOBALS.Equal(p_SEG_rec.attribute10,p_old_SEG_rec.attribute10)
90: THEN

Line 92: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE10;

88:
89: IF NOT QP_GLOBALS.Equal(p_SEG_rec.attribute10,p_old_SEG_rec.attribute10)
90: THEN
91: l_index := l_index + 1;
92: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE10;
93: END IF;
94:
95: IF NOT QP_GLOBALS.Equal(p_SEG_rec.attribute11,p_old_SEG_rec.attribute11)
96: THEN

Line 98: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE11;

94:
95: IF NOT QP_GLOBALS.Equal(p_SEG_rec.attribute11,p_old_SEG_rec.attribute11)
96: THEN
97: l_index := l_index + 1;
98: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE11;
99: END IF;
100:
101: IF NOT QP_GLOBALS.Equal(p_SEG_rec.attribute12,p_old_SEG_rec.attribute12)
102: THEN

Line 104: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE12;

100:
101: IF NOT QP_GLOBALS.Equal(p_SEG_rec.attribute12,p_old_SEG_rec.attribute12)
102: THEN
103: l_index := l_index + 1;
104: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE12;
105: END IF;
106:
107: IF NOT QP_GLOBALS.Equal(p_SEG_rec.attribute13,p_old_SEG_rec.attribute13)
108: THEN

Line 110: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE13;

106:
107: IF NOT QP_GLOBALS.Equal(p_SEG_rec.attribute13,p_old_SEG_rec.attribute13)
108: THEN
109: l_index := l_index + 1;
110: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE13;
111: END IF;
112:
113: IF NOT QP_GLOBALS.Equal(p_SEG_rec.attribute14,p_old_SEG_rec.attribute14)
114: THEN

Line 116: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE14;

112:
113: IF NOT QP_GLOBALS.Equal(p_SEG_rec.attribute14,p_old_SEG_rec.attribute14)
114: THEN
115: l_index := l_index + 1;
116: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE14;
117: END IF;
118:
119: IF NOT QP_GLOBALS.Equal(p_SEG_rec.attribute15,p_old_SEG_rec.attribute15)
120: THEN

Line 122: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE15;

118:
119: IF NOT QP_GLOBALS.Equal(p_SEG_rec.attribute15,p_old_SEG_rec.attribute15)
120: THEN
121: l_index := l_index + 1;
122: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE15;
123: END IF;
124:
125: IF NOT QP_GLOBALS.Equal(p_SEG_rec.attribute2,p_old_SEG_rec.attribute2)
126: THEN

Line 128: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE2;

124:
125: IF NOT QP_GLOBALS.Equal(p_SEG_rec.attribute2,p_old_SEG_rec.attribute2)
126: THEN
127: l_index := l_index + 1;
128: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE2;
129: END IF;
130:
131: IF NOT QP_GLOBALS.Equal(p_SEG_rec.attribute3,p_old_SEG_rec.attribute3)
132: THEN

Line 134: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE3;

130:
131: IF NOT QP_GLOBALS.Equal(p_SEG_rec.attribute3,p_old_SEG_rec.attribute3)
132: THEN
133: l_index := l_index + 1;
134: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE3;
135: END IF;
136:
137: IF NOT QP_GLOBALS.Equal(p_SEG_rec.attribute4,p_old_SEG_rec.attribute4)
138: THEN

Line 140: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE4;

136:
137: IF NOT QP_GLOBALS.Equal(p_SEG_rec.attribute4,p_old_SEG_rec.attribute4)
138: THEN
139: l_index := l_index + 1;
140: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE4;
141: END IF;
142:
143: IF NOT QP_GLOBALS.Equal(p_SEG_rec.attribute5,p_old_SEG_rec.attribute5)
144: THEN

Line 146: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE5;

142:
143: IF NOT QP_GLOBALS.Equal(p_SEG_rec.attribute5,p_old_SEG_rec.attribute5)
144: THEN
145: l_index := l_index + 1;
146: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE5;
147: END IF;
148:
149: IF NOT QP_GLOBALS.Equal(p_SEG_rec.attribute6,p_old_SEG_rec.attribute6)
150: THEN

Line 152: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE6;

148:
149: IF NOT QP_GLOBALS.Equal(p_SEG_rec.attribute6,p_old_SEG_rec.attribute6)
150: THEN
151: l_index := l_index + 1;
152: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE6;
153: END IF;
154:
155: IF NOT QP_GLOBALS.Equal(p_SEG_rec.attribute7,p_old_SEG_rec.attribute7)
156: THEN

Line 158: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE7;

154:
155: IF NOT QP_GLOBALS.Equal(p_SEG_rec.attribute7,p_old_SEG_rec.attribute7)
156: THEN
157: l_index := l_index + 1;
158: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE7;
159: END IF;
160:
161: IF NOT QP_GLOBALS.Equal(p_SEG_rec.attribute8,p_old_SEG_rec.attribute8)
162: THEN

Line 164: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE8;

160:
161: IF NOT QP_GLOBALS.Equal(p_SEG_rec.attribute8,p_old_SEG_rec.attribute8)
162: THEN
163: l_index := l_index + 1;
164: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE8;
165: END IF;
166:
167: IF NOT QP_GLOBALS.Equal(p_SEG_rec.attribute9,p_old_SEG_rec.attribute9)
168: THEN

Line 170: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE9;

166:
167: IF NOT QP_GLOBALS.Equal(p_SEG_rec.attribute9,p_old_SEG_rec.attribute9)
168: THEN
169: l_index := l_index + 1;
170: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE9;
171: END IF;
172:
173: IF NOT QP_GLOBALS.Equal(p_SEG_rec.availability_in_basic,p_old_SEG_rec.availability_in_basic)
174: THEN

Line 176: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_AVAILABILITY_IN_BASIC;

172:
173: IF NOT QP_GLOBALS.Equal(p_SEG_rec.availability_in_basic,p_old_SEG_rec.availability_in_basic)
174: THEN
175: l_index := l_index + 1;
176: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_AVAILABILITY_IN_BASIC;
177: END IF;
178:
179: IF NOT QP_GLOBALS.Equal(p_SEG_rec.context,p_old_SEG_rec.context)
180: THEN

Line 182: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_CONTEXT;

178:
179: IF NOT QP_GLOBALS.Equal(p_SEG_rec.context,p_old_SEG_rec.context)
180: THEN
181: l_index := l_index + 1;
182: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_CONTEXT;
183: END IF;
184:
185: IF NOT QP_GLOBALS.Equal(p_SEG_rec.created_by,p_old_SEG_rec.created_by)
186: THEN

Line 188: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_CREATED_BY;

184:
185: IF NOT QP_GLOBALS.Equal(p_SEG_rec.created_by,p_old_SEG_rec.created_by)
186: THEN
187: l_index := l_index + 1;
188: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_CREATED_BY;
189: END IF;
190:
191: IF NOT QP_GLOBALS.Equal(p_SEG_rec.creation_date,p_old_SEG_rec.creation_date)
192: THEN

Line 194: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_CREATION_DATE;

190:
191: IF NOT QP_GLOBALS.Equal(p_SEG_rec.creation_date,p_old_SEG_rec.creation_date)
192: THEN
193: l_index := l_index + 1;
194: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_CREATION_DATE;
195: END IF;
196:
197: IF NOT QP_GLOBALS.Equal(p_SEG_rec.last_updated_by,p_old_SEG_rec.last_updated_by)
198: THEN

Line 200: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_LAST_UPDATED_BY;

196:
197: IF NOT QP_GLOBALS.Equal(p_SEG_rec.last_updated_by,p_old_SEG_rec.last_updated_by)
198: THEN
199: l_index := l_index + 1;
200: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_LAST_UPDATED_BY;
201: END IF;
202:
203: IF NOT QP_GLOBALS.Equal(p_SEG_rec.last_update_date,p_old_SEG_rec.last_update_date)
204: THEN

Line 206: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_LAST_UPDATE_DATE;

202:
203: IF NOT QP_GLOBALS.Equal(p_SEG_rec.last_update_date,p_old_SEG_rec.last_update_date)
204: THEN
205: l_index := l_index + 1;
206: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_LAST_UPDATE_DATE;
207: END IF;
208:
209: IF NOT QP_GLOBALS.Equal(p_SEG_rec.last_update_login,p_old_SEG_rec.last_update_login)
210: THEN

Line 212: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_LAST_UPDATE_LOGIN;

208:
209: IF NOT QP_GLOBALS.Equal(p_SEG_rec.last_update_login,p_old_SEG_rec.last_update_login)
210: THEN
211: l_index := l_index + 1;
212: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_LAST_UPDATE_LOGIN;
213: END IF;
214:
215: IF NOT QP_GLOBALS.Equal(p_SEG_rec.prc_context_id,p_old_SEG_rec.prc_context_id)
216: THEN

Line 218: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_PRC_CONTEXT;

214:
215: IF NOT QP_GLOBALS.Equal(p_SEG_rec.prc_context_id,p_old_SEG_rec.prc_context_id)
216: THEN
217: l_index := l_index + 1;
218: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_PRC_CONTEXT;
219: END IF;
220:
221: IF NOT QP_GLOBALS.Equal(p_SEG_rec.program_application_id,p_old_SEG_rec.program_application_id)
222: THEN

Line 224: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_PROGRAM_APPLICATION;

220:
221: IF NOT QP_GLOBALS.Equal(p_SEG_rec.program_application_id,p_old_SEG_rec.program_application_id)
222: THEN
223: l_index := l_index + 1;
224: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_PROGRAM_APPLICATION;
225: END IF;
226:
227: IF NOT QP_GLOBALS.Equal(p_SEG_rec.program_id,p_old_SEG_rec.program_id)
228: THEN

Line 230: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_PROGRAM;

226:
227: IF NOT QP_GLOBALS.Equal(p_SEG_rec.program_id,p_old_SEG_rec.program_id)
228: THEN
229: l_index := l_index + 1;
230: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_PROGRAM;
231: END IF;
232:
233: IF NOT QP_GLOBALS.Equal(p_SEG_rec.program_update_date,p_old_SEG_rec.program_update_date)
234: THEN

Line 236: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_PROGRAM_UPDATE_DATE;

232:
233: IF NOT QP_GLOBALS.Equal(p_SEG_rec.program_update_date,p_old_SEG_rec.program_update_date)
234: THEN
235: l_index := l_index + 1;
236: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_PROGRAM_UPDATE_DATE;
237: END IF;
238:
239: IF NOT QP_GLOBALS.Equal(p_SEG_rec.seeded_flag,p_old_SEG_rec.seeded_flag)
240: THEN

Line 242: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_SEEDED;

238:
239: IF NOT QP_GLOBALS.Equal(p_SEG_rec.seeded_flag,p_old_SEG_rec.seeded_flag)
240: THEN
241: l_index := l_index + 1;
242: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_SEEDED;
243: END IF;
244:
245: IF NOT QP_GLOBALS.Equal(p_SEG_rec.seeded_format_type,p_old_SEG_rec.seeded_format_type)
246: THEN

Line 248: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_SEEDED_FORMAT_TYPE;

244:
245: IF NOT QP_GLOBALS.Equal(p_SEG_rec.seeded_format_type,p_old_SEG_rec.seeded_format_type)
246: THEN
247: l_index := l_index + 1;
248: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_SEEDED_FORMAT_TYPE;
249: END IF;
250:
251: IF NOT QP_GLOBALS.Equal(p_SEG_rec.seeded_precedence,p_old_SEG_rec.seeded_precedence)
252: THEN

Line 254: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_SEEDED_PRECEDENCE;

250:
251: IF NOT QP_GLOBALS.Equal(p_SEG_rec.seeded_precedence,p_old_SEG_rec.seeded_precedence)
252: THEN
253: l_index := l_index + 1;
254: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_SEEDED_PRECEDENCE;
255: END IF;
256:
257:
258: IF NOT QP_GLOBALS.Equal( p_SEG_rec.seeded_description,p_old_SEG_rec.seeded_description)

Line 261: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_SEEDED_DESCRIPTION;

257:
258: IF NOT QP_GLOBALS.Equal( p_SEG_rec.seeded_description,p_old_SEG_rec.seeded_description)
259: THEN
260: l_index := l_index + 1;
261: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_SEEDED_DESCRIPTION;
262: END IF;
263:
264: IF NOT QP_GLOBALS.Equal( p_SEG_rec.user_description,p_old_SEG_rec.user_description)
265: THEN

Line 267: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_USER_DESCRIPTION;

263:
264: IF NOT QP_GLOBALS.Equal( p_SEG_rec.user_description,p_old_SEG_rec.user_description)
265: THEN
266: l_index := l_index + 1;
267: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_USER_DESCRIPTION;
268: END IF;
269:
270: IF NOT QP_GLOBALS.Equal(p_SEG_rec.seeded_segment_name,p_old_SEG_rec.seeded_segment_name)
271: THEN

Line 273: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_SEEDED_SEGMENT_NAME;

269:
270: IF NOT QP_GLOBALS.Equal(p_SEG_rec.seeded_segment_name,p_old_SEG_rec.seeded_segment_name)
271: THEN
272: l_index := l_index + 1;
273: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_SEEDED_SEGMENT_NAME;
274: END IF;
275:
276: IF NOT QP_GLOBALS.Equal(p_SEG_rec.seeded_valueset_id,p_old_SEG_rec.seeded_valueset_id)
277: THEN

Line 279: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_SEEDED_VALUESET;

275:
276: IF NOT QP_GLOBALS.Equal(p_SEG_rec.seeded_valueset_id,p_old_SEG_rec.seeded_valueset_id)
277: THEN
278: l_index := l_index + 1;
279: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_SEEDED_VALUESET;
280: END IF;
281:
282: IF NOT QP_GLOBALS.Equal(p_SEG_rec.segment_code,p_old_SEG_rec.segment_code)
283: THEN

Line 285: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_SEGMENT_code;

281:
282: IF NOT QP_GLOBALS.Equal(p_SEG_rec.segment_code,p_old_SEG_rec.segment_code)
283: THEN
284: l_index := l_index + 1;
285: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_SEGMENT_code;
286: END IF;
287:
288: IF NOT QP_GLOBALS.Equal(p_SEG_rec.segment_id,p_old_SEG_rec.segment_id)
289: THEN

Line 291: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_SEGMENT;

287:
288: IF NOT QP_GLOBALS.Equal(p_SEG_rec.segment_id,p_old_SEG_rec.segment_id)
289: THEN
290: l_index := l_index + 1;
291: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_SEGMENT;
292: END IF;
293:
294: IF NOT QP_GLOBALS.Equal(p_SEG_rec.application_id,p_old_SEG_rec.application_id)
295: THEN

Line 297: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_APPLICATION_ID;

293:
294: IF NOT QP_GLOBALS.Equal(p_SEG_rec.application_id,p_old_SEG_rec.application_id)
295: THEN
296: l_index := l_index + 1;
297: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_APPLICATION_ID;
298: END IF;
299:
300: IF NOT QP_GLOBALS.Equal(p_SEG_rec.segment_mapping_column,p_old_SEG_rec.segment_mapping_column)
301: THEN

Line 303: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_SEGMENT_MAPPING_COLUMN;

299:
300: IF NOT QP_GLOBALS.Equal(p_SEG_rec.segment_mapping_column,p_old_SEG_rec.segment_mapping_column)
301: THEN
302: l_index := l_index + 1;
303: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_SEGMENT_MAPPING_COLUMN;
304: END IF;
305:
306: IF NOT QP_GLOBALS.Equal(p_SEG_rec.user_format_type,p_old_SEG_rec.user_format_type)
307: THEN

Line 309: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_USER_FORMAT_TYPE;

305:
306: IF NOT QP_GLOBALS.Equal(p_SEG_rec.user_format_type,p_old_SEG_rec.user_format_type)
307: THEN
308: l_index := l_index + 1;
309: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_USER_FORMAT_TYPE;
310: END IF;
311:
312: IF NOT QP_GLOBALS.Equal(p_SEG_rec.user_precedence,p_old_SEG_rec.user_precedence)
313: THEN

Line 315: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_USER_PRECEDENCE;

311:
312: IF NOT QP_GLOBALS.Equal(p_SEG_rec.user_precedence,p_old_SEG_rec.user_precedence)
313: THEN
314: l_index := l_index + 1;
315: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_USER_PRECEDENCE;
316: END IF;
317:
318: IF NOT QP_GLOBALS.Equal(p_SEG_rec.user_segment_name,p_old_SEG_rec.user_segment_name)
319: THEN

Line 321: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_USER_SEGMENT_NAME;

317:
318: IF NOT QP_GLOBALS.Equal(p_SEG_rec.user_segment_name,p_old_SEG_rec.user_segment_name)
319: THEN
320: l_index := l_index + 1;
321: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_USER_SEGMENT_NAME;
322: END IF;
323:
324: IF NOT QP_GLOBALS.Equal(p_SEG_rec.user_valueset_id,p_old_SEG_rec.user_valueset_id)
325: THEN

Line 327: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_USER_VALUESET;

323:
324: IF NOT QP_GLOBALS.Equal(p_SEG_rec.user_valueset_id,p_old_SEG_rec.user_valueset_id)
325: THEN
326: l_index := l_index + 1;
327: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_USER_VALUESET;
328: END IF;
329:
330: IF NOT QP_GLOBALS.Equal(p_SEG_rec.required_flag,p_old_SEG_rec.required_flag)
331: THEN

Line 333: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_REQUIRED_FLAG;

329:
330: IF NOT QP_GLOBALS.Equal(p_SEG_rec.required_flag,p_old_SEG_rec.required_flag)
331: THEN
332: l_index := l_index + 1;
333: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_REQUIRED_FLAG;
334: END IF;
335: -- Added for TCA
336: IF NOT QP_GLOBALS.Equal(p_SEG_rec.party_hierarchy_enabled_flag,p_old_SEG_rec.party_hierarchy_enabled_flag)
337: THEN

Line 339: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_PARTY_HIERARCHY_ENABLED_FLAG;

335: -- Added for TCA
336: IF NOT QP_GLOBALS.Equal(p_SEG_rec.party_hierarchy_enabled_flag,p_old_SEG_rec.party_hierarchy_enabled_flag)
337: THEN
338: l_index := l_index + 1;
339: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_PARTY_HIERARCHY_ENABLED_FLAG;
340: END IF;
341:
342: ELSIF p_attr_id = G_ATTRIBUTE1 THEN
343: l_index := l_index + 1;

Line 344: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE1;

340: END IF;
341:
342: ELSIF p_attr_id = G_ATTRIBUTE1 THEN
343: l_index := l_index + 1;
344: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE1;
345: ELSIF p_attr_id = G_ATTRIBUTE10 THEN
346: l_index := l_index + 1;
347: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE10;
348: ELSIF p_attr_id = G_ATTRIBUTE11 THEN

Line 347: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE10;

343: l_index := l_index + 1;
344: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE1;
345: ELSIF p_attr_id = G_ATTRIBUTE10 THEN
346: l_index := l_index + 1;
347: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE10;
348: ELSIF p_attr_id = G_ATTRIBUTE11 THEN
349: l_index := l_index + 1;
350: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE11;
351: ELSIF p_attr_id = G_ATTRIBUTE12 THEN

Line 350: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE11;

346: l_index := l_index + 1;
347: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE10;
348: ELSIF p_attr_id = G_ATTRIBUTE11 THEN
349: l_index := l_index + 1;
350: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE11;
351: ELSIF p_attr_id = G_ATTRIBUTE12 THEN
352: l_index := l_index + 1;
353: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE12;
354: ELSIF p_attr_id = G_ATTRIBUTE13 THEN

Line 353: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE12;

349: l_index := l_index + 1;
350: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE11;
351: ELSIF p_attr_id = G_ATTRIBUTE12 THEN
352: l_index := l_index + 1;
353: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE12;
354: ELSIF p_attr_id = G_ATTRIBUTE13 THEN
355: l_index := l_index + 1;
356: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE13;
357: ELSIF p_attr_id = G_ATTRIBUTE14 THEN

Line 356: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE13;

352: l_index := l_index + 1;
353: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE12;
354: ELSIF p_attr_id = G_ATTRIBUTE13 THEN
355: l_index := l_index + 1;
356: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE13;
357: ELSIF p_attr_id = G_ATTRIBUTE14 THEN
358: l_index := l_index + 1;
359: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE14;
360: ELSIF p_attr_id = G_ATTRIBUTE15 THEN

Line 359: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE14;

355: l_index := l_index + 1;
356: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE13;
357: ELSIF p_attr_id = G_ATTRIBUTE14 THEN
358: l_index := l_index + 1;
359: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE14;
360: ELSIF p_attr_id = G_ATTRIBUTE15 THEN
361: l_index := l_index + 1;
362: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE15;
363: ELSIF p_attr_id = G_ATTRIBUTE2 THEN

Line 362: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE15;

358: l_index := l_index + 1;
359: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE14;
360: ELSIF p_attr_id = G_ATTRIBUTE15 THEN
361: l_index := l_index + 1;
362: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE15;
363: ELSIF p_attr_id = G_ATTRIBUTE2 THEN
364: l_index := l_index + 1;
365: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE2;
366: ELSIF p_attr_id = G_ATTRIBUTE3 THEN

Line 365: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE2;

361: l_index := l_index + 1;
362: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE15;
363: ELSIF p_attr_id = G_ATTRIBUTE2 THEN
364: l_index := l_index + 1;
365: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE2;
366: ELSIF p_attr_id = G_ATTRIBUTE3 THEN
367: l_index := l_index + 1;
368: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE3;
369: ELSIF p_attr_id = G_ATTRIBUTE4 THEN

Line 368: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE3;

364: l_index := l_index + 1;
365: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE2;
366: ELSIF p_attr_id = G_ATTRIBUTE3 THEN
367: l_index := l_index + 1;
368: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE3;
369: ELSIF p_attr_id = G_ATTRIBUTE4 THEN
370: l_index := l_index + 1;
371: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE4;
372: ELSIF p_attr_id = G_ATTRIBUTE5 THEN

Line 371: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE4;

367: l_index := l_index + 1;
368: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE3;
369: ELSIF p_attr_id = G_ATTRIBUTE4 THEN
370: l_index := l_index + 1;
371: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE4;
372: ELSIF p_attr_id = G_ATTRIBUTE5 THEN
373: l_index := l_index + 1;
374: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE5;
375: ELSIF p_attr_id = G_ATTRIBUTE6 THEN

Line 374: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE5;

370: l_index := l_index + 1;
371: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE4;
372: ELSIF p_attr_id = G_ATTRIBUTE5 THEN
373: l_index := l_index + 1;
374: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE5;
375: ELSIF p_attr_id = G_ATTRIBUTE6 THEN
376: l_index := l_index + 1;
377: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE6;
378: ELSIF p_attr_id = G_ATTRIBUTE7 THEN

Line 377: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE6;

373: l_index := l_index + 1;
374: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE5;
375: ELSIF p_attr_id = G_ATTRIBUTE6 THEN
376: l_index := l_index + 1;
377: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE6;
378: ELSIF p_attr_id = G_ATTRIBUTE7 THEN
379: l_index := l_index + 1;
380: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE7;
381: ELSIF p_attr_id = G_ATTRIBUTE8 THEN

Line 380: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE7;

376: l_index := l_index + 1;
377: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE6;
378: ELSIF p_attr_id = G_ATTRIBUTE7 THEN
379: l_index := l_index + 1;
380: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE7;
381: ELSIF p_attr_id = G_ATTRIBUTE8 THEN
382: l_index := l_index + 1;
383: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE8;
384: ELSIF p_attr_id = G_ATTRIBUTE9 THEN

Line 383: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE8;

379: l_index := l_index + 1;
380: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE7;
381: ELSIF p_attr_id = G_ATTRIBUTE8 THEN
382: l_index := l_index + 1;
383: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE8;
384: ELSIF p_attr_id = G_ATTRIBUTE9 THEN
385: l_index := l_index + 1;
386: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE9;
387: ELSIF p_attr_id = G_AVAILABILITY_IN_BASIC THEN

Line 386: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE9;

382: l_index := l_index + 1;
383: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE8;
384: ELSIF p_attr_id = G_ATTRIBUTE9 THEN
385: l_index := l_index + 1;
386: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE9;
387: ELSIF p_attr_id = G_AVAILABILITY_IN_BASIC THEN
388: l_index := l_index + 1;
389: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_AVAILABILITY_IN_BASIC;
390: ELSIF p_attr_id = G_CONTEXT THEN

Line 389: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_AVAILABILITY_IN_BASIC;

385: l_index := l_index + 1;
386: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE9;
387: ELSIF p_attr_id = G_AVAILABILITY_IN_BASIC THEN
388: l_index := l_index + 1;
389: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_AVAILABILITY_IN_BASIC;
390: ELSIF p_attr_id = G_CONTEXT THEN
391: l_index := l_index + 1;
392: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_CONTEXT;
393: ELSIF p_attr_id = G_CREATED_BY THEN

Line 392: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_CONTEXT;

388: l_index := l_index + 1;
389: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_AVAILABILITY_IN_BASIC;
390: ELSIF p_attr_id = G_CONTEXT THEN
391: l_index := l_index + 1;
392: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_CONTEXT;
393: ELSIF p_attr_id = G_CREATED_BY THEN
394: l_index := l_index + 1;
395: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_CREATED_BY;
396: ELSIF p_attr_id = G_CREATION_DATE THEN

Line 395: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_CREATED_BY;

391: l_index := l_index + 1;
392: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_CONTEXT;
393: ELSIF p_attr_id = G_CREATED_BY THEN
394: l_index := l_index + 1;
395: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_CREATED_BY;
396: ELSIF p_attr_id = G_CREATION_DATE THEN
397: l_index := l_index + 1;
398: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_CREATION_DATE;
399: ELSIF p_attr_id = G_LAST_UPDATED_BY THEN

Line 398: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_CREATION_DATE;

394: l_index := l_index + 1;
395: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_CREATED_BY;
396: ELSIF p_attr_id = G_CREATION_DATE THEN
397: l_index := l_index + 1;
398: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_CREATION_DATE;
399: ELSIF p_attr_id = G_LAST_UPDATED_BY THEN
400: l_index := l_index + 1;
401: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_LAST_UPDATED_BY;
402: ELSIF p_attr_id = G_LAST_UPDATE_DATE THEN

Line 401: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_LAST_UPDATED_BY;

397: l_index := l_index + 1;
398: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_CREATION_DATE;
399: ELSIF p_attr_id = G_LAST_UPDATED_BY THEN
400: l_index := l_index + 1;
401: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_LAST_UPDATED_BY;
402: ELSIF p_attr_id = G_LAST_UPDATE_DATE THEN
403: l_index := l_index + 1;
404: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_LAST_UPDATE_DATE;
405: ELSIF p_attr_id = G_LAST_UPDATE_LOGIN THEN

Line 404: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_LAST_UPDATE_DATE;

400: l_index := l_index + 1;
401: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_LAST_UPDATED_BY;
402: ELSIF p_attr_id = G_LAST_UPDATE_DATE THEN
403: l_index := l_index + 1;
404: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_LAST_UPDATE_DATE;
405: ELSIF p_attr_id = G_LAST_UPDATE_LOGIN THEN
406: l_index := l_index + 1;
407: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_LAST_UPDATE_LOGIN;
408: ELSIF p_attr_id = G_PRC_CONTEXT THEN

Line 407: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_LAST_UPDATE_LOGIN;

403: l_index := l_index + 1;
404: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_LAST_UPDATE_DATE;
405: ELSIF p_attr_id = G_LAST_UPDATE_LOGIN THEN
406: l_index := l_index + 1;
407: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_LAST_UPDATE_LOGIN;
408: ELSIF p_attr_id = G_PRC_CONTEXT THEN
409: l_index := l_index + 1;
410: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_PRC_CONTEXT;
411: ELSIF p_attr_id = G_PROGRAM_APPLICATION THEN

Line 410: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_PRC_CONTEXT;

406: l_index := l_index + 1;
407: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_LAST_UPDATE_LOGIN;
408: ELSIF p_attr_id = G_PRC_CONTEXT THEN
409: l_index := l_index + 1;
410: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_PRC_CONTEXT;
411: ELSIF p_attr_id = G_PROGRAM_APPLICATION THEN
412: l_index := l_index + 1;
413: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_PROGRAM_APPLICATION;
414: ELSIF p_attr_id = G_PROGRAM THEN

Line 413: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_PROGRAM_APPLICATION;

409: l_index := l_index + 1;
410: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_PRC_CONTEXT;
411: ELSIF p_attr_id = G_PROGRAM_APPLICATION THEN
412: l_index := l_index + 1;
413: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_PROGRAM_APPLICATION;
414: ELSIF p_attr_id = G_PROGRAM THEN
415: l_index := l_index + 1;
416: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_PROGRAM;
417: ELSIF p_attr_id = G_PROGRAM_UPDATE_DATE THEN

Line 416: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_PROGRAM;

412: l_index := l_index + 1;
413: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_PROGRAM_APPLICATION;
414: ELSIF p_attr_id = G_PROGRAM THEN
415: l_index := l_index + 1;
416: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_PROGRAM;
417: ELSIF p_attr_id = G_PROGRAM_UPDATE_DATE THEN
418: l_index := l_index + 1;
419: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_PROGRAM_UPDATE_DATE;
420: ELSIF p_attr_id = G_SEEDED THEN

Line 419: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_PROGRAM_UPDATE_DATE;

415: l_index := l_index + 1;
416: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_PROGRAM;
417: ELSIF p_attr_id = G_PROGRAM_UPDATE_DATE THEN
418: l_index := l_index + 1;
419: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_PROGRAM_UPDATE_DATE;
420: ELSIF p_attr_id = G_SEEDED THEN
421: l_index := l_index + 1;
422: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_SEEDED;
423: ELSIF p_attr_id = G_SEEDED_FORMAT_TYPE THEN

Line 422: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_SEEDED;

418: l_index := l_index + 1;
419: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_PROGRAM_UPDATE_DATE;
420: ELSIF p_attr_id = G_SEEDED THEN
421: l_index := l_index + 1;
422: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_SEEDED;
423: ELSIF p_attr_id = G_SEEDED_FORMAT_TYPE THEN
424: l_index := l_index + 1;
425: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_SEEDED_FORMAT_TYPE;
426: ELSIF p_attr_id = G_SEEDED_PRECEDENCE THEN

Line 425: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_SEEDED_FORMAT_TYPE;

421: l_index := l_index + 1;
422: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_SEEDED;
423: ELSIF p_attr_id = G_SEEDED_FORMAT_TYPE THEN
424: l_index := l_index + 1;
425: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_SEEDED_FORMAT_TYPE;
426: ELSIF p_attr_id = G_SEEDED_PRECEDENCE THEN
427: l_index := l_index + 1;
428: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_SEEDED_PRECEDENCE;
429: ELSIF p_attr_id = G_SEEDED_SEGMENT_NAME THEN

Line 428: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_SEEDED_PRECEDENCE;

424: l_index := l_index + 1;
425: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_SEEDED_FORMAT_TYPE;
426: ELSIF p_attr_id = G_SEEDED_PRECEDENCE THEN
427: l_index := l_index + 1;
428: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_SEEDED_PRECEDENCE;
429: ELSIF p_attr_id = G_SEEDED_SEGMENT_NAME THEN
430: l_index := l_index + 1;
431: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_SEEDED_SEGMENT_NAME;
432: ELSIF p_attr_id = G_SEEDED_VALUESET THEN

Line 431: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_SEEDED_SEGMENT_NAME;

427: l_index := l_index + 1;
428: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_SEEDED_PRECEDENCE;
429: ELSIF p_attr_id = G_SEEDED_SEGMENT_NAME THEN
430: l_index := l_index + 1;
431: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_SEEDED_SEGMENT_NAME;
432: ELSIF p_attr_id = G_SEEDED_VALUESET THEN
433: l_index := l_index + 1;
434: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_SEEDED_VALUESET;
435: ELSIF p_attr_id = G_SEGMENT_code THEN

Line 434: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_SEEDED_VALUESET;

430: l_index := l_index + 1;
431: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_SEEDED_SEGMENT_NAME;
432: ELSIF p_attr_id = G_SEEDED_VALUESET THEN
433: l_index := l_index + 1;
434: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_SEEDED_VALUESET;
435: ELSIF p_attr_id = G_SEGMENT_code THEN
436: l_index := l_index + 1;
437: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_SEGMENT_code;
438: ELSIF p_attr_id = G_SEGMENT THEN

Line 437: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_SEGMENT_code;

433: l_index := l_index + 1;
434: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_SEEDED_VALUESET;
435: ELSIF p_attr_id = G_SEGMENT_code THEN
436: l_index := l_index + 1;
437: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_SEGMENT_code;
438: ELSIF p_attr_id = G_SEGMENT THEN
439: l_index := l_index + 1;
440: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_SEGMENT;
441: ELSIF p_attr_id = G_APPLICATION_ID THEN

Line 440: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_SEGMENT;

436: l_index := l_index + 1;
437: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_SEGMENT_code;
438: ELSIF p_attr_id = G_SEGMENT THEN
439: l_index := l_index + 1;
440: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_SEGMENT;
441: ELSIF p_attr_id = G_APPLICATION_ID THEN
442: l_index := l_index + 1;
443: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_APPLICATION_ID;
444: ELSIF p_attr_id = G_SEGMENT_MAPPING_COLUMN THEN

Line 443: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_APPLICATION_ID;

439: l_index := l_index + 1;
440: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_SEGMENT;
441: ELSIF p_attr_id = G_APPLICATION_ID THEN
442: l_index := l_index + 1;
443: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_APPLICATION_ID;
444: ELSIF p_attr_id = G_SEGMENT_MAPPING_COLUMN THEN
445: l_index := l_index + 1;
446: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_SEGMENT_MAPPING_COLUMN;
447: ELSIF p_attr_id = G_USER_FORMAT_TYPE THEN

Line 446: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_SEGMENT_MAPPING_COLUMN;

442: l_index := l_index + 1;
443: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_APPLICATION_ID;
444: ELSIF p_attr_id = G_SEGMENT_MAPPING_COLUMN THEN
445: l_index := l_index + 1;
446: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_SEGMENT_MAPPING_COLUMN;
447: ELSIF p_attr_id = G_USER_FORMAT_TYPE THEN
448: l_index := l_index + 1;
449: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_USER_FORMAT_TYPE;
450: ELSIF p_attr_id = G_USER_PRECEDENCE THEN

Line 449: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_USER_FORMAT_TYPE;

445: l_index := l_index + 1;
446: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_SEGMENT_MAPPING_COLUMN;
447: ELSIF p_attr_id = G_USER_FORMAT_TYPE THEN
448: l_index := l_index + 1;
449: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_USER_FORMAT_TYPE;
450: ELSIF p_attr_id = G_USER_PRECEDENCE THEN
451: l_index := l_index + 1;
452: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_USER_PRECEDENCE;
453: ELSIF p_attr_id = G_USER_SEGMENT_NAME THEN

Line 452: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_USER_PRECEDENCE;

448: l_index := l_index + 1;
449: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_USER_FORMAT_TYPE;
450: ELSIF p_attr_id = G_USER_PRECEDENCE THEN
451: l_index := l_index + 1;
452: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_USER_PRECEDENCE;
453: ELSIF p_attr_id = G_USER_SEGMENT_NAME THEN
454: l_index := l_index + 1;
455: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_USER_SEGMENT_NAME;
456: ELSIF p_attr_id = G_USER_VALUESET THEN

Line 455: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_USER_SEGMENT_NAME;

451: l_index := l_index + 1;
452: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_USER_PRECEDENCE;
453: ELSIF p_attr_id = G_USER_SEGMENT_NAME THEN
454: l_index := l_index + 1;
455: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_USER_SEGMENT_NAME;
456: ELSIF p_attr_id = G_USER_VALUESET THEN
457: l_index := l_index + 1;
458: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_USER_VALUESET;
459: ELSIF p_attr_id = G_SEEDED_DESCRIPTION THEN

Line 458: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_USER_VALUESET;

454: l_index := l_index + 1;
455: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_USER_SEGMENT_NAME;
456: ELSIF p_attr_id = G_USER_VALUESET THEN
457: l_index := l_index + 1;
458: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_USER_VALUESET;
459: ELSIF p_attr_id = G_SEEDED_DESCRIPTION THEN
460: l_index := l_index + 1;
461: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_SEEDED_DESCRIPTION;
462: ELSIF p_attr_id = G_USER_DESCRIPTION THEN

Line 461: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_SEEDED_DESCRIPTION;

457: l_index := l_index + 1;
458: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_USER_VALUESET;
459: ELSIF p_attr_id = G_SEEDED_DESCRIPTION THEN
460: l_index := l_index + 1;
461: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_SEEDED_DESCRIPTION;
462: ELSIF p_attr_id = G_USER_DESCRIPTION THEN
463: l_index := l_index + 1;
464: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_USER_DESCRIPTION;
465: ELSIF p_attr_id = G_REQUIRED_FLAG THEN

Line 464: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_USER_DESCRIPTION;

460: l_index := l_index + 1;
461: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_SEEDED_DESCRIPTION;
462: ELSIF p_attr_id = G_USER_DESCRIPTION THEN
463: l_index := l_index + 1;
464: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_USER_DESCRIPTION;
465: ELSIF p_attr_id = G_REQUIRED_FLAG THEN
466: l_index := l_index + 1;
467: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_REQUIRED_FLAG;
468: -- Added for TCA

Line 467: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_REQUIRED_FLAG;

463: l_index := l_index + 1;
464: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_USER_DESCRIPTION;
465: ELSIF p_attr_id = G_REQUIRED_FLAG THEN
466: l_index := l_index + 1;
467: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_REQUIRED_FLAG;
468: -- Added for TCA
469: ELSIF p_attr_id = G_PARTY_HIERARCHY_ENABLED_FLAG THEN
470: l_index := l_index + 1;
471: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_PARTY_HIERARCHY_ENABLED_FLAG;

Line 471: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_PARTY_HIERARCHY_ENABLED_FLAG;

467: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_REQUIRED_FLAG;
468: -- Added for TCA
469: ELSIF p_attr_id = G_PARTY_HIERARCHY_ENABLED_FLAG THEN
470: l_index := l_index + 1;
471: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_PARTY_HIERARCHY_ENABLED_FLAG;
472: END IF;
473:
474: END Clear_Dependent_Attr;
475:

Line 2181: END QP_Seg_Util;

2177: RETURN l_SEG_rec;
2178:
2179: END Get_Ids;
2180:
2181: END QP_Seg_Util;