DBA Data[Home] [Help]

APPS.GCS_FEM_HIER_SYNC_PKG dependencies on FND_GLOBAL

Line 39: AND fuf.user_id = FND_GLOBAL.USER_ID;

35: SELECT 'Y'
36: INTO l_user_assigned_flag
37: FROM fem_user_folders fuf
38: WHERE fuf.folder_id = 1100
39: AND fuf.user_id = FND_GLOBAL.USER_ID;
40: EXCEPTION
41: WHEN NO_DATA_FOUND THEN
42: fem_folders_utl_pkg.assign_user_to_folder(
43: p_api_version => 1.0,

Line 57: AND fuf.user_id = FND_GLOBAL.USER_ID;

53: SELECT 'Y'
54: INTO l_user_assigned_flag
55: FROM fem_user_folders fuf
56: WHERE fuf.folder_id = 1000
57: AND fuf.user_id = FND_GLOBAL.USER_ID;
58: EXCEPTION
59: WHEN NO_DATA_FOUND THEN
60: fem_folders_utl_pkg.assign_user_to_folder(
61: p_api_version => 1.0,

Line 403: FND_GLOBAL.USER_ID,

399: 18,
400: 'Y',
401: 1,
402: sysdate,
403: FND_GLOBAL.USER_ID,
404: sysdate,
405: FND_GLOBAL.USER_ID,
406: FND_GLOBAL.LOGIN_ID,
407: 1,

Line 405: FND_GLOBAL.USER_ID,

401: 1,
402: sysdate,
403: FND_GLOBAL.USER_ID,
404: sysdate,
405: FND_GLOBAL.USER_ID,
406: FND_GLOBAL.LOGIN_ID,
407: 1,
408: 'N'
409: );

Line 406: FND_GLOBAL.LOGIN_ID,

402: sysdate,
403: FND_GLOBAL.USER_ID,
404: sysdate,
405: FND_GLOBAL.USER_ID,
406: FND_GLOBAL.LOGIN_ID,
407: 1,
408: 'N'
409: );
410:

Line 440: FND_GLOBAL.USER_ID,

436: 18,
437: 'Y',
438: 1,
439: sysdate,
440: FND_GLOBAL.USER_ID,
441: sysdate,
442: FND_GLOBAL.USER_ID,
443: FND_GLOBAL.LOGIN_ID,
444: 1,

Line 442: FND_GLOBAL.USER_ID,

438: 1,
439: sysdate,
440: FND_GLOBAL.USER_ID,
441: sysdate,
442: FND_GLOBAL.USER_ID,
443: FND_GLOBAL.LOGIN_ID,
444: 1,
445: 'N'
446: FROM fem_entities_attr fea

Line 443: FND_GLOBAL.LOGIN_ID,

439: sysdate,
440: FND_GLOBAL.USER_ID,
441: sysdate,
442: FND_GLOBAL.USER_ID,
443: FND_GLOBAL.LOGIN_ID,
444: 1,
445: 'N'
446: FROM fem_entities_attr fea
447: WHERE fea.entity_id = l_child_entity_id