DBA Data[Home] [Help]

APPS.HR_PROCESS_SIT_SS dependencies on HR_API

Line 721: ,p_date_from in date default hr_api.g_date

717: (p_validate in number default 1
718: ,p_person_id in number
719: ,p_person_analysis_id in number
720: ,p_pea_object_version_number in out nocopy number
721: ,p_date_from in date default hr_api.g_date
722: ,p_date_to in date default hr_api.g_date
723: ,p_analysis_criteria_id in number
724: ,p_login_person_id in number
725: ,p_business_group_id in number

Line 722: ,p_date_to in date default hr_api.g_date

718: ,p_person_id in number
719: ,p_person_analysis_id in number
720: ,p_pea_object_version_number in out nocopy number
721: ,p_date_from in date default hr_api.g_date
722: ,p_date_to in date default hr_api.g_date
723: ,p_analysis_criteria_id in number
724: ,p_login_person_id in number
725: ,p_business_group_id in number
726: ,p_id_flex_num in number

Line 947: from HR_API_TRANSACTION_STEPS t1

943:
944: --2287707
945: cursor csr_get_steps is
946: select t1.transaction_step_id
947: from HR_API_TRANSACTION_STEPS t1
948: where t1.api_name = 'HR_PROCESS_SIT_SS.PROCESS_API'
949: and t1.transaction_id = (select t2.transaction_id
950: from HR_API_TRANSACTION_STEPS t2
951: where t2.transaction_step_id = p_transaction_step_id)

Line 950: from HR_API_TRANSACTION_STEPS t2

946: select t1.transaction_step_id
947: from HR_API_TRANSACTION_STEPS t1
948: where t1.api_name = 'HR_PROCESS_SIT_SS.PROCESS_API'
949: and t1.transaction_id = (select t2.transaction_id
950: from HR_API_TRANSACTION_STEPS t2
951: where t2.transaction_step_id = p_transaction_step_id)
952: order by transaction_step_id;
953:
954: l_transaction_step_id HR_API_TRANSACTION_STEPS.transaction_step_id%TYPE;

Line 954: l_transaction_step_id HR_API_TRANSACTION_STEPS.transaction_step_id%TYPE;

950: from HR_API_TRANSACTION_STEPS t2
951: where t2.transaction_step_id = p_transaction_step_id)
952: order by transaction_step_id;
953:
954: l_transaction_step_id HR_API_TRANSACTION_STEPS.transaction_step_id%TYPE;
955: --2287707
956:
957: BEGIN
958: