DBA Data[Home] [Help]

APPS.IBU_HOME_PAGE_PVT dependencies on FND_GLOBAL

Line 32: l_user_id := FND_GLOBAL.USER_ID;

28: l_app_id NUMBER;
29: l_return_value VARCHAR(10);
30: x_return_status VARCHAR2(1);
31: begin
32: l_user_id := FND_GLOBAL.USER_ID;
33: l_resp_id := FND_GLOBAL.RESP_ID;
34: l_app_id := FND_GLOBAL.RESP_APPL_ID;
35: l_return_value := FND_PROFILE.VALUE_SPECIFIC ('IBU_INTERNAL_ROLLOUT', l_user_id, l_resp_id, l_app_id);
36: if l_return_value = 'Y' then

Line 33: l_resp_id := FND_GLOBAL.RESP_ID;

29: l_return_value VARCHAR(10);
30: x_return_status VARCHAR2(1);
31: begin
32: l_user_id := FND_GLOBAL.USER_ID;
33: l_resp_id := FND_GLOBAL.RESP_ID;
34: l_app_id := FND_GLOBAL.RESP_APPL_ID;
35: l_return_value := FND_PROFILE.VALUE_SPECIFIC ('IBU_INTERNAL_ROLLOUT', l_user_id, l_resp_id, l_app_id);
36: if l_return_value = 'Y' then
37: x_return_status := FND_API.G_TRUE;

Line 34: l_app_id := FND_GLOBAL.RESP_APPL_ID;

30: x_return_status VARCHAR2(1);
31: begin
32: l_user_id := FND_GLOBAL.USER_ID;
33: l_resp_id := FND_GLOBAL.RESP_ID;
34: l_app_id := FND_GLOBAL.RESP_APPL_ID;
35: l_return_value := FND_PROFILE.VALUE_SPECIFIC ('IBU_INTERNAL_ROLLOUT', l_user_id, l_resp_id, l_app_id);
36: if l_return_value = 'Y' then
37: x_return_status := FND_API.G_TRUE;
38: else

Line 79: return FND_GLOBAL.USER_ID;

75: -- common context info
76: function get_user_id return NUMBER
77: as
78: begin
79: return FND_GLOBAL.USER_ID;
80: end get_user_id;
81:
82: function get_user_name return VARCHAR2
83: as

Line 85: return FND_GLOBAL.USER_NAME;

81:
82: function get_user_name return VARCHAR2
83: as
84: begin
85: return FND_GLOBAL.USER_NAME;
86: end get_user_name;
87:
88: function get_app_id return NUMBER
89: as

Line 98: -- seems fnd_global may not return the right responsibility

94: function get_resp_id return NUMBER
95: as
96: begin
97: -- get the default resp id for this user
98: -- seems fnd_global may not return the right responsibility
99: return get_resp_id_from_user(get_user_id);
100: end get_resp_id;
101:
102: function get_customer_id return NUMBER

Line 148: -- seems fnd_global may not return the right responsibility

144: function get_resp_id_from_user(p_user_id IN NUMBER) return NUMBER
145: as
146: begin
147: -- get the default resp id for this user
148: -- seems fnd_global may not return the right responsibility
149: return FND_PROFILE.VALUE_SPECIFIC(
150: 'JTF_PROFILE_DEFAULT_RESPONSIBILITY',
151: p_user_id,
152: null,

Line 424: l_close_url := 'ibuhpage.jsp?action=close' || fnd_global.local_chr(38)

420: return VARCHAR2
421: as
422: l_close_url VARCHAR2(5000);
423: begin
424: l_close_url := 'ibuhpage.jsp?action=close' || fnd_global.local_chr(38)
425: || 'binId=' || to_char(p_bin_id);
426: if p_cookie_url is not null then
427: l_close_url := l_close_url || fnd_global.local_chr(38) || p_cookie_url;
428: end if;

Line 427: l_close_url := l_close_url || fnd_global.local_chr(38) || p_cookie_url;

423: begin
424: l_close_url := 'ibuhpage.jsp?action=close' || fnd_global.local_chr(38)
425: || 'binId=' || to_char(p_bin_id);
426: if p_cookie_url is not null then
427: l_close_url := l_close_url || fnd_global.local_chr(38) || p_cookie_url;
428: end if;
429: return l_close_url;
430: end get_close_bin_url;
431:

Line 441: || fnd_global.local_chr(38) || 'filterFile=' || p_jsp_file_name;

437: as
438: l_edit_url VARCHAR2(5000);
439: begin
440: l_edit_url := 'ibuhedtf.jsp?binId=' || to_char(p_bin_id)
441: || fnd_global.local_chr(38) || 'filterFile=' || p_jsp_file_name;
442:
443: if p_filter_string is not null then
444: l_edit_url := l_edit_url || fnd_global.local_chr(38) || p_filter_string;
445: end if;

Line 444: l_edit_url := l_edit_url || fnd_global.local_chr(38) || p_filter_string;

440: l_edit_url := 'ibuhedtf.jsp?binId=' || to_char(p_bin_id)
441: || fnd_global.local_chr(38) || 'filterFile=' || p_jsp_file_name;
442:
443: if p_filter_string is not null then
444: l_edit_url := l_edit_url || fnd_global.local_chr(38) || p_filter_string;
445: end if;
446:
447: if p_cookie_url is not null then
448: l_edit_url := l_edit_url || fnd_global.local_chr(38) || p_cookie_url;

Line 448: l_edit_url := l_edit_url || fnd_global.local_chr(38) || p_cookie_url;

444: l_edit_url := l_edit_url || fnd_global.local_chr(38) || p_filter_string;
445: end if;
446:
447: if p_cookie_url is not null then
448: l_edit_url := l_edit_url || fnd_global.local_chr(38) || p_cookie_url;
449: end if;
450: return l_edit_url;
451: end get_edit_bin_url;
452:

Line 461: newln VARCHAR2(2) := fnd_global.newline ();

457: return VARCHAR2
458: as
459: l_html VARCHAR2(18000);
460: l_tmp_str VARCHAR2(10000);
461: newln VARCHAR2(2) := fnd_global.newline ();
462: l_prompts IBU_Home_Page_PVT.IBU_STR_ARR;
463: l_edit_name VARCHAR2(80);
464: l_close_name VARCHAR2(80);
465: begin

Line 501: || '' || fnd_global.local_chr(38) || 'nbsp;' || newln;

497:
498: if p_edit_url is not null then
499: l_tmp_str := ' ' || l_edit_name
501: || '
' || fnd_global.local_chr(38) || 'nbsp;' || newln;
502: end if;
503:
504: if p_close_url is not null then
505: l_tmp_str := l_tmp_str

Line 764: x_filter_string := x_filter_string || fnd_global.local_chr(38)

760: if f_curr_row = 1 then
761: x_filter_string := l_pd_attrib_tbl (f_curr_row).ATTRIBUTE_NAME
762: || '=' || l_pd_attrib_tbl (f_curr_row).ATTRIBUTE_VALUE;
763: else
764: x_filter_string := x_filter_string || fnd_global.local_chr(38)
765: || l_pd_attrib_tbl (f_curr_row).ATTRIBUTE_NAME
766: || '=' || l_pd_attrib_tbl (f_curr_row).ATTRIBUTE_VALUE;
767: end if;
768: end if;