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_PMT_PLANS_PKG dependencies on DUAL

Line 70: INTO L_end_date FROM dual;

66: -- dbms_output.put_line('begin insert_row');
67:
68: SELECT DECODE(X_end_date, FND_API.G_MISS_DATE,
69: to_date(NULL),X_end_date)
70: INTO L_end_date FROM dual;
71: SELECT DECODE(X_attribute_category, FND_API.G_MISS_CHAR,
72: NULL,Ltrim(Rtrim(X_attribute_category)))
73: INTO L_attribute_category FROM dual;
74: SELECT DECODE(X_ATTRIBUTE1, FND_API.G_MISS_CHAR,

Line 73: INTO L_attribute_category FROM dual;

69: to_date(NULL),X_end_date)
70: INTO L_end_date FROM dual;
71: SELECT DECODE(X_attribute_category, FND_API.G_MISS_CHAR,
72: NULL,Ltrim(Rtrim(X_attribute_category)))
73: INTO L_attribute_category FROM dual;
74: SELECT DECODE(X_ATTRIBUTE1, FND_API.G_MISS_CHAR,
75: NULL,Ltrim(Rtrim(X_ATTRIBUTE1)))
76: INTO L_ATTRIBUTE1 FROM dual;
77: SELECT DECODE(X_ATTRIBUTE2, FND_API.G_MISS_CHAR,

Line 76: INTO L_ATTRIBUTE1 FROM dual;

72: NULL,Ltrim(Rtrim(X_attribute_category)))
73: INTO L_attribute_category FROM dual;
74: SELECT DECODE(X_ATTRIBUTE1, FND_API.G_MISS_CHAR,
75: NULL,Ltrim(Rtrim(X_ATTRIBUTE1)))
76: INTO L_ATTRIBUTE1 FROM dual;
77: SELECT DECODE(X_ATTRIBUTE2, FND_API.G_MISS_CHAR,
78: NULL,Ltrim(Rtrim(X_ATTRIBUTE2)))
79: INTO L_ATTRIBUTE2 FROM dual;
80: SELECT DECODE(X_ATTRIBUTE3, FND_API.G_MISS_CHAR,

Line 79: INTO L_ATTRIBUTE2 FROM dual;

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

Line 82: INTO L_ATTRIBUTE3 FROM dual;

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

Line 85: INTO L_ATTRIBUTE4 FROM dual;

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

Line 88: INTO L_ATTRIBUTE5 FROM dual;

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

Line 91: INTO L_ATTRIBUTE6 FROM dual;

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

Line 94: INTO L_ATTRIBUTE7 FROM dual;

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

Line 97: INTO L_ATTRIBUTE8 FROM dual;

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

Line 100: INTO L_ATTRIBUTE9 FROM dual;

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

Line 103: INTO L_ATTRIBUTE10 FROM dual;

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

Line 106: INTO L_ATTRIBUTE11 FROM dual;

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

Line 109: INTO L_ATTRIBUTE12 FROM dual;

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

Line 112: INTO L_ATTRIBUTE13 FROM dual;

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

Line 115: INTO L_ATTRIBUTE14 FROM dual;

111: NULL,Ltrim(Rtrim(X_ATTRIBUTE13)))
112: INTO L_ATTRIBUTE13 FROM dual;
113: SELECT DECODE(X_ATTRIBUTE14, FND_API.G_MISS_CHAR,
114: NULL,Ltrim(Rtrim(X_ATTRIBUTE14)))
115: INTO L_ATTRIBUTE14 FROM dual;
116: SELECT DECODE(X_attribute15, FND_API.G_MISS_CHAR,
117: NULL,Ltrim(Rtrim(X_attribute15)))
118: INTO L_attribute15 FROM dual;
119: SELECT DECODE(X_created_by, FND_API.G_MISS_NUM,

Line 118: INTO L_attribute15 FROM dual;

114: NULL,Ltrim(Rtrim(X_ATTRIBUTE14)))
115: INTO L_ATTRIBUTE14 FROM dual;
116: SELECT DECODE(X_attribute15, FND_API.G_MISS_CHAR,
117: NULL,Ltrim(Rtrim(X_attribute15)))
118: INTO L_attribute15 FROM dual;
119: SELECT DECODE(X_created_by, FND_API.G_MISS_NUM,
120: G_CREATED_BY,Ltrim(Rtrim(X_CREATED_BY)))
121: INTO L_created_by FROM dual;
122: SELECT DECODE(X_creation_date, FND_API.G_MISS_DATE,

Line 121: INTO L_created_by FROM dual;

117: NULL,Ltrim(Rtrim(X_attribute15)))
118: INTO L_attribute15 FROM dual;
119: SELECT DECODE(X_created_by, FND_API.G_MISS_NUM,
120: G_CREATED_BY,Ltrim(Rtrim(X_CREATED_BY)))
121: INTO L_created_by FROM dual;
122: SELECT DECODE(X_creation_date, FND_API.G_MISS_DATE,
123: G_CREATION_DATE,X_CREATION_DATE)
124: INTO L_creation_date FROM dual;
125: SELECT DECODE(X_last_update_login, FND_API.G_MISS_NUM,

Line 124: INTO L_creation_date FROM dual;

120: G_CREATED_BY,Ltrim(Rtrim(X_CREATED_BY)))
121: INTO L_created_by FROM dual;
122: SELECT DECODE(X_creation_date, FND_API.G_MISS_DATE,
123: G_CREATION_DATE,X_CREATION_DATE)
124: INTO L_creation_date FROM dual;
125: SELECT DECODE(X_last_update_login, FND_API.G_MISS_NUM,
126: G_LAST_UPDATE_LOGIN,Ltrim(Rtrim(X_LAST_UPDATE_LOGIN)))
127: INTO L_last_update_login FROM dual;
128: SELECT DECODE(X_last_update_date, FND_API.G_MISS_DATE,

Line 127: INTO L_last_update_login FROM dual;

123: G_CREATION_DATE,X_CREATION_DATE)
124: INTO L_creation_date FROM dual;
125: SELECT DECODE(X_last_update_login, FND_API.G_MISS_NUM,
126: G_LAST_UPDATE_LOGIN,Ltrim(Rtrim(X_LAST_UPDATE_LOGIN)))
127: INTO L_last_update_login FROM dual;
128: SELECT DECODE(X_last_update_date, FND_API.G_MISS_DATE,
129: G_LAST_UPDATE_DATE,X_LAST_UPDATE_DATE)
130: INTO L_last_update_date FROM dual;
131: SELECT DECODE(X_last_updated_by, FND_API.G_MISS_NUM,

Line 130: INTO L_last_update_date FROM dual;

126: G_LAST_UPDATE_LOGIN,Ltrim(Rtrim(X_LAST_UPDATE_LOGIN)))
127: INTO L_last_update_login FROM dual;
128: SELECT DECODE(X_last_update_date, FND_API.G_MISS_DATE,
129: G_LAST_UPDATE_DATE,X_LAST_UPDATE_DATE)
130: INTO L_last_update_date FROM dual;
131: SELECT DECODE(X_last_updated_by, FND_API.G_MISS_NUM,
132: G_LAST_UPDATED_BY,Ltrim(Rtrim(X_LAST_UPDATED_BY)))
133: INTO L_last_updated_by FROM dual;
134:

Line 133: INTO L_last_updated_by FROM dual;

129: G_LAST_UPDATE_DATE,X_LAST_UPDATE_DATE)
130: INTO L_last_update_date FROM dual;
131: SELECT DECODE(X_last_updated_by, FND_API.G_MISS_NUM,
132: G_LAST_UPDATED_BY,Ltrim(Rtrim(X_LAST_UPDATED_BY)))
133: INTO L_last_updated_by FROM dual;
134:
135: -- dbms_output.put_line('before insert_row');
136:
137: INSERT INTO cn_role_pmt_plans (

Line 263: INTO rec.role_id FROM dual;

259: END IF;
260:
261: SELECT DECODE(X_role_id, FND_API.G_MISS_NUM,
262: rec.role_id,Ltrim(Rtrim(X_role_id)))
263: INTO rec.role_id FROM dual;
264: SELECT DECODE(X_pmt_plan_id, FND_API.G_MISS_NUM,
265: rec.pmt_plan_id,Ltrim(Rtrim(X_pmt_plan_id)))
266: INTO rec.pmt_plan_id FROM dual;
267: SELECT DECODE(X_start_date, FND_API.G_MISS_DATE,

Line 266: INTO rec.pmt_plan_id FROM dual;

262: rec.role_id,Ltrim(Rtrim(X_role_id)))
263: INTO rec.role_id FROM dual;
264: SELECT DECODE(X_pmt_plan_id, FND_API.G_MISS_NUM,
265: rec.pmt_plan_id,Ltrim(Rtrim(X_pmt_plan_id)))
266: INTO rec.pmt_plan_id FROM dual;
267: SELECT DECODE(X_start_date, FND_API.G_MISS_DATE,
268: rec.start_date,X_start_date)
269: INTO rec.start_date FROM dual;
270: SELECT DECODE(X_end_date, FND_API.G_MISS_DATE,

Line 269: INTO rec.start_date FROM dual;

265: rec.pmt_plan_id,Ltrim(Rtrim(X_pmt_plan_id)))
266: INTO rec.pmt_plan_id FROM dual;
267: SELECT DECODE(X_start_date, FND_API.G_MISS_DATE,
268: rec.start_date,X_start_date)
269: INTO rec.start_date FROM dual;
270: SELECT DECODE(X_end_date, FND_API.G_MISS_DATE,
271: rec.end_date,X_end_date)
272: INTO rec.end_date FROM dual;
273: SELECT DECODE(X_attribute_category, FND_API.G_MISS_CHAR,

Line 272: INTO rec.end_date FROM dual;

268: rec.start_date,X_start_date)
269: INTO rec.start_date FROM dual;
270: SELECT DECODE(X_end_date, FND_API.G_MISS_DATE,
271: rec.end_date,X_end_date)
272: INTO rec.end_date FROM dual;
273: SELECT DECODE(X_attribute_category, FND_API.G_MISS_CHAR,
274: rec.attribute_category,Ltrim(Rtrim(X_attribute_category)))
275: INTO rec.attribute_category FROM dual;
276: SELECT DECODE(X_ATTRIBUTE1, FND_API.G_MISS_CHAR,

Line 275: INTO rec.attribute_category FROM dual;

271: rec.end_date,X_end_date)
272: INTO rec.end_date FROM dual;
273: SELECT DECODE(X_attribute_category, FND_API.G_MISS_CHAR,
274: rec.attribute_category,Ltrim(Rtrim(X_attribute_category)))
275: INTO rec.attribute_category FROM dual;
276: SELECT DECODE(X_ATTRIBUTE1, FND_API.G_MISS_CHAR,
277: rec.ATTRIBUTE1,Ltrim(Rtrim(X_ATTRIBUTE1)))
278: INTO rec.ATTRIBUTE1 FROM dual;
279: SELECT DECODE(X_ATTRIBUTE2, FND_API.G_MISS_CHAR,

Line 278: INTO rec.ATTRIBUTE1 FROM dual;

274: rec.attribute_category,Ltrim(Rtrim(X_attribute_category)))
275: INTO rec.attribute_category FROM dual;
276: SELECT DECODE(X_ATTRIBUTE1, FND_API.G_MISS_CHAR,
277: rec.ATTRIBUTE1,Ltrim(Rtrim(X_ATTRIBUTE1)))
278: INTO rec.ATTRIBUTE1 FROM dual;
279: SELECT DECODE(X_ATTRIBUTE2, FND_API.G_MISS_CHAR,
280: rec.ATTRIBUTE2,Ltrim(Rtrim(X_ATTRIBUTE2)))
281: INTO rec.ATTRIBUTE2 FROM dual;
282: SELECT DECODE(X_ATTRIBUTE3, FND_API.G_MISS_CHAR,

Line 281: INTO rec.ATTRIBUTE2 FROM dual;

277: rec.ATTRIBUTE1,Ltrim(Rtrim(X_ATTRIBUTE1)))
278: INTO rec.ATTRIBUTE1 FROM dual;
279: SELECT DECODE(X_ATTRIBUTE2, FND_API.G_MISS_CHAR,
280: rec.ATTRIBUTE2,Ltrim(Rtrim(X_ATTRIBUTE2)))
281: INTO rec.ATTRIBUTE2 FROM dual;
282: SELECT DECODE(X_ATTRIBUTE3, FND_API.G_MISS_CHAR,
283: rec.ATTRIBUTE3,Ltrim(Rtrim(X_ATTRIBUTE3)))
284: INTO rec.ATTRIBUTE3 FROM dual;
285: SELECT DECODE(X_ATTRIBUTE4, FND_API.G_MISS_CHAR,

Line 284: INTO rec.ATTRIBUTE3 FROM dual;

280: rec.ATTRIBUTE2,Ltrim(Rtrim(X_ATTRIBUTE2)))
281: INTO rec.ATTRIBUTE2 FROM dual;
282: SELECT DECODE(X_ATTRIBUTE3, FND_API.G_MISS_CHAR,
283: rec.ATTRIBUTE3,Ltrim(Rtrim(X_ATTRIBUTE3)))
284: INTO rec.ATTRIBUTE3 FROM dual;
285: SELECT DECODE(X_ATTRIBUTE4, FND_API.G_MISS_CHAR,
286: rec.ATTRIBUTE4,Ltrim(Rtrim(X_ATTRIBUTE4)))
287: INTO rec.ATTRIBUTE4 FROM dual;
288: SELECT DECODE(X_ATTRIBUTE5, FND_API.G_MISS_CHAR,

Line 287: INTO rec.ATTRIBUTE4 FROM dual;

283: rec.ATTRIBUTE3,Ltrim(Rtrim(X_ATTRIBUTE3)))
284: INTO rec.ATTRIBUTE3 FROM dual;
285: SELECT DECODE(X_ATTRIBUTE4, FND_API.G_MISS_CHAR,
286: rec.ATTRIBUTE4,Ltrim(Rtrim(X_ATTRIBUTE4)))
287: INTO rec.ATTRIBUTE4 FROM dual;
288: SELECT DECODE(X_ATTRIBUTE5, FND_API.G_MISS_CHAR,
289: rec.ATTRIBUTE5,Ltrim(Rtrim(X_ATTRIBUTE5)))
290: INTO rec.ATTRIBUTE5 FROM dual;
291: SELECT DECODE(X_ATTRIBUTE6, FND_API.G_MISS_CHAR,

Line 290: INTO rec.ATTRIBUTE5 FROM dual;

286: rec.ATTRIBUTE4,Ltrim(Rtrim(X_ATTRIBUTE4)))
287: INTO rec.ATTRIBUTE4 FROM dual;
288: SELECT DECODE(X_ATTRIBUTE5, FND_API.G_MISS_CHAR,
289: rec.ATTRIBUTE5,Ltrim(Rtrim(X_ATTRIBUTE5)))
290: INTO rec.ATTRIBUTE5 FROM dual;
291: SELECT DECODE(X_ATTRIBUTE6, FND_API.G_MISS_CHAR,
292: rec.ATTRIBUTE6,Ltrim(Rtrim(X_ATTRIBUTE6)))
293: INTO rec.ATTRIBUTE6 FROM dual;
294: SELECT DECODE(X_ATTRIBUTE7, FND_API.G_MISS_CHAR,

Line 293: INTO rec.ATTRIBUTE6 FROM dual;

289: rec.ATTRIBUTE5,Ltrim(Rtrim(X_ATTRIBUTE5)))
290: INTO rec.ATTRIBUTE5 FROM dual;
291: SELECT DECODE(X_ATTRIBUTE6, FND_API.G_MISS_CHAR,
292: rec.ATTRIBUTE6,Ltrim(Rtrim(X_ATTRIBUTE6)))
293: INTO rec.ATTRIBUTE6 FROM dual;
294: SELECT DECODE(X_ATTRIBUTE7, FND_API.G_MISS_CHAR,
295: rec.ATTRIBUTE7,Ltrim(Rtrim(X_ATTRIBUTE7)))
296: INTO rec.ATTRIBUTE7 FROM dual;
297: SELECT DECODE(X_ATTRIBUTE8, FND_API.G_MISS_CHAR,

Line 296: INTO rec.ATTRIBUTE7 FROM dual;

292: rec.ATTRIBUTE6,Ltrim(Rtrim(X_ATTRIBUTE6)))
293: INTO rec.ATTRIBUTE6 FROM dual;
294: SELECT DECODE(X_ATTRIBUTE7, FND_API.G_MISS_CHAR,
295: rec.ATTRIBUTE7,Ltrim(Rtrim(X_ATTRIBUTE7)))
296: INTO rec.ATTRIBUTE7 FROM dual;
297: SELECT DECODE(X_ATTRIBUTE8, FND_API.G_MISS_CHAR,
298: rec.ATTRIBUTE8,Ltrim(Rtrim(X_ATTRIBUTE8)))
299: INTO rec.ATTRIBUTE8 FROM dual;
300: SELECT DECODE(X_ATTRIBUTE9, FND_API.G_MISS_CHAR,

Line 299: INTO rec.ATTRIBUTE8 FROM dual;

295: rec.ATTRIBUTE7,Ltrim(Rtrim(X_ATTRIBUTE7)))
296: INTO rec.ATTRIBUTE7 FROM dual;
297: SELECT DECODE(X_ATTRIBUTE8, FND_API.G_MISS_CHAR,
298: rec.ATTRIBUTE8,Ltrim(Rtrim(X_ATTRIBUTE8)))
299: INTO rec.ATTRIBUTE8 FROM dual;
300: SELECT DECODE(X_ATTRIBUTE9, FND_API.G_MISS_CHAR,
301: rec.ATTRIBUTE9,Ltrim(Rtrim(X_ATTRIBUTE9)))
302: INTO rec.ATTRIBUTE9 FROM dual;
303: SELECT DECODE(X_ATTRIBUTE10, FND_API.G_MISS_CHAR,

Line 302: INTO rec.ATTRIBUTE9 FROM dual;

298: rec.ATTRIBUTE8,Ltrim(Rtrim(X_ATTRIBUTE8)))
299: INTO rec.ATTRIBUTE8 FROM dual;
300: SELECT DECODE(X_ATTRIBUTE9, FND_API.G_MISS_CHAR,
301: rec.ATTRIBUTE9,Ltrim(Rtrim(X_ATTRIBUTE9)))
302: INTO rec.ATTRIBUTE9 FROM dual;
303: SELECT DECODE(X_ATTRIBUTE10, FND_API.G_MISS_CHAR,
304: rec.ATTRIBUTE10,Ltrim(Rtrim(X_ATTRIBUTE10)))
305: INTO rec.ATTRIBUTE10 FROM dual;
306: SELECT DECODE(X_ATTRIBUTE11, FND_API.G_MISS_CHAR,

Line 305: INTO rec.ATTRIBUTE10 FROM dual;

301: rec.ATTRIBUTE9,Ltrim(Rtrim(X_ATTRIBUTE9)))
302: INTO rec.ATTRIBUTE9 FROM dual;
303: SELECT DECODE(X_ATTRIBUTE10, FND_API.G_MISS_CHAR,
304: rec.ATTRIBUTE10,Ltrim(Rtrim(X_ATTRIBUTE10)))
305: INTO rec.ATTRIBUTE10 FROM dual;
306: SELECT DECODE(X_ATTRIBUTE11, FND_API.G_MISS_CHAR,
307: rec.ATTRIBUTE11,Ltrim(Rtrim(X_ATTRIBUTE11)))
308: INTO rec.ATTRIBUTE11 FROM dual;
309: SELECT DECODE(X_ATTRIBUTE12, FND_API.G_MISS_CHAR,

Line 308: INTO rec.ATTRIBUTE11 FROM dual;

304: rec.ATTRIBUTE10,Ltrim(Rtrim(X_ATTRIBUTE10)))
305: INTO rec.ATTRIBUTE10 FROM dual;
306: SELECT DECODE(X_ATTRIBUTE11, FND_API.G_MISS_CHAR,
307: rec.ATTRIBUTE11,Ltrim(Rtrim(X_ATTRIBUTE11)))
308: INTO rec.ATTRIBUTE11 FROM dual;
309: SELECT DECODE(X_ATTRIBUTE12, FND_API.G_MISS_CHAR,
310: rec.ATTRIBUTE12,Ltrim(Rtrim(X_ATTRIBUTE12)))
311: INTO rec.ATTRIBUTE12 FROM dual;
312: SELECT DECODE(X_ATTRIBUTE13, FND_API.G_MISS_CHAR,

Line 311: INTO rec.ATTRIBUTE12 FROM dual;

307: rec.ATTRIBUTE11,Ltrim(Rtrim(X_ATTRIBUTE11)))
308: INTO rec.ATTRIBUTE11 FROM dual;
309: SELECT DECODE(X_ATTRIBUTE12, FND_API.G_MISS_CHAR,
310: rec.ATTRIBUTE12,Ltrim(Rtrim(X_ATTRIBUTE12)))
311: INTO rec.ATTRIBUTE12 FROM dual;
312: SELECT DECODE(X_ATTRIBUTE13, FND_API.G_MISS_CHAR,
313: rec.ATTRIBUTE13,Ltrim(Rtrim(X_ATTRIBUTE13)))
314: INTO rec.ATTRIBUTE13 FROM dual;
315: SELECT DECODE(X_ATTRIBUTE14, FND_API.G_MISS_CHAR,

Line 314: INTO rec.ATTRIBUTE13 FROM dual;

310: rec.ATTRIBUTE12,Ltrim(Rtrim(X_ATTRIBUTE12)))
311: INTO rec.ATTRIBUTE12 FROM dual;
312: SELECT DECODE(X_ATTRIBUTE13, FND_API.G_MISS_CHAR,
313: rec.ATTRIBUTE13,Ltrim(Rtrim(X_ATTRIBUTE13)))
314: INTO rec.ATTRIBUTE13 FROM dual;
315: SELECT DECODE(X_ATTRIBUTE14, FND_API.G_MISS_CHAR,
316: rec.ATTRIBUTE14,Ltrim(Rtrim(X_ATTRIBUTE14)))
317: INTO rec.ATTRIBUTE14 FROM dual;
318: SELECT DECODE(X_attribute15, FND_API.G_MISS_CHAR,

Line 317: INTO rec.ATTRIBUTE14 FROM dual;

313: rec.ATTRIBUTE13,Ltrim(Rtrim(X_ATTRIBUTE13)))
314: INTO rec.ATTRIBUTE13 FROM dual;
315: SELECT DECODE(X_ATTRIBUTE14, FND_API.G_MISS_CHAR,
316: rec.ATTRIBUTE14,Ltrim(Rtrim(X_ATTRIBUTE14)))
317: INTO rec.ATTRIBUTE14 FROM dual;
318: SELECT DECODE(X_attribute15, FND_API.G_MISS_CHAR,
319: rec.attribute15,Ltrim(Rtrim(X_attribute15)))
320: INTO rec.attribute15 FROM dual;
321: SELECT DECODE(X_created_by, FND_API.G_MISS_NUM,

Line 320: INTO rec.attribute15 FROM dual;

316: rec.ATTRIBUTE14,Ltrim(Rtrim(X_ATTRIBUTE14)))
317: INTO rec.ATTRIBUTE14 FROM dual;
318: SELECT DECODE(X_attribute15, FND_API.G_MISS_CHAR,
319: rec.attribute15,Ltrim(Rtrim(X_attribute15)))
320: INTO rec.attribute15 FROM dual;
321: SELECT DECODE(X_created_by, FND_API.G_MISS_NUM,
322: G_CREATED_BY,Ltrim(Rtrim(X_created_by)))
323: INTO rec.created_by FROM dual;
324: SELECT DECODE(X_creation_date, FND_API.G_MISS_DATE,

Line 323: INTO rec.created_by FROM dual;

319: rec.attribute15,Ltrim(Rtrim(X_attribute15)))
320: INTO rec.attribute15 FROM dual;
321: SELECT DECODE(X_created_by, FND_API.G_MISS_NUM,
322: G_CREATED_BY,Ltrim(Rtrim(X_created_by)))
323: INTO rec.created_by FROM dual;
324: SELECT DECODE(X_creation_date, FND_API.G_MISS_DATE,
325: G_CREATION_DATE,X_creation_date)
326: INTO rec.creation_date FROM dual;
327: SELECT DECODE(X_last_update_login, FND_API.G_MISS_NUM,

Line 326: INTO rec.creation_date FROM dual;

322: G_CREATED_BY,Ltrim(Rtrim(X_created_by)))
323: INTO rec.created_by FROM dual;
324: SELECT DECODE(X_creation_date, FND_API.G_MISS_DATE,
325: G_CREATION_DATE,X_creation_date)
326: INTO rec.creation_date FROM dual;
327: SELECT DECODE(X_last_update_login, FND_API.G_MISS_NUM,
328: G_LAST_UPDATE_LOGIN,Ltrim(Rtrim(X_last_update_login)))
329: INTO rec.last_update_login FROM dual;
330: SELECT DECODE(X_last_update_date, FND_API.G_MISS_DATE,

Line 329: INTO rec.last_update_login FROM dual;

325: G_CREATION_DATE,X_creation_date)
326: INTO rec.creation_date FROM dual;
327: SELECT DECODE(X_last_update_login, FND_API.G_MISS_NUM,
328: G_LAST_UPDATE_LOGIN,Ltrim(Rtrim(X_last_update_login)))
329: INTO rec.last_update_login FROM dual;
330: SELECT DECODE(X_last_update_date, FND_API.G_MISS_DATE,
331: G_LAST_UPDATE_DATE,X_last_update_date)
332: INTO rec.last_update_date FROM dual;
333: SELECT DECODE(X_last_updated_by, FND_API.G_MISS_NUM,

Line 332: INTO rec.last_update_date FROM dual;

328: G_LAST_UPDATE_LOGIN,Ltrim(Rtrim(X_last_update_login)))
329: INTO rec.last_update_login FROM dual;
330: SELECT DECODE(X_last_update_date, FND_API.G_MISS_DATE,
331: G_LAST_UPDATE_DATE,X_last_update_date)
332: INTO rec.last_update_date FROM dual;
333: SELECT DECODE(X_last_updated_by, FND_API.G_MISS_NUM,
334: G_LAST_UPDATED_BY,Ltrim(Rtrim(X_last_updated_by)))
335: INTO rec.last_updated_by FROM dual;
336:

Line 335: INTO rec.last_updated_by FROM dual;

331: G_LAST_UPDATE_DATE,X_last_update_date)
332: INTO rec.last_update_date FROM dual;
333: SELECT DECODE(X_last_updated_by, FND_API.G_MISS_NUM,
334: G_LAST_UPDATED_BY,Ltrim(Rtrim(X_last_updated_by)))
335: INTO rec.last_updated_by FROM dual;
336:
337: UPDATE cn_role_pmt_plans SET
338: role_id = rec.role_id,
339: pmt_plan_id = rec.pmt_plan_id,