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_PROCESS_ASSIGNMENT_SS dependencies on HR_API_TRANSACTION_STEPS

Line 2240: l_item_type hr_api_transaction_steps.item_type%TYPE;

2236:
2237: ) is
2238: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
2239: l_person_id per_all_assignments_f.person_id%TYPE;
2240: l_item_type hr_api_transaction_steps.item_type%TYPE;
2241: l_item_key hr_api_transaction_steps.item_key%TYPE;
2242: l_activity_id hr_api_transaction_steps.activity_id%TYPE;
2243: l_effective_date date;
2244: l_effective_start_date date;

Line 2241: l_item_key hr_api_transaction_steps.item_key%TYPE;

2237: ) is
2238: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
2239: l_person_id per_all_assignments_f.person_id%TYPE;
2240: l_item_type hr_api_transaction_steps.item_type%TYPE;
2241: l_item_key hr_api_transaction_steps.item_key%TYPE;
2242: l_activity_id hr_api_transaction_steps.activity_id%TYPE;
2243: l_effective_date date;
2244: l_effective_start_date date;
2245: l_effective_end_date date;

Line 2242: l_activity_id hr_api_transaction_steps.activity_id%TYPE;

2238: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
2239: l_person_id per_all_assignments_f.person_id%TYPE;
2240: l_item_type hr_api_transaction_steps.item_type%TYPE;
2241: l_item_key hr_api_transaction_steps.item_key%TYPE;
2242: l_activity_id hr_api_transaction_steps.activity_id%TYPE;
2243: l_effective_date date;
2244: l_effective_start_date date;
2245: l_effective_end_date date;
2246: l_transaction_id number;

Line 2412: select processing_order from hr_api_transaction_steps where

2408: from per_all_assignments_f
2409: where assignment_id = p_assignment_id;
2410:
2411: cursor process_order(l_item_type in varchar2,l_item_key in varchar2) is
2412: select processing_order from hr_api_transaction_steps where
2413: item_type=l_item_type and item_key=l_item_key and api_name='HR_SUPERVISOR_SS.PROCESS_API';
2414:
2415: cursor pay_step(l_item_type in varchar2,l_item_key in varchar2) is --bug6405208
2416: select transaction_step_id,activity_id from hr_api_transaction_steps where

Line 2416: select transaction_step_id,activity_id from hr_api_transaction_steps where

2412: select processing_order from hr_api_transaction_steps where
2413: item_type=l_item_type and item_key=l_item_key and api_name='HR_SUPERVISOR_SS.PROCESS_API';
2414:
2415: cursor pay_step(l_item_type in varchar2,l_item_key in varchar2) is --bug6405208
2416: select transaction_step_id,activity_id from hr_api_transaction_steps where
2417: item_type=l_item_type and item_key=l_item_key and api_name='HR_PAY_RATE_SS.PROCESS_API';
2418:
2419: cursor step_grade_step(l_item_type in varchar2,l_item_key in varchar2) is
2420: select null from hr_api_transaction_steps where

Line 2420: select null from hr_api_transaction_steps where

2416: select transaction_step_id,activity_id from hr_api_transaction_steps where
2417: item_type=l_item_type and item_key=l_item_key and api_name='HR_PAY_RATE_SS.PROCESS_API';
2418:
2419: cursor step_grade_step(l_item_type in varchar2,l_item_key in varchar2) is
2420: select null from hr_api_transaction_steps where
2421: item_type=l_item_type and item_key=l_item_key and api_name='HR_PROCESS_ASSIGNMENT_STEP_SS.PROCESS_API';
2422:
2423: --
2424: begin

Line 7466: hr_api_transaction_steps ts

7462: l_old_organization_id old_organization_id,
7463: l_old_pay_basis_id old_pay_basis_id,
7464: l_old_grade_id old_grade_id
7465: from
7466: hr_api_transaction_steps ts
7467: ,hr_api_transaction_values otv, hr_all_organization_units_tl org
7468: ,hr_api_transaction_values jtv, per_jobs_tl job
7469: ,hr_api_transaction_values ptv, hr_all_positions_f_tl pos
7470: ,hr_api_transaction_values gtv, per_grades_tl grade