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.PQH_PTX_UTL dependencies on HR_GENERAL

Line 2593: hr_general.decode_organization(organization_id),

2589: l_organization_desc varchar2(2000);
2590: l_job_desc varchar2(2000);
2591: l_transaction_status varchar2(100);
2592: cursor c0 is select name, action_date,
2593: hr_general.decode_organization(organization_id),
2594: hr_general.decode_job(job_id),
2595: hr_general.decode_lookup('PQH_TRANSACTION_STATUS', transaction_status)
2596: from pqh_position_transactions
2597: where position_transaction_id = p_transaction_id;

Line 2594: hr_general.decode_job(job_id),

2590: l_job_desc varchar2(2000);
2591: l_transaction_status varchar2(100);
2592: cursor c0 is select name, action_date,
2593: hr_general.decode_organization(organization_id),
2594: hr_general.decode_job(job_id),
2595: hr_general.decode_lookup('PQH_TRANSACTION_STATUS', transaction_status)
2596: from pqh_position_transactions
2597: where position_transaction_id = p_transaction_id;
2598: BEGIN

Line 2595: hr_general.decode_lookup('PQH_TRANSACTION_STATUS', transaction_status)

2591: l_transaction_status varchar2(100);
2592: cursor c0 is select name, action_date,
2593: hr_general.decode_organization(organization_id),
2594: hr_general.decode_job(job_id),
2595: hr_general.decode_lookup('PQH_TRANSACTION_STATUS', transaction_status)
2596: from pqh_position_transactions
2597: where position_transaction_id = p_transaction_id;
2598: BEGIN
2599: hr_utility.set_location('inside fyi notification'||l_proc,10);

Line 2634: hr_general.decode_organization(organization_id),

2630: l_organization_desc varchar2(2000);
2631: l_job_desc varchar2(2000);
2632: l_transaction_status varchar2(100);
2633: cursor c0 is select name, action_date,
2634: hr_general.decode_organization(organization_id),
2635: hr_general.decode_job(job_id),
2636: hr_general.decode_lookup('PQH_TRANSACTION_STATUS', transaction_status)
2637: from pqh_position_transactions
2638: where position_transaction_id = p_transaction_id;

Line 2635: hr_general.decode_job(job_id),

2631: l_job_desc varchar2(2000);
2632: l_transaction_status varchar2(100);
2633: cursor c0 is select name, action_date,
2634: hr_general.decode_organization(organization_id),
2635: hr_general.decode_job(job_id),
2636: hr_general.decode_lookup('PQH_TRANSACTION_STATUS', transaction_status)
2637: from pqh_position_transactions
2638: where position_transaction_id = p_transaction_id;
2639: BEGIN

Line 2636: hr_general.decode_lookup('PQH_TRANSACTION_STATUS', transaction_status)

2632: l_transaction_status varchar2(100);
2633: cursor c0 is select name, action_date,
2634: hr_general.decode_organization(organization_id),
2635: hr_general.decode_job(job_id),
2636: hr_general.decode_lookup('PQH_TRANSACTION_STATUS', transaction_status)
2637: from pqh_position_transactions
2638: where position_transaction_id = p_transaction_id;
2639: BEGIN
2640: hr_utility.set_location('inside back notification'||l_proc,10);

Line 2675: hr_general.decode_organization(organization_id),

2671: l_organization_desc varchar2(2000);
2672: l_job_desc varchar2(2000);
2673: l_transaction_status varchar2(100);
2674: cursor c0 is select name, action_date,
2675: hr_general.decode_organization(organization_id),
2676: hr_general.decode_job(job_id),
2677: hr_general.decode_lookup('PQH_TRANSACTION_STATUS', transaction_status)
2678: from pqh_position_transactions
2679: where position_transaction_id = p_transaction_id;

Line 2676: hr_general.decode_job(job_id),

2672: l_job_desc varchar2(2000);
2673: l_transaction_status varchar2(100);
2674: cursor c0 is select name, action_date,
2675: hr_general.decode_organization(organization_id),
2676: hr_general.decode_job(job_id),
2677: hr_general.decode_lookup('PQH_TRANSACTION_STATUS', transaction_status)
2678: from pqh_position_transactions
2679: where position_transaction_id = p_transaction_id;
2680: BEGIN

Line 2677: hr_general.decode_lookup('PQH_TRANSACTION_STATUS', transaction_status)

2673: l_transaction_status varchar2(100);
2674: cursor c0 is select name, action_date,
2675: hr_general.decode_organization(organization_id),
2676: hr_general.decode_job(job_id),
2677: hr_general.decode_lookup('PQH_TRANSACTION_STATUS', transaction_status)
2678: from pqh_position_transactions
2679: where position_transaction_id = p_transaction_id;
2680: BEGIN
2681: hr_utility.set_location('inside override notification'||l_proc,10);

Line 2716: hr_general.decode_organization(organization_id),

2712: l_organization_desc varchar2(2000);
2713: l_job_desc varchar2(2000);
2714: l_transaction_status varchar2(100);
2715: cursor c0 is select name, action_date,
2716: hr_general.decode_organization(organization_id),
2717: hr_general.decode_job(job_id),
2718: hr_general.decode_lookup('PQH_TRANSACTION_STATUS', transaction_status)
2719: from pqh_position_transactions
2720: where position_transaction_id = p_transaction_id;

Line 2717: hr_general.decode_job(job_id),

2713: l_job_desc varchar2(2000);
2714: l_transaction_status varchar2(100);
2715: cursor c0 is select name, action_date,
2716: hr_general.decode_organization(organization_id),
2717: hr_general.decode_job(job_id),
2718: hr_general.decode_lookup('PQH_TRANSACTION_STATUS', transaction_status)
2719: from pqh_position_transactions
2720: where position_transaction_id = p_transaction_id;
2721: BEGIN

Line 2718: hr_general.decode_lookup('PQH_TRANSACTION_STATUS', transaction_status)

2714: l_transaction_status varchar2(100);
2715: cursor c0 is select name, action_date,
2716: hr_general.decode_organization(organization_id),
2717: hr_general.decode_job(job_id),
2718: hr_general.decode_lookup('PQH_TRANSACTION_STATUS', transaction_status)
2719: from pqh_position_transactions
2720: where position_transaction_id = p_transaction_id;
2721: BEGIN
2722: hr_utility.set_location('inside apply notification'||l_proc,10);

Line 2757: hr_general.decode_organization(organization_id),

2753: l_organization_desc varchar2(2000);
2754: l_job_desc varchar2(2000);
2755: l_transaction_status varchar2(100);
2756: cursor c0 is select name, action_date,
2757: hr_general.decode_organization(organization_id),
2758: hr_general.decode_job(job_id),
2759: hr_general.decode_lookup('PQH_TRANSACTION_STATUS', transaction_status)
2760: from pqh_position_transactions
2761: where position_transaction_id = p_transaction_id;

Line 2758: hr_general.decode_job(job_id),

2754: l_job_desc varchar2(2000);
2755: l_transaction_status varchar2(100);
2756: cursor c0 is select name, action_date,
2757: hr_general.decode_organization(organization_id),
2758: hr_general.decode_job(job_id),
2759: hr_general.decode_lookup('PQH_TRANSACTION_STATUS', transaction_status)
2760: from pqh_position_transactions
2761: where position_transaction_id = p_transaction_id;
2762: BEGIN

Line 2759: hr_general.decode_lookup('PQH_TRANSACTION_STATUS', transaction_status)

2755: l_transaction_status varchar2(100);
2756: cursor c0 is select name, action_date,
2757: hr_general.decode_organization(organization_id),
2758: hr_general.decode_job(job_id),
2759: hr_general.decode_lookup('PQH_TRANSACTION_STATUS', transaction_status)
2760: from pqh_position_transactions
2761: where position_transaction_id = p_transaction_id;
2762: BEGIN
2763: hr_utility.set_location('inside reject notification'||l_proc,10);

Line 2798: hr_general.decode_organization(organization_id),

2794: l_organization_desc varchar2(2000);
2795: l_job_desc varchar2(2000);
2796: l_transaction_status varchar2(100);
2797: cursor c0 is select name, action_date,
2798: hr_general.decode_organization(organization_id),
2799: hr_general.decode_job(job_id),
2800: hr_general.decode_lookup('PQH_TRANSACTION_STATUS', transaction_status)
2801: from pqh_position_transactions
2802: where position_transaction_id = p_transaction_id;

Line 2799: hr_general.decode_job(job_id),

2795: l_job_desc varchar2(2000);
2796: l_transaction_status varchar2(100);
2797: cursor c0 is select name, action_date,
2798: hr_general.decode_organization(organization_id),
2799: hr_general.decode_job(job_id),
2800: hr_general.decode_lookup('PQH_TRANSACTION_STATUS', transaction_status)
2801: from pqh_position_transactions
2802: where position_transaction_id = p_transaction_id;
2803: BEGIN

Line 2800: hr_general.decode_lookup('PQH_TRANSACTION_STATUS', transaction_status)

2796: l_transaction_status varchar2(100);
2797: cursor c0 is select name, action_date,
2798: hr_general.decode_organization(organization_id),
2799: hr_general.decode_job(job_id),
2800: hr_general.decode_lookup('PQH_TRANSACTION_STATUS', transaction_status)
2801: from pqh_position_transactions
2802: where position_transaction_id = p_transaction_id;
2803: BEGIN
2804: hr_utility.set_location('inside warning notification'||l_proc,10);

Line 2839: hr_general.decode_organization(organization_id),

2835: l_organization_desc varchar2(2000);
2836: l_job_desc varchar2(2000);
2837: l_transaction_status varchar2(100);
2838: cursor c0 is select name, action_date,
2839: hr_general.decode_organization(organization_id),
2840: hr_general.decode_job(job_id),
2841: hr_general.decode_lookup('PQH_TRANSACTION_STATUS', transaction_status)
2842: from pqh_position_transactions
2843: where position_transaction_id = p_transaction_id;

Line 2840: hr_general.decode_job(job_id),

2836: l_job_desc varchar2(2000);
2837: l_transaction_status varchar2(100);
2838: cursor c0 is select name, action_date,
2839: hr_general.decode_organization(organization_id),
2840: hr_general.decode_job(job_id),
2841: hr_general.decode_lookup('PQH_TRANSACTION_STATUS', transaction_status)
2842: from pqh_position_transactions
2843: where position_transaction_id = p_transaction_id;
2844: BEGIN

Line 2841: hr_general.decode_lookup('PQH_TRANSACTION_STATUS', transaction_status)

2837: l_transaction_status varchar2(100);
2838: cursor c0 is select name, action_date,
2839: hr_general.decode_organization(organization_id),
2840: hr_general.decode_job(job_id),
2841: hr_general.decode_lookup('PQH_TRANSACTION_STATUS', transaction_status)
2842: from pqh_position_transactions
2843: where position_transaction_id = p_transaction_id;
2844: BEGIN
2845: hr_utility.set_location('inside respond notification'||l_proc,10);

Line 3612: and nvl(fnd_date.canonical_to_date(poei_information4),hr_general.end_of_time);

3608: where position_id = p_position_id
3609: and information_type= 'PER_RESERVED'
3610: and p_effective_date
3611: between fnd_date.canonical_to_date(poei_information3)
3612: and nvl(fnd_date.canonical_to_date(poei_information4),hr_general.end_of_time);
3613: --
3614: cursor csr_valid_eff_date(p_position_id number, p_validation_start_date date, p_validation_end_date date) is
3615: select p_validation_start_date start_date
3616: from dual

Line 3755: where business_group_id = hr_general.get_business_group_id;

3751: p_unit3_precision OUT NOCOPY varchar2) as
3752: --
3753: cursor c1 is select currency_code
3754: from per_business_groups
3755: where business_group_id = hr_general.get_business_group_id;
3756: --
3757: cursor b1(p_budget_id number) is
3758: select currency_code, budget_unit1_id, budget_unit2_id, budget_unit3_id,
3759: pqh_wks_budget.get_unit_type(budget_unit1_id),