APPS.HR_WORKFLOW_SS dependencies on HR_API_TRANSACTION_STEPS

Line 220: hr_utility.set_location('querying hr_api_transaction_steps.item_type for p_transaction_id:'||p_transaction_id, 2);

216: exception
217: when no_data_found then
218: -- get the data from the steps
219: if g_debug then
220: hr_utility.set_location('querying hr_api_transaction_steps.item_type for p_transaction_id:'||p_transaction_id, 2);
221: end if;
222: select ts.item_type
223: into get_item_type.c_item_type
224: from hr_api_transaction_steps ts

Line 224: from hr_api_transaction_steps ts

220: hr_utility.set_location('querying hr_api_transaction_steps.item_type for p_transaction_id:'||p_transaction_id, 2);
221: end if;
222: select ts.item_type
223: into get_item_type.c_item_type
224: from hr_api_transaction_steps ts
225: where ts.transaction_id=get_item_type.p_transaction_id
226: and ts.item_type is not null and rownum <=1;
227: end;
228:

Line 264: hr_utility.set_location('querying hr_api_transaction_steps.item_type for p_transaction_id:'||p_transaction_id, 2);

260: exception
261: when no_data_found then
262: -- get the data from the steps
263: if g_debug then
264: hr_utility.set_location('querying hr_api_transaction_steps.item_type for p_transaction_id:'||p_transaction_id, 2);
265: end if;
266: select ts.item_key
267: into get_item_key.c_item_key
268: from hr_api_transaction_steps ts

Line 268: from hr_api_transaction_steps ts

264: hr_utility.set_location('querying hr_api_transaction_steps.item_type for p_transaction_id:'||p_transaction_id, 2);
265: end if;
266: select ts.item_key
267: into get_item_key.c_item_key
268: from hr_api_transaction_steps ts
269: where ts.transaction_id=get_item_key.p_transaction_id
270: and ts.item_type is not null and rownum <=1;
271: end;
272:

Line 791: l_asg_txn_step_id hr_api_transaction_steps.transaction_step_id%type

787: l_new_pay_basis_id per_all_assignments_f.pay_basis_id%type default null;
788: l_pay_period_start_date date default null;
789: l_pay_period_end_date date default null;
790:
791: l_asg_txn_step_id hr_api_transaction_steps.transaction_step_id%type
792: default null;
793: l_effective_date date default null;
794:
795:

Line 812: from hr_api_transaction_steps trs

808: ,trs.item_type
809: ,trs.item_key
810: ,trs.activity_id
811: ,trs.creator_person_id
812: from hr_api_transaction_steps trs
813: where trs.item_type = p_item_type
814: and trs.item_key = p_item_key
815: order by trs.processing_order
816: ,trs.transaction_step_id ; --#2313279

Line 2486: select * from hr_api_transaction_steps where transaction_id = l_txn_id

2482: l_creator_person_id number;
2483: l_organization_name varchar2(500) default null;
2484: cursor csr_txn_steps
2485: IS
2486: select * from hr_api_transaction_steps where transaction_id = l_txn_id
2487: and api_name = 'HR_CCMGR_SS.PROCESS_API';
2488: type transaction_type is table of hr_api_transaction_steps%rowtype;
2489: txn_steps_rc transaction_type;
2490: l_counter number default 0;

Line 2488: type transaction_type is table of hr_api_transaction_steps%rowtype;

2484: cursor csr_txn_steps
2485: IS
2486: select * from hr_api_transaction_steps where transaction_id = l_txn_id
2487: and api_name = 'HR_CCMGR_SS.PROCESS_API';
2488: type transaction_type is table of hr_api_transaction_steps%rowtype;
2489: txn_steps_rc transaction_type;
2490: l_counter number default 0;
2491:
2492: cursor is_term_txn is

Line 2493: select transaction_step_id from hr_api_transaction_steps where transaction_id = l_txn_id

2489: txn_steps_rc transaction_type;
2490: l_counter number default 0;
2491:
2492: cursor is_term_txn is
2493: select transaction_step_id from hr_api_transaction_steps where transaction_id = l_txn_id
2494: and api_name = 'HR_TERMINATION_SS.PROCESS_API';
2495: l_term_txn number;
2496:
2497: begin