[Home] [Help]
760: end loop;
761: end if;*/
762:
763: dbms_lob.trim(l_resp_clob,length(l_resp_clob)-5);
764: l_postjoin_sql := ' )A ,fnd_responsibility_vl resp,FND_SECURITY_GROUPS_VL secgrp ,fnd_application_vl app '
765: ||' where '
766: ||' A.app_short_name = app.application_short_name '
767: ||' order by ResponsibilityName ,ApplicationName , SecurityGroupName ';
768:
802: ' decode(A.profile_option_value, ''Y'',''Yes'',''N'',''No'',A.profile_option_value) ProfileValue, '||
803: ' fapp.Application_Name, A.level_value from (';
804:
805: l_postjoin_sql :=' )A, FND_PROFILE_OPTIONS_VL fprf '||
806: ' ,fnd_application_vl fapp '||
807: ' where fprf.profile_option_name = A.profile_name '||
808: ' and fapp.APPLICATION_SHORT_NAME = A.level_value_app '||
809: ' and level_x = ''1001'' '|| --only for Site level profiles
810: ' order by UserProfileName desc';
899: ' decode(A.profile_option_value, ''Y'',''Yes'',''N'',''No'',A.profile_option_value) ProfileValue, '||
900: ' fapp.Application_Name, A.level_value from (';
901:
902: l_postjoin_sql :=' )A, FND_PROFILE_OPTIONS_VL fprf '||
903: ' ,fnd_application_vl fapp '||
904: ' where fprf.profile_option_name = A.profile_name '||
905: ' and fapp.APPLICATION_SHORT_NAME = A.level_value_app ';
906:
907: dbms_lob.writeappend(l_profile_apps_clob,length(l_prejoin_sql),l_prejoin_sql);
955: ' decode(A.profile_option_value, ''Y'',''Yes'',''N'',''No'',A.profile_option_value) ProfileValue, '||
956: ' fapp.Application_Name, A.level_value from (';
957:
958: l_postjoin_sql :=' )A, FND_PROFILE_OPTIONS_VL fprf '||
959: ' ,fnd_application_vl fapp '||
960: ' where fprf.profile_option_name = A.profile_name '||
961: ' and fapp.APPLICATION_SHORT_NAME = A.level_value_app ';
962:
963: dbms_lob.writeappend(l_profile_resp_clob,length(l_prejoin_sql),l_prejoin_sql);
1046:
1047: l_prejoin_sql := ' select A.appl_short_name , A.flex_code ,A.structure_code,A.structure_title,A.description, A.allow_dynamic_inserts,A.segment_separator,A.enabled,A.freeze_flex_def,'||
1048: ' fapp.Application_Name from( ';
1049:
1050: l_postjoin_sql := ' )A, fnd_application_vl fapp '||
1051: ' where fapp.APPLICATION_SHORT_NAME = A.appl_short_name '||
1052: ' order by Application_Name desc,structure_title desc';
1053:
1054: dbms_lob.writeappend(l_kf_str_clob,length(l_prejoin_sql),l_prejoin_sql);
2782: l_vs_security_available varchar2(80);
2783: l_vs_enable_longlist varchar2(80);
2784:
2785: l_vs_format_type varchar2(80);
2786: l_appl_name fnd_application_vl.application_name%type;
2787:
2788: BEGIN
2789: hr_utility.set_location('Entering ' ||l_proc,10);
2790:
2794: l_required := l_allow_dynamic;
2795: l_display := l_allow_dynamic;
2796: l_freeze_flex_def := l_allow_dynamic;
2797:
2798: select application_name into l_appl_name from fnd_application_vl where application_short_name = p_kf_structure_tab(j).appl_short_name;
2799:
2800: --For every cost Structure find all Segments
2801: IF p_kf_structure_tab.count > 0 THEN
2802: for j in p_kf_structure_tab.first ..
3382: l_prejoin_sql := ' select decode(A.legislation_code,''BF'',''International'',terr.TERRITORY_SHORT_NAME) Legislation , '
3383: ||' fapp.application_name '
3384: ||' from ( ';
3385:
3386: l_postjoin_sql := ' )A , FND_TERRITORIES_VL terr ,fnd_application_vl fapp '
3387: ||' where terr.TERRITORY_CODE = A.legislation_code '
3388: ||' and fapp.application_short_name = A.application_short_name '
3389: ||' order by Legislation desc , fapp.application_name desc';
3390: