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_NO_EMP_CONT dependencies on PAY_NO_EMP_CONT

Line 1: package body PAY_NO_EMP_CONT as

1: package body PAY_NO_EMP_CONT as
2: /* $Header: pynoempcont.pkb 120.4.12000000.3 2007/07/16 17:03:15 sugarg noship $ */
3:
4:
5: ----------------------------------Function definitions----------------------------------------------

Line 126: g_tab_calc PAY_NO_EMP_CONT.g_tab_calc_tabtype;

122:
123:
124: -- Local PL/SQL Tables
125:
126: g_tab_calc PAY_NO_EMP_CONT.g_tab_calc_tabtype;
127: g_lu_tab PAY_NO_EMP_CONT.g_lu_tabtype;
128: g_mu_tab PAY_NO_EMP_CONT.g_mu_tabtype;
129:
130: -- Cursor definitions

Line 127: g_lu_tab PAY_NO_EMP_CONT.g_lu_tabtype;

123:
124: -- Local PL/SQL Tables
125:
126: g_tab_calc PAY_NO_EMP_CONT.g_tab_calc_tabtype;
127: g_lu_tab PAY_NO_EMP_CONT.g_lu_tabtype;
128: g_mu_tab PAY_NO_EMP_CONT.g_mu_tabtype;
129:
130: -- Cursor definitions
131:

Line 128: g_mu_tab PAY_NO_EMP_CONT.g_mu_tabtype;

124: -- Local PL/SQL Tables
125:
126: g_tab_calc PAY_NO_EMP_CONT.g_tab_calc_tabtype;
127: g_lu_tab PAY_NO_EMP_CONT.g_lu_tabtype;
128: g_mu_tab PAY_NO_EMP_CONT.g_mu_tabtype;
129:
130: -- Cursor definitions
131:
132: -- csr to get the current assignment_action_ids with the same LE

Line 238: OPEN PAY_NO_EMP_CONT.get_lu_details(p_local_unit_id);

234: hr_utility.trace('EMP_CONT ::: l_curr_zone = '|| l_curr_zone );
235: hr_utility.trace('EMP_CONT ::: l_curr_under_62 = '|| l_curr_under_62 );
236:
237: -- Get the Status and Report Separately for the Local Unit of the current assignment
238: OPEN PAY_NO_EMP_CONT.get_lu_details(p_local_unit_id);
239: FETCH PAY_NO_EMP_CONT.get_lu_details INTO l_lu_status , l_lu_rep_sep ;
240: CLOSE PAY_NO_EMP_CONT.get_lu_details;
241:
242: hr_utility.trace('EMP_CONT ::: l_lu_status = '|| l_lu_status );

Line 239: FETCH PAY_NO_EMP_CONT.get_lu_details INTO l_lu_status , l_lu_rep_sep ;

235: hr_utility.trace('EMP_CONT ::: l_curr_under_62 = '|| l_curr_under_62 );
236:
237: -- Get the Status and Report Separately for the Local Unit of the current assignment
238: OPEN PAY_NO_EMP_CONT.get_lu_details(p_local_unit_id);
239: FETCH PAY_NO_EMP_CONT.get_lu_details INTO l_lu_status , l_lu_rep_sep ;
240: CLOSE PAY_NO_EMP_CONT.get_lu_details;
241:
242: hr_utility.trace('EMP_CONT ::: l_lu_status = '|| l_lu_status );
243: hr_utility.trace('EMP_CONT ::: l_lu_rep_sep = '|| l_lu_rep_sep );

Line 240: CLOSE PAY_NO_EMP_CONT.get_lu_details;

236:
237: -- Get the Status and Report Separately for the Local Unit of the current assignment
238: OPEN PAY_NO_EMP_CONT.get_lu_details(p_local_unit_id);
239: FETCH PAY_NO_EMP_CONT.get_lu_details INTO l_lu_status , l_lu_rep_sep ;
240: CLOSE PAY_NO_EMP_CONT.get_lu_details;
241:
242: hr_utility.trace('EMP_CONT ::: l_lu_status = '|| l_lu_status );
243: hr_utility.trace('EMP_CONT ::: l_lu_rep_sep = '|| l_lu_rep_sep );
244: hr_utility.trace('EMP_CONT ::: goin to test for local unit report separately..........');

Line 254: start_index_main := NVL (PAY_NO_EMP_CONT.g_tab_main.FIRST, 0) ;

250: -- since LU is report separately, check if LE LU combination exists
251:
252: hr_utility.trace('EMP_CONT ::: Local unit is Rep Sep');
253:
254: start_index_main := NVL (PAY_NO_EMP_CONT.g_tab_main.FIRST, 0) ;
255: end_index_main := NVL (PAY_NO_EMP_CONT.g_tab_main.LAST, 0) ;
256: l_le_lu_exists := FALSE;
257:
258: -- loop through existing records for LE LU to check if the current LE LU exists

Line 255: end_index_main := NVL (PAY_NO_EMP_CONT.g_tab_main.LAST, 0) ;

251:
252: hr_utility.trace('EMP_CONT ::: Local unit is Rep Sep');
253:
254: start_index_main := NVL (PAY_NO_EMP_CONT.g_tab_main.FIRST, 0) ;
255: end_index_main := NVL (PAY_NO_EMP_CONT.g_tab_main.LAST, 0) ;
256: l_le_lu_exists := FALSE;
257:
258: -- loop through existing records for LE LU to check if the current LE LU exists
259: WHILE (PAY_NO_EMP_CONT.g_tab_main.EXISTS(start_index_main)) and (start_index_main <= end_index_main) LOOP

Line 259: WHILE (PAY_NO_EMP_CONT.g_tab_main.EXISTS(start_index_main)) and (start_index_main <= end_index_main) LOOP

255: end_index_main := NVL (PAY_NO_EMP_CONT.g_tab_main.LAST, 0) ;
256: l_le_lu_exists := FALSE;
257:
258: -- loop through existing records for LE LU to check if the current LE LU exists
259: WHILE (PAY_NO_EMP_CONT.g_tab_main.EXISTS(start_index_main)) and (start_index_main <= end_index_main) LOOP
260: IF (PAY_NO_EMP_CONT.g_tab_main(start_index_main).legal_employer_id = p_tax_unit_id) AND
261: (PAY_NO_EMP_CONT.g_tab_main(start_index_main).local_unit_id = p_local_unit_id) AND
262: (PAY_NO_EMP_CONT.g_tab_main(start_index_main).zone = l_curr_zone) AND
263: (PAY_NO_EMP_CONT.g_tab_main(start_index_main).under_62 = l_curr_under_62)

Line 260: IF (PAY_NO_EMP_CONT.g_tab_main(start_index_main).legal_employer_id = p_tax_unit_id) AND

256: l_le_lu_exists := FALSE;
257:
258: -- loop through existing records for LE LU to check if the current LE LU exists
259: WHILE (PAY_NO_EMP_CONT.g_tab_main.EXISTS(start_index_main)) and (start_index_main <= end_index_main) LOOP
260: IF (PAY_NO_EMP_CONT.g_tab_main(start_index_main).legal_employer_id = p_tax_unit_id) AND
261: (PAY_NO_EMP_CONT.g_tab_main(start_index_main).local_unit_id = p_local_unit_id) AND
262: (PAY_NO_EMP_CONT.g_tab_main(start_index_main).zone = l_curr_zone) AND
263: (PAY_NO_EMP_CONT.g_tab_main(start_index_main).under_62 = l_curr_under_62)
264:

Line 261: (PAY_NO_EMP_CONT.g_tab_main(start_index_main).local_unit_id = p_local_unit_id) AND

257:
258: -- loop through existing records for LE LU to check if the current LE LU exists
259: WHILE (PAY_NO_EMP_CONT.g_tab_main.EXISTS(start_index_main)) and (start_index_main <= end_index_main) LOOP
260: IF (PAY_NO_EMP_CONT.g_tab_main(start_index_main).legal_employer_id = p_tax_unit_id) AND
261: (PAY_NO_EMP_CONT.g_tab_main(start_index_main).local_unit_id = p_local_unit_id) AND
262: (PAY_NO_EMP_CONT.g_tab_main(start_index_main).zone = l_curr_zone) AND
263: (PAY_NO_EMP_CONT.g_tab_main(start_index_main).under_62 = l_curr_under_62)
264:
265: THEN

Line 262: (PAY_NO_EMP_CONT.g_tab_main(start_index_main).zone = l_curr_zone) AND

258: -- loop through existing records for LE LU to check if the current LE LU exists
259: WHILE (PAY_NO_EMP_CONT.g_tab_main.EXISTS(start_index_main)) and (start_index_main <= end_index_main) LOOP
260: IF (PAY_NO_EMP_CONT.g_tab_main(start_index_main).legal_employer_id = p_tax_unit_id) AND
261: (PAY_NO_EMP_CONT.g_tab_main(start_index_main).local_unit_id = p_local_unit_id) AND
262: (PAY_NO_EMP_CONT.g_tab_main(start_index_main).zone = l_curr_zone) AND
263: (PAY_NO_EMP_CONT.g_tab_main(start_index_main).under_62 = l_curr_under_62)
264:
265: THEN
266: l_le_lu_exists := TRUE;

Line 263: (PAY_NO_EMP_CONT.g_tab_main(start_index_main).under_62 = l_curr_under_62)

259: WHILE (PAY_NO_EMP_CONT.g_tab_main.EXISTS(start_index_main)) and (start_index_main <= end_index_main) LOOP
260: IF (PAY_NO_EMP_CONT.g_tab_main(start_index_main).legal_employer_id = p_tax_unit_id) AND
261: (PAY_NO_EMP_CONT.g_tab_main(start_index_main).local_unit_id = p_local_unit_id) AND
262: (PAY_NO_EMP_CONT.g_tab_main(start_index_main).zone = l_curr_zone) AND
263: (PAY_NO_EMP_CONT.g_tab_main(start_index_main).under_62 = l_curr_under_62)
264:
265: THEN
266: l_le_lu_exists := TRUE;
267: l_le_lu_index := start_index_main;

Line 282: p_run_base := PAY_NO_EMP_CONT.g_tab_main(l_le_lu_index).run_base;

278: IF l_le_lu_exists
279:
280: THEN -------------------------------------------------------------------------------------------------------------------------
281: -- since the combination alreday exists, calculation has been already done, just return values
282: p_run_base := PAY_NO_EMP_CONT.g_tab_main(l_le_lu_index).run_base;
283: p_run_contribution := PAY_NO_EMP_CONT.g_tab_main(l_le_lu_index).run_contribution;
284: p_curr_exemption_limit_used := 0; -- coz this value must have been returned before
285:
286: hr_utility.trace('EMP_CONT ::: LU found, since results exist, just returning them');

Line 283: p_run_contribution := PAY_NO_EMP_CONT.g_tab_main(l_le_lu_index).run_contribution;

279:
280: THEN -------------------------------------------------------------------------------------------------------------------------
281: -- since the combination alreday exists, calculation has been already done, just return values
282: p_run_base := PAY_NO_EMP_CONT.g_tab_main(l_le_lu_index).run_base;
283: p_run_contribution := PAY_NO_EMP_CONT.g_tab_main(l_le_lu_index).run_contribution;
284: p_curr_exemption_limit_used := 0; -- coz this value must have been returned before
285:
286: hr_utility.trace('EMP_CONT ::: LU found, since results exist, just returning them');
287: hr_utility.trace('EMP_CONT ::: LU ***** l_le_lu_index = '|| l_le_lu_index );

Line 359: OPEN PAY_NO_EMP_CONT.csr_get_exemption_limit(p_local_unit_id ,p_date_earned );

355: hr_utility.trace('EMP_CONT ::: LU ***** l_bal_val_ytd = '|| l_bal_val_ytd );
356: hr_utility.trace('EMP_CONT ::: LU ***** l_bal_val_bimonth = '|| l_bal_val_bimonth );
357: hr_utility.trace('EMP_CONT ::: LU ***** l_exemption_limit_used_yet = '|| l_exemption_limit_used_yet );
358:
359: OPEN PAY_NO_EMP_CONT.csr_get_exemption_limit(p_local_unit_id ,p_date_earned );
360: FETCH PAY_NO_EMP_CONT.csr_get_exemption_limit INTO l_exemption_limit ;
361: CLOSE PAY_NO_EMP_CONT.csr_get_exemption_limit;
362:
363: IF l_exemption_limit_used_yet >= l_exemption_limit

Line 360: FETCH PAY_NO_EMP_CONT.csr_get_exemption_limit INTO l_exemption_limit ;

356: hr_utility.trace('EMP_CONT ::: LU ***** l_bal_val_bimonth = '|| l_bal_val_bimonth );
357: hr_utility.trace('EMP_CONT ::: LU ***** l_exemption_limit_used_yet = '|| l_exemption_limit_used_yet );
358:
359: OPEN PAY_NO_EMP_CONT.csr_get_exemption_limit(p_local_unit_id ,p_date_earned );
360: FETCH PAY_NO_EMP_CONT.csr_get_exemption_limit INTO l_exemption_limit ;
361: CLOSE PAY_NO_EMP_CONT.csr_get_exemption_limit;
362:
363: IF l_exemption_limit_used_yet >= l_exemption_limit
364: THEN

Line 361: CLOSE PAY_NO_EMP_CONT.csr_get_exemption_limit;

357: hr_utility.trace('EMP_CONT ::: LU ***** l_exemption_limit_used_yet = '|| l_exemption_limit_used_yet );
358:
359: OPEN PAY_NO_EMP_CONT.csr_get_exemption_limit(p_local_unit_id ,p_date_earned );
360: FETCH PAY_NO_EMP_CONT.csr_get_exemption_limit INTO l_exemption_limit ;
361: CLOSE PAY_NO_EMP_CONT.csr_get_exemption_limit;
362:
363: IF l_exemption_limit_used_yet >= l_exemption_limit
364: THEN
365: l_LU_over_limit := 'Y';

Line 759: ,PAY_NO_EMP_CONT.g_tab_main

755: -- ec_main_calculation function call for LU
756: hr_utility.trace('EMP_CONT ::: LU ***** ec_main_calculation function call for LU , entering ' );
757:
758: l_main_index := ec_main_calculation (g_tab_calc
759: ,PAY_NO_EMP_CONT.g_tab_main
760: ,p_tax_unit_id
761: ,p_local_unit_id
762: ,l_exemption_limit_used
763: ,l_lu_status

Line 780: p_run_base := PAY_NO_EMP_CONT.g_tab_main(l_main_index).run_base;

776:
777: -- done all caclculation and entered values in the main table for next time usage
778:
779: -- returning values at LU level
780: p_run_base := PAY_NO_EMP_CONT.g_tab_main(l_main_index).run_base;
781: p_run_contribution := PAY_NO_EMP_CONT.g_tab_main(l_main_index).run_contribution;
782: p_curr_exemption_limit_used := PAY_NO_EMP_CONT.g_tab_main(l_main_index).exemption_limit_used;
783:
784: hr_utility.trace('EMP_CONT ::: LU ***** l_main_index = '|| l_main_index );

Line 781: p_run_contribution := PAY_NO_EMP_CONT.g_tab_main(l_main_index).run_contribution;

777: -- done all caclculation and entered values in the main table for next time usage
778:
779: -- returning values at LU level
780: p_run_base := PAY_NO_EMP_CONT.g_tab_main(l_main_index).run_base;
781: p_run_contribution := PAY_NO_EMP_CONT.g_tab_main(l_main_index).run_contribution;
782: p_curr_exemption_limit_used := PAY_NO_EMP_CONT.g_tab_main(l_main_index).exemption_limit_used;
783:
784: hr_utility.trace('EMP_CONT ::: LU ***** l_main_index = '|| l_main_index );
785: hr_utility.trace('EMP_CONT ::: LU ***** p_run_base = '|| p_run_base );

Line 782: p_curr_exemption_limit_used := PAY_NO_EMP_CONT.g_tab_main(l_main_index).exemption_limit_used;

778:
779: -- returning values at LU level
780: p_run_base := PAY_NO_EMP_CONT.g_tab_main(l_main_index).run_base;
781: p_run_contribution := PAY_NO_EMP_CONT.g_tab_main(l_main_index).run_contribution;
782: p_curr_exemption_limit_used := PAY_NO_EMP_CONT.g_tab_main(l_main_index).exemption_limit_used;
783:
784: hr_utility.trace('EMP_CONT ::: LU ***** l_main_index = '|| l_main_index );
785: hr_utility.trace('EMP_CONT ::: LU ***** p_run_base = '|| p_run_base );
786: hr_utility.trace('EMP_CONT ::: LU ***** p_run_contribution = '|| p_run_contribution );

Line 802: start_index_main := NVL (PAY_NO_EMP_CONT.g_tab_main.FIRST, 0) ;

798:
799: hr_utility.trace('EMP_CONT ::: LU is not report separately');
800: hr_utility.trace('EMP_CONT ::: checking if LE exists');
801:
802: start_index_main := NVL (PAY_NO_EMP_CONT.g_tab_main.FIRST, 0) ;
803: end_index_main := NVL (PAY_NO_EMP_CONT.g_tab_main.LAST, 0) ;
804: l_le_exists := FALSE;
805:
806: -- loop through existing records for LE and -9999 to check if the current LE exists

Line 803: end_index_main := NVL (PAY_NO_EMP_CONT.g_tab_main.LAST, 0) ;

799: hr_utility.trace('EMP_CONT ::: LU is not report separately');
800: hr_utility.trace('EMP_CONT ::: checking if LE exists');
801:
802: start_index_main := NVL (PAY_NO_EMP_CONT.g_tab_main.FIRST, 0) ;
803: end_index_main := NVL (PAY_NO_EMP_CONT.g_tab_main.LAST, 0) ;
804: l_le_exists := FALSE;
805:
806: -- loop through existing records for LE and -9999 to check if the current LE exists
807: WHILE (PAY_NO_EMP_CONT.g_tab_main.EXISTS(start_index_main)) and (start_index_main <= end_index_main) LOOP

Line 807: WHILE (PAY_NO_EMP_CONT.g_tab_main.EXISTS(start_index_main)) and (start_index_main <= end_index_main) LOOP

803: end_index_main := NVL (PAY_NO_EMP_CONT.g_tab_main.LAST, 0) ;
804: l_le_exists := FALSE;
805:
806: -- loop through existing records for LE and -9999 to check if the current LE exists
807: WHILE (PAY_NO_EMP_CONT.g_tab_main.EXISTS(start_index_main)) and (start_index_main <= end_index_main) LOOP
808:
809: IF (PAY_NO_EMP_CONT.g_tab_main(start_index_main).legal_employer_id = p_tax_unit_id) AND
810: (PAY_NO_EMP_CONT.g_tab_main(start_index_main).local_unit_id = -9999) AND
811: (PAY_NO_EMP_CONT.g_tab_main(start_index_main).zone = l_curr_zone) AND

Line 809: IF (PAY_NO_EMP_CONT.g_tab_main(start_index_main).legal_employer_id = p_tax_unit_id) AND

805:
806: -- loop through existing records for LE and -9999 to check if the current LE exists
807: WHILE (PAY_NO_EMP_CONT.g_tab_main.EXISTS(start_index_main)) and (start_index_main <= end_index_main) LOOP
808:
809: IF (PAY_NO_EMP_CONT.g_tab_main(start_index_main).legal_employer_id = p_tax_unit_id) AND
810: (PAY_NO_EMP_CONT.g_tab_main(start_index_main).local_unit_id = -9999) AND
811: (PAY_NO_EMP_CONT.g_tab_main(start_index_main).zone = l_curr_zone) AND
812: (PAY_NO_EMP_CONT.g_tab_main(start_index_main).under_62 = l_curr_under_62)
813:

Line 810: (PAY_NO_EMP_CONT.g_tab_main(start_index_main).local_unit_id = -9999) AND

806: -- loop through existing records for LE and -9999 to check if the current LE exists
807: WHILE (PAY_NO_EMP_CONT.g_tab_main.EXISTS(start_index_main)) and (start_index_main <= end_index_main) LOOP
808:
809: IF (PAY_NO_EMP_CONT.g_tab_main(start_index_main).legal_employer_id = p_tax_unit_id) AND
810: (PAY_NO_EMP_CONT.g_tab_main(start_index_main).local_unit_id = -9999) AND
811: (PAY_NO_EMP_CONT.g_tab_main(start_index_main).zone = l_curr_zone) AND
812: (PAY_NO_EMP_CONT.g_tab_main(start_index_main).under_62 = l_curr_under_62)
813:
814: THEN

Line 811: (PAY_NO_EMP_CONT.g_tab_main(start_index_main).zone = l_curr_zone) AND

807: WHILE (PAY_NO_EMP_CONT.g_tab_main.EXISTS(start_index_main)) and (start_index_main <= end_index_main) LOOP
808:
809: IF (PAY_NO_EMP_CONT.g_tab_main(start_index_main).legal_employer_id = p_tax_unit_id) AND
810: (PAY_NO_EMP_CONT.g_tab_main(start_index_main).local_unit_id = -9999) AND
811: (PAY_NO_EMP_CONT.g_tab_main(start_index_main).zone = l_curr_zone) AND
812: (PAY_NO_EMP_CONT.g_tab_main(start_index_main).under_62 = l_curr_under_62)
813:
814: THEN
815: l_le_exists := TRUE;

Line 812: (PAY_NO_EMP_CONT.g_tab_main(start_index_main).under_62 = l_curr_under_62)

808:
809: IF (PAY_NO_EMP_CONT.g_tab_main(start_index_main).legal_employer_id = p_tax_unit_id) AND
810: (PAY_NO_EMP_CONT.g_tab_main(start_index_main).local_unit_id = -9999) AND
811: (PAY_NO_EMP_CONT.g_tab_main(start_index_main).zone = l_curr_zone) AND
812: (PAY_NO_EMP_CONT.g_tab_main(start_index_main).under_62 = l_curr_under_62)
813:
814: THEN
815: l_le_exists := TRUE;
816: l_le_index := start_index_main;

Line 831: p_run_base := PAY_NO_EMP_CONT.g_tab_main(l_le_index).run_base;

827: -- if the LE and -9999 exists, return the values
828: IF l_le_exists
829:
830: THEN -------------------------------------------------------------------------------------------------------------------------
831: p_run_base := PAY_NO_EMP_CONT.g_tab_main(l_le_index).run_base;
832: p_run_contribution := PAY_NO_EMP_CONT.g_tab_main(l_le_index).run_contribution;
833: p_curr_exemption_limit_used := 0; -- coz this value must have been returned before
834:
835: hr_utility.trace('EMP_CONT ::: LE #### LE already exists, so just returning vales' );

Line 832: p_run_contribution := PAY_NO_EMP_CONT.g_tab_main(l_le_index).run_contribution;

828: IF l_le_exists
829:
830: THEN -------------------------------------------------------------------------------------------------------------------------
831: p_run_base := PAY_NO_EMP_CONT.g_tab_main(l_le_index).run_base;
832: p_run_contribution := PAY_NO_EMP_CONT.g_tab_main(l_le_index).run_contribution;
833: p_curr_exemption_limit_used := 0; -- coz this value must have been returned before
834:
835: hr_utility.trace('EMP_CONT ::: LE #### LE already exists, so just returning vales' );
836: hr_utility.trace('EMP_CONT ::: LE #### l_le_index = '|| l_le_index );

Line 852: OPEN PAY_NO_EMP_CONT.get_le_status(p_tax_unit_id);

848:
849: ---------- initializing the g_tab_calc table for LE and -9999 combination
850: hr_utility.trace('EMP_CONT ::: LE #### initializing the g_tab_calc , entering');
851:
852: OPEN PAY_NO_EMP_CONT.get_le_status(p_tax_unit_id);
853: FETCH PAY_NO_EMP_CONT.get_le_status INTO l_le_status;
854: CLOSE PAY_NO_EMP_CONT.get_le_status;
855:
856: hr_utility.trace('EMP_CONT ::: LE #### l_le_status = '|| l_le_status );

Line 853: FETCH PAY_NO_EMP_CONT.get_le_status INTO l_le_status;

849: ---------- initializing the g_tab_calc table for LE and -9999 combination
850: hr_utility.trace('EMP_CONT ::: LE #### initializing the g_tab_calc , entering');
851:
852: OPEN PAY_NO_EMP_CONT.get_le_status(p_tax_unit_id);
853: FETCH PAY_NO_EMP_CONT.get_le_status INTO l_le_status;
854: CLOSE PAY_NO_EMP_CONT.get_le_status;
855:
856: hr_utility.trace('EMP_CONT ::: LE #### l_le_status = '|| l_le_status );
857:

Line 854: CLOSE PAY_NO_EMP_CONT.get_le_status;

850: hr_utility.trace('EMP_CONT ::: LE #### initializing the g_tab_calc , entering');
851:
852: OPEN PAY_NO_EMP_CONT.get_le_status(p_tax_unit_id);
853: FETCH PAY_NO_EMP_CONT.get_le_status INTO l_le_status;
854: CLOSE PAY_NO_EMP_CONT.get_le_status;
855:
856: hr_utility.trace('EMP_CONT ::: LE #### l_le_status = '|| l_le_status );
857:
858: -- loop for each zone,under_62 commbination

Line 918: OPEN PAY_NO_EMP_CONT.csr_get_exemption_limit(p_tax_unit_id ,p_date_earned );

914: hr_utility.trace('EMP_CONT ::: LE #### l_bal_val_ytd = '|| l_bal_val_ytd );
915: hr_utility.trace('EMP_CONT ::: LE #### l_bal_val_bimonth = '|| l_bal_val_bimonth );
916: hr_utility.trace('EMP_CONT ::: LE #### l_exemption_limit_used_yet = '|| l_exemption_limit_used_yet );
917:
918: OPEN PAY_NO_EMP_CONT.csr_get_exemption_limit(p_tax_unit_id ,p_date_earned );
919: FETCH PAY_NO_EMP_CONT.csr_get_exemption_limit INTO l_exemption_limit ;
920: CLOSE PAY_NO_EMP_CONT.csr_get_exemption_limit;
921:
922: IF l_exemption_limit_used_yet >= l_exemption_limit

Line 919: FETCH PAY_NO_EMP_CONT.csr_get_exemption_limit INTO l_exemption_limit ;

915: hr_utility.trace('EMP_CONT ::: LE #### l_bal_val_bimonth = '|| l_bal_val_bimonth );
916: hr_utility.trace('EMP_CONT ::: LE #### l_exemption_limit_used_yet = '|| l_exemption_limit_used_yet );
917:
918: OPEN PAY_NO_EMP_CONT.csr_get_exemption_limit(p_tax_unit_id ,p_date_earned );
919: FETCH PAY_NO_EMP_CONT.csr_get_exemption_limit INTO l_exemption_limit ;
920: CLOSE PAY_NO_EMP_CONT.csr_get_exemption_limit;
921:
922: IF l_exemption_limit_used_yet >= l_exemption_limit
923: THEN

Line 920: CLOSE PAY_NO_EMP_CONT.csr_get_exemption_limit;

916: hr_utility.trace('EMP_CONT ::: LE #### l_exemption_limit_used_yet = '|| l_exemption_limit_used_yet );
917:
918: OPEN PAY_NO_EMP_CONT.csr_get_exemption_limit(p_tax_unit_id ,p_date_earned );
919: FETCH PAY_NO_EMP_CONT.csr_get_exemption_limit INTO l_exemption_limit ;
920: CLOSE PAY_NO_EMP_CONT.csr_get_exemption_limit;
921:
922: IF l_exemption_limit_used_yet >= l_exemption_limit
923: THEN
924: l_LE_over_limit := 'Y';

Line 1346: ,PAY_NO_EMP_CONT.g_tab_main

1342: -- ec_main_calculation function call for LE
1343: hr_utility.trace('EMP_CONT ::: LE #### ec_main_calculation function call for LE , entering ' );
1344:
1345: l_main_index := ec_main_calculation (g_tab_calc
1346: ,PAY_NO_EMP_CONT.g_tab_main
1347: ,p_tax_unit_id
1348: ,-9999
1349: ,l_exemption_limit_used
1350: ,l_le_status

Line 1369: p_run_base := PAY_NO_EMP_CONT.g_tab_main(l_main_index).run_base;

1365:
1366: -- done all caclculation and entered values in the main table for next time usage
1367:
1368: -- returning values at LE level
1369: p_run_base := PAY_NO_EMP_CONT.g_tab_main(l_main_index).run_base;
1370: p_run_contribution := PAY_NO_EMP_CONT.g_tab_main(l_main_index).run_contribution;
1371: p_curr_exemption_limit_used := PAY_NO_EMP_CONT.g_tab_main(l_main_index).exemption_limit_used;
1372:
1373: hr_utility.trace('EMP_CONT ::: LE #### l_main_index = '|| l_main_index );

Line 1370: p_run_contribution := PAY_NO_EMP_CONT.g_tab_main(l_main_index).run_contribution;

1366: -- done all caclculation and entered values in the main table for next time usage
1367:
1368: -- returning values at LE level
1369: p_run_base := PAY_NO_EMP_CONT.g_tab_main(l_main_index).run_base;
1370: p_run_contribution := PAY_NO_EMP_CONT.g_tab_main(l_main_index).run_contribution;
1371: p_curr_exemption_limit_used := PAY_NO_EMP_CONT.g_tab_main(l_main_index).exemption_limit_used;
1372:
1373: hr_utility.trace('EMP_CONT ::: LE #### l_main_index = '|| l_main_index );
1374: hr_utility.trace('EMP_CONT ::: LE #### p_run_base = '|| p_run_base );

Line 1371: p_curr_exemption_limit_used := PAY_NO_EMP_CONT.g_tab_main(l_main_index).exemption_limit_used;

1367:
1368: -- returning values at LE level
1369: p_run_base := PAY_NO_EMP_CONT.g_tab_main(l_main_index).run_base;
1370: p_run_contribution := PAY_NO_EMP_CONT.g_tab_main(l_main_index).run_contribution;
1371: p_curr_exemption_limit_used := PAY_NO_EMP_CONT.g_tab_main(l_main_index).exemption_limit_used;
1372:
1373: hr_utility.trace('EMP_CONT ::: LE #### l_main_index = '|| l_main_index );
1374: hr_utility.trace('EMP_CONT ::: LE #### p_run_base = '|| p_run_base );
1375: hr_utility.trace('EMP_CONT ::: LE #### p_run_contribution = '|| p_run_contribution );

Line 1434: ,g_lu_tab IN OUT NOCOPY PAY_NO_EMP_CONT.g_lu_tabtype

1430: FUNCTION populate_tables
1431: (p_tax_unit_id IN NUMBER
1432: ,p_payroll_id IN NUMBER
1433: ,p_date_earned IN DATE
1434: ,g_lu_tab IN OUT NOCOPY PAY_NO_EMP_CONT.g_lu_tabtype
1435: ,g_mu_tab IN OUT NOCOPY PAY_NO_EMP_CONT.g_mu_tabtype ) RETURN NUMBER IS
1436:
1437:
1438: /* Bug Fix: 5042861 - Added cursor csr_element_type */

Line 1435: ,g_mu_tab IN OUT NOCOPY PAY_NO_EMP_CONT.g_mu_tabtype ) RETURN NUMBER IS

1431: (p_tax_unit_id IN NUMBER
1432: ,p_payroll_id IN NUMBER
1433: ,p_date_earned IN DATE
1434: ,g_lu_tab IN OUT NOCOPY PAY_NO_EMP_CONT.g_lu_tabtype
1435: ,g_mu_tab IN OUT NOCOPY PAY_NO_EMP_CONT.g_mu_tabtype ) RETURN NUMBER IS
1436:
1437:
1438: /* Bug Fix: 5042861 - Added cursor csr_element_type */
1439: /* cursor to get the element_type_id of element 'Tax Deduction Base' */

Line 1476: FOR csr1_rec IN PAY_NO_EMP_CONT.csr_payroll_action_id (p_date_earned) LOOP

1472:
1473: ------------- testing the 3 cursor loops
1474:
1475: -- loop to get all payroll_action_id in the bimonth period for the current payroll
1476: FOR csr1_rec IN PAY_NO_EMP_CONT.csr_payroll_action_id (p_date_earned) LOOP
1477:
1478: -- loop to get assignment_id and assignment_action_id for all payroll_action_id obtained above for the current legal employer
1479: FOR csr2_rec IN PAY_NO_EMP_CONT.csr_assignment_id (p_tax_unit_id , csr1_rec.PAYROLL_ACTION_ID) LOOP
1480:

Line 1479: FOR csr2_rec IN PAY_NO_EMP_CONT.csr_assignment_id (p_tax_unit_id , csr1_rec.PAYROLL_ACTION_ID) LOOP

1475: -- loop to get all payroll_action_id in the bimonth period for the current payroll
1476: FOR csr1_rec IN PAY_NO_EMP_CONT.csr_payroll_action_id (p_date_earned) LOOP
1477:
1478: -- loop to get assignment_id and assignment_action_id for all payroll_action_id obtained above for the current legal employer
1479: FOR csr2_rec IN PAY_NO_EMP_CONT.csr_assignment_id (p_tax_unit_id , csr1_rec.PAYROLL_ACTION_ID) LOOP
1480:
1481: -- loop to get local unit and tax municipality for all assignment actions obtained above
1482: /* FOR csr3_rec IN PAY_NO_EMP_CONT.csr_lu_mu (csr2_rec.ASSIGNMENT_ID , csr2_rec.ASSIGNMENT_ACTION_ID , p_date_earned) LOOP
1483: */

Line 1482: /* FOR csr3_rec IN PAY_NO_EMP_CONT.csr_lu_mu (csr2_rec.ASSIGNMENT_ID , csr2_rec.ASSIGNMENT_ACTION_ID , p_date_earned) LOOP

1478: -- loop to get assignment_id and assignment_action_id for all payroll_action_id obtained above for the current legal employer
1479: FOR csr2_rec IN PAY_NO_EMP_CONT.csr_assignment_id (p_tax_unit_id , csr1_rec.PAYROLL_ACTION_ID) LOOP
1480:
1481: -- loop to get local unit and tax municipality for all assignment actions obtained above
1482: /* FOR csr3_rec IN PAY_NO_EMP_CONT.csr_lu_mu (csr2_rec.ASSIGNMENT_ID , csr2_rec.ASSIGNMENT_ACTION_ID , p_date_earned) LOOP
1483: */
1484:
1485: /* Bug Fix: 5042861 - Changed call of cursor PAY_NO_EMP_CONT.csr_lu_mu */
1486: FOR csr3_rec IN PAY_NO_EMP_CONT.csr_lu_mu (csr2_rec.ASSIGNMENT_ID , csr2_rec.ASSIGNMENT_ACTION_ID , p_date_earned , l_tax_dedn_base_ele_type_id ) LOOP

Line 1485: /* Bug Fix: 5042861 - Changed call of cursor PAY_NO_EMP_CONT.csr_lu_mu */

1481: -- loop to get local unit and tax municipality for all assignment actions obtained above
1482: /* FOR csr3_rec IN PAY_NO_EMP_CONT.csr_lu_mu (csr2_rec.ASSIGNMENT_ID , csr2_rec.ASSIGNMENT_ACTION_ID , p_date_earned) LOOP
1483: */
1484:
1485: /* Bug Fix: 5042861 - Changed call of cursor PAY_NO_EMP_CONT.csr_lu_mu */
1486: FOR csr3_rec IN PAY_NO_EMP_CONT.csr_lu_mu (csr2_rec.ASSIGNMENT_ID , csr2_rec.ASSIGNMENT_ACTION_ID , p_date_earned , l_tax_dedn_base_ele_type_id ) LOOP
1487:
1488: hr_utility.trace('EMP_CONT ::: --------------------------------------------------------');
1489:

Line 1486: FOR csr3_rec IN PAY_NO_EMP_CONT.csr_lu_mu (csr2_rec.ASSIGNMENT_ID , csr2_rec.ASSIGNMENT_ACTION_ID , p_date_earned , l_tax_dedn_base_ele_type_id ) LOOP

1482: /* FOR csr3_rec IN PAY_NO_EMP_CONT.csr_lu_mu (csr2_rec.ASSIGNMENT_ID , csr2_rec.ASSIGNMENT_ACTION_ID , p_date_earned) LOOP
1483: */
1484:
1485: /* Bug Fix: 5042861 - Changed call of cursor PAY_NO_EMP_CONT.csr_lu_mu */
1486: FOR csr3_rec IN PAY_NO_EMP_CONT.csr_lu_mu (csr2_rec.ASSIGNMENT_ID , csr2_rec.ASSIGNMENT_ACTION_ID , p_date_earned , l_tax_dedn_base_ele_type_id ) LOOP
1487:
1488: hr_utility.trace('EMP_CONT ::: --------------------------------------------------------');
1489:
1490: hr_utility.trace('EMP_CONT ::: PAY_ACT_ID = '||csr1_rec.PAYROLL_ACTION_ID||' ASS_ID = '||csr2_rec.ASSIGNMENT_ID||' ASS_ACT_ID = '||csr2_rec.ASSIGNMENT_ACTION_ID

Line 1519: OPEN PAY_NO_EMP_CONT.get_lu_details(csr3_rec.local_unit_id);

1515:
1516: ----------------------------- check for unique LU -------------------------------------------
1517:
1518: -- Get the Status and Report Separately for this particular Local Unit
1519: OPEN PAY_NO_EMP_CONT.get_lu_details(csr3_rec.local_unit_id);
1520: FETCH PAY_NO_EMP_CONT.get_lu_details INTO l_lu_status , l_lu_rep_sep ;
1521: CLOSE PAY_NO_EMP_CONT.get_lu_details;
1522:
1523: IF trim(l_lu_rep_sep) = 'N'

Line 1520: FETCH PAY_NO_EMP_CONT.get_lu_details INTO l_lu_status , l_lu_rep_sep ;

1516: ----------------------------- check for unique LU -------------------------------------------
1517:
1518: -- Get the Status and Report Separately for this particular Local Unit
1519: OPEN PAY_NO_EMP_CONT.get_lu_details(csr3_rec.local_unit_id);
1520: FETCH PAY_NO_EMP_CONT.get_lu_details INTO l_lu_status , l_lu_rep_sep ;
1521: CLOSE PAY_NO_EMP_CONT.get_lu_details;
1522:
1523: IF trim(l_lu_rep_sep) = 'N'
1524: THEN

Line 1521: CLOSE PAY_NO_EMP_CONT.get_lu_details;

1517:
1518: -- Get the Status and Report Separately for this particular Local Unit
1519: OPEN PAY_NO_EMP_CONT.get_lu_details(csr3_rec.local_unit_id);
1520: FETCH PAY_NO_EMP_CONT.get_lu_details INTO l_lu_status , l_lu_rep_sep ;
1521: CLOSE PAY_NO_EMP_CONT.get_lu_details;
1522:
1523: IF trim(l_lu_rep_sep) = 'N'
1524: THEN
1525:

Line 1670: (g_tab_calc IN PAY_NO_EMP_CONT.g_tab_calc_tabtype

1666:
1667: -- Function to look up the corresponding cell number in he table g_tab_calc
1668:
1669: FUNCTION lookup_cell
1670: (g_tab_calc IN PAY_NO_EMP_CONT.g_tab_calc_tabtype
1671: ,l_under_62 IN VARCHAR2
1672: ,l_zone IN NUMBER ) RETURN NUMBER IS
1673:
1674: l_cell NUMBER;

Line 1699: (g_tab_calc IN OUT NOCOPY PAY_NO_EMP_CONT.g_tab_calc_tabtype

1695: -- NEW function for main calculation
1696:
1697: FUNCTION ec_main_calculation
1698:
1699: (g_tab_calc IN OUT NOCOPY PAY_NO_EMP_CONT.g_tab_calc_tabtype
1700: ,g_tab_main IN OUT NOCOPY PAY_NO_EMP_CONT.g_tab_main_tabtype
1701: ,p_tax_unit_id IN NUMBER
1702: ,p_local_unit_id IN NUMBER
1703: ,p_exemption_limit_used IN NUMBER

Line 1700: ,g_tab_main IN OUT NOCOPY PAY_NO_EMP_CONT.g_tab_main_tabtype

1696:
1697: FUNCTION ec_main_calculation
1698:
1699: (g_tab_calc IN OUT NOCOPY PAY_NO_EMP_CONT.g_tab_calc_tabtype
1700: ,g_tab_main IN OUT NOCOPY PAY_NO_EMP_CONT.g_tab_main_tabtype
1701: ,p_tax_unit_id IN NUMBER
1702: ,p_local_unit_id IN NUMBER
1703: ,p_exemption_limit_used IN NUMBER
1704: ,p_org_status IN VARCHAR2

Line 2003: (g_tab_calc IN PAY_NO_EMP_CONT.g_tab_calc_tabtype ) RETURN NUMBER IS

1999:
2000: -- function to display table values of g_tab_calc
2001:
2002: FUNCTION display_table_calc
2003: (g_tab_calc IN PAY_NO_EMP_CONT.g_tab_calc_tabtype ) RETURN NUMBER IS
2004:
2005: start_index_calc NUMBER;
2006: end_index_calc NUMBER;
2007:

Line 2180: (g_tab_main IN PAY_NO_EMP_CONT.g_tab_main_tabtype

2176:
2177: -- Function to look up the corresponding cell number in he table g_tab_main
2178:
2179: FUNCTION main_lookup_cell
2180: (g_tab_main IN PAY_NO_EMP_CONT.g_tab_main_tabtype
2181: ,start_main_index IN NUMBER
2182: ,l_under_62 IN VARCHAR2
2183: ,l_zone IN NUMBER ) RETURN NUMBER IS
2184:

Line 2250: FOR csr_rec in PAY_NO_EMP_CONT.csr_get_lu_le (p_payroll_action_id ,p_date_earned ) LOOP

2246: hr_utility.trace('EXEM_LIM ::: made g_error_check := TRUE ');
2247:
2248: -- loop thru the cursor csr_get_lu_le and get all LE and LU
2249:
2250: FOR csr_rec in PAY_NO_EMP_CONT.csr_get_lu_le (p_payroll_action_id ,p_date_earned ) LOOP
2251:
2252: hr_utility.trace('EXEM_LIM ::: ------------------Inside For loop------------- ' );
2253: hr_utility.trace('EXEM_LIM ::: Local unit id = '||csr_rec.loc_unit ||' Legal Employer ID = '||csr_rec.leg_emp );
2254: -- get the status and report separately for the LU

Line 2256: OPEN PAY_NO_EMP_CONT.get_lu_details (csr_rec.loc_unit);

2252: hr_utility.trace('EXEM_LIM ::: ------------------Inside For loop------------- ' );
2253: hr_utility.trace('EXEM_LIM ::: Local unit id = '||csr_rec.loc_unit ||' Legal Employer ID = '||csr_rec.leg_emp );
2254: -- get the status and report separately for the LU
2255:
2256: OPEN PAY_NO_EMP_CONT.get_lu_details (csr_rec.loc_unit);
2257: FETCH PAY_NO_EMP_CONT.get_lu_details INTO l_status , l_rep_sep ;
2258: CLOSE PAY_NO_EMP_CONT.get_lu_details ;
2259:
2260: hr_utility.trace('EXEM_LIM ::: l_status '|| l_status );

Line 2257: FETCH PAY_NO_EMP_CONT.get_lu_details INTO l_status , l_rep_sep ;

2253: hr_utility.trace('EXEM_LIM ::: Local unit id = '||csr_rec.loc_unit ||' Legal Employer ID = '||csr_rec.leg_emp );
2254: -- get the status and report separately for the LU
2255:
2256: OPEN PAY_NO_EMP_CONT.get_lu_details (csr_rec.loc_unit);
2257: FETCH PAY_NO_EMP_CONT.get_lu_details INTO l_status , l_rep_sep ;
2258: CLOSE PAY_NO_EMP_CONT.get_lu_details ;
2259:
2260: hr_utility.trace('EXEM_LIM ::: l_status '|| l_status );
2261: hr_utility.trace('EXEM_LIM ::: l_rep_sep '||l_rep_sep );

Line 2258: CLOSE PAY_NO_EMP_CONT.get_lu_details ;

2254: -- get the status and report separately for the LU
2255:
2256: OPEN PAY_NO_EMP_CONT.get_lu_details (csr_rec.loc_unit);
2257: FETCH PAY_NO_EMP_CONT.get_lu_details INTO l_status , l_rep_sep ;
2258: CLOSE PAY_NO_EMP_CONT.get_lu_details ;
2259:
2260: hr_utility.trace('EXEM_LIM ::: l_status '|| l_status );
2261: hr_utility.trace('EXEM_LIM ::: l_rep_sep '||l_rep_sep );
2262:

Line 2269: OPEN PAY_NO_EMP_CONT.csr_get_exemption_limit (csr_rec.loc_unit, p_date_earned) ;

2265:
2266: THEN
2267: hr_utility.trace('EXEM_LIM ::: local unit is rep sep and status in OF , HF....fetching exemption limit ');
2268: -- then open exemption limit cursor
2269: OPEN PAY_NO_EMP_CONT.csr_get_exemption_limit (csr_rec.loc_unit, p_date_earned) ;
2270: FETCH PAY_NO_EMP_CONT.csr_get_exemption_limit INTO l_exempt_limit ;
2271:
2272: -- if any error is there
2273: -- checking if no data returned for Exemption Limit

Line 2270: FETCH PAY_NO_EMP_CONT.csr_get_exemption_limit INTO l_exempt_limit ;

2266: THEN
2267: hr_utility.trace('EXEM_LIM ::: local unit is rep sep and status in OF , HF....fetching exemption limit ');
2268: -- then open exemption limit cursor
2269: OPEN PAY_NO_EMP_CONT.csr_get_exemption_limit (csr_rec.loc_unit, p_date_earned) ;
2270: FETCH PAY_NO_EMP_CONT.csr_get_exemption_limit INTO l_exempt_limit ;
2271:
2272: -- if any error is there
2273: -- checking if no data returned for Exemption Limit
2274: IF (PAY_NO_EMP_CONT.csr_get_exemption_limit%NOTFOUND OR l_exempt_limit IS NULL)

Line 2274: IF (PAY_NO_EMP_CONT.csr_get_exemption_limit%NOTFOUND OR l_exempt_limit IS NULL)

2270: FETCH PAY_NO_EMP_CONT.csr_get_exemption_limit INTO l_exempt_limit ;
2271:
2272: -- if any error is there
2273: -- checking if no data returned for Exemption Limit
2274: IF (PAY_NO_EMP_CONT.csr_get_exemption_limit%NOTFOUND OR l_exempt_limit IS NULL)
2275: THEN
2276: hr_utility.trace('EXEM_LIM ::: Problem in getting Exemption limit ' );
2277: -- Exemption Limit for this Local Unit Not Specified for this Period or not specified at all
2278:

Line 2284: OPEN PAY_NO_EMP_CONT.csr_org_name(csr_rec.loc_unit ,p_bus_grp_id );

2280: g_error_flag := TRUE ;
2281: hr_utility.trace('EXEM_LIM ::: set g_error_flag = TRUE ');
2282:
2283: -- get the name of the local unit
2284: OPEN PAY_NO_EMP_CONT.csr_org_name(csr_rec.loc_unit ,p_bus_grp_id );
2285: FETCH PAY_NO_EMP_CONT.csr_org_name INTO l_org_name ;
2286: CLOSE PAY_NO_EMP_CONT.csr_org_name;
2287:
2288: hr_utility.trace('EXEM_LIM ::: name of local unit = '|| l_org_name );

Line 2285: FETCH PAY_NO_EMP_CONT.csr_org_name INTO l_org_name ;

2281: hr_utility.trace('EXEM_LIM ::: set g_error_flag = TRUE ');
2282:
2283: -- get the name of the local unit
2284: OPEN PAY_NO_EMP_CONT.csr_org_name(csr_rec.loc_unit ,p_bus_grp_id );
2285: FETCH PAY_NO_EMP_CONT.csr_org_name INTO l_org_name ;
2286: CLOSE PAY_NO_EMP_CONT.csr_org_name;
2287:
2288: hr_utility.trace('EXEM_LIM ::: name of local unit = '|| l_org_name );
2289:

Line 2286: CLOSE PAY_NO_EMP_CONT.csr_org_name;

2282:
2283: -- get the name of the local unit
2284: OPEN PAY_NO_EMP_CONT.csr_org_name(csr_rec.loc_unit ,p_bus_grp_id );
2285: FETCH PAY_NO_EMP_CONT.csr_org_name INTO l_org_name ;
2286: CLOSE PAY_NO_EMP_CONT.csr_org_name;
2287:
2288: hr_utility.trace('EXEM_LIM ::: name of local unit = '|| l_org_name );
2289:
2290: -- Set the message and message token

Line 2305: CLOSE PAY_NO_EMP_CONT.csr_get_exemption_limit;

2301: -- p_err_text := p_err_text || hr_utility.get_message ;
2302:
2303: END IF; -- end exemption limit got check
2304:
2305: CLOSE PAY_NO_EMP_CONT.csr_get_exemption_limit;
2306:
2307: ELSIF ( trim(l_rep_sep) = 'N' ) -- else if LU is not rep sep , check at the legal employer level
2308:
2309: THEN

Line 2312: OPEN PAY_NO_EMP_CONT.get_le_status (csr_rec.leg_emp) ;

2308:
2309: THEN
2310: hr_utility.trace('EXEM_LIM ::: local unit is NOT rep sep....fetching LE Status ');
2311: -- get the status of the LE
2312: OPEN PAY_NO_EMP_CONT.get_le_status (csr_rec.leg_emp) ;
2313: FETCH PAY_NO_EMP_CONT.get_le_status INTO l_status ;
2314: CLOSE PAY_NO_EMP_CONT.get_le_status ;
2315:
2316: hr_utility.trace('EXEM_LIM ::: LE l_status '|| l_status );

Line 2313: FETCH PAY_NO_EMP_CONT.get_le_status INTO l_status ;

2309: THEN
2310: hr_utility.trace('EXEM_LIM ::: local unit is NOT rep sep....fetching LE Status ');
2311: -- get the status of the LE
2312: OPEN PAY_NO_EMP_CONT.get_le_status (csr_rec.leg_emp) ;
2313: FETCH PAY_NO_EMP_CONT.get_le_status INTO l_status ;
2314: CLOSE PAY_NO_EMP_CONT.get_le_status ;
2315:
2316: hr_utility.trace('EXEM_LIM ::: LE l_status '|| l_status );
2317:

Line 2314: CLOSE PAY_NO_EMP_CONT.get_le_status ;

2310: hr_utility.trace('EXEM_LIM ::: local unit is NOT rep sep....fetching LE Status ');
2311: -- get the status of the LE
2312: OPEN PAY_NO_EMP_CONT.get_le_status (csr_rec.leg_emp) ;
2313: FETCH PAY_NO_EMP_CONT.get_le_status INTO l_status ;
2314: CLOSE PAY_NO_EMP_CONT.get_le_status ;
2315:
2316: hr_utility.trace('EXEM_LIM ::: LE l_status '|| l_status );
2317:
2318: -- if the status of LE in OF,HF

Line 2323: OPEN PAY_NO_EMP_CONT.csr_get_exemption_limit (csr_rec.leg_emp, p_date_earned) ;

2319: IF ( l_status IN ('OF','HF') )
2320: THEN
2321: hr_utility.trace('EXEM_LIM ::: Legal Emp status in OF , HF....fetching exemption limit ');
2322: -- then open exemption limit cursor
2323: OPEN PAY_NO_EMP_CONT.csr_get_exemption_limit (csr_rec.leg_emp, p_date_earned) ;
2324: FETCH PAY_NO_EMP_CONT.csr_get_exemption_limit INTO l_exempt_limit ;
2325:
2326: -- if any error is there
2327: -- checking if no data returned for Exemption Limit

Line 2324: FETCH PAY_NO_EMP_CONT.csr_get_exemption_limit INTO l_exempt_limit ;

2320: THEN
2321: hr_utility.trace('EXEM_LIM ::: Legal Emp status in OF , HF....fetching exemption limit ');
2322: -- then open exemption limit cursor
2323: OPEN PAY_NO_EMP_CONT.csr_get_exemption_limit (csr_rec.leg_emp, p_date_earned) ;
2324: FETCH PAY_NO_EMP_CONT.csr_get_exemption_limit INTO l_exempt_limit ;
2325:
2326: -- if any error is there
2327: -- checking if no data returned for Exemption Limit
2328: IF (PAY_NO_EMP_CONT.csr_get_exemption_limit%NOTFOUND OR l_exempt_limit IS NULL)

Line 2328: IF (PAY_NO_EMP_CONT.csr_get_exemption_limit%NOTFOUND OR l_exempt_limit IS NULL)

2324: FETCH PAY_NO_EMP_CONT.csr_get_exemption_limit INTO l_exempt_limit ;
2325:
2326: -- if any error is there
2327: -- checking if no data returned for Exemption Limit
2328: IF (PAY_NO_EMP_CONT.csr_get_exemption_limit%NOTFOUND OR l_exempt_limit IS NULL)
2329: THEN
2330: hr_utility.trace('EXEM_LIM ::: Problem in getting Exemption limit ' );
2331: -- Exemption Limit for this Legal Emplyer Not Specified for this Period or not specified at all
2332:

Line 2338: OPEN PAY_NO_EMP_CONT.csr_org_name(csr_rec.leg_emp ,p_bus_grp_id );

2334: g_error_flag := TRUE ;
2335: hr_utility.trace('EXEM_LIM ::: set g_error_flag = TRUE ');
2336:
2337: -- get the name of the Legal Employer
2338: OPEN PAY_NO_EMP_CONT.csr_org_name(csr_rec.leg_emp ,p_bus_grp_id );
2339: FETCH PAY_NO_EMP_CONT.csr_org_name INTO l_org_name ;
2340: CLOSE PAY_NO_EMP_CONT.csr_org_name;
2341:
2342: hr_utility.trace('EXEM_LIM ::: name of legal employer = '|| l_org_name );

Line 2339: FETCH PAY_NO_EMP_CONT.csr_org_name INTO l_org_name ;

2335: hr_utility.trace('EXEM_LIM ::: set g_error_flag = TRUE ');
2336:
2337: -- get the name of the Legal Employer
2338: OPEN PAY_NO_EMP_CONT.csr_org_name(csr_rec.leg_emp ,p_bus_grp_id );
2339: FETCH PAY_NO_EMP_CONT.csr_org_name INTO l_org_name ;
2340: CLOSE PAY_NO_EMP_CONT.csr_org_name;
2341:
2342: hr_utility.trace('EXEM_LIM ::: name of legal employer = '|| l_org_name );
2343:

Line 2340: CLOSE PAY_NO_EMP_CONT.csr_org_name;

2336:
2337: -- get the name of the Legal Employer
2338: OPEN PAY_NO_EMP_CONT.csr_org_name(csr_rec.leg_emp ,p_bus_grp_id );
2339: FETCH PAY_NO_EMP_CONT.csr_org_name INTO l_org_name ;
2340: CLOSE PAY_NO_EMP_CONT.csr_org_name;
2341:
2342: hr_utility.trace('EXEM_LIM ::: name of legal employer = '|| l_org_name );
2343:
2344: -- Set the message and message token

Line 2357: CLOSE PAY_NO_EMP_CONT.csr_get_exemption_limit;

2353: -- p_err_text := p_err_text || hr_utility.get_message ;
2354:
2355: END IF; -- end exemption limit got check
2356:
2357: CLOSE PAY_NO_EMP_CONT.csr_get_exemption_limit;
2358:
2359: END IF; -- end if the status of LE in OF,HF
2360:
2361: END IF ; -- end if report separately = yes and status in OF,HF

Line 2409: OPEN pay_no_emp_cont.get_lu_details(p_local_unit_id);

2405: l_curr_under_62 VARCHAR2(10);
2406:
2407: BEGIN
2408:
2409: OPEN pay_no_emp_cont.get_lu_details(p_local_unit_id);
2410: FETCH pay_no_emp_cont.get_lu_details
2411: INTO l_lu_status,
2412: l_lu_rep_sep;
2413: CLOSE pay_no_emp_cont.get_lu_details;

Line 2410: FETCH pay_no_emp_cont.get_lu_details

2406:
2407: BEGIN
2408:
2409: OPEN pay_no_emp_cont.get_lu_details(p_local_unit_id);
2410: FETCH pay_no_emp_cont.get_lu_details
2411: INTO l_lu_status,
2412: l_lu_rep_sep;
2413: CLOSE pay_no_emp_cont.get_lu_details;
2414:

Line 2413: CLOSE pay_no_emp_cont.get_lu_details;

2409: OPEN pay_no_emp_cont.get_lu_details(p_local_unit_id);
2410: FETCH pay_no_emp_cont.get_lu_details
2411: INTO l_lu_status,
2412: l_lu_rep_sep;
2413: CLOSE pay_no_emp_cont.get_lu_details;
2414:
2415: IF(l_lu_rep_sep = 'Y') THEN
2416: l_org_status := l_lu_status; -- if report sepeartely is yes then assigning the lu status
2417: ELSE

Line 2419: OPEN pay_no_emp_cont.get_le_status(p_tax_unit_id);

2415: IF(l_lu_rep_sep = 'Y') THEN
2416: l_org_status := l_lu_status; -- if report sepeartely is yes then assigning the lu status
2417: ELSE
2418:
2419: OPEN pay_no_emp_cont.get_le_status(p_tax_unit_id);
2420: FETCH pay_no_emp_cont.get_le_status
2421: INTO l_le_status;
2422: CLOSE pay_no_emp_cont.get_le_status;
2423:

Line 2420: FETCH pay_no_emp_cont.get_le_status

2416: l_org_status := l_lu_status; -- if report sepeartely is yes then assigning the lu status
2417: ELSE
2418:
2419: OPEN pay_no_emp_cont.get_le_status(p_tax_unit_id);
2420: FETCH pay_no_emp_cont.get_le_status
2421: INTO l_le_status;
2422: CLOSE pay_no_emp_cont.get_le_status;
2423:
2424: l_org_status := l_le_status; -- assigning the le status

Line 2422: CLOSE pay_no_emp_cont.get_le_status;

2418:
2419: OPEN pay_no_emp_cont.get_le_status(p_tax_unit_id);
2420: FETCH pay_no_emp_cont.get_le_status
2421: INTO l_le_status;
2422: CLOSE pay_no_emp_cont.get_le_status;
2423:
2424: l_org_status := l_le_status; -- assigning the le status
2425: END IF;
2426:

Line 2427: -- l_curr_zone := to_number(SUBSTR(pay_no_emp_cont.get_lookup_meaning('NO_TAX_MUNICIPALITY', p_jurisdiction_code), 1, 1));

2423:
2424: l_org_status := l_le_status; -- assigning the le status
2425: END IF;
2426:
2427: -- l_curr_zone := to_number(SUBSTR(pay_no_emp_cont.get_lookup_meaning('NO_TAX_MUNICIPALITY', p_jurisdiction_code), 1, 1));
2428: -- Tax Municipality for Norway has been moved to User Table NO_TAX_MUNICIPALITY
2429: -- The zone for a Tax Municipality will now be fetched from the user table
2430: l_curr_zone := fnd_number.canonical_to_number(hruserdt.get_table_value (p_bus_group_id, 'NO_TAX_MUNICIPALITY' , 'ZONE', p_jurisdiction_code, p_date_earned )) ;
2431:

Line 2432: l_curr_under_62 := pay_no_emp_cont.check_under_62(p_asg_act_id, p_date_earned);

2428: -- Tax Municipality for Norway has been moved to User Table NO_TAX_MUNICIPALITY
2429: -- The zone for a Tax Municipality will now be fetched from the user table
2430: l_curr_zone := fnd_number.canonical_to_number(hruserdt.get_table_value (p_bus_group_id, 'NO_TAX_MUNICIPALITY' , 'ZONE', p_jurisdiction_code, p_date_earned )) ;
2431:
2432: l_curr_under_62 := pay_no_emp_cont.check_under_62(p_asg_act_id, p_date_earned);
2433:
2434: l_ec_rate := pay_no_emp_cont.get_ec_rate(l_curr_under_62, l_curr_zone, p_under_limit, l_org_status, p_bus_group_id, p_date_earned, p_under_age_high_rate, p_over_age_high_rate);
2435:
2436: RETURN l_ec_rate;

Line 2434: l_ec_rate := pay_no_emp_cont.get_ec_rate(l_curr_under_62, l_curr_zone, p_under_limit, l_org_status, p_bus_group_id, p_date_earned, p_under_age_high_rate, p_over_age_high_rate);

2430: l_curr_zone := fnd_number.canonical_to_number(hruserdt.get_table_value (p_bus_group_id, 'NO_TAX_MUNICIPALITY' , 'ZONE', p_jurisdiction_code, p_date_earned )) ;
2431:
2432: l_curr_under_62 := pay_no_emp_cont.check_under_62(p_asg_act_id, p_date_earned);
2433:
2434: l_ec_rate := pay_no_emp_cont.get_ec_rate(l_curr_under_62, l_curr_zone, p_under_limit, l_org_status, p_bus_group_id, p_date_earned, p_under_age_high_rate, p_over_age_high_rate);
2435:
2436: RETURN l_ec_rate;
2437: END get_emp_contr_rate;
2438:

Line 2444: END PAY_NO_EMP_CONT;

2440:
2441:
2442: ---------------------------- end of package ---------------------------------------------------------------------------------------
2443:
2444: END PAY_NO_EMP_CONT;