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 382: pay_balance_pkg.set_context('LOCAL_UNIT_ID',p_local_unit_id);

378: ------------------ get exemption limit used for LU
379: hr_utility.trace('2007 EMP_CONT ::: LU ***** get exemption limit ');
380:
381: -- set the context values for balance
382: pay_balance_pkg.set_context('LOCAL_UNIT_ID',p_local_unit_id);
383:
384: -- get defined balance ids
385: l_def_bal_id_1 := get_defined_balance_id('Employer Contribution Exemption Limit Used','_TU_LU_YTD') ;
386: l_def_bal_id_2 := get_defined_balance_id('Employer Contribution Exemption Limit Used','_TU_LU_BIMONTH') ;

Line 392: 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);

388: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_def_bal_id_1 = '|| l_def_bal_id_1 );
389: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_def_bal_id_2 = '|| l_def_bal_id_2 );
390:
391: -- get the balance value
392: 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);
393: 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);
394:
395: l_exemption_limit_used_yet := l_bal_val_ytd - l_bal_val_bimonth ;
396:

Line 393: 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);

389: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_def_bal_id_2 = '|| l_def_bal_id_2 );
390:
391: -- get the balance value
392: 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);
393: 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);
394:
395: l_exemption_limit_used_yet := l_bal_val_ytd - l_bal_val_bimonth ;
396:
397: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_bal_val_ytd = '|| l_bal_val_ytd );

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

474: -- remove till here
475:
476: hr_utility.trace('2007 EMP_CONT ::: LU ***** level 0 leave' );
477:
478: --pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);
479: --pay_balance_pkg.set_context('LOCAL_UNIT_ID',p_local_unit_id);
480:
481: -----
482:

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

475:
476: hr_utility.trace('2007 EMP_CONT ::: LU ***** level 0 leave' );
477:
478: --pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);
479: --pay_balance_pkg.set_context('LOCAL_UNIT_ID',p_local_unit_id);
480:
481: -----
482:
483: -- loop to get all assignment_action_id in the current payroll_action_id

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

492:
493: hr_utility.trace('2007 EMP_CONT ::: LU ***** level 2, g_mu_tab ' );
494: 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 );
495:
496: -- pay_balance_pkg.set_context('JURISDICTION_CODE',g_mu_tab(start_index_mu));
497:
498: -- get the balance value
499: /* l_asg_ers_base := pay_balance_pkg.get_value(l_def_bal_id_1,csr1_rec.ASSIGNMENT_ACTION_ID,TRUE,FALSE);
500: l_asg_ers_base2 := pay_balance_pkg.get_value(l_def_bal_id_2,csr1_rec.ASSIGNMENT_ACTION_ID,TRUE,FALSE);

Line 499: /* l_asg_ers_base := pay_balance_pkg.get_value(l_def_bal_id_1,csr1_rec.ASSIGNMENT_ACTION_ID,TRUE,FALSE);

495:
496: -- pay_balance_pkg.set_context('JURISDICTION_CODE',g_mu_tab(start_index_mu));
497:
498: -- get the balance value
499: /* l_asg_ers_base := pay_balance_pkg.get_value(l_def_bal_id_1,csr1_rec.ASSIGNMENT_ACTION_ID,TRUE,FALSE);
500: l_asg_ers_base2 := pay_balance_pkg.get_value(l_def_bal_id_2,csr1_rec.ASSIGNMENT_ACTION_ID,TRUE,FALSE);
501: l_asg_ers_base_diff := l_asg_ers_base - l_asg_ers_base2;
502:
503:

Line 500: l_asg_ers_base2 := pay_balance_pkg.get_value(l_def_bal_id_2,csr1_rec.ASSIGNMENT_ACTION_ID,TRUE,FALSE);

496: -- pay_balance_pkg.set_context('JURISDICTION_CODE',g_mu_tab(start_index_mu));
497:
498: -- get the balance value
499: /* l_asg_ers_base := pay_balance_pkg.get_value(l_def_bal_id_1,csr1_rec.ASSIGNMENT_ACTION_ID,TRUE,FALSE);
500: l_asg_ers_base2 := pay_balance_pkg.get_value(l_def_bal_id_2,csr1_rec.ASSIGNMENT_ACTION_ID,TRUE,FALSE);
501: l_asg_ers_base_diff := l_asg_ers_base - l_asg_ers_base2;
502:
503:
504: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_asg_ers_base = '|| l_asg_ers_base );

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

595: end_index_mu := NVL (g_mu_tab.LAST, 0) ;
596:
597: hr_utility.trace('2007 EMP_CONT ::: LU ***** level 0 leave ' );
598:
599: --pay_balance_pkg.set_context('LOCAL_UNIT_ID',p_local_unit_id);
600:
601:
602: WHILE (g_mu_tab.EXISTS(start_index_mu)) and (start_index_mu <= end_index_mu) LOOP
603:

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

602: WHILE (g_mu_tab.EXISTS(start_index_mu)) and (start_index_mu <= end_index_mu) LOOP
603:
604: hr_utility.trace('2007 EMP_CONT ::: LU ***** level 1 ,g_mu_tab ' );
605:
606: -- pay_balance_pkg.set_context('JURISDICTION_CODE',g_mu_tab(start_index_mu));
607:
608: hr_utility.trace('2007 EMP_CONT ::: LU ***** MU = '|| g_mu_tab(start_index_mu)|| ' LU = '|| p_local_unit_id );
609:
610: -- get the balance value

Line 611: /*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);

607:
608: hr_utility.trace('2007 EMP_CONT ::: LU ***** MU = '|| g_mu_tab(start_index_mu)|| ' LU = '|| p_local_unit_id );
609:
610: -- get the balance value
611: /*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);
612: 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);
613:
614: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_lu_ers_base = '|| l_lu_ers_base);
615: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_lu_ers = '||l_lu_ers ); */

Line 612: 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);

608: hr_utility.trace('2007 EMP_CONT ::: LU ***** MU = '|| g_mu_tab(start_index_mu)|| ' LU = '|| p_local_unit_id );
609:
610: -- get the balance value
611: /*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);
612: 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);
613:
614: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_lu_ers_base = '|| l_lu_ers_base);
615: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_lu_ers = '||l_lu_ers ); */
616: -- added 29-dec-2012

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

966: hr_utility.trace('2007 EMP_CONT ::: LE #### get exemption limit used for LE , entering');
967:
968: -- set the context values for balance
969:
970: pay_balance_pkg.set_context('LOCAL_UNIT_ID',p_local_unit_id);
971:
972: -- get defined balance ids
973: l_def_bal_id_1 := get_defined_balance_id('Employer Contribution Exemption Limit Used','_TU_LU_YTD') ;
974: l_def_bal_id_2 := get_defined_balance_id('Employer Contribution Exemption Limit Used','_TU_LU_BIMONTH') ;

Line 980: 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);

976: hr_utility.trace('2007 EMP_CONT ::: LE #### l_def_bal_id_1 = '|| l_def_bal_id_1 );
977: hr_utility.trace('2007 EMP_CONT ::: LE #### l_def_bal_id_2 = '|| l_def_bal_id_2 );
978:
979: -- get the balance value
980: 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);
981: 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);
982:
983: --l_bal_val_ytd := 0 ;
984: --l_bal_val_bimonth := 0 ;

Line 981: 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);

977: hr_utility.trace('2007 EMP_CONT ::: LE #### l_def_bal_id_2 = '|| l_def_bal_id_2 );
978:
979: -- get the balance value
980: 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);
981: 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);
982:
983: --l_bal_val_ytd := 0 ;
984: --l_bal_val_bimonth := 0 ;
985:

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

1063:
1064: hr_utility.trace('2007 EMP_CONT ::: LE #### level 0 leave' );
1065:
1066: -- change 2b -1
1067: -- pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);
1068: ----
1069:
1070: -- loop to get all assignment_action_id in the current payroll_action_id
1071: FOR csr1_rec IN csr_curr_le_asg_act_id (p_tax_unit_id , p_payroll_action_id, p_date_earned) LOOP

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

1082: start_index_mu := NVL (g_mu_tab.FIRST, 0) ;
1083: end_index_mu := NVL (g_mu_tab.LAST, 0) ;
1084:
1085: -- Change 2b - 2
1086: -- pay_balance_pkg.set_context('LOCAL_UNIT_ID',g_lu_tab(start_index_lu));
1087: -----
1088:
1089: WHILE (g_mu_tab.EXISTS(start_index_mu)) and (start_index_mu <= end_index_mu) LOOP
1090:

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

1091: hr_utility.trace('2007 EMP_CONT ::: LE #### level 3, g_mu_tab ' );
1092: 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) );
1093:
1094: --setting the context values
1095: -- pay_balance_pkg.set_context('JURISDICTION_CODE',g_mu_tab(start_index_mu));
1096:
1097: -- get the balance value
1098: /* l_asg_ers_base := pay_balance_pkg.get_value(l_def_bal_id_1,csr1_rec.ASSIGNMENT_ACTION_ID,TRUE,FALSE);
1099: l_asg_ers_base2 := pay_balance_pkg.get_value(l_def_bal_id_2,csr1_rec.ASSIGNMENT_ACTION_ID,TRUE,FALSE);

Line 1098: /* l_asg_ers_base := pay_balance_pkg.get_value(l_def_bal_id_1,csr1_rec.ASSIGNMENT_ACTION_ID,TRUE,FALSE);

1094: --setting the context values
1095: -- pay_balance_pkg.set_context('JURISDICTION_CODE',g_mu_tab(start_index_mu));
1096:
1097: -- get the balance value
1098: /* l_asg_ers_base := pay_balance_pkg.get_value(l_def_bal_id_1,csr1_rec.ASSIGNMENT_ACTION_ID,TRUE,FALSE);
1099: l_asg_ers_base2 := pay_balance_pkg.get_value(l_def_bal_id_2,csr1_rec.ASSIGNMENT_ACTION_ID,TRUE,FALSE);
1100: l_asg_ers_base_diff := l_asg_ers_base - l_asg_ers_base2;
1101:
1102: hr_utility.trace('2007 EMP_CONT ::: LE #### l_asg_ers_base = '|| l_asg_ers_base );

Line 1099: l_asg_ers_base2 := pay_balance_pkg.get_value(l_def_bal_id_2,csr1_rec.ASSIGNMENT_ACTION_ID,TRUE,FALSE);

1095: -- pay_balance_pkg.set_context('JURISDICTION_CODE',g_mu_tab(start_index_mu));
1096:
1097: -- get the balance value
1098: /* l_asg_ers_base := pay_balance_pkg.get_value(l_def_bal_id_1,csr1_rec.ASSIGNMENT_ACTION_ID,TRUE,FALSE);
1099: l_asg_ers_base2 := pay_balance_pkg.get_value(l_def_bal_id_2,csr1_rec.ASSIGNMENT_ACTION_ID,TRUE,FALSE);
1100: l_asg_ers_base_diff := l_asg_ers_base - l_asg_ers_base2;
1101:
1102: hr_utility.trace('2007 EMP_CONT ::: LE #### l_asg_ers_base = '|| l_asg_ers_base );
1103: hr_utility.trace('2007 EMP_CONT ::: LE #### l_asg_ers_base2 = '|| l_asg_ers_base2 );

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

1196:
1197: hr_utility.trace('2007 EMP_CONT ::: LE #### level 0 leave ' );
1198:
1199: -- change 3b -1
1200: --pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);
1201: ----
1202:
1203: WHILE (g_lu_tab.EXISTS(start_index_lu)) and (start_index_lu <= end_index_lu) LOOP
1204:

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

1208: start_index_mu := NVL (g_mu_tab.FIRST, 0) ;
1209: end_index_mu := NVL (g_mu_tab.LAST, 0) ;
1210:
1211: -- change 3b -2
1212: --pay_balance_pkg.set_context('LOCAL_UNIT_ID',g_lu_tab(start_index_lu));
1213: ----
1214:
1215: WHILE (g_mu_tab.EXISTS(start_index_mu)) and (start_index_mu <= end_index_mu) LOOP
1216:

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

1218:
1219: hr_utility.trace('2007 EMP_CONT ::: LE #### MU = '|| g_mu_tab(start_index_mu)|| ' LU = '|| g_lu_tab(start_index_lu) );
1220:
1221: --setting the context values
1222: --pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);
1223: -- pay_balance_pkg.set_context('JURISDICTION_CODE',g_mu_tab(start_index_mu));
1224: --pay_balance_pkg.set_context('LOCAL_UNIT_ID',g_lu_tab(start_index_lu));
1225:
1226: -- get the balance value

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

1219: hr_utility.trace('2007 EMP_CONT ::: LE #### MU = '|| g_mu_tab(start_index_mu)|| ' LU = '|| g_lu_tab(start_index_lu) );
1220:
1221: --setting the context values
1222: --pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);
1223: -- pay_balance_pkg.set_context('JURISDICTION_CODE',g_mu_tab(start_index_mu));
1224: --pay_balance_pkg.set_context('LOCAL_UNIT_ID',g_lu_tab(start_index_lu));
1225:
1226: -- get the balance value
1227: /* 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 1224: --pay_balance_pkg.set_context('LOCAL_UNIT_ID',g_lu_tab(start_index_lu));

1220:
1221: --setting the context values
1222: --pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);
1223: -- pay_balance_pkg.set_context('JURISDICTION_CODE',g_mu_tab(start_index_mu));
1224: --pay_balance_pkg.set_context('LOCAL_UNIT_ID',g_lu_tab(start_index_lu));
1225:
1226: -- get the balance value
1227: /* 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);
1228: 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 1227: /* 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);

1223: -- pay_balance_pkg.set_context('JURISDICTION_CODE',g_mu_tab(start_index_mu));
1224: --pay_balance_pkg.set_context('LOCAL_UNIT_ID',g_lu_tab(start_index_lu));
1225:
1226: -- get the balance value
1227: /* 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);
1228: 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);
1229:
1230: hr_utility.trace('2007 EMP_CONT ::: LE #### l_le_ers_base = '|| l_le_ers_base);
1231: hr_utility.trace('2007 EMP_CONT ::: LE #### l_le_ers = '||l_le_ers ); */

Line 1228: 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);

1224: --pay_balance_pkg.set_context('LOCAL_UNIT_ID',g_lu_tab(start_index_lu));
1225:
1226: -- get the balance value
1227: /* 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);
1228: 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);
1229:
1230: hr_utility.trace('2007 EMP_CONT ::: LE #### l_le_ers_base = '|| l_le_ers_base);
1231: hr_utility.trace('2007 EMP_CONT ::: LE #### l_le_ers = '||l_le_ers ); */
1232: -- added 29-dec-2012