DBA Data[Home] [Help]

APPS.PA_PROJECT_CORE1 dependencies on PA_PROJ_TASK_STRUC_PUB

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

4984: l_min_one_wp_ver_sel VARCHAR2(1) := 'N';
4985: l_fin_tasks_flag VARCHAR2(1) := 'Y';
4986: BEGIN
4987: --Check whether WP structure is enabled for the source project
4988: l_workplan_enabled := PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS( x_orig_project_id );
4989:
4990: IF NVL( l_workplan_enabled, 'N' ) = 'Y' THEN
4991: --Check whether the structures are shared or not in the source project
4992: l_shared := PA_PROJECT_STRUCTURE_UTILS.check_sharing_enabled( x_orig_project_id );

Line 5154: /*PA_PROJ_TASK_STRUC_PUB.COPY_STRUCTURE(

5150: BEGIN
5151: --This condition is checked here to make sure that the tasks
5152: --have already been created.
5153: -- if (x_copy_task_flag = 'Y' ) then
5154: /*PA_PROJ_TASK_STRUC_PUB.COPY_STRUCTURE(
5155: p_dest_project_id => x_new_project_id
5156: ,p_src_project_id => x_orig_project_id
5157: -- anlee
5158: -- Dates changes

Line 5173: PA_PROJ_TASK_STRUC_PUB.COPY_STRUCTURE(

5169: l_target_finish_date := NULL;
5170: END IF;
5171: --end bug 3991169
5172:
5173: PA_PROJ_TASK_STRUC_PUB.COPY_STRUCTURE(
5174: p_dest_project_id => x_new_project_id
5175: ,p_src_project_id => x_orig_project_id
5176: ,p_delta => x_delta
5177: ,p_dest_template_flag => x_template_flag

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

5188: IF l_return_status <> 'S'
5189: THEN
5190: x_err_code := 805;
5191: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_DFLT_STRUCTURE');
5192: x_err_stack := x_err_stack||'->PA_PROJ_TASK_STRUC_PUB.COPY_STRUCTURE';
5193: rollback to copy_project;
5194: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534
5195: return;
5196: END IF;

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

5199: x_err_code := 805;
5200: -- x_err_stage := pa_project_core1.get_message_from_stack( null );
5201: -- IF x_err_stage IS NULL
5202: -- THEN
5203: x_err_stage := 'API: '||'PA_PROJ_TASK_STRUC_PUB.COPY_STRUCTURE'||
5204:
5205: ' SQL error message: '||SUBSTR( SQLERRM,1,1900);
5206: -- END IF;
5207: rollback to copy_project;

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

5676: END;
5677: */
5678: -- 3024607 maansari end of changes
5679: --bug 3068506 maansari Copy Task Attachments ( moved from PA_PROJECT_CORE2.copy_task )
5680: /* Bug 3140032. It needs to be moved to PA_PROJ_TASK_STRUC_PUB.copy_structures_tasks_bulk api.
5681: x_err_stage := 'Copying task attachments..';
5682: Begin
5683: Declare
5684: cursor c_attach_tasks is

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

5724: end ;
5725:
5726: -- End of the attachment call
5727: --end bug 3068506 maansari Copy Task Attachements
5728: 3140032 Moved to PA_PROJ_TASK_STRUC_PUB.copy_structures_tasks_bulk api*/
5729:
5730: x_project_id := x_new_project_id;
5731: x_err_stack := old_stack;
5732: -- Check if WF is enabled for the new project status

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

5866: --********************************************************
5867: --DO NOT ADD ANY CODE AFTER THIS CALL. bug 3163280
5868: --********************************************************
5869: --Call the process updates WBS api to kick-off concurrent program or online processing.
5870: x_err_stage := 'Calling PA_PROJ_TASK_STRUC_PUB.CALL_PROCESS_WBS_UPDATES API ...';
5871:
5872: if (x_copy_task_flag = 'Y' ) then --no need to call for AMG. AMG has its own call.
5873:
5874: BEGIN

Line 5875: PA_PROJ_TASK_STRUC_PUB.CALL_PROCESS_WBS_UPDATES

5871:
5872: if (x_copy_task_flag = 'Y' ) then --no need to call for AMG. AMG has its own call.
5873:
5874: BEGIN
5875: PA_PROJ_TASK_STRUC_PUB.CALL_PROCESS_WBS_UPDATES
5876: ( p_dest_project_id => x_new_project_id
5877: ,x_return_status => l_return_status
5878: ,x_msg_count => l_msg_count
5879: ,x_msg_data => l_msg_data);

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

5880:
5881: if l_return_status <> 'S' then
5882: x_err_code := 1010;
5883: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_PROCESS_WBS');
5884: x_err_stack := x_err_stack||'->PA_PROJ_TASK_STRUC_PUB.CALL_PROCESS_WBS_UPDATES';
5885: rollback to copy_project;
5886: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534
5887: return;
5888: end if;

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

5887: return;
5888: end if;
5889: EXCEPTION WHEN OTHERS THEN
5890: x_err_code := 1010;
5891: x_err_stage := 'API: '||'PA_PROJ_TASK_STRUC_PUB.CALL_PROCESS_WBS_UPDATES'||
5892: ' SQL error message: '||SUBSTR( SQLERRM,1,1900);
5893: rollback to copy_project;
5894: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534
5895: return;