DBA Data[Home] [Help]

APPS.IBE_DSP_SECTION_GRP dependencies on FND_GLOBAL

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

204: decode(p_attribute14, FND_API.G_MISS_CHAR, NULL, p_attribute14),
205: decode(p_attribute15, FND_API.G_MISS_CHAR, NULL, p_attribute15),
206: decode(p_creation_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
207: p_creation_date),
208: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
209: NULL, FND_GLOBAL.user_id, p_created_by),
210: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
211: p_last_update_date),
212: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,

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

205: decode(p_attribute15, FND_API.G_MISS_CHAR, NULL, p_attribute15),
206: decode(p_creation_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
207: p_creation_date),
208: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
209: NULL, FND_GLOBAL.user_id, p_created_by),
210: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
211: p_last_update_date),
212: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
213: NULL, FND_GLOBAL.user_id, p_last_updated_by),

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

208: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
209: NULL, FND_GLOBAL.user_id, p_created_by),
210: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
211: p_last_update_date),
212: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
213: NULL, FND_GLOBAL.user_id, p_last_updated_by),
214: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
215: NULL, FND_GLOBAL.login_id, p_last_update_login)
216: );

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

209: NULL, FND_GLOBAL.user_id, p_created_by),
210: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
211: p_last_update_date),
212: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
213: NULL, FND_GLOBAL.user_id, p_last_updated_by),
214: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
215: NULL, FND_GLOBAL.login_id, p_last_update_login)
216: );
217:

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

210: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
211: p_last_update_date),
212: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
213: NULL, FND_GLOBAL.user_id, p_last_updated_by),
214: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
215: NULL, FND_GLOBAL.login_id, p_last_update_login)
216: );
217:
218: OPEN c;

Line 215: NULL, FND_GLOBAL.login_id, p_last_update_login)

211: p_last_update_date),
212: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
213: NULL, FND_GLOBAL.user_id, p_last_updated_by),
214: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
215: NULL, FND_GLOBAL.login_id, p_last_update_login)
216: );
217:
218: OPEN c;
219: FETCH c INTO x_rowid;

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

241: language,
242: source_lang
243: )
244: SELECT
245: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
246: NULL, FND_GLOBAL.login_id, p_last_update_login),
247: p_display_name,
248: decode(p_description,FND_API.G_MISS_CHAR, NULL, p_description),
249: decode(p_long_description, FND_API.G_MISS_CHAR, NULL, p_long_description),

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

242: source_lang
243: )
244: SELECT
245: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
246: NULL, FND_GLOBAL.login_id, p_last_update_login),
247: p_display_name,
248: decode(p_description,FND_API.G_MISS_CHAR, NULL, p_description),
249: decode(p_long_description, FND_API.G_MISS_CHAR, NULL, p_long_description),
250: decode(p_keywords, FND_API.G_MISS_CHAR, NULL, p_keywords),

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

247: p_display_name,
248: decode(p_description,FND_API.G_MISS_CHAR, NULL, p_description),
249: decode(p_long_description, FND_API.G_MISS_CHAR, NULL, p_long_description),
250: decode(p_keywords, FND_API.G_MISS_CHAR, NULL, p_keywords),
251: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
252: NULL, FND_GLOBAL.user_id, p_last_updated_by),
253: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate,
254: NULL, sysdate, p_last_update_date),
255: decode(p_creation_date, FND_API.G_MISS_DATE, sysdate,

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

248: decode(p_description,FND_API.G_MISS_CHAR, NULL, p_description),
249: decode(p_long_description, FND_API.G_MISS_CHAR, NULL, p_long_description),
250: decode(p_keywords, FND_API.G_MISS_CHAR, NULL, p_keywords),
251: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
252: NULL, FND_GLOBAL.user_id, p_last_updated_by),
253: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate,
254: NULL, sysdate, p_last_update_date),
255: decode(p_creation_date, FND_API.G_MISS_DATE, sysdate,
256: NULL, sysdate, p_creation_date),

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

255: decode(p_creation_date, FND_API.G_MISS_DATE, sysdate,
256: NULL, sysdate, p_creation_date),
257: x_section_id,
258: p_object_version_number,
259: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
260: NULL, FND_GLOBAL.user_id, p_created_by),
261: L.language_code,
262: USERENV('LANG')
263: FROM fnd_languages L

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

256: NULL, sysdate, p_creation_date),
257: x_section_id,
258: p_object_version_number,
259: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
260: NULL, FND_GLOBAL.user_id, p_created_by),
261: L.language_code,
262: USERENV('LANG')
263: FROM fnd_languages L
264: WHERE L.installed_flag IN ('I', 'B')

Line 386: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,

382: attribute15, p_attribute15),
383: last_update_date = decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate,
384: NULL, sysdate, p_last_update_date),
385: last_updated_by = decode(p_last_updated_by, FND_API.G_MISS_NUM,
386: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,
387: p_last_updated_by),
388: last_update_login = decode(p_last_update_login, FND_API.G_MISS_NUM,
389: FND_GLOBAL.login_id, NULL, FND_GLOBAL.login_id,
390: p_last_update_login)

Line 389: FND_GLOBAL.login_id, NULL, FND_GLOBAL.login_id,

385: last_updated_by = decode(p_last_updated_by, FND_API.G_MISS_NUM,
386: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,
387: p_last_updated_by),
388: last_update_login = decode(p_last_update_login, FND_API.G_MISS_NUM,
389: FND_GLOBAL.login_id, NULL, FND_GLOBAL.login_id,
390: p_last_update_login)
391: WHERE section_id = p_section_id
392: AND object_version_number = decode(p_object_version_number,
393: FND_API.G_MISS_NUM,

Line 414: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,

410: keywords = decode(p_keywords, FND_API.G_MISS_CHAR, keywords, p_keywords),
411: last_update_date = decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate,
412: NULL, sysdate, p_last_update_date),
413: last_updated_by = decode(p_last_updated_by, FND_API.G_MISS_NUM,
414: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,
415: p_last_updated_by),
416: last_update_login = decode(p_last_update_login, FND_API.G_MISS_NUM,
417: FND_GLOBAL.login_id, NULL, FND_GLOBAL.login_id,
418: p_last_update_login),

Line 417: FND_GLOBAL.login_id, NULL, FND_GLOBAL.login_id,

413: last_updated_by = decode(p_last_updated_by, FND_API.G_MISS_NUM,
414: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,
415: p_last_updated_by),
416: last_update_login = decode(p_last_update_login, FND_API.G_MISS_NUM,
417: FND_GLOBAL.login_id, NULL, FND_GLOBAL.login_id,
418: p_last_update_login),
419: source_lang = USERENV('LANG')
420: WHERE section_id = p_section_id
421: -- AND object_version_number = decode(p_object_version_number,

Line 1606: FND_GLOBAL.user_id,

1602: p_description,
1603: p_long_description,
1604: p_keywords,
1605: SYSDATE,
1606: FND_GLOBAL.user_id,
1607: SYSDATE,
1608: FND_GLOBAL.user_id,
1609: FND_GLOBAL.login_id,
1610: l_rowid,

Line 1608: FND_GLOBAL.user_id,

1604: p_keywords,
1605: SYSDATE,
1606: FND_GLOBAL.user_id,
1607: SYSDATE,
1608: FND_GLOBAL.user_id,
1609: FND_GLOBAL.login_id,
1610: l_rowid,
1611: x_section_id
1612: );

Line 1609: FND_GLOBAL.login_id,

1605: SYSDATE,
1606: FND_GLOBAL.user_id,
1607: SYSDATE,
1608: FND_GLOBAL.user_id,
1609: FND_GLOBAL.login_id,
1610: l_rowid,
1611: x_section_id
1612: );
1613: EXCEPTION

Line 1887: FND_GLOBAL.user_id,

1883: p_description,
1884: p_long_description,
1885: p_keywords,
1886: SYSDATE,
1887: FND_GLOBAL.user_id,
1888: FND_GLOBAL.login_id
1889: );
1890: EXCEPTION
1891: WHEN NO_DATA_FOUND THEN

Line 1888: FND_GLOBAL.login_id

1884: p_long_description,
1885: p_keywords,
1886: SYSDATE,
1887: FND_GLOBAL.user_id,
1888: FND_GLOBAL.login_id
1889: );
1890: EXCEPTION
1891: WHEN NO_DATA_FOUND THEN
1892: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_UPDATE_FAIL');