DBA Data[Home] [Help]

APPS.HZ_PARTY_USG_ASSIGNMENTS_PKG dependencies on FND_API

Line 94: FND_API.G_MISS_DATE, trunc(sysdate),

90: x_party_id,
91: x_party_usage_code,
92: DECODE(x_effective_start_date,
93: NULL, trunc(sysdate),
94: FND_API.G_MISS_DATE, trunc(sysdate),
95: trunc(x_effective_start_date)),
96: DECODE(x_effective_end_date,
97: NULL, D_FUTURE_DATE,
98: FND_API.G_MISS_DATE, D_FUTURE_DATE,

Line 98: FND_API.G_MISS_DATE, D_FUTURE_DATE,

94: FND_API.G_MISS_DATE, trunc(sysdate),
95: trunc(x_effective_start_date)),
96: DECODE(x_effective_end_date,
97: NULL, D_FUTURE_DATE,
98: FND_API.G_MISS_DATE, D_FUTURE_DATE,
99: trunc(x_effective_end_date)),
100: DECODE(x_status_flag,
101: NULL, 'A',
102: FND_API.G_MISS_CHAR, 'A',

Line 102: FND_API.G_MISS_CHAR, 'A',

98: FND_API.G_MISS_DATE, D_FUTURE_DATE,
99: trunc(x_effective_end_date)),
100: DECODE(x_status_flag,
101: NULL, 'A',
102: FND_API.G_MISS_CHAR, 'A',
103: x_status_flag),
104: DECODE(x_comments,
105: FND_API.G_MISS_CHAR, NULL,
106: x_comments),

Line 105: FND_API.G_MISS_CHAR, NULL,

101: NULL, 'A',
102: FND_API.G_MISS_CHAR, 'A',
103: x_status_flag),
104: DECODE(x_comments,
105: FND_API.G_MISS_CHAR, NULL,
106: x_comments),
107: DECODE(x_owner_table_name,
108: FND_API.G_MISS_CHAR, NULL,
109: x_owner_table_name),

Line 108: FND_API.G_MISS_CHAR, NULL,

104: DECODE(x_comments,
105: FND_API.G_MISS_CHAR, NULL,
106: x_comments),
107: DECODE(x_owner_table_name,
108: FND_API.G_MISS_CHAR, NULL,
109: x_owner_table_name),
110: DECODE(x_owner_table_id,
111: FND_API.G_MISS_NUM, NULL,
112: x_owner_table_id),

Line 111: FND_API.G_MISS_NUM, NULL,

107: DECODE(x_owner_table_name,
108: FND_API.G_MISS_CHAR, NULL,
109: x_owner_table_name),
110: DECODE(x_owner_table_id,
111: FND_API.G_MISS_NUM, NULL,
112: x_owner_table_id),
113: DECODE(x_attribute_category,
114: FND_API.G_MISS_CHAR, NULL,
115: x_attribute_category),

Line 114: FND_API.G_MISS_CHAR, NULL,

110: DECODE(x_owner_table_id,
111: FND_API.G_MISS_NUM, NULL,
112: x_owner_table_id),
113: DECODE(x_attribute_category,
114: FND_API.G_MISS_CHAR, NULL,
115: x_attribute_category),
116: DECODE(x_attribute1,
117: FND_API.G_MISS_CHAR, NULL,
118: x_attribute1),

Line 117: FND_API.G_MISS_CHAR, NULL,

113: DECODE(x_attribute_category,
114: FND_API.G_MISS_CHAR, NULL,
115: x_attribute_category),
116: DECODE(x_attribute1,
117: FND_API.G_MISS_CHAR, NULL,
118: x_attribute1),
119: DECODE(x_attribute2,
120: FND_API.G_MISS_CHAR, NULL,
121: x_attribute2),

Line 120: FND_API.G_MISS_CHAR, NULL,

116: DECODE(x_attribute1,
117: FND_API.G_MISS_CHAR, NULL,
118: x_attribute1),
119: DECODE(x_attribute2,
120: FND_API.G_MISS_CHAR, NULL,
121: x_attribute2),
122: DECODE(x_attribute3,
123: FND_API.G_MISS_CHAR, NULL,
124: x_attribute3),

Line 123: FND_API.G_MISS_CHAR, NULL,

119: DECODE(x_attribute2,
120: FND_API.G_MISS_CHAR, NULL,
121: x_attribute2),
122: DECODE(x_attribute3,
123: FND_API.G_MISS_CHAR, NULL,
124: x_attribute3),
125: DECODE(x_attribute4,
126: FND_API.G_MISS_CHAR, NULL,
127: x_attribute4),

Line 126: FND_API.G_MISS_CHAR, NULL,

122: DECODE(x_attribute3,
123: FND_API.G_MISS_CHAR, NULL,
124: x_attribute3),
125: DECODE(x_attribute4,
126: FND_API.G_MISS_CHAR, NULL,
127: x_attribute4),
128: DECODE(x_attribute5,
129: FND_API.G_MISS_CHAR, NULL,
130: x_attribute5),

Line 129: FND_API.G_MISS_CHAR, NULL,

125: DECODE(x_attribute4,
126: FND_API.G_MISS_CHAR, NULL,
127: x_attribute4),
128: DECODE(x_attribute5,
129: FND_API.G_MISS_CHAR, NULL,
130: x_attribute5),
131: DECODE(x_attribute6,
132: FND_API.G_MISS_CHAR, NULL,
133: x_attribute6),

Line 132: FND_API.G_MISS_CHAR, NULL,

128: DECODE(x_attribute5,
129: FND_API.G_MISS_CHAR, NULL,
130: x_attribute5),
131: DECODE(x_attribute6,
132: FND_API.G_MISS_CHAR, NULL,
133: x_attribute6),
134: DECODE(x_attribute7,
135: FND_API.G_MISS_CHAR, NULL,
136: x_attribute7),

Line 135: FND_API.G_MISS_CHAR, NULL,

131: DECODE(x_attribute6,
132: FND_API.G_MISS_CHAR, NULL,
133: x_attribute6),
134: DECODE(x_attribute7,
135: FND_API.G_MISS_CHAR, NULL,
136: x_attribute7),
137: DECODE(x_attribute8,
138: FND_API.G_MISS_CHAR, NULL,
139: x_attribute8),

Line 138: FND_API.G_MISS_CHAR, NULL,

134: DECODE(x_attribute7,
135: FND_API.G_MISS_CHAR, NULL,
136: x_attribute7),
137: DECODE(x_attribute8,
138: FND_API.G_MISS_CHAR, NULL,
139: x_attribute8),
140: DECODE(x_attribute9,
141: FND_API.G_MISS_CHAR, NULL,
142: x_attribute9),

Line 141: FND_API.G_MISS_CHAR, NULL,

137: DECODE(x_attribute8,
138: FND_API.G_MISS_CHAR, NULL,
139: x_attribute8),
140: DECODE(x_attribute9,
141: FND_API.G_MISS_CHAR, NULL,
142: x_attribute9),
143: DECODE(x_attribute10,
144: FND_API.G_MISS_CHAR, NULL,
145: x_attribute10),

Line 144: FND_API.G_MISS_CHAR, NULL,

140: DECODE(x_attribute9,
141: FND_API.G_MISS_CHAR, NULL,
142: x_attribute9),
143: DECODE(x_attribute10,
144: FND_API.G_MISS_CHAR, NULL,
145: x_attribute10),
146: DECODE(x_attribute11,
147: FND_API.G_MISS_CHAR, NULL,
148: x_attribute11),

Line 147: FND_API.G_MISS_CHAR, NULL,

143: DECODE(x_attribute10,
144: FND_API.G_MISS_CHAR, NULL,
145: x_attribute10),
146: DECODE(x_attribute11,
147: FND_API.G_MISS_CHAR, NULL,
148: x_attribute11),
149: DECODE(x_attribute12,
150: FND_API.G_MISS_CHAR, NULL,
151: x_attribute12),

Line 150: FND_API.G_MISS_CHAR, NULL,

146: DECODE(x_attribute11,
147: FND_API.G_MISS_CHAR, NULL,
148: x_attribute11),
149: DECODE(x_attribute12,
150: FND_API.G_MISS_CHAR, NULL,
151: x_attribute12),
152: DECODE(x_attribute13,
153: FND_API.G_MISS_CHAR, NULL,
154: x_attribute13),

Line 153: FND_API.G_MISS_CHAR, NULL,

149: DECODE(x_attribute12,
150: FND_API.G_MISS_CHAR, NULL,
151: x_attribute12),
152: DECODE(x_attribute13,
153: FND_API.G_MISS_CHAR, NULL,
154: x_attribute13),
155: DECODE(x_attribute14,
156: FND_API.G_MISS_CHAR, NULL,
157: x_attribute14),

Line 156: FND_API.G_MISS_CHAR, NULL,

152: DECODE(x_attribute13,
153: FND_API.G_MISS_CHAR, NULL,
154: x_attribute13),
155: DECODE(x_attribute14,
156: FND_API.G_MISS_CHAR, NULL,
157: x_attribute14),
158: DECODE(x_attribute15,
159: FND_API.G_MISS_CHAR, NULL,
160: x_attribute15),

Line 159: FND_API.G_MISS_CHAR, NULL,

155: DECODE(x_attribute14,
156: FND_API.G_MISS_CHAR, NULL,
157: x_attribute14),
158: DECODE(x_attribute15,
159: FND_API.G_MISS_CHAR, NULL,
160: x_attribute15),
161: DECODE(x_attribute16,
162: FND_API.G_MISS_CHAR, NULL,
163: x_attribute16),

Line 162: FND_API.G_MISS_CHAR, NULL,

158: DECODE(x_attribute15,
159: FND_API.G_MISS_CHAR, NULL,
160: x_attribute15),
161: DECODE(x_attribute16,
162: FND_API.G_MISS_CHAR, NULL,
163: x_attribute16),
164: DECODE(x_attribute17,
165: FND_API.G_MISS_CHAR, NULL,
166: x_attribute17),

Line 165: FND_API.G_MISS_CHAR, NULL,

161: DECODE(x_attribute16,
162: FND_API.G_MISS_CHAR, NULL,
163: x_attribute16),
164: DECODE(x_attribute17,
165: FND_API.G_MISS_CHAR, NULL,
166: x_attribute17),
167: DECODE(x_attribute18,
168: FND_API.G_MISS_CHAR, NULL,
169: x_attribute18),

Line 168: FND_API.G_MISS_CHAR, NULL,

164: DECODE(x_attribute17,
165: FND_API.G_MISS_CHAR, NULL,
166: x_attribute17),
167: DECODE(x_attribute18,
168: FND_API.G_MISS_CHAR, NULL,
169: x_attribute18),
170: DECODE(x_attribute19,
171: FND_API.G_MISS_CHAR, NULL,
172: x_attribute19),

Line 171: FND_API.G_MISS_CHAR, NULL,

167: DECODE(x_attribute18,
168: FND_API.G_MISS_CHAR, NULL,
169: x_attribute18),
170: DECODE(x_attribute19,
171: FND_API.G_MISS_CHAR, NULL,
172: x_attribute19),
173: DECODE(x_attribute20,
174: FND_API.G_MISS_CHAR, NULL,
175: x_attribute20),

Line 174: FND_API.G_MISS_CHAR, NULL,

170: DECODE(x_attribute19,
171: FND_API.G_MISS_CHAR, NULL,
172: x_attribute19),
173: DECODE(x_attribute20,
174: FND_API.G_MISS_CHAR, NULL,
175: x_attribute20),
176: x_object_version_number,
177: x_created_by_module,
178: hz_utility_v2pub.application_id,

Line 250: FND_API.G_MISS_DATE, D_FUTURE_DATE,

246: trunc(x_effective_start_date)),
247: effective_end_date =
248: DECODE(x_effective_end_date,
249: NULL, effective_end_date,
250: FND_API.G_MISS_DATE, D_FUTURE_DATE,
251: trunc(x_effective_end_date)),
252: status_flag =
253: DECODE(x_status_flag,
254: NULL, status_flag,

Line 259: FND_API.G_MISS_CHAR, NULL,

255: x_status_flag),
256: comments =
257: DECODE(x_comments,
258: NULL, comments,
259: FND_API.G_MISS_CHAR, NULL,
260: x_comments),
261: owner_table_name =
262: DECODE(x_owner_table_name,
263: NULL, owner_table_name,

Line 264: FND_API.G_MISS_CHAR, NULL,

260: x_comments),
261: owner_table_name =
262: DECODE(x_owner_table_name,
263: NULL, owner_table_name,
264: FND_API.G_MISS_CHAR, NULL,
265: x_owner_table_name),
266: owner_table_id =
267: DECODE(x_owner_table_id,
268: NULL, owner_table_id,

Line 269: FND_API.G_MISS_CHAR, NULL,

265: x_owner_table_name),
266: owner_table_id =
267: DECODE(x_owner_table_id,
268: NULL, owner_table_id,
269: FND_API.G_MISS_CHAR, NULL,
270: x_owner_table_id),
271: attribute_category =
272: DECODE(x_attribute_category,
273: NULL, attribute_category,

Line 274: FND_API.G_MISS_CHAR, NULL,

270: x_owner_table_id),
271: attribute_category =
272: DECODE(x_attribute_category,
273: NULL, attribute_category,
274: FND_API.G_MISS_CHAR, NULL,
275: x_attribute_category),
276: attribute1 =
277: DECODE(x_attribute1,
278: NULL, attribute1,

Line 279: FND_API.G_MISS_CHAR, NULL,

275: x_attribute_category),
276: attribute1 =
277: DECODE(x_attribute1,
278: NULL, attribute1,
279: FND_API.G_MISS_CHAR, NULL,
280: x_attribute1),
281: attribute2 =
282: DECODE(x_attribute2,
283: NULL, attribute2,

Line 284: FND_API.G_MISS_CHAR, NULL,

280: x_attribute1),
281: attribute2 =
282: DECODE(x_attribute2,
283: NULL, attribute2,
284: FND_API.G_MISS_CHAR, NULL,
285: x_attribute2),
286: attribute3 =
287: DECODE(x_attribute3,
288: NULL, attribute3,

Line 289: FND_API.G_MISS_CHAR, NULL,

285: x_attribute2),
286: attribute3 =
287: DECODE(x_attribute3,
288: NULL, attribute3,
289: FND_API.G_MISS_CHAR, NULL,
290: x_attribute3),
291: attribute4 =
292: DECODE(x_attribute4,
293: NULL, attribute4,

Line 294: FND_API.G_MISS_CHAR, NULL,

290: x_attribute3),
291: attribute4 =
292: DECODE(x_attribute4,
293: NULL, attribute4,
294: FND_API.G_MISS_CHAR, NULL,
295: x_attribute4),
296: attribute5 =
297: DECODE(x_attribute5,
298: NULL, attribute5,

Line 299: FND_API.G_MISS_CHAR, NULL,

295: x_attribute4),
296: attribute5 =
297: DECODE(x_attribute5,
298: NULL, attribute5,
299: FND_API.G_MISS_CHAR, NULL,
300: x_attribute5),
301: attribute6 =
302: DECODE(x_attribute6,
303: NULL, attribute6,

Line 304: FND_API.G_MISS_CHAR, NULL,

300: x_attribute5),
301: attribute6 =
302: DECODE(x_attribute6,
303: NULL, attribute6,
304: FND_API.G_MISS_CHAR, NULL,
305: x_attribute6),
306: attribute7 =
307: DECODE(x_attribute7,
308: NULL, attribute7,

Line 309: FND_API.G_MISS_CHAR, NULL,

305: x_attribute6),
306: attribute7 =
307: DECODE(x_attribute7,
308: NULL, attribute7,
309: FND_API.G_MISS_CHAR, NULL,
310: x_attribute7),
311: attribute8 =
312: DECODE(x_attribute8,
313: NULL, attribute8,

Line 314: FND_API.G_MISS_CHAR, NULL,

310: x_attribute7),
311: attribute8 =
312: DECODE(x_attribute8,
313: NULL, attribute8,
314: FND_API.G_MISS_CHAR, NULL,
315: x_attribute8),
316: attribute9 =
317: DECODE(x_attribute9,
318: NULL, attribute9,

Line 319: FND_API.G_MISS_CHAR, NULL,

315: x_attribute8),
316: attribute9 =
317: DECODE(x_attribute9,
318: NULL, attribute9,
319: FND_API.G_MISS_CHAR, NULL,
320: x_attribute9),
321: attribute10 =
322: DECODE(x_attribute10,
323: NULL, attribute10,

Line 324: FND_API.G_MISS_CHAR, NULL,

320: x_attribute9),
321: attribute10 =
322: DECODE(x_attribute10,
323: NULL, attribute10,
324: FND_API.G_MISS_CHAR, NULL,
325: x_attribute10),
326: attribute11 =
327: DECODE(x_attribute11,
328: NULL, attribute11,

Line 329: FND_API.G_MISS_CHAR, NULL,

325: x_attribute10),
326: attribute11 =
327: DECODE(x_attribute11,
328: NULL, attribute11,
329: FND_API.G_MISS_CHAR, NULL,
330: x_attribute11),
331: attribute12 =
332: DECODE(x_attribute12,
333: NULL, attribute12,

Line 334: FND_API.G_MISS_CHAR, NULL,

330: x_attribute11),
331: attribute12 =
332: DECODE(x_attribute12,
333: NULL, attribute12,
334: FND_API.G_MISS_CHAR, NULL,
335: x_attribute12),
336: attribute13 =
337: DECODE(x_attribute13,
338: NULL, attribute13,

Line 339: FND_API.G_MISS_CHAR, NULL,

335: x_attribute12),
336: attribute13 =
337: DECODE(x_attribute13,
338: NULL, attribute13,
339: FND_API.G_MISS_CHAR, NULL,
340: x_attribute13),
341: attribute14 =
342: DECODE(x_attribute14,
343: NULL, attribute14,

Line 344: FND_API.G_MISS_CHAR, NULL,

340: x_attribute13),
341: attribute14 =
342: DECODE(x_attribute14,
343: NULL, attribute14,
344: FND_API.G_MISS_CHAR, NULL,
345: x_attribute14),
346: attribute15 =
347: DECODE(x_attribute15,
348: NULL, attribute15,

Line 349: FND_API.G_MISS_CHAR, NULL,

345: x_attribute14),
346: attribute15 =
347: DECODE(x_attribute15,
348: NULL, attribute15,
349: FND_API.G_MISS_CHAR, NULL,
350: x_attribute15),
351: attribute16 =
352: DECODE(x_attribute16,
353: NULL, attribute16,

Line 354: FND_API.G_MISS_CHAR, NULL,

350: x_attribute15),
351: attribute16 =
352: DECODE(x_attribute16,
353: NULL, attribute16,
354: FND_API.G_MISS_CHAR, NULL,
355: x_attribute16),
356: attribute17 =
357: DECODE(x_attribute17,
358: NULL, attribute17,

Line 359: FND_API.G_MISS_CHAR, NULL,

355: x_attribute16),
356: attribute17 =
357: DECODE(x_attribute17,
358: NULL, attribute17,
359: FND_API.G_MISS_CHAR, NULL,
360: x_attribute17),
361: attribute18 =
362: DECODE(x_attribute18,
363: NULL, attribute18,

Line 364: FND_API.G_MISS_CHAR, NULL,

360: x_attribute17),
361: attribute18 =
362: DECODE(x_attribute18,
363: NULL, attribute18,
364: FND_API.G_MISS_CHAR, NULL,
365: x_attribute18),
366: attribute19 =
367: DECODE(x_attribute19,
368: NULL, attribute19,

Line 369: FND_API.G_MISS_CHAR, NULL,

365: x_attribute18),
366: attribute19 =
367: DECODE(x_attribute19,
368: NULL, attribute19,
369: FND_API.G_MISS_CHAR, NULL,
370: x_attribute19),
371: attribute20 =
372: DECODE(x_attribute20,
373: NULL, attribute20,

Line 374: FND_API.G_MISS_CHAR, NULL,

370: x_attribute19),
371: attribute20 =
372: DECODE(x_attribute20,
373: NULL, attribute20,
374: FND_API.G_MISS_CHAR, NULL,
375: x_attribute20),
376: object_version_number =
377: DECODE(x_object_version_number,
378: NULL, object_version_number,