APPS.IRC_APL_PROFILE_ACCESS_API SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 21

  	select 1 from per_all_assignments_f asg, per_all_people_f allper, per_all_people_f per
  	where asg.person_id = allper.person_id
  	and allper.party_id = per.party_id
  	and trunc(sysdate) between asg.effective_start_date and asg.effective_end_date
  	and trunc(sysdate) between per.effective_start_date and per.effective_end_date
  	and trunc(sysdate) between allper.effective_start_date and allper.effective_end_date
  	and asg.business_group_id in
  	   (select bginfo.organization_id from hr_organization_information bginfo
  	   where bginfo.ORG_INFORMATION_CONTEXT = 'BG Recruitment'
  	   and bginfo.org_information11 = 'Y')
	and per.person_id = irc_utilities_pkg.get_recruitment_person_id(p_person_id);

Line: 136

procedure update_apl_profile_access
  (p_validate                      in     boolean  default false
  ,p_person_id                     in     number
  ,p_apl_profile_access_id           in out nocopy   number
  ,p_object_version_number         in out nocopy   number
  ) is
  --
  -- Declare cursors and local variables
  --
  -- out variables
  l_apl_profile_access_id		irc_apl_profile_access.apl_profile_access_id%TYPE;

Line: 148

  l_proc				varchar2(72) := g_package||'update_apl_profile_access';

Line: 155

  savepoint update_apl_profile_access;

Line: 171

    irc_apl_profile_access_bk2.update_apl_profile_access_b
      (p_person_id              => p_person_id
      ,p_apl_profile_access_id    => l_apl_profile_access_id
      ,p_object_version_number  => l_object_version_number
      );

Line: 179

        (p_module_name => 'update_apl_profile_access'
        ,p_hook_type   => 'BP'
        );

Line: 201

    irc_apl_profile_access_bk2.update_apl_profile_access_a
      (p_person_id              => p_person_id
      ,p_apl_profile_access_id	=> l_apl_profile_access_id
      ,p_object_version_number	=> l_object_version_number
      );

Line: 209

        (p_module_name => 'update_apl_profile_access'
        ,p_hook_type   => 'AP'
        );

Line: 232

    rollback to update_apl_profile_access;

Line: 246

    rollback to update_apl_profile_access;

Line: 256

end update_apl_profile_access;

Line: 263

procedure delete_apl_profile_access
  (p_validate				in     boolean  default false
   ,p_person_id			in     number
   ,p_apl_profile_access_id          in number
   ,p_object_version_number		in number
    ) is
  --
  -- Declare cursors and local variables
  --
  l_proc                varchar2(72) := g_package||'delete_apl_profile_access';

Line: 278

  savepoint delete_apl_profile_access;

Line: 285

    irc_apl_profile_access_bk3.delete_apl_profile_access_b
      (p_person_id		       => p_person_id
      ,p_apl_profile_access_id      => p_apl_profile_access_id
      ,p_object_version_number         => p_object_version_number
      );

Line: 293

        (p_module_name => 'delete_apl_profile_access'
        ,p_hook_type   => 'BP'
        );

Line: 308

    irc_apl_profile_access_bk3.delete_apl_profile_access_a
      (p_person_id		       => p_person_id
      ,p_apl_profile_access_id      => p_apl_profile_access_id
      ,p_object_version_number         => p_object_version_number
      );

Line: 316

        (p_module_name => 'delete_apl_profile_access'
        ,p_hook_type   => 'AP'
        );

Line: 334

    rollback to delete_apl_profile_access;

Line: 341

    rollback to delete_apl_profile_access;

Line: 345

end delete_apl_profile_access;