DBA Data[Home] [Help]

APPS.PA_PROJECT_CORE1 dependencies on PA_PROJ_TASK_STRUC_PUB

Line 5036: l_workplan_enabled := PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS( x_orig_project_id );

5032: l_min_one_wp_ver_sel VARCHAR2(1) := 'N';
5033: l_fin_tasks_flag VARCHAR2(1) := 'Y';
5034: BEGIN
5035: --Check whether WP structure is enabled for the source project
5036: l_workplan_enabled := PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS( x_orig_project_id );
5037:
5038: IF NVL( l_workplan_enabled, 'N' ) = 'Y' THEN
5039: --Check whether the structures are shared or not in the source project
5040: l_shared := PA_PROJECT_STRUCTURE_UTILS.check_sharing_enabled( x_orig_project_id );

Line 5222: /*PA_PROJ_TASK_STRUC_PUB.COPY_STRUCTURE(

5218: BEGIN
5219: --This condition is checked here to make sure that the tasks
5220: --have already been created.
5221: -- if (x_copy_task_flag = 'Y' ) then
5222: /*PA_PROJ_TASK_STRUC_PUB.COPY_STRUCTURE(
5223: p_dest_project_id => x_new_project_id
5224: ,p_src_project_id => x_orig_project_id
5225: -- anlee
5226: -- Dates changes

Line 5241: PA_PROJ_TASK_STRUC_PUB.COPY_STRUCTURE(

5237: l_target_finish_date := NULL;
5238: END IF;
5239: --end bug 3991169
5240:
5241: PA_PROJ_TASK_STRUC_PUB.COPY_STRUCTURE(
5242: p_dest_project_id => x_new_project_id
5243: ,p_src_project_id => x_orig_project_id
5244: ,p_delta => x_delta
5245: ,p_dest_template_flag => x_template_flag

Line 5260: x_err_stack := x_err_stack||'->PA_PROJ_TASK_STRUC_PUB.COPY_STRUCTURE';

5256: IF l_return_status <> 'S'
5257: THEN
5258: x_err_code := 805;
5259: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_DFLT_STRUCTURE');
5260: x_err_stack := x_err_stack||'->PA_PROJ_TASK_STRUC_PUB.COPY_STRUCTURE';
5261: rollback to copy_project;
5262: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534
5263: return;
5264: END IF;

Line 5271: x_err_stage := 'API: '||'PA_PROJ_TASK_STRUC_PUB.COPY_STRUCTURE'||

5267: x_err_code := 805;
5268: -- x_err_stage := pa_project_core1.get_message_from_stack( null );
5269: -- IF x_err_stage IS NULL
5270: -- THEN
5271: x_err_stage := 'API: '||'PA_PROJ_TASK_STRUC_PUB.COPY_STRUCTURE'||
5272:
5273: ' SQL error message: '||SUBSTR( SQLERRM,1,1900);
5274: -- END IF;
5275: rollback to copy_project;

Line 5748: /* Bug 3140032. It needs to be moved to PA_PROJ_TASK_STRUC_PUB.copy_structures_tasks_bulk api.

5744: END;
5745: */
5746: -- 3024607 maansari end of changes
5747: --bug 3068506 maansari Copy Task Attachments ( moved from PA_PROJECT_CORE2.copy_task )
5748: /* Bug 3140032. It needs to be moved to PA_PROJ_TASK_STRUC_PUB.copy_structures_tasks_bulk api.
5749: x_err_stage := 'Copying task attachments..';
5750: Begin
5751: Declare
5752: cursor c_attach_tasks is

Line 5796: 3140032 Moved to PA_PROJ_TASK_STRUC_PUB.copy_structures_tasks_bulk api*/

5792: end ;
5793:
5794: -- End of the attachment call
5795: --end bug 3068506 maansari Copy Task Attachements
5796: 3140032 Moved to PA_PROJ_TASK_STRUC_PUB.copy_structures_tasks_bulk api*/
5797:
5798: x_project_id := x_new_project_id;
5799: x_err_stack := old_stack;
5800: -- Check if WF is enabled for the new project status

Line 5938: x_err_stage := 'Calling PA_PROJ_TASK_STRUC_PUB.CALL_PROCESS_WBS_UPDATES API ...';

5934: --********************************************************
5935: --DO NOT ADD ANY CODE AFTER THIS CALL. bug 3163280
5936: --********************************************************
5937: --Call the process updates WBS api to kick-off concurrent program or online processing.
5938: x_err_stage := 'Calling PA_PROJ_TASK_STRUC_PUB.CALL_PROCESS_WBS_UPDATES API ...';
5939:
5940: if (x_copy_task_flag = 'Y' ) then --no need to call for AMG. AMG has its own call.
5941:
5942: BEGIN

Line 5943: PA_PROJ_TASK_STRUC_PUB.CALL_PROCESS_WBS_UPDATES

5939:
5940: if (x_copy_task_flag = 'Y' ) then --no need to call for AMG. AMG has its own call.
5941:
5942: BEGIN
5943: PA_PROJ_TASK_STRUC_PUB.CALL_PROCESS_WBS_UPDATES
5944: ( p_dest_project_id => x_new_project_id
5945: ,x_return_status => l_return_status
5946: ,x_msg_count => l_msg_count
5947: ,x_msg_data => l_msg_data);

Line 5952: x_err_stack := x_err_stack||'->PA_PROJ_TASK_STRUC_PUB.CALL_PROCESS_WBS_UPDATES';

5948:
5949: if l_return_status <> 'S' then
5950: x_err_code := 1010;
5951: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_PROCESS_WBS');
5952: x_err_stack := x_err_stack||'->PA_PROJ_TASK_STRUC_PUB.CALL_PROCESS_WBS_UPDATES';
5953: rollback to copy_project;
5954: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534
5955: return;
5956: end if;

Line 5959: x_err_stage := 'API: '||'PA_PROJ_TASK_STRUC_PUB.CALL_PROCESS_WBS_UPDATES'||

5955: return;
5956: end if;
5957: EXCEPTION WHEN OTHERS THEN
5958: x_err_code := 1010;
5959: x_err_stage := 'API: '||'PA_PROJ_TASK_STRUC_PUB.CALL_PROCESS_WBS_UPDATES'||
5960: ' SQL error message: '||SUBSTR( SQLERRM,1,1900);
5961: rollback to copy_project;
5962: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534
5963: return;