DBA Data[Home] [Help]

APPS.CN_SEC_PROF_ASSIGNS_PKG dependencies on FND_API

Line 36: fnd_api.g_miss_date, NULL,

32: END IF;
33:
34: SELECT
35: Decode(x_new_rec.end_date,
36: fnd_api.g_miss_date, NULL,
37: x_new_rec.end_date),
38: Decode(x_new_rec.attribute_category,
39: fnd_api.g_miss_char, NULL,
40: x_new_rec.attribute_category),

Line 39: fnd_api.g_miss_char, NULL,

35: Decode(x_new_rec.end_date,
36: fnd_api.g_miss_date, NULL,
37: x_new_rec.end_date),
38: Decode(x_new_rec.attribute_category,
39: fnd_api.g_miss_char, NULL,
40: x_new_rec.attribute_category),
41: Decode(x_new_rec.attribute1,
42: fnd_api.g_miss_char, NULL,
43: x_new_rec.attribute1),

Line 42: fnd_api.g_miss_char, NULL,

38: Decode(x_new_rec.attribute_category,
39: fnd_api.g_miss_char, NULL,
40: x_new_rec.attribute_category),
41: Decode(x_new_rec.attribute1,
42: fnd_api.g_miss_char, NULL,
43: x_new_rec.attribute1),
44: Decode(x_new_rec.attribute2,
45: fnd_api.g_miss_char, NULL,
46: x_new_rec.attribute2),

Line 45: fnd_api.g_miss_char, NULL,

41: Decode(x_new_rec.attribute1,
42: fnd_api.g_miss_char, NULL,
43: x_new_rec.attribute1),
44: Decode(x_new_rec.attribute2,
45: fnd_api.g_miss_char, NULL,
46: x_new_rec.attribute2),
47: Decode(x_new_rec.attribute3,
48: fnd_api.g_miss_char, NULL,
49: x_new_rec.attribute3),

Line 48: fnd_api.g_miss_char, NULL,

44: Decode(x_new_rec.attribute2,
45: fnd_api.g_miss_char, NULL,
46: x_new_rec.attribute2),
47: Decode(x_new_rec.attribute3,
48: fnd_api.g_miss_char, NULL,
49: x_new_rec.attribute3),
50: Decode(x_new_rec.attribute4,
51: fnd_api.g_miss_char, NULL,
52: x_new_rec.attribute4),

Line 51: fnd_api.g_miss_char, NULL,

47: Decode(x_new_rec.attribute3,
48: fnd_api.g_miss_char, NULL,
49: x_new_rec.attribute3),
50: Decode(x_new_rec.attribute4,
51: fnd_api.g_miss_char, NULL,
52: x_new_rec.attribute4),
53: Decode(x_new_rec.attribute5,
54: fnd_api.g_miss_char, NULL,
55: x_new_rec.attribute5),

Line 54: fnd_api.g_miss_char, NULL,

50: Decode(x_new_rec.attribute4,
51: fnd_api.g_miss_char, NULL,
52: x_new_rec.attribute4),
53: Decode(x_new_rec.attribute5,
54: fnd_api.g_miss_char, NULL,
55: x_new_rec.attribute5),
56: Decode(x_new_rec.attribute6,
57: fnd_api.g_miss_char, NULL,
58: x_new_rec.attribute6),

Line 57: fnd_api.g_miss_char, NULL,

53: Decode(x_new_rec.attribute5,
54: fnd_api.g_miss_char, NULL,
55: x_new_rec.attribute5),
56: Decode(x_new_rec.attribute6,
57: fnd_api.g_miss_char, NULL,
58: x_new_rec.attribute6),
59: Decode(x_new_rec.attribute7,
60: fnd_api.g_miss_char, NULL,
61: x_new_rec.attribute7),

Line 60: fnd_api.g_miss_char, NULL,

56: Decode(x_new_rec.attribute6,
57: fnd_api.g_miss_char, NULL,
58: x_new_rec.attribute6),
59: Decode(x_new_rec.attribute7,
60: fnd_api.g_miss_char, NULL,
61: x_new_rec.attribute7),
62: Decode(x_new_rec.attribute8,
63: fnd_api.g_miss_char, NULL,
64: x_new_rec.attribute8),

Line 63: fnd_api.g_miss_char, NULL,

59: Decode(x_new_rec.attribute7,
60: fnd_api.g_miss_char, NULL,
61: x_new_rec.attribute7),
62: Decode(x_new_rec.attribute8,
63: fnd_api.g_miss_char, NULL,
64: x_new_rec.attribute8),
65: Decode(x_new_rec.attribute9,
66: fnd_api.g_miss_char, NULL,
67: x_new_rec.attribute9),

Line 66: fnd_api.g_miss_char, NULL,

62: Decode(x_new_rec.attribute8,
63: fnd_api.g_miss_char, NULL,
64: x_new_rec.attribute8),
65: Decode(x_new_rec.attribute9,
66: fnd_api.g_miss_char, NULL,
67: x_new_rec.attribute9),
68: Decode(x_new_rec.attribute10,
69: fnd_api.g_miss_char, NULL,
70: x_new_rec.attribute10),

Line 69: fnd_api.g_miss_char, NULL,

65: Decode(x_new_rec.attribute9,
66: fnd_api.g_miss_char, NULL,
67: x_new_rec.attribute9),
68: Decode(x_new_rec.attribute10,
69: fnd_api.g_miss_char, NULL,
70: x_new_rec.attribute10),
71: Decode(x_new_rec.attribute11,
72: fnd_api.g_miss_char, NULL,
73: x_new_rec.attribute11),

Line 72: fnd_api.g_miss_char, NULL,

68: Decode(x_new_rec.attribute10,
69: fnd_api.g_miss_char, NULL,
70: x_new_rec.attribute10),
71: Decode(x_new_rec.attribute11,
72: fnd_api.g_miss_char, NULL,
73: x_new_rec.attribute11),
74: Decode(x_new_rec.attribute12,
75: fnd_api.g_miss_char, NULL,
76: x_new_rec.attribute12),

Line 75: fnd_api.g_miss_char, NULL,

71: Decode(x_new_rec.attribute11,
72: fnd_api.g_miss_char, NULL,
73: x_new_rec.attribute11),
74: Decode(x_new_rec.attribute12,
75: fnd_api.g_miss_char, NULL,
76: x_new_rec.attribute12),
77: Decode(x_new_rec.attribute13,
78: fnd_api.g_miss_char, NULL,
79: x_new_rec.attribute13),

Line 78: fnd_api.g_miss_char, NULL,

74: Decode(x_new_rec.attribute12,
75: fnd_api.g_miss_char, NULL,
76: x_new_rec.attribute12),
77: Decode(x_new_rec.attribute13,
78: fnd_api.g_miss_char, NULL,
79: x_new_rec.attribute13),
80: Decode(x_new_rec.attribute14,
81: fnd_api.g_miss_char, NULL,
82: x_new_rec.attribute14),

Line 81: fnd_api.g_miss_char, NULL,

77: Decode(x_new_rec.attribute13,
78: fnd_api.g_miss_char, NULL,
79: x_new_rec.attribute13),
80: Decode(x_new_rec.attribute14,
81: fnd_api.g_miss_char, NULL,
82: x_new_rec.attribute14),
83: Decode(x_new_rec.attribute15,
84: fnd_api.g_miss_char, NULL,
85: x_new_rec.attribute15),

Line 84: fnd_api.g_miss_char, NULL,

80: Decode(x_new_rec.attribute14,
81: fnd_api.g_miss_char, NULL,
82: x_new_rec.attribute14),
83: Decode(x_new_rec.attribute15,
84: fnd_api.g_miss_char, NULL,
85: x_new_rec.attribute15),
86: Decode(x_new_rec.created_by,
87: cn_api.g_miss_id, g_created_by,
88: x_new_rec.created_by),

Line 90: fnd_api.g_miss_date, g_creation_date,

86: Decode(x_new_rec.created_by,
87: cn_api.g_miss_id, g_created_by,
88: x_new_rec.created_by),
89: Decode(x_new_rec.creation_date,
90: fnd_api.g_miss_date, g_creation_date,
91: x_new_rec.creation_date),
92: Decode(x_new_rec.last_update_login,
93: cn_api.g_miss_id, g_last_update_login,
94: x_new_rec.last_update_login),

Line 96: fnd_api.g_miss_date, g_last_update_date,

92: Decode(x_new_rec.last_update_login,
93: cn_api.g_miss_id, g_last_update_login,
94: x_new_rec.last_update_login),
95: Decode(x_new_rec.last_update_date,
96: fnd_api.g_miss_date, g_last_update_date,
97: x_new_rec.last_update_date),
98: Decode(x_new_rec.last_updated_by,
99: cn_api.g_miss_id, g_last_updated_by,
100: x_new_rec.last_updated_by)

Line 220: fnd_api.g_miss_date, rec.start_date,

216: Decode(x_new_rec.salesrep_id,
217: cn_api.g_miss_id, rec.salesrep_id,
218: x_new_rec.salesrep_id),
219: Decode(x_new_rec.start_date,
220: fnd_api.g_miss_date, rec.start_date,
221: x_new_rec.start_date),
222: Decode(x_new_rec.end_date,
223: fnd_api.g_miss_date, rec.end_date,
224: x_new_rec.end_date),

Line 223: fnd_api.g_miss_date, rec.end_date,

219: Decode(x_new_rec.start_date,
220: fnd_api.g_miss_date, rec.start_date,
221: x_new_rec.start_date),
222: Decode(x_new_rec.end_date,
223: fnd_api.g_miss_date, rec.end_date,
224: x_new_rec.end_date),
225: Decode(x_new_rec.attribute_category,
226: fnd_api.g_miss_char, rec.attribute_category,
227: x_new_rec.attribute_category),

Line 226: fnd_api.g_miss_char, rec.attribute_category,

222: Decode(x_new_rec.end_date,
223: fnd_api.g_miss_date, rec.end_date,
224: x_new_rec.end_date),
225: Decode(x_new_rec.attribute_category,
226: fnd_api.g_miss_char, rec.attribute_category,
227: x_new_rec.attribute_category),
228: Decode(x_new_rec.attribute1,
229: fnd_api.g_miss_char, rec.attribute1,
230: x_new_rec.attribute1),

Line 229: fnd_api.g_miss_char, rec.attribute1,

225: Decode(x_new_rec.attribute_category,
226: fnd_api.g_miss_char, rec.attribute_category,
227: x_new_rec.attribute_category),
228: Decode(x_new_rec.attribute1,
229: fnd_api.g_miss_char, rec.attribute1,
230: x_new_rec.attribute1),
231: Decode(x_new_rec.attribute2,
232: fnd_api.g_miss_char, rec.attribute2,
233: x_new_rec.attribute2),

Line 232: fnd_api.g_miss_char, rec.attribute2,

228: Decode(x_new_rec.attribute1,
229: fnd_api.g_miss_char, rec.attribute1,
230: x_new_rec.attribute1),
231: Decode(x_new_rec.attribute2,
232: fnd_api.g_miss_char, rec.attribute2,
233: x_new_rec.attribute2),
234: Decode(x_new_rec.attribute3,
235: fnd_api.g_miss_char, rec.attribute3,
236: x_new_rec.attribute3),

Line 235: fnd_api.g_miss_char, rec.attribute3,

231: Decode(x_new_rec.attribute2,
232: fnd_api.g_miss_char, rec.attribute2,
233: x_new_rec.attribute2),
234: Decode(x_new_rec.attribute3,
235: fnd_api.g_miss_char, rec.attribute3,
236: x_new_rec.attribute3),
237: Decode(x_new_rec.attribute4,
238: fnd_api.g_miss_char, rec.attribute4,
239: x_new_rec.attribute4),

Line 238: fnd_api.g_miss_char, rec.attribute4,

234: Decode(x_new_rec.attribute3,
235: fnd_api.g_miss_char, rec.attribute3,
236: x_new_rec.attribute3),
237: Decode(x_new_rec.attribute4,
238: fnd_api.g_miss_char, rec.attribute4,
239: x_new_rec.attribute4),
240: Decode(x_new_rec.attribute5,
241: fnd_api.g_miss_char, rec.attribute5,
242: x_new_rec.attribute5),

Line 241: fnd_api.g_miss_char, rec.attribute5,

237: Decode(x_new_rec.attribute4,
238: fnd_api.g_miss_char, rec.attribute4,
239: x_new_rec.attribute4),
240: Decode(x_new_rec.attribute5,
241: fnd_api.g_miss_char, rec.attribute5,
242: x_new_rec.attribute5),
243: Decode(x_new_rec.attribute6,
244: fnd_api.g_miss_char, rec.attribute6,
245: x_new_rec.attribute6),

Line 244: fnd_api.g_miss_char, rec.attribute6,

240: Decode(x_new_rec.attribute5,
241: fnd_api.g_miss_char, rec.attribute5,
242: x_new_rec.attribute5),
243: Decode(x_new_rec.attribute6,
244: fnd_api.g_miss_char, rec.attribute6,
245: x_new_rec.attribute6),
246: Decode(x_new_rec.attribute7,
247: fnd_api.g_miss_char, rec.attribute7,
248: x_new_rec.attribute7),

Line 247: fnd_api.g_miss_char, rec.attribute7,

243: Decode(x_new_rec.attribute6,
244: fnd_api.g_miss_char, rec.attribute6,
245: x_new_rec.attribute6),
246: Decode(x_new_rec.attribute7,
247: fnd_api.g_miss_char, rec.attribute7,
248: x_new_rec.attribute7),
249: Decode(x_new_rec.attribute8,
250: fnd_api.g_miss_char, rec.attribute8,
251: x_new_rec.attribute8),

Line 250: fnd_api.g_miss_char, rec.attribute8,

246: Decode(x_new_rec.attribute7,
247: fnd_api.g_miss_char, rec.attribute7,
248: x_new_rec.attribute7),
249: Decode(x_new_rec.attribute8,
250: fnd_api.g_miss_char, rec.attribute8,
251: x_new_rec.attribute8),
252: Decode(x_new_rec.attribute9,
253: fnd_api.g_miss_char, rec.attribute9,
254: x_new_rec.attribute9),

Line 253: fnd_api.g_miss_char, rec.attribute9,

249: Decode(x_new_rec.attribute8,
250: fnd_api.g_miss_char, rec.attribute8,
251: x_new_rec.attribute8),
252: Decode(x_new_rec.attribute9,
253: fnd_api.g_miss_char, rec.attribute9,
254: x_new_rec.attribute9),
255: Decode(x_new_rec.attribute10,
256: fnd_api.g_miss_char, rec.attribute10,
257: x_new_rec.attribute10),

Line 256: fnd_api.g_miss_char, rec.attribute10,

252: Decode(x_new_rec.attribute9,
253: fnd_api.g_miss_char, rec.attribute9,
254: x_new_rec.attribute9),
255: Decode(x_new_rec.attribute10,
256: fnd_api.g_miss_char, rec.attribute10,
257: x_new_rec.attribute10),
258: Decode(x_new_rec.attribute11,
259: fnd_api.g_miss_char, rec.attribute11,
260: x_new_rec.attribute11),

Line 259: fnd_api.g_miss_char, rec.attribute11,

255: Decode(x_new_rec.attribute10,
256: fnd_api.g_miss_char, rec.attribute10,
257: x_new_rec.attribute10),
258: Decode(x_new_rec.attribute11,
259: fnd_api.g_miss_char, rec.attribute11,
260: x_new_rec.attribute11),
261: Decode(x_new_rec.attribute12,
262: fnd_api.g_miss_char, rec.attribute12,
263: x_new_rec.attribute12),

Line 262: fnd_api.g_miss_char, rec.attribute12,

258: Decode(x_new_rec.attribute11,
259: fnd_api.g_miss_char, rec.attribute11,
260: x_new_rec.attribute11),
261: Decode(x_new_rec.attribute12,
262: fnd_api.g_miss_char, rec.attribute12,
263: x_new_rec.attribute12),
264: Decode(x_new_rec.attribute13,
265: fnd_api.g_miss_char, rec.attribute13,
266: x_new_rec.attribute13),

Line 265: fnd_api.g_miss_char, rec.attribute13,

261: Decode(x_new_rec.attribute12,
262: fnd_api.g_miss_char, rec.attribute12,
263: x_new_rec.attribute12),
264: Decode(x_new_rec.attribute13,
265: fnd_api.g_miss_char, rec.attribute13,
266: x_new_rec.attribute13),
267: Decode(x_new_rec.attribute14,
268: fnd_api.g_miss_char, rec.attribute14,
269: x_new_rec.attribute14),

Line 268: fnd_api.g_miss_char, rec.attribute14,

264: Decode(x_new_rec.attribute13,
265: fnd_api.g_miss_char, rec.attribute13,
266: x_new_rec.attribute13),
267: Decode(x_new_rec.attribute14,
268: fnd_api.g_miss_char, rec.attribute14,
269: x_new_rec.attribute14),
270: Decode(x_new_rec.attribute15,
271: fnd_api.g_miss_char, rec.attribute15,
272: x_new_rec.attribute15),

Line 271: fnd_api.g_miss_char, rec.attribute15,

267: Decode(x_new_rec.attribute14,
268: fnd_api.g_miss_char, rec.attribute14,
269: x_new_rec.attribute14),
270: Decode(x_new_rec.attribute15,
271: fnd_api.g_miss_char, rec.attribute15,
272: x_new_rec.attribute15),
273: Decode(x_new_rec.last_update_login,
274: cn_api.g_miss_id, g_last_update_login,
275: x_new_rec.last_update_login),

Line 277: fnd_api.g_miss_date, g_last_update_date,

273: Decode(x_new_rec.last_update_login,
274: cn_api.g_miss_id, g_last_update_login,
275: x_new_rec.last_update_login),
276: Decode(x_new_rec.last_update_date,
277: fnd_api.g_miss_date, g_last_update_date,
278: x_new_rec.last_update_date),
279: Decode(x_new_rec.last_updated_by,
280: cn_api.g_miss_id, g_last_updated_by,
281: x_new_rec.last_updated_by)