[Home] [Help]
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
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:
259: exception
260: when no_data_found then
261: -- get the data from the steps
262: if g_debug then
263: hr_utility.set_location('querying hr_api_transaction_steps.item_type for p_transaction_id:'||p_transaction_id, 2);
264: end if;
265: select ts.item_key
266: into get_item_key.c_item_key
267: from hr_api_transaction_steps ts
263: hr_utility.set_location('querying hr_api_transaction_steps.item_type for p_transaction_id:'||p_transaction_id, 2);
264: end if;
265: select ts.item_key
266: into get_item_key.c_item_key
267: from hr_api_transaction_steps ts
268: where ts.transaction_id=get_item_key.p_transaction_id
269: and ts.item_type is not null and rownum <=1;
270: end;
271:
753: l_new_pay_basis_id per_all_assignments_f.pay_basis_id%type default null;
754: l_pay_period_start_date date default null;
755: l_pay_period_end_date date default null;
756:
757: l_asg_txn_step_id hr_api_transaction_steps.transaction_step_id%type
758: default null;
759: l_effective_date date default null;
760:
761:
774: ,trs.item_type
775: ,trs.item_key
776: ,trs.activity_id
777: ,trs.creator_person_id
778: from hr_api_transaction_steps trs
779: where trs.item_type = p_item_type
780: and trs.item_key = p_item_key
781: order by trs.processing_order
782: ,trs.transaction_step_id ; --#2313279