APPS.HXC_TK_GRP_QUERY_CRITERIA_API SQL Statements

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

Line: 200

procedure update_tk_grp_query_criteria
  (p_validate                       in  boolean   default false
  ,p_tk_group_query_criteria_id     in  number
  ,p_tk_group_query_id              in  number
  ,p_object_version_number          in  out nocopy number
  ,p_criteria_type                  in  varchar2
  ,p_criteria_id                    in  number )
IS
  --
  -- Declare cursors and local variables
  --
	l_proc varchar2(72) ;

Line: 218

  	l_proc := g_package||' update_tk_grp_query_criteria';

Line: 224

  savepoint update_tk_grp_query_criteria;

Line: 255

    hxc_tk_grp_query_criteria_BK_2.update_tk_grp_query_criteria_b
	  (p_tk_group_query_criteria_id      => p_tk_group_query_criteria_id
	  ,p_tk_group_query_id               => p_tk_group_query_id
	  ,p_object_version_number           => p_object_version_number
          ,p_criteria_type                   => p_criteria_type
          ,p_criteria_id                     => p_criteria_id
  );

Line: 265

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

Line: 293

    hxc_tk_grp_query_criteria_BK_2.update_tk_grp_query_criteria_a
	  (p_tk_group_query_criteria_id      => p_tk_group_query_criteria_id
	  ,p_tk_group_query_id               => p_tk_group_query_id
	  ,p_object_version_number           => l_object_version_number
          ,p_criteria_type                   => p_criteria_type
          ,p_criteria_id                     => p_criteria_id
  );

Line: 303

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

Line: 333

    ROLLBACK TO update_tk_grp_query_criteria;

Line: 352

    ROLLBACK TO update_tk_grp_query_criteria;

Line: 355

end update_tk_grp_query_criteria;

Line: 365

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

Line: 380

  	l_proc := g_package||'delete_tk_grp_query_criteria';

Line: 386

  savepoint delete_tk_grp_query_criteria;

Line: 388

	hxc_tk_grp_query_criteria_api.chk_delete (
				 p_tk_group_query_criteria_id => p_tk_group_query_criteria_id );

Line: 399

    hxc_tk_grp_query_criteria_BK_3.delete_tk_grp_query_criteria_b
	  (p_tk_group_query_criteria_id     => p_tk_group_query_criteria_id
	  ,p_object_version_number => p_object_version_number
	  );

Line: 406

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

Line: 431

  hxc_tk_grp_query_criteria_BK_3.delete_tk_grp_query_criteria_a
	  (p_tk_group_query_criteria_id     => p_tk_group_query_criteria_id
	  ,p_object_version_number => p_object_version_number
	  );

Line: 438

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

Line: 460

    ROLLBACK TO delete_tk_grp_query_criteria;

Line: 466

    ROLLBACK TO delete_tk_grp_query_criteria;

Line: 469

end delete_tk_grp_query_criteria;

Line: 493

SELECT 'error'
FROM	sys.dual
WHERE EXISTS (
	SELECT	'x'
	FROM	hr_lookups h
	WHERE	h.lookup_type = 'HXC_TK_CRITERIA_TYPES'
        AND     h.lookup_code = p_criteria_type
        AND     h.enabled_flag = 'Y'
	AND	sysdate BETWEEN h.start_date_active AND NVL(h.end_date_active, hr_general.end_of_time) );

Line: 567

SELECT  'x'
FROM    dual
WHERE EXISTS ( select 'x'
               FROM   per_assignments_f asg
               WHERE  asg.assignment_id = p_criteria_id );

Line: 575

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

Line: 633

SELECT	'x'
FROM 	dual
WHERE EXISTS ( SELECT 'x'
               FROM   hxc_tk_group_queries tkgq
               WHERE  tkgq.tk_group_query_id = p_tk_group_query_id );

Line: 690

Procedure chk_delete
  (
   p_tk_group_query_criteria_id in number
  ) IS
BEGIN
null;

Line: 696

END chk_delete;

Line: 716

SELECT  asg.assignment_number
FROM    per_assignments asg
WHERE   asg.assignment_id = p_criteria_id;

Line: 721

SELECT  p.employee_number
FROM    per_people p
WHERE   p.person_id = p_criteria_id;

Line: 726

SELECT ppf.full_name
  FROM per_assignments_f asg,fnd_sessions ss,per_people_f ppf
 WHERE asg.effective_start_date <= ss.effective_date
   AND asg.effective_end_date >= ss.effective_date
   AND ss.session_id = USERENV ('sessionid')
   AND ppf.effective_start_date <= ss.effective_date
   AND ppf.effective_end_date >= ss.effective_date
   AND ppf.person_id = asg.person_id
   AND asg.assignment_id = p_criteria_id;

Line: 739

SELECT  p.full_name
FROM    per_people p
WHERE   p.person_id = p_criteria_id;

Line: 804

SELECT 'x'
FROM	sys.dual
WHERE EXISTS (
	SELECT	'x'
	FROM	hxc_tk_group_query_criteria tkgqc
	WHERE	tkgqc.tk_group_query_id = p_tk_group_query_id
        AND     tkgqc.criteria_id       = p_criteria_id
	AND	tkgqc.criteria_type     = p_criteria_type
        AND
	( tkgqc.tk_group_query_criteria_id <> p_tk_group_query_criteria_id OR
	  p_tk_group_query_criteria_id IS NULL ) );

Line: 871

SELECT rp.name
FROM   hxc_recurring_periods rp
WHERE  rp.recurring_period_id = TO_NUMBER(p_rp_id);

Line: 876

SELECT effective_date
FROM   fnd_sessions
WHERE  session_id = USERENV('sessionid');

Line: 943

SELECT effective_date
FROM   fnd_sessions
WHERE  session_id = USERENV('SESSIONID');

Line: 994

SELECT	rp.period_type
,	rp.duration_in_days
FROM  	hxc_recurring_periods rp
WHERE 	rp.recurring_period_id = TO_NUMBER(p_rp_id);