APPS.HR_NEW_USER_REG_SS dependencies on HR_TRANSACTION_SS

Line 50: where trs.transaction_id = hr_transaction_ss.get_transaction_id

46:
47: cursor csr_txn_step_id is
48: select trs.transaction_step_id
49: from hr_api_transaction_steps trs
50: where trs.transaction_id = hr_transaction_ss.get_transaction_id
51: (WfItemType ,WfItemKey )
52: and trs.api_name ='HR_PROCESS_PERSON_SS.PROCESS_API';
53:
54: --Added for the Bug 14158934

Line 57: where hrt.transaction_id = hr_transaction_ss.get_transaction_id(WfItemType ,WfItemKey);

53:
54: --Added for the Bug 14158934
55: cursor csr_txn_status is
56: select status from hr_api_transactions hrt
57: where hrt.transaction_id = hr_transaction_ss.get_transaction_id(WfItemType ,WfItemKey);
58:
59: l_effective_date date;
60: l_session_c number;
61: l_transaction_step_id number;

Line 224: l_transaction_id := hr_transaction_ss.get_transaction_id

220: else
221: l_ignore_warnings := false;
222: end if;
223: -- get the transaction id
224: l_transaction_id := hr_transaction_ss.get_transaction_id
225: (p_item_type => p_item_type
226: ,p_item_key => p_item_key);
227: if l_transaction_id is null then
228: return;

Line 239: hr_transaction_ss.process_web_api_call

235: if(p_api_name is not null) then
236: -- process selected api step
237: for csr_sel in csr_sel_trs loop
238: begin
239: hr_transaction_ss.process_web_api_call
240: (p_transaction_step_id => csr_sel.transaction_step_id
241: ,p_api_name => csr_sel.api_name
242: ,p_validate => p_validate);
243: exception

Line 313: hr_transaction_ss.process_web_api_call

309: if p_update_object_version = 'Y' then
310: -- update object version for each step
311: l_obj_api_name := substr(i.api_name,1, instr(i.api_name,'.'));
312: l_obj_api_name := l_obj_api_name || g_update_object_version;
313: hr_transaction_ss.process_web_api_call
314: (p_transaction_step_id => i.transaction_step_id
315: ,p_api_name => l_obj_api_name
316: ,p_extra_parameter_name => 'p_login_person_id'
317: ,p_extra_parameter_value => i.creator_person_id

Line 321: hr_transaction_ss.process_web_api_call

317: ,p_extra_parameter_value => i.creator_person_id
318: ,p_validate => false);
319: elsif p_effective_date is not null then
320: --validate api with the new p_effective_date
321: hr_transaction_ss.process_web_api_call
322: (p_transaction_step_id => i.transaction_step_id
323: ,p_api_name => i.api_name
324: ,p_extra_parameter_name => 'p_effective_date'
325: ,p_extra_parameter_value => p_effective_date

Line 329: hr_transaction_ss.process_web_api_call

325: ,p_extra_parameter_value => p_effective_date
326: ,p_validate => p_validate);
327: else
328: --validate api
329: hr_transaction_ss.process_web_api_call
330: (p_transaction_step_id => i.transaction_step_id
331: ,p_api_name => i.api_name
332: ,p_validate => p_validate);
333: end if;

Line 457: l_transaction_id := hr_transaction_ss.get_transaction_id

453: l_date := nvl(l_date,trunc(sysdate));
454: open csr_person;
455: fetch csr_person into l_newUserPersonId,l_person_type_id;
456:
457: l_transaction_id := hr_transaction_ss.get_transaction_id
458: (p_item_type => WfItemType
459: ,p_item_key => WfItemKey);
460:
461: if l_transaction_id is null then

Line 544: where trs.transaction_id = hr_transaction_ss.get_transaction_id

540:
541: cursor csr_txn_step_id is
542: select trs.transaction_step_id
543: from hr_api_transaction_steps trs
544: where trs.transaction_id = hr_transaction_ss.get_transaction_id
545: (WfItemType ,WfItemKey )
546: and trs.api_name ='HR_PROCESS_PERSON_SS.PROCESS_API';
547:
548: BEGIN