197: decode(p_attribute14, FND_API.G_MISS_CHAR, NULL, p_attribute14),
198: decode(p_attribute15, FND_API.G_MISS_CHAR, NULL, p_attribute15),
199: decode(p_creation_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
200: p_creation_date),
201: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
202: NULL, FND_GLOBAL.user_id, p_created_by),
203: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
204: p_last_update_date),
205: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
198: decode(p_attribute15, FND_API.G_MISS_CHAR, NULL, p_attribute15),
199: decode(p_creation_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
200: p_creation_date),
201: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
202: NULL, FND_GLOBAL.user_id, p_created_by),
203: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
204: p_last_update_date),
205: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
206: NULL, FND_GLOBAL.user_id, p_last_updated_by),
201: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
202: NULL, FND_GLOBAL.user_id, p_created_by),
203: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
204: p_last_update_date),
205: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
206: NULL, FND_GLOBAL.user_id, p_last_updated_by),
207: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
208: NULL, FND_GLOBAL.login_id, p_last_update_login)
209: );
202: NULL, FND_GLOBAL.user_id, p_created_by),
203: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
204: p_last_update_date),
205: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
206: NULL, FND_GLOBAL.user_id, p_last_updated_by),
207: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
208: NULL, FND_GLOBAL.login_id, p_last_update_login)
209: );
210:
203: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
204: p_last_update_date),
205: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
206: NULL, FND_GLOBAL.user_id, p_last_updated_by),
207: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
208: NULL, FND_GLOBAL.login_id, p_last_update_login)
209: );
210:
211: OPEN c;
204: p_last_update_date),
205: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
206: NULL, FND_GLOBAL.user_id, p_last_updated_by),
207: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
208: NULL, FND_GLOBAL.login_id, p_last_update_login)
209: );
210:
211: OPEN c;
212: FETCH c INTO x_rowid;
234: language,
235: source_lang
236: )
237: SELECT
238: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
239: NULL, FND_GLOBAL.login_id, p_last_update_login),
240: p_display_name,
241: decode(p_description,FND_API.G_MISS_CHAR, NULL, p_description),
242: decode(p_long_description, FND_API.G_MISS_CHAR, NULL, p_long_description),
235: source_lang
236: )
237: SELECT
238: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
239: NULL, FND_GLOBAL.login_id, p_last_update_login),
240: p_display_name,
241: decode(p_description,FND_API.G_MISS_CHAR, NULL, p_description),
242: decode(p_long_description, FND_API.G_MISS_CHAR, NULL, p_long_description),
243: decode(p_keywords, FND_API.G_MISS_CHAR, NULL, p_keywords),
240: p_display_name,
241: decode(p_description,FND_API.G_MISS_CHAR, NULL, p_description),
242: decode(p_long_description, FND_API.G_MISS_CHAR, NULL, p_long_description),
243: decode(p_keywords, FND_API.G_MISS_CHAR, NULL, p_keywords),
244: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
245: NULL, FND_GLOBAL.user_id, p_last_updated_by),
246: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate,
247: NULL, sysdate, p_last_update_date),
248: decode(p_creation_date, FND_API.G_MISS_DATE, sysdate,
241: decode(p_description,FND_API.G_MISS_CHAR, NULL, p_description),
242: decode(p_long_description, FND_API.G_MISS_CHAR, NULL, p_long_description),
243: decode(p_keywords, FND_API.G_MISS_CHAR, NULL, p_keywords),
244: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
245: NULL, FND_GLOBAL.user_id, p_last_updated_by),
246: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate,
247: NULL, sysdate, p_last_update_date),
248: decode(p_creation_date, FND_API.G_MISS_DATE, sysdate,
249: NULL, sysdate, p_creation_date),
248: decode(p_creation_date, FND_API.G_MISS_DATE, sysdate,
249: NULL, sysdate, p_creation_date),
250: x_section_id,
251: p_object_version_number,
252: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
253: NULL, FND_GLOBAL.user_id, p_created_by),
254: L.language_code,
255: USERENV('LANG')
256: FROM fnd_languages L
249: NULL, sysdate, p_creation_date),
250: x_section_id,
251: p_object_version_number,
252: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
253: NULL, FND_GLOBAL.user_id, p_created_by),
254: L.language_code,
255: USERENV('LANG')
256: FROM fnd_languages L
257: WHERE L.installed_flag IN ('I', 'B')
375: attribute15, p_attribute15),
376: last_update_date = decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate,
377: NULL, sysdate, p_last_update_date),
378: last_updated_by = decode(p_last_updated_by, FND_API.G_MISS_NUM,
379: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,
380: p_last_updated_by),
381: last_update_login = decode(p_last_update_login, FND_API.G_MISS_NUM,
382: FND_GLOBAL.login_id, NULL, FND_GLOBAL.login_id,
383: p_last_update_login)
378: last_updated_by = decode(p_last_updated_by, FND_API.G_MISS_NUM,
379: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,
380: p_last_updated_by),
381: last_update_login = decode(p_last_update_login, FND_API.G_MISS_NUM,
382: FND_GLOBAL.login_id, NULL, FND_GLOBAL.login_id,
383: p_last_update_login)
384: WHERE section_id = p_section_id
385: AND object_version_number = decode(p_object_version_number,
386: FND_API.G_MISS_NUM,
403: keywords = decode(p_keywords, FND_API.G_MISS_CHAR, keywords, p_keywords),
404: last_update_date = decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate,
405: NULL, sysdate, p_last_update_date),
406: last_updated_by = decode(p_last_updated_by, FND_API.G_MISS_NUM,
407: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,
408: p_last_updated_by),
409: last_update_login = decode(p_last_update_login, FND_API.G_MISS_NUM,
410: FND_GLOBAL.login_id, NULL, FND_GLOBAL.login_id,
411: p_last_update_login),
406: last_updated_by = decode(p_last_updated_by, FND_API.G_MISS_NUM,
407: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,
408: p_last_updated_by),
409: last_update_login = decode(p_last_update_login, FND_API.G_MISS_NUM,
410: FND_GLOBAL.login_id, NULL, FND_GLOBAL.login_id,
411: p_last_update_login),
412: source_lang = USERENV('LANG')
413: WHERE section_id = p_section_id
414: --AND object_version_number = decode(p_object_version_number,
1526: p_description,
1527: p_long_description,
1528: p_keywords,
1529: SYSDATE,
1530: FND_GLOBAL.user_id,
1531: SYSDATE,
1532: FND_GLOBAL.user_id,
1533: FND_GLOBAL.login_id,
1534: l_rowid,
1528: p_keywords,
1529: SYSDATE,
1530: FND_GLOBAL.user_id,
1531: SYSDATE,
1532: FND_GLOBAL.user_id,
1533: FND_GLOBAL.login_id,
1534: l_rowid,
1535: x_section_id
1536: );
1529: SYSDATE,
1530: FND_GLOBAL.user_id,
1531: SYSDATE,
1532: FND_GLOBAL.user_id,
1533: FND_GLOBAL.login_id,
1534: l_rowid,
1535: x_section_id
1536: );
1537: EXCEPTION
1788: p_description,
1789: p_long_description,
1790: p_keywords,
1791: SYSDATE,
1792: FND_GLOBAL.user_id,
1793: FND_GLOBAL.login_id
1794: );
1795: EXCEPTION
1796: WHEN NO_DATA_FOUND THEN
1789: p_long_description,
1790: p_keywords,
1791: SYSDATE,
1792: FND_GLOBAL.user_id,
1793: FND_GLOBAL.login_id
1794: );
1795: EXCEPTION
1796: WHEN NO_DATA_FOUND THEN
1797: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_UPDATE_FAIL');