DBA Data[Home] [Help]

APPS.HR_NEW_USER_REG_SS dependencies on HR_API_TRANSACTION_STEPS

Line 49: from hr_api_transaction_steps trs

45: cursor csr_person is select person_id from per_all_people_f where person_id = PersonId;
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:

Line 195: from hr_api_transaction_steps trs

191: ,trs.item_type
192: ,trs.item_key
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',

Line 211: from hr_api_transaction_steps trs

207: ,trs.item_type
208: ,trs.item_key
209: ,trs.activity_id
210: ,trs.creator_person_id
211: from hr_api_transaction_steps trs
212: where trs.transaction_id = l_transaction_id
213: and trs.api_name = p_api_name
214: order by trs.processing_order;
215:

Line 543: from hr_api_transaction_steps trs

539: and fs.application_id(+) = 801;
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: