[Home] [Help]
149: --
150:
151: SELECT pa_workflow_itemkey_s.nextval
152: INTO itemkey
153: FROM dual;
154: --
155: -- Since this workflow needs to be executed in the background we need
156: -- to change the threshold. So we save the current threshold which
157: -- will be used later on to change it back to the current threshold.
1964: --rmunjulu bug 6815563
1965: cursor chk_org_res_exists_csr (l_org_id in NUMBER) is
1966: select 'Y'
1967: into l_org_res_exists
1968: from dual
1969: where exists (SELECT 'Y'
1970: FROM pa_resources_denorm
1971: WHERE resource_organization_id = l_org_id
1972: and sysdate between resource_effective_start_date and
2598: ,p_validate_only => NULL
2599: ,p_max_msg_count => NULL
2600: ,p_internal => 'Y'
2601: ,p_person_id => l_person_id
2602: ,p_individual => 'Y'
2603: ,p_resource_type => 'EMPLOYEE'
2604: ,x_return_status => l_return_status
2605: ,x_msg_count => l_msg_count
2606: ,x_msg_data => l_msg_data
2656: ,p_validate_only => NULL
2657: ,p_max_msg_count => NULL
2658: ,p_internal => 'Y'
2659: ,p_person_id => l_person_id
2660: ,p_individual => 'Y'
2661: ,p_resource_type => 'EMPLOYEE'
2662: ,x_return_status => l_return_status
2663: ,x_msg_count => l_msg_count
2664: ,x_msg_data => l_msg_data
2756:
2757: BEGIN
2758: SELECT 'Y'
2759: INTO l_res_asgn_exists
2760: FROM dual
2761: WHERE EXISTS (SELECT 'Y'
2762: FROM pa_resources_denorm
2763: WHERE person_id = l_person_id
2764: AND resource_effective_start_date =
2791: ,p_validate_only => NULL
2792: ,p_max_msg_count => NULL
2793: ,p_internal => 'Y'
2794: ,p_person_id => l_person_id
2795: ,p_individual => 'Y'
2796: ,p_resource_type => 'EMPLOYEE'
2797: ,x_return_status => l_return_status
2798: ,x_msg_count => l_msg_count
2799: ,x_msg_data => l_msg_data
3214: -- Get a unique identifier for this specific workflow
3215: --
3216: SELECT pa_workflow_itemkey_s.nextval
3217: INTO l_item_key
3218: FROM dual;
3219:
3220: -- Since this workflow needs to be executed in Non deferred mode,
3221: -- we need to change the threshold. So we save the current threshold which
3222: -- will be used later on to change it back to the current threshold.
3373:
3374: log_message('before calling PA_R_PROJECT_RESOURCES_PUB.CREATE_RESOURCE');
3375: PA_R_PROJECT_RESOURCES_PUB.CREATE_RESOURCE( p_api_version => 1.0,
3376: p_internal => 'Y',
3377: p_individual => 'Y',
3378: P_PERSON_ID => l_person_id,
3379: p_scheduled_member_flag => 'Y',
3380: P_PULL_TERM_RES => 'Y',
3381: x_return_status => l_return_status,