DBA Data[Home] [Help]

APPS.CEP_STANDARD dependencies on FND_GLOBAL

Line 50: IF fnd_global.CONC_REQUEST_ID <> -1 THEN

46: 'ce', line);
47: end if;
48:
49:
50: IF fnd_global.CONC_REQUEST_ID <> -1 THEN
51: FND_FILE.put_line(FND_FILE.LOG, line);
52: END IF;
53: End If ;
54:

Line 420: fnd_global.user_name,

416: 1.0,
417: null,
418: p_object_name,
419: null,
420: fnd_global.user_name,
421: null,
422: p_predicate,
423: p_return_status,
424: null);

Line 466: 'rol.user_name in ((select fnd_global.user_name from dual) UNION ALL '||

462:
463: l_final_query := 'SELECT 1 from fnd_grants grt, fnd_objects obj, wf_user_roles rol, xle_entity_profiles le ' ||
464: 'where grt.object_id = obj.object_id and Trunc(Nvl(grt.end_date,SYSDATE)) >= Trunc(SYSDATE) and obj.obj_name = ''' || p_security_mode || ''' and ' ||
465: 'GRANTEE_TYPE = '''||'GROUP'||''' and GRANTEE_KEY = rol.role_name and ' ||
466: 'rol.user_name in ((select fnd_global.user_name from dual) UNION ALL '||
467: '(select incrns.name from wf_local_roles incrns, fnd_user f '||
468: 'where '''|| 'HZ_PARTY' ||''' = incrns.orig_system and f.user_name = fnd_global.user_name '||
469: 'and f.person_party_id = incrns.orig_system_id and incrns.partition_id = 9)) '||
470: 'and INSTANCE_PK1_VALUE = to_char(le.legal_entity_id) '||

Line 468: 'where '''|| 'HZ_PARTY' ||''' = incrns.orig_system and f.user_name = fnd_global.user_name '||

464: 'where grt.object_id = obj.object_id and Trunc(Nvl(grt.end_date,SYSDATE)) >= Trunc(SYSDATE) and obj.obj_name = ''' || p_security_mode || ''' and ' ||
465: 'GRANTEE_TYPE = '''||'GROUP'||''' and GRANTEE_KEY = rol.role_name and ' ||
466: 'rol.user_name in ((select fnd_global.user_name from dual) UNION ALL '||
467: '(select incrns.name from wf_local_roles incrns, fnd_user f '||
468: 'where '''|| 'HZ_PARTY' ||''' = incrns.orig_system and f.user_name = fnd_global.user_name '||
469: 'and f.person_party_id = incrns.orig_system_id and incrns.partition_id = 9)) '||
470: 'and INSTANCE_PK1_VALUE = to_char(le.legal_entity_id) '||
471: 'and le.legal_entity_id = '|| to_char(p_le_id);
472:

Line 541: IF FND_GLOBAL.resp_appl_id=101 THEN

537: l_resp_appl_id NUMBER(15); -- 8823179: Added variable
538: l_appl_name VARCHAR2(50);
539: BEGIN
540: -- 8823179: IF block added
541: IF FND_GLOBAL.resp_appl_id=101 THEN
542: l_resp_appl_id := 260;
543: ELSE
544: l_resp_appl_id := FND_GLOBAL.resp_appl_id;
545: END IF;

Line 544: l_resp_appl_id := FND_GLOBAL.resp_appl_id;

540: -- 8823179: IF block added
541: IF FND_GLOBAL.resp_appl_id=101 THEN
542: l_resp_appl_id := 260;
543: ELSE
544: l_resp_appl_id := FND_GLOBAL.resp_appl_id;
545: END IF;
546:
547: -- call MO Init if it has not been set yet
548: IF MO_GLOBAL.is_mo_init_done = 'N' THEN