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_2007 dependencies on PAY_BALANCE_PKG

Line 300: pay_balance_pkg.set_context('LOCAL_UNIT_ID',p_local_unit_id);

296: ------------------ get exemption limit used for LU
297: hr_utility.trace('2007 EMP_CONT ::: LU ***** get exemption limit ');
298:
299: -- set the context values for balance
300: pay_balance_pkg.set_context('LOCAL_UNIT_ID',p_local_unit_id);
301:
302: -- get defined balance ids
303: l_def_bal_id_1 := get_defined_balance_id('Employer Contribution Exemption Limit Used','_TU_LU_YTD') ;
304: l_def_bal_id_2 := get_defined_balance_id('Employer Contribution Exemption Limit Used','_TU_LU_BIMONTH') ;

Line 310: l_bal_val_ytd := pay_balance_pkg.get_value(l_def_bal_id_1,p_asg_act_id,p_tax_unit_id,p_jurisdiction_code,NULL,NULL,NULL,l_bimonth_end_date);

306: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_def_bal_id_1 = '|| l_def_bal_id_1 );
307: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_def_bal_id_2 = '|| l_def_bal_id_2 );
308:
309: -- get the balance value
310: l_bal_val_ytd := pay_balance_pkg.get_value(l_def_bal_id_1,p_asg_act_id,p_tax_unit_id,p_jurisdiction_code,NULL,NULL,NULL,l_bimonth_end_date);
311: l_bal_val_bimonth := pay_balance_pkg.get_value(l_def_bal_id_2,p_asg_act_id,p_tax_unit_id,p_jurisdiction_code,NULL,NULL,NULL,l_bimonth_end_date);
312:
313: l_exemption_limit_used_yet := l_bal_val_ytd - l_bal_val_bimonth ;
314:

Line 311: l_bal_val_bimonth := pay_balance_pkg.get_value(l_def_bal_id_2,p_asg_act_id,p_tax_unit_id,p_jurisdiction_code,NULL,NULL,NULL,l_bimonth_end_date);

307: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_def_bal_id_2 = '|| l_def_bal_id_2 );
308:
309: -- get the balance value
310: l_bal_val_ytd := pay_balance_pkg.get_value(l_def_bal_id_1,p_asg_act_id,p_tax_unit_id,p_jurisdiction_code,NULL,NULL,NULL,l_bimonth_end_date);
311: l_bal_val_bimonth := pay_balance_pkg.get_value(l_def_bal_id_2,p_asg_act_id,p_tax_unit_id,p_jurisdiction_code,NULL,NULL,NULL,l_bimonth_end_date);
312:
313: l_exemption_limit_used_yet := l_bal_val_ytd - l_bal_val_bimonth ;
314:
315: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_bal_val_ytd = '|| l_bal_val_ytd );

Line 383: pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);

379: -- remove till here
380:
381: hr_utility.trace('2007 EMP_CONT ::: LU ***** level 0 leave' );
382:
383: pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);
384: pay_balance_pkg.set_context('LOCAL_UNIT_ID',p_local_unit_id);
385:
386: -----
387:

Line 384: pay_balance_pkg.set_context('LOCAL_UNIT_ID',p_local_unit_id);

380:
381: hr_utility.trace('2007 EMP_CONT ::: LU ***** level 0 leave' );
382:
383: pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);
384: pay_balance_pkg.set_context('LOCAL_UNIT_ID',p_local_unit_id);
385:
386: -----
387:
388: -- loop to get all assignment_action_id in the current payroll_action_id

Line 401: pay_balance_pkg.set_context('JURISDICTION_CODE',g_mu_tab(start_index_mu));

397:
398: hr_utility.trace('2007 EMP_CONT ::: LU ***** level 2, g_mu_tab ' );
399: hr_utility.trace('2007 EMP_CONT ::: LU ***** ASS_ACT_ID = '|| csr1_rec.ASSIGNMENT_ACTION_ID || ' MU = '|| g_mu_tab(start_index_mu)|| ' LU = '|| p_local_unit_id );
400:
401: pay_balance_pkg.set_context('JURISDICTION_CODE',g_mu_tab(start_index_mu));
402:
403: -- get the balance value
404: l_asg_ers_base := pay_balance_pkg.get_value(l_def_bal_id_1,csr1_rec.ASSIGNMENT_ACTION_ID);
405: l_asg_ers_base2 := pay_balance_pkg.get_value(l_def_bal_id_2,csr1_rec.ASSIGNMENT_ACTION_ID);

Line 404: l_asg_ers_base := pay_balance_pkg.get_value(l_def_bal_id_1,csr1_rec.ASSIGNMENT_ACTION_ID);

400:
401: pay_balance_pkg.set_context('JURISDICTION_CODE',g_mu_tab(start_index_mu));
402:
403: -- get the balance value
404: l_asg_ers_base := pay_balance_pkg.get_value(l_def_bal_id_1,csr1_rec.ASSIGNMENT_ACTION_ID);
405: l_asg_ers_base2 := pay_balance_pkg.get_value(l_def_bal_id_2,csr1_rec.ASSIGNMENT_ACTION_ID);
406: l_asg_ers_base_diff := l_asg_ers_base - l_asg_ers_base2;
407:
408:

Line 405: l_asg_ers_base2 := pay_balance_pkg.get_value(l_def_bal_id_2,csr1_rec.ASSIGNMENT_ACTION_ID);

401: pay_balance_pkg.set_context('JURISDICTION_CODE',g_mu_tab(start_index_mu));
402:
403: -- get the balance value
404: l_asg_ers_base := pay_balance_pkg.get_value(l_def_bal_id_1,csr1_rec.ASSIGNMENT_ACTION_ID);
405: l_asg_ers_base2 := pay_balance_pkg.get_value(l_def_bal_id_2,csr1_rec.ASSIGNMENT_ACTION_ID);
406: l_asg_ers_base_diff := l_asg_ers_base - l_asg_ers_base2;
407:
408:
409: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_asg_ers_base = '|| l_asg_ers_base );

Line 464: pay_balance_pkg.set_context('LOCAL_UNIT_ID',p_local_unit_id);

460: end_index_mu := NVL (g_mu_tab.LAST, 0) ;
461:
462: hr_utility.trace('2007 EMP_CONT ::: LU ***** level 0 leave ' );
463:
464: pay_balance_pkg.set_context('LOCAL_UNIT_ID',p_local_unit_id);
465:
466:
467: WHILE (g_mu_tab.EXISTS(start_index_mu)) and (start_index_mu <= end_index_mu) LOOP
468:

Line 471: pay_balance_pkg.set_context('JURISDICTION_CODE',g_mu_tab(start_index_mu));

467: WHILE (g_mu_tab.EXISTS(start_index_mu)) and (start_index_mu <= end_index_mu) LOOP
468:
469: hr_utility.trace('2007 EMP_CONT ::: LU ***** level 1 ,g_mu_tab ' );
470:
471: pay_balance_pkg.set_context('JURISDICTION_CODE',g_mu_tab(start_index_mu));
472:
473: hr_utility.trace('2007 EMP_CONT ::: LU ***** MU = '|| g_mu_tab(start_index_mu)|| ' LU = '|| p_local_unit_id );
474:
475: -- get the balance value

Line 476: l_lu_ers_base := pay_balance_pkg.get_value(l_def_bal_id_1,p_asg_act_id,p_tax_unit_id,g_mu_tab(start_index_mu),NULL,NULL,NULL,l_bimonth_end_date);

472:
473: hr_utility.trace('2007 EMP_CONT ::: LU ***** MU = '|| g_mu_tab(start_index_mu)|| ' LU = '|| p_local_unit_id );
474:
475: -- get the balance value
476: l_lu_ers_base := pay_balance_pkg.get_value(l_def_bal_id_1,p_asg_act_id,p_tax_unit_id,g_mu_tab(start_index_mu),NULL,NULL,NULL,l_bimonth_end_date);
477: l_lu_ers := pay_balance_pkg.get_value(l_def_bal_id_2,p_asg_act_id,p_tax_unit_id,g_mu_tab(start_index_mu),NULL,NULL,NULL,l_bimonth_end_date);
478:
479: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_lu_ers_base = '|| l_lu_ers_base);
480: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_lu_ers = '||l_lu_ers );

Line 477: l_lu_ers := pay_balance_pkg.get_value(l_def_bal_id_2,p_asg_act_id,p_tax_unit_id,g_mu_tab(start_index_mu),NULL,NULL,NULL,l_bimonth_end_date);

473: hr_utility.trace('2007 EMP_CONT ::: LU ***** MU = '|| g_mu_tab(start_index_mu)|| ' LU = '|| p_local_unit_id );
474:
475: -- get the balance value
476: l_lu_ers_base := pay_balance_pkg.get_value(l_def_bal_id_1,p_asg_act_id,p_tax_unit_id,g_mu_tab(start_index_mu),NULL,NULL,NULL,l_bimonth_end_date);
477: l_lu_ers := pay_balance_pkg.get_value(l_def_bal_id_2,p_asg_act_id,p_tax_unit_id,g_mu_tab(start_index_mu),NULL,NULL,NULL,l_bimonth_end_date);
478:
479: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_lu_ers_base = '|| l_lu_ers_base);
480: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_lu_ers = '||l_lu_ers );
481:

Line 811: pay_balance_pkg.set_context('LOCAL_UNIT_ID',p_local_unit_id);

807: hr_utility.trace('2007 EMP_CONT ::: LE #### get exemption limit used for LE , entering');
808:
809: -- set the context values for balance
810:
811: pay_balance_pkg.set_context('LOCAL_UNIT_ID',p_local_unit_id);
812:
813: -- get defined balance ids
814: l_def_bal_id_1 := get_defined_balance_id('Employer Contribution Exemption Limit Used','_TU_LU_YTD') ;
815: l_def_bal_id_2 := get_defined_balance_id('Employer Contribution Exemption Limit Used','_TU_LU_BIMONTH') ;

Line 821: l_bal_val_ytd := pay_balance_pkg.get_value(l_def_bal_id_1,p_asg_act_id,p_tax_unit_id,p_jurisdiction_code,NULL,NULL,NULL,l_bimonth_end_date);

817: hr_utility.trace('2007 EMP_CONT ::: LE #### l_def_bal_id_1 = '|| l_def_bal_id_1 );
818: hr_utility.trace('2007 EMP_CONT ::: LE #### l_def_bal_id_2 = '|| l_def_bal_id_2 );
819:
820: -- get the balance value
821: l_bal_val_ytd := pay_balance_pkg.get_value(l_def_bal_id_1,p_asg_act_id,p_tax_unit_id,p_jurisdiction_code,NULL,NULL,NULL,l_bimonth_end_date);
822: l_bal_val_bimonth := pay_balance_pkg.get_value(l_def_bal_id_2,p_asg_act_id,p_tax_unit_id,p_jurisdiction_code,NULL,NULL,NULL,l_bimonth_end_date);
823:
824: --l_bal_val_ytd := 0 ;
825: --l_bal_val_bimonth := 0 ;

Line 822: l_bal_val_bimonth := pay_balance_pkg.get_value(l_def_bal_id_2,p_asg_act_id,p_tax_unit_id,p_jurisdiction_code,NULL,NULL,NULL,l_bimonth_end_date);

818: hr_utility.trace('2007 EMP_CONT ::: LE #### l_def_bal_id_2 = '|| l_def_bal_id_2 );
819:
820: -- get the balance value
821: l_bal_val_ytd := pay_balance_pkg.get_value(l_def_bal_id_1,p_asg_act_id,p_tax_unit_id,p_jurisdiction_code,NULL,NULL,NULL,l_bimonth_end_date);
822: l_bal_val_bimonth := pay_balance_pkg.get_value(l_def_bal_id_2,p_asg_act_id,p_tax_unit_id,p_jurisdiction_code,NULL,NULL,NULL,l_bimonth_end_date);
823:
824: --l_bal_val_ytd := 0 ;
825: --l_bal_val_bimonth := 0 ;
826:

Line 895: pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);

891:
892: hr_utility.trace('2007 EMP_CONT ::: LE #### level 0 leave' );
893:
894: -- change 2b -1
895: pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);
896: ----
897:
898: -- loop to get all assignment_action_id in the current payroll_action_id
899: FOR csr1_rec IN csr_curr_le_asg_act_id (p_tax_unit_id , p_payroll_action_id, p_date_earned) LOOP

Line 914: pay_balance_pkg.set_context('LOCAL_UNIT_ID',g_lu_tab(start_index_lu));

910: start_index_mu := NVL (g_mu_tab.FIRST, 0) ;
911: end_index_mu := NVL (g_mu_tab.LAST, 0) ;
912:
913: -- Change 2b - 2
914: pay_balance_pkg.set_context('LOCAL_UNIT_ID',g_lu_tab(start_index_lu));
915: -----
916:
917: WHILE (g_mu_tab.EXISTS(start_index_mu)) and (start_index_mu <= end_index_mu) LOOP
918:

Line 923: pay_balance_pkg.set_context('JURISDICTION_CODE',g_mu_tab(start_index_mu));

919: hr_utility.trace('2007 EMP_CONT ::: LE #### level 3, g_mu_tab ' );
920: hr_utility.trace('2007 EMP_CONT ::: LE #### ASS_ACT_ID = '|| csr1_rec.ASSIGNMENT_ACTION_ID || ' MU = '|| g_mu_tab(start_index_mu)|| ' LU = '|| g_lu_tab(start_index_lu) );
921:
922: --setting the context values
923: pay_balance_pkg.set_context('JURISDICTION_CODE',g_mu_tab(start_index_mu));
924:
925: -- get the balance value
926: l_asg_ers_base := pay_balance_pkg.get_value(l_def_bal_id_1,csr1_rec.ASSIGNMENT_ACTION_ID);
927: l_asg_ers_base2 := pay_balance_pkg.get_value(l_def_bal_id_2,csr1_rec.ASSIGNMENT_ACTION_ID);

Line 926: l_asg_ers_base := pay_balance_pkg.get_value(l_def_bal_id_1,csr1_rec.ASSIGNMENT_ACTION_ID);

922: --setting the context values
923: pay_balance_pkg.set_context('JURISDICTION_CODE',g_mu_tab(start_index_mu));
924:
925: -- get the balance value
926: l_asg_ers_base := pay_balance_pkg.get_value(l_def_bal_id_1,csr1_rec.ASSIGNMENT_ACTION_ID);
927: l_asg_ers_base2 := pay_balance_pkg.get_value(l_def_bal_id_2,csr1_rec.ASSIGNMENT_ACTION_ID);
928: l_asg_ers_base_diff := l_asg_ers_base - l_asg_ers_base2;
929:
930: hr_utility.trace('2007 EMP_CONT ::: LE #### l_asg_ers_base = '|| l_asg_ers_base );

Line 927: l_asg_ers_base2 := pay_balance_pkg.get_value(l_def_bal_id_2,csr1_rec.ASSIGNMENT_ACTION_ID);

923: pay_balance_pkg.set_context('JURISDICTION_CODE',g_mu_tab(start_index_mu));
924:
925: -- get the balance value
926: l_asg_ers_base := pay_balance_pkg.get_value(l_def_bal_id_1,csr1_rec.ASSIGNMENT_ACTION_ID);
927: l_asg_ers_base2 := pay_balance_pkg.get_value(l_def_bal_id_2,csr1_rec.ASSIGNMENT_ACTION_ID);
928: l_asg_ers_base_diff := l_asg_ers_base - l_asg_ers_base2;
929:
930: hr_utility.trace('2007 EMP_CONT ::: LE #### l_asg_ers_base = '|| l_asg_ers_base );
931: hr_utility.trace('2007 EMP_CONT ::: LE #### l_asg_ers_base2 = '|| l_asg_ers_base2 );

Line 987: --pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);

983:
984: hr_utility.trace('2007 EMP_CONT ::: LE #### level 0 leave ' );
985:
986: -- change 3b -1
987: --pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);
988: ----
989:
990: WHILE (g_lu_tab.EXISTS(start_index_lu)) and (start_index_lu <= end_index_lu) LOOP
991:

Line 999: pay_balance_pkg.set_context('LOCAL_UNIT_ID',g_lu_tab(start_index_lu));

995: start_index_mu := NVL (g_mu_tab.FIRST, 0) ;
996: end_index_mu := NVL (g_mu_tab.LAST, 0) ;
997:
998: -- change 3b -2
999: pay_balance_pkg.set_context('LOCAL_UNIT_ID',g_lu_tab(start_index_lu));
1000: ----
1001:
1002: WHILE (g_mu_tab.EXISTS(start_index_mu)) and (start_index_mu <= end_index_mu) LOOP
1003:

Line 1009: --pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);

1005:
1006: hr_utility.trace('2007 EMP_CONT ::: LE #### MU = '|| g_mu_tab(start_index_mu)|| ' LU = '|| g_lu_tab(start_index_lu) );
1007:
1008: --setting the context values
1009: --pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);
1010: pay_balance_pkg.set_context('JURISDICTION_CODE',g_mu_tab(start_index_mu));
1011: --pay_balance_pkg.set_context('LOCAL_UNIT_ID',g_lu_tab(start_index_lu));
1012:
1013: -- get the balance value

Line 1010: pay_balance_pkg.set_context('JURISDICTION_CODE',g_mu_tab(start_index_mu));

1006: hr_utility.trace('2007 EMP_CONT ::: LE #### MU = '|| g_mu_tab(start_index_mu)|| ' LU = '|| g_lu_tab(start_index_lu) );
1007:
1008: --setting the context values
1009: --pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);
1010: pay_balance_pkg.set_context('JURISDICTION_CODE',g_mu_tab(start_index_mu));
1011: --pay_balance_pkg.set_context('LOCAL_UNIT_ID',g_lu_tab(start_index_lu));
1012:
1013: -- get the balance value
1014: l_le_ers_base := pay_balance_pkg.get_value(l_def_bal_id_1,p_asg_act_id,p_tax_unit_id,g_mu_tab(start_index_mu),NULL,NULL,NULL,l_bimonth_end_date);

Line 1011: --pay_balance_pkg.set_context('LOCAL_UNIT_ID',g_lu_tab(start_index_lu));

1007:
1008: --setting the context values
1009: --pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);
1010: pay_balance_pkg.set_context('JURISDICTION_CODE',g_mu_tab(start_index_mu));
1011: --pay_balance_pkg.set_context('LOCAL_UNIT_ID',g_lu_tab(start_index_lu));
1012:
1013: -- get the balance value
1014: l_le_ers_base := pay_balance_pkg.get_value(l_def_bal_id_1,p_asg_act_id,p_tax_unit_id,g_mu_tab(start_index_mu),NULL,NULL,NULL,l_bimonth_end_date);
1015: l_le_ers := pay_balance_pkg.get_value(l_def_bal_id_2,p_asg_act_id,p_tax_unit_id,g_mu_tab(start_index_mu),NULL,NULL,NULL,l_bimonth_end_date);

Line 1014: l_le_ers_base := pay_balance_pkg.get_value(l_def_bal_id_1,p_asg_act_id,p_tax_unit_id,g_mu_tab(start_index_mu),NULL,NULL,NULL,l_bimonth_end_date);

1010: pay_balance_pkg.set_context('JURISDICTION_CODE',g_mu_tab(start_index_mu));
1011: --pay_balance_pkg.set_context('LOCAL_UNIT_ID',g_lu_tab(start_index_lu));
1012:
1013: -- get the balance value
1014: l_le_ers_base := pay_balance_pkg.get_value(l_def_bal_id_1,p_asg_act_id,p_tax_unit_id,g_mu_tab(start_index_mu),NULL,NULL,NULL,l_bimonth_end_date);
1015: l_le_ers := pay_balance_pkg.get_value(l_def_bal_id_2,p_asg_act_id,p_tax_unit_id,g_mu_tab(start_index_mu),NULL,NULL,NULL,l_bimonth_end_date);
1016:
1017: hr_utility.trace('2007 EMP_CONT ::: LE #### l_le_ers_base = '|| l_le_ers_base);
1018: hr_utility.trace('2007 EMP_CONT ::: LE #### l_le_ers = '||l_le_ers );

Line 1015: l_le_ers := pay_balance_pkg.get_value(l_def_bal_id_2,p_asg_act_id,p_tax_unit_id,g_mu_tab(start_index_mu),NULL,NULL,NULL,l_bimonth_end_date);

1011: --pay_balance_pkg.set_context('LOCAL_UNIT_ID',g_lu_tab(start_index_lu));
1012:
1013: -- get the balance value
1014: l_le_ers_base := pay_balance_pkg.get_value(l_def_bal_id_1,p_asg_act_id,p_tax_unit_id,g_mu_tab(start_index_mu),NULL,NULL,NULL,l_bimonth_end_date);
1015: l_le_ers := pay_balance_pkg.get_value(l_def_bal_id_2,p_asg_act_id,p_tax_unit_id,g_mu_tab(start_index_mu),NULL,NULL,NULL,l_bimonth_end_date);
1016:
1017: hr_utility.trace('2007 EMP_CONT ::: LE #### l_le_ers_base = '|| l_le_ers_base);
1018: hr_utility.trace('2007 EMP_CONT ::: LE #### l_le_ers = '||l_le_ers );
1019: