DBA Data[Home] [Help]

APPS.HR_NEW_USER_REG_SS dependencies on HR_PROCESS_PERSON_SS

Line 52: and trs.api_name ='HR_PROCESS_PERSON_SS.PROCESS_API';

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

Line 100: -- the commit process will call Process_api of hr_process_person_ss which

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

Line 142: -- the commit process will call Process_api of hr_process_person_ss which

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);

Line 145: PersonId := to_char(hr_process_person_ss.g_person_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;

Line 146: AssignmentId := to_char(hr_process_person_ss.g_assignment_id);

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:

Line 197: and trs.api_name in ('HR_PROCESS_PERSON_SS.PROCESS_API',

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;

Line 232: hr_process_person_ss.g_person_id := null;

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

Line 233: hr_process_person_ss.g_assignment_id := null;

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

Line 266: -- is not in the per_person_list table. In hr_process_person_ss.

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

Line 375: -- is not in the per_person_list table. In hr_process_person_ss.

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

Line 505: PersonId := to_char(hr_process_person_ss.g_person_id);

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;

Line 506: AssignmentId := to_char(hr_process_person_ss.g_assignment_id);

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:

Line 546: and trs.api_name ='HR_PROCESS_PERSON_SS.PROCESS_API';

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;