APPS.HXC_TIMEKEEPER_GROUP_API SQL Statements

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

Line: 253

procedure update_timekeeper_group
  (p_validate                       in  boolean   default false
  ,p_tk_group_id                    in  number
  ,p_object_version_number          in  out nocopy number
  ,p_tk_group_name                  in     varchar2
  ,p_tk_resource_id                    in number
  ,p_business_group_id              in  number)
IS
  --
  -- Declare cursors and local variables
  --
	l_proc varchar2(72);

Line: 271

  	l_proc := g_package||' update_timekeeper_group';

Line: 277

  savepoint update_timekeeper_group;

Line: 295

    hxc_timekeeper_group_BK_2.update_timekeeper_group_b
	  (p_tk_group_id            => p_tk_group_id
	  ,p_object_version_number  => p_object_version_number
	  ,p_tk_group_name          => p_tk_group_name
          ,p_tk_resource_id            => p_tk_resource_id
          ,p_business_group_id     => p_business_group_id
  );

Line: 305

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

Line: 334

    hxc_timekeeper_group_BK_2.update_timekeeper_group_a
	  (p_tk_group_id            => p_tk_group_id
	  ,p_object_version_number  => l_object_version_number
	  ,p_tk_group_name          => p_tk_group_name
          ,p_tk_resource_id            => p_tk_resource_id
          ,p_business_group_id      => p_business_group_id
  );

Line: 344

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

Line: 374

    ROLLBACK TO update_timekeeper_group;

Line: 393

    ROLLBACK TO update_timekeeper_group;

Line: 396

end update_timekeeper_group;

Line: 434

procedure delete_timekeeper_group
  (p_validate                       in  boolean  default false
  ,p_tk_group_id                    in  number
  ,p_object_version_number          in  number
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc varchar2(72);

Line: 449

  	l_proc := g_package||'delete_timekeeper_group';

Line: 455

  savepoint delete_timekeeper_group;

Line: 457

	hxc_timekeeper_group_api.chk_delete (
				 p_tk_group_id => p_tk_group_id );

Line: 468

    hxc_timekeeper_group_BK_3.delete_timekeeper_group_b
	  (p_tk_group_id           => p_tk_group_id
	  ,p_object_version_number => p_object_version_number
	  );

Line: 475

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

Line: 500

  hxc_timekeeper_group_BK_3.delete_timekeeper_group_a
	  (p_tk_group_id           => p_tk_group_id
	  ,p_object_version_number => p_object_version_number
	  );

Line: 507

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

Line: 529

    ROLLBACK TO delete_timekeeper_group;

Line: 535

    ROLLBACK TO delete_timekeeper_group;

Line: 538

end delete_timekeeper_group;

Line: 565

SELECT 'error'
FROM	sys.dual
WHERE EXISTS (
	SELECT	'x'
	FROM	hxc_tk_groups teg
	WHERE	teg.tk_group_name	= p_tk_group_name
        AND     teg.tk_resource_id         = p_tk_resource_id
        AND
	( teg.tk_group_id <> p_tk_group_id OR
	  p_tk_group_id IS NULL )
	AND teg.business_group_id = p_business_group_id
	  );

Line: 638

SELECT 'x'
FROM   dual
WHERE EXISTS ( select 'x'
               FROM   per_people_f p
               WHERE  p.person_id = p_tk_resource_id );

Line: 674

Procedure chk_delete
  (
   p_tk_group_id in number
  ) IS
BEGIN
null;

Line: 680

END chk_delete;

Line: 703

SELECT p.full_name
,      nvl(p.employee_number, p.npw_number) employee_number
FROM   per_people p
WHERE  p.person_id = p_person_id;

Line: 762

SELECT DISTINCT
       p.person_id
,      p.full_name
,      nvl(p.employee_number, p.npw_number) employee_number
,      SUBSTR(hxc_tk_grp_query_criteria_api.get_tc_period ( p.person_id ),1,80) tc_period_name
,      hr_person_type_usage_info.get_user_person_type(p.effective_start_date, p.person_id)  person_type
FROM
       per_people p
,      per_assignments asg
,      hr_assignment_set_amendments asa
,      hr_assignment_sets ass
,      per_person_types ppt				--added 2943706
,      per_person_type_usages pptu

WHERE ass.assignment_set_id  = p_populate_id
AND   asa.assignment_set_id = ass.assignment_set_id
AND   asa.include_or_exclude = 'I'
AND   asg.assignment_id = asa.assignment_id
AND   p.person_id = asg.person_id
AND   pptu.person_id = p.person_id
AND   ppt.person_type_id = pptu.person_type_id
AND   ppt.system_person_type in ('EMP','EMP_APL','CWK')
AND   ( p_person_type IS NULL OR  (p_person_type IS NOT NULL AND decode(ppt.SYSTEM_PERSON_TYPE,'EMP_APL','EMP',ppt.SYSTEM_PERSON_TYPE)=p_person_type));

Line: 787

SELECT DISTINCT
       p.person_id
,      p.full_name
,      nvl(p.employee_number, p.npw_number) employee_number
,      SUBSTR(hxc_tk_grp_query_criteria_api.get_tc_period ( p.person_id ),1,80) tc_period_name
,      hr_person_type_usage_info.get_user_person_type(p.effective_start_date, p.person_id) person_type
FROM
       per_people p
,      per_assignments asg
,      per_person_types ppt				--added 2943706
,      per_person_type_usages pptu
WHERE asg.organization_id = p_populate_id
AND   p.person_id = asg.person_id
AND   pptu.person_id = p.person_id
AND   ppt.person_type_id = pptu.person_type_id
AND   ppt.system_person_type in ('EMP','EMP_APL','CWK')
AND   asg.assignment_type in ('A','E','C')
AND   ( p_person_type IS NULL OR  (p_person_type IS NOT NULL AND decode(ppt.SYSTEM_PERSON_TYPE,'EMP_APL','EMP',ppt.SYSTEM_PERSON_TYPE)=p_person_type));