DBA Data[Home] [Help]

APPS.QP_SEG_UTIL dependencies on QP_GLOBALS

Line 70: l_src_attr_tbl QP_GLOBALS.NUMBER_Tbl_Type;

66: , x_SEG_rec OUT NOCOPY /* file.sql.39 change */ QP_Attributes_PUB.Seg_Rec_Type
67: )
68: IS
69: l_index NUMBER := 0;
70: l_src_attr_tbl QP_GLOBALS.NUMBER_Tbl_Type;
71: l_dep_attr_tbl QP_GLOBALS.NUMBER_Tbl_Type;
72: BEGIN
73:
74: -- Load out record

Line 71: l_dep_attr_tbl QP_GLOBALS.NUMBER_Tbl_Type;

67: )
68: IS
69: l_index NUMBER := 0;
70: l_src_attr_tbl QP_GLOBALS.NUMBER_Tbl_Type;
71: l_dep_attr_tbl QP_GLOBALS.NUMBER_Tbl_Type;
72: BEGIN
73:
74: -- Load out record
75:

Line 83: IF NOT QP_GLOBALS.Equal(p_SEG_rec.attribute1,p_old_SEG_rec.attribute1)

79: -- every changed attribute clear its dependent fields.
80:
81: IF p_attr_id = FND_API.G_MISS_NUM THEN
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;

Line 89: IF NOT QP_GLOBALS.Equal(p_SEG_rec.attribute10,p_old_SEG_rec.attribute10)

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
91: l_index := l_index + 1;
92: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE10;
93: END IF;

Line 95: IF NOT QP_GLOBALS.Equal(p_SEG_rec.attribute11,p_old_SEG_rec.attribute11)

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
97: l_index := l_index + 1;
98: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE11;
99: END IF;

Line 101: IF NOT QP_GLOBALS.Equal(p_SEG_rec.attribute12,p_old_SEG_rec.attribute12)

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
103: l_index := l_index + 1;
104: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE12;
105: END IF;

Line 107: IF NOT QP_GLOBALS.Equal(p_SEG_rec.attribute13,p_old_SEG_rec.attribute13)

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
109: l_index := l_index + 1;
110: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE13;
111: END IF;

Line 113: IF NOT QP_GLOBALS.Equal(p_SEG_rec.attribute14,p_old_SEG_rec.attribute14)

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
115: l_index := l_index + 1;
116: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE14;
117: END IF;

Line 119: IF NOT QP_GLOBALS.Equal(p_SEG_rec.attribute15,p_old_SEG_rec.attribute15)

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
121: l_index := l_index + 1;
122: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE15;
123: END IF;

Line 125: IF NOT QP_GLOBALS.Equal(p_SEG_rec.attribute2,p_old_SEG_rec.attribute2)

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
127: l_index := l_index + 1;
128: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE2;
129: END IF;

Line 131: IF NOT QP_GLOBALS.Equal(p_SEG_rec.attribute3,p_old_SEG_rec.attribute3)

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
133: l_index := l_index + 1;
134: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE3;
135: END IF;

Line 137: IF NOT QP_GLOBALS.Equal(p_SEG_rec.attribute4,p_old_SEG_rec.attribute4)

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
139: l_index := l_index + 1;
140: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE4;
141: END IF;

Line 143: IF NOT QP_GLOBALS.Equal(p_SEG_rec.attribute5,p_old_SEG_rec.attribute5)

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
145: l_index := l_index + 1;
146: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE5;
147: END IF;

Line 149: IF NOT QP_GLOBALS.Equal(p_SEG_rec.attribute6,p_old_SEG_rec.attribute6)

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
151: l_index := l_index + 1;
152: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE6;
153: END IF;

Line 155: IF NOT QP_GLOBALS.Equal(p_SEG_rec.attribute7,p_old_SEG_rec.attribute7)

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
157: l_index := l_index + 1;
158: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE7;
159: END IF;

Line 161: IF NOT QP_GLOBALS.Equal(p_SEG_rec.attribute8,p_old_SEG_rec.attribute8)

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
163: l_index := l_index + 1;
164: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE8;
165: END IF;

Line 167: IF NOT QP_GLOBALS.Equal(p_SEG_rec.attribute9,p_old_SEG_rec.attribute9)

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
169: l_index := l_index + 1;
170: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_ATTRIBUTE9;
171: END IF;

Line 173: IF NOT QP_GLOBALS.Equal(p_SEG_rec.availability_in_basic,p_old_SEG_rec.availability_in_basic)

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
175: l_index := l_index + 1;
176: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_AVAILABILITY_IN_BASIC;
177: END IF;

Line 179: IF NOT QP_GLOBALS.Equal(p_SEG_rec.context,p_old_SEG_rec.context)

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
181: l_index := l_index + 1;
182: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_CONTEXT;
183: END IF;

Line 185: IF NOT QP_GLOBALS.Equal(p_SEG_rec.created_by,p_old_SEG_rec.created_by)

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
187: l_index := l_index + 1;
188: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_CREATED_BY;
189: END IF;

Line 191: IF NOT QP_GLOBALS.Equal(p_SEG_rec.creation_date,p_old_SEG_rec.creation_date)

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
193: l_index := l_index + 1;
194: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_CREATION_DATE;
195: END IF;

Line 197: IF NOT QP_GLOBALS.Equal(p_SEG_rec.last_updated_by,p_old_SEG_rec.last_updated_by)

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
199: l_index := l_index + 1;
200: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_LAST_UPDATED_BY;
201: END IF;

Line 203: IF NOT QP_GLOBALS.Equal(p_SEG_rec.last_update_date,p_old_SEG_rec.last_update_date)

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
205: l_index := l_index + 1;
206: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_LAST_UPDATE_DATE;
207: END IF;

Line 209: IF NOT QP_GLOBALS.Equal(p_SEG_rec.last_update_login,p_old_SEG_rec.last_update_login)

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
211: l_index := l_index + 1;
212: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_LAST_UPDATE_LOGIN;
213: END IF;

Line 215: IF NOT QP_GLOBALS.Equal(p_SEG_rec.prc_context_id,p_old_SEG_rec.prc_context_id)

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
217: l_index := l_index + 1;
218: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_PRC_CONTEXT;
219: END IF;

Line 221: IF NOT QP_GLOBALS.Equal(p_SEG_rec.program_application_id,p_old_SEG_rec.program_application_id)

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
223: l_index := l_index + 1;
224: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_PROGRAM_APPLICATION;
225: END IF;

Line 227: IF NOT QP_GLOBALS.Equal(p_SEG_rec.program_id,p_old_SEG_rec.program_id)

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
229: l_index := l_index + 1;
230: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_PROGRAM;
231: END IF;

Line 233: IF NOT QP_GLOBALS.Equal(p_SEG_rec.program_update_date,p_old_SEG_rec.program_update_date)

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
235: l_index := l_index + 1;
236: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_PROGRAM_UPDATE_DATE;
237: END IF;

Line 239: IF NOT QP_GLOBALS.Equal(p_SEG_rec.seeded_flag,p_old_SEG_rec.seeded_flag)

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
241: l_index := l_index + 1;
242: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_SEEDED;
243: END IF;

Line 245: IF NOT QP_GLOBALS.Equal(p_SEG_rec.seeded_format_type,p_old_SEG_rec.seeded_format_type)

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
247: l_index := l_index + 1;
248: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_SEEDED_FORMAT_TYPE;
249: END IF;

Line 251: IF NOT QP_GLOBALS.Equal(p_SEG_rec.seeded_precedence,p_old_SEG_rec.seeded_precedence)

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
253: l_index := l_index + 1;
254: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_SEEDED_PRECEDENCE;
255: END IF;

Line 258: IF NOT QP_GLOBALS.Equal( p_SEG_rec.seeded_description,p_old_SEG_rec.seeded_description)

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)
259: THEN
260: l_index := l_index + 1;
261: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_SEEDED_DESCRIPTION;
262: END IF;

Line 264: IF NOT QP_GLOBALS.Equal( p_SEG_rec.user_description,p_old_SEG_rec.user_description)

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
266: l_index := l_index + 1;
267: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_USER_DESCRIPTION;
268: END IF;

Line 270: IF NOT QP_GLOBALS.Equal(p_SEG_rec.seeded_segment_name,p_old_SEG_rec.seeded_segment_name)

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
272: l_index := l_index + 1;
273: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_SEEDED_SEGMENT_NAME;
274: END IF;

Line 276: IF NOT QP_GLOBALS.Equal(p_SEG_rec.seeded_valueset_id,p_old_SEG_rec.seeded_valueset_id)

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
278: l_index := l_index + 1;
279: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_SEEDED_VALUESET;
280: END IF;

Line 282: IF NOT QP_GLOBALS.Equal(p_SEG_rec.segment_code,p_old_SEG_rec.segment_code)

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
284: l_index := l_index + 1;
285: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_SEGMENT_code;
286: END IF;

Line 288: IF NOT QP_GLOBALS.Equal(p_SEG_rec.segment_id,p_old_SEG_rec.segment_id)

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
290: l_index := l_index + 1;
291: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_SEGMENT;
292: END IF;

Line 294: IF NOT QP_GLOBALS.Equal(p_SEG_rec.application_id,p_old_SEG_rec.application_id)

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
296: l_index := l_index + 1;
297: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_APPLICATION_ID;
298: END IF;

Line 300: IF NOT QP_GLOBALS.Equal(p_SEG_rec.segment_mapping_column,p_old_SEG_rec.segment_mapping_column)

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
302: l_index := l_index + 1;
303: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_SEGMENT_MAPPING_COLUMN;
304: END IF;

Line 306: IF NOT QP_GLOBALS.Equal(p_SEG_rec.user_format_type,p_old_SEG_rec.user_format_type)

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
308: l_index := l_index + 1;
309: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_USER_FORMAT_TYPE;
310: END IF;

Line 312: IF NOT QP_GLOBALS.Equal(p_SEG_rec.user_precedence,p_old_SEG_rec.user_precedence)

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
314: l_index := l_index + 1;
315: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_USER_PRECEDENCE;
316: END IF;

Line 318: IF NOT QP_GLOBALS.Equal(p_SEG_rec.user_segment_name,p_old_SEG_rec.user_segment_name)

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
320: l_index := l_index + 1;
321: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_USER_SEGMENT_NAME;
322: END IF;

Line 324: IF NOT QP_GLOBALS.Equal(p_SEG_rec.user_valueset_id,p_old_SEG_rec.user_valueset_id)

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
326: l_index := l_index + 1;
327: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_USER_VALUESET;
328: END IF;

Line 330: IF NOT QP_GLOBALS.Equal(p_SEG_rec.required_flag,p_old_SEG_rec.required_flag)

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
332: l_index := l_index + 1;
333: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_REQUIRED_FLAG;
334: END IF;

Line 336: IF NOT QP_GLOBALS.Equal(p_SEG_rec.party_hierarchy_enabled_flag,p_old_SEG_rec.party_hierarchy_enabled_flag)

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
338: l_index := l_index + 1;
339: l_src_attr_tbl(l_index) := QP_SEG_UTIL.G_PARTY_HIERARCHY_ENABLED_FLAG;
340: END IF;

Line 491: IF NOT QP_GLOBALS.Equal(p_SEG_rec.attribute1,p_old_SEG_rec.attribute1)

487: -- Load out record
488:
489: x_SEG_rec := p_SEG_rec;
490:
491: IF NOT QP_GLOBALS.Equal(p_SEG_rec.attribute1,p_old_SEG_rec.attribute1)
492: THEN
493: NULL;
494: END IF;
495:

Line 496: IF NOT QP_GLOBALS.Equal(p_SEG_rec.attribute10,p_old_SEG_rec.attribute10)

492: THEN
493: NULL;
494: END IF;
495:
496: IF NOT QP_GLOBALS.Equal(p_SEG_rec.attribute10,p_old_SEG_rec.attribute10)
497: THEN
498: NULL;
499: END IF;
500:

Line 501: IF NOT QP_GLOBALS.Equal(p_SEG_rec.attribute11,p_old_SEG_rec.attribute11)

497: THEN
498: NULL;
499: END IF;
500:
501: IF NOT QP_GLOBALS.Equal(p_SEG_rec.attribute11,p_old_SEG_rec.attribute11)
502: THEN
503: NULL;
504: END IF;
505:

Line 506: IF NOT QP_GLOBALS.Equal(p_SEG_rec.attribute12,p_old_SEG_rec.attribute12)

502: THEN
503: NULL;
504: END IF;
505:
506: IF NOT QP_GLOBALS.Equal(p_SEG_rec.attribute12,p_old_SEG_rec.attribute12)
507: THEN
508: NULL;
509: END IF;
510:

Line 511: IF NOT QP_GLOBALS.Equal(p_SEG_rec.attribute13,p_old_SEG_rec.attribute13)

507: THEN
508: NULL;
509: END IF;
510:
511: IF NOT QP_GLOBALS.Equal(p_SEG_rec.attribute13,p_old_SEG_rec.attribute13)
512: THEN
513: NULL;
514: END IF;
515:

Line 516: IF NOT QP_GLOBALS.Equal(p_SEG_rec.attribute14,p_old_SEG_rec.attribute14)

512: THEN
513: NULL;
514: END IF;
515:
516: IF NOT QP_GLOBALS.Equal(p_SEG_rec.attribute14,p_old_SEG_rec.attribute14)
517: THEN
518: NULL;
519: END IF;
520:

Line 521: IF NOT QP_GLOBALS.Equal(p_SEG_rec.attribute15,p_old_SEG_rec.attribute15)

517: THEN
518: NULL;
519: END IF;
520:
521: IF NOT QP_GLOBALS.Equal(p_SEG_rec.attribute15,p_old_SEG_rec.attribute15)
522: THEN
523: NULL;
524: END IF;
525:

Line 526: IF NOT QP_GLOBALS.Equal(p_SEG_rec.attribute2,p_old_SEG_rec.attribute2)

522: THEN
523: NULL;
524: END IF;
525:
526: IF NOT QP_GLOBALS.Equal(p_SEG_rec.attribute2,p_old_SEG_rec.attribute2)
527: THEN
528: NULL;
529: END IF;
530:

Line 531: IF NOT QP_GLOBALS.Equal(p_SEG_rec.attribute3,p_old_SEG_rec.attribute3)

527: THEN
528: NULL;
529: END IF;
530:
531: IF NOT QP_GLOBALS.Equal(p_SEG_rec.attribute3,p_old_SEG_rec.attribute3)
532: THEN
533: NULL;
534: END IF;
535:

Line 536: IF NOT QP_GLOBALS.Equal(p_SEG_rec.attribute4,p_old_SEG_rec.attribute4)

532: THEN
533: NULL;
534: END IF;
535:
536: IF NOT QP_GLOBALS.Equal(p_SEG_rec.attribute4,p_old_SEG_rec.attribute4)
537: THEN
538: NULL;
539: END IF;
540:

Line 541: IF NOT QP_GLOBALS.Equal(p_SEG_rec.attribute5,p_old_SEG_rec.attribute5)

537: THEN
538: NULL;
539: END IF;
540:
541: IF NOT QP_GLOBALS.Equal(p_SEG_rec.attribute5,p_old_SEG_rec.attribute5)
542: THEN
543: NULL;
544: END IF;
545:

Line 546: IF NOT QP_GLOBALS.Equal(p_SEG_rec.attribute6,p_old_SEG_rec.attribute6)

542: THEN
543: NULL;
544: END IF;
545:
546: IF NOT QP_GLOBALS.Equal(p_SEG_rec.attribute6,p_old_SEG_rec.attribute6)
547: THEN
548: NULL;
549: END IF;
550:

Line 551: IF NOT QP_GLOBALS.Equal(p_SEG_rec.attribute7,p_old_SEG_rec.attribute7)

547: THEN
548: NULL;
549: END IF;
550:
551: IF NOT QP_GLOBALS.Equal(p_SEG_rec.attribute7,p_old_SEG_rec.attribute7)
552: THEN
553: NULL;
554: END IF;
555:

Line 556: IF NOT QP_GLOBALS.Equal(p_SEG_rec.attribute8,p_old_SEG_rec.attribute8)

552: THEN
553: NULL;
554: END IF;
555:
556: IF NOT QP_GLOBALS.Equal(p_SEG_rec.attribute8,p_old_SEG_rec.attribute8)
557: THEN
558: NULL;
559: END IF;
560:

Line 561: IF NOT QP_GLOBALS.Equal(p_SEG_rec.attribute9,p_old_SEG_rec.attribute9)

557: THEN
558: NULL;
559: END IF;
560:
561: IF NOT QP_GLOBALS.Equal(p_SEG_rec.attribute9,p_old_SEG_rec.attribute9)
562: THEN
563: NULL;
564: END IF;
565:

Line 566: IF NOT QP_GLOBALS.Equal(p_SEG_rec.availability_in_basic,p_old_SEG_rec.availability_in_basic)

562: THEN
563: NULL;
564: END IF;
565:
566: IF NOT QP_GLOBALS.Equal(p_SEG_rec.availability_in_basic,p_old_SEG_rec.availability_in_basic)
567: THEN
568: NULL;
569: END IF;
570:

Line 571: IF NOT QP_GLOBALS.Equal(p_SEG_rec.context,p_old_SEG_rec.context)

567: THEN
568: NULL;
569: END IF;
570:
571: IF NOT QP_GLOBALS.Equal(p_SEG_rec.context,p_old_SEG_rec.context)
572: THEN
573: NULL;
574: END IF;
575:

Line 576: IF NOT QP_GLOBALS.Equal(p_SEG_rec.created_by,p_old_SEG_rec.created_by)

572: THEN
573: NULL;
574: END IF;
575:
576: IF NOT QP_GLOBALS.Equal(p_SEG_rec.created_by,p_old_SEG_rec.created_by)
577: THEN
578: NULL;
579: END IF;
580:

Line 581: IF NOT QP_GLOBALS.Equal(p_SEG_rec.creation_date,p_old_SEG_rec.creation_date)

577: THEN
578: NULL;
579: END IF;
580:
581: IF NOT QP_GLOBALS.Equal(p_SEG_rec.creation_date,p_old_SEG_rec.creation_date)
582: THEN
583: NULL;
584: END IF;
585:

Line 586: IF NOT QP_GLOBALS.Equal(p_SEG_rec.last_updated_by,p_old_SEG_rec.last_updated_by)

582: THEN
583: NULL;
584: END IF;
585:
586: IF NOT QP_GLOBALS.Equal(p_SEG_rec.last_updated_by,p_old_SEG_rec.last_updated_by)
587: THEN
588: NULL;
589: END IF;
590:

Line 591: IF NOT QP_GLOBALS.Equal(p_SEG_rec.last_update_date,p_old_SEG_rec.last_update_date)

587: THEN
588: NULL;
589: END IF;
590:
591: IF NOT QP_GLOBALS.Equal(p_SEG_rec.last_update_date,p_old_SEG_rec.last_update_date)
592: THEN
593: NULL;
594: END IF;
595:

Line 596: IF NOT QP_GLOBALS.Equal(p_SEG_rec.last_update_login,p_old_SEG_rec.last_update_login)

592: THEN
593: NULL;
594: END IF;
595:
596: IF NOT QP_GLOBALS.Equal(p_SEG_rec.last_update_login,p_old_SEG_rec.last_update_login)
597: THEN
598: NULL;
599: END IF;
600:

Line 601: IF NOT QP_GLOBALS.Equal(p_SEG_rec.prc_context_id,p_old_SEG_rec.prc_context_id)

597: THEN
598: NULL;
599: END IF;
600:
601: IF NOT QP_GLOBALS.Equal(p_SEG_rec.prc_context_id,p_old_SEG_rec.prc_context_id)
602: THEN
603: NULL;
604: END IF;
605:

Line 606: IF NOT QP_GLOBALS.Equal(p_SEG_rec.program_application_id,p_old_SEG_rec.program_application_id)

602: THEN
603: NULL;
604: END IF;
605:
606: IF NOT QP_GLOBALS.Equal(p_SEG_rec.program_application_id,p_old_SEG_rec.program_application_id)
607: THEN
608: NULL;
609: END IF;
610:

Line 611: IF NOT QP_GLOBALS.Equal(p_SEG_rec.program_id,p_old_SEG_rec.program_id)

607: THEN
608: NULL;
609: END IF;
610:
611: IF NOT QP_GLOBALS.Equal(p_SEG_rec.program_id,p_old_SEG_rec.program_id)
612: THEN
613: NULL;
614: END IF;
615:

Line 616: IF NOT QP_GLOBALS.Equal(p_SEG_rec.program_update_date,p_old_SEG_rec.program_update_date)

612: THEN
613: NULL;
614: END IF;
615:
616: IF NOT QP_GLOBALS.Equal(p_SEG_rec.program_update_date,p_old_SEG_rec.program_update_date)
617: THEN
618: NULL;
619: END IF;
620:

Line 621: IF NOT QP_GLOBALS.Equal(p_SEG_rec.seeded_flag,p_old_SEG_rec.seeded_flag)

617: THEN
618: NULL;
619: END IF;
620:
621: IF NOT QP_GLOBALS.Equal(p_SEG_rec.seeded_flag,p_old_SEG_rec.seeded_flag)
622: THEN
623: NULL;
624: END IF;
625:

Line 626: IF NOT QP_GLOBALS.Equal(p_SEG_rec.seeded_format_type,p_old_SEG_rec.seeded_format_type)

622: THEN
623: NULL;
624: END IF;
625:
626: IF NOT QP_GLOBALS.Equal(p_SEG_rec.seeded_format_type,p_old_SEG_rec.seeded_format_type)
627: THEN
628: NULL;
629: END IF;
630:

Line 631: IF NOT QP_GLOBALS.Equal(p_SEG_rec.seeded_precedence,p_old_SEG_rec.seeded_precedence)

627: THEN
628: NULL;
629: END IF;
630:
631: IF NOT QP_GLOBALS.Equal(p_SEG_rec.seeded_precedence,p_old_SEG_rec.seeded_precedence)
632: THEN
633: NULL;
634: END IF;
635:

Line 636: IF NOT QP_GLOBALS.Equal(p_SEG_rec.seeded_segment_name,p_old_SEG_rec.seeded_segment_name)

632: THEN
633: NULL;
634: END IF;
635:
636: IF NOT QP_GLOBALS.Equal(p_SEG_rec.seeded_segment_name,p_old_SEG_rec.seeded_segment_name)
637: THEN
638: NULL;
639: END IF;
640:

Line 641: IF NOT QP_GLOBALS.Equal( p_SEG_rec.seeded_description,p_old_SEG_rec.seeded_description)

637: THEN
638: NULL;
639: END IF;
640:
641: IF NOT QP_GLOBALS.Equal( p_SEG_rec.seeded_description,p_old_SEG_rec.seeded_description)
642: THEN
643: NULL;
644: END IF;
645:

Line 646: IF NOT QP_GLOBALS.Equal( p_SEG_rec.user_description,p_old_SEG_rec.user_description)

642: THEN
643: NULL;
644: END IF;
645:
646: IF NOT QP_GLOBALS.Equal( p_SEG_rec.user_description,p_old_SEG_rec.user_description)
647: THEN
648: NULL;
649: END IF;
650:

Line 651: IF NOT QP_GLOBALS.Equal(p_SEG_rec.seeded_valueset_id,p_old_SEG_rec.seeded_valueset_id)

647: THEN
648: NULL;
649: END IF;
650:
651: IF NOT QP_GLOBALS.Equal(p_SEG_rec.seeded_valueset_id,p_old_SEG_rec.seeded_valueset_id)
652: THEN
653: NULL;
654: END IF;
655:

Line 656: IF NOT QP_GLOBALS.Equal(p_SEG_rec.segment_code,p_old_SEG_rec.segment_code)

652: THEN
653: NULL;
654: END IF;
655:
656: IF NOT QP_GLOBALS.Equal(p_SEG_rec.segment_code,p_old_SEG_rec.segment_code)
657: THEN
658: NULL;
659: END IF;
660:

Line 661: IF NOT QP_GLOBALS.Equal(p_SEG_rec.segment_id,p_old_SEG_rec.segment_id)

657: THEN
658: NULL;
659: END IF;
660:
661: IF NOT QP_GLOBALS.Equal(p_SEG_rec.segment_id,p_old_SEG_rec.segment_id)
662: THEN
663: NULL;
664: END IF;
665:

Line 666: IF NOT QP_GLOBALS.Equal(p_SEG_rec.application_id,p_old_SEG_rec.application_id)

662: THEN
663: NULL;
664: END IF;
665:
666: IF NOT QP_GLOBALS.Equal(p_SEG_rec.application_id,p_old_SEG_rec.application_id)
667: THEN
668: NULL;
669: END IF;
670:

Line 671: IF NOT QP_GLOBALS.Equal(p_SEG_rec.segment_mapping_column,p_old_SEG_rec.segment_mapping_column)

667: THEN
668: NULL;
669: END IF;
670:
671: IF NOT QP_GLOBALS.Equal(p_SEG_rec.segment_mapping_column,p_old_SEG_rec.segment_mapping_column)
672: THEN
673: NULL;
674: END IF;
675:

Line 676: IF NOT QP_GLOBALS.Equal(p_SEG_rec.user_format_type,p_old_SEG_rec.user_format_type)

672: THEN
673: NULL;
674: END IF;
675:
676: IF NOT QP_GLOBALS.Equal(p_SEG_rec.user_format_type,p_old_SEG_rec.user_format_type)
677: THEN
678: NULL;
679: END IF;
680:

Line 681: IF NOT QP_GLOBALS.Equal(p_SEG_rec.user_precedence,p_old_SEG_rec.user_precedence)

677: THEN
678: NULL;
679: END IF;
680:
681: IF NOT QP_GLOBALS.Equal(p_SEG_rec.user_precedence,p_old_SEG_rec.user_precedence)
682: THEN
683: NULL;
684: END IF;
685:

Line 686: IF NOT QP_GLOBALS.Equal(p_SEG_rec.user_segment_name,p_old_SEG_rec.user_segment_name)

682: THEN
683: NULL;
684: END IF;
685:
686: IF NOT QP_GLOBALS.Equal(p_SEG_rec.user_segment_name,p_old_SEG_rec.user_segment_name)
687: THEN
688: NULL;
689: END IF;
690:

Line 691: IF NOT QP_GLOBALS.Equal(p_SEG_rec.user_valueset_id,p_old_SEG_rec.user_valueset_id)

687: THEN
688: NULL;
689: END IF;
690:
691: IF NOT QP_GLOBALS.Equal(p_SEG_rec.user_valueset_id,p_old_SEG_rec.user_valueset_id)
692: THEN
693: NULL;
694: END IF;
695:

Line 696: IF NOT QP_GLOBALS.Equal(p_SEG_rec.required_flag,p_old_SEG_rec.required_flag)

692: THEN
693: NULL;
694: END IF;
695:
696: IF NOT QP_GLOBALS.Equal(p_SEG_rec.required_flag,p_old_SEG_rec.required_flag)
697: THEN
698: NULL;
699: END IF;
700: --Added for TCA

Line 701: IF NOT QP_GLOBALS.Equal(p_SEG_rec.party_hierarchy_enabled_flag,p_old_SEG_rec.party_hierarchy_enabled_flag)

697: THEN
698: NULL;
699: END IF;
700: --Added for TCA
701: IF NOT QP_GLOBALS.Equal(p_SEG_rec.party_hierarchy_enabled_flag,p_old_SEG_rec.party_hierarchy_enabled_flag)
702: THEN
703: NULL;
704: END IF;
705: END Apply_Attribute_Changes;

Line 1787: IF QP_GLOBALS.Equal(p_SEG_rec.attribute1,

1783: FOR UPDATE NOWAIT;
1784:
1785: -- Row locked. Compare IN attributes to DB attributes.
1786:
1787: IF QP_GLOBALS.Equal(p_SEG_rec.attribute1,
1788: l_SEG_rec.attribute1)
1789: AND QP_GLOBALS.Equal(p_SEG_rec.attribute10,
1790: l_SEG_rec.attribute10)
1791: AND QP_GLOBALS.Equal(p_SEG_rec.attribute11,

Line 1789: AND QP_GLOBALS.Equal(p_SEG_rec.attribute10,

1785: -- Row locked. Compare IN attributes to DB attributes.
1786:
1787: IF QP_GLOBALS.Equal(p_SEG_rec.attribute1,
1788: l_SEG_rec.attribute1)
1789: AND QP_GLOBALS.Equal(p_SEG_rec.attribute10,
1790: l_SEG_rec.attribute10)
1791: AND QP_GLOBALS.Equal(p_SEG_rec.attribute11,
1792: l_SEG_rec.attribute11)
1793: AND QP_GLOBALS.Equal(p_SEG_rec.attribute12,

Line 1791: AND QP_GLOBALS.Equal(p_SEG_rec.attribute11,

1787: IF QP_GLOBALS.Equal(p_SEG_rec.attribute1,
1788: l_SEG_rec.attribute1)
1789: AND QP_GLOBALS.Equal(p_SEG_rec.attribute10,
1790: l_SEG_rec.attribute10)
1791: AND QP_GLOBALS.Equal(p_SEG_rec.attribute11,
1792: l_SEG_rec.attribute11)
1793: AND QP_GLOBALS.Equal(p_SEG_rec.attribute12,
1794: l_SEG_rec.attribute12)
1795: AND QP_GLOBALS.Equal(p_SEG_rec.attribute13,

Line 1793: AND QP_GLOBALS.Equal(p_SEG_rec.attribute12,

1789: AND QP_GLOBALS.Equal(p_SEG_rec.attribute10,
1790: l_SEG_rec.attribute10)
1791: AND QP_GLOBALS.Equal(p_SEG_rec.attribute11,
1792: l_SEG_rec.attribute11)
1793: AND QP_GLOBALS.Equal(p_SEG_rec.attribute12,
1794: l_SEG_rec.attribute12)
1795: AND QP_GLOBALS.Equal(p_SEG_rec.attribute13,
1796: l_SEG_rec.attribute13)
1797: AND QP_GLOBALS.Equal(p_SEG_rec.attribute14,

Line 1795: AND QP_GLOBALS.Equal(p_SEG_rec.attribute13,

1791: AND QP_GLOBALS.Equal(p_SEG_rec.attribute11,
1792: l_SEG_rec.attribute11)
1793: AND QP_GLOBALS.Equal(p_SEG_rec.attribute12,
1794: l_SEG_rec.attribute12)
1795: AND QP_GLOBALS.Equal(p_SEG_rec.attribute13,
1796: l_SEG_rec.attribute13)
1797: AND QP_GLOBALS.Equal(p_SEG_rec.attribute14,
1798: l_SEG_rec.attribute14)
1799: AND QP_GLOBALS.Equal(p_SEG_rec.attribute15,

Line 1797: AND QP_GLOBALS.Equal(p_SEG_rec.attribute14,

1793: AND QP_GLOBALS.Equal(p_SEG_rec.attribute12,
1794: l_SEG_rec.attribute12)
1795: AND QP_GLOBALS.Equal(p_SEG_rec.attribute13,
1796: l_SEG_rec.attribute13)
1797: AND QP_GLOBALS.Equal(p_SEG_rec.attribute14,
1798: l_SEG_rec.attribute14)
1799: AND QP_GLOBALS.Equal(p_SEG_rec.attribute15,
1800: l_SEG_rec.attribute15)
1801: AND QP_GLOBALS.Equal(p_SEG_rec.attribute2,

Line 1799: AND QP_GLOBALS.Equal(p_SEG_rec.attribute15,

1795: AND QP_GLOBALS.Equal(p_SEG_rec.attribute13,
1796: l_SEG_rec.attribute13)
1797: AND QP_GLOBALS.Equal(p_SEG_rec.attribute14,
1798: l_SEG_rec.attribute14)
1799: AND QP_GLOBALS.Equal(p_SEG_rec.attribute15,
1800: l_SEG_rec.attribute15)
1801: AND QP_GLOBALS.Equal(p_SEG_rec.attribute2,
1802: l_SEG_rec.attribute2)
1803: AND QP_GLOBALS.Equal(p_SEG_rec.attribute3,

Line 1801: AND QP_GLOBALS.Equal(p_SEG_rec.attribute2,

1797: AND QP_GLOBALS.Equal(p_SEG_rec.attribute14,
1798: l_SEG_rec.attribute14)
1799: AND QP_GLOBALS.Equal(p_SEG_rec.attribute15,
1800: l_SEG_rec.attribute15)
1801: AND QP_GLOBALS.Equal(p_SEG_rec.attribute2,
1802: l_SEG_rec.attribute2)
1803: AND QP_GLOBALS.Equal(p_SEG_rec.attribute3,
1804: l_SEG_rec.attribute3)
1805: AND QP_GLOBALS.Equal(p_SEG_rec.attribute4,

Line 1803: AND QP_GLOBALS.Equal(p_SEG_rec.attribute3,

1799: AND QP_GLOBALS.Equal(p_SEG_rec.attribute15,
1800: l_SEG_rec.attribute15)
1801: AND QP_GLOBALS.Equal(p_SEG_rec.attribute2,
1802: l_SEG_rec.attribute2)
1803: AND QP_GLOBALS.Equal(p_SEG_rec.attribute3,
1804: l_SEG_rec.attribute3)
1805: AND QP_GLOBALS.Equal(p_SEG_rec.attribute4,
1806: l_SEG_rec.attribute4)
1807: AND QP_GLOBALS.Equal(p_SEG_rec.attribute5,

Line 1805: AND QP_GLOBALS.Equal(p_SEG_rec.attribute4,

1801: AND QP_GLOBALS.Equal(p_SEG_rec.attribute2,
1802: l_SEG_rec.attribute2)
1803: AND QP_GLOBALS.Equal(p_SEG_rec.attribute3,
1804: l_SEG_rec.attribute3)
1805: AND QP_GLOBALS.Equal(p_SEG_rec.attribute4,
1806: l_SEG_rec.attribute4)
1807: AND QP_GLOBALS.Equal(p_SEG_rec.attribute5,
1808: l_SEG_rec.attribute5)
1809: AND QP_GLOBALS.Equal(p_SEG_rec.attribute6,

Line 1807: AND QP_GLOBALS.Equal(p_SEG_rec.attribute5,

1803: AND QP_GLOBALS.Equal(p_SEG_rec.attribute3,
1804: l_SEG_rec.attribute3)
1805: AND QP_GLOBALS.Equal(p_SEG_rec.attribute4,
1806: l_SEG_rec.attribute4)
1807: AND QP_GLOBALS.Equal(p_SEG_rec.attribute5,
1808: l_SEG_rec.attribute5)
1809: AND QP_GLOBALS.Equal(p_SEG_rec.attribute6,
1810: l_SEG_rec.attribute6)
1811: AND QP_GLOBALS.Equal(p_SEG_rec.attribute7,

Line 1809: AND QP_GLOBALS.Equal(p_SEG_rec.attribute6,

1805: AND QP_GLOBALS.Equal(p_SEG_rec.attribute4,
1806: l_SEG_rec.attribute4)
1807: AND QP_GLOBALS.Equal(p_SEG_rec.attribute5,
1808: l_SEG_rec.attribute5)
1809: AND QP_GLOBALS.Equal(p_SEG_rec.attribute6,
1810: l_SEG_rec.attribute6)
1811: AND QP_GLOBALS.Equal(p_SEG_rec.attribute7,
1812: l_SEG_rec.attribute7)
1813: AND QP_GLOBALS.Equal(p_SEG_rec.attribute8,

Line 1811: AND QP_GLOBALS.Equal(p_SEG_rec.attribute7,

1807: AND QP_GLOBALS.Equal(p_SEG_rec.attribute5,
1808: l_SEG_rec.attribute5)
1809: AND QP_GLOBALS.Equal(p_SEG_rec.attribute6,
1810: l_SEG_rec.attribute6)
1811: AND QP_GLOBALS.Equal(p_SEG_rec.attribute7,
1812: l_SEG_rec.attribute7)
1813: AND QP_GLOBALS.Equal(p_SEG_rec.attribute8,
1814: l_SEG_rec.attribute8)
1815: AND QP_GLOBALS.Equal(p_SEG_rec.attribute9,

Line 1813: AND QP_GLOBALS.Equal(p_SEG_rec.attribute8,

1809: AND QP_GLOBALS.Equal(p_SEG_rec.attribute6,
1810: l_SEG_rec.attribute6)
1811: AND QP_GLOBALS.Equal(p_SEG_rec.attribute7,
1812: l_SEG_rec.attribute7)
1813: AND QP_GLOBALS.Equal(p_SEG_rec.attribute8,
1814: l_SEG_rec.attribute8)
1815: AND QP_GLOBALS.Equal(p_SEG_rec.attribute9,
1816: l_SEG_rec.attribute9)
1817: AND QP_GLOBALS.Equal(p_SEG_rec.availability_in_basic,

Line 1815: AND QP_GLOBALS.Equal(p_SEG_rec.attribute9,

1811: AND QP_GLOBALS.Equal(p_SEG_rec.attribute7,
1812: l_SEG_rec.attribute7)
1813: AND QP_GLOBALS.Equal(p_SEG_rec.attribute8,
1814: l_SEG_rec.attribute8)
1815: AND QP_GLOBALS.Equal(p_SEG_rec.attribute9,
1816: l_SEG_rec.attribute9)
1817: AND QP_GLOBALS.Equal(p_SEG_rec.availability_in_basic,
1818: l_SEG_rec.availability_in_basic)
1819: AND QP_GLOBALS.Equal(p_SEG_rec.context,

Line 1817: AND QP_GLOBALS.Equal(p_SEG_rec.availability_in_basic,

1813: AND QP_GLOBALS.Equal(p_SEG_rec.attribute8,
1814: l_SEG_rec.attribute8)
1815: AND QP_GLOBALS.Equal(p_SEG_rec.attribute9,
1816: l_SEG_rec.attribute9)
1817: AND QP_GLOBALS.Equal(p_SEG_rec.availability_in_basic,
1818: l_SEG_rec.availability_in_basic)
1819: AND QP_GLOBALS.Equal(p_SEG_rec.context,
1820: l_SEG_rec.context)
1821: AND QP_GLOBALS.Equal(p_SEG_rec.created_by,

Line 1819: AND QP_GLOBALS.Equal(p_SEG_rec.context,

1815: AND QP_GLOBALS.Equal(p_SEG_rec.attribute9,
1816: l_SEG_rec.attribute9)
1817: AND QP_GLOBALS.Equal(p_SEG_rec.availability_in_basic,
1818: l_SEG_rec.availability_in_basic)
1819: AND QP_GLOBALS.Equal(p_SEG_rec.context,
1820: l_SEG_rec.context)
1821: AND QP_GLOBALS.Equal(p_SEG_rec.created_by,
1822: l_SEG_rec.created_by)
1823: AND QP_GLOBALS.Equal(p_SEG_rec.creation_date,

Line 1821: AND QP_GLOBALS.Equal(p_SEG_rec.created_by,

1817: AND QP_GLOBALS.Equal(p_SEG_rec.availability_in_basic,
1818: l_SEG_rec.availability_in_basic)
1819: AND QP_GLOBALS.Equal(p_SEG_rec.context,
1820: l_SEG_rec.context)
1821: AND QP_GLOBALS.Equal(p_SEG_rec.created_by,
1822: l_SEG_rec.created_by)
1823: AND QP_GLOBALS.Equal(p_SEG_rec.creation_date,
1824: l_SEG_rec.creation_date)
1825: AND QP_GLOBALS.Equal(p_SEG_rec.last_updated_by,

Line 1823: AND QP_GLOBALS.Equal(p_SEG_rec.creation_date,

1819: AND QP_GLOBALS.Equal(p_SEG_rec.context,
1820: l_SEG_rec.context)
1821: AND QP_GLOBALS.Equal(p_SEG_rec.created_by,
1822: l_SEG_rec.created_by)
1823: AND QP_GLOBALS.Equal(p_SEG_rec.creation_date,
1824: l_SEG_rec.creation_date)
1825: AND QP_GLOBALS.Equal(p_SEG_rec.last_updated_by,
1826: l_SEG_rec.last_updated_by)
1827: AND QP_GLOBALS.Equal(p_SEG_rec.last_update_date,

Line 1825: AND QP_GLOBALS.Equal(p_SEG_rec.last_updated_by,

1821: AND QP_GLOBALS.Equal(p_SEG_rec.created_by,
1822: l_SEG_rec.created_by)
1823: AND QP_GLOBALS.Equal(p_SEG_rec.creation_date,
1824: l_SEG_rec.creation_date)
1825: AND QP_GLOBALS.Equal(p_SEG_rec.last_updated_by,
1826: l_SEG_rec.last_updated_by)
1827: AND QP_GLOBALS.Equal(p_SEG_rec.last_update_date,
1828: l_SEG_rec.last_update_date)
1829: AND QP_GLOBALS.Equal(p_SEG_rec.last_update_login,

Line 1827: AND QP_GLOBALS.Equal(p_SEG_rec.last_update_date,

1823: AND QP_GLOBALS.Equal(p_SEG_rec.creation_date,
1824: l_SEG_rec.creation_date)
1825: AND QP_GLOBALS.Equal(p_SEG_rec.last_updated_by,
1826: l_SEG_rec.last_updated_by)
1827: AND QP_GLOBALS.Equal(p_SEG_rec.last_update_date,
1828: l_SEG_rec.last_update_date)
1829: AND QP_GLOBALS.Equal(p_SEG_rec.last_update_login,
1830: l_SEG_rec.last_update_login)
1831: AND QP_GLOBALS.Equal(p_SEG_rec.prc_context_id,

Line 1829: AND QP_GLOBALS.Equal(p_SEG_rec.last_update_login,

1825: AND QP_GLOBALS.Equal(p_SEG_rec.last_updated_by,
1826: l_SEG_rec.last_updated_by)
1827: AND QP_GLOBALS.Equal(p_SEG_rec.last_update_date,
1828: l_SEG_rec.last_update_date)
1829: AND QP_GLOBALS.Equal(p_SEG_rec.last_update_login,
1830: l_SEG_rec.last_update_login)
1831: AND QP_GLOBALS.Equal(p_SEG_rec.prc_context_id,
1832: l_SEG_rec.prc_context_id)
1833: AND QP_GLOBALS.Equal(p_SEG_rec.program_application_id,

Line 1831: AND QP_GLOBALS.Equal(p_SEG_rec.prc_context_id,

1827: AND QP_GLOBALS.Equal(p_SEG_rec.last_update_date,
1828: l_SEG_rec.last_update_date)
1829: AND QP_GLOBALS.Equal(p_SEG_rec.last_update_login,
1830: l_SEG_rec.last_update_login)
1831: AND QP_GLOBALS.Equal(p_SEG_rec.prc_context_id,
1832: l_SEG_rec.prc_context_id)
1833: AND QP_GLOBALS.Equal(p_SEG_rec.program_application_id,
1834: l_SEG_rec.program_application_id)
1835: AND QP_GLOBALS.Equal(p_SEG_rec.program_id,

Line 1833: AND QP_GLOBALS.Equal(p_SEG_rec.program_application_id,

1829: AND QP_GLOBALS.Equal(p_SEG_rec.last_update_login,
1830: l_SEG_rec.last_update_login)
1831: AND QP_GLOBALS.Equal(p_SEG_rec.prc_context_id,
1832: l_SEG_rec.prc_context_id)
1833: AND QP_GLOBALS.Equal(p_SEG_rec.program_application_id,
1834: l_SEG_rec.program_application_id)
1835: AND QP_GLOBALS.Equal(p_SEG_rec.program_id,
1836: l_SEG_rec.program_id)
1837: AND QP_GLOBALS.Equal(p_SEG_rec.program_update_date,

Line 1835: AND QP_GLOBALS.Equal(p_SEG_rec.program_id,

1831: AND QP_GLOBALS.Equal(p_SEG_rec.prc_context_id,
1832: l_SEG_rec.prc_context_id)
1833: AND QP_GLOBALS.Equal(p_SEG_rec.program_application_id,
1834: l_SEG_rec.program_application_id)
1835: AND QP_GLOBALS.Equal(p_SEG_rec.program_id,
1836: l_SEG_rec.program_id)
1837: AND QP_GLOBALS.Equal(p_SEG_rec.program_update_date,
1838: l_SEG_rec.program_update_date)
1839: AND QP_GLOBALS.Equal(p_SEG_rec.seeded_flag,

Line 1837: AND QP_GLOBALS.Equal(p_SEG_rec.program_update_date,

1833: AND QP_GLOBALS.Equal(p_SEG_rec.program_application_id,
1834: l_SEG_rec.program_application_id)
1835: AND QP_GLOBALS.Equal(p_SEG_rec.program_id,
1836: l_SEG_rec.program_id)
1837: AND QP_GLOBALS.Equal(p_SEG_rec.program_update_date,
1838: l_SEG_rec.program_update_date)
1839: AND QP_GLOBALS.Equal(p_SEG_rec.seeded_flag,
1840: l_SEG_rec.seeded_flag)
1841: AND QP_GLOBALS.Equal(p_SEG_rec.seeded_format_type,

Line 1839: AND QP_GLOBALS.Equal(p_SEG_rec.seeded_flag,

1835: AND QP_GLOBALS.Equal(p_SEG_rec.program_id,
1836: l_SEG_rec.program_id)
1837: AND QP_GLOBALS.Equal(p_SEG_rec.program_update_date,
1838: l_SEG_rec.program_update_date)
1839: AND QP_GLOBALS.Equal(p_SEG_rec.seeded_flag,
1840: l_SEG_rec.seeded_flag)
1841: AND QP_GLOBALS.Equal(p_SEG_rec.seeded_format_type,
1842: l_SEG_rec.seeded_format_type)
1843: AND QP_GLOBALS.Equal(p_SEG_rec.seeded_precedence,

Line 1841: AND QP_GLOBALS.Equal(p_SEG_rec.seeded_format_type,

1837: AND QP_GLOBALS.Equal(p_SEG_rec.program_update_date,
1838: l_SEG_rec.program_update_date)
1839: AND QP_GLOBALS.Equal(p_SEG_rec.seeded_flag,
1840: l_SEG_rec.seeded_flag)
1841: AND QP_GLOBALS.Equal(p_SEG_rec.seeded_format_type,
1842: l_SEG_rec.seeded_format_type)
1843: AND QP_GLOBALS.Equal(p_SEG_rec.seeded_precedence,
1844: l_SEG_rec.seeded_precedence)
1845: AND QP_GLOBALS.Equal(p_SEG_rec.seeded_segment_name,

Line 1843: AND QP_GLOBALS.Equal(p_SEG_rec.seeded_precedence,

1839: AND QP_GLOBALS.Equal(p_SEG_rec.seeded_flag,
1840: l_SEG_rec.seeded_flag)
1841: AND QP_GLOBALS.Equal(p_SEG_rec.seeded_format_type,
1842: l_SEG_rec.seeded_format_type)
1843: AND QP_GLOBALS.Equal(p_SEG_rec.seeded_precedence,
1844: l_SEG_rec.seeded_precedence)
1845: AND QP_GLOBALS.Equal(p_SEG_rec.seeded_segment_name,
1846: l_SEG_rec.seeded_segment_name)
1847: AND QP_GLOBALS.Equal(p_SEG_rec.seeded_valueset_id,

Line 1845: AND QP_GLOBALS.Equal(p_SEG_rec.seeded_segment_name,

1841: AND QP_GLOBALS.Equal(p_SEG_rec.seeded_format_type,
1842: l_SEG_rec.seeded_format_type)
1843: AND QP_GLOBALS.Equal(p_SEG_rec.seeded_precedence,
1844: l_SEG_rec.seeded_precedence)
1845: AND QP_GLOBALS.Equal(p_SEG_rec.seeded_segment_name,
1846: l_SEG_rec.seeded_segment_name)
1847: AND QP_GLOBALS.Equal(p_SEG_rec.seeded_valueset_id,
1848: l_SEG_rec.seeded_valueset_id)
1849: AND QP_GLOBALS.Equal(p_SEG_rec.segment_code,

Line 1847: AND QP_GLOBALS.Equal(p_SEG_rec.seeded_valueset_id,

1843: AND QP_GLOBALS.Equal(p_SEG_rec.seeded_precedence,
1844: l_SEG_rec.seeded_precedence)
1845: AND QP_GLOBALS.Equal(p_SEG_rec.seeded_segment_name,
1846: l_SEG_rec.seeded_segment_name)
1847: AND QP_GLOBALS.Equal(p_SEG_rec.seeded_valueset_id,
1848: l_SEG_rec.seeded_valueset_id)
1849: AND QP_GLOBALS.Equal(p_SEG_rec.segment_code,
1850: l_SEG_rec.segment_code)
1851: AND QP_GLOBALS.Equal(p_SEG_rec.segment_id,

Line 1849: AND QP_GLOBALS.Equal(p_SEG_rec.segment_code,

1845: AND QP_GLOBALS.Equal(p_SEG_rec.seeded_segment_name,
1846: l_SEG_rec.seeded_segment_name)
1847: AND QP_GLOBALS.Equal(p_SEG_rec.seeded_valueset_id,
1848: l_SEG_rec.seeded_valueset_id)
1849: AND QP_GLOBALS.Equal(p_SEG_rec.segment_code,
1850: l_SEG_rec.segment_code)
1851: AND QP_GLOBALS.Equal(p_SEG_rec.segment_id,
1852: l_SEG_rec.segment_id)
1853: AND QP_GLOBALS.Equal(p_SEG_rec.application_id,

Line 1851: AND QP_GLOBALS.Equal(p_SEG_rec.segment_id,

1847: AND QP_GLOBALS.Equal(p_SEG_rec.seeded_valueset_id,
1848: l_SEG_rec.seeded_valueset_id)
1849: AND QP_GLOBALS.Equal(p_SEG_rec.segment_code,
1850: l_SEG_rec.segment_code)
1851: AND QP_GLOBALS.Equal(p_SEG_rec.segment_id,
1852: l_SEG_rec.segment_id)
1853: AND QP_GLOBALS.Equal(p_SEG_rec.application_id,
1854: l_SEG_rec.application_id)
1855: AND QP_GLOBALS.Equal(p_SEG_rec.segment_mapping_column,

Line 1853: AND QP_GLOBALS.Equal(p_SEG_rec.application_id,

1849: AND QP_GLOBALS.Equal(p_SEG_rec.segment_code,
1850: l_SEG_rec.segment_code)
1851: AND QP_GLOBALS.Equal(p_SEG_rec.segment_id,
1852: l_SEG_rec.segment_id)
1853: AND QP_GLOBALS.Equal(p_SEG_rec.application_id,
1854: l_SEG_rec.application_id)
1855: AND QP_GLOBALS.Equal(p_SEG_rec.segment_mapping_column,
1856: l_SEG_rec.segment_mapping_column)
1857: AND QP_GLOBALS.Equal(p_SEG_rec.user_format_type,

Line 1855: AND QP_GLOBALS.Equal(p_SEG_rec.segment_mapping_column,

1851: AND QP_GLOBALS.Equal(p_SEG_rec.segment_id,
1852: l_SEG_rec.segment_id)
1853: AND QP_GLOBALS.Equal(p_SEG_rec.application_id,
1854: l_SEG_rec.application_id)
1855: AND QP_GLOBALS.Equal(p_SEG_rec.segment_mapping_column,
1856: l_SEG_rec.segment_mapping_column)
1857: AND QP_GLOBALS.Equal(p_SEG_rec.user_format_type,
1858: l_SEG_rec.user_format_type)
1859: AND QP_GLOBALS.Equal(p_SEG_rec.user_precedence,

Line 1857: AND QP_GLOBALS.Equal(p_SEG_rec.user_format_type,

1853: AND QP_GLOBALS.Equal(p_SEG_rec.application_id,
1854: l_SEG_rec.application_id)
1855: AND QP_GLOBALS.Equal(p_SEG_rec.segment_mapping_column,
1856: l_SEG_rec.segment_mapping_column)
1857: AND QP_GLOBALS.Equal(p_SEG_rec.user_format_type,
1858: l_SEG_rec.user_format_type)
1859: AND QP_GLOBALS.Equal(p_SEG_rec.user_precedence,
1860: l_SEG_rec.user_precedence)
1861: AND QP_GLOBALS.Equal(p_SEG_rec.user_segment_name,

Line 1859: AND QP_GLOBALS.Equal(p_SEG_rec.user_precedence,

1855: AND QP_GLOBALS.Equal(p_SEG_rec.segment_mapping_column,
1856: l_SEG_rec.segment_mapping_column)
1857: AND QP_GLOBALS.Equal(p_SEG_rec.user_format_type,
1858: l_SEG_rec.user_format_type)
1859: AND QP_GLOBALS.Equal(p_SEG_rec.user_precedence,
1860: l_SEG_rec.user_precedence)
1861: AND QP_GLOBALS.Equal(p_SEG_rec.user_segment_name,
1862: l_SEG_rec.user_segment_name)
1863: AND QP_GLOBALS.Equal( p_SEG_rec.seeded_description,

Line 1861: AND QP_GLOBALS.Equal(p_SEG_rec.user_segment_name,

1857: AND QP_GLOBALS.Equal(p_SEG_rec.user_format_type,
1858: l_SEG_rec.user_format_type)
1859: AND QP_GLOBALS.Equal(p_SEG_rec.user_precedence,
1860: l_SEG_rec.user_precedence)
1861: AND QP_GLOBALS.Equal(p_SEG_rec.user_segment_name,
1862: l_SEG_rec.user_segment_name)
1863: AND QP_GLOBALS.Equal( p_SEG_rec.seeded_description,
1864: l_SEG_rec.seeded_description)
1865: AND QP_GLOBALS.Equal( p_SEG_rec.user_description,

Line 1863: AND QP_GLOBALS.Equal( p_SEG_rec.seeded_description,

1859: AND QP_GLOBALS.Equal(p_SEG_rec.user_precedence,
1860: l_SEG_rec.user_precedence)
1861: AND QP_GLOBALS.Equal(p_SEG_rec.user_segment_name,
1862: l_SEG_rec.user_segment_name)
1863: AND QP_GLOBALS.Equal( p_SEG_rec.seeded_description,
1864: l_SEG_rec.seeded_description)
1865: AND QP_GLOBALS.Equal( p_SEG_rec.user_description,
1866: l_SEG_rec.user_description)
1867: AND QP_GLOBALS.Equal(p_SEG_rec.user_valueset_id,

Line 1865: AND QP_GLOBALS.Equal( p_SEG_rec.user_description,

1861: AND QP_GLOBALS.Equal(p_SEG_rec.user_segment_name,
1862: l_SEG_rec.user_segment_name)
1863: AND QP_GLOBALS.Equal( p_SEG_rec.seeded_description,
1864: l_SEG_rec.seeded_description)
1865: AND QP_GLOBALS.Equal( p_SEG_rec.user_description,
1866: l_SEG_rec.user_description)
1867: AND QP_GLOBALS.Equal(p_SEG_rec.user_valueset_id,
1868: l_SEG_rec.user_valueset_id)
1869: AND QP_GLOBALS.Equal(p_SEG_rec.required_flag,

Line 1867: AND QP_GLOBALS.Equal(p_SEG_rec.user_valueset_id,

1863: AND QP_GLOBALS.Equal( p_SEG_rec.seeded_description,
1864: l_SEG_rec.seeded_description)
1865: AND QP_GLOBALS.Equal( p_SEG_rec.user_description,
1866: l_SEG_rec.user_description)
1867: AND QP_GLOBALS.Equal(p_SEG_rec.user_valueset_id,
1868: l_SEG_rec.user_valueset_id)
1869: AND QP_GLOBALS.Equal(p_SEG_rec.required_flag,
1870: l_SEG_rec.required_flag)
1871: -- Added for TCA

Line 1869: AND QP_GLOBALS.Equal(p_SEG_rec.required_flag,

1865: AND QP_GLOBALS.Equal( p_SEG_rec.user_description,
1866: l_SEG_rec.user_description)
1867: AND QP_GLOBALS.Equal(p_SEG_rec.user_valueset_id,
1868: l_SEG_rec.user_valueset_id)
1869: AND QP_GLOBALS.Equal(p_SEG_rec.required_flag,
1870: l_SEG_rec.required_flag)
1871: -- Added for TCA
1872: AND QP_GLOBALS.Equal(p_SEG_rec.party_hierarchy_enabled_flag,
1873: l_SEG_rec.party_hierarchy_enabled_flag)

Line 1872: AND QP_GLOBALS.Equal(p_SEG_rec.party_hierarchy_enabled_flag,

1868: l_SEG_rec.user_valueset_id)
1869: AND QP_GLOBALS.Equal(p_SEG_rec.required_flag,
1870: l_SEG_rec.required_flag)
1871: -- Added for TCA
1872: AND QP_GLOBALS.Equal(p_SEG_rec.party_hierarchy_enabled_flag,
1873: l_SEG_rec.party_hierarchy_enabled_flag)
1874:
1875: THEN
1876: -- Row has not changed. Set out parameter.

Line 1956: NOT QP_GLOBALS.Equal(p_SEG_rec.prc_context_id,

1952: BEGIN
1953:
1954: IF p_SEG_rec.prc_context_id IS NOT NULL AND
1955: p_SEG_rec.prc_context_id <> FND_API.G_MISS_NUM AND
1956: NOT QP_GLOBALS.Equal(p_SEG_rec.prc_context_id,
1957: p_old_SEG_rec.prc_context_id)
1958: THEN
1959: l_SEG_val_rec.prc_context := QP_Id_To_Value.Prc_Context
1960: ( p_prc_context_id => p_SEG_rec.prc_context_id

Line 1966: NOT QP_GLOBALS.Equal(p_SEG_rec.seeded_flag,

1962: END IF;
1963:
1964: IF p_SEG_rec.seeded_flag IS NOT NULL AND
1965: p_SEG_rec.seeded_flag <> FND_API.G_MISS_CHAR AND
1966: NOT QP_GLOBALS.Equal(p_SEG_rec.seeded_flag,
1967: p_old_SEG_rec.seeded_flag)
1968: THEN
1969: l_SEG_val_rec.seeded := QP_Id_To_Value.Seeded
1970: ( p_seeded_flag => p_SEG_rec.seeded_flag

Line 1976: NOT QP_GLOBALS.Equal(p_SEG_rec.seeded_valueset_id,

1972: END IF;
1973:
1974: IF p_SEG_rec.seeded_valueset_id IS NOT NULL AND
1975: p_SEG_rec.seeded_valueset_id <> FND_API.G_MISS_NUM AND
1976: NOT QP_GLOBALS.Equal(p_SEG_rec.seeded_valueset_id,
1977: p_old_SEG_rec.seeded_valueset_id)
1978: THEN
1979: l_SEG_val_rec.seeded_valueset := QP_Id_To_Value.Seeded_Valueset
1980: ( p_seeded_valueset_id => p_SEG_rec.seeded_valueset_id

Line 1986: NOT QP_GLOBALS.Equal(p_SEG_rec.segment_id,

1982: END IF;
1983:
1984: IF p_SEG_rec.segment_id IS NOT NULL AND
1985: p_SEG_rec.segment_id <> FND_API.G_MISS_NUM AND
1986: NOT QP_GLOBALS.Equal(p_SEG_rec.segment_id,
1987: p_old_SEG_rec.segment_id)
1988: THEN
1989: l_SEG_val_rec.segment := QP_Id_To_Value.Segment
1990: ( p_segment_id => p_SEG_rec.segment_id

Line 1996: NOT QP_GLOBALS.Equal(p_SEG_rec.user_valueset_id,

1992: END IF;
1993:
1994: IF p_SEG_rec.user_valueset_id IS NOT NULL AND
1995: p_SEG_rec.user_valueset_id <> FND_API.G_MISS_NUM AND
1996: NOT QP_GLOBALS.Equal(p_SEG_rec.user_valueset_id,
1997: p_old_SEG_rec.user_valueset_id)
1998: THEN
1999: l_SEG_val_rec.user_valueset := QP_Id_To_Value.User_Valueset
2000: ( p_user_valueset_id => p_SEG_rec.user_valueset_id