APPS.JTF_TERR_CHANGES_REPORT_PVT dependencies on FND_PROFILE

Line 93: fnd_client_info.set_org_context(fnd_profile.value('ORG_ID'));

89: WHERE j1.terr_qual_id = p_terr_qual_id
90: ORDER BY j1.value_set;
91:
92: BEGIN
93: fnd_client_info.set_org_context(fnd_profile.value('ORG_ID'));
94: l_response := p_response;
95:
96: select trunc(to_date(p_sd_date||'-'||p_sm_date||'-'||p_sy_date,'DD/MM/YYYY'))
97: into l_from_date

Line 139: fnd_client_info.set_org_context(fnd_profile.value_wnps('ORG_ID'));

135: htp.br;
136:
137:
138: htp.tableOpen (cattributes => 'COLS=4 border="1" width="100%"');
139: fnd_client_info.set_org_context(fnd_profile.value_wnps('ORG_ID'));
140: -- display territories
141: l_rec_count := 0;
142: FOR rec_terr in cur_territory(l_from_date, l_to_date) loop
143: htp.tableRowOpen;

Line 391: fnd_client_info.set_org_context(fnd_profile.value('ORG_ID'));

387: ORDER BY j1.value_set;
388:
389: BEGIN
390: owa_util.mime_header('application/excel');
391: fnd_client_info.set_org_context(fnd_profile.value('ORG_ID'));
392:
393: -- fnd_client_info.set_org_context(fnd_profile.value_wnps('ORG_ID'));
394: SELECT FND_GLOBAL.TAB
395: INTO v_tab

Line 393: -- fnd_client_info.set_org_context(fnd_profile.value_wnps('ORG_ID'));

389: BEGIN
390: owa_util.mime_header('application/excel');
391: fnd_client_info.set_org_context(fnd_profile.value('ORG_ID'));
392:
393: -- fnd_client_info.set_org_context(fnd_profile.value_wnps('ORG_ID'));
394: SELECT FND_GLOBAL.TAB
395: INTO v_tab
396: from dual;
397: