DBA Data[Home] [Help]

APPS.FND_SIGNON dependencies on FND_GLOBAL

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

513: if ((l_proxy_user_id is not NULL) AND
514: (l_proxy_user_id <> -1)) then
515: l_audit_level := 'D';
516: else
517: if (FND_GLOBAL.USER_ID = -1) or (FND_GLOBAL.USER_ID = 6) then
518: l_audit_level:=
519: fnd_profile.value_specific('SIGNONAUDIT:LEVEL', UID);
520: else
521: l_audit_level:= fnd_profile.value('SIGNONAUDIT:LEVEL');

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

665: Fnd_Signon.Update_Desktop_Object(function10, 10,
666: user_id, resp_id, appl_id, login_id);
667:
668: -- Save window position to preferences
669: Fnd_Preference.Put(Fnd_Global.User_Name, 'FNDSCSGN',
670: 'WINDOW_WIDTH',
671: fnd_number.number_to_canonical(window_width));
672: Fnd_Preference.Put(Fnd_Global.User_Name, 'FNDSCSGN',
673: 'WINDOW_HEIGHT',

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

668: -- Save window position to preferences
669: Fnd_Preference.Put(Fnd_Global.User_Name, 'FNDSCSGN',
670: 'WINDOW_WIDTH',
671: fnd_number.number_to_canonical(window_width));
672: Fnd_Preference.Put(Fnd_Global.User_Name, 'FNDSCSGN',
673: 'WINDOW_HEIGHT',
674: fnd_number.number_to_canonical(window_height));
675: Fnd_Preference.Put(Fnd_Global.User_Name, 'FNDSCSGN',
676: 'WINDOW_XPOS',

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

671: fnd_number.number_to_canonical(window_width));
672: Fnd_Preference.Put(Fnd_Global.User_Name, 'FNDSCSGN',
673: 'WINDOW_HEIGHT',
674: fnd_number.number_to_canonical(window_height));
675: Fnd_Preference.Put(Fnd_Global.User_Name, 'FNDSCSGN',
676: 'WINDOW_XPOS',
677: fnd_number.number_to_canonical(window_xpos));
678: Fnd_Preference.Put(Fnd_Global.User_Name, 'FNDSCSGN',
679: 'WINDOW_YPOS',

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

674: fnd_number.number_to_canonical(window_height));
675: Fnd_Preference.Put(Fnd_Global.User_Name, 'FNDSCSGN',
676: 'WINDOW_XPOS',
677: fnd_number.number_to_canonical(window_xpos));
678: Fnd_Preference.Put(Fnd_Global.User_Name, 'FNDSCSGN',
679: 'WINDOW_YPOS',
680: fnd_number.number_to_canonical(window_ypos));
681: Fnd_Preference.Put(Fnd_Global.User_Name, 'FNDSCSGN',
682: 'NEW_WINDOW_FLAG', new_window_flag);

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

677: fnd_number.number_to_canonical(window_xpos));
678: Fnd_Preference.Put(Fnd_Global.User_Name, 'FNDSCSGN',
679: 'WINDOW_YPOS',
680: fnd_number.number_to_canonical(window_ypos));
681: Fnd_Preference.Put(Fnd_Global.User_Name, 'FNDSCSGN',
682: 'NEW_WINDOW_FLAG', new_window_flag);
683: commit;
684: exception
685: when others then

Line 702: Fnd_Preference.Get(Fnd_Global.User_Name,

698: NEW_WINDOW_FLAG out nocopy varchar2)
699: is
700: begin
701: window_width := fnd_number.canonical_to_number(
702: Fnd_Preference.Get(Fnd_Global.User_Name,
703: 'FNDSCSGN', 'WINDOW_WIDTH'));
704: window_height := fnd_number.canonical_to_number(
705: Fnd_Preference.Get(Fnd_Global.User_Name,
706: 'FNDSCSGN', 'WINDOW_HEIGHT'));

Line 705: Fnd_Preference.Get(Fnd_Global.User_Name,

701: window_width := fnd_number.canonical_to_number(
702: Fnd_Preference.Get(Fnd_Global.User_Name,
703: 'FNDSCSGN', 'WINDOW_WIDTH'));
704: window_height := fnd_number.canonical_to_number(
705: Fnd_Preference.Get(Fnd_Global.User_Name,
706: 'FNDSCSGN', 'WINDOW_HEIGHT'));
707: window_xpos := fnd_number.canonical_to_number(
708: Fnd_Preference.Get(Fnd_Global.User_Name,
709: 'FNDSCSGN', 'WINDOW_XPOS'));

Line 708: Fnd_Preference.Get(Fnd_Global.User_Name,

704: window_height := fnd_number.canonical_to_number(
705: Fnd_Preference.Get(Fnd_Global.User_Name,
706: 'FNDSCSGN', 'WINDOW_HEIGHT'));
707: window_xpos := fnd_number.canonical_to_number(
708: Fnd_Preference.Get(Fnd_Global.User_Name,
709: 'FNDSCSGN', 'WINDOW_XPOS'));
710: window_ypos := fnd_number.canonical_to_number(
711: Fnd_Preference.Get(Fnd_Global.User_Name,
712: 'FNDSCSGN', 'WINDOW_YPOS'));

Line 711: Fnd_Preference.Get(Fnd_Global.User_Name,

707: window_xpos := fnd_number.canonical_to_number(
708: Fnd_Preference.Get(Fnd_Global.User_Name,
709: 'FNDSCSGN', 'WINDOW_XPOS'));
710: window_ypos := fnd_number.canonical_to_number(
711: Fnd_Preference.Get(Fnd_Global.User_Name,
712: 'FNDSCSGN', 'WINDOW_YPOS'));
713: new_window_flag := substrb(Fnd_Preference.Get(
714: Fnd_Global.User_Name,
715: 'FNDSCSGN', 'NEW_WINDOW_FLAG'), 1, 1);

Line 714: Fnd_Global.User_Name,

710: window_ypos := fnd_number.canonical_to_number(
711: Fnd_Preference.Get(Fnd_Global.User_Name,
712: 'FNDSCSGN', 'WINDOW_YPOS'));
713: new_window_flag := substrb(Fnd_Preference.Get(
714: Fnd_Global.User_Name,
715: 'FNDSCSGN', 'NEW_WINDOW_FLAG'), 1, 1);
716: exception
717: when others then
718: generic_error('FND_SIGNON.GET_NAVIGATOR_PREFERENCES', SQLCODE, SQLERRM);

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

897: -- Bug 3238722: The login_id generated by FND_LOGINS_S is not being recorded in
898: -- FND_LOGINS when a user-level value for the profile option 'Sign-On Audit:Level' is set
899: -- but a site-level value is not. This happens when the audit level value returned by
900: -- fnd_profile.value returns the site-level when the context is not set. The code needs to
901: -- check if the context is set by an FND_GLOBAL.USER_ID call. If the return value is -1,
902: -- then the context is not set. If the context is not set, the code should call
903: -- fnd_profile.value_specific and pass in the user_id to return an accurate value for
904: -- the audit level. Once an accurate value for the profile is returned, the login_id will
905: -- be properly recorded in FND_LOGINS.

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

925: -- of SIGNONAUDIT:LEVEL profile option
926: if (l_proxy_user_id is not NULL) then
927: l_audit_level := 'D';
928: else
929: if (FND_GLOBAL.USER_ID = -1) OR (FND_GLOBAL.USER_ID = 6) then
930: l_audit_level:= fnd_profile.value_specific('SIGNONAUDIT:LEVEL', user_id);
931: else
932: l_audit_level:= fnd_profile.value('SIGNONAUDIT:LEVEL');
933: end if;