[Home] [Help]
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:
55: l_transaction_step_id number;
56: l_business_grp_Id number;
76: itemkey=>WfItemKey,
77: actid=>'12345', -- can hard code this to anything this is not being used inside the call
78: funmode=>'RUN', -- the necessary mode to run the api in commit mode
79: result=>l_result); -- though we are getting the error results back we are not using them.
80: -- the commit process will call Process_api of hr_process_person_ss which
81: */
82: /* Replaced commit_transaction with process_selected_transaction, commit transaction will
83: call all the steps for a given item key. However we need only person and address apis
84: are
110: process_selected_transaction
111: (p_item_type => WfItemType,
112: p_item_key => WfItemKey);
113:
114: -- the commit process will call Process_api of hr_process_person_ss which
115: -- creates a person and returns us the person id and assignment_id.
116:
117:
118:
115: -- creates a person and returns us the person id and assignment_id.
116:
117:
118:
119: PersonId := to_char(hr_process_person_ss.g_person_id);
120: AssignmentId := to_char(hr_process_person_ss.g_assignment_id);
121: end if;
122: -- close the cursor
123: close csr_person;
116:
117:
118:
119: PersonId := to_char(hr_process_person_ss.g_person_id);
120: AssignmentId := to_char(hr_process_person_ss.g_assignment_id);
121: end if;
122: -- close the cursor
123: close csr_person;
124:
161: ,trs.activity_id
162: ,trs.creator_person_id
163: from hr_api_transaction_steps trs
164: where trs.transaction_id = l_transaction_id
165: and trs.api_name in ('HR_PROCESS_PERSON_SS.PROCESS_API',
166: 'HR_PROCESS_ADDRESS_SS.PROCESS_API',
167: 'HR_PROCESS_ASSIGNMENT_SS.PROCESS_API',
168: 'HR_PROCESS_CONTACT_SS.PROCESS_CREATE_CONTACT_API')
169: order by trs.processing_order,trs.transaction_step_id;
196: return;
197: end if;
198:
199:
200: hr_process_person_ss.g_person_id := null;
201: hr_process_person_ss.g_assignment_id := null;
202:
203: if(p_api_name is not null) then
204: -- process selected api step
197: end if;
198:
199:
200: hr_process_person_ss.g_person_id := null;
201: hr_process_person_ss.g_assignment_id := null;
202:
203: if(p_api_name is not null) then
204: -- process selected api step
205: for csr_sel in csr_sel_trs loop
230: -- Business Group profile option is null and Cross Business Group
231: -- equals to 'N', you will get an Application Error after the final
232: -- approver approves the transaction. This problem usually happens
233: -- in New Hire or Applicant Hire whereby the new employee created
234: -- is not in the per_person_list table. In hr_process_person_ss.
235: -- process_api, it call hr_employee_api.create_employee which
236: -- eventually will call dt_api.return_min_start_date. This
237: -- dt_api.return_min_start_date accesses the per_people_f secured
238: -- view, you will get HR_7182_DT_NO_MIN_MAX_ROWS error with the
334: -- Business Group profile option is null and Cross Business Group
335: -- equals to 'N', you will get an Application Error after the final
336: -- approver approves the transaction. This problem usually happens
337: -- in New Hire or Applicant Hire whereby the new employee created
338: -- is not in the per_person_list table. In hr_process_person_ss.
339: -- process_api, it call hr_employee_api.create_employee which
340: -- eventually will call dt_api.return_min_start_date. This
341: -- dt_api.return_min_start_date accesses the per_people_f secured
342: -- view, you will get HR_7182_DT_NO_MIN_MAX_ROWS error with the