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.HR_H2PI_PERSON_UPLOAD dependencies on PER_PAY_PROPOSALS

Line 2488: FROM per_pay_proposals ppp

2484: AND ppp.client_id = p_from_client_id;
2485:
2486: CURSOR csr_ed_salary (p_ppp_id NUMBER) IS
2487: SELECT object_version_number
2488: FROM per_pay_proposals ppp
2489: WHERE ppp.pay_proposal_id = p_ppp_id;
2490:
2491: CURSOR csr_sal_ee (p_asg_id NUMBER,
2492: p_date DATE) IS

Line 2503: l_assignment_id per_pay_proposals.assignment_id%TYPE;

2499: l_proc VARCHAR2(72) := g_package||'upload_salary';
2500:
2501: l_encoded_message VARCHAR2(200);
2502:
2503: l_assignment_id per_pay_proposals.assignment_id%TYPE;
2504: l_pay_proposal_id per_pay_proposals.pay_proposal_id%TYPE;
2505: l_ovn per_pay_proposals.object_version_number%TYPE;
2506: v_ud_ppp hr_h2pi_salaries%ROWTYPE;
2507:

Line 2504: l_pay_proposal_id per_pay_proposals.pay_proposal_id%TYPE;

2500:
2501: l_encoded_message VARCHAR2(200);
2502:
2503: l_assignment_id per_pay_proposals.assignment_id%TYPE;
2504: l_pay_proposal_id per_pay_proposals.pay_proposal_id%TYPE;
2505: l_ovn per_pay_proposals.object_version_number%TYPE;
2506: v_ud_ppp hr_h2pi_salaries%ROWTYPE;
2507:
2508: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;

Line 2505: l_ovn per_pay_proposals.object_version_number%TYPE;

2501: l_encoded_message VARCHAR2(200);
2502:
2503: l_assignment_id per_pay_proposals.assignment_id%TYPE;
2504: l_pay_proposal_id per_pay_proposals.pay_proposal_id%TYPE;
2505: l_ovn per_pay_proposals.object_version_number%TYPE;
2506: v_ud_ppp hr_h2pi_salaries%ROWTYPE;
2507:
2508: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
2509: l_inv_next_sal_date_warning BOOLEAN;

Line 2527: (p_table_name => 'PER_PAY_PROPOSALS',

2523: p_report_error => TRUE);
2524:
2525: hr_utility.set_location(l_proc, 20);
2526: l_pay_proposal_id := hr_h2pi_map.get_to_id
2527: (p_table_name => 'PER_PAY_PROPOSALS',
2528: p_from_id => v_ud_ppp.pay_proposal_id);
2529:
2530: OPEN csr_sal_ee(l_assignment_id,
2531: v_ud_ppp.change_date);

Line 2581: (p_table_name => 'PER_PAY_PROPOSALS',

2577: hr_utility.set_location(l_proc || ' 2. Proposed_salary_n..' || v_ud_ppp.proposed_salary_n, 103);
2578: hr_utility.set_location(l_proc || ' 2. Change_Date..' || v_ud_ppp.change_date, 104);
2579: hr_utility.set_location(l_proc, 40);
2580: hr_h2pi_map.create_id_mapping
2581: (p_table_name => 'PER_PAY_PROPOSALS',
2582: p_from_id => v_ud_ppp.pay_proposal_id,
2583: p_to_id => l_pay_proposal_id);
2584:
2585: ELSE