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.HZ_ORIG_SYS_ENTITY_MAP_PKG dependencies on FND_API

Line 77: FND_API.G_MISS_CHAR, NULL,

73: attribute20
74: )
75: VALUES (
76: DECODE(x_orig_system,
77: FND_API.G_MISS_CHAR, NULL,
78: x_orig_system),
79: DECODE(x_owner_table_name,
80: FND_API.G_MISS_CHAR, NULL,
81: x_owner_table_name),

Line 80: FND_API.G_MISS_CHAR, NULL,

76: DECODE(x_orig_system,
77: FND_API.G_MISS_CHAR, NULL,
78: x_orig_system),
79: DECODE(x_owner_table_name,
80: FND_API.G_MISS_CHAR, NULL,
81: x_owner_table_name),
82: DECODE(x_status,
83: FND_API.G_MISS_CHAR, 'A',
84: NULL, 'A',

Line 83: FND_API.G_MISS_CHAR, 'A',

79: DECODE(x_owner_table_name,
80: FND_API.G_MISS_CHAR, NULL,
81: x_owner_table_name),
82: DECODE(x_status,
83: FND_API.G_MISS_CHAR, 'A',
84: NULL, 'A',
85: x_status),
86: DECODE(x_multiple_flag,
87: FND_API.G_MISS_CHAR, 'N',NULL, 'N',

Line 87: FND_API.G_MISS_CHAR, 'N',NULL, 'N',

83: FND_API.G_MISS_CHAR, 'A',
84: NULL, 'A',
85: x_status),
86: DECODE(x_multiple_flag,
87: FND_API.G_MISS_CHAR, 'N',NULL, 'N',
88: x_multiple_flag),
89: --raji
90: DECODE(x_multi_osr_flag,
91: FND_API.G_MISS_CHAR,'Y',NULL,'Y',

Line 91: FND_API.G_MISS_CHAR,'Y',NULL,'Y',

87: FND_API.G_MISS_CHAR, 'N',NULL, 'N',
88: x_multiple_flag),
89: --raji
90: DECODE(x_multi_osr_flag,
91: FND_API.G_MISS_CHAR,'Y',NULL,'Y',
92: x_multi_osr_flag),
93: hz_utility_v2pub.created_by,
94: hz_utility_v2pub.creation_date,
95: hz_utility_v2pub.last_updated_by,

Line 99: FND_API.G_MISS_NUM, NULL,

95: hz_utility_v2pub.last_updated_by,
96: hz_utility_v2pub.last_update_date,
97: hz_utility_v2pub.last_update_login,
98: DECODE(x_object_version_number,
99: FND_API.G_MISS_NUM, NULL,
100: x_object_version_number),
101: DECODE(x_created_by_module,
102: FND_API.G_MISS_CHAR, NULL,
103: x_created_by_module),

Line 102: FND_API.G_MISS_CHAR, NULL,

98: DECODE(x_object_version_number,
99: FND_API.G_MISS_NUM, NULL,
100: x_object_version_number),
101: DECODE(x_created_by_module,
102: FND_API.G_MISS_CHAR, NULL,
103: x_created_by_module),
104: hz_utility_v2pub.application_id,
105: DECODE(x_attribute_category,
106: FND_API.G_MISS_CHAR, NULL,

Line 106: FND_API.G_MISS_CHAR, NULL,

102: FND_API.G_MISS_CHAR, NULL,
103: x_created_by_module),
104: hz_utility_v2pub.application_id,
105: DECODE(x_attribute_category,
106: FND_API.G_MISS_CHAR, NULL,
107: x_attribute_category),
108: DECODE(x_attribute1,
109: FND_API.G_MISS_CHAR, NULL,
110: x_attribute1),

Line 109: FND_API.G_MISS_CHAR, NULL,

105: DECODE(x_attribute_category,
106: FND_API.G_MISS_CHAR, NULL,
107: x_attribute_category),
108: DECODE(x_attribute1,
109: FND_API.G_MISS_CHAR, NULL,
110: x_attribute1),
111: DECODE(x_attribute2,
112: FND_API.G_MISS_CHAR, NULL,
113: x_attribute2),

Line 112: FND_API.G_MISS_CHAR, NULL,

108: DECODE(x_attribute1,
109: FND_API.G_MISS_CHAR, NULL,
110: x_attribute1),
111: DECODE(x_attribute2,
112: FND_API.G_MISS_CHAR, NULL,
113: x_attribute2),
114: DECODE(x_attribute3,
115: FND_API.G_MISS_CHAR, NULL,
116: x_attribute3),

Line 115: FND_API.G_MISS_CHAR, NULL,

111: DECODE(x_attribute2,
112: FND_API.G_MISS_CHAR, NULL,
113: x_attribute2),
114: DECODE(x_attribute3,
115: FND_API.G_MISS_CHAR, NULL,
116: x_attribute3),
117: DECODE(x_attribute4,
118: FND_API.G_MISS_CHAR, NULL,
119: x_attribute4),

Line 118: FND_API.G_MISS_CHAR, NULL,

114: DECODE(x_attribute3,
115: FND_API.G_MISS_CHAR, NULL,
116: x_attribute3),
117: DECODE(x_attribute4,
118: FND_API.G_MISS_CHAR, NULL,
119: x_attribute4),
120: DECODE(x_attribute5,
121: FND_API.G_MISS_CHAR, NULL,
122: x_attribute5),

Line 121: FND_API.G_MISS_CHAR, NULL,

117: DECODE(x_attribute4,
118: FND_API.G_MISS_CHAR, NULL,
119: x_attribute4),
120: DECODE(x_attribute5,
121: FND_API.G_MISS_CHAR, NULL,
122: x_attribute5),
123: DECODE(x_attribute6,
124: FND_API.G_MISS_CHAR, NULL,
125: x_attribute6),

Line 124: FND_API.G_MISS_CHAR, NULL,

120: DECODE(x_attribute5,
121: FND_API.G_MISS_CHAR, NULL,
122: x_attribute5),
123: DECODE(x_attribute6,
124: FND_API.G_MISS_CHAR, NULL,
125: x_attribute6),
126: DECODE(x_attribute7,
127: FND_API.G_MISS_CHAR, NULL,
128: x_attribute7),

Line 127: FND_API.G_MISS_CHAR, NULL,

123: DECODE(x_attribute6,
124: FND_API.G_MISS_CHAR, NULL,
125: x_attribute6),
126: DECODE(x_attribute7,
127: FND_API.G_MISS_CHAR, NULL,
128: x_attribute7),
129: DECODE(x_attribute8,
130: FND_API.G_MISS_CHAR, NULL,
131: x_attribute8),

Line 130: FND_API.G_MISS_CHAR, NULL,

126: DECODE(x_attribute7,
127: FND_API.G_MISS_CHAR, NULL,
128: x_attribute7),
129: DECODE(x_attribute8,
130: FND_API.G_MISS_CHAR, NULL,
131: x_attribute8),
132: DECODE(x_attribute9,
133: FND_API.G_MISS_CHAR, NULL,
134: x_attribute9),

Line 133: FND_API.G_MISS_CHAR, NULL,

129: DECODE(x_attribute8,
130: FND_API.G_MISS_CHAR, NULL,
131: x_attribute8),
132: DECODE(x_attribute9,
133: FND_API.G_MISS_CHAR, NULL,
134: x_attribute9),
135: DECODE(x_attribute10,
136: FND_API.G_MISS_CHAR, NULL,
137: x_attribute10),

Line 136: FND_API.G_MISS_CHAR, NULL,

132: DECODE(x_attribute9,
133: FND_API.G_MISS_CHAR, NULL,
134: x_attribute9),
135: DECODE(x_attribute10,
136: FND_API.G_MISS_CHAR, NULL,
137: x_attribute10),
138: DECODE(x_attribute11,
139: FND_API.G_MISS_CHAR, NULL,
140: x_attribute11),

Line 139: FND_API.G_MISS_CHAR, NULL,

135: DECODE(x_attribute10,
136: FND_API.G_MISS_CHAR, NULL,
137: x_attribute10),
138: DECODE(x_attribute11,
139: FND_API.G_MISS_CHAR, NULL,
140: x_attribute11),
141: DECODE(x_attribute12,
142: FND_API.G_MISS_CHAR, NULL,
143: x_attribute12),

Line 142: FND_API.G_MISS_CHAR, NULL,

138: DECODE(x_attribute11,
139: FND_API.G_MISS_CHAR, NULL,
140: x_attribute11),
141: DECODE(x_attribute12,
142: FND_API.G_MISS_CHAR, NULL,
143: x_attribute12),
144: DECODE(x_attribute13,
145: FND_API.G_MISS_CHAR, NULL,
146: x_attribute13),

Line 145: FND_API.G_MISS_CHAR, NULL,

141: DECODE(x_attribute12,
142: FND_API.G_MISS_CHAR, NULL,
143: x_attribute12),
144: DECODE(x_attribute13,
145: FND_API.G_MISS_CHAR, NULL,
146: x_attribute13),
147: DECODE(x_attribute14,
148: FND_API.G_MISS_CHAR, NULL,
149: x_attribute14),

Line 148: FND_API.G_MISS_CHAR, NULL,

144: DECODE(x_attribute13,
145: FND_API.G_MISS_CHAR, NULL,
146: x_attribute13),
147: DECODE(x_attribute14,
148: FND_API.G_MISS_CHAR, NULL,
149: x_attribute14),
150: DECODE(x_attribute15,
151: FND_API.G_MISS_CHAR, NULL,
152: x_attribute15),

Line 151: FND_API.G_MISS_CHAR, NULL,

147: DECODE(x_attribute14,
148: FND_API.G_MISS_CHAR, NULL,
149: x_attribute14),
150: DECODE(x_attribute15,
151: FND_API.G_MISS_CHAR, NULL,
152: x_attribute15),
153: DECODE(x_attribute16,
154: FND_API.G_MISS_CHAR, NULL,
155: x_attribute16),

Line 154: FND_API.G_MISS_CHAR, NULL,

150: DECODE(x_attribute15,
151: FND_API.G_MISS_CHAR, NULL,
152: x_attribute15),
153: DECODE(x_attribute16,
154: FND_API.G_MISS_CHAR, NULL,
155: x_attribute16),
156: DECODE(x_attribute17,
157: FND_API.G_MISS_CHAR, NULL,
158: x_attribute17),

Line 157: FND_API.G_MISS_CHAR, NULL,

153: DECODE(x_attribute16,
154: FND_API.G_MISS_CHAR, NULL,
155: x_attribute16),
156: DECODE(x_attribute17,
157: FND_API.G_MISS_CHAR, NULL,
158: x_attribute17),
159: DECODE(x_attribute18,
160: FND_API.G_MISS_CHAR, NULL,
161: x_attribute18),

Line 160: FND_API.G_MISS_CHAR, NULL,

156: DECODE(x_attribute17,
157: FND_API.G_MISS_CHAR, NULL,
158: x_attribute17),
159: DECODE(x_attribute18,
160: FND_API.G_MISS_CHAR, NULL,
161: x_attribute18),
162: DECODE(x_attribute19,
163: FND_API.G_MISS_CHAR, NULL,
164: x_attribute19),

Line 163: FND_API.G_MISS_CHAR, NULL,

159: DECODE(x_attribute18,
160: FND_API.G_MISS_CHAR, NULL,
161: x_attribute18),
162: DECODE(x_attribute19,
163: FND_API.G_MISS_CHAR, NULL,
164: x_attribute19),
165: DECODE(x_attribute20,
166: FND_API.G_MISS_CHAR, NULL,
167: x_attribute20)

Line 166: FND_API.G_MISS_CHAR, NULL,

162: DECODE(x_attribute19,
163: FND_API.G_MISS_CHAR, NULL,
164: x_attribute19),
165: DECODE(x_attribute20,
166: FND_API.G_MISS_CHAR, NULL,
167: x_attribute20)
168: ) ;
169:
170: END Insert_Row;

Line 211: FND_API.G_MISS_CHAR, NULL,

207: SET
208: orig_system =
209: DECODE(x_orig_system,
210: NULL, orig_system,
211: FND_API.G_MISS_CHAR, NULL,
212: x_orig_system),
213: owner_table_name =
214: DECODE(x_owner_table_name,
215: NULL, owner_table_name,

Line 216: FND_API.G_MISS_CHAR, NULL,

212: x_orig_system),
213: owner_table_name =
214: DECODE(x_owner_table_name,
215: NULL, owner_table_name,
216: FND_API.G_MISS_CHAR, NULL,
217: x_owner_table_name),
218: status =
219: DECODE(x_status,
220: NULL, status,

Line 221: FND_API.G_MISS_CHAR, NULL,

217: x_owner_table_name),
218: status =
219: DECODE(x_status,
220: NULL, status,
221: FND_API.G_MISS_CHAR, NULL,
222: x_status),
223: multiple_flag =
224: DECODE(x_multiple_flag,
225: NULL, multiple_flag,

Line 226: FND_API.G_MISS_CHAR, NULL,

222: x_status),
223: multiple_flag =
224: DECODE(x_multiple_flag,
225: NULL, multiple_flag,
226: FND_API.G_MISS_CHAR, NULL,
227: x_multiple_flag),
228: --raji
229: multi_osr_flag =
230: DECODE(x_multi_osr_flag,

Line 232: FND_API.G_MISS_CHAR,'Y',

228: --raji
229: multi_osr_flag =
230: DECODE(x_multi_osr_flag,
231: NULL,multi_osr_flag,
232: FND_API.G_MISS_CHAR,'Y',
233: x_multi_osr_flag),
234: created_by = created_by,
235: creation_date = creation_date,
236: last_updated_by = hz_utility_v2pub.last_updated_by,

Line 242: FND_API.G_MISS_NUM, NULL,

238: last_update_login = hz_utility_v2pub.last_update_login,
239: object_version_number =
240: DECODE(x_object_version_number,
241: NULL, object_version_number,
242: FND_API.G_MISS_NUM, NULL,
243: x_object_version_number),
244: created_by_module =
245: DECODE(x_created_by_module,
246: NULL, created_by_module,

Line 247: FND_API.G_MISS_CHAR, NULL,

243: x_object_version_number),
244: created_by_module =
245: DECODE(x_created_by_module,
246: NULL, created_by_module,
247: FND_API.G_MISS_CHAR, NULL,
248: x_created_by_module),
249: application_id = hz_utility_v2pub.application_id,
250: attribute_category =
251: DECODE(x_attribute_category,

Line 253: FND_API.G_MISS_CHAR, NULL,

249: application_id = hz_utility_v2pub.application_id,
250: attribute_category =
251: DECODE(x_attribute_category,
252: NULL, attribute_category,
253: FND_API.G_MISS_CHAR, NULL,
254: x_attribute_category),
255: attribute1 =
256: DECODE(x_attribute1,
257: NULL, attribute1,

Line 258: FND_API.G_MISS_CHAR, NULL,

254: x_attribute_category),
255: attribute1 =
256: DECODE(x_attribute1,
257: NULL, attribute1,
258: FND_API.G_MISS_CHAR, NULL,
259: x_attribute1),
260: attribute2 =
261: DECODE(x_attribute2,
262: NULL, attribute2,

Line 263: FND_API.G_MISS_CHAR, NULL,

259: x_attribute1),
260: attribute2 =
261: DECODE(x_attribute2,
262: NULL, attribute2,
263: FND_API.G_MISS_CHAR, NULL,
264: x_attribute2),
265: attribute3 =
266: DECODE(x_attribute3,
267: NULL, attribute3,

Line 268: FND_API.G_MISS_CHAR, NULL,

264: x_attribute2),
265: attribute3 =
266: DECODE(x_attribute3,
267: NULL, attribute3,
268: FND_API.G_MISS_CHAR, NULL,
269: x_attribute3),
270: attribute4 =
271: DECODE(x_attribute4,
272: NULL, attribute4,

Line 273: FND_API.G_MISS_CHAR, NULL,

269: x_attribute3),
270: attribute4 =
271: DECODE(x_attribute4,
272: NULL, attribute4,
273: FND_API.G_MISS_CHAR, NULL,
274: x_attribute4),
275: attribute5 =
276: DECODE(x_attribute5,
277: NULL, attribute5,

Line 278: FND_API.G_MISS_CHAR, NULL,

274: x_attribute4),
275: attribute5 =
276: DECODE(x_attribute5,
277: NULL, attribute5,
278: FND_API.G_MISS_CHAR, NULL,
279: x_attribute5),
280: attribute6 =
281: DECODE(x_attribute6,
282: NULL, attribute6,

Line 283: FND_API.G_MISS_CHAR, NULL,

279: x_attribute5),
280: attribute6 =
281: DECODE(x_attribute6,
282: NULL, attribute6,
283: FND_API.G_MISS_CHAR, NULL,
284: x_attribute6),
285: attribute7 =
286: DECODE(x_attribute7,
287: NULL, attribute7,

Line 288: FND_API.G_MISS_CHAR, NULL,

284: x_attribute6),
285: attribute7 =
286: DECODE(x_attribute7,
287: NULL, attribute7,
288: FND_API.G_MISS_CHAR, NULL,
289: x_attribute7),
290: attribute8 =
291: DECODE(x_attribute8,
292: NULL, attribute8,

Line 293: FND_API.G_MISS_CHAR, NULL,

289: x_attribute7),
290: attribute8 =
291: DECODE(x_attribute8,
292: NULL, attribute8,
293: FND_API.G_MISS_CHAR, NULL,
294: x_attribute8),
295: attribute9 =
296: DECODE(x_attribute9,
297: NULL, attribute9,

Line 298: FND_API.G_MISS_CHAR, NULL,

294: x_attribute8),
295: attribute9 =
296: DECODE(x_attribute9,
297: NULL, attribute9,
298: FND_API.G_MISS_CHAR, NULL,
299: x_attribute9),
300: attribute10 =
301: DECODE(x_attribute10,
302: NULL, attribute10,

Line 303: FND_API.G_MISS_CHAR, NULL,

299: x_attribute9),
300: attribute10 =
301: DECODE(x_attribute10,
302: NULL, attribute10,
303: FND_API.G_MISS_CHAR, NULL,
304: x_attribute10),
305: attribute11 =
306: DECODE(x_attribute11,
307: NULL, attribute11,

Line 308: FND_API.G_MISS_CHAR, NULL,

304: x_attribute10),
305: attribute11 =
306: DECODE(x_attribute11,
307: NULL, attribute11,
308: FND_API.G_MISS_CHAR, NULL,
309: x_attribute11),
310: attribute12 =
311: DECODE(x_attribute12,
312: NULL, attribute12,

Line 313: FND_API.G_MISS_CHAR, NULL,

309: x_attribute11),
310: attribute12 =
311: DECODE(x_attribute12,
312: NULL, attribute12,
313: FND_API.G_MISS_CHAR, NULL,
314: x_attribute12),
315: attribute13 =
316: DECODE(x_attribute13,
317: NULL, attribute13,

Line 318: FND_API.G_MISS_CHAR, NULL,

314: x_attribute12),
315: attribute13 =
316: DECODE(x_attribute13,
317: NULL, attribute13,
318: FND_API.G_MISS_CHAR, NULL,
319: x_attribute13),
320: attribute14 =
321: DECODE(x_attribute14,
322: NULL, attribute14,

Line 323: FND_API.G_MISS_CHAR, NULL,

319: x_attribute13),
320: attribute14 =
321: DECODE(x_attribute14,
322: NULL, attribute14,
323: FND_API.G_MISS_CHAR, NULL,
324: x_attribute14),
325: attribute15 =
326: DECODE(x_attribute15,
327: NULL, attribute15,

Line 328: FND_API.G_MISS_CHAR, NULL,

324: x_attribute14),
325: attribute15 =
326: DECODE(x_attribute15,
327: NULL, attribute15,
328: FND_API.G_MISS_CHAR, NULL,
329: x_attribute15),
330: attribute16 =
331: DECODE(x_attribute16,
332: NULL, attribute16,

Line 333: FND_API.G_MISS_CHAR, NULL,

329: x_attribute15),
330: attribute16 =
331: DECODE(x_attribute16,
332: NULL, attribute16,
333: FND_API.G_MISS_CHAR, NULL,
334: x_attribute16),
335: attribute17 =
336: DECODE(x_attribute17,
337: NULL, attribute17,

Line 338: FND_API.G_MISS_CHAR, NULL,

334: x_attribute16),
335: attribute17 =
336: DECODE(x_attribute17,
337: NULL, attribute17,
338: FND_API.G_MISS_CHAR, NULL,
339: x_attribute17),
340: attribute18 =
341: DECODE(x_attribute18,
342: NULL, attribute18,

Line 343: FND_API.G_MISS_CHAR, NULL,

339: x_attribute17),
340: attribute18 =
341: DECODE(x_attribute18,
342: NULL, attribute18,
343: FND_API.G_MISS_CHAR, NULL,
344: x_attribute18),
345: attribute19 =
346: DECODE(x_attribute19,
347: NULL, attribute19,

Line 348: FND_API.G_MISS_CHAR, NULL,

344: x_attribute18),
345: attribute19 =
346: DECODE(x_attribute19,
347: NULL, attribute19,
348: FND_API.G_MISS_CHAR, NULL,
349: x_attribute19),
350: attribute20 =
351: DECODE(x_attribute20,
352: NULL, attribute20,

Line 353: FND_API.G_MISS_CHAR, NULL,

349: x_attribute19),
350: attribute20 =
351: DECODE(x_attribute20,
352: NULL, attribute20,
353: FND_API.G_MISS_CHAR, NULL,
354: x_attribute20)
355: WHERE ORIG_SYSTEM = X_ORIG_SYSTEM
356: AND OWNER_TABLE_NAME = X_OWNER_TABLE_NAME;
357:

Line 568: NVL(orig_system, FND_API.G_MISS_CHAR),

564: ) IS
565: BEGIN
566:
567: SELECT
568: NVL(orig_system, FND_API.G_MISS_CHAR),
569: NVL(owner_table_name, FND_API.G_MISS_CHAR),
570: NVL(status, FND_API.G_MISS_CHAR),
571: NVL(multiple_flag, FND_API.G_MISS_CHAR),
572: --raji

Line 569: NVL(owner_table_name, FND_API.G_MISS_CHAR),

565: BEGIN
566:
567: SELECT
568: NVL(orig_system, FND_API.G_MISS_CHAR),
569: NVL(owner_table_name, FND_API.G_MISS_CHAR),
570: NVL(status, FND_API.G_MISS_CHAR),
571: NVL(multiple_flag, FND_API.G_MISS_CHAR),
572: --raji
573: NVL(multi_osr_flag,FND_API.G_MISS_CHAR),

Line 570: NVL(status, FND_API.G_MISS_CHAR),

566:
567: SELECT
568: NVL(orig_system, FND_API.G_MISS_CHAR),
569: NVL(owner_table_name, FND_API.G_MISS_CHAR),
570: NVL(status, FND_API.G_MISS_CHAR),
571: NVL(multiple_flag, FND_API.G_MISS_CHAR),
572: --raji
573: NVL(multi_osr_flag,FND_API.G_MISS_CHAR),
574: NVL(created_by_module, FND_API.G_MISS_CHAR),

Line 571: NVL(multiple_flag, FND_API.G_MISS_CHAR),

567: SELECT
568: NVL(orig_system, FND_API.G_MISS_CHAR),
569: NVL(owner_table_name, FND_API.G_MISS_CHAR),
570: NVL(status, FND_API.G_MISS_CHAR),
571: NVL(multiple_flag, FND_API.G_MISS_CHAR),
572: --raji
573: NVL(multi_osr_flag,FND_API.G_MISS_CHAR),
574: NVL(created_by_module, FND_API.G_MISS_CHAR),
575: NVL(application_id, FND_API.G_MISS_NUM),

Line 573: NVL(multi_osr_flag,FND_API.G_MISS_CHAR),

569: NVL(owner_table_name, FND_API.G_MISS_CHAR),
570: NVL(status, FND_API.G_MISS_CHAR),
571: NVL(multiple_flag, FND_API.G_MISS_CHAR),
572: --raji
573: NVL(multi_osr_flag,FND_API.G_MISS_CHAR),
574: NVL(created_by_module, FND_API.G_MISS_CHAR),
575: NVL(application_id, FND_API.G_MISS_NUM),
576: NVL(attribute_category, FND_API.G_MISS_CHAR),
577: NVL(attribute1, FND_API.G_MISS_CHAR),

Line 574: NVL(created_by_module, FND_API.G_MISS_CHAR),

570: NVL(status, FND_API.G_MISS_CHAR),
571: NVL(multiple_flag, FND_API.G_MISS_CHAR),
572: --raji
573: NVL(multi_osr_flag,FND_API.G_MISS_CHAR),
574: NVL(created_by_module, FND_API.G_MISS_CHAR),
575: NVL(application_id, FND_API.G_MISS_NUM),
576: NVL(attribute_category, FND_API.G_MISS_CHAR),
577: NVL(attribute1, FND_API.G_MISS_CHAR),
578: NVL(attribute2, FND_API.G_MISS_CHAR),

Line 575: NVL(application_id, FND_API.G_MISS_NUM),

571: NVL(multiple_flag, FND_API.G_MISS_CHAR),
572: --raji
573: NVL(multi_osr_flag,FND_API.G_MISS_CHAR),
574: NVL(created_by_module, FND_API.G_MISS_CHAR),
575: NVL(application_id, FND_API.G_MISS_NUM),
576: NVL(attribute_category, FND_API.G_MISS_CHAR),
577: NVL(attribute1, FND_API.G_MISS_CHAR),
578: NVL(attribute2, FND_API.G_MISS_CHAR),
579: NVL(attribute3, FND_API.G_MISS_CHAR),

Line 576: NVL(attribute_category, FND_API.G_MISS_CHAR),

572: --raji
573: NVL(multi_osr_flag,FND_API.G_MISS_CHAR),
574: NVL(created_by_module, FND_API.G_MISS_CHAR),
575: NVL(application_id, FND_API.G_MISS_NUM),
576: NVL(attribute_category, FND_API.G_MISS_CHAR),
577: NVL(attribute1, FND_API.G_MISS_CHAR),
578: NVL(attribute2, FND_API.G_MISS_CHAR),
579: NVL(attribute3, FND_API.G_MISS_CHAR),
580: NVL(attribute4, FND_API.G_MISS_CHAR),

Line 577: NVL(attribute1, FND_API.G_MISS_CHAR),

573: NVL(multi_osr_flag,FND_API.G_MISS_CHAR),
574: NVL(created_by_module, FND_API.G_MISS_CHAR),
575: NVL(application_id, FND_API.G_MISS_NUM),
576: NVL(attribute_category, FND_API.G_MISS_CHAR),
577: NVL(attribute1, FND_API.G_MISS_CHAR),
578: NVL(attribute2, FND_API.G_MISS_CHAR),
579: NVL(attribute3, FND_API.G_MISS_CHAR),
580: NVL(attribute4, FND_API.G_MISS_CHAR),
581: NVL(attribute5, FND_API.G_MISS_CHAR),

Line 578: NVL(attribute2, FND_API.G_MISS_CHAR),

574: NVL(created_by_module, FND_API.G_MISS_CHAR),
575: NVL(application_id, FND_API.G_MISS_NUM),
576: NVL(attribute_category, FND_API.G_MISS_CHAR),
577: NVL(attribute1, FND_API.G_MISS_CHAR),
578: NVL(attribute2, FND_API.G_MISS_CHAR),
579: NVL(attribute3, FND_API.G_MISS_CHAR),
580: NVL(attribute4, FND_API.G_MISS_CHAR),
581: NVL(attribute5, FND_API.G_MISS_CHAR),
582: NVL(attribute6, FND_API.G_MISS_CHAR),

Line 579: NVL(attribute3, FND_API.G_MISS_CHAR),

575: NVL(application_id, FND_API.G_MISS_NUM),
576: NVL(attribute_category, FND_API.G_MISS_CHAR),
577: NVL(attribute1, FND_API.G_MISS_CHAR),
578: NVL(attribute2, FND_API.G_MISS_CHAR),
579: NVL(attribute3, FND_API.G_MISS_CHAR),
580: NVL(attribute4, FND_API.G_MISS_CHAR),
581: NVL(attribute5, FND_API.G_MISS_CHAR),
582: NVL(attribute6, FND_API.G_MISS_CHAR),
583: NVL(attribute7, FND_API.G_MISS_CHAR),

Line 580: NVL(attribute4, FND_API.G_MISS_CHAR),

576: NVL(attribute_category, FND_API.G_MISS_CHAR),
577: NVL(attribute1, FND_API.G_MISS_CHAR),
578: NVL(attribute2, FND_API.G_MISS_CHAR),
579: NVL(attribute3, FND_API.G_MISS_CHAR),
580: NVL(attribute4, FND_API.G_MISS_CHAR),
581: NVL(attribute5, FND_API.G_MISS_CHAR),
582: NVL(attribute6, FND_API.G_MISS_CHAR),
583: NVL(attribute7, FND_API.G_MISS_CHAR),
584: NVL(attribute8, FND_API.G_MISS_CHAR),

Line 581: NVL(attribute5, FND_API.G_MISS_CHAR),

577: NVL(attribute1, FND_API.G_MISS_CHAR),
578: NVL(attribute2, FND_API.G_MISS_CHAR),
579: NVL(attribute3, FND_API.G_MISS_CHAR),
580: NVL(attribute4, FND_API.G_MISS_CHAR),
581: NVL(attribute5, FND_API.G_MISS_CHAR),
582: NVL(attribute6, FND_API.G_MISS_CHAR),
583: NVL(attribute7, FND_API.G_MISS_CHAR),
584: NVL(attribute8, FND_API.G_MISS_CHAR),
585: NVL(attribute9, FND_API.G_MISS_CHAR),

Line 582: NVL(attribute6, FND_API.G_MISS_CHAR),

578: NVL(attribute2, FND_API.G_MISS_CHAR),
579: NVL(attribute3, FND_API.G_MISS_CHAR),
580: NVL(attribute4, FND_API.G_MISS_CHAR),
581: NVL(attribute5, FND_API.G_MISS_CHAR),
582: NVL(attribute6, FND_API.G_MISS_CHAR),
583: NVL(attribute7, FND_API.G_MISS_CHAR),
584: NVL(attribute8, FND_API.G_MISS_CHAR),
585: NVL(attribute9, FND_API.G_MISS_CHAR),
586: NVL(attribute10, FND_API.G_MISS_CHAR),

Line 583: NVL(attribute7, FND_API.G_MISS_CHAR),

579: NVL(attribute3, FND_API.G_MISS_CHAR),
580: NVL(attribute4, FND_API.G_MISS_CHAR),
581: NVL(attribute5, FND_API.G_MISS_CHAR),
582: NVL(attribute6, FND_API.G_MISS_CHAR),
583: NVL(attribute7, FND_API.G_MISS_CHAR),
584: NVL(attribute8, FND_API.G_MISS_CHAR),
585: NVL(attribute9, FND_API.G_MISS_CHAR),
586: NVL(attribute10, FND_API.G_MISS_CHAR),
587: NVL(attribute11, FND_API.G_MISS_CHAR),

Line 584: NVL(attribute8, FND_API.G_MISS_CHAR),

580: NVL(attribute4, FND_API.G_MISS_CHAR),
581: NVL(attribute5, FND_API.G_MISS_CHAR),
582: NVL(attribute6, FND_API.G_MISS_CHAR),
583: NVL(attribute7, FND_API.G_MISS_CHAR),
584: NVL(attribute8, FND_API.G_MISS_CHAR),
585: NVL(attribute9, FND_API.G_MISS_CHAR),
586: NVL(attribute10, FND_API.G_MISS_CHAR),
587: NVL(attribute11, FND_API.G_MISS_CHAR),
588: NVL(attribute12, FND_API.G_MISS_CHAR),

Line 585: NVL(attribute9, FND_API.G_MISS_CHAR),

581: NVL(attribute5, FND_API.G_MISS_CHAR),
582: NVL(attribute6, FND_API.G_MISS_CHAR),
583: NVL(attribute7, FND_API.G_MISS_CHAR),
584: NVL(attribute8, FND_API.G_MISS_CHAR),
585: NVL(attribute9, FND_API.G_MISS_CHAR),
586: NVL(attribute10, FND_API.G_MISS_CHAR),
587: NVL(attribute11, FND_API.G_MISS_CHAR),
588: NVL(attribute12, FND_API.G_MISS_CHAR),
589: NVL(attribute13, FND_API.G_MISS_CHAR),

Line 586: NVL(attribute10, FND_API.G_MISS_CHAR),

582: NVL(attribute6, FND_API.G_MISS_CHAR),
583: NVL(attribute7, FND_API.G_MISS_CHAR),
584: NVL(attribute8, FND_API.G_MISS_CHAR),
585: NVL(attribute9, FND_API.G_MISS_CHAR),
586: NVL(attribute10, FND_API.G_MISS_CHAR),
587: NVL(attribute11, FND_API.G_MISS_CHAR),
588: NVL(attribute12, FND_API.G_MISS_CHAR),
589: NVL(attribute13, FND_API.G_MISS_CHAR),
590: NVL(attribute14, FND_API.G_MISS_CHAR),

Line 587: NVL(attribute11, FND_API.G_MISS_CHAR),

583: NVL(attribute7, FND_API.G_MISS_CHAR),
584: NVL(attribute8, FND_API.G_MISS_CHAR),
585: NVL(attribute9, FND_API.G_MISS_CHAR),
586: NVL(attribute10, FND_API.G_MISS_CHAR),
587: NVL(attribute11, FND_API.G_MISS_CHAR),
588: NVL(attribute12, FND_API.G_MISS_CHAR),
589: NVL(attribute13, FND_API.G_MISS_CHAR),
590: NVL(attribute14, FND_API.G_MISS_CHAR),
591: NVL(attribute15, FND_API.G_MISS_CHAR),

Line 588: NVL(attribute12, FND_API.G_MISS_CHAR),

584: NVL(attribute8, FND_API.G_MISS_CHAR),
585: NVL(attribute9, FND_API.G_MISS_CHAR),
586: NVL(attribute10, FND_API.G_MISS_CHAR),
587: NVL(attribute11, FND_API.G_MISS_CHAR),
588: NVL(attribute12, FND_API.G_MISS_CHAR),
589: NVL(attribute13, FND_API.G_MISS_CHAR),
590: NVL(attribute14, FND_API.G_MISS_CHAR),
591: NVL(attribute15, FND_API.G_MISS_CHAR),
592: NVL(attribute16, FND_API.G_MISS_CHAR),

Line 589: NVL(attribute13, FND_API.G_MISS_CHAR),

585: NVL(attribute9, FND_API.G_MISS_CHAR),
586: NVL(attribute10, FND_API.G_MISS_CHAR),
587: NVL(attribute11, FND_API.G_MISS_CHAR),
588: NVL(attribute12, FND_API.G_MISS_CHAR),
589: NVL(attribute13, FND_API.G_MISS_CHAR),
590: NVL(attribute14, FND_API.G_MISS_CHAR),
591: NVL(attribute15, FND_API.G_MISS_CHAR),
592: NVL(attribute16, FND_API.G_MISS_CHAR),
593: NVL(attribute17, FND_API.G_MISS_CHAR),

Line 590: NVL(attribute14, FND_API.G_MISS_CHAR),

586: NVL(attribute10, FND_API.G_MISS_CHAR),
587: NVL(attribute11, FND_API.G_MISS_CHAR),
588: NVL(attribute12, FND_API.G_MISS_CHAR),
589: NVL(attribute13, FND_API.G_MISS_CHAR),
590: NVL(attribute14, FND_API.G_MISS_CHAR),
591: NVL(attribute15, FND_API.G_MISS_CHAR),
592: NVL(attribute16, FND_API.G_MISS_CHAR),
593: NVL(attribute17, FND_API.G_MISS_CHAR),
594: NVL(attribute18, FND_API.G_MISS_CHAR),

Line 591: NVL(attribute15, FND_API.G_MISS_CHAR),

587: NVL(attribute11, FND_API.G_MISS_CHAR),
588: NVL(attribute12, FND_API.G_MISS_CHAR),
589: NVL(attribute13, FND_API.G_MISS_CHAR),
590: NVL(attribute14, FND_API.G_MISS_CHAR),
591: NVL(attribute15, FND_API.G_MISS_CHAR),
592: NVL(attribute16, FND_API.G_MISS_CHAR),
593: NVL(attribute17, FND_API.G_MISS_CHAR),
594: NVL(attribute18, FND_API.G_MISS_CHAR),
595: NVL(attribute19, FND_API.G_MISS_CHAR),

Line 592: NVL(attribute16, FND_API.G_MISS_CHAR),

588: NVL(attribute12, FND_API.G_MISS_CHAR),
589: NVL(attribute13, FND_API.G_MISS_CHAR),
590: NVL(attribute14, FND_API.G_MISS_CHAR),
591: NVL(attribute15, FND_API.G_MISS_CHAR),
592: NVL(attribute16, FND_API.G_MISS_CHAR),
593: NVL(attribute17, FND_API.G_MISS_CHAR),
594: NVL(attribute18, FND_API.G_MISS_CHAR),
595: NVL(attribute19, FND_API.G_MISS_CHAR),
596: NVL(attribute20, FND_API.G_MISS_CHAR)

Line 593: NVL(attribute17, FND_API.G_MISS_CHAR),

589: NVL(attribute13, FND_API.G_MISS_CHAR),
590: NVL(attribute14, FND_API.G_MISS_CHAR),
591: NVL(attribute15, FND_API.G_MISS_CHAR),
592: NVL(attribute16, FND_API.G_MISS_CHAR),
593: NVL(attribute17, FND_API.G_MISS_CHAR),
594: NVL(attribute18, FND_API.G_MISS_CHAR),
595: NVL(attribute19, FND_API.G_MISS_CHAR),
596: NVL(attribute20, FND_API.G_MISS_CHAR)
597: INTO

Line 594: NVL(attribute18, FND_API.G_MISS_CHAR),

590: NVL(attribute14, FND_API.G_MISS_CHAR),
591: NVL(attribute15, FND_API.G_MISS_CHAR),
592: NVL(attribute16, FND_API.G_MISS_CHAR),
593: NVL(attribute17, FND_API.G_MISS_CHAR),
594: NVL(attribute18, FND_API.G_MISS_CHAR),
595: NVL(attribute19, FND_API.G_MISS_CHAR),
596: NVL(attribute20, FND_API.G_MISS_CHAR)
597: INTO
598: x_orig_system,

Line 595: NVL(attribute19, FND_API.G_MISS_CHAR),

591: NVL(attribute15, FND_API.G_MISS_CHAR),
592: NVL(attribute16, FND_API.G_MISS_CHAR),
593: NVL(attribute17, FND_API.G_MISS_CHAR),
594: NVL(attribute18, FND_API.G_MISS_CHAR),
595: NVL(attribute19, FND_API.G_MISS_CHAR),
596: NVL(attribute20, FND_API.G_MISS_CHAR)
597: INTO
598: x_orig_system,
599: x_owner_table_name,

Line 596: NVL(attribute20, FND_API.G_MISS_CHAR)

592: NVL(attribute16, FND_API.G_MISS_CHAR),
593: NVL(attribute17, FND_API.G_MISS_CHAR),
594: NVL(attribute18, FND_API.G_MISS_CHAR),
595: NVL(attribute19, FND_API.G_MISS_CHAR),
596: NVL(attribute20, FND_API.G_MISS_CHAR)
597: INTO
598: x_orig_system,
599: x_owner_table_name,
600: x_status,

Line 638: RAISE FND_API.G_EXC_ERROR;

634: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
635: FND_MESSAGE.SET_TOKEN('RECORD', 'orig_sys_entity_map_rec');
636: FND_MESSAGE.SET_TOKEN('VALUE', x_orig_system);
637: FND_MSG_PUB.ADD;
638: RAISE FND_API.G_EXC_ERROR;
639:
640: END Select_Row;
641:
642: