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_PPMV4_SS dependencies on HR_API

Line 353: and nvl(ppm.run_type_id, hr_api.g_number) = nvl(p_run_type_id, hr_api.g_number)

349: select count(0)
350: from pay_personal_payment_methods_f ppm
351: , pay_org_payment_methods_f opm
352: where ppm.assignment_id = p_assignment_id
353: and nvl(ppm.run_type_id, hr_api.g_number) = nvl(p_run_type_id, hr_api.g_number)
354: and p_effective_date between
355: ppm.effective_start_date and ppm.effective_end_date
356: and opm.org_payment_method_id = ppm.org_payment_method_id
357: and opm.defined_balance_id is not null

Line 444: and nvl(ppm.run_type_id, hr_api.g_number) = nvl(p_run_type_id, hr_api.g_number)

440: , pay_payment_types ppt
441: , pay_defined_balances pdb
442: , pay_balance_types pbt
443: where ppm.assignment_id = p_assignment_id
444: and nvl(ppm.run_type_id, hr_api.g_number) = nvl(p_run_type_id, hr_api.g_number)
445: and p_effective_date between
446: ppm.effective_start_date and ppm.effective_end_date
447: and opm.org_payment_method_id = ppm.org_payment_method_id
448: and p_effective_date between

Line 607: l_ppm.update_datetrack_mode := hr_api.g_correction;

603: --
604: pay_ppmv4_utils_ss.seterrorstage
605: (l_proc, 'SET_DT_MODES:' || to_char(i), 30);
606: if l_ppm.effective_date = l_effective_date then
607: l_ppm.update_datetrack_mode := hr_api.g_correction;
608: --
609: -- Need to check whether or not there are preceding date-track rows as
610: -- this affects the delete date-track mode.
611: --

Line 619: l_ppm.delete_datetrack_mode := hr_api.g_delete;

615: (p_personal_payment_method_id => l_ppm.personal_payment_method_id
616: );
617: fetch csr_dt_row_count into l_dt_count;
618: if l_dt_count > 1 then
619: l_ppm.delete_datetrack_mode := hr_api.g_delete;
620: --
621: -- Get the object version number for the preceding row - as the
622: -- delete is done on that row.
623: --

Line 631: l_ppm.delete_datetrack_mode := hr_api.g_zap;

627: where ppm.personal_payment_method_id =
628: l_ppm.personal_payment_method_id
629: and ppm.effective_end_date = (l_effective_date-1);
630: else
631: l_ppm.delete_datetrack_mode := hr_api.g_zap;
632: end if;
633: close csr_dt_row_count;
634: else
635: l_ppm.update_datetrack_mode := hr_api.g_update;

Line 635: l_ppm.update_datetrack_mode := hr_api.g_update;

631: l_ppm.delete_datetrack_mode := hr_api.g_zap;
632: end if;
633: close csr_dt_row_count;
634: else
635: l_ppm.update_datetrack_mode := hr_api.g_update;
636: l_ppm.delete_datetrack_mode := hr_api.g_delete;
637: end if;
638: --
639: -- Set the effective date to the correct value.

Line 636: l_ppm.delete_datetrack_mode := hr_api.g_delete;

632: end if;
633: close csr_dt_row_count;
634: else
635: l_ppm.update_datetrack_mode := hr_api.g_update;
636: l_ppm.delete_datetrack_mode := hr_api.g_delete;
637: end if;
638: --
639: -- Set the effective date to the correct value.
640: --

Line 1200: , nvl(ppt.territory_code, hr_api.return_legislation_code(paa.business_group_id))

1196: (p_assigment_id in number
1197: ,p_effective_date in date
1198: ) is
1199: select ppt.category
1200: , nvl(ppt.territory_code, hr_api.return_legislation_code(paa.business_group_id))
1201: , pap.prl_information3
1202: , paa.payroll_id
1203: from per_all_assignments_f paa
1204: , pay_all_payrolls_f pap

Line 1319: and nvl(ppm.run_type_id, hr_api.g_number) = nvl(p_run_type_id, hr_api.g_number)

1315: ) is
1316: select null
1317: from pay_personal_payment_methods_f ppm
1318: where ppm.assignment_id = p_assignment_id
1319: and nvl(ppm.run_type_id, hr_api.g_number) = nvl(p_run_type_id, hr_api.g_number)
1320: and ppm.effective_start_date > p_effective_date
1321: ;
1322: --
1323: -- Check if this assignment has any PPMs with not null (monetary) amount

Line 1333: and nvl(ppm.run_type_id, hr_api.g_number) = nvl(p_run_type_id, hr_api.g_number)

1329: ) is
1330: select null
1331: from pay_personal_payment_methods_f ppm
1332: where ppm.assignment_id = p_assignment_id
1333: and nvl(ppm.run_type_id, hr_api.g_number) = nvl(p_run_type_id, hr_api.g_number)
1334: and p_effective_date between
1335: ppm.effective_start_date and ppm.effective_end_date
1336: and ppm.amount is not null
1337: ;

Line 1351: and nvl(ppm.run_type_id, hr_api.g_number) = nvl(p_run_type_id, hr_api.g_number)

1347: select null
1348: from pay_personal_payment_methods_f ppm
1349: , pay_org_payment_methods_f opm
1350: where ppm.assignment_id = p_assignment_id
1351: and nvl(ppm.run_type_id, hr_api.g_number) = nvl(p_run_type_id, hr_api.g_number)
1352: and p_effective_date between
1353: ppm.effective_start_date and ppm.effective_end_date
1354: and opm.org_payment_method_id = ppm.org_payment_method_id
1355: and p_effective_date between

Line 1362: and nvl(ppm1.run_type_id, hr_api.g_number) = nvl(p_run_type_id, hr_api.g_number)

1358: and ( (p_run_type_id is not null) or (ppm.priority <
1359: (select max(priority)
1360: from pay_personal_payment_methods_f ppm1
1361: where ppm1.assignment_id = p_assignment_id
1362: and nvl(ppm1.run_type_id, hr_api.g_number) = nvl(p_run_type_id, hr_api.g_number)
1363: and p_effective_date between
1364: ppm1.effective_start_date and ppm1.effective_end_date)))
1365: and ppm.percentage is not null
1366: ;

Line 2442: if nvl(l_o_logical_priority, to_char(hr_api.g_number)) =

2438:
2439:
2440: end if;
2441: pay_ppmv4_utils_ss.seterrorstage(l_proc, 'LOGICAL_PRIORITY CHANGE', 10);
2442: if nvl(l_o_logical_priority, to_char(hr_api.g_number)) =
2443: p_logical_priority then
2444: --
2445: -- If this is an existing PPM that has been updated then it is
2446: -- necessary to check whether or not this change will reset the PPM

Line 3190: and nvl(ppm.run_type_id, hr_api.g_number) = nvl(p_run_type_id, hr_api.g_number)

3186: , ppm.priority priority
3187: from pay_personal_payment_methods_f ppm
3188: , pay_org_payment_methods_f opm
3189: where ppm.assignment_id = p_assignment_id
3190: and nvl(ppm.run_type_id, hr_api.g_number) = nvl(p_run_type_id, hr_api.g_number)
3191: and p_effective_date
3192: between ppm.effective_start_date and ppm.effective_end_date
3193: and opm.org_payment_method_id = ppm.org_payment_method_id
3194: and p_effective_date between

Line 3208: l_dt_mode := hr_api.g_correction;

3204: if ppm.priority <> l_priority then
3205: --
3206: -- Set the correct datetrack mode.
3207: --
3208: l_dt_mode := hr_api.g_correction;
3209: if ppm.esd < p_effective_date then
3210: l_dt_mode := hr_api.g_update;
3211: end if;
3212: hr_personal_pay_method_api.update_personal_pay_method

Line 3210: l_dt_mode := hr_api.g_update;

3206: -- Set the correct datetrack mode.
3207: --
3208: l_dt_mode := hr_api.g_correction;
3209: if ppm.esd < p_effective_date then
3210: l_dt_mode := hr_api.g_update;
3211: end if;
3212: hr_personal_pay_method_api.update_personal_pay_method
3213: (p_validate => false
3214: ,p_personal_payment_method_id => ppm.ppmid

Line 3406: from hr_api_transaction_steps

3402: select creator_person_id
3403: , transaction_id
3404: into l_hr_txpersonid
3405: , l_hr_txid
3406: from hr_api_transaction_steps
3407: where transaction_step_id = p_transaction_step_id;
3408: --
3409: -- Set the processed flag for this transaction.
3410: --

Line 3425: from hr_api_transaction_values hatv

3421: --
3422: pay_ppmv4_utils_ss.seterrorstage(l_proc, 'COUNT_UNPROCESSED', 30);
3423: select count(*)
3424: into l_unprocessed
3425: from hr_api_transaction_values hatv
3426: where hatv.name = pay_ppmv4_utils_ss.C_PROCESSED_FLAG_ARG
3427: and hatv.varchar2_value = 'N'
3428: and hatv.transaction_step_id in
3429: (select transaction_step_id

Line 3430: from hr_api_transaction_steps hats

3426: where hatv.name = pay_ppmv4_utils_ss.C_PROCESSED_FLAG_ARG
3427: and hatv.varchar2_value = 'N'
3428: and hatv.transaction_step_id in
3429: (select transaction_step_id
3430: from hr_api_transaction_steps hats
3431: where hats.transaction_id = l_hr_txid);
3432: pay_ppmv4_utils_ss.seterrorstage
3433: (l_proc, 'UNPROCESSED_COUNT:' || to_char(l_unprocessed), 35);
3434: --

Line 3627: and leg.legislation_code = DECODE(PTS.territory_code, null, HR_API.RETURN_LEGISLATION_CODE(OPM.BUSINESS_GROUP_ID),PTS.territory_code)

3623: , PAY_PAYMENT_TYPES PTS
3624: where opm.ORG_PAYMENT_METHOD_ID = cp_opm_id
3625: and opm.BUSINESS_GROUP_ID = cp_bgid
3626: and opm.PAYMENT_TYPE_ID = PTS.PAYMENT_TYPE_ID
3627: and leg.legislation_code = DECODE(PTS.territory_code, null, HR_API.RETURN_LEGISLATION_CODE(OPM.BUSINESS_GROUP_ID),PTS.territory_code)
3628: and leg.rule_type = 'E'
3629: and to_char(flex.id_flex_num) = leg.rule_mode
3630: and flex.id_flex_code = 'BANK';
3631: