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 947: l_def_bal_id := pay_in_tax_utils.get_defined_balance('Excess Interest Amount','_ASG_DE_PTD');

943: --
944: --
945: END LOOP;
946:
947: l_def_bal_id := pay_in_tax_utils.get_defined_balance('Excess Interest Amount','_ASG_DE_PTD');
948: l_excess_pf := pay_balance_pkg.get_value(l_def_bal_id,p_assignment_action_id);
949:
950: l_def_bal_id := pay_in_tax_utils.get_defined_balance('Excess PF Amount','_ASG_DE_PTD');
951: l_excess_pf := l_excess_pf + pay_balance_pkg.get_value(l_def_bal_id,p_assignment_action_id);

Line 950: l_def_bal_id := pay_in_tax_utils.get_defined_balance('Excess PF Amount','_ASG_DE_PTD');

946:
947: l_def_bal_id := pay_in_tax_utils.get_defined_balance('Excess Interest Amount','_ASG_DE_PTD');
948: l_excess_pf := pay_balance_pkg.get_value(l_def_bal_id,p_assignment_action_id);
949:
950: l_def_bal_id := pay_in_tax_utils.get_defined_balance('Excess PF Amount','_ASG_DE_PTD');
951: l_excess_pf := l_excess_pf + pay_balance_pkg.get_value(l_def_bal_id,p_assignment_action_id);
952:
953:
954:

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

1145: END IF;
1146:
1147: FOR i IN 1..9
1148: LOOP
1149: l_value := pay_in_tax_utils.get_balance_value(p_assignment_action_id => p_assignment_action_id,
1150: p_balance_name => g_bal_name(i),
1151: p_dimension_name => '_ASG_DE_PTD',
1152: p_context_name => 'NULL',
1153: p_context_value => 'NULL'

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

1185: -- --
1186: -- Name : ARCHIVE_FORM24Q_BALANCES --
1187: -- Type : PROCEDURE --
1188: -- Access : Private --
1189: -- Description : This procedure calls pay_in_tax_utils. --
1190: -- get_balance_value to archive individual balances for --
1191: -- the following balances --
1192: -- --
1193: -- 1. Net Pay --

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

1375: FOR rec_multi IN c_multi_records( p_pre_assact_id) LOOP
1376: l_date :=rec_multi.date_earned;
1377: l_eff_date := rec_multi.effective_date;
1378: pay_in_utils.set_location(g_debug,l_procedure, 30);
1379: l_multirec_value := l_multirec_value + pay_in_tax_utils.get_balance_value(p_assignment_action_id => rec_multi.assignment_action_id,
1380: p_balance_name => l_bal_name_val(i).l_balance_name,
1381: p_dimension_name => '_ASG_RUN',
1382: p_context_name => 'NULL',
1383: p_context_value => 'NULL');

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

1386: l_bal_name_val(i).l_balance_val := l_multirec_value;
1387: l_multirec_value :=0;
1388:
1389: ELSE
1390: l_bal_name_val(i).l_balance_val := pay_in_tax_utils.get_balance_value(p_assignment_action_id => p_assignment_action_id,
1391: p_balance_name => l_bal_name_val(i).l_balance_name,
1392: p_dimension_name => '_ASG_RUN',
1393: p_context_name => 'NULL',
1394: p_context_value => 'NULL'

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

1433: /* Bug 12660389 */
1434: l_next_year := to_char(pay_in_utils.next_tax_year(p_effective_date),'YYYY');
1435: l_assessment_year := l_next_year || '-' || to_char(to_number(l_next_year)+1);
1436: l_tan := pay_in_form_24q_web_adi.get_tan_number(p_assignment_id, nvl(l_date, p_effective_date));
1437: l_period := pay_in_tax_utils.get_period_number(l_payroll_id, nvl(TRUNC(l_date), p_effective_date));
1438: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 35);
1439:
1440: pay_action_information_api.create_action_information
1441: (

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

2535: l_start_date:=add_months(l_start_date,1);
2536: l_end_date :=l_start_date;
2537: END IF;
2538:
2539: 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');
2540: l_contr_period_1:=to_char(pay_in_tax_utils.get_financial_year_start(l_start_date_1),'YYYY')||'-'||to_char(pay_in_tax_utils.get_financial_year_end(l_end_date_1),'YYYY'); -- 14784847
2541:
2542:
2543: OPEN c_defined_balance_id('PF Computation Salary','_ASG_DE_PTD');

Line 2540: l_contr_period_1:=to_char(pay_in_tax_utils.get_financial_year_start(l_start_date_1),'YYYY')||'-'||to_char(pay_in_tax_utils.get_financial_year_end(l_end_date_1),'YYYY'); -- 14784847

2536: l_end_date :=l_start_date;
2537: END IF;
2538:
2539: 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');
2540: l_contr_period_1:=to_char(pay_in_tax_utils.get_financial_year_start(l_start_date_1),'YYYY')||'-'||to_char(pay_in_tax_utils.get_financial_year_end(l_end_date_1),'YYYY'); -- 14784847
2541:
2542:
2543: OPEN c_defined_balance_id('PF Computation Salary','_ASG_DE_PTD');
2544: FETCH c_defined_balance_id INTO l_balance_defined_id;

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

3193: --Contribution Period
3194: IF(to_number(to_char(p_payroll_date,'MM'))) > 3 AND (to_number(to_char(p_payroll_date,'MM'))) < 10 THEN
3195: l_contr_period :='Apr-'||to_char(p_payroll_date,'YYYY')||' - '||'Sep-'||to_char(p_payroll_date,'YYYY');
3196: ELSE
3197: 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');
3198: END IF;
3199: --ESI Coverage
3200:
3201: IF g_debug THEN

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

3478: l_start_date:=add_months(l_start_date,1);
3479: l_end_date :=l_start_date;
3480: END IF;
3481:
3482: 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');
3483: l_contr_period_1:=to_char(pay_in_tax_utils.get_financial_year_start(l_start_date_1),'YYYY')||'-'||to_char(pay_in_tax_utils.get_financial_year_end(l_end_date_1),'YYYY');
3484: ELSIF p_context = 'ESI' THEN
3485: pay_in_utils.set_location(g_debug,l_procedure, 50);
3486: IF(TO_NUMBER(TO_CHAR(l_effective_date,'MM'))) > 3 AND (TO_NUMBER(TO_CHAR(l_effective_date,'MM'))) < 10 THEN

Line 3483: l_contr_period_1:=to_char(pay_in_tax_utils.get_financial_year_start(l_start_date_1),'YYYY')||'-'||to_char(pay_in_tax_utils.get_financial_year_end(l_end_date_1),'YYYY');

3479: l_end_date :=l_start_date;
3480: END IF;
3481:
3482: 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');
3483: l_contr_period_1:=to_char(pay_in_tax_utils.get_financial_year_start(l_start_date_1),'YYYY')||'-'||to_char(pay_in_tax_utils.get_financial_year_end(l_end_date_1),'YYYY');
3484: ELSIF p_context = 'ESI' THEN
3485: pay_in_utils.set_location(g_debug,l_procedure, 50);
3486: IF(TO_NUMBER(TO_CHAR(l_effective_date,'MM'))) > 3 AND (TO_NUMBER(TO_CHAR(l_effective_date,'MM'))) < 10 THEN
3487: l_contr_period:='Apr-'||to_char(l_effective_date,'YYYY')||' - '||'Sep-'||to_char(l_effective_date,'YYYY');

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

3485: pay_in_utils.set_location(g_debug,l_procedure, 50);
3486: IF(TO_NUMBER(TO_CHAR(l_effective_date,'MM'))) > 3 AND (TO_NUMBER(TO_CHAR(l_effective_date,'MM'))) < 10 THEN
3487: l_contr_period:='Apr-'||to_char(l_effective_date,'YYYY')||' - '||'Sep-'||to_char(l_effective_date,'YYYY');
3488: ELSE
3489: 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');
3490:
3491: END IF;
3492: END IF;
3493:

Line 3829: pt_salary := pay_in_tax_utils.get_balance_value(

3825: pay_in_utils.trace('PT-III g_pt_jur_code ',g_pt_jur_code(g_cnt_pt));
3826: END IF;
3827:
3828: --PT Salary
3829: pt_salary := pay_in_tax_utils.get_balance_value(
3830: p_assignment_action_id => p_assignment_action_id
3831: ,p_balance_name => 'PT Actual Salary'
3832: ,p_dimension_name => '_ASG_STATE_DE_PTD'
3833: ,p_context_name => 'JURISDICTION_CODE'

Line 3843: pt := pay_in_tax_utils.get_balance_value(

3839: pay_in_utils.trace('PT Salary ',pt_salary);
3840: END IF;
3841:
3842: --Professional Tax
3843: pt := pay_in_tax_utils.get_balance_value(
3844: p_assignment_action_id => p_assignment_action_id
3845: ,p_balance_name => 'Professional Tax'
3846: ,p_dimension_name => '_ASG_STATE_DE_PTD'
3847: ,p_context_name => 'JURISDICTION_CODE'

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

3898: l_exempted_frm_pt := 'No';
3899: END IF;
3900:
3901: l_contrib_month := TO_CHAR(ADD_MONTHS(p_payroll_date, -3), 'MM');
3902: 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');
3903:
3904: pay_action_information_api.create_action_information
3905: (p_action_context_id => p_archive_action_id --Archive Action id
3906: ,p_action_context_type => 'AAP'

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

4111: pay_in_utils.set_location(g_debug,l_procedure, 30);
4112:
4113:
4114: --Contribution Period
4115: 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');
4116: l_contr_month := TO_CHAR(ADD_MONTHS(l_effective_date, -3), 'MM');
4117:
4118: --Registered Name
4119: OPEN c_registered_name(l_org_id