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 2414: select processing_order from hr_api_transaction_steps where

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

Line 2418: select transaction_step_id,activity_id from hr_api_transaction_steps where

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

Line 2422: select null from hr_api_transaction_steps where

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

Line 2441: select transaction_step_id from hr_api_transaction_steps

2437: all_pgp_null varchar2(2) := 'N';
2438: all_scl_null varchar2(2) := 'N';
2439:
2440: cursor csr_per_step_id is
2441: select transaction_step_id from hr_api_transaction_steps
2442: where item_type=l_item_type and item_key=l_item_key
2443: and api_name='HR_PROCESS_PERSON_SS.PROCESS_API';
2444: l_per_step_id number;
2445: l_asgn_change_mode varchar2(2);

Line 6060: FROM hr_api_transaction_steps

6056: and effective_end_date;
6057:
6058: CURSOR cur_txnStep (c_txnStepId NUMBER ) IS
6059: SELECT item_type,item_key
6060: FROM hr_api_transaction_steps
6061: WHERE transaction_step_id = c_txnStepId;
6062:
6063: l_item_type varchar2(50);
6064: l_item_key varchar2(50);

Line 6068: select transaction_step_id from hr_api_transaction_steps

6064: l_item_key varchar2(50);
6065: l_rehire_flow varchar2(10) default null;
6066:
6067: cursor csr_per_step_id is
6068: select transaction_step_id from hr_api_transaction_steps
6069: where item_type=l_item_type and item_key=l_item_key
6070: and api_name='HR_PROCESS_PERSON_SS.PROCESS_API';
6071: l_per_step_id number;
6072: l_asgn_change_mode varchar2(2);

Line 7949: hr_api_transaction_steps ts

7945: l_old_pay_basis_id old_pay_basis_id,
7946: l_old_grade_id old_grade_id,
7947: l_primary_flag primary_flag
7948: from
7949: hr_api_transaction_steps ts
7950: ,hr_api_transaction_values otv, hr_all_organization_units_tl org
7951: ,hr_api_transaction_values jtv, per_jobs_tl job
7952: ,hr_api_transaction_values ptv, hr_all_positions_f_tl pos
7953: ,hr_api_transaction_values gtv, per_grades_tl grade