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

Line 73: SELECT DECODE(X_end_date, FND_API.G_MISS_DATE,

69:
70: BEGIN
71: -- dbms_output.put_line('begin insert_row');
72:
73: SELECT DECODE(X_end_date, FND_API.G_MISS_DATE,
74: to_date(NULL),X_end_date)
75: INTO L_end_date FROM dual;
76: SELECT DECODE(X_attribute_category, FND_API.G_MISS_CHAR,
77: NULL,Ltrim(Rtrim(X_attribute_category)))

Line 76: SELECT DECODE(X_attribute_category, FND_API.G_MISS_CHAR,

72:
73: SELECT DECODE(X_end_date, FND_API.G_MISS_DATE,
74: to_date(NULL),X_end_date)
75: INTO L_end_date FROM dual;
76: SELECT DECODE(X_attribute_category, FND_API.G_MISS_CHAR,
77: NULL,Ltrim(Rtrim(X_attribute_category)))
78: INTO L_attribute_category FROM dual;
79: SELECT DECODE(X_ATTRIBUTE1, FND_API.G_MISS_CHAR,
80: NULL,Ltrim(Rtrim(X_ATTRIBUTE1)))

Line 79: SELECT DECODE(X_ATTRIBUTE1, FND_API.G_MISS_CHAR,

75: INTO L_end_date FROM dual;
76: SELECT DECODE(X_attribute_category, FND_API.G_MISS_CHAR,
77: NULL,Ltrim(Rtrim(X_attribute_category)))
78: INTO L_attribute_category FROM dual;
79: SELECT DECODE(X_ATTRIBUTE1, FND_API.G_MISS_CHAR,
80: NULL,Ltrim(Rtrim(X_ATTRIBUTE1)))
81: INTO L_ATTRIBUTE1 FROM dual;
82: SELECT DECODE(X_ATTRIBUTE2, FND_API.G_MISS_CHAR,
83: NULL,Ltrim(Rtrim(X_ATTRIBUTE2)))

Line 82: SELECT DECODE(X_ATTRIBUTE2, FND_API.G_MISS_CHAR,

78: INTO L_attribute_category FROM dual;
79: SELECT DECODE(X_ATTRIBUTE1, FND_API.G_MISS_CHAR,
80: NULL,Ltrim(Rtrim(X_ATTRIBUTE1)))
81: INTO L_ATTRIBUTE1 FROM dual;
82: SELECT DECODE(X_ATTRIBUTE2, FND_API.G_MISS_CHAR,
83: NULL,Ltrim(Rtrim(X_ATTRIBUTE2)))
84: INTO L_ATTRIBUTE2 FROM dual;
85: SELECT DECODE(X_ATTRIBUTE3, FND_API.G_MISS_CHAR,
86: NULL,Ltrim(Rtrim(X_ATTRIBUTE3)))

Line 85: SELECT DECODE(X_ATTRIBUTE3, FND_API.G_MISS_CHAR,

81: INTO L_ATTRIBUTE1 FROM dual;
82: SELECT DECODE(X_ATTRIBUTE2, FND_API.G_MISS_CHAR,
83: NULL,Ltrim(Rtrim(X_ATTRIBUTE2)))
84: INTO L_ATTRIBUTE2 FROM dual;
85: SELECT DECODE(X_ATTRIBUTE3, FND_API.G_MISS_CHAR,
86: NULL,Ltrim(Rtrim(X_ATTRIBUTE3)))
87: INTO L_ATTRIBUTE3 FROM dual;
88: SELECT DECODE(X_ATTRIBUTE4, FND_API.G_MISS_CHAR,
89: NULL,Ltrim(Rtrim(X_ATTRIBUTE4)))

Line 88: SELECT DECODE(X_ATTRIBUTE4, FND_API.G_MISS_CHAR,

84: INTO L_ATTRIBUTE2 FROM dual;
85: SELECT DECODE(X_ATTRIBUTE3, FND_API.G_MISS_CHAR,
86: NULL,Ltrim(Rtrim(X_ATTRIBUTE3)))
87: INTO L_ATTRIBUTE3 FROM dual;
88: SELECT DECODE(X_ATTRIBUTE4, FND_API.G_MISS_CHAR,
89: NULL,Ltrim(Rtrim(X_ATTRIBUTE4)))
90: INTO L_ATTRIBUTE4 FROM dual;
91: SELECT DECODE(X_ATTRIBUTE5, FND_API.G_MISS_CHAR,
92: NULL,Ltrim(Rtrim(X_ATTRIBUTE5)))

Line 91: SELECT DECODE(X_ATTRIBUTE5, FND_API.G_MISS_CHAR,

87: INTO L_ATTRIBUTE3 FROM dual;
88: SELECT DECODE(X_ATTRIBUTE4, FND_API.G_MISS_CHAR,
89: NULL,Ltrim(Rtrim(X_ATTRIBUTE4)))
90: INTO L_ATTRIBUTE4 FROM dual;
91: SELECT DECODE(X_ATTRIBUTE5, FND_API.G_MISS_CHAR,
92: NULL,Ltrim(Rtrim(X_ATTRIBUTE5)))
93: INTO L_ATTRIBUTE5 FROM dual;
94: SELECT DECODE(X_ATTRIBUTE6, FND_API.G_MISS_CHAR,
95: NULL,Ltrim(Rtrim(X_ATTRIBUTE6)))

Line 94: SELECT DECODE(X_ATTRIBUTE6, FND_API.G_MISS_CHAR,

90: INTO L_ATTRIBUTE4 FROM dual;
91: SELECT DECODE(X_ATTRIBUTE5, FND_API.G_MISS_CHAR,
92: NULL,Ltrim(Rtrim(X_ATTRIBUTE5)))
93: INTO L_ATTRIBUTE5 FROM dual;
94: SELECT DECODE(X_ATTRIBUTE6, FND_API.G_MISS_CHAR,
95: NULL,Ltrim(Rtrim(X_ATTRIBUTE6)))
96: INTO L_ATTRIBUTE6 FROM dual;
97: SELECT DECODE(X_ATTRIBUTE7, FND_API.G_MISS_CHAR,
98: NULL,Ltrim(Rtrim(X_ATTRIBUTE7)))

Line 97: SELECT DECODE(X_ATTRIBUTE7, FND_API.G_MISS_CHAR,

93: INTO L_ATTRIBUTE5 FROM dual;
94: SELECT DECODE(X_ATTRIBUTE6, FND_API.G_MISS_CHAR,
95: NULL,Ltrim(Rtrim(X_ATTRIBUTE6)))
96: INTO L_ATTRIBUTE6 FROM dual;
97: SELECT DECODE(X_ATTRIBUTE7, FND_API.G_MISS_CHAR,
98: NULL,Ltrim(Rtrim(X_ATTRIBUTE7)))
99: INTO L_ATTRIBUTE7 FROM dual;
100: SELECT DECODE(X_ATTRIBUTE8, FND_API.G_MISS_CHAR,
101: NULL,Ltrim(Rtrim(X_ATTRIBUTE8)))

Line 100: SELECT DECODE(X_ATTRIBUTE8, FND_API.G_MISS_CHAR,

96: INTO L_ATTRIBUTE6 FROM dual;
97: SELECT DECODE(X_ATTRIBUTE7, FND_API.G_MISS_CHAR,
98: NULL,Ltrim(Rtrim(X_ATTRIBUTE7)))
99: INTO L_ATTRIBUTE7 FROM dual;
100: SELECT DECODE(X_ATTRIBUTE8, FND_API.G_MISS_CHAR,
101: NULL,Ltrim(Rtrim(X_ATTRIBUTE8)))
102: INTO L_ATTRIBUTE8 FROM dual;
103: SELECT DECODE(X_ATTRIBUTE9, FND_API.G_MISS_CHAR,
104: NULL,Ltrim(Rtrim(X_ATTRIBUTE9)))

Line 103: SELECT DECODE(X_ATTRIBUTE9, FND_API.G_MISS_CHAR,

99: INTO L_ATTRIBUTE7 FROM dual;
100: SELECT DECODE(X_ATTRIBUTE8, FND_API.G_MISS_CHAR,
101: NULL,Ltrim(Rtrim(X_ATTRIBUTE8)))
102: INTO L_ATTRIBUTE8 FROM dual;
103: SELECT DECODE(X_ATTRIBUTE9, FND_API.G_MISS_CHAR,
104: NULL,Ltrim(Rtrim(X_ATTRIBUTE9)))
105: INTO L_ATTRIBUTE9 FROM dual;
106: SELECT DECODE(X_ATTRIBUTE10, FND_API.G_MISS_CHAR,
107: NULL,Ltrim(Rtrim(X_ATTRIBUTE10)))

Line 106: SELECT DECODE(X_ATTRIBUTE10, FND_API.G_MISS_CHAR,

102: INTO L_ATTRIBUTE8 FROM dual;
103: SELECT DECODE(X_ATTRIBUTE9, FND_API.G_MISS_CHAR,
104: NULL,Ltrim(Rtrim(X_ATTRIBUTE9)))
105: INTO L_ATTRIBUTE9 FROM dual;
106: SELECT DECODE(X_ATTRIBUTE10, FND_API.G_MISS_CHAR,
107: NULL,Ltrim(Rtrim(X_ATTRIBUTE10)))
108: INTO L_ATTRIBUTE10 FROM dual;
109: SELECT DECODE(X_ATTRIBUTE11, FND_API.G_MISS_CHAR,
110: NULL,Ltrim(Rtrim(X_ATTRIBUTE11)))

Line 109: SELECT DECODE(X_ATTRIBUTE11, FND_API.G_MISS_CHAR,

105: INTO L_ATTRIBUTE9 FROM dual;
106: SELECT DECODE(X_ATTRIBUTE10, FND_API.G_MISS_CHAR,
107: NULL,Ltrim(Rtrim(X_ATTRIBUTE10)))
108: INTO L_ATTRIBUTE10 FROM dual;
109: SELECT DECODE(X_ATTRIBUTE11, FND_API.G_MISS_CHAR,
110: NULL,Ltrim(Rtrim(X_ATTRIBUTE11)))
111: INTO L_ATTRIBUTE11 FROM dual;
112: SELECT DECODE(X_ATTRIBUTE12, FND_API.G_MISS_CHAR,
113: NULL,Ltrim(Rtrim(X_ATTRIBUTE12)))

Line 112: SELECT DECODE(X_ATTRIBUTE12, FND_API.G_MISS_CHAR,

108: INTO L_ATTRIBUTE10 FROM dual;
109: SELECT DECODE(X_ATTRIBUTE11, FND_API.G_MISS_CHAR,
110: NULL,Ltrim(Rtrim(X_ATTRIBUTE11)))
111: INTO L_ATTRIBUTE11 FROM dual;
112: SELECT DECODE(X_ATTRIBUTE12, FND_API.G_MISS_CHAR,
113: NULL,Ltrim(Rtrim(X_ATTRIBUTE12)))
114: INTO L_ATTRIBUTE12 FROM dual;
115: SELECT DECODE(X_ATTRIBUTE13, FND_API.G_MISS_CHAR,
116: NULL,Ltrim(Rtrim(X_ATTRIBUTE13)))

Line 115: SELECT DECODE(X_ATTRIBUTE13, FND_API.G_MISS_CHAR,

111: INTO L_ATTRIBUTE11 FROM dual;
112: SELECT DECODE(X_ATTRIBUTE12, FND_API.G_MISS_CHAR,
113: NULL,Ltrim(Rtrim(X_ATTRIBUTE12)))
114: INTO L_ATTRIBUTE12 FROM dual;
115: SELECT DECODE(X_ATTRIBUTE13, FND_API.G_MISS_CHAR,
116: NULL,Ltrim(Rtrim(X_ATTRIBUTE13)))
117: INTO L_ATTRIBUTE13 FROM dual;
118: SELECT DECODE(X_ATTRIBUTE14, FND_API.G_MISS_CHAR,
119: NULL,Ltrim(Rtrim(X_ATTRIBUTE14)))

Line 118: SELECT DECODE(X_ATTRIBUTE14, FND_API.G_MISS_CHAR,

114: INTO L_ATTRIBUTE12 FROM dual;
115: SELECT DECODE(X_ATTRIBUTE13, FND_API.G_MISS_CHAR,
116: NULL,Ltrim(Rtrim(X_ATTRIBUTE13)))
117: INTO L_ATTRIBUTE13 FROM dual;
118: SELECT DECODE(X_ATTRIBUTE14, FND_API.G_MISS_CHAR,
119: NULL,Ltrim(Rtrim(X_ATTRIBUTE14)))
120: INTO L_ATTRIBUTE14 FROM dual;
121: SELECT DECODE(X_attribute15, FND_API.G_MISS_CHAR,
122: NULL,Ltrim(Rtrim(X_attribute15)))

Line 121: SELECT DECODE(X_attribute15, FND_API.G_MISS_CHAR,

117: INTO L_ATTRIBUTE13 FROM dual;
118: SELECT DECODE(X_ATTRIBUTE14, FND_API.G_MISS_CHAR,
119: NULL,Ltrim(Rtrim(X_ATTRIBUTE14)))
120: INTO L_ATTRIBUTE14 FROM dual;
121: SELECT DECODE(X_attribute15, FND_API.G_MISS_CHAR,
122: NULL,Ltrim(Rtrim(X_attribute15)))
123: INTO L_attribute15 FROM dual;
124: SELECT DECODE(X_created_by, FND_API.G_MISS_NUM,
125: G_CREATED_BY,Ltrim(Rtrim(X_CREATED_BY)))

Line 124: SELECT DECODE(X_created_by, FND_API.G_MISS_NUM,

120: INTO L_ATTRIBUTE14 FROM dual;
121: SELECT DECODE(X_attribute15, FND_API.G_MISS_CHAR,
122: NULL,Ltrim(Rtrim(X_attribute15)))
123: INTO L_attribute15 FROM dual;
124: SELECT DECODE(X_created_by, FND_API.G_MISS_NUM,
125: G_CREATED_BY,Ltrim(Rtrim(X_CREATED_BY)))
126: INTO L_created_by FROM dual;
127: SELECT DECODE(X_creation_date, FND_API.G_MISS_DATE,
128: G_CREATION_DATE,X_CREATION_DATE)

Line 127: SELECT DECODE(X_creation_date, FND_API.G_MISS_DATE,

123: INTO L_attribute15 FROM dual;
124: SELECT DECODE(X_created_by, FND_API.G_MISS_NUM,
125: G_CREATED_BY,Ltrim(Rtrim(X_CREATED_BY)))
126: INTO L_created_by FROM dual;
127: SELECT DECODE(X_creation_date, FND_API.G_MISS_DATE,
128: G_CREATION_DATE,X_CREATION_DATE)
129: INTO L_creation_date FROM dual;
130: SELECT DECODE(X_last_update_login, FND_API.G_MISS_NUM,
131: G_LAST_UPDATE_LOGIN,Ltrim(Rtrim(X_LAST_UPDATE_LOGIN)))

Line 130: SELECT DECODE(X_last_update_login, FND_API.G_MISS_NUM,

126: INTO L_created_by FROM dual;
127: SELECT DECODE(X_creation_date, FND_API.G_MISS_DATE,
128: G_CREATION_DATE,X_CREATION_DATE)
129: INTO L_creation_date FROM dual;
130: SELECT DECODE(X_last_update_login, FND_API.G_MISS_NUM,
131: G_LAST_UPDATE_LOGIN,Ltrim(Rtrim(X_LAST_UPDATE_LOGIN)))
132: INTO L_last_update_login FROM dual;
133: SELECT DECODE(X_last_update_date, FND_API.G_MISS_DATE,
134: G_LAST_UPDATE_DATE,X_LAST_UPDATE_DATE)

Line 133: SELECT DECODE(X_last_update_date, FND_API.G_MISS_DATE,

129: INTO L_creation_date FROM dual;
130: SELECT DECODE(X_last_update_login, FND_API.G_MISS_NUM,
131: G_LAST_UPDATE_LOGIN,Ltrim(Rtrim(X_LAST_UPDATE_LOGIN)))
132: INTO L_last_update_login FROM dual;
133: SELECT DECODE(X_last_update_date, FND_API.G_MISS_DATE,
134: G_LAST_UPDATE_DATE,X_LAST_UPDATE_DATE)
135: INTO L_last_update_date FROM dual;
136: SELECT DECODE(X_last_updated_by, FND_API.G_MISS_NUM,
137: G_LAST_UPDATED_BY,Ltrim(Rtrim(X_LAST_UPDATED_BY)))

Line 136: SELECT DECODE(X_last_updated_by, FND_API.G_MISS_NUM,

132: INTO L_last_update_login FROM dual;
133: SELECT DECODE(X_last_update_date, FND_API.G_MISS_DATE,
134: G_LAST_UPDATE_DATE,X_LAST_UPDATE_DATE)
135: INTO L_last_update_date FROM dual;
136: SELECT DECODE(X_last_updated_by, FND_API.G_MISS_NUM,
137: G_LAST_UPDATED_BY,Ltrim(Rtrim(X_LAST_UPDATED_BY)))
138: INTO L_last_updated_by FROM dual;
139:
140: -- dbms_output.put_line('before insert_row');

Line 267: raise fnd_api.g_exc_unexpected_error;

263: ELSE
264: IF (rec.object_version_number <> X_OBJECT_VERSION_NUMBER ) THEN
265: fnd_message.set_name('CN', 'CN_RECORD_CHANGED');
266: fnd_msg_pub.add;
267: raise fnd_api.g_exc_unexpected_error;
268: END IF;
269: SELECT DECODE(X_role_id, FND_API.G_MISS_NUM,
270: rec.role_id,Ltrim(Rtrim(X_role_id)))
271: INTO rec.role_id FROM dual;

Line 269: SELECT DECODE(X_role_id, FND_API.G_MISS_NUM,

265: fnd_message.set_name('CN', 'CN_RECORD_CHANGED');
266: fnd_msg_pub.add;
267: raise fnd_api.g_exc_unexpected_error;
268: END IF;
269: SELECT DECODE(X_role_id, FND_API.G_MISS_NUM,
270: rec.role_id,Ltrim(Rtrim(X_role_id)))
271: INTO rec.role_id FROM dual;
272: SELECT DECODE(X_comp_plan_id, FND_API.G_MISS_NUM,
273: rec.comp_plan_id,Ltrim(Rtrim(X_comp_plan_id)))

Line 272: SELECT DECODE(X_comp_plan_id, FND_API.G_MISS_NUM,

268: END IF;
269: SELECT DECODE(X_role_id, FND_API.G_MISS_NUM,
270: rec.role_id,Ltrim(Rtrim(X_role_id)))
271: INTO rec.role_id FROM dual;
272: SELECT DECODE(X_comp_plan_id, FND_API.G_MISS_NUM,
273: rec.comp_plan_id,Ltrim(Rtrim(X_comp_plan_id)))
274: INTO rec.comp_plan_id FROM dual;
275: SELECT DECODE(X_start_date, FND_API.G_MISS_DATE,
276: rec.start_date,X_start_date)

Line 275: SELECT DECODE(X_start_date, FND_API.G_MISS_DATE,

271: INTO rec.role_id FROM dual;
272: SELECT DECODE(X_comp_plan_id, FND_API.G_MISS_NUM,
273: rec.comp_plan_id,Ltrim(Rtrim(X_comp_plan_id)))
274: INTO rec.comp_plan_id FROM dual;
275: SELECT DECODE(X_start_date, FND_API.G_MISS_DATE,
276: rec.start_date,X_start_date)
277: INTO rec.start_date FROM dual;
278: SELECT DECODE(X_end_date, FND_API.G_MISS_DATE,
279: rec.end_date,X_end_date)

Line 278: SELECT DECODE(X_end_date, FND_API.G_MISS_DATE,

274: INTO rec.comp_plan_id FROM dual;
275: SELECT DECODE(X_start_date, FND_API.G_MISS_DATE,
276: rec.start_date,X_start_date)
277: INTO rec.start_date FROM dual;
278: SELECT DECODE(X_end_date, FND_API.G_MISS_DATE,
279: rec.end_date,X_end_date)
280: INTO rec.end_date FROM dual;
281: SELECT DECODE(X_attribute_category, FND_API.G_MISS_CHAR,
282: rec.attribute_category,Ltrim(Rtrim(X_attribute_category)))

Line 281: SELECT DECODE(X_attribute_category, FND_API.G_MISS_CHAR,

277: INTO rec.start_date FROM dual;
278: SELECT DECODE(X_end_date, FND_API.G_MISS_DATE,
279: rec.end_date,X_end_date)
280: INTO rec.end_date FROM dual;
281: SELECT DECODE(X_attribute_category, FND_API.G_MISS_CHAR,
282: rec.attribute_category,Ltrim(Rtrim(X_attribute_category)))
283: INTO rec.attribute_category FROM dual;
284: SELECT DECODE(X_ATTRIBUTE1, FND_API.G_MISS_CHAR,
285: rec.ATTRIBUTE1,Ltrim(Rtrim(X_ATTRIBUTE1)))

Line 284: SELECT DECODE(X_ATTRIBUTE1, FND_API.G_MISS_CHAR,

280: INTO rec.end_date FROM dual;
281: SELECT DECODE(X_attribute_category, FND_API.G_MISS_CHAR,
282: rec.attribute_category,Ltrim(Rtrim(X_attribute_category)))
283: INTO rec.attribute_category FROM dual;
284: SELECT DECODE(X_ATTRIBUTE1, FND_API.G_MISS_CHAR,
285: rec.ATTRIBUTE1,Ltrim(Rtrim(X_ATTRIBUTE1)))
286: INTO rec.ATTRIBUTE1 FROM dual;
287: SELECT DECODE(X_ATTRIBUTE2, FND_API.G_MISS_CHAR,
288: rec.ATTRIBUTE2,Ltrim(Rtrim(X_ATTRIBUTE2)))

Line 287: SELECT DECODE(X_ATTRIBUTE2, FND_API.G_MISS_CHAR,

283: INTO rec.attribute_category FROM dual;
284: SELECT DECODE(X_ATTRIBUTE1, FND_API.G_MISS_CHAR,
285: rec.ATTRIBUTE1,Ltrim(Rtrim(X_ATTRIBUTE1)))
286: INTO rec.ATTRIBUTE1 FROM dual;
287: SELECT DECODE(X_ATTRIBUTE2, FND_API.G_MISS_CHAR,
288: rec.ATTRIBUTE2,Ltrim(Rtrim(X_ATTRIBUTE2)))
289: INTO rec.ATTRIBUTE2 FROM dual;
290: SELECT DECODE(X_ATTRIBUTE3, FND_API.G_MISS_CHAR,
291: rec.ATTRIBUTE3,Ltrim(Rtrim(X_ATTRIBUTE3)))

Line 290: SELECT DECODE(X_ATTRIBUTE3, FND_API.G_MISS_CHAR,

286: INTO rec.ATTRIBUTE1 FROM dual;
287: SELECT DECODE(X_ATTRIBUTE2, FND_API.G_MISS_CHAR,
288: rec.ATTRIBUTE2,Ltrim(Rtrim(X_ATTRIBUTE2)))
289: INTO rec.ATTRIBUTE2 FROM dual;
290: SELECT DECODE(X_ATTRIBUTE3, FND_API.G_MISS_CHAR,
291: rec.ATTRIBUTE3,Ltrim(Rtrim(X_ATTRIBUTE3)))
292: INTO rec.ATTRIBUTE3 FROM dual;
293: SELECT DECODE(X_ATTRIBUTE4, FND_API.G_MISS_CHAR,
294: rec.ATTRIBUTE4,Ltrim(Rtrim(X_ATTRIBUTE4)))

Line 293: SELECT DECODE(X_ATTRIBUTE4, FND_API.G_MISS_CHAR,

289: INTO rec.ATTRIBUTE2 FROM dual;
290: SELECT DECODE(X_ATTRIBUTE3, FND_API.G_MISS_CHAR,
291: rec.ATTRIBUTE3,Ltrim(Rtrim(X_ATTRIBUTE3)))
292: INTO rec.ATTRIBUTE3 FROM dual;
293: SELECT DECODE(X_ATTRIBUTE4, FND_API.G_MISS_CHAR,
294: rec.ATTRIBUTE4,Ltrim(Rtrim(X_ATTRIBUTE4)))
295: INTO rec.ATTRIBUTE4 FROM dual;
296: SELECT DECODE(X_ATTRIBUTE5, FND_API.G_MISS_CHAR,
297: rec.ATTRIBUTE5,Ltrim(Rtrim(X_ATTRIBUTE5)))

Line 296: SELECT DECODE(X_ATTRIBUTE5, FND_API.G_MISS_CHAR,

292: INTO rec.ATTRIBUTE3 FROM dual;
293: SELECT DECODE(X_ATTRIBUTE4, FND_API.G_MISS_CHAR,
294: rec.ATTRIBUTE4,Ltrim(Rtrim(X_ATTRIBUTE4)))
295: INTO rec.ATTRIBUTE4 FROM dual;
296: SELECT DECODE(X_ATTRIBUTE5, FND_API.G_MISS_CHAR,
297: rec.ATTRIBUTE5,Ltrim(Rtrim(X_ATTRIBUTE5)))
298: INTO rec.ATTRIBUTE5 FROM dual;
299: SELECT DECODE(X_ATTRIBUTE6, FND_API.G_MISS_CHAR,
300: rec.ATTRIBUTE6,Ltrim(Rtrim(X_ATTRIBUTE6)))

Line 299: SELECT DECODE(X_ATTRIBUTE6, FND_API.G_MISS_CHAR,

295: INTO rec.ATTRIBUTE4 FROM dual;
296: SELECT DECODE(X_ATTRIBUTE5, FND_API.G_MISS_CHAR,
297: rec.ATTRIBUTE5,Ltrim(Rtrim(X_ATTRIBUTE5)))
298: INTO rec.ATTRIBUTE5 FROM dual;
299: SELECT DECODE(X_ATTRIBUTE6, FND_API.G_MISS_CHAR,
300: rec.ATTRIBUTE6,Ltrim(Rtrim(X_ATTRIBUTE6)))
301: INTO rec.ATTRIBUTE6 FROM dual;
302: SELECT DECODE(X_ATTRIBUTE7, FND_API.G_MISS_CHAR,
303: rec.ATTRIBUTE7,Ltrim(Rtrim(X_ATTRIBUTE7)))

Line 302: SELECT DECODE(X_ATTRIBUTE7, FND_API.G_MISS_CHAR,

298: INTO rec.ATTRIBUTE5 FROM dual;
299: SELECT DECODE(X_ATTRIBUTE6, FND_API.G_MISS_CHAR,
300: rec.ATTRIBUTE6,Ltrim(Rtrim(X_ATTRIBUTE6)))
301: INTO rec.ATTRIBUTE6 FROM dual;
302: SELECT DECODE(X_ATTRIBUTE7, FND_API.G_MISS_CHAR,
303: rec.ATTRIBUTE7,Ltrim(Rtrim(X_ATTRIBUTE7)))
304: INTO rec.ATTRIBUTE7 FROM dual;
305: SELECT DECODE(X_ATTRIBUTE8, FND_API.G_MISS_CHAR,
306: rec.ATTRIBUTE8,Ltrim(Rtrim(X_ATTRIBUTE8)))

Line 305: SELECT DECODE(X_ATTRIBUTE8, FND_API.G_MISS_CHAR,

301: INTO rec.ATTRIBUTE6 FROM dual;
302: SELECT DECODE(X_ATTRIBUTE7, FND_API.G_MISS_CHAR,
303: rec.ATTRIBUTE7,Ltrim(Rtrim(X_ATTRIBUTE7)))
304: INTO rec.ATTRIBUTE7 FROM dual;
305: SELECT DECODE(X_ATTRIBUTE8, FND_API.G_MISS_CHAR,
306: rec.ATTRIBUTE8,Ltrim(Rtrim(X_ATTRIBUTE8)))
307: INTO rec.ATTRIBUTE8 FROM dual;
308: SELECT DECODE(X_ATTRIBUTE9, FND_API.G_MISS_CHAR,
309: rec.ATTRIBUTE9,Ltrim(Rtrim(X_ATTRIBUTE9)))

Line 308: SELECT DECODE(X_ATTRIBUTE9, FND_API.G_MISS_CHAR,

304: INTO rec.ATTRIBUTE7 FROM dual;
305: SELECT DECODE(X_ATTRIBUTE8, FND_API.G_MISS_CHAR,
306: rec.ATTRIBUTE8,Ltrim(Rtrim(X_ATTRIBUTE8)))
307: INTO rec.ATTRIBUTE8 FROM dual;
308: SELECT DECODE(X_ATTRIBUTE9, FND_API.G_MISS_CHAR,
309: rec.ATTRIBUTE9,Ltrim(Rtrim(X_ATTRIBUTE9)))
310: INTO rec.ATTRIBUTE9 FROM dual;
311: SELECT DECODE(X_ATTRIBUTE10, FND_API.G_MISS_CHAR,
312: rec.ATTRIBUTE10,Ltrim(Rtrim(X_ATTRIBUTE10)))

Line 311: SELECT DECODE(X_ATTRIBUTE10, FND_API.G_MISS_CHAR,

307: INTO rec.ATTRIBUTE8 FROM dual;
308: SELECT DECODE(X_ATTRIBUTE9, FND_API.G_MISS_CHAR,
309: rec.ATTRIBUTE9,Ltrim(Rtrim(X_ATTRIBUTE9)))
310: INTO rec.ATTRIBUTE9 FROM dual;
311: SELECT DECODE(X_ATTRIBUTE10, FND_API.G_MISS_CHAR,
312: rec.ATTRIBUTE10,Ltrim(Rtrim(X_ATTRIBUTE10)))
313: INTO rec.ATTRIBUTE10 FROM dual;
314: SELECT DECODE(X_ATTRIBUTE11, FND_API.G_MISS_CHAR,
315: rec.ATTRIBUTE11,Ltrim(Rtrim(X_ATTRIBUTE11)))

Line 314: SELECT DECODE(X_ATTRIBUTE11, FND_API.G_MISS_CHAR,

310: INTO rec.ATTRIBUTE9 FROM dual;
311: SELECT DECODE(X_ATTRIBUTE10, FND_API.G_MISS_CHAR,
312: rec.ATTRIBUTE10,Ltrim(Rtrim(X_ATTRIBUTE10)))
313: INTO rec.ATTRIBUTE10 FROM dual;
314: SELECT DECODE(X_ATTRIBUTE11, FND_API.G_MISS_CHAR,
315: rec.ATTRIBUTE11,Ltrim(Rtrim(X_ATTRIBUTE11)))
316: INTO rec.ATTRIBUTE11 FROM dual;
317: SELECT DECODE(X_ATTRIBUTE12, FND_API.G_MISS_CHAR,
318: rec.ATTRIBUTE12,Ltrim(Rtrim(X_ATTRIBUTE12)))

Line 317: SELECT DECODE(X_ATTRIBUTE12, FND_API.G_MISS_CHAR,

313: INTO rec.ATTRIBUTE10 FROM dual;
314: SELECT DECODE(X_ATTRIBUTE11, FND_API.G_MISS_CHAR,
315: rec.ATTRIBUTE11,Ltrim(Rtrim(X_ATTRIBUTE11)))
316: INTO rec.ATTRIBUTE11 FROM dual;
317: SELECT DECODE(X_ATTRIBUTE12, FND_API.G_MISS_CHAR,
318: rec.ATTRIBUTE12,Ltrim(Rtrim(X_ATTRIBUTE12)))
319: INTO rec.ATTRIBUTE12 FROM dual;
320: SELECT DECODE(X_ATTRIBUTE13, FND_API.G_MISS_CHAR,
321: rec.ATTRIBUTE13,Ltrim(Rtrim(X_ATTRIBUTE13)))

Line 320: SELECT DECODE(X_ATTRIBUTE13, FND_API.G_MISS_CHAR,

316: INTO rec.ATTRIBUTE11 FROM dual;
317: SELECT DECODE(X_ATTRIBUTE12, FND_API.G_MISS_CHAR,
318: rec.ATTRIBUTE12,Ltrim(Rtrim(X_ATTRIBUTE12)))
319: INTO rec.ATTRIBUTE12 FROM dual;
320: SELECT DECODE(X_ATTRIBUTE13, FND_API.G_MISS_CHAR,
321: rec.ATTRIBUTE13,Ltrim(Rtrim(X_ATTRIBUTE13)))
322: INTO rec.ATTRIBUTE13 FROM dual;
323: SELECT DECODE(X_ATTRIBUTE14, FND_API.G_MISS_CHAR,
324: rec.ATTRIBUTE14,Ltrim(Rtrim(X_ATTRIBUTE14)))

Line 323: SELECT DECODE(X_ATTRIBUTE14, FND_API.G_MISS_CHAR,

319: INTO rec.ATTRIBUTE12 FROM dual;
320: SELECT DECODE(X_ATTRIBUTE13, FND_API.G_MISS_CHAR,
321: rec.ATTRIBUTE13,Ltrim(Rtrim(X_ATTRIBUTE13)))
322: INTO rec.ATTRIBUTE13 FROM dual;
323: SELECT DECODE(X_ATTRIBUTE14, FND_API.G_MISS_CHAR,
324: rec.ATTRIBUTE14,Ltrim(Rtrim(X_ATTRIBUTE14)))
325: INTO rec.ATTRIBUTE14 FROM dual;
326: SELECT DECODE(X_attribute15, FND_API.G_MISS_CHAR,
327: rec.attribute15,Ltrim(Rtrim(X_attribute15)))

Line 326: SELECT DECODE(X_attribute15, FND_API.G_MISS_CHAR,

322: INTO rec.ATTRIBUTE13 FROM dual;
323: SELECT DECODE(X_ATTRIBUTE14, FND_API.G_MISS_CHAR,
324: rec.ATTRIBUTE14,Ltrim(Rtrim(X_ATTRIBUTE14)))
325: INTO rec.ATTRIBUTE14 FROM dual;
326: SELECT DECODE(X_attribute15, FND_API.G_MISS_CHAR,
327: rec.attribute15,Ltrim(Rtrim(X_attribute15)))
328: INTO rec.attribute15 FROM dual;
329: SELECT DECODE(X_created_by, FND_API.G_MISS_NUM,
330: G_CREATED_BY,Ltrim(Rtrim(X_created_by)))

Line 329: SELECT DECODE(X_created_by, FND_API.G_MISS_NUM,

325: INTO rec.ATTRIBUTE14 FROM dual;
326: SELECT DECODE(X_attribute15, FND_API.G_MISS_CHAR,
327: rec.attribute15,Ltrim(Rtrim(X_attribute15)))
328: INTO rec.attribute15 FROM dual;
329: SELECT DECODE(X_created_by, FND_API.G_MISS_NUM,
330: G_CREATED_BY,Ltrim(Rtrim(X_created_by)))
331: INTO rec.created_by FROM dual;
332: SELECT DECODE(X_creation_date, FND_API.G_MISS_DATE,
333: G_CREATION_DATE,X_creation_date)

Line 332: SELECT DECODE(X_creation_date, FND_API.G_MISS_DATE,

328: INTO rec.attribute15 FROM dual;
329: SELECT DECODE(X_created_by, FND_API.G_MISS_NUM,
330: G_CREATED_BY,Ltrim(Rtrim(X_created_by)))
331: INTO rec.created_by FROM dual;
332: SELECT DECODE(X_creation_date, FND_API.G_MISS_DATE,
333: G_CREATION_DATE,X_creation_date)
334: INTO rec.creation_date FROM dual;
335: SELECT DECODE(X_last_update_login, FND_API.G_MISS_NUM,
336: G_LAST_UPDATE_LOGIN,Ltrim(Rtrim(X_last_update_login)))

Line 335: SELECT DECODE(X_last_update_login, FND_API.G_MISS_NUM,

331: INTO rec.created_by FROM dual;
332: SELECT DECODE(X_creation_date, FND_API.G_MISS_DATE,
333: G_CREATION_DATE,X_creation_date)
334: INTO rec.creation_date FROM dual;
335: SELECT DECODE(X_last_update_login, FND_API.G_MISS_NUM,
336: G_LAST_UPDATE_LOGIN,Ltrim(Rtrim(X_last_update_login)))
337: INTO rec.last_update_login FROM dual;
338: SELECT DECODE(X_last_update_date, FND_API.G_MISS_DATE,
339: G_LAST_UPDATE_DATE,X_last_update_date)

Line 338: SELECT DECODE(X_last_update_date, FND_API.G_MISS_DATE,

334: INTO rec.creation_date FROM dual;
335: SELECT DECODE(X_last_update_login, FND_API.G_MISS_NUM,
336: G_LAST_UPDATE_LOGIN,Ltrim(Rtrim(X_last_update_login)))
337: INTO rec.last_update_login FROM dual;
338: SELECT DECODE(X_last_update_date, FND_API.G_MISS_DATE,
339: G_LAST_UPDATE_DATE,X_last_update_date)
340: INTO rec.last_update_date FROM dual;
341: SELECT DECODE(X_last_updated_by, FND_API.G_MISS_NUM,
342: G_LAST_UPDATED_BY,Ltrim(Rtrim(X_last_updated_by)))

Line 341: SELECT DECODE(X_last_updated_by, FND_API.G_MISS_NUM,

337: INTO rec.last_update_login FROM dual;
338: SELECT DECODE(X_last_update_date, FND_API.G_MISS_DATE,
339: G_LAST_UPDATE_DATE,X_last_update_date)
340: INTO rec.last_update_date FROM dual;
341: SELECT DECODE(X_last_updated_by, FND_API.G_MISS_NUM,
342: G_LAST_UPDATED_BY,Ltrim(Rtrim(X_last_updated_by)))
343: INTO rec.last_updated_by FROM dual;
344:
345: UPDATE cn_role_plans SET