APPS.PER_RI_CREATE_HIER_ELEMENT SQL Statements

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

Line: 13

   l_sql_stmt :=  'Select line_status From '||p_view||' Where batch_line_id = :1';

Line: 24

Procedure insert_batch_lines(P_BATCH_ID                     in number
			     ,P_DATA_PUMP_BATCH_LINE_ID     in number default null
			     ,P_DATA_PUMP_BUSINESS_GRP_NAME in varchar2 default null
	                     ,P_USER_SEQUENCE               in number default null
			     ,P_LINK_VALUE                  in number default null
			     ,P_EFFECTIVE_DATE              in date
			     ,P_DATE_FROM                   in date
			     ,P_VIEW_ALL_ORGS               in varchar2
			     ,P_END_OF_TIME                 in date
	                     ,P_HR_INSTALLED                in varchar2
	                     ,P_PA_INSTALLED                in varchar2
	                     ,P_POS_CONTROL_ENABLED_FLAG    in varchar2
	                     ,P_WARNING_RAISED              in varchar2
			     ,P_PARENT_ORGANIZATION_NAME    in varchar2
			     ,P_LANGUAGE_CODE               in varchar2
			     ,P_ORG_STR_VERSION_USER_KEY    in varchar2
			     ,P_CHILD_ORGANIZATION_NAME     in varchar2
			     ,P_SECURITY_PROFILE_NAME       in varchar2) as

l_org_structure_user_key   Varchar2(240);

Line: 53

  Select p_org_str_version_user_key
    From hrdpv_create_hierarchy_element
   Where batch_line_id = c_batch_line_id;

Line: 58

	select posv.organization_structure_id
	from per_organization_structures pos,per_org_structure_versions posv
	where pos.organization_structure_id = posv.organization_structure_id
	and (posv.business_group_id +0 = c_bg_id
	or posv.business_group_id is null)
	and name = p_org_str_version_user_key;

Line: 69

	select hr_api.return_business_group_id(c_bg_name) as business_group_id
	from dual;

Line: 74

  Select unique_key_id
    From hr_pump_batch_line_user_keys
   Where user_key_value = l_org_structure_user_key;

Line: 82

    hr_utility.set_location('Entering per_ri_create_hier_element.insert_batch_lines', 10);

Line: 124

hr_utility.set_location('Inserted the User Key '||l_org_structure_user_key , 50);

Line: 129

hrdpp_create_hierarchy_element.insert_batch_lines(P_BATCH_ID                     => p_batch_id
						  ,P_DATA_PUMP_BATCH_LINE_ID      => p_data_pump_batch_line_id
					          ,P_DATA_PUMP_BUSINESS_GRP_NAME  => p_data_pump_business_grp_name
						  ,P_USER_SEQUENCE                => p_user_sequence
						  ,P_LINK_VALUE                   => p_link_value
						  ,P_EFFECTIVE_DATE               => p_effective_date
						  ,P_DATE_FROM                    => p_date_from
						  ,P_VIEW_ALL_ORGS                => p_view_all_orgs
						  ,P_END_OF_TIME                  => p_end_of_time
						  ,P_HR_INSTALLED                 => p_hr_installed
						  ,P_PA_INSTALLED                 => p_pa_installed
						  ,P_POS_CONTROL_ENABLED_FLAG     => p_pos_control_enabled_flag
						  ,P_WARNING_RAISED               => p_warning_raised
						  ,P_PARENT_ORGANIZATION_NAME     => p_parent_organization_name
						  ,P_LANGUAGE_CODE                => p_language_code
						  ,P_ORG_STR_VERSION_USER_KEY     => l_org_structure_user_key
						  ,P_CHILD_ORGANIZATION_NAME      => p_child_organization_name
						  ,P_SECURITY_PROFILE_NAME        => p_security_profile_name );

Line: 150

End insert_batch_lines;