eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_FI_TC_DP_UPLOAD SQL Statements

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

Line: 65


	        l_datetrack_update_mode VARCHAR2(80);

Line: 135


		SELECT legislation_code, name
		FROM per_business_groups
		WHERE business_group_id = v_bg_id;

Line: 143


		SELECT  PAA.ASSIGNMENT_ID
		FROM per_all_assignments_f PAA
		, per_all_people_f PAP
		, hr_soft_coding_keyflex SCL
		WHERE PAA.BUSINESS_GROUP_ID      = p_business_group_id
		AND PAP.per_information_category ='FI'
		AND PAP.NATIONAL_IDENTIFIER = p_ni
		AND PAA.PERSON_ID = PAP.PERSON_ID
		AND PAA.PRIMARY_FLAG = 'Y'
		AND PAA.soft_coding_keyflex_id = SCL.soft_coding_keyflex_id
		AND fnd_date.canonical_to_date(p_effective_date) between  PAA.EFFECTIVE_START_DATE  and PAA.EFFECTIVE_END_DATE
		AND fnd_date.canonical_to_date(p_effective_date) between  PAP.EFFECTIVE_START_DATE  and PAP.EFFECTIVE_END_DATE
		AND SCL.ENABLED_FLAG = 'Y'
		AND SCL.SEGMENT2       in
		( select to_char(hoi1.organization_id)
		 from HR_ORGANIZATION_UNITS o1
		, HR_ORGANIZATION_INFORMATION hoi1
		, HR_ORGANIZATION_INFORMATION hoi2
		, HR_ORGANIZATION_INFORMATION hoi3
		, HR_ORGANIZATION_INFORMATION hoi4
		WHERE o1.business_group_id = p_business_group_id
		and hoi1.organization_id = o1.organization_id
		and hoi1.org_information1 = 'FI_LOCAL_UNIT'
		and hoi1.org_information_context = 'CLASS'
		and o1.organization_id = hoi2.org_information1
		and hoi2.ORG_INFORMATION_CONTEXT='FI_LOCAL_UNITS'
		and hoi2.organization_id =  hoi3.organization_id
		and hoi3.ORG_INFORMATION_CONTEXT='CLASS'
		and hoi3.org_information1 = 'HR_LEGAL_EMPLOYER'
		and hoi4.ORG_INFORMATION_CONTEXT='FI_LEGAL_EMPLOYER_DETAILS'
		and hoi4.organization_id =  hoi3.organization_id
		and hoi4.org_information1 = SUBSTR(p_employer_org_no,1,9)
		and fnd_date.canonical_to_date(p_effective_date) >= o1.DATE_FROM
		and fnd_date.canonical_to_date(p_effective_date) <= nvl(o1.DATE_TO, fnd_date.canonical_to_date(p_effective_date)));

Line: 184


		SELECT  PAA.ASSIGNMENT_ID
		FROM per_all_assignments_f PAA
		, per_all_people_f PAP
		, hr_soft_coding_keyflex SCL
		WHERE PAA.BUSINESS_GROUP_ID      = p_business_group_id
		AND PAP.per_information_category ='FI'
		AND PAP.NATIONAL_IDENTIFIER = p_ni
		AND PAA.PERSON_ID = PAP.PERSON_ID
		AND PAA.soft_coding_keyflex_id = SCL.soft_coding_keyflex_id
		AND fnd_date.canonical_to_date(p_effective_date) between  PAA.EFFECTIVE_START_DATE  and PAA.EFFECTIVE_END_DATE
		AND fnd_date.canonical_to_date(p_effective_date) between  PAP.EFFECTIVE_START_DATE  and PAP.EFFECTIVE_END_DATE
		AND SCL.ENABLED_FLAG = 'Y'
		AND SCL.SEGMENT2       in
		( select to_char(hoi1.organization_id)
		 from HR_ORGANIZATION_UNITS o1
		, HR_ORGANIZATION_INFORMATION hoi1
		, HR_ORGANIZATION_INFORMATION hoi2
		, HR_ORGANIZATION_INFORMATION hoi3
		, HR_ORGANIZATION_INFORMATION hoi4
		WHERE o1.business_group_id = p_business_group_id
		and hoi1.organization_id = o1.organization_id
		and hoi1.org_information1 = 'FI_LOCAL_UNIT'
		and hoi1.org_information_context = 'CLASS'
		and o1.organization_id = hoi2.org_information1
		and hoi2.ORG_INFORMATION_CONTEXT='FI_LOCAL_UNITS'
		and hoi2.organization_id =  hoi3.organization_id
		and hoi3.ORG_INFORMATION_CONTEXT='CLASS'
		and hoi3.org_information1 = 'HR_LEGAL_EMPLOYER'
		and hoi4.ORG_INFORMATION_CONTEXT='FI_LEGAL_EMPLOYER_DETAILS'
		and hoi4.organization_id =  hoi3.organization_id
		and hoi4.org_information1 = SUBSTR(p_employer_org_no,1,9)
		and fnd_date.canonical_to_date(p_effective_date) >= o1.DATE_FROM
		and fnd_date.canonical_to_date(p_effective_date) <= nvl(o1.DATE_TO, fnd_date.canonical_to_date(p_effective_date)));

Line: 224


		SELECT pee.ELEMENT_ENTRY_ID , pet.ELEMENT_NAME, pee.EFFECTIVE_START_DATE,pee.EFFECTIVE_END_DATE
		from pay_element_entries_f pee
		, pay_element_types_f pet
		, pay_element_links_f pel
		, per_all_assignments_f paa
		where pet.ELEMENT_NAME = p_element_name
		and pet.legislation_code = 'FI'
		and pel.ELEMENT_TYPE_ID = pet.ELEMENT_TYPE_ID
		and pee.ELEMENT_LINK_ID = pel.ELEMENT_LINK_ID
		and paa.ASSIGNMENT_ID = pee.ASSIGNMENT_ID
		and pee.ELEMENT_TYPE_ID = pet.ELEMENT_TYPE_ID
		and pee.ASSIGNMENT_ID = p_assignment_id
		and fnd_date.canonical_to_date(p_effective_date) between pee.EFFECTIVE_START_DATE and pee.EFFECTIVE_END_DATE
		and fnd_date.canonical_to_date(p_effective_date) between pet.EFFECTIVE_START_DATE and pet.EFFECTIVE_END_DATE
		and fnd_date.canonical_to_date(p_effective_date) between pel.EFFECTIVE_START_DATE and pel.EFFECTIVE_END_DATE
		and fnd_date.canonical_to_date(p_effective_date) between paa.EFFECTIVE_START_DATE and paa.EFFECTIVE_END_DATE ;

Line: 243


		SELECT user_key_value, unique_key_id
		FROM   hr_pump_batch_line_user_keys
		WHERE  user_key_value = p_user_key_value;

Line: 250


		INSERT INTO fnd_sessions(SESSION_ID , EFFECTIVE_DATE )
		VALUES(userenv('SESSIONID'),fnd_date.canonical_to_date(p_effective_date)) ;

Line: 380


					 l_input_value_name10 := 'Override Manual Update';

Line: 436


							l_datetrack_update_mode := 'CORRECTION';

Line: 439


							l_datetrack_update_mode := 'UPDATE_OVERRIDE';

Line: 441


							l_datetrack_update_mode := 'UPDATE';

Line: 444


						hr_utility.set_location (   '  Datetrack Update Mode:' || l_datetrack_update_mode, 180);

Line: 447


						-- Data Pump procedure called to create batch lines to update element entries
						hrdpp_update_element_entry.insert_batch_lines
						(p_batch_id      => l_batch_id
						,p_data_pump_business_grp_name => l_bg_name
						,P_DATETRACK_UPDATE_MODE =>  l_datetrack_update_mode
						,P_EFFECTIVE_DATE => fnd_date.canonical_to_date(p_effective_date)
						,P_ENTRY_VALUE1 => l_entry_value1
						,P_ENTRY_VALUE2 => l_entry_value2
						,P_ENTRY_VALUE3 => l_entry_value3
						,P_ENTRY_VALUE4 => l_entry_value4
						,P_ENTRY_VALUE5 => l_entry_value5
						,P_ENTRY_VALUE6 => l_entry_value6
						,P_ENTRY_VALUE7 => l_entry_value7
						,P_ENTRY_VALUE8 => l_entry_value8
						,P_ENTRY_VALUE9 => l_entry_value9
						,P_ENTRY_VALUE10 => l_entry_value10
						,P_ENTRY_VALUE11 => l_entry_value11
						,P_ENTRY_VALUE12 => l_entry_value12
						,P_ENTRY_VALUE13 => l_entry_value13
						,P_ENTRY_VALUE14 => l_entry_value14
						,P_ENTRY_VALUE15 => l_entry_value15
						,P_ELEMENT_ENTRY_USER_KEY => l_tc_ee_user_key
						,P_ELEMENT_NAME => l_element_name
						,P_LANGUAGE_CODE =>'US'
						,P_INPUT_VALUE_NAME1 =>l_input_value_name1
						,P_INPUT_VALUE_NAME2 =>l_input_value_name2
						,P_INPUT_VALUE_NAME3 =>l_input_value_name3
						,P_INPUT_VALUE_NAME4 =>l_input_value_name4
						,P_INPUT_VALUE_NAME5 =>l_input_value_name5
						,P_INPUT_VALUE_NAME6 =>l_input_value_name6
						,P_INPUT_VALUE_NAME7 =>l_input_value_name7
						,P_INPUT_VALUE_NAME8 =>l_input_value_name8
						,P_INPUT_VALUE_NAME9 =>l_input_value_name9
						,P_INPUT_VALUE_NAME10 =>l_input_value_name10
						,P_INPUT_VALUE_NAME11 =>l_input_value_name11
						,P_INPUT_VALUE_NAME12 =>l_input_value_name12
						,P_INPUT_VALUE_NAME13 =>l_input_value_name13
						,P_INPUT_VALUE_NAME14 =>l_input_value_name14
						,P_INPUT_VALUE_NAME15 =>l_input_value_name15);

Line: 498


						--DELETE the key

							IF csr_get_user_key%FOUND THEN
								DELETE FROM HR_PUMP_BATCH_LINE_USER_KEYS WHERE unique_key_id =l_unique_key_id;

Line: 524


						hrdpp_create_element_entry.insert_batch_lines
						(p_batch_id      => l_batch_id
						,p_data_pump_business_grp_name => l_bg_name
						,P_EFFECTIVE_DATE => fnd_date.canonical_to_date(p_effective_date)
						,P_ENTRY_TYPE     =>  'E'
						,P_CREATOR_TYPE   =>  'F'
						,P_ENTRY_VALUE1 => l_entry_value1
						,P_ENTRY_VALUE2 => l_entry_value2
						,P_ENTRY_VALUE3 => l_entry_value3
						,P_ENTRY_VALUE4 => l_entry_value4
						,P_ENTRY_VALUE5 => l_entry_value5
						,P_ENTRY_VALUE6 => l_entry_value6
						,P_ENTRY_VALUE7 => l_entry_value7
						,P_ENTRY_VALUE8 => l_entry_value8
						,P_ENTRY_VALUE9 => l_entry_value9
						,P_ENTRY_VALUE10 => l_entry_value10
						,P_ENTRY_VALUE11 => l_entry_value11
						,P_ENTRY_VALUE12 => l_entry_value12
						,P_ENTRY_VALUE13 => l_entry_value13
						,P_ENTRY_VALUE14 => l_entry_value14
						,P_ENTRY_VALUE15 => l_entry_value15
						,P_ELEMENT_ENTRY_USER_KEY => l_tc_ee_user_key
						,P_ASSIGNMENT_USER_KEY => L_ASSIGNMENT_USER_KEY
						,P_ELEMENT_LINK_USER_KEY => L_ELEMENT_LINK_USER_KEY
						,P_LANGUAGE_CODE =>'US'
						,P_ELEMENT_NAME => 'Tax Card'
						,P_INPUT_VALUE_NAME1 =>l_input_value_name1
						,P_INPUT_VALUE_NAME2 =>l_input_value_name2
						,P_INPUT_VALUE_NAME3 =>l_input_value_name3
						,P_INPUT_VALUE_NAME4 =>l_input_value_name4
						,P_INPUT_VALUE_NAME5 =>l_input_value_name5
						,P_INPUT_VALUE_NAME6 =>l_input_value_name6
						,P_INPUT_VALUE_NAME7 =>l_input_value_name7
						,P_INPUT_VALUE_NAME8 =>l_input_value_name8
						,P_INPUT_VALUE_NAME9 =>l_input_value_name9
						,P_INPUT_VALUE_NAME10 =>l_input_value_name10
						,P_INPUT_VALUE_NAME11 =>l_input_value_name11
						,P_INPUT_VALUE_NAME12 =>l_input_value_name12
						,P_INPUT_VALUE_NAME13 =>l_input_value_name13
						,P_INPUT_VALUE_NAME14 =>l_input_value_name14
						,P_INPUT_VALUE_NAME15 =>l_input_value_name15);

Line: 672


							l_datetrack_update_mode := 'CORRECTION';

Line: 675


							l_datetrack_update_mode := 'UPDATE_OVERRIDE';

Line: 677


							l_datetrack_update_mode := 'UPDATE';

Line: 680


						hr_utility.set_location (   '  Datetrack Update Mode:' || l_datetrack_update_mode, 230);

Line: 683


						-- Data Pump procedure called to create batch lines to update element entries
						hrdpp_update_element_entry.insert_batch_lines
						(p_batch_id      => l_batch_id
						,p_data_pump_business_grp_name => l_bg_name
						,P_DATETRACK_UPDATE_MODE =>  l_datetrack_update_mode
						,P_EFFECTIVE_DATE => fnd_date.canonical_to_date(p_effective_date)
						,P_ENTRY_VALUE1 => l_t_entry_value1
						,P_ENTRY_VALUE2 => l_t_entry_value2
						,P_ENTRY_VALUE3 => l_t_entry_value3
						,P_ENTRY_VALUE4 => l_t_entry_value4
						,P_ENTRY_VALUE5 => l_t_entry_value5
						,P_ENTRY_VALUE6 => l_t_entry_value6
						,P_ENTRY_VALUE7 => l_t_entry_value7
						,P_ENTRY_VALUE8 => l_t_entry_value8
						,P_ENTRY_VALUE9 => l_t_entry_value9
						,P_ENTRY_VALUE10 => l_t_entry_value10
						,P_ENTRY_VALUE11 => l_t_entry_value11
						,P_ENTRY_VALUE12 => l_t_entry_value12
						,P_ENTRY_VALUE13 => l_t_entry_value13
						,P_ENTRY_VALUE14 => l_t_entry_value14
						,P_ENTRY_VALUE15 => l_t_entry_value15
						,P_ELEMENT_ENTRY_USER_KEY => l_t_ee_user_key
						,P_ELEMENT_NAME => l_element_name
						,P_LANGUAGE_CODE =>'US'
						,P_INPUT_VALUE_NAME1 =>l_input_value_name1
						,P_INPUT_VALUE_NAME2 =>l_input_value_name2
						,P_INPUT_VALUE_NAME3 =>l_input_value_name3
						,P_INPUT_VALUE_NAME4 =>l_input_value_name4
						,P_INPUT_VALUE_NAME5 =>l_input_value_name5
						,P_INPUT_VALUE_NAME6 =>l_input_value_name6
						,P_INPUT_VALUE_NAME7 =>l_input_value_name7
						,P_INPUT_VALUE_NAME8 =>l_input_value_name8
						,P_INPUT_VALUE_NAME9 =>l_input_value_name9
						,P_INPUT_VALUE_NAME10 =>l_input_value_name10
						,P_INPUT_VALUE_NAME11 =>l_input_value_name11
						,P_INPUT_VALUE_NAME12 =>l_input_value_name12
						,P_INPUT_VALUE_NAME13 =>l_input_value_name13
						,P_INPUT_VALUE_NAME14 =>l_input_value_name14
						,P_INPUT_VALUE_NAME15 =>l_input_value_name15);

Line: 1018


		*     p_entry_value10   Override Manual Update  ( not on file )
		*     p_entry_value11  	Lower Income Percentage
		*/

		--Set record length
		l_record_length := 140;

Line: 1119


		SELECT  payroll_id
		FROM per_all_assignments_f
		WHERE business_group_id     = p_business_group_id
		AND assignment_id	    = p_assignment_id
		AND fnd_date.canonical_to_date(p_effective_date)
		BETWEEN  effective_start_date  AND effective_end_date ;

Line: 1131


		SELECT element.element_link_id
		FROM pay_paywsmee_elements_lov element
		WHERE element.assignment_id = p_assignment_id
		AND  element.element_name = p_element_name
		AND (element.business_group_id = p_business_group_id
		OR (element.business_group_id is null and element.legislation_code = 'FI'))
		AND ( element.multiple_entries_allowed_flag = 'Y'
		OR (element.normal_exists = 'N'
		OR (p_payroll_id is not null
		AND ( (element.additional_entry_allowed_flag = 'Y'
		AND element.additional_exists = 'N' )
		OR (element.overridden = 'N' and element.adjusted = 'N' ))))) ;