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_IN_PAYSLIP_ARCHIVE dependencies on PAY_IN_TAX_UTILS

Line 877: l_def_bal_id := pay_in_tax_utils.get_defined_balance('Excess Interest Amount','_ASG_PTD');

873: --
874: --
875: END LOOP;
876:
877: l_def_bal_id := pay_in_tax_utils.get_defined_balance('Excess Interest Amount','_ASG_PTD');
878: l_excess_pf := pay_balance_pkg.get_value(l_def_bal_id,p_assignment_action_id);
879:
880: l_def_bal_id := pay_in_tax_utils.get_defined_balance('Excess PF Amount','_ASG_PTD');
881: l_excess_pf := l_excess_pf + pay_balance_pkg.get_value(l_def_bal_id,p_assignment_action_id);

Line 880: l_def_bal_id := pay_in_tax_utils.get_defined_balance('Excess PF Amount','_ASG_PTD');

876:
877: l_def_bal_id := pay_in_tax_utils.get_defined_balance('Excess Interest Amount','_ASG_PTD');
878: l_excess_pf := pay_balance_pkg.get_value(l_def_bal_id,p_assignment_action_id);
879:
880: l_def_bal_id := pay_in_tax_utils.get_defined_balance('Excess PF Amount','_ASG_PTD');
881: l_excess_pf := l_excess_pf + pay_balance_pkg.get_value(l_def_bal_id,p_assignment_action_id);
882:
883:
884:

Line 1079: l_value := pay_in_tax_utils.get_balance_value(p_assignment_action_id => p_assignment_action_id,

1075: END IF;
1076:
1077: FOR i IN 1..9
1078: LOOP
1079: l_value := pay_in_tax_utils.get_balance_value(p_assignment_action_id => p_assignment_action_id,
1080: p_balance_name => g_bal_name(i),
1081: p_dimension_name => '_ASG_PTD',
1082: p_context_name => 'NULL',
1083: p_context_value => 'NULL'

Line 1119: -- Description : This procedure calls pay_in_tax_utils. --

1115: -- --
1116: -- Name : ARCHIVE_FORM24Q_BALANCES --
1117: -- Type : PROCEDURE --
1118: -- Access : Private --
1119: -- Description : This procedure calls pay_in_tax_utils. --
1120: -- get_balance_value to archive individual balances for --
1121: -- the following balances --
1122: -- --
1123: -- 1. Net Pay --

Line 1271: l_multirec_value := l_multirec_value + pay_in_tax_utils.get_balance_value(p_assignment_action_id => rec_multi.assignment_action_id,

1267: FOR rec_multi IN c_multi_records( p_pre_assact_id) LOOP
1268: l_date :=rec_multi.date_earned;
1269: l_eff_date := rec_multi.effective_date;
1270: pay_in_utils.set_location(g_debug,l_procedure, 30);
1271: l_multirec_value := l_multirec_value + pay_in_tax_utils.get_balance_value(p_assignment_action_id => rec_multi.assignment_action_id,
1272: p_balance_name => l_bal_name_val(i).l_balance_name,
1273: p_dimension_name => '_ASG_RUN',
1274: p_context_name => 'NULL',
1275: p_context_value => 'NULL');

Line 1282: l_bal_name_val(i).l_balance_val := pay_in_tax_utils.get_balance_value(p_assignment_action_id => p_assignment_action_id,

1278: l_bal_name_val(i).l_balance_val := l_multirec_value;
1279: l_multirec_value :=0;
1280:
1281: ELSE
1282: l_bal_name_val(i).l_balance_val := pay_in_tax_utils.get_balance_value(p_assignment_action_id => p_assignment_action_id,
1283: p_balance_name => l_bal_name_val(i).l_balance_name,
1284: p_dimension_name => '_ASG_RUN',
1285: p_context_name => 'NULL',
1286: p_context_value => 'NULL'

Line 1309: l_period := pay_in_tax_utils.get_period_number(l_payroll_id, nvl(TRUNC(l_date), p_effective_date));

1305:
1306: l_next_year := to_char(pay_in_utils.next_tax_year(nvl(TRUNC(l_date),p_effective_date)),'YYYY');
1307: l_assessment_year := l_next_year || '-' || to_char(to_number(l_next_year)+1);
1308: l_tan := pay_in_form_24q_web_adi.get_tan_number(p_assignment_id, nvl(l_date, p_effective_date));
1309: l_period := pay_in_tax_utils.get_period_number(l_payroll_id, nvl(TRUNC(l_date), p_effective_date));
1310: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 35);
1311:
1312: pay_action_information_api.create_action_information
1313: (

Line 2328: l_contr_period:=to_char(pay_in_tax_utils.get_financial_year_start(l_start_date),'YYYY')||'-'||to_char(pay_in_tax_utils.get_financial_year_end(l_end_date),'YYYY');

2324: l_start_date:=add_months(l_start_date,1);
2325: l_end_date :=l_start_date;
2326: END IF;
2327:
2328: l_contr_period:=to_char(pay_in_tax_utils.get_financial_year_start(l_start_date),'YYYY')||'-'||to_char(pay_in_tax_utils.get_financial_year_end(l_end_date),'YYYY');
2329:
2330:
2331: OPEN c_defined_balance_id('PF Computation Salary','_ASG_PTD');
2332: FETCH c_defined_balance_id INTO l_balance_defined_id;

Line 2985: l_contr_period :='Oct-'||to_char(pay_in_tax_utils.get_financial_year_start(p_payroll_date),'YYYY')||' - '||'Mar-'||to_char(pay_in_tax_utils.get_financial_year_end(p_payroll_date),'YYYY');

2981: --Contribution Period
2982: IF(to_number(to_char(p_payroll_date,'MM'))) > 3 AND (to_number(to_char(p_payroll_date,'MM'))) < 10 THEN
2983: l_contr_period :='Apr-'||to_char(p_payroll_date,'YYYY')||' - '||'Sep-'||to_char(p_payroll_date,'YYYY');
2984: ELSE
2985: l_contr_period :='Oct-'||to_char(pay_in_tax_utils.get_financial_year_start(p_payroll_date),'YYYY')||' - '||'Mar-'||to_char(pay_in_tax_utils.get_financial_year_end(p_payroll_date),'YYYY');
2986: END IF;
2987: --ESI Coverage
2988:
2989: IF g_debug THEN

Line 3264: l_contr_period := TO_CHAR(pay_in_tax_utils.get_financial_year_start(l_start_date),'YYYY')||'-'||to_char(pay_in_tax_utils.get_financial_year_end(l_end_date),'YYYY');

3260: l_start_date:=add_months(l_start_date,1);
3261: l_end_date :=l_start_date;
3262: END IF;
3263:
3264: l_contr_period := TO_CHAR(pay_in_tax_utils.get_financial_year_start(l_start_date),'YYYY')||'-'||to_char(pay_in_tax_utils.get_financial_year_end(l_end_date),'YYYY');
3265: ELSIF p_context = 'ESI' THEN
3266: pay_in_utils.set_location(g_debug,l_procedure, 50);
3267: IF(TO_NUMBER(TO_CHAR(l_effective_date,'MM'))) > 3 AND (TO_NUMBER(TO_CHAR(l_effective_date,'MM'))) < 10 THEN
3268: l_contr_period:='Apr-'||to_char(l_effective_date,'YYYY')||' - '||'Sep-'||to_char(l_effective_date,'YYYY');

Line 3270: l_contr_period:='Oct-'||to_char(pay_in_tax_utils.get_financial_year_start(l_effective_date),'YYYY')||' - '||'Mar-'||to_char(pay_in_tax_utils.get_financial_year_end(l_effective_date),'YYYY');

3266: pay_in_utils.set_location(g_debug,l_procedure, 50);
3267: IF(TO_NUMBER(TO_CHAR(l_effective_date,'MM'))) > 3 AND (TO_NUMBER(TO_CHAR(l_effective_date,'MM'))) < 10 THEN
3268: l_contr_period:='Apr-'||to_char(l_effective_date,'YYYY')||' - '||'Sep-'||to_char(l_effective_date,'YYYY');
3269: ELSE
3270: l_contr_period:='Oct-'||to_char(pay_in_tax_utils.get_financial_year_start(l_effective_date),'YYYY')||' - '||'Mar-'||to_char(pay_in_tax_utils.get_financial_year_end(l_effective_date),'YYYY');
3271:
3272: END IF;
3273: END IF;
3274:

Line 3609: pt_salary := pay_in_tax_utils.get_balance_value(

3605: pay_in_utils.trace('PT-III g_pt_jur_code ',g_pt_jur_code(g_cnt_pt));
3606: END IF;
3607:
3608: --PT Salary
3609: pt_salary := pay_in_tax_utils.get_balance_value(
3610: p_assignment_action_id => p_assignment_action_id
3611: ,p_balance_name => 'PT Actual Salary'
3612: ,p_dimension_name => '_ASG_STATE_PTD'
3613: ,p_context_name => 'JURISDICTION_CODE'

Line 3623: pt := pay_in_tax_utils.get_balance_value(

3619: pay_in_utils.trace('PT Salary ',pt_salary);
3620: END IF;
3621:
3622: --Professional Tax
3623: pt := pay_in_tax_utils.get_balance_value(
3624: p_assignment_action_id => p_assignment_action_id
3625: ,p_balance_name => 'Professional Tax'
3626: ,p_dimension_name => '_ASG_STATE_PTD'
3627: ,p_context_name => 'JURISDICTION_CODE'

Line 3682: l_contrib_year := TO_CHAR(pay_in_tax_utils.get_financial_year_start(p_payroll_date), 'YYYY')||'-'|| TO_CHAR(pay_in_tax_utils.get_financial_year_end(p_payroll_date), 'YYYY');

3678: l_exempted_frm_pt := 'No';
3679: END IF;
3680:
3681: l_contrib_month := TO_CHAR(ADD_MONTHS(p_payroll_date, -3), 'MM');
3682: l_contrib_year := TO_CHAR(pay_in_tax_utils.get_financial_year_start(p_payroll_date), 'YYYY')||'-'|| TO_CHAR(pay_in_tax_utils.get_financial_year_end(p_payroll_date), 'YYYY');
3683:
3684: pay_action_information_api.create_action_information
3685: (p_action_context_id => p_archive_action_id --Archive Action id
3686: ,p_action_context_type => 'AAP'

Line 3895: l_contr_year := TO_CHAR(pay_in_tax_utils.get_financial_year_start(l_effective_date), 'YYYY')||'-'||to_char(pay_in_tax_utils.get_financial_year_end(l_effective_date), 'YYYY');

3891: pay_in_utils.set_location(g_debug,l_procedure, 30);
3892:
3893:
3894: --Contribution Period
3895: l_contr_year := TO_CHAR(pay_in_tax_utils.get_financial_year_start(l_effective_date), 'YYYY')||'-'||to_char(pay_in_tax_utils.get_financial_year_end(l_effective_date), 'YYYY');
3896: l_contr_month := TO_CHAR(ADD_MONTHS(l_effective_date, -3), 'MM');
3897:
3898: --Registered Name
3899: OPEN c_registered_name(l_org_id