APPS.HXC_PROJ_MANAGER_APPROVAL_PKG SQL Statements

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

Line: 8

select approval_style_id from HXC_APPROVAL_STYLES where name ='SEEDED_APPL_PA_MGR';

Line: 15

select TIME_RECIPIENT_ID from HXC_TIME_RECIPIENTs where APPLICATION_ID = 275 ;

Line: 19

select APPROVAL_COMP_ID, OBJECT_VERSION_NUMBER from hxc_approval_comps where APPROVAL_MECHANISM = 'ENTRY_LEVEL_APPROVAL'  and APPROVAL_STYLE_ID = l_approval_style_id;

Line: 24

select FLEX_VALUE_SET_ID from fnd_flex_value_sets where flex_value_set_name = 'HXC_ALL_PROJECTS';

Line: 26

g_update_flag NUMBER;

Line: 42

select time_category_comp_id, object_version_number, time_category_id
from hxc_time_category_comps
where value_id = to_char(l_project_id)
and    TIME_CATEGORY_ID IN (     SELECT  TIME_CATEGORY_ID  FROM HXC_TIME_CATEGORIES
   WHERE TIME_CATEGORY_NAME LIKE 'PROJECT MANAGER :: % SYSTEM GENERATED DO NOT MODIFY'   );

Line: 52

select time_category_id from hxc_time_categories where time_category_name = l_time_category_name;

Line: 57

select APPROVAL_MECHANISM, APPROVAL_MECHANISM_ID, APPROVAL_COMP_ID, OBJECT_VERSION_NUMBER , WF_NAME , WF_ITEM_TYPE from hxc_approval_comps where
APPROVAL_STYLE_ID = l_approval_style_id  and TIME_CATEGORY_ID = l_time_category_id
and OBJECT_VERSION_NUMBER  = ( select max( OBJECT_VERSION_NUMBER ) from hxc_approval_comps where
APPROVAL_STYLE_ID = l_approval_style_id  and TIME_CATEGORY_ID = l_time_category_id);

Line: 65

SELECT	mapping_component_id
  FROM	hxc_mapping_components_v
 WHERE	bld_blk_info_type	= 'PROJECTS'
   AND	field_name	= 'Project_Id';

Line: 221

	IF l_time_category_name = 'PROJECT MANAGER :: -1 SYSTEM GENERATED DO NOT MODIFY' and p_default_approval_mechanism IS NOT NULL and g_update_flag  = 0
	THEN
	  if g_debug then
	  	hr_utility.set_location(l_proc, 50);

Line: 239

			g_update_flag := 1;

Line: 246

				g_update_flag := 1;

Line: 252

				g_update_flag := 1;

Line: 258

			---- update

IF g_update_flag = 1
THEN
	  if g_debug then
	  	hr_utility.set_location(l_proc, 60);

Line: 266

	hxc_approval_comps_api.update_approval_comps
	  (
	  p_approval_comp_id             => l_approval_comp_id
	  ,p_object_version_number       => l_object_version_number
	  ,p_approval_mechanism          =>  l_approval_mechanism
	  ,p_approval_mechanism_id       =>  l_mechanism_id
	  ,p_time_recipient_id           =>   -1
                ,p_approval_style_id     => l_approval_style_id
	  ,p_wf_item_type                =>  p_wf_item_type
	  ,p_wf_name                     =>  p_wf_name
	  ,p_start_date                  => sysdate
	  ,p_end_date                    =>  hr_general.end_of_time
	  ,p_time_category_id            => l_time_category_id
	  ,p_parent_comp_id              =>  l_parent_comp_id
	  ,p_parent_comp_ovn             => l_parent_object_version_number );

Line: 329

/* The project set-up has changed and so we need to delete previous time cat comp and then add new one */
		-- dele

		hxc_time_category_comp_api.delete_time_category_comp
		 (  p_time_category_comp_id   => l_time_category_comp_id_old
		     ,p_object_version_number   => l_object_version_number_old
		   );