DBA Data[Home] [Help]

APPS.PAY_FR_MIGRATE_TIME_ANALYSIS dependencies on HR_GENERAL

Line 112: l_head_full_name := hr_general.decode_lookup('FR_TIME_MIGR_HEADINGS', 'FULL_NAME');

108: FETCH csr_migr_script_run INTO l_script_run;
109: IF l_script_run = 0 THEN
110: -- Update the required values
111: -- Assign values to teh heading variables
112: l_head_full_name := hr_general.decode_lookup('FR_TIME_MIGR_HEADINGS', 'FULL_NAME');
113: l_head_ctr_ref := hr_general.decode_lookup('FR_TIME_MIGR_HEADINGS', 'CTR_REFERENCE');
114: l_head_start_date := hr_general.decode_lookup('FR_TIME_MIGR_HEADINGS', 'CTR_START_DATE');
115: l_head_end_date := hr_general.decode_lookup('FR_TIME_MIGR_HEADINGS', 'CTR_END_DATE');
116: l_head_fixed_time := hr_general.decode_lookup('FR_TIME_MIGR_HEADINGS', 'FIXED_WORKING_TIME');

Line 113: l_head_ctr_ref := hr_general.decode_lookup('FR_TIME_MIGR_HEADINGS', 'CTR_REFERENCE');

109: IF l_script_run = 0 THEN
110: -- Update the required values
111: -- Assign values to teh heading variables
112: l_head_full_name := hr_general.decode_lookup('FR_TIME_MIGR_HEADINGS', 'FULL_NAME');
113: l_head_ctr_ref := hr_general.decode_lookup('FR_TIME_MIGR_HEADINGS', 'CTR_REFERENCE');
114: l_head_start_date := hr_general.decode_lookup('FR_TIME_MIGR_HEADINGS', 'CTR_START_DATE');
115: l_head_end_date := hr_general.decode_lookup('FR_TIME_MIGR_HEADINGS', 'CTR_END_DATE');
116: l_head_fixed_time := hr_general.decode_lookup('FR_TIME_MIGR_HEADINGS', 'FIXED_WORKING_TIME');
117: l_head_amount := hr_general.decode_lookup('FR_TIME_MIGR_HEADINGS', 'FIXED_TIME_AMT');

Line 114: l_head_start_date := hr_general.decode_lookup('FR_TIME_MIGR_HEADINGS', 'CTR_START_DATE');

110: -- Update the required values
111: -- Assign values to teh heading variables
112: l_head_full_name := hr_general.decode_lookup('FR_TIME_MIGR_HEADINGS', 'FULL_NAME');
113: l_head_ctr_ref := hr_general.decode_lookup('FR_TIME_MIGR_HEADINGS', 'CTR_REFERENCE');
114: l_head_start_date := hr_general.decode_lookup('FR_TIME_MIGR_HEADINGS', 'CTR_START_DATE');
115: l_head_end_date := hr_general.decode_lookup('FR_TIME_MIGR_HEADINGS', 'CTR_END_DATE');
116: l_head_fixed_time := hr_general.decode_lookup('FR_TIME_MIGR_HEADINGS', 'FIXED_WORKING_TIME');
117: l_head_amount := hr_general.decode_lookup('FR_TIME_MIGR_HEADINGS', 'FIXED_TIME_AMT');
118: l_head_units := hr_general.decode_lookup('FR_TIME_MIGR_HEADINGS', 'FIXED_TIME_UNIT');

Line 115: l_head_end_date := hr_general.decode_lookup('FR_TIME_MIGR_HEADINGS', 'CTR_END_DATE');

111: -- Assign values to teh heading variables
112: l_head_full_name := hr_general.decode_lookup('FR_TIME_MIGR_HEADINGS', 'FULL_NAME');
113: l_head_ctr_ref := hr_general.decode_lookup('FR_TIME_MIGR_HEADINGS', 'CTR_REFERENCE');
114: l_head_start_date := hr_general.decode_lookup('FR_TIME_MIGR_HEADINGS', 'CTR_START_DATE');
115: l_head_end_date := hr_general.decode_lookup('FR_TIME_MIGR_HEADINGS', 'CTR_END_DATE');
116: l_head_fixed_time := hr_general.decode_lookup('FR_TIME_MIGR_HEADINGS', 'FIXED_WORKING_TIME');
117: l_head_amount := hr_general.decode_lookup('FR_TIME_MIGR_HEADINGS', 'FIXED_TIME_AMT');
118: l_head_units := hr_general.decode_lookup('FR_TIME_MIGR_HEADINGS', 'FIXED_TIME_UNIT');
119: l_head_frequency := hr_general.decode_lookup('FR_TIME_MIGR_HEADINGS', 'FIXED_TIME_FREQUENCY');

Line 116: l_head_fixed_time := hr_general.decode_lookup('FR_TIME_MIGR_HEADINGS', 'FIXED_WORKING_TIME');

112: l_head_full_name := hr_general.decode_lookup('FR_TIME_MIGR_HEADINGS', 'FULL_NAME');
113: l_head_ctr_ref := hr_general.decode_lookup('FR_TIME_MIGR_HEADINGS', 'CTR_REFERENCE');
114: l_head_start_date := hr_general.decode_lookup('FR_TIME_MIGR_HEADINGS', 'CTR_START_DATE');
115: l_head_end_date := hr_general.decode_lookup('FR_TIME_MIGR_HEADINGS', 'CTR_END_DATE');
116: l_head_fixed_time := hr_general.decode_lookup('FR_TIME_MIGR_HEADINGS', 'FIXED_WORKING_TIME');
117: l_head_amount := hr_general.decode_lookup('FR_TIME_MIGR_HEADINGS', 'FIXED_TIME_AMT');
118: l_head_units := hr_general.decode_lookup('FR_TIME_MIGR_HEADINGS', 'FIXED_TIME_UNIT');
119: l_head_frequency := hr_general.decode_lookup('FR_TIME_MIGR_HEADINGS', 'FIXED_TIME_FREQUENCY');
120: l_head_wrk_days := hr_general.decode_lookup('FR_TIME_MIGR_HEADINGS', 'WORKING_TIME_YEAR');

Line 117: l_head_amount := hr_general.decode_lookup('FR_TIME_MIGR_HEADINGS', 'FIXED_TIME_AMT');

113: l_head_ctr_ref := hr_general.decode_lookup('FR_TIME_MIGR_HEADINGS', 'CTR_REFERENCE');
114: l_head_start_date := hr_general.decode_lookup('FR_TIME_MIGR_HEADINGS', 'CTR_START_DATE');
115: l_head_end_date := hr_general.decode_lookup('FR_TIME_MIGR_HEADINGS', 'CTR_END_DATE');
116: l_head_fixed_time := hr_general.decode_lookup('FR_TIME_MIGR_HEADINGS', 'FIXED_WORKING_TIME');
117: l_head_amount := hr_general.decode_lookup('FR_TIME_MIGR_HEADINGS', 'FIXED_TIME_AMT');
118: l_head_units := hr_general.decode_lookup('FR_TIME_MIGR_HEADINGS', 'FIXED_TIME_UNIT');
119: l_head_frequency := hr_general.decode_lookup('FR_TIME_MIGR_HEADINGS', 'FIXED_TIME_FREQUENCY');
120: l_head_wrk_days := hr_general.decode_lookup('FR_TIME_MIGR_HEADINGS', 'WORKING_TIME_YEAR');
121: l_head_asg_hrs := hr_general.decode_lookup('FR_TIME_MIGR_HEADINGS', 'ASG_NORMAL_HR');

Line 118: l_head_units := hr_general.decode_lookup('FR_TIME_MIGR_HEADINGS', 'FIXED_TIME_UNIT');

114: l_head_start_date := hr_general.decode_lookup('FR_TIME_MIGR_HEADINGS', 'CTR_START_DATE');
115: l_head_end_date := hr_general.decode_lookup('FR_TIME_MIGR_HEADINGS', 'CTR_END_DATE');
116: l_head_fixed_time := hr_general.decode_lookup('FR_TIME_MIGR_HEADINGS', 'FIXED_WORKING_TIME');
117: l_head_amount := hr_general.decode_lookup('FR_TIME_MIGR_HEADINGS', 'FIXED_TIME_AMT');
118: l_head_units := hr_general.decode_lookup('FR_TIME_MIGR_HEADINGS', 'FIXED_TIME_UNIT');
119: l_head_frequency := hr_general.decode_lookup('FR_TIME_MIGR_HEADINGS', 'FIXED_TIME_FREQUENCY');
120: l_head_wrk_days := hr_general.decode_lookup('FR_TIME_MIGR_HEADINGS', 'WORKING_TIME_YEAR');
121: l_head_asg_hrs := hr_general.decode_lookup('FR_TIME_MIGR_HEADINGS', 'ASG_NORMAL_HR');
122: l_head_asg_freq := hr_general.decode_lookup('FR_TIME_MIGR_HEADINGS', 'ASG_FREQUENCY');

Line 119: l_head_frequency := hr_general.decode_lookup('FR_TIME_MIGR_HEADINGS', 'FIXED_TIME_FREQUENCY');

115: l_head_end_date := hr_general.decode_lookup('FR_TIME_MIGR_HEADINGS', 'CTR_END_DATE');
116: l_head_fixed_time := hr_general.decode_lookup('FR_TIME_MIGR_HEADINGS', 'FIXED_WORKING_TIME');
117: l_head_amount := hr_general.decode_lookup('FR_TIME_MIGR_HEADINGS', 'FIXED_TIME_AMT');
118: l_head_units := hr_general.decode_lookup('FR_TIME_MIGR_HEADINGS', 'FIXED_TIME_UNIT');
119: l_head_frequency := hr_general.decode_lookup('FR_TIME_MIGR_HEADINGS', 'FIXED_TIME_FREQUENCY');
120: l_head_wrk_days := hr_general.decode_lookup('FR_TIME_MIGR_HEADINGS', 'WORKING_TIME_YEAR');
121: l_head_asg_hrs := hr_general.decode_lookup('FR_TIME_MIGR_HEADINGS', 'ASG_NORMAL_HR');
122: l_head_asg_freq := hr_general.decode_lookup('FR_TIME_MIGR_HEADINGS', 'ASG_FREQUENCY');
123: --

Line 120: l_head_wrk_days := hr_general.decode_lookup('FR_TIME_MIGR_HEADINGS', 'WORKING_TIME_YEAR');

116: l_head_fixed_time := hr_general.decode_lookup('FR_TIME_MIGR_HEADINGS', 'FIXED_WORKING_TIME');
117: l_head_amount := hr_general.decode_lookup('FR_TIME_MIGR_HEADINGS', 'FIXED_TIME_AMT');
118: l_head_units := hr_general.decode_lookup('FR_TIME_MIGR_HEADINGS', 'FIXED_TIME_UNIT');
119: l_head_frequency := hr_general.decode_lookup('FR_TIME_MIGR_HEADINGS', 'FIXED_TIME_FREQUENCY');
120: l_head_wrk_days := hr_general.decode_lookup('FR_TIME_MIGR_HEADINGS', 'WORKING_TIME_YEAR');
121: l_head_asg_hrs := hr_general.decode_lookup('FR_TIME_MIGR_HEADINGS', 'ASG_NORMAL_HR');
122: l_head_asg_freq := hr_general.decode_lookup('FR_TIME_MIGR_HEADINGS', 'ASG_FREQUENCY');
123: --
124: -- Print the heading for the columns

Line 121: l_head_asg_hrs := hr_general.decode_lookup('FR_TIME_MIGR_HEADINGS', 'ASG_NORMAL_HR');

117: l_head_amount := hr_general.decode_lookup('FR_TIME_MIGR_HEADINGS', 'FIXED_TIME_AMT');
118: l_head_units := hr_general.decode_lookup('FR_TIME_MIGR_HEADINGS', 'FIXED_TIME_UNIT');
119: l_head_frequency := hr_general.decode_lookup('FR_TIME_MIGR_HEADINGS', 'FIXED_TIME_FREQUENCY');
120: l_head_wrk_days := hr_general.decode_lookup('FR_TIME_MIGR_HEADINGS', 'WORKING_TIME_YEAR');
121: l_head_asg_hrs := hr_general.decode_lookup('FR_TIME_MIGR_HEADINGS', 'ASG_NORMAL_HR');
122: l_head_asg_freq := hr_general.decode_lookup('FR_TIME_MIGR_HEADINGS', 'ASG_FREQUENCY');
123: --
124: -- Print the heading for the columns
125: -- Presently using the following format to display data in the log file

Line 122: l_head_asg_freq := hr_general.decode_lookup('FR_TIME_MIGR_HEADINGS', 'ASG_FREQUENCY');

118: l_head_units := hr_general.decode_lookup('FR_TIME_MIGR_HEADINGS', 'FIXED_TIME_UNIT');
119: l_head_frequency := hr_general.decode_lookup('FR_TIME_MIGR_HEADINGS', 'FIXED_TIME_FREQUENCY');
120: l_head_wrk_days := hr_general.decode_lookup('FR_TIME_MIGR_HEADINGS', 'WORKING_TIME_YEAR');
121: l_head_asg_hrs := hr_general.decode_lookup('FR_TIME_MIGR_HEADINGS', 'ASG_NORMAL_HR');
122: l_head_asg_freq := hr_general.decode_lookup('FR_TIME_MIGR_HEADINGS', 'ASG_FREQUENCY');
123: --
124: -- Print the heading for the columns
125: -- Presently using the following format to display data in the log file
126: -- Full Name Ctr reference Ctr_start_date Ctr_end_date Fixed_working_Time Amount Units Frequency Asg work days/yr Asg hours Asg freq

Line 192: l_prev_end_date := hr_general.start_of_time;

188: FOR person_contr_rec IN csr_get_all_contr(asg_mod_rec.person_id) LOOP
189: l_count_contr_date :=0;
190: -- IF rows are present
191: -- Initialize the previous end date as start of time
192: l_prev_end_date := hr_general.start_of_time;
193: --
194: -- Loop thru' all rows
195: hr_utility.set_location('asg_mod_rec.effective_start_date is: '||asg_mod_rec.effective_start_date,22);
196: hr_utility.set_location('getting date tracked data for contracts', 22);

Line 309: l_disp_fixed_time:= hr_general.decode_lookup('YES_NO',l_fixed_time);

305: -- End if for count rows
306: -- Assigning values for writing into log files
307: l_disp_start_date := fnd_date.date_to_displaydt(DATEVAL=> l_effective_start_date);
308: l_disp_end_date := fnd_date.date_to_displaydt(DATEVAL=> l_effective_end_date);
309: l_disp_fixed_time:= hr_general.decode_lookup('YES_NO',l_fixed_time);
310: l_disp_units:= hr_general.decode_lookup('FR_FIXED_TIME_UNITS',l_units);
311: l_disp_frequency:= hr_general.decode_lookup('FR_FIXED_TIME_FREQUENCY',l_frequency);
312:
313: -- log the modified data

Line 310: l_disp_units:= hr_general.decode_lookup('FR_FIXED_TIME_UNITS',l_units);

306: -- Assigning values for writing into log files
307: l_disp_start_date := fnd_date.date_to_displaydt(DATEVAL=> l_effective_start_date);
308: l_disp_end_date := fnd_date.date_to_displaydt(DATEVAL=> l_effective_end_date);
309: l_disp_fixed_time:= hr_general.decode_lookup('YES_NO',l_fixed_time);
310: l_disp_units:= hr_general.decode_lookup('FR_FIXED_TIME_UNITS',l_units);
311: l_disp_frequency:= hr_general.decode_lookup('FR_FIXED_TIME_FREQUENCY',l_frequency);
312:
313: -- log the modified data
314: FND_FILE.PUT(FND_FILE.LOG, asg_mod_rec.full_name||' '||l_ctr_ref||' '||l_disp_start_date||' '||l_disp_end_date);

Line 311: l_disp_frequency:= hr_general.decode_lookup('FR_FIXED_TIME_FREQUENCY',l_frequency);

307: l_disp_start_date := fnd_date.date_to_displaydt(DATEVAL=> l_effective_start_date);
308: l_disp_end_date := fnd_date.date_to_displaydt(DATEVAL=> l_effective_end_date);
309: l_disp_fixed_time:= hr_general.decode_lookup('YES_NO',l_fixed_time);
310: l_disp_units:= hr_general.decode_lookup('FR_FIXED_TIME_UNITS',l_units);
311: l_disp_frequency:= hr_general.decode_lookup('FR_FIXED_TIME_FREQUENCY',l_frequency);
312:
313: -- log the modified data
314: FND_FILE.PUT(FND_FILE.LOG, asg_mod_rec.full_name||' '||l_ctr_ref||' '||l_disp_start_date||' '||l_disp_end_date);
315: FND_FILE.PUT(FND_FILE.LOG, ' '||l_disp_fixed_time||' '||l_disp_canon_amt||' '||l_disp_units||' '||l_disp_frequency);