APPS.PA_HR_UPDATE_PA_ENTITIES dependencies on DUAL

Line 153: FROM dual;

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.

Line 2443: ,p_individual => 'Y'

2439: ,p_validate_only => NULL
2440: ,p_max_msg_count => NULL
2441: ,p_internal => 'Y'
2442: ,p_person_id => l_person_id
2443: ,p_individual => 'Y'
2444: ,p_resource_type => 'EMPLOYEE'
2445: ,x_return_status => l_return_status
2446: ,x_msg_count => l_msg_count
2447: ,x_msg_data => l_msg_data

Line 2496: ,p_individual => 'Y'

2492: ,p_validate_only => NULL
2493: ,p_max_msg_count => NULL
2494: ,p_internal => 'Y'
2495: ,p_person_id => l_person_id
2496: ,p_individual => 'Y'
2497: ,p_resource_type => 'EMPLOYEE'
2498: ,x_return_status => l_return_status
2499: ,x_msg_count => l_msg_count
2500: ,x_msg_data => l_msg_data

Line 2596: FROM dual

2592:
2593: BEGIN
2594: SELECT 'Y'
2595: INTO l_res_asgn_exists
2596: FROM dual
2597: WHERE EXISTS (SELECT 'Y'
2598: FROM pa_resources_denorm
2599: WHERE person_id = l_person_id
2600: AND resource_effective_start_date =

Line 2625: ,p_individual => 'Y'

2621: ,p_validate_only => NULL
2622: ,p_max_msg_count => NULL
2623: ,p_internal => 'Y'
2624: ,p_person_id => l_person_id
2625: ,p_individual => 'Y'
2626: ,p_resource_type => 'EMPLOYEE'
2627: ,x_return_status => l_return_status
2628: ,x_msg_count => l_msg_count
2629: ,x_msg_data => l_msg_data

Line 3021: FROM dual;

3017: -- Get a unique identifier for this specific workflow
3018: --
3019: SELECT pa_workflow_itemkey_s.nextval
3020: INTO l_item_key
3021: FROM dual;
3022:
3023: -- Since this workflow needs to be executed in Non deferred mode,
3024: -- we need to change the threshold. So we save the current threshold which
3025: -- will be used later on to change it back to the current threshold.

Line 3180: p_individual => 'Y',

3176:
3177: log_message('before calling PA_R_PROJECT_RESOURCES_PUB.CREATE_RESOURCE');
3178: PA_R_PROJECT_RESOURCES_PUB.CREATE_RESOURCE( p_api_version => 1.0,
3179: p_internal => 'Y',
3180: p_individual => 'Y',
3181: P_PERSON_ID => l_person_id,
3182: p_scheduled_member_flag => 'Y',
3183: P_PULL_TERM_RES => 'Y',
3184: x_return_status => l_return_status,