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