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 FND_API

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

64:
65: BEGIN
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)))

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

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,
75: NULL,Ltrim(Rtrim(X_ATTRIBUTE1)))

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

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,
78: NULL,Ltrim(Rtrim(X_ATTRIBUTE2)))

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

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,
81: NULL,Ltrim(Rtrim(X_ATTRIBUTE3)))

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

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,
84: NULL,Ltrim(Rtrim(X_ATTRIBUTE4)))

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

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,
87: NULL,Ltrim(Rtrim(X_ATTRIBUTE5)))

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

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,
90: NULL,Ltrim(Rtrim(X_ATTRIBUTE6)))

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

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,
93: NULL,Ltrim(Rtrim(X_ATTRIBUTE7)))

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

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,
96: NULL,Ltrim(Rtrim(X_ATTRIBUTE8)))

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

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,
99: NULL,Ltrim(Rtrim(X_ATTRIBUTE9)))

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

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,
102: NULL,Ltrim(Rtrim(X_ATTRIBUTE10)))

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

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,
105: NULL,Ltrim(Rtrim(X_ATTRIBUTE11)))

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

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,
108: NULL,Ltrim(Rtrim(X_ATTRIBUTE12)))

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

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,
111: NULL,Ltrim(Rtrim(X_ATTRIBUTE13)))

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

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,
114: NULL,Ltrim(Rtrim(X_ATTRIBUTE14)))

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

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,
117: NULL,Ltrim(Rtrim(X_attribute15)))

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

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,
120: G_CREATED_BY,Ltrim(Rtrim(X_CREATED_BY)))

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

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,
123: G_CREATION_DATE,X_CREATION_DATE)

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

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,
126: G_LAST_UPDATE_LOGIN,Ltrim(Rtrim(X_LAST_UPDATE_LOGIN)))

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

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,
129: G_LAST_UPDATE_DATE,X_LAST_UPDATE_DATE)

Line 128: SELECT DECODE(X_last_update_date, FND_API.G_MISS_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,
132: G_LAST_UPDATED_BY,Ltrim(Rtrim(X_LAST_UPDATED_BY)))

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

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:
135: -- dbms_output.put_line('before insert_row');

Line 258: raise fnd_api.g_exc_unexpected_error;

254: ELSE
255: IF (rec.object_version_number <> X_OBJECT_VERSION_NUMBER ) THEN
256: fnd_message.set_name('CN', 'CN_RECORD_CHANGED');
257: fnd_msg_pub.add;
258: raise fnd_api.g_exc_unexpected_error;
259: END IF;
260:
261: SELECT DECODE(X_role_id, FND_API.G_MISS_NUM,
262: rec.role_id,Ltrim(Rtrim(X_role_id)))

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

257: fnd_msg_pub.add;
258: raise fnd_api.g_exc_unexpected_error;
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)))

Line 264: SELECT DECODE(X_pmt_plan_id, FND_API.G_MISS_NUM,

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,
268: rec.start_date,X_start_date)

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

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,
271: rec.end_date,X_end_date)

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

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,
274: rec.attribute_category,Ltrim(Rtrim(X_attribute_category)))

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

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,
277: rec.ATTRIBUTE1,Ltrim(Rtrim(X_ATTRIBUTE1)))

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

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,
280: rec.ATTRIBUTE2,Ltrim(Rtrim(X_ATTRIBUTE2)))

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

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,
283: rec.ATTRIBUTE3,Ltrim(Rtrim(X_ATTRIBUTE3)))

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

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,
286: rec.ATTRIBUTE4,Ltrim(Rtrim(X_ATTRIBUTE4)))

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

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,
289: rec.ATTRIBUTE5,Ltrim(Rtrim(X_ATTRIBUTE5)))

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

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,
292: rec.ATTRIBUTE6,Ltrim(Rtrim(X_ATTRIBUTE6)))

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

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,
295: rec.ATTRIBUTE7,Ltrim(Rtrim(X_ATTRIBUTE7)))

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

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,
298: rec.ATTRIBUTE8,Ltrim(Rtrim(X_ATTRIBUTE8)))

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

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,
301: rec.ATTRIBUTE9,Ltrim(Rtrim(X_ATTRIBUTE9)))

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

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,
304: rec.ATTRIBUTE10,Ltrim(Rtrim(X_ATTRIBUTE10)))

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

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,
307: rec.ATTRIBUTE11,Ltrim(Rtrim(X_ATTRIBUTE11)))

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

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,
310: rec.ATTRIBUTE12,Ltrim(Rtrim(X_ATTRIBUTE12)))

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

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,
313: rec.ATTRIBUTE13,Ltrim(Rtrim(X_ATTRIBUTE13)))

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

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,
316: rec.ATTRIBUTE14,Ltrim(Rtrim(X_ATTRIBUTE14)))

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

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,
319: rec.attribute15,Ltrim(Rtrim(X_attribute15)))

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

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,
322: G_CREATED_BY,Ltrim(Rtrim(X_created_by)))

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

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,
325: G_CREATION_DATE,X_creation_date)

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

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,
328: G_LAST_UPDATE_LOGIN,Ltrim(Rtrim(X_last_update_login)))

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

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,
331: G_LAST_UPDATE_DATE,X_last_update_date)

Line 330: SELECT DECODE(X_last_update_date, FND_API.G_MISS_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,
334: G_LAST_UPDATED_BY,Ltrim(Rtrim(X_last_updated_by)))

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

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:
337: UPDATE cn_role_pmt_plans SET