APPS.JTF_RS_RESOURCE_UTL_PUB dependencies on FND_PROFILE

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

537: l_resource_user_id number;
538:
539: BEGIN
540:
541: l_profile_value := nvl(FND_PROFILE.VALUE('JTF_RS_EMP_RES_UPD_ACCESS'),'SELF');
542: l_user_id := nvl(FND_PROFILE.VALUE('USER_ID'),-1);
543:
544: IF (l_profile_value = 'SELF') THEN
545: IF (p_resource_user_id IS NULL) THEN

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

538:
539: BEGIN
540:
541: l_profile_value := nvl(FND_PROFILE.VALUE('JTF_RS_EMP_RES_UPD_ACCESS'),'SELF');
542: l_user_id := nvl(FND_PROFILE.VALUE('USER_ID'),-1);
543:
544: IF (l_profile_value = 'SELF') THEN
545: IF (p_resource_user_id IS NULL) THEN
546: BEGIN

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

589: AND trunc(sysdate) between start_date_active and nvl(end_date_active, trunc(sysdate));
590:
591: BEGIN
592:
593: l_profile_value := nvl(FND_PROFILE.VALUE('JTF_RS_GROUP_UPD_ACCESS'),'NONE');
594: l_user_id := nvl(FND_PROFILE.VALUE('USER_ID'),-1);
595: -- l_profile_value := 'NONE';
596: -- l_user_id := 1351;
597:

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

590:
591: BEGIN
592:
593: l_profile_value := nvl(FND_PROFILE.VALUE('JTF_RS_GROUP_UPD_ACCESS'),'NONE');
594: l_user_id := nvl(FND_PROFILE.VALUE('USER_ID'),-1);
595: -- l_profile_value := 'NONE';
596: -- l_user_id := 1351;
597:
598: IF (l_profile_value = 'ALL') THEN

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

697: l_profile_value VARCHAR2(10);
698:
699: BEGIN
700:
701: l_profile_value := nvl(FND_PROFILE.VALUE('JTF_RS_ROLE_UPD_ACCESS'),'NONE');
702: if l_profile_value = 'ALL' then
703: return 'FA';
704: else
705: return 'RO';

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

723: start with resource_id = p_res_id;
724:
725: BEGIN
726:
727: l_user_id := nvl(FND_PROFILE.VALUE('USER_ID'),-1);
728:
729: for mgr_usr_id_rec in mgr_usr_ids(p_resource_id) loop
730: if (l_user_id = mgr_usr_id_rec.user_id) then
731: return 'Y';