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:
355:
356: and opm.org_payment_method_id = ppm.org_payment_method_id
357: and opm.defined_balance_id is not null

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

506: , pay_payment_types ppt
507: , pay_defined_balances pdb
508: , pay_balance_types pbt
509: where ppm.assignment_id = p_assignment_id
510: and nvl(ppm.run_type_id, hr_api.g_number) = nvl(p_run_type_id, hr_api.g_number)
511: and opm.org_payment_method_id = ppm.org_payment_method_id
512: and (
513: (p_effective_date between ppm.effective_start_date and ppm.effective_end_date
514: and p_effective_date between opm.effective_start_date and opm.effective_end_date)

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

672: --
673: pay_ppmv4_utils_ss.seterrorstage
674: (l_proc, 'SET_DT_MODES:' || to_char(i), 30);
675: if l_ppm.effective_date = l_effective_date then
676: l_ppm.update_datetrack_mode := hr_api.g_correction;
677: --
678: -- Need to check whether or not there are preceding date-track rows as
679: -- this affects the delete date-track mode.
680: --

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

684: (p_personal_payment_method_id => l_ppm.personal_payment_method_id
685: );
686: fetch csr_dt_row_count into l_dt_count;
687: if l_dt_count > 1 then
688: l_ppm.delete_datetrack_mode := hr_api.g_delete;
689: --
690: -- Get the object version number for the preceding row - as the
691: -- delete is done on that row.
692: --

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

696: where ppm.personal_payment_method_id =
697: l_ppm.personal_payment_method_id
698: and ppm.effective_end_date = (l_effective_date-1);
699: else
700: l_ppm.delete_datetrack_mode := hr_api.g_zap;
701: end if;
702: close csr_dt_row_count;
703: else
704: l_ppm.update_datetrack_mode := hr_api.g_update;

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

700: l_ppm.delete_datetrack_mode := hr_api.g_zap;
701: end if;
702: close csr_dt_row_count;
703: else
704: l_ppm.update_datetrack_mode := hr_api.g_update;
705: l_ppm.delete_datetrack_mode := hr_api.g_delete;
706: end if;
707: --
708: -- Set the effective date to the correct value.

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

701: end if;
702: close csr_dt_row_count;
703: else
704: l_ppm.update_datetrack_mode := hr_api.g_update;
705: l_ppm.delete_datetrack_mode := hr_api.g_delete;
706: end if;
707: --
708: -- Set the effective date to the correct value.
709: --

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

1271: (p_assigment_id in number
1272: ,p_effective_date in date
1273: ) is
1274: select ppt.category
1275: , nvl(ppt.territory_code, hr_api.return_legislation_code(paa.business_group_id))
1276: , pap.prl_information3
1277: , paa.payroll_id
1278: from per_all_assignments_f paa
1279: , pay_all_payrolls_f pap

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

1404: ) is
1405: select null
1406: from pay_personal_payment_methods_f ppm
1407: where ppm.assignment_id = p_assignment_id
1408: and nvl(ppm.run_type_id, hr_api.g_number) = nvl(p_run_type_id, hr_api.g_number)
1409: and p_effective_date between
1410: ppm.effective_start_date and ppm.effective_end_date
1411: and ppm.amount is not null
1412: ;

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

1422: select null
1423: from pay_personal_payment_methods_f ppm
1424: , pay_org_payment_methods_f opm
1425: where ppm.assignment_id = p_assignment_id
1426: and nvl(ppm.run_type_id, hr_api.g_number) = nvl(p_run_type_id, hr_api.g_number)
1427: and p_effective_date between
1428: ppm.effective_start_date and ppm.effective_end_date
1429: and opm.org_payment_method_id = ppm.org_payment_method_id
1430: and p_effective_date between

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

1433: and ( (p_run_type_id is not null) or (ppm.priority <
1434: (select max(priority)
1435: from pay_personal_payment_methods_f ppm1
1436: where ppm1.assignment_id = p_assignment_id
1437: and nvl(ppm1.run_type_id, hr_api.g_number) = nvl(p_run_type_id, hr_api.g_number)
1438: and p_effective_date between
1439: ppm1.effective_start_date and ppm1.effective_end_date)))
1440: and ppm.percentage is not null
1441: ;

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

2530: l_amount_type := p_amount_type;
2531: end if;
2532: end if;
2533: pay_ppmv4_utils_ss.seterrorstage(l_proc, 'LOGICAL_PRIORITY CHANGE', 10);
2534: if nvl(l_o_logical_priority, to_char(hr_api.g_number)) =
2535: p_logical_priority then
2536: --
2537: -- If this is an existing PPM that has been updated then it is
2538: -- necessary to check whether or not this change will reset the PPM

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

3447: , ppm.priority priority
3448: from pay_personal_payment_methods_f ppm
3449: , pay_org_payment_methods_f opm
3450: where ppm.assignment_id = p_assignment_id
3451: and nvl(ppm.run_type_id, hr_api.g_number) = nvl(p_run_type_id, hr_api.g_number)
3452: and p_effective_date
3453: between ppm.effective_start_date and ppm.effective_end_date
3454: and opm.org_payment_method_id = ppm.org_payment_method_id
3455: and p_effective_date between

Line 3476: l_dt_mode := hr_api.g_correction;

3472: );
3473: --
3474: -- Set the correct datetrack mode.
3475: --
3476: l_dt_mode := hr_api.g_correction;
3477: if ppm.esd < p_effective_date then
3478: l_dt_mode := hr_api.g_update;
3479: end if;
3480: hr_utility.trace('Calling UPDATE from resequence_priorities');

Line 3478: l_dt_mode := hr_api.g_update;

3474: -- Set the correct datetrack mode.
3475: --
3476: l_dt_mode := hr_api.g_correction;
3477: if ppm.esd < p_effective_date then
3478: l_dt_mode := hr_api.g_update;
3479: end if;
3480: hr_utility.trace('Calling UPDATE from resequence_priorities');
3481: hr_personal_pay_method_api.update_personal_pay_method
3482: (p_validate => false

Line 3741: from hr_api_transaction_steps

3737: select creator_person_id
3738: , transaction_id
3739: into l_hr_txpersonid
3740: , l_hr_txid
3741: from hr_api_transaction_steps
3742: where transaction_step_id = p_transaction_step_id;
3743: --
3744: -- Set the processed flag for this transaction.
3745: --

Line 3760: from hr_api_transaction_values hatv

3756: --
3757: pay_ppmv4_utils_ss.seterrorstage(l_proc, 'COUNT_UNPROCESSED', 30);
3758: select count(*)
3759: into l_unprocessed
3760: from hr_api_transaction_values hatv
3761: where hatv.name = pay_ppmv4_utils_ss.C_PROCESSED_FLAG_ARG
3762: and hatv.varchar2_value = 'N'
3763: and hatv.transaction_step_id in
3764: (select transaction_step_id

Line 3765: from hr_api_transaction_steps hats

3761: where hatv.name = pay_ppmv4_utils_ss.C_PROCESSED_FLAG_ARG
3762: and hatv.varchar2_value = 'N'
3763: and hatv.transaction_step_id in
3764: (select transaction_step_id
3765: from hr_api_transaction_steps hats
3766: where hats.transaction_id = l_hr_txid);
3767: pay_ppmv4_utils_ss.seterrorstage
3768: (l_proc, 'UNPROCESSED_COUNT:' || to_char(l_unprocessed), 35);
3769: --

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

3959: , PAY_PAYMENT_TYPES PTS
3960: where opm.ORG_PAYMENT_METHOD_ID = cp_opm_id
3961: and opm.BUSINESS_GROUP_ID = cp_bgid
3962: and opm.PAYMENT_TYPE_ID = PTS.PAYMENT_TYPE_ID
3963: and leg.legislation_code = DECODE(PTS.territory_code, null, HR_API.RETURN_LEGISLATION_CODE(OPM.BUSINESS_GROUP_ID),PTS.territory_code)
3964: and leg.rule_type = 'E'
3965: and to_char(flex.id_flex_num) = leg.rule_mode
3966: and flex.id_flex_code = 'BANK';
3967:

Line 4034: and HR_API.RETURN_LEGISLATION_CODE(POPM.BUSINESS_GROUP_ID)='US'

4030: select popm.PMETH_INFORMATION9
4031: INTO l_is_foreign_transaction
4032: from pay_org_payment_methods_f popm
4033: where popm.ORG_PAYMENT_METHOD_ID = p_opm_id
4034: and HR_API.RETURN_LEGISLATION_CODE(POPM.BUSINESS_GROUP_ID)='US'
4035: AND p_effective_date
4036: BETWEEN popm.effective_start_date AND popm.effective_end_date;
4037:
4038: return nvl(l_is_foreign_transaction,'N');

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

4098: ) is
4099: select null
4100: from pay_personal_payment_methods_f ppm
4101: where ppm.assignment_id = p_assignment_id
4102: and nvl(ppm.run_type_id, hr_api.g_number) = nvl(p_run_type_id, hr_api.g_number)
4103: and ppm.effective_start_date > p_effective_date;
4104: begin
4105: p_effective_date := to_date(p_effective_date_str,hr_transaction_ss.g_date_format);
4106: open csr_future_ppms