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 DUAL

Line 75: INTO L_end_date FROM dual;

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)))
78: INTO L_attribute_category FROM dual;
79: SELECT DECODE(X_ATTRIBUTE1, FND_API.G_MISS_CHAR,

Line 78: INTO L_attribute_category FROM dual;

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)))
81: INTO L_ATTRIBUTE1 FROM dual;
82: SELECT DECODE(X_ATTRIBUTE2, FND_API.G_MISS_CHAR,

Line 81: INTO L_ATTRIBUTE1 FROM dual;

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)))
84: INTO L_ATTRIBUTE2 FROM dual;
85: SELECT DECODE(X_ATTRIBUTE3, FND_API.G_MISS_CHAR,

Line 84: INTO L_ATTRIBUTE2 FROM dual;

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)))
87: INTO L_ATTRIBUTE3 FROM dual;
88: SELECT DECODE(X_ATTRIBUTE4, FND_API.G_MISS_CHAR,

Line 87: INTO L_ATTRIBUTE3 FROM dual;

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)))
90: INTO L_ATTRIBUTE4 FROM dual;
91: SELECT DECODE(X_ATTRIBUTE5, FND_API.G_MISS_CHAR,

Line 90: INTO L_ATTRIBUTE4 FROM dual;

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)))
93: INTO L_ATTRIBUTE5 FROM dual;
94: SELECT DECODE(X_ATTRIBUTE6, FND_API.G_MISS_CHAR,

Line 93: INTO L_ATTRIBUTE5 FROM dual;

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)))
96: INTO L_ATTRIBUTE6 FROM dual;
97: SELECT DECODE(X_ATTRIBUTE7, FND_API.G_MISS_CHAR,

Line 96: INTO L_ATTRIBUTE6 FROM dual;

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)))
99: INTO L_ATTRIBUTE7 FROM dual;
100: SELECT DECODE(X_ATTRIBUTE8, FND_API.G_MISS_CHAR,

Line 99: INTO L_ATTRIBUTE7 FROM dual;

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)))
102: INTO L_ATTRIBUTE8 FROM dual;
103: SELECT DECODE(X_ATTRIBUTE9, FND_API.G_MISS_CHAR,

Line 102: INTO L_ATTRIBUTE8 FROM dual;

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)))
105: INTO L_ATTRIBUTE9 FROM dual;
106: SELECT DECODE(X_ATTRIBUTE10, FND_API.G_MISS_CHAR,

Line 105: INTO L_ATTRIBUTE9 FROM dual;

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)))
108: INTO L_ATTRIBUTE10 FROM dual;
109: SELECT DECODE(X_ATTRIBUTE11, FND_API.G_MISS_CHAR,

Line 108: INTO L_ATTRIBUTE10 FROM dual;

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)))
111: INTO L_ATTRIBUTE11 FROM dual;
112: SELECT DECODE(X_ATTRIBUTE12, FND_API.G_MISS_CHAR,

Line 111: INTO L_ATTRIBUTE11 FROM dual;

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)))
114: INTO L_ATTRIBUTE12 FROM dual;
115: SELECT DECODE(X_ATTRIBUTE13, FND_API.G_MISS_CHAR,

Line 114: INTO L_ATTRIBUTE12 FROM dual;

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)))
117: INTO L_ATTRIBUTE13 FROM dual;
118: SELECT DECODE(X_ATTRIBUTE14, FND_API.G_MISS_CHAR,

Line 117: INTO L_ATTRIBUTE13 FROM dual;

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)))
120: INTO L_ATTRIBUTE14 FROM dual;
121: SELECT DECODE(X_attribute15, FND_API.G_MISS_CHAR,

Line 120: INTO L_ATTRIBUTE14 FROM dual;

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)))
123: INTO L_attribute15 FROM dual;
124: SELECT DECODE(X_created_by, FND_API.G_MISS_NUM,

Line 123: INTO L_attribute15 FROM dual;

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)))
126: INTO L_created_by FROM dual;
127: SELECT DECODE(X_creation_date, FND_API.G_MISS_DATE,

Line 126: INTO L_created_by FROM dual;

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)
129: INTO L_creation_date FROM dual;
130: SELECT DECODE(X_last_update_login, FND_API.G_MISS_NUM,

Line 129: INTO L_creation_date FROM dual;

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)))
132: INTO L_last_update_login FROM dual;
133: SELECT DECODE(X_last_update_date, FND_API.G_MISS_DATE,

Line 132: INTO L_last_update_login FROM dual;

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)
135: INTO L_last_update_date FROM dual;
136: SELECT DECODE(X_last_updated_by, FND_API.G_MISS_NUM,

Line 135: INTO L_last_update_date FROM dual;

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)))
138: INTO L_last_updated_by FROM dual;
139:

Line 138: INTO L_last_updated_by FROM dual;

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');
141:
142: INSERT INTO cn_role_plans (

Line 271: INTO rec.role_id FROM dual;

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)))
274: INTO rec.comp_plan_id FROM dual;
275: SELECT DECODE(X_start_date, FND_API.G_MISS_DATE,

Line 274: INTO rec.comp_plan_id FROM dual;

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)
277: INTO rec.start_date FROM dual;
278: SELECT DECODE(X_end_date, FND_API.G_MISS_DATE,

Line 277: INTO rec.start_date FROM dual;

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)
280: INTO rec.end_date FROM dual;
281: SELECT DECODE(X_attribute_category, FND_API.G_MISS_CHAR,

Line 280: INTO rec.end_date FROM dual;

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)))
283: INTO rec.attribute_category FROM dual;
284: SELECT DECODE(X_ATTRIBUTE1, FND_API.G_MISS_CHAR,

Line 283: INTO rec.attribute_category FROM dual;

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)))
286: INTO rec.ATTRIBUTE1 FROM dual;
287: SELECT DECODE(X_ATTRIBUTE2, FND_API.G_MISS_CHAR,

Line 286: INTO rec.ATTRIBUTE1 FROM dual;

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)))
289: INTO rec.ATTRIBUTE2 FROM dual;
290: SELECT DECODE(X_ATTRIBUTE3, FND_API.G_MISS_CHAR,

Line 289: INTO rec.ATTRIBUTE2 FROM dual;

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)))
292: INTO rec.ATTRIBUTE3 FROM dual;
293: SELECT DECODE(X_ATTRIBUTE4, FND_API.G_MISS_CHAR,

Line 292: INTO rec.ATTRIBUTE3 FROM dual;

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)))
295: INTO rec.ATTRIBUTE4 FROM dual;
296: SELECT DECODE(X_ATTRIBUTE5, FND_API.G_MISS_CHAR,

Line 295: INTO rec.ATTRIBUTE4 FROM dual;

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)))
298: INTO rec.ATTRIBUTE5 FROM dual;
299: SELECT DECODE(X_ATTRIBUTE6, FND_API.G_MISS_CHAR,

Line 298: INTO rec.ATTRIBUTE5 FROM dual;

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)))
301: INTO rec.ATTRIBUTE6 FROM dual;
302: SELECT DECODE(X_ATTRIBUTE7, FND_API.G_MISS_CHAR,

Line 301: INTO rec.ATTRIBUTE6 FROM dual;

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)))
304: INTO rec.ATTRIBUTE7 FROM dual;
305: SELECT DECODE(X_ATTRIBUTE8, FND_API.G_MISS_CHAR,

Line 304: INTO rec.ATTRIBUTE7 FROM dual;

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)))
307: INTO rec.ATTRIBUTE8 FROM dual;
308: SELECT DECODE(X_ATTRIBUTE9, FND_API.G_MISS_CHAR,

Line 307: INTO rec.ATTRIBUTE8 FROM dual;

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)))
310: INTO rec.ATTRIBUTE9 FROM dual;
311: SELECT DECODE(X_ATTRIBUTE10, FND_API.G_MISS_CHAR,

Line 310: INTO rec.ATTRIBUTE9 FROM dual;

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)))
313: INTO rec.ATTRIBUTE10 FROM dual;
314: SELECT DECODE(X_ATTRIBUTE11, FND_API.G_MISS_CHAR,

Line 313: INTO rec.ATTRIBUTE10 FROM dual;

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)))
316: INTO rec.ATTRIBUTE11 FROM dual;
317: SELECT DECODE(X_ATTRIBUTE12, FND_API.G_MISS_CHAR,

Line 316: INTO rec.ATTRIBUTE11 FROM dual;

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)))
319: INTO rec.ATTRIBUTE12 FROM dual;
320: SELECT DECODE(X_ATTRIBUTE13, FND_API.G_MISS_CHAR,

Line 319: INTO rec.ATTRIBUTE12 FROM dual;

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)))
322: INTO rec.ATTRIBUTE13 FROM dual;
323: SELECT DECODE(X_ATTRIBUTE14, FND_API.G_MISS_CHAR,

Line 322: INTO rec.ATTRIBUTE13 FROM dual;

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)))
325: INTO rec.ATTRIBUTE14 FROM dual;
326: SELECT DECODE(X_attribute15, FND_API.G_MISS_CHAR,

Line 325: INTO rec.ATTRIBUTE14 FROM dual;

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)))
328: INTO rec.attribute15 FROM dual;
329: SELECT DECODE(X_created_by, FND_API.G_MISS_NUM,

Line 328: INTO rec.attribute15 FROM dual;

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)))
331: INTO rec.created_by FROM dual;
332: SELECT DECODE(X_creation_date, FND_API.G_MISS_DATE,

Line 331: INTO rec.created_by FROM dual;

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)
334: INTO rec.creation_date FROM dual;
335: SELECT DECODE(X_last_update_login, FND_API.G_MISS_NUM,

Line 334: INTO rec.creation_date FROM dual;

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)))
337: INTO rec.last_update_login FROM dual;
338: SELECT DECODE(X_last_update_date, FND_API.G_MISS_DATE,

Line 337: INTO rec.last_update_login FROM dual;

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)
340: INTO rec.last_update_date FROM dual;
341: SELECT DECODE(X_last_updated_by, FND_API.G_MISS_NUM,

Line 340: INTO rec.last_update_date FROM dual;

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)))
343: INTO rec.last_updated_by FROM dual;
344:

Line 343: INTO rec.last_updated_by FROM dual;

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
346: role_id = rec.role_id,
347: comp_plan_id = rec.comp_plan_id,