APPS.OTA_COMPETENCE_SS dependencies on HR_TRANSACTION_SS

Line 269: l_transaction_table hr_transaction_ss.transaction_table;

265: l_transaction_id number default null;
266: l_transaction_step_id number default null;
267: l_trans_obj_vers_num number default null;
268: l_count integer default 0;
269: l_transaction_table hr_transaction_ss.transaction_table;
270: l_review_item_name varchar2(50);
271: l_message_number VARCHAR2(10);
272: l_result varchar2(100) default null;
273: l_old_transaction_step_id number;

Line 286: l_transaction_id := hr_transaction_ss.get_transaction_id

282:
283: begin
284:
285: -- First, check if transaction id exists or not
286: l_transaction_id := hr_transaction_ss.get_transaction_id
287: (p_item_type => p_item_type
288: ,p_item_key => p_item_key);
289: --
290: IF l_transaction_id is null THEN

Line 292: hr_transaction_ss.start_transaction

288: ,p_item_key => p_item_key);
289: --
290: IF l_transaction_id is null THEN
291: -- Start a Transaction
292: hr_transaction_ss.start_transaction
293: (itemtype => p_item_type
294: ,itemkey => p_item_key
295: ,actid => l_activity_id --not used
296: ,funmode => 'RUN'

Line 301: l_transaction_id := hr_transaction_ss.get_transaction_id

297: ,p_login_person_id => p_person_id
298: ,p_function_id => 0--not available in api
299: ,result => l_result);
300:
301: l_transaction_id := hr_transaction_ss.get_transaction_id
302: (p_item_type => p_item_type
303: ,p_item_key => p_item_key);
304:
305: END IF;

Line 446: hr_transaction_ss.save_transaction_step

442: 'OTA_TRANSACTION_STEP_ID',
443: l_transaction_step_id);
444:
445: hr_utility.set_location('Before save transaction step'||l_proc, 5);
446: hr_transaction_ss.save_transaction_step
447: (p_item_type => p_item_type
448: ,p_item_key => p_item_key
449: ,p_actid => l_activity_id
450: ,p_login_person_id => p_person_id

Line 577: p_transaction_id => hr_transaction_ss.get_transaction_id

573: ,avalue => nvl(l_error_text, sqlerrm));
574: hr_utility.trace('l_error_text' || nvl(l_error_text, sqlerrm));
575: -- update the transaction table status
576: hr_transaction_api.update_transaction(
577: p_transaction_id => hr_transaction_ss.get_transaction_id
578: (p_item_type => itemtype
579: ,p_item_key => itemkey),
580: p_status => 'E');
581:

Line 667: p_transaction_id => hr_transaction_ss.get_transaction_id

663: ,avalue => nvl(l_error_text, sqlerrm));
664: hr_utility.trace('l_error_text' || nvl(l_error_text, sqlerrm));
665: -- update the transaction table status
666: hr_transaction_api.update_transaction(
667: p_transaction_id => hr_transaction_ss.get_transaction_id
668: (p_item_type => itemtype
669: ,p_item_key => itemkey),
670: p_status => 'E');
671: