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_AC_ACTION_ARCH dependencies on PAY_EMP_ACTION_ARCH

Line 332: of pay_emp_action_arch from all

328: taking from pay_element_types_f_tl.
329: Also changed populate_hours_x_rate.
330: 02-DEC-2002 ahanda 115.34 Changed package to fix GSCC warning
331: 19-NOV-2002 vpandya 115.33 Calling set_error_message function
332: of pay_emp_action_arch from all
333: exceptions to get error message
334: Remote Procedure Calls(RPC or Sub
335: program)
336: 13-NOV-2002 ahanda 115.32 2667749 Changed get_missing_xfr_info

Line 678: pay_emp_action_arch.set_error_message(lv_error_message);

674:
675: hr_utility.trace(lv_error_message || '-' || sqlerrm);
676:
677: lv_error_message :=
678: pay_emp_action_arch.set_error_message(lv_error_message);
679:
680: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
681: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
682: hr_utility.raise_error;

Line 750: if pay_emp_action_arch.gv_multi_payroll_pymt = 'Y' then

746:
747: BEGIN
748: hr_utility.set_location(gv_package || lv_procedure_name, 10);
749: ln_step := 1;
750: if pay_emp_action_arch.gv_multi_payroll_pymt = 'Y' then
751: open c_multi_asg_prev_information(p_assignment_id,
752: p_action_info_category,
753: p_xfr_action_id,
754: p_curr_effective_date);

Line 801: pay_emp_action_arch.set_error_message(lv_error_message);

797:
798: hr_utility.trace(lv_error_message || '-' || sqlerrm);
799:
800: lv_error_message :=
801: pay_emp_action_arch.set_error_message(lv_error_message);
802:
803: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
804: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
805: hr_utility.raise_error;

Line 820: used when pay_emp_action_arch.gv_multi_payroll_pymt = 'Y'

816: 2. p_legislation_code
817: Notes : The only difference with the base version is the usage
818: of cursor c_prev_run_information/c_multi_asg_prev_information.
819: In base version, cursor c_multi_asg_prev_information is
820: used when pay_emp_action_arch.gv_multi_payroll_pymt = 'Y'
821: otherwise cursor c_prev_run_information get called.
822: However, in the overloaded version for US legislation
823: cursor c_multi_asg_prev_information is used when
824: pay_emp_action_arch.gv_multi_payroll_pymt = 'Y' AND

Line 824: pay_emp_action_arch.gv_multi_payroll_pymt = 'Y' AND

820: used when pay_emp_action_arch.gv_multi_payroll_pymt = 'Y'
821: otherwise cursor c_prev_run_information get called.
822: However, in the overloaded version for US legislation
823: cursor c_multi_asg_prev_information is used when
824: pay_emp_action_arch.gv_multi_payroll_pymt = 'Y' AND
825: p_arch_bal_info = 'Y' otherwise
826: cursor c_prev_run_information get called. For other
827: legislations, the cursor usage is like base version only.
828: ******************************************************************/

Line 904: if pay_emp_action_arch.gv_multi_payroll_pymt = 'Y' AND p_arch_bal_info = 'Y' then

900:
901:
902: IF p_legislation_code = 'US' THEN
903:
904: if pay_emp_action_arch.gv_multi_payroll_pymt = 'Y' AND p_arch_bal_info = 'Y' then
905: open c_multi_asg_prev_information(p_assignment_id,
906: p_action_info_category,
907: p_xfr_action_id,
908: ln_payroll_id, --added for the bug 14605761

Line 933: if pay_emp_action_arch.gv_multi_payroll_pymt = 'Y' then

929: end if;
930:
931: ELSE
932:
933: if pay_emp_action_arch.gv_multi_payroll_pymt = 'Y' then
934: open c_multi_asg_prev_information(p_assignment_id,
935: p_action_info_category,
936: p_xfr_action_id,
937: ln_payroll_id, --added for the bug 14605761

Line 986: pay_emp_action_arch.set_error_message(lv_error_message);

982:
983: hr_utility.trace(lv_error_message || '-' || sqlerrm);
984:
985: lv_error_message :=
986: pay_emp_action_arch.set_error_message(lv_error_message);
987:
988: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
989: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
990: hr_utility.raise_error;

Line 1057: pay_emp_action_arch.set_error_message(lv_error_message);

1053:
1054: hr_utility.trace(lv_error_message || '-' || sqlerrm);
1055:
1056: lv_error_message :=
1057: pay_emp_action_arch.set_error_message(lv_error_message);
1058:
1059: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
1060: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
1061: hr_utility.raise_error;

Line 1126: pay_emp_action_arch.set_error_message(lv_error_message);

1122:
1123: hr_utility.trace(lv_error_message || '-' || sqlerrm);
1124:
1125: lv_error_message :=
1126: pay_emp_action_arch.set_error_message(lv_error_message);
1127:
1128: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
1129: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
1130: hr_utility.raise_error;

Line 1242: if pay_emp_action_arch.gv_multi_leg_rule is null then

1238: hr_utility.trace('p_pymt_balcall_aaid ='||to_char(p_pymt_balcall_aaid));
1239: hr_utility.trace('p_legislation_code ='||p_legislation_code);
1240: hr_utility.trace('p_hours_balance_id ='||to_char(p_hours_balance_id));
1241:
1242: if pay_emp_action_arch.gv_multi_leg_rule is null then
1243: pay_emp_action_arch.gv_multi_leg_rule
1244: := pay_emp_action_arch.get_multi_legislative_rule(
1245: p_legislation_code);
1246: end if;

Line 1243: pay_emp_action_arch.gv_multi_leg_rule

1239: hr_utility.trace('p_legislation_code ='||p_legislation_code);
1240: hr_utility.trace('p_hours_balance_id ='||to_char(p_hours_balance_id));
1241:
1242: if pay_emp_action_arch.gv_multi_leg_rule is null then
1243: pay_emp_action_arch.gv_multi_leg_rule
1244: := pay_emp_action_arch.get_multi_legislative_rule(
1245: p_legislation_code);
1246: end if;
1247:

Line 1244: := pay_emp_action_arch.get_multi_legislative_rule(

1240: hr_utility.trace('p_hours_balance_id ='||to_char(p_hours_balance_id));
1241:
1242: if pay_emp_action_arch.gv_multi_leg_rule is null then
1243: pay_emp_action_arch.gv_multi_leg_rule
1244: := pay_emp_action_arch.get_multi_legislative_rule(
1245: p_legislation_code);
1246: end if;
1247:
1248: ln_step := 2;

Line 1268: := pay_emp_action_arch.get_defined_balance_id(

1264: ** Get the defined balance_id for YTD call as it will be
1265: ** same for all classification types.
1266: *********************************************************/
1267: ln_ytd_defined_balance_id
1268: := pay_emp_action_arch.get_defined_balance_id(
1269: p_primary_balance_id,
1270: gv_ytd_balance_dimension,
1271: p_legislation_code);
1272:

Line 1280: := pay_emp_action_arch.get_defined_balance_id(

1276: ln_step := 4;
1277: if p_hours_balance_id is not null then
1278: hr_utility.set_location(gv_package || lv_procedure_name, 20);
1279: ln_ytd_hours_balance_id
1280: := pay_emp_action_arch.get_defined_balance_id(
1281: p_hours_balance_id,
1282: gv_ytd_balance_dimension,
1283: p_legislation_code);
1284:

Line 1339: := pay_emp_action_arch.get_defined_balance_id(

1335: /* Added dimension _ASG_GRE_RUN for reversals and Balance
1336: Adjustments for Canada. Bug#3498653 */
1337: if p_action_type in ('B','V') then
1338: ln_pymt_defined_balance_id
1339: := pay_emp_action_arch.get_defined_balance_id(
1340: p_primary_balance_id,
1341: '_ASG_GRE_RUN',
1342: p_legislation_code);
1343: else

Line 1344: if pay_emp_action_arch.gv_multi_leg_rule = 'Y' then

1340: p_primary_balance_id,
1341: '_ASG_GRE_RUN',
1342: p_legislation_code);
1343: else
1344: if pay_emp_action_arch.gv_multi_leg_rule = 'Y' then
1345: ln_pymt_defined_balance_id
1346: := pay_emp_action_arch.get_defined_balance_id(
1347: p_primary_balance_id,
1348: '_ASG_PAYMENTS',

Line 1346: := pay_emp_action_arch.get_defined_balance_id(

1342: p_legislation_code);
1343: else
1344: if pay_emp_action_arch.gv_multi_leg_rule = 'Y' then
1345: ln_pymt_defined_balance_id
1346: := pay_emp_action_arch.get_defined_balance_id(
1347: p_primary_balance_id,
1348: '_ASG_PAYMENTS',
1349: p_legislation_code);
1350: else

Line 1352: := pay_emp_action_arch.get_defined_balance_id(

1348: '_ASG_PAYMENTS',
1349: p_legislation_code);
1350: else
1351: ln_pymt_defined_balance_id
1352: := pay_emp_action_arch.get_defined_balance_id(
1353: p_primary_balance_id,
1354: '_PAYMENTS',
1355: p_legislation_code);
1356: end if;

Line 1374: := pay_emp_action_arch.get_defined_balance_id(

1370: /* Added dimension _ASG_GRE_RUN for reversals and Balance
1371: Adjustments for Canada. Bug#3498653 */
1372: if p_action_type in ('B','V') then
1373: ln_pymt_hours_balance_id
1374: := pay_emp_action_arch.get_defined_balance_id(
1375: p_hours_balance_id
1376: ,'_ASG_GRE_RUN'
1377: ,p_legislation_code);
1378: else

Line 1379: if pay_emp_action_arch.gv_multi_leg_rule = 'Y' then

1375: p_hours_balance_id
1376: ,'_ASG_GRE_RUN'
1377: ,p_legislation_code);
1378: else
1379: if pay_emp_action_arch.gv_multi_leg_rule = 'Y' then
1380: ln_pymt_hours_balance_id
1381: := pay_emp_action_arch.get_defined_balance_id(
1382: p_hours_balance_id
1383: ,'_ASG_PAYMENTS'

Line 1381: := pay_emp_action_arch.get_defined_balance_id(

1377: ,p_legislation_code);
1378: else
1379: if pay_emp_action_arch.gv_multi_leg_rule = 'Y' then
1380: ln_pymt_hours_balance_id
1381: := pay_emp_action_arch.get_defined_balance_id(
1382: p_hours_balance_id
1383: ,'_ASG_PAYMENTS'
1384: ,p_legislation_code);
1385: else

Line 1387: := pay_emp_action_arch.get_defined_balance_id(

1383: ,'_ASG_PAYMENTS'
1384: ,p_legislation_code);
1385: else
1386: ln_pymt_hours_balance_id
1387: := pay_emp_action_arch.get_defined_balance_id(
1388: p_hours_balance_id
1389: ,'_PAYMENTS'
1390: ,p_legislation_code);
1391: end if;

Line 1548: pay_emp_action_arch.set_error_message(lv_error_message);

1544:
1545: hr_utility.trace(lv_error_message || '-' || sqlerrm);
1546:
1547: lv_error_message :=
1548: pay_emp_action_arch.set_error_message(lv_error_message);
1549:
1550: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
1551: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
1552: hr_utility.raise_error;

Line 1766: := pay_emp_action_arch.get_defined_balance_id

1762:
1763: ln_step := 5;
1764: if gv_reporting_level = 'TAXGRP' then
1765: ln_tg_ytd_defined_bal_id
1766: := pay_emp_action_arch.get_defined_balance_id
1767: (ln_primary_balance_id,
1768: gv_dim_asg_tg_ytd,
1769: p_legislation_code);
1770: ln_hours_ytd_defined_bal_id

Line 1771: := pay_emp_action_arch.get_defined_balance_id

1767: (ln_primary_balance_id,
1768: gv_dim_asg_tg_ytd,
1769: p_legislation_code);
1770: ln_hours_ytd_defined_bal_id
1771: := pay_emp_action_arch.get_defined_balance_id
1772: (ln_hours_balance_id,
1773: gv_dim_asg_tg_ytd,
1774: p_legislation_code);
1775: if ln_tg_ytd_defined_bal_id is not null then

Line 1788: := pay_emp_action_arch.get_defined_balance_id

1784: end if;
1785: else
1786: ln_step := 10;
1787: ln_gre_ytd_defined_bal_id
1788: := pay_emp_action_arch.get_defined_balance_id
1789: (ln_primary_balance_id,
1790: gv_dim_asg_gre_ytd,
1791: p_legislation_code);
1792: ln_hours_ytd_defined_bal_id

Line 1793: := pay_emp_action_arch.get_defined_balance_id

1789: (ln_primary_balance_id,
1790: gv_dim_asg_gre_ytd,
1791: p_legislation_code);
1792: ln_hours_ytd_defined_bal_id
1793: := pay_emp_action_arch.get_defined_balance_id
1794: (ln_hours_balance_id,
1795: gv_dim_asg_gre_ytd,
1796: p_legislation_code);
1797: if ln_gre_ytd_defined_bal_id is not null then

Line 1820: := pay_emp_action_arch.get_defined_balance_id

1816: ln_ytd_amount := 0;
1817: ln_ytd_hours := 0;
1818:
1819: ln_pymt_def_bal_id
1820: := pay_emp_action_arch.get_defined_balance_id
1821: (ln_primary_balance_id,
1822: '_ASG_PAYMENTS',
1823: p_legislation_code);
1824:

Line 2005: pay_emp_action_arch.set_error_message(lv_error_message);

2001:
2002: hr_utility.trace(lv_error_message || '-' || sqlerrm);
2003:
2004: lv_error_message :=
2005: pay_emp_action_arch.set_error_message(lv_error_message);
2006:
2007: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
2008: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
2009: hr_utility.raise_error;

Line 2991: pay_emp_action_arch.set_error_message(lv_error_message);

2987:
2988: hr_utility.trace(lv_error_message || '-' || sqlerrm);
2989:
2990: lv_error_message :=
2991: pay_emp_action_arch.set_error_message(lv_error_message);
2992:
2993: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
2994: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
2995: hr_utility.raise_error;

Line 3099: pay_emp_action_arch.gv_multi_payroll_pymt);

3095: hr_utility.trace('p_xfr_action_id = '||p_xfr_action_id);
3096: hr_utility.trace('p_last_xfr_action_id = '|| p_last_xfr_action_id );
3097: hr_utility.trace('p_assignment_id = '|| p_assignment_id );
3098: hr_utility.trace('gv_multi_payroll_pymt = '||
3099: pay_emp_action_arch.gv_multi_payroll_pymt);
3100: hr_utility.trace('p_sepchk_flag = '||p_sepchk_flag);
3101:
3102: open c_last_xfr_elements(p_last_xfr_action_id, p_legislation_code);
3103: loop

Line 3153: if pay_emp_action_arch.gv_multi_payroll_pymt = 'Y' and

3149:
3150: hr_utility.trace('p_assignment_id (current) = '||p_assignment_id);
3151: hr_utility.trace('ln_assignment_id (prev) = '||ln_assignment_id);
3152:
3153: if pay_emp_action_arch.gv_multi_payroll_pymt = 'Y' and
3154: p_sepchk_flag = 'Y' and
3155: ln_assignment_id <> p_assignment_id then
3156:
3157: hr_utility.trace('action_info_category = ' ||lv_action_info_category);

Line 3272: := pay_emp_action_arch.get_defined_balance_id

3268: end if;
3269:
3270: ln_step := 15;
3271: ln_ytd_defined_balance_id
3272: := pay_emp_action_arch.get_defined_balance_id
3273: (ln_primary_balance_id,
3274: gv_ytd_balance_dimension,
3275: p_legislation_code);
3276: hr_utility.set_location(gv_package || lv_procedure_name, 60);

Line 3285: := pay_emp_action_arch.get_defined_balance_id

3281: end if;
3282: hr_utility.set_location(gv_package || lv_procedure_name, 70);
3283: if ln_hours_balance_id is not null then
3284: ln_ytd_hours_balance_id
3285: := pay_emp_action_arch.get_defined_balance_id
3286: (ln_hours_balance_id,
3287: gv_ytd_balance_dimension,
3288: p_legislation_code);
3289: hr_utility.set_location(gv_package || lv_procedure_name, 80);

Line 3378: pay_emp_action_arch.set_error_message(lv_error_message);

3374:
3375: hr_utility.trace(lv_error_message || '-' || sqlerrm);
3376:
3377: lv_error_message :=
3378: pay_emp_action_arch.set_error_message(lv_error_message);
3379:
3380: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
3381: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
3382: hr_utility.raise_error;

Line 3578: pay_emp_action_arch.get_defined_balance_id

3574: end if;
3575:
3576: ln_step := 15;
3577: ln_ytd_defined_balance_id :=
3578: pay_emp_action_arch.get_defined_balance_id
3579: (ln_primary_balance_id,
3580: gv_ytd_balance_dimension,
3581: p_legislation_code);
3582: hr_utility.set_location(gv_package || lv_procedure_name, 60);

Line 3591: pay_emp_action_arch.get_defined_balance_id

3587: hr_utility.set_location(gv_package || lv_procedure_name, 70);
3588: end if;
3589: if ln_hours_balance_id is not null then
3590: ln_ytd_hours_balance_id :=
3591: pay_emp_action_arch.get_defined_balance_id
3592: (ln_hours_balance_id,
3593: gv_ytd_balance_dimension,
3594: p_legislation_code);
3595: hr_utility.set_location(gv_package || lv_procedure_name, 80);

Line 3671: pay_emp_action_arch.set_error_message(lv_error_message);

3667:
3668: hr_utility.trace(lv_error_message || '-' || sqlerrm);
3669:
3670: lv_error_message :=
3671: pay_emp_action_arch.set_error_message(lv_error_message);
3672:
3673: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
3674: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
3675: hr_utility.raise_error;

Line 4000: pay_emp_action_arch.set_error_message(lv_error_message);

3996:
3997: hr_utility.trace(lv_error_message || '-' || sqlerrm);
3998:
3999: lv_error_message :=
4000: pay_emp_action_arch.set_error_message(lv_error_message);
4001:
4002: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
4003: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
4004: hr_utility.raise_error;

Line 4096: pay_emp_action_arch.set_error_message(lv_error_message);

4092:
4093: hr_utility.trace(lv_error_message || '-' || sqlerrm);
4094:
4095: lv_error_message :=
4096: pay_emp_action_arch.set_error_message(lv_error_message);
4097:
4098: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
4099: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
4100: hr_utility.raise_error;

Line 4368: pay_emp_action_arch.set_error_message(lv_error_message);

4364:
4365: hr_utility.trace(lv_error_message || '-' || sqlerrm);
4366:
4367: lv_error_message :=
4368: pay_emp_action_arch.set_error_message(lv_error_message);
4369:
4370: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
4371: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
4372: hr_utility.raise_error;

Line 4470: := pay_emp_action_arch.get_defined_balance_id(

4466: if ln_hours_balance_id is not null then
4467: ln_step := 30;
4468: hr_utility.set_location(gv_package || lv_procedure_name, 22);
4469: ln_ytd_hours_balance_id
4470: := pay_emp_action_arch.get_defined_balance_id(
4471: ln_hours_balance_id,
4472: gv_ytd_balance_dimension,
4473: p_legislation_code);
4474: hr_utility.trace('ln_ytd_hours_balance_id = '||

Line 4490: := pay_emp_action_arch.get_defined_balance_id

4486: end if; --Hours
4487:
4488: ln_step := 50;
4489: ln_ytd_defined_balance_id
4490: := pay_emp_action_arch.get_defined_balance_id
4491: (ln_primary_balance_id,
4492: gv_ytd_balance_dimension,
4493: p_legislation_code);
4494: hr_utility.trace('ln_ytd_defined_balance_id = '||

Line 4603: pay_emp_action_arch.set_error_message(lv_error_message);

4599:
4600: hr_utility.trace(lv_error_message || '-' || sqlerrm);
4601:
4602: lv_error_message :=
4603: pay_emp_action_arch.set_error_message(lv_error_message);
4604:
4605: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
4606: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
4607: hr_utility.raise_error;

Line 4705: pay_emp_action_arch.set_error_message(lv_error_message);

4701:
4702: hr_utility.trace(lv_error_message || '-' || sqlerrm);
4703:
4704: lv_error_message :=
4705: pay_emp_action_arch.set_error_message(lv_error_message);
4706:
4707: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
4708: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
4709: hr_utility.raise_error;

Line 5239: if pay_emp_action_arch.gv_multi_leg_rule is null then

5235: /* Code added for doing balance call for YTD
5236: This is a Case where Element DOES NOT have Base Entry
5237: BUT ONLY Retro Entries */
5238:
5239: if pay_emp_action_arch.gv_multi_leg_rule is null then
5240: pay_emp_action_arch.gv_multi_leg_rule
5241: := pay_emp_action_arch.get_multi_legislative_rule(
5242: p_legislation_code);
5243: end if;

Line 5240: pay_emp_action_arch.gv_multi_leg_rule

5236: This is a Case where Element DOES NOT have Base Entry
5237: BUT ONLY Retro Entries */
5238:
5239: if pay_emp_action_arch.gv_multi_leg_rule is null then
5240: pay_emp_action_arch.gv_multi_leg_rule
5241: := pay_emp_action_arch.get_multi_legislative_rule(
5242: p_legislation_code);
5243: end if;
5244:

Line 5241: := pay_emp_action_arch.get_multi_legislative_rule(

5237: BUT ONLY Retro Entries */
5238:
5239: if pay_emp_action_arch.gv_multi_leg_rule is null then
5240: pay_emp_action_arch.gv_multi_leg_rule
5241: := pay_emp_action_arch.get_multi_legislative_rule(
5242: p_legislation_code);
5243: end if;
5244:
5245: pay_balance_pkg.set_context('JURISDICTION_CODE', NULL);

Line 5254: := pay_emp_action_arch.get_defined_balance_id(

5250: end if;
5251:
5252:
5253: ln_ytd_defined_balance_id
5254: := pay_emp_action_arch.get_defined_balance_id(
5255: p_primary_balance_id,
5256: gv_ytd_balance_dimension,
5257: p_legislation_code);
5258:

Line 5270: := pay_emp_action_arch.get_defined_balance_id(

5266: end if;
5267: if p_hours_balance_id is not null then
5268: hr_utility.set_location(gv_package || lv_procedure_name, 20);
5269: ln_ytd_hours_balance_id
5270: := pay_emp_action_arch.get_defined_balance_id(
5271: p_hours_balance_id,
5272: gv_ytd_balance_dimension,
5273: p_legislation_code);
5274:

Line 5776: if pay_emp_action_arch.gv_multi_leg_rule is null then

5772: lv_temp_AAA := 'BBB' ;
5773: end loop;
5774:
5775: /* Code added for doing balance call for YTD */
5776: if pay_emp_action_arch.gv_multi_leg_rule is null then
5777: pay_emp_action_arch.gv_multi_leg_rule
5778: := pay_emp_action_arch.get_multi_legislative_rule(
5779: p_legislation_code);
5780: end if;

Line 5777: pay_emp_action_arch.gv_multi_leg_rule

5773: end loop;
5774:
5775: /* Code added for doing balance call for YTD */
5776: if pay_emp_action_arch.gv_multi_leg_rule is null then
5777: pay_emp_action_arch.gv_multi_leg_rule
5778: := pay_emp_action_arch.get_multi_legislative_rule(
5779: p_legislation_code);
5780: end if;
5781:

Line 5778: := pay_emp_action_arch.get_multi_legislative_rule(

5774:
5775: /* Code added for doing balance call for YTD */
5776: if pay_emp_action_arch.gv_multi_leg_rule is null then
5777: pay_emp_action_arch.gv_multi_leg_rule
5778: := pay_emp_action_arch.get_multi_legislative_rule(
5779: p_legislation_code);
5780: end if;
5781:
5782: pay_balance_pkg.set_context('JURISDICTION_CODE', null);

Line 5794: := pay_emp_action_arch.get_defined_balance_id(

5790: ** Get the defined balance_id for YTD call as it will be
5791: ** same for all classification types.
5792: *********************************************************/
5793: ln_ytd_defined_balance_id
5794: := pay_emp_action_arch.get_defined_balance_id(
5795: p_primary_balance_id,
5796: gv_ytd_balance_dimension,
5797: p_legislation_code);
5798:

Line 5806: := pay_emp_action_arch.get_defined_balance_id(

5802: ln_step := 4;
5803: if p_hours_balance_id is not null then
5804: hr_utility.set_location(gv_package || lv_procedure_name, 20);
5805: ln_ytd_hours_balance_id
5806: := pay_emp_action_arch.get_defined_balance_id(
5807: p_hours_balance_id,
5808: gv_ytd_balance_dimension,
5809: p_legislation_code);
5810:

Line 5841: := pay_emp_action_arch.get_defined_balance_id(

5837: /* Added dimension _ASG_GRE_RUN for reversals and Balance
5838: Adjustments for Canada. Bug#3498653 */
5839: if p_action_type in ('B','V') then
5840: ln_pymt_defined_balance_id
5841: := pay_emp_action_arch.get_defined_balance_id(
5842: p_primary_balance_id,
5843: '_ASG_GRE_RUN',
5844: p_legislation_code);
5845: else

Line 5846: if pay_emp_action_arch.gv_multi_leg_rule = 'Y' then

5842: p_primary_balance_id,
5843: '_ASG_GRE_RUN',
5844: p_legislation_code);
5845: else
5846: if pay_emp_action_arch.gv_multi_leg_rule = 'Y' then
5847: ln_pymt_defined_balance_id
5848: := pay_emp_action_arch.get_defined_balance_id(
5849: p_primary_balance_id,
5850: '_ASG_PAYMENTS',

Line 5848: := pay_emp_action_arch.get_defined_balance_id(

5844: p_legislation_code);
5845: else
5846: if pay_emp_action_arch.gv_multi_leg_rule = 'Y' then
5847: ln_pymt_defined_balance_id
5848: := pay_emp_action_arch.get_defined_balance_id(
5849: p_primary_balance_id,
5850: '_ASG_PAYMENTS',
5851: p_legislation_code);
5852: else

Line 5854: := pay_emp_action_arch.get_defined_balance_id(

5850: '_ASG_PAYMENTS',
5851: p_legislation_code);
5852: else
5853: ln_pymt_defined_balance_id
5854: := pay_emp_action_arch.get_defined_balance_id(
5855: p_primary_balance_id,
5856: '_PAYMENTS',
5857: p_legislation_code);
5858: end if;

Line 5876: := pay_emp_action_arch.get_defined_balance_id(

5872: /* Added dimension _ASG_GRE_RUN for reversals and Balance
5873: Adjustments for Canada. Bug#3498653 */
5874: if p_action_type in ('B','V') then
5875: ln_pymt_hours_balance_id
5876: := pay_emp_action_arch.get_defined_balance_id(
5877: p_hours_balance_id
5878: ,'_ASG_GRE_RUN'
5879: ,p_legislation_code);
5880: else

Line 5881: if pay_emp_action_arch.gv_multi_leg_rule = 'Y' then

5877: p_hours_balance_id
5878: ,'_ASG_GRE_RUN'
5879: ,p_legislation_code);
5880: else
5881: if pay_emp_action_arch.gv_multi_leg_rule = 'Y' then
5882: ln_pymt_hours_balance_id
5883: := pay_emp_action_arch.get_defined_balance_id(
5884: p_hours_balance_id
5885: ,'_ASG_PAYMENTS'

Line 5883: := pay_emp_action_arch.get_defined_balance_id(

5879: ,p_legislation_code);
5880: else
5881: if pay_emp_action_arch.gv_multi_leg_rule = 'Y' then
5882: ln_pymt_hours_balance_id
5883: := pay_emp_action_arch.get_defined_balance_id(
5884: p_hours_balance_id
5885: ,'_ASG_PAYMENTS'
5886: ,p_legislation_code);
5887: else

Line 5889: := pay_emp_action_arch.get_defined_balance_id(

5885: ,'_ASG_PAYMENTS'
5886: ,p_legislation_code);
5887: else
5888: ln_pymt_hours_balance_id
5889: := pay_emp_action_arch.get_defined_balance_id(
5890: p_hours_balance_id
5891: ,'_PAYMENTS'
5892: ,p_legislation_code);
5893: end if;

Line 6388: if pay_emp_action_arch.gv_multi_leg_rule is null then

6384: lv_temp_AAA := 'BBB' ;
6385: end loop;
6386:
6387: /* Code added for doing balance call for YTD */
6388: if pay_emp_action_arch.gv_multi_leg_rule is null then
6389: pay_emp_action_arch.gv_multi_leg_rule
6390: := pay_emp_action_arch.get_multi_legislative_rule(
6391: p_legislation_code);
6392: end if;

Line 6389: pay_emp_action_arch.gv_multi_leg_rule

6385: end loop;
6386:
6387: /* Code added for doing balance call for YTD */
6388: if pay_emp_action_arch.gv_multi_leg_rule is null then
6389: pay_emp_action_arch.gv_multi_leg_rule
6390: := pay_emp_action_arch.get_multi_legislative_rule(
6391: p_legislation_code);
6392: end if;
6393:

Line 6390: := pay_emp_action_arch.get_multi_legislative_rule(

6386:
6387: /* Code added for doing balance call for YTD */
6388: if pay_emp_action_arch.gv_multi_leg_rule is null then
6389: pay_emp_action_arch.gv_multi_leg_rule
6390: := pay_emp_action_arch.get_multi_legislative_rule(
6391: p_legislation_code);
6392: end if;
6393:
6394: pay_balance_pkg.set_context('JURISDICTION_CODE', null);

Line 6406: := pay_emp_action_arch.get_defined_balance_id(

6402: ** Get the defined balance_id for YTD call as it will be
6403: ** same for all classification types.
6404: *********************************************************/
6405: ln_ytd_defined_balance_id
6406: := pay_emp_action_arch.get_defined_balance_id(
6407: p_primary_balance_id,
6408: gv_ytd_balance_dimension,
6409: p_legislation_code);
6410:

Line 6418: := pay_emp_action_arch.get_defined_balance_id(

6414: ln_step := 4;
6415: if p_hours_balance_id is not null then
6416: hr_utility.set_location(gv_package || lv_procedure_name, 20);
6417: ln_ytd_hours_balance_id
6418: := pay_emp_action_arch.get_defined_balance_id(
6419: p_hours_balance_id,
6420: gv_ytd_balance_dimension,
6421: p_legislation_code);
6422:

Line 6453: := pay_emp_action_arch.get_defined_balance_id(

6449: /* Added dimension _ASG_GRE_RUN for reversals and Balance
6450: Adjustments for Canada. Bug#3498653 */
6451: if p_action_type in ('B','V') then
6452: ln_pymt_defined_balance_id
6453: := pay_emp_action_arch.get_defined_balance_id(
6454: p_primary_balance_id,
6455: '_ASG_GRE_RUN',
6456: p_legislation_code);
6457: else

Line 6458: if pay_emp_action_arch.gv_multi_leg_rule = 'Y' then

6454: p_primary_balance_id,
6455: '_ASG_GRE_RUN',
6456: p_legislation_code);
6457: else
6458: if pay_emp_action_arch.gv_multi_leg_rule = 'Y' then
6459: ln_pymt_defined_balance_id
6460: := pay_emp_action_arch.get_defined_balance_id(
6461: p_primary_balance_id,
6462: '_ASG_PAYMENTS',

Line 6460: := pay_emp_action_arch.get_defined_balance_id(

6456: p_legislation_code);
6457: else
6458: if pay_emp_action_arch.gv_multi_leg_rule = 'Y' then
6459: ln_pymt_defined_balance_id
6460: := pay_emp_action_arch.get_defined_balance_id(
6461: p_primary_balance_id,
6462: '_ASG_PAYMENTS',
6463: p_legislation_code);
6464: else

Line 6466: := pay_emp_action_arch.get_defined_balance_id(

6462: '_ASG_PAYMENTS',
6463: p_legislation_code);
6464: else
6465: ln_pymt_defined_balance_id
6466: := pay_emp_action_arch.get_defined_balance_id(
6467: p_primary_balance_id,
6468: '_PAYMENTS',
6469: p_legislation_code);
6470: end if;

Line 6488: := pay_emp_action_arch.get_defined_balance_id(

6484: /* Added dimension _ASG_GRE_RUN for reversals and Balance
6485: Adjustments for Canada. Bug#3498653 */
6486: if p_action_type in ('B','V') then
6487: ln_pymt_hours_balance_id
6488: := pay_emp_action_arch.get_defined_balance_id(
6489: p_hours_balance_id
6490: ,'_ASG_GRE_RUN'
6491: ,p_legislation_code);
6492: else

Line 6493: if pay_emp_action_arch.gv_multi_leg_rule = 'Y' then

6489: p_hours_balance_id
6490: ,'_ASG_GRE_RUN'
6491: ,p_legislation_code);
6492: else
6493: if pay_emp_action_arch.gv_multi_leg_rule = 'Y' then
6494: ln_pymt_hours_balance_id
6495: := pay_emp_action_arch.get_defined_balance_id(
6496: p_hours_balance_id
6497: ,'_ASG_PAYMENTS'

Line 6495: := pay_emp_action_arch.get_defined_balance_id(

6491: ,p_legislation_code);
6492: else
6493: if pay_emp_action_arch.gv_multi_leg_rule = 'Y' then
6494: ln_pymt_hours_balance_id
6495: := pay_emp_action_arch.get_defined_balance_id(
6496: p_hours_balance_id
6497: ,'_ASG_PAYMENTS'
6498: ,p_legislation_code);
6499: else

Line 6501: := pay_emp_action_arch.get_defined_balance_id(

6497: ,'_ASG_PAYMENTS'
6498: ,p_legislation_code);
6499: else
6500: ln_pymt_hours_balance_id
6501: := pay_emp_action_arch.get_defined_balance_id(
6502: p_hours_balance_id
6503: ,'_PAYMENTS'
6504: ,p_legislation_code);
6505: end if;