APPS.JTF_RS_RESOURCE_UTL_PUB dependencies on FND_PROFILE

Line 529: l_profile_value := nvl(FND_PROFILE.VALUE('JTF_RS_EMP_RES_UPD_ACCESS'),'SELF');

525: l_resource_user_id number;
526:
527: BEGIN
528:
529: l_profile_value := nvl(FND_PROFILE.VALUE('JTF_RS_EMP_RES_UPD_ACCESS'),'SELF');
530: l_user_id := nvl(FND_PROFILE.VALUE('USER_ID'),-1);
531:
532: IF (l_profile_value = 'SELF') THEN
533: IF (p_resource_user_id IS NULL) THEN

Line 530: l_user_id := nvl(FND_PROFILE.VALUE('USER_ID'),-1);

526:
527: BEGIN
528:
529: l_profile_value := nvl(FND_PROFILE.VALUE('JTF_RS_EMP_RES_UPD_ACCESS'),'SELF');
530: l_user_id := nvl(FND_PROFILE.VALUE('USER_ID'),-1);
531:
532: IF (l_profile_value = 'SELF') THEN
533: IF (p_resource_user_id IS NULL) THEN
534: BEGIN

Line 581: l_profile_value := nvl(FND_PROFILE.VALUE('JTF_RS_GROUP_UPD_ACCESS'),'NONE');

577: AND trunc(sysdate) between start_date_active and nvl(end_date_active, trunc(sysdate));
578:
579: BEGIN
580:
581: l_profile_value := nvl(FND_PROFILE.VALUE('JTF_RS_GROUP_UPD_ACCESS'),'NONE');
582: l_user_id := nvl(FND_PROFILE.VALUE('USER_ID'),-1);
583: -- l_profile_value := 'NONE';
584: -- l_user_id := 1351;
585:

Line 582: l_user_id := nvl(FND_PROFILE.VALUE('USER_ID'),-1);

578:
579: BEGIN
580:
581: l_profile_value := nvl(FND_PROFILE.VALUE('JTF_RS_GROUP_UPD_ACCESS'),'NONE');
582: l_user_id := nvl(FND_PROFILE.VALUE('USER_ID'),-1);
583: -- l_profile_value := 'NONE';
584: -- l_user_id := 1351;
585:
586: IF (l_profile_value = 'ALL') THEN

Line 689: l_profile_value := nvl(FND_PROFILE.VALUE('JTF_RS_ROLE_UPD_ACCESS'),'NONE');

685: l_profile_value VARCHAR2(10);
686:
687: BEGIN
688:
689: l_profile_value := nvl(FND_PROFILE.VALUE('JTF_RS_ROLE_UPD_ACCESS'),'NONE');
690: if l_profile_value = 'ALL' then
691: return 'FA';
692: else
693: return 'RO';

Line 715: l_user_id := nvl(FND_PROFILE.VALUE('USER_ID'),-1);

711: start with resource_id = p_res_id;
712:
713: BEGIN
714:
715: l_user_id := nvl(FND_PROFILE.VALUE('USER_ID'),-1);
716:
717: for mgr_usr_id_rec in mgr_usr_ids(p_resource_id) loop
718: if (l_user_id = mgr_usr_id_rec.user_id) then
719: return 'Y';