DBA Data[Home] [Help]

APPS.JTF_DSP_SECTION_GRP dependencies on FND_GLOBAL

Line 201: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,

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,

Line 202: NULL, FND_GLOBAL.user_id, p_created_by),

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),

Line 205: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,

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: );

Line 206: NULL, FND_GLOBAL.user_id, p_last_updated_by),

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:

Line 207: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,

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;

Line 208: NULL, FND_GLOBAL.login_id, p_last_update_login)

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;

Line 238: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,

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),

Line 239: NULL, FND_GLOBAL.login_id, p_last_update_login),

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),

Line 244: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,

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,

Line 245: NULL, FND_GLOBAL.user_id, p_last_updated_by),

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),

Line 252: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,

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

Line 253: NULL, FND_GLOBAL.user_id, p_created_by),

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')

Line 379: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,

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)

Line 382: FND_GLOBAL.login_id, NULL, FND_GLOBAL.login_id,

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,

Line 407: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,

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),

Line 410: FND_GLOBAL.login_id, NULL, FND_GLOBAL.login_id,

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,

Line 1530: FND_GLOBAL.user_id,

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,

Line 1532: FND_GLOBAL.user_id,

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: );

Line 1533: FND_GLOBAL.login_id,

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

Line 1792: FND_GLOBAL.user_id,

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

Line 1793: FND_GLOBAL.login_id

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');