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
55: cursor csr_txn_status is
56: select status from hr_api_transactions hrt
96: itemkey=>WfItemKey,
97: actid=>'12345', -- can hard code this to anything this is not being used inside the call
98: funmode=>'RUN', -- the necessary mode to run the api in commit mode
99: result=>l_result); -- though we are getting the error results back we are not using them.
100: -- the commit process will call Process_api of hr_process_person_ss which
101: */
102: /* Replaced commit_transaction with process_selected_transaction, commit transaction will
103: call all the steps for a given item key. However we need only person and address apis
104: are
138: process_selected_transaction
139: (p_item_type => WfItemType,
140: p_item_key => WfItemKey);
141:
142: -- the commit process will call Process_api of hr_process_person_ss which
143: -- creates a person and returns us the person id and assignment_id.
144:
145: PersonId := to_char(hr_process_person_ss.g_person_id);
146: AssignmentId := to_char(hr_process_person_ss.g_assignment_id);
141:
142: -- the commit process will call Process_api of hr_process_person_ss which
143: -- creates a person and returns us the person id and assignment_id.
144:
145: PersonId := to_char(hr_process_person_ss.g_person_id);
146: AssignmentId := to_char(hr_process_person_ss.g_assignment_id);
147: end if;
148: -- close the cursor
149: close csr_person;
142: -- the commit process will call Process_api of hr_process_person_ss which
143: -- creates a person and returns us the person id and assignment_id.
144:
145: PersonId := to_char(hr_process_person_ss.g_person_id);
146: AssignmentId := to_char(hr_process_person_ss.g_assignment_id);
147: end if;
148: -- close the cursor
149: close csr_person;
150:
193: ,trs.activity_id
194: ,trs.creator_person_id
195: from hr_api_transaction_steps trs
196: where trs.transaction_id = l_transaction_id
197: and trs.api_name in ('HR_PROCESS_PERSON_SS.PROCESS_API',
198: 'HR_PROCESS_ADDRESS_SS.PROCESS_API',
199: 'HR_PROCESS_ASSIGNMENT_SS.PROCESS_API',
200: 'HR_PROCESS_CONTACT_SS.PROCESS_CREATE_CONTACT_API')
201: order by trs.processing_order,trs.transaction_step_id;
228: return;
229: end if;
230:
231:
232: hr_process_person_ss.g_person_id := null;
233: hr_process_person_ss.g_assignment_id := null;
234:
235: if(p_api_name is not null) then
236: -- process selected api step
229: end if;
230:
231:
232: hr_process_person_ss.g_person_id := null;
233: hr_process_person_ss.g_assignment_id := null;
234:
235: if(p_api_name is not null) then
236: -- process selected api step
237: for csr_sel in csr_sel_trs loop
262: -- Business Group profile option is null and Cross Business Group
263: -- equals to 'N', you will get an Application Error after the final
264: -- approver approves the transaction. This problem usually happens
265: -- in New Hire or Applicant Hire whereby the new employee created
266: -- is not in the per_person_list table. In hr_process_person_ss.
267: -- process_api, it call hr_employee_api.create_employee which
268: -- eventually will call dt_api.return_min_start_date. This
269: -- dt_api.return_min_start_date accesses the per_people_f secured
270: -- view, you will get HR_7182_DT_NO_MIN_MAX_ROWS error with the
371: -- Business Group profile option is null and Cross Business Group
372: -- equals to 'N', you will get an Application Error after the final
373: -- approver approves the transaction. This problem usually happens
374: -- in New Hire or Applicant Hire whereby the new employee created
375: -- is not in the per_person_list table. In hr_process_person_ss.
376: -- process_api, it call hr_employee_api.create_employee which
377: -- eventually will call dt_api.return_min_start_date. This
378: -- dt_api.return_min_start_date accesses the per_people_f secured
379: -- view, you will get HR_7182_DT_NO_MIN_MAX_ROWS error with the
501: process_selected_transaction
502: (p_item_type => WfItemType,
503: p_item_key => WfItemKey,
504: p_source => p_source);
505: PersonId := to_char(hr_process_person_ss.g_person_id);
506: AssignmentId := to_char(hr_process_person_ss.g_assignment_id);
507:
508: end if;
509: close csr_person;
502: (p_item_type => WfItemType,
503: p_item_key => WfItemKey,
504: p_source => p_source);
505: PersonId := to_char(hr_process_person_ss.g_person_id);
506: AssignmentId := to_char(hr_process_person_ss.g_assignment_id);
507:
508: end if;
509: close csr_person;
510:
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
549:
550: l_bg_id := p_bg_id;