[Home] [Help]
157: hr_utility.set_location ( 'p_effective_end_date'||p_effective_end_date, 10);
158:
159: IF p_effective_start_date is NULL AND p_effective_end_date IS NULL
160: THEN
161: DELETE FROM PAY_RANGE_TEMP;
162:
163: ELSE
164:
165: OPEN CSR_Legislation_Code;
379: SELECT distinct
380: RANGE_TABLE_NUMBER,
381: PERIOD_FREQUENCY,
382: EARNINGS_TYPE
383: FROM PAY_RANGE_TEMP;
384:
385:
386: CURSOR csr_range_band_val_frm_tmp_tab( l_range_table_num NUMBER,l_period_frequency VARCHAR2,l_earnings_type VARCHAR2)
387: IS
387: IS
388: SELECT RANGE_ID,LOW_BAND,
389: HIGH_BAND,
390: AMOUNT1
391: FROM PAY_RANGE_TEMP
392: WHERE RANGE_TABLE_NUMBER = l_range_table_num
393: AND PERIOD_FREQUENCY = l_period_frequency
394: AND EARNINGS_TYPE = l_earnings_type;
395:
429: BEGIN
430:
431: l_Check := ' ';
432:
433: select max(range_id) into l_max_range_id from PAY_RANGE_TEMP;
434:
435: hr_utility.set_location ( 'UPLOAD PROCESS',10);
436:
437: l_object_version_number := 1;
559: -- check to find whether it is last record to avoid high band search
560: if (l_max_range_id <> l_range_id) then
561:
562: -- Calculates the HIGH_BAND values by looking a record forward
563: select decode(low_band-1,-1,99999,low_band-1) into l_high_band from PAY_RANGE_TEMP where range_id=l_range_id+1;
564: pay_range_api.create_range
565: (
566: P_RANGE_TABLE_ID => l_pay_f_range_table_id
567: ,P_LOW_BAND => l_low_band
712: -- Batch Variables
713: l_batch_seq NUMBER := 0;
714: l_batch_id NUMBER;
715:
716: -- variables which represents columns in PAY_RANGE_TEMP table.
717: l_range_table_number PAY_RANGE_TABLES_F .RANGE_TABLE_NUMBER%TYPE;
718: l_period_frequency PAY_RANGE_TABLES_F .PERIOD_FREQUENCY%TYPE;
719: l_earnings_type PAY_RANGE_TABLES_F .EARNINGS_TYPE%TYPE;
720: l_low_band PAY_RANGES_F.LOW_BAND%TYPE;
770: ,p_AMOUNT1 => l_AMOUNT1
771: );
772:
773: insert into
774: pay_range_temp
775: ( RANGE_ID,
776: RANGE_TABLE_NUMBER,
777: ROW_VALUE_UOM,
778: PERIOD_FREQUENCY,