DBA Data[Home] [Help]

APPS.FND_SIGNON dependencies on FND_GLOBAL

Line 541: if (FND_GLOBAL.USER_ID = -1) or (FND_GLOBAL.USER_ID = 6) then

537: if ((l_proxy_user_id is not NULL) AND
538: (l_proxy_user_id <> -1)) then
539: l_audit_level := 'D';
540: else
541: if (FND_GLOBAL.USER_ID = -1) or (FND_GLOBAL.USER_ID = 6) then
542: l_audit_level:=
543: fnd_profile.value_specific('SIGNONAUDIT:LEVEL', UID);
544: else
545: l_audit_level:= fnd_profile.value('SIGNONAUDIT:LEVEL');

Line 693: Fnd_Preference.Put(Fnd_Global.User_Name, 'FNDSCSGN',

689: Fnd_Signon.Update_Desktop_Object(function10, 10,
690: user_id, resp_id, appl_id, login_id);
691:
692: -- Save window position to preferences
693: Fnd_Preference.Put(Fnd_Global.User_Name, 'FNDSCSGN',
694: 'WINDOW_WIDTH',
695: fnd_number.number_to_canonical(window_width));
696: Fnd_Preference.Put(Fnd_Global.User_Name, 'FNDSCSGN',
697: 'WINDOW_HEIGHT',

Line 696: Fnd_Preference.Put(Fnd_Global.User_Name, 'FNDSCSGN',

692: -- Save window position to preferences
693: Fnd_Preference.Put(Fnd_Global.User_Name, 'FNDSCSGN',
694: 'WINDOW_WIDTH',
695: fnd_number.number_to_canonical(window_width));
696: Fnd_Preference.Put(Fnd_Global.User_Name, 'FNDSCSGN',
697: 'WINDOW_HEIGHT',
698: fnd_number.number_to_canonical(window_height));
699: Fnd_Preference.Put(Fnd_Global.User_Name, 'FNDSCSGN',
700: 'WINDOW_XPOS',

Line 699: Fnd_Preference.Put(Fnd_Global.User_Name, 'FNDSCSGN',

695: fnd_number.number_to_canonical(window_width));
696: Fnd_Preference.Put(Fnd_Global.User_Name, 'FNDSCSGN',
697: 'WINDOW_HEIGHT',
698: fnd_number.number_to_canonical(window_height));
699: Fnd_Preference.Put(Fnd_Global.User_Name, 'FNDSCSGN',
700: 'WINDOW_XPOS',
701: fnd_number.number_to_canonical(window_xpos));
702: Fnd_Preference.Put(Fnd_Global.User_Name, 'FNDSCSGN',
703: 'WINDOW_YPOS',

Line 702: Fnd_Preference.Put(Fnd_Global.User_Name, 'FNDSCSGN',

698: fnd_number.number_to_canonical(window_height));
699: Fnd_Preference.Put(Fnd_Global.User_Name, 'FNDSCSGN',
700: 'WINDOW_XPOS',
701: fnd_number.number_to_canonical(window_xpos));
702: Fnd_Preference.Put(Fnd_Global.User_Name, 'FNDSCSGN',
703: 'WINDOW_YPOS',
704: fnd_number.number_to_canonical(window_ypos));
705: Fnd_Preference.Put(Fnd_Global.User_Name, 'FNDSCSGN',
706: 'NEW_WINDOW_FLAG', new_window_flag);

Line 705: Fnd_Preference.Put(Fnd_Global.User_Name, 'FNDSCSGN',

701: fnd_number.number_to_canonical(window_xpos));
702: Fnd_Preference.Put(Fnd_Global.User_Name, 'FNDSCSGN',
703: 'WINDOW_YPOS',
704: fnd_number.number_to_canonical(window_ypos));
705: Fnd_Preference.Put(Fnd_Global.User_Name, 'FNDSCSGN',
706: 'NEW_WINDOW_FLAG', new_window_flag);
707: commit;
708: exception
709: when others then

Line 726: Fnd_Preference.Get(Fnd_Global.User_Name,

722: NEW_WINDOW_FLAG out nocopy varchar2)
723: is
724: begin
725: window_width := fnd_number.canonical_to_number(
726: Fnd_Preference.Get(Fnd_Global.User_Name,
727: 'FNDSCSGN', 'WINDOW_WIDTH'));
728: window_height := fnd_number.canonical_to_number(
729: Fnd_Preference.Get(Fnd_Global.User_Name,
730: 'FNDSCSGN', 'WINDOW_HEIGHT'));

Line 729: Fnd_Preference.Get(Fnd_Global.User_Name,

725: window_width := fnd_number.canonical_to_number(
726: Fnd_Preference.Get(Fnd_Global.User_Name,
727: 'FNDSCSGN', 'WINDOW_WIDTH'));
728: window_height := fnd_number.canonical_to_number(
729: Fnd_Preference.Get(Fnd_Global.User_Name,
730: 'FNDSCSGN', 'WINDOW_HEIGHT'));
731: window_xpos := fnd_number.canonical_to_number(
732: Fnd_Preference.Get(Fnd_Global.User_Name,
733: 'FNDSCSGN', 'WINDOW_XPOS'));

Line 732: Fnd_Preference.Get(Fnd_Global.User_Name,

728: window_height := fnd_number.canonical_to_number(
729: Fnd_Preference.Get(Fnd_Global.User_Name,
730: 'FNDSCSGN', 'WINDOW_HEIGHT'));
731: window_xpos := fnd_number.canonical_to_number(
732: Fnd_Preference.Get(Fnd_Global.User_Name,
733: 'FNDSCSGN', 'WINDOW_XPOS'));
734: window_ypos := fnd_number.canonical_to_number(
735: Fnd_Preference.Get(Fnd_Global.User_Name,
736: 'FNDSCSGN', 'WINDOW_YPOS'));

Line 735: Fnd_Preference.Get(Fnd_Global.User_Name,

731: window_xpos := fnd_number.canonical_to_number(
732: Fnd_Preference.Get(Fnd_Global.User_Name,
733: 'FNDSCSGN', 'WINDOW_XPOS'));
734: window_ypos := fnd_number.canonical_to_number(
735: Fnd_Preference.Get(Fnd_Global.User_Name,
736: 'FNDSCSGN', 'WINDOW_YPOS'));
737: new_window_flag := substrb(Fnd_Preference.Get(
738: Fnd_Global.User_Name,
739: 'FNDSCSGN', 'NEW_WINDOW_FLAG'), 1, 1);

Line 738: Fnd_Global.User_Name,

734: window_ypos := fnd_number.canonical_to_number(
735: Fnd_Preference.Get(Fnd_Global.User_Name,
736: 'FNDSCSGN', 'WINDOW_YPOS'));
737: new_window_flag := substrb(Fnd_Preference.Get(
738: Fnd_Global.User_Name,
739: 'FNDSCSGN', 'NEW_WINDOW_FLAG'), 1, 1);
740: exception
741: when others then
742: generic_error('FND_SIGNON.GET_NAVIGATOR_PREFERENCES', SQLCODE, SQLERRM);

Line 925: -- check if the context is set by an FND_GLOBAL.USER_ID call. If the return value is -1,

921: -- Bug 3238722: The login_id generated by FND_LOGINS_S is not being recorded in
922: -- FND_LOGINS when a user-level value for the profile option 'Sign-On Audit:Level' is set
923: -- but a site-level value is not. This happens when the audit level value returned by
924: -- fnd_profile.value returns the site-level when the context is not set. The code needs to
925: -- check if the context is set by an FND_GLOBAL.USER_ID call. If the return value is -1,
926: -- then the context is not set. If the context is not set, the code should call
927: -- fnd_profile.value_specific and pass in the user_id to return an accurate value for
928: -- the audit level. Once an accurate value for the profile is returned, the login_id will
929: -- be properly recorded in FND_LOGINS.

Line 953: if (FND_GLOBAL.USER_ID = -1) OR (FND_GLOBAL.USER_ID = 6) then

949: -- of SIGNONAUDIT:LEVEL profile option
950: if (l_proxy_user_id is not NULL) then
951: l_audit_level := 'D';
952: else
953: if (FND_GLOBAL.USER_ID = -1) OR (FND_GLOBAL.USER_ID = 6) then
954: l_audit_level:= fnd_profile.value_specific('SIGNONAUDIT:LEVEL', user_id);
955: else
956: l_audit_level:= fnd_profile.value('SIGNONAUDIT:LEVEL');
957: end if;