[Home] [Help]
1288: END;
1289: -- For debugging .. remove the code
1290: Begin
1291: /*
1292: select fnd_profile_server.value('PER_SECURITY_PROFILE_ID')
1293: into l_profile_per_sec_id
1294: from dual;
1295: */
1296: select to_number(fnd_profile_server.value('PER_SECURITY_PROFILE_ID'))
1292: select fnd_profile_server.value('PER_SECURITY_PROFILE_ID')
1293: into l_profile_per_sec_id
1294: from dual;
1295: */
1296: select to_number(fnd_profile_server.value('PER_SECURITY_PROFILE_ID'))
1297: into l_profile_per_sec_id
1298: from dual;
1299: select fnd_profile_server.value('PER_BUSINESS_GROUP_ID')
1300: into l_profile_per_bg
1295: */
1296: select to_number(fnd_profile_server.value('PER_SECURITY_PROFILE_ID'))
1297: into l_profile_per_sec_id
1298: from dual;
1299: select fnd_profile_server.value('PER_BUSINESS_GROUP_ID')
1300: into l_profile_per_bg
1301: from dual;
1302: /*
1303: select fnd_profile_server.value('SECURITY_GROUP_ID')
1299: select fnd_profile_server.value('PER_BUSINESS_GROUP_ID')
1300: into l_profile_per_bg
1301: from dual;
1302: /*
1303: select fnd_profile_server.value('SECURITY_GROUP_ID')
1304: into l_profile_sec_grp_id
1305: from dual;
1306: */
1307:
1305: from dual;
1306: */
1307:
1308: /* Bug 9211154 - There is no profile 'SECURITY_GROUP_ID' and hence below query will always return NULL'
1309: select to_number(fnd_profile_server.value('SECURITY_GROUP_ID'))
1310: into l_profile_sec_grp_id
1311: from dual;
1312: */
1313: --Bug 9211154 Setting the value as fnd security group id
1312: */
1313: --Bug 9211154 Setting the value as fnd security group id
1314: l_profile_sec_grp_id := l_sec_grp_id;
1315:
1316: select fnd_profile_server.value('USERNAME')
1317: into l_profile_user_name
1318: from dual;
1319:
1320: hr_utility.trace('jj payuswfpkg l_profile_per_sec_id = '||l_profile_per_sec_id);
3018: END;
3019: -- For debugging .. remove the code
3020: Begin
3021: /*
3022: select fnd_profile_server.value('PER_SECURITY_PROFILE_ID')
3023: into l_profile_per_sec_id
3024: from dual;
3025: */
3026: select to_number(fnd_profile_server.value('PER_SECURITY_PROFILE_ID'))
3022: select fnd_profile_server.value('PER_SECURITY_PROFILE_ID')
3023: into l_profile_per_sec_id
3024: from dual;
3025: */
3026: select to_number(fnd_profile_server.value('PER_SECURITY_PROFILE_ID'))
3027: into l_profile_per_sec_id
3028: from dual;
3029: select fnd_profile_server.value('PER_BUSINESS_GROUP_ID')
3030: into l_profile_per_bg
3025: */
3026: select to_number(fnd_profile_server.value('PER_SECURITY_PROFILE_ID'))
3027: into l_profile_per_sec_id
3028: from dual;
3029: select fnd_profile_server.value('PER_BUSINESS_GROUP_ID')
3030: into l_profile_per_bg
3031: from dual;
3032: /*
3033: select fnd_profile_server.value('SECURITY_GROUP_ID')
3029: select fnd_profile_server.value('PER_BUSINESS_GROUP_ID')
3030: into l_profile_per_bg
3031: from dual;
3032: /*
3033: select fnd_profile_server.value('SECURITY_GROUP_ID')
3034: into l_profile_sec_grp_id
3035: from dual;
3036: */
3037:
3035: from dual;
3036: */
3037:
3038: /* Bug 9211154 - There is no profile 'SECURITY_GROUP_ID' and hence below query will always return NULL'
3039: select to_number(fnd_profile_server.value('SECURITY_GROUP_ID'))
3040: into l_profile_sec_grp_id
3041: from dual;
3042: */
3043: --Bug 9211154 Setting the value as fnd security group id
3042: */
3043: --Bug 9211154 Setting the value as fnd security group id
3044: l_profile_sec_grp_id := l_sec_grp_id;
3045:
3046: select fnd_profile_server.value('USERNAME')
3047: into l_profile_user_name
3048: from dual;
3049:
3050: hr_utility.trace('jj payuswfpkg l_profile_per_sec_id = '||l_profile_per_sec_id);