APPS.ALR_DBTRIGGER dependencies on FND_PROFILE

Line 211: alr_dbtrigger.DIAGNOSTICS := FND_PROFILE.VALUE('DIAGNOSTICS');

207: -- Fetch the Diagnostics flag
208: --
209: if alr_dbtrigger.DIAGNOSTICS is NULL then
210: begin
211: alr_dbtrigger.DIAGNOSTICS := FND_PROFILE.VALUE('DIAGNOSTICS');
212:
213: if alr_dbtrigger.DIAGNOSTICS is NULL then
214: alr_dbtrigger.DIAGNOSTICS := 'N'; -- default
215: end if;

Line 811: 'fnd_profile_option_values.profile_option_value%TYPE;' ||

807: 'REQID NUMBER; RETVAL boolean;' ||
808: 'ORGID varchar2(255);' ||
809: 'MORGID number;' ||
810: 'l_security_profile_id ' ||
811: 'fnd_profile_option_values.profile_option_value%TYPE;' ||
812: 'l_org_id fnd_profile_option_values.profile_option_value%TYPE;' ||
813: 'default_org_id fnd_profile_option_values.profile_option_value%TYPE;' ||
814:
815: 'begin ' ||

Line 812: 'l_org_id fnd_profile_option_values.profile_option_value%TYPE;' ||

808: 'ORGID varchar2(255);' ||
809: 'MORGID number;' ||
810: 'l_security_profile_id ' ||
811: 'fnd_profile_option_values.profile_option_value%TYPE;' ||
812: 'l_org_id fnd_profile_option_values.profile_option_value%TYPE;' ||
813: 'default_org_id fnd_profile_option_values.profile_option_value%TYPE;' ||
814:
815: 'begin ' ||
816:

Line 813: 'default_org_id fnd_profile_option_values.profile_option_value%TYPE;' ||

809: 'MORGID number;' ||
810: 'l_security_profile_id ' ||
811: 'fnd_profile_option_values.profile_option_value%TYPE;' ||
812: 'l_org_id fnd_profile_option_values.profile_option_value%TYPE;' ||
813: 'default_org_id fnd_profile_option_values.profile_option_value%TYPE;' ||
814:
815: 'begin ' ||
816:
817: -- JWSMITH Bug 6996306 - no longer user client_infor for org_id

Line 825: ' fnd_profile.get(''XLA_MO_SECURITY_PROFILE_LEVEL'',

821:
822: -- bug 6996306
823: 'select nvl(mo_global.get_current_org_id, 0) into MORGID from dual;' ||
824: 'if (MORGID = 0) then ' ||
825: ' fnd_profile.get(''XLA_MO_SECURITY_PROFILE_LEVEL'',
826: l_security_profile_id);' ||
827: ' if (l_security_profile_id is NULL) then ' ||
828: 'fnd_profile.get(''ORG_ID'', l_org_id);' ||
829: 'ORGID := l_org_id;' ||

Line 828: 'fnd_profile.get(''ORG_ID'', l_org_id);' ||

824: 'if (MORGID = 0) then ' ||
825: ' fnd_profile.get(''XLA_MO_SECURITY_PROFILE_LEVEL'',
826: l_security_profile_id);' ||
827: ' if (l_security_profile_id is NULL) then ' ||
828: 'fnd_profile.get(''ORG_ID'', l_org_id);' ||
829: 'ORGID := l_org_id;' ||
830: ' else ' ||
831: 'fnd_profile.get(''DEFAULT_ORG_ID'', default_org_id);' ||
832: 'ORGID := default_org_id;' ||

Line 831: 'fnd_profile.get(''DEFAULT_ORG_ID'', default_org_id);' ||

827: ' if (l_security_profile_id is NULL) then ' ||
828: 'fnd_profile.get(''ORG_ID'', l_org_id);' ||
829: 'ORGID := l_org_id;' ||
830: ' else ' ||
831: 'fnd_profile.get(''DEFAULT_ORG_ID'', default_org_id);' ||
832: 'ORGID := default_org_id;' ||
833: ' end if;' ||
834: 'else ' ||
835: 'ORGID := TO_CHAR(MORGID);' ||

Line 847: 'fnd_profile.get(''EMAIL_ADDRESS'',MAILID);' ||

843: -- Check if required profiles are present -- otherwise,
844: -- assume that foreign system has fired trigger and
845: -- exit quietly.
846:
847: 'fnd_profile.get(''EMAIL_ADDRESS'',MAILID);' ||
848:
849: 'if MAILID is null then ' ||
850:
851: 'if alr_profile.value(''DEFAULT_USER_MAIL_ACCOUNT'')!=''O'' '||

Line 853: 'fnd_profile.get(''USERNAME'',MAILID);' ||

849: 'if MAILID is null then ' ||
850:
851: 'if alr_profile.value(''DEFAULT_USER_MAIL_ACCOUNT'')!=''O'' '||
852: 'then ' ||
853: 'fnd_profile.get(''USERNAME'',MAILID);' ||
854: 'else ' ||
855: 'fnd_profile.get(''SIGNONAUDIT:LOGIN_NAME'',MAILID);' ||
856: 'end if;' ||
857:

Line 855: 'fnd_profile.get(''SIGNONAUDIT:LOGIN_NAME'',MAILID);' ||

851: 'if alr_profile.value(''DEFAULT_USER_MAIL_ACCOUNT'')!=''O'' '||
852: 'then ' ||
853: 'fnd_profile.get(''USERNAME'',MAILID);' ||
854: 'else ' ||
855: 'fnd_profile.get(''SIGNONAUDIT:LOGIN_NAME'',MAILID);' ||
856: 'end if;' ||
857:
858: 'if MAILID is null then ' ||
859: 'MAILID:=''MAILID'';' ||