eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_PROJECT_PUB dependencies on PA_PROJ_TASK_STRUC_PUB

Line 4354: l_delta := PA_PROJ_TASK_STRUC_PUB.get_proj_dates_delta(

4350:
4351: --Project Structure Integration
4352: --This creates the
4353: /* not required as
4354: l_delta := PA_PROJ_TASK_STRUC_PUB.get_proj_dates_delta(
4355: l_project_in_rec.created_from_project_id
4356: ,l_out_start_date );
4357: */
4358:

Line 4360: PA_PROJ_TASK_STRUC_PUB.COPY_STRUCTURE(

4356: ,l_out_start_date );
4357: */
4358:
4359: /*--bug 2805602 we dont this anymore as copy project will take care of creating structures only
4360: PA_PROJ_TASK_STRUC_PUB.COPY_STRUCTURE(
4361: p_dest_project_id => l_project_id
4362: ,p_src_project_id => l_project_in_rec.created_from_project_id
4363: ,p_delta => l_delta
4364: ,p_copy_task_flag => 'N'

Line 4391: PA_PROJ_TASK_STRUC_PUB.Clean_unwanted_tasks(

4387:
4388: --Clean up first the unwanted tasks that are created by copy_structure in pa_proj_elements
4389: --although they had not been created in pa_tasks.
4390:
4391: PA_PROJ_TASK_STRUC_PUB.Clean_unwanted_tasks(
4392: p_project_id => l_project_id
4393: ,x_msg_count => l_msg_count
4394: ,x_msg_data => l_msg_data
4395: ,x_return_status => l_return_status

Line 4411: G_Published_version_exists := PA_PROJ_TASK_STRUC_PUB.Published_version_exists( l_project_id );

4407:
4408: --Project Structure Integration
4409:
4410: --bug 2738747 --create project api. Here ther is actually no pupose of this call
4411: G_Published_version_exists := PA_PROJ_TASK_STRUC_PUB.Published_version_exists( l_project_id );
4412: G_IS_WP_SEPARATE_FROM_FN := PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN( l_project_id );
4413: G_IS_WP_VERSIONING_ENABLED := PA_PROJ_TASK_STRUC_PUB.IS_WP_VERSIONING_ENABLED( l_project_id );
4414: --bug 2738747
4415:

Line 4412: G_IS_WP_SEPARATE_FROM_FN := PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN( l_project_id );

4408: --Project Structure Integration
4409:
4410: --bug 2738747 --create project api. Here ther is actually no pupose of this call
4411: G_Published_version_exists := PA_PROJ_TASK_STRUC_PUB.Published_version_exists( l_project_id );
4412: G_IS_WP_SEPARATE_FROM_FN := PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN( l_project_id );
4413: G_IS_WP_VERSIONING_ENABLED := PA_PROJ_TASK_STRUC_PUB.IS_WP_VERSIONING_ENABLED( l_project_id );
4414: --bug 2738747
4415:
4416: G_WP_STR_EXISTS := PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS( l_project_id );

Line 4413: G_IS_WP_VERSIONING_ENABLED := PA_PROJ_TASK_STRUC_PUB.IS_WP_VERSIONING_ENABLED( l_project_id );

4409:
4410: --bug 2738747 --create project api. Here ther is actually no pupose of this call
4411: G_Published_version_exists := PA_PROJ_TASK_STRUC_PUB.Published_version_exists( l_project_id );
4412: G_IS_WP_SEPARATE_FROM_FN := PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN( l_project_id );
4413: G_IS_WP_VERSIONING_ENABLED := PA_PROJ_TASK_STRUC_PUB.IS_WP_VERSIONING_ENABLED( l_project_id );
4414: --bug 2738747
4415:
4416: G_WP_STR_EXISTS := PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS( l_project_id );
4417: --Begin Add by rtarway FP.M changes for mapping

Line 4416: G_WP_STR_EXISTS := PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS( l_project_id );

4412: G_IS_WP_SEPARATE_FROM_FN := PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN( l_project_id );
4413: G_IS_WP_VERSIONING_ENABLED := PA_PROJ_TASK_STRUC_PUB.IS_WP_VERSIONING_ENABLED( l_project_id );
4414: --bug 2738747
4415:
4416: G_WP_STR_EXISTS := PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS( l_project_id );
4417: --Begin Add by rtarway FP.M changes for mapping
4418: G_PROJECT_SHARING_TYPE := PA_PROJ_TASK_STRUC_PUB.GET_SHARE_TYPE(l_project_id);
4419: --End Add by rtarway FP.M changes for mapping
4420:

Line 4418: G_PROJECT_SHARING_TYPE := PA_PROJ_TASK_STRUC_PUB.GET_SHARE_TYPE(l_project_id);

4414: --bug 2738747
4415:
4416: G_WP_STR_EXISTS := PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS( l_project_id );
4417: --Begin Add by rtarway FP.M changes for mapping
4418: G_PROJECT_SHARING_TYPE := PA_PROJ_TASK_STRUC_PUB.GET_SHARE_TYPE(l_project_id);
4419: --End Add by rtarway FP.M changes for mapping
4420:
4421: --TASK
4422: --add tasks to the just created project

Line 4728: PA_PROJ_TASK_STRUC_PUB.convert_pm_parent_task_ref(

4724: AND l_task_in_rec.pm_parent_task_reference IS NOT NULL)
4725: THEN
4726: --convert pm_parent_task_reference to parent_task_id.
4727: --All the parent tasks are created first then child tasks are created. See TRM for AMG load_task api.
4728: PA_PROJ_TASK_STRUC_PUB.convert_pm_parent_task_ref(
4729: p_pm_parent_task_reference => l_task_in_rec.pm_parent_task_reference
4730: ,p_project_id => l_project_id
4731: ,x_parent_task_id => v_parent_task_id
4732: ,x_return_status => l_return_status

Line 4766: PA_PROJ_TASK_STRUC_PUB.CREATE_TASK_STRUCTURE(

4762: l_ref_task_id := v_task_id;
4763: END IF;
4764: --proj conn
4765:
4766: PA_PROJ_TASK_STRUC_PUB.CREATE_TASK_STRUCTURE(
4767: p_project_id => l_project_id
4768: ,p_task_id => l_task_in_rec.pa_task_id
4769: ,p_parent_task_id => v_parent_task_id
4770: ,p_ref_task_id => l_ref_task_id --proj conn

Line 4870: pa_debug.g_err_stage := 'Calling PA_PROJ_TASK_STRUC_PUB.PROCESS_TASK_STRUCTURE_BULK ' ;

4866:
4867: -- Made the following changes for post FP K one off. Bug 2931183
4868: -- Performance changes.
4869: IF l_debug_mode = 'Y' THEN
4870: pa_debug.g_err_stage := 'Calling PA_PROJ_TASK_STRUC_PUB.PROCESS_TASK_STRUCTURE_BULK ' ;
4871: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
4872: END IF;
4873:
4874: --Set the global variable G_OP_VALIDATE_FLAG.

Line 4878: PA_PROJ_TASK_STRUC_PUB.PROCESS_TASK_STRUCTURE_BULK

4874: --Set the global variable G_OP_VALIDATE_FLAG.
4875: --BUG 4218977
4876: G_OP_VALIDATE_FLAG := p_op_validate_flag;
4877:
4878: PA_PROJ_TASK_STRUC_PUB.PROCESS_TASK_STRUCTURE_BULK
4879: ( p_api_version_number => p_api_version_number
4880: ,p_commit => FND_API.G_FALSE --p_commit : Bug 3668424: passing p_commit as FND_API.G_FALSE
4881: ,p_project_id => l_project_id -- Changed during UT.
4882: ,p_source_project_id => l_project_in_rec.created_from_project_id --ADUT. Included this new param.

Line 4906: pa_debug.g_err_stage := 'Returned from PA_PROJ_TASK_STRUC_PUB.PROCESS_TASK_STRUCTURE_BULK ' ;

4902: p_multiple_task_msg := 'F';
4903: END IF;
4904:
4905: IF l_debug_mode = 'Y' THEN
4906: pa_debug.g_err_stage := 'Returned from PA_PROJ_TASK_STRUC_PUB.PROCESS_TASK_STRUCTURE_BULK ' ;
4907: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
4908: END IF;
4909:
4910: /* Post FP K one off. Bug 2931183

Line 4911: Commenting this code as this is done in PA_PROJ_TASK_STRUC_PUB.process_task_structure_bulk.

4907: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
4908: END IF;
4909:
4910: /* Post FP K one off. Bug 2931183
4911: Commenting this code as this is done in PA_PROJ_TASK_STRUC_PUB.process_task_structure_bulk.
4912: --bug 2732895 --create_project
4913: IF ( G_WP_STR_EXISTS = 'Y' AND G_IS_WP_SEPARATE_FROM_FN = 'N' ) OR
4914: ( G_WP_STR_EXISTS = 'Y' AND G_IS_WP_SEPARATE_FROM_FN = 'Y' AND l_structure_in_rec.structure_type = 'WORKPLAN' ) --should not call fif tasks are added to financial structure version
4915: THEN

Line 4916: PA_PROJ_TASK_STRUC_PUB.recalc_task_weightings(

4912: --bug 2732895 --create_project
4913: IF ( G_WP_STR_EXISTS = 'Y' AND G_IS_WP_SEPARATE_FROM_FN = 'N' ) OR
4914: ( G_WP_STR_EXISTS = 'Y' AND G_IS_WP_SEPARATE_FROM_FN = 'Y' AND l_structure_in_rec.structure_type = 'WORKPLAN' ) --should not call fif tasks are added to financial structure version
4915: THEN
4916: PA_PROJ_TASK_STRUC_PUB.recalc_task_weightings(
4917: p_tasks_in => p_tasks_out
4918: ,p_task_version_id => null
4919: ,x_msg_count => l_msg_count
4920: ,x_msg_data => l_msg_data

Line 4936: PA_PROJ_TASK_STRUC_PUB.rollup_dates(

4932: END IF;
4933:
4934: --bug 2856033
4935:
4936: PA_PROJ_TASK_STRUC_PUB.rollup_dates(
4937: p_tasks_in => p_tasks_out
4938: ,p_task_version_id => null
4939: ,p_project_id => l_project_id
4940: ,P_structure_version_id => null

Line 4984: --IF (PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS(p_project_out.pa_project_id) = 'Y') THEN

4980: -- p_project_out.pa_project_id is not available till this point. Should be replaced by following.
4981: -- l_d_task_id := p_tasks_out(l_d_loop_count).pa_task_id;
4982:
4983: --Commented by rtarway FP.M Changes for Mapping
4984: --IF (PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS(p_project_out.pa_project_id) = 'Y') THEN
4985: IF (PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS(l_project_id) = 'Y') THEN
4986:
4987: --maansari5/18 replaced api call CONVERT_PM_TASKREF_TO_ID to CONVERT_PM_TASKREF_TO_ID_all
4988: IF l_d_task_id IS NULL AND

Line 4985: IF (PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS(l_project_id) = 'Y') THEN

4981: -- l_d_task_id := p_tasks_out(l_d_loop_count).pa_task_id;
4982:
4983: --Commented by rtarway FP.M Changes for Mapping
4984: --IF (PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS(p_project_out.pa_project_id) = 'Y') THEN
4985: IF (PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS(l_project_id) = 'Y') THEN
4986:
4987: --maansari5/18 replaced api call CONVERT_PM_TASKREF_TO_ID to CONVERT_PM_TASKREF_TO_ID_all
4988: IF l_d_task_id IS NULL AND
4989: l_task_in_rec.pm_task_reference IS NOT NULL AND

Line 5021: pa_proj_task_struc_pub.parse_predecessor_import(p_string => l_task_in_rec.pred_string

5017:
5018: l_d_task_ver_id := PA_PROJ_ELEMENTS_UTILS.GET_TASK_VERSION_ID(p_structure_version_id => l_d_structure_version_id
5019: ,p_task_id => l_d_task_id);
5020:
5021: pa_proj_task_struc_pub.parse_predecessor_import(p_string => l_task_in_rec.pred_string
5022: ,p_delimeter => l_task_in_rec.pred_delimiter
5023: ,p_task_version_Id => l_d_task_ver_id
5024: ,x_return_status => l_return_status
5025: ,x_msg_count => l_msg_count

Line 5855: ELSIF 'N' = PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN( l_project_id ) THEN

5851: FETCH cur_get_str_type_from_str_id INTO l_str_type;
5852: IF cur_get_str_type_from_str_id%NOTFOUND THEN
5853: l_str_type := p_structure_type;
5854: --Foll IF condition added for Bug 3810365
5855: ELSIF 'N' = PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN( l_project_id ) THEN
5856: l_str_type := 'FINANCIAL';
5857: END IF;
5858: CLOSE cur_get_str_type_from_str_id;
5859: END IF;

Line 6073: G_Published_version_exists := PA_PROJ_TASK_STRUC_PUB.Published_version_exists( l_project_id );

6069: FETCH l_amg_project_csr INTO l_amg_segment1;
6070: CLOSE l_amg_project_csr;
6071:
6072: --bug 2738747 ---Add task
6073: G_Published_version_exists := PA_PROJ_TASK_STRUC_PUB.Published_version_exists( l_project_id );
6074: G_IS_WP_SEPARATE_FROM_FN := PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN( l_project_id );
6075: G_IS_WP_VERSIONING_ENABLED := PA_PROJ_TASK_STRUC_PUB.IS_WP_VERSIONING_ENABLED( l_project_id );
6076: --bug 2738747
6077: G_WP_STR_EXISTS := PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS( l_project_id );

Line 6074: G_IS_WP_SEPARATE_FROM_FN := PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN( l_project_id );

6070: CLOSE l_amg_project_csr;
6071:
6072: --bug 2738747 ---Add task
6073: G_Published_version_exists := PA_PROJ_TASK_STRUC_PUB.Published_version_exists( l_project_id );
6074: G_IS_WP_SEPARATE_FROM_FN := PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN( l_project_id );
6075: G_IS_WP_VERSIONING_ENABLED := PA_PROJ_TASK_STRUC_PUB.IS_WP_VERSIONING_ENABLED( l_project_id );
6076: --bug 2738747
6077: G_WP_STR_EXISTS := PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS( l_project_id );
6078: G_OP_VALIDATE_FLAG := p_op_validate_flag; --added by rtarway for bug 4218977

Line 6075: G_IS_WP_VERSIONING_ENABLED := PA_PROJ_TASK_STRUC_PUB.IS_WP_VERSIONING_ENABLED( l_project_id );

6071:
6072: --bug 2738747 ---Add task
6073: G_Published_version_exists := PA_PROJ_TASK_STRUC_PUB.Published_version_exists( l_project_id );
6074: G_IS_WP_SEPARATE_FROM_FN := PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN( l_project_id );
6075: G_IS_WP_VERSIONING_ENABLED := PA_PROJ_TASK_STRUC_PUB.IS_WP_VERSIONING_ENABLED( l_project_id );
6076: --bug 2738747
6077: G_WP_STR_EXISTS := PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS( l_project_id );
6078: G_OP_VALIDATE_FLAG := p_op_validate_flag; --added by rtarway for bug 4218977
6079:

Line 6077: G_WP_STR_EXISTS := PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS( l_project_id );

6073: G_Published_version_exists := PA_PROJ_TASK_STRUC_PUB.Published_version_exists( l_project_id );
6074: G_IS_WP_SEPARATE_FROM_FN := PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN( l_project_id );
6075: G_IS_WP_VERSIONING_ENABLED := PA_PROJ_TASK_STRUC_PUB.IS_WP_VERSIONING_ENABLED( l_project_id );
6076: --bug 2738747
6077: G_WP_STR_EXISTS := PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS( l_project_id );
6078: G_OP_VALIDATE_FLAG := p_op_validate_flag; --added by rtarway for bug 4218977
6079:
6080: --bug 2876703 --Add_task
6081: IF G_IS_WP_SEPARATE_FROM_FN = 'N' AND

Line 6871: IF (PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS(p_pa_project_id) = 'Y') THEN

6867: ,p_out_task_id => l_d_task_id
6868: ,p_return_status => l_return_status);
6869: */
6870:
6871: IF (PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS(p_pa_project_id) = 'Y') THEN
6872:
6873: IF l_d_task_id IS NULL AND l_task_in_rec.pm_task_reference IS NOT NULL AND
6874: l_task_in_rec.pm_task_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
6875: THEN

Line 6918: pa_proj_task_struc_pub.parse_predecessor_import(p_string => l_task_in_rec.pred_string

6914:
6915: l_d_task_ver_id := PA_PROJ_ELEMENTS_UTILS.GET_TASK_VERSION_ID(p_structure_version_id => l_d_struct_ver_id
6916: ,p_task_id => l_d_task_id);
6917:
6918: pa_proj_task_struc_pub.parse_predecessor_import(p_string => l_task_in_rec.pred_string
6919: ,p_delimeter => l_task_in_rec.pred_delimiter
6920: ,p_task_version_Id => l_d_task_ver_id
6921: ,x_return_status => l_return_status
6922: ,x_msg_count => l_msg_count

Line 6976: PA_PROJ_TASK_STRUC_PUB.CREATE_TASK_STRUCTURE(

6972: l_task_in_rec.scheduled_start_date := p_scheduled_start_date;
6973: l_task_in_rec.scheduled_finish_date := p_scheduled_finish_date;
6974: l_task_in_rec.PM_task_reference := p_pm_task_reference;
6975:
6976: PA_PROJ_TASK_STRUC_PUB.CREATE_TASK_STRUCTURE(
6977: p_project_id => l_project_id
6978: ,p_task_id => l_task_in_rec.pa_task_id
6979: ,p_parent_task_id => l_task_in_rec.pa_parent_task_id
6980: ,p_ref_task_id => l_ref_task_id --proj conn

Line 7071: G_PROJECT_SHARING_TYPE := PA_PROJ_TASK_STRUC_PUB.GET_SHARE_TYPE(l_project_id);

7067: p_pa_project_id_out := l_project_rec.project_id;
7068: p_pa_project_number_out := l_project_rec.segment1; --this is the project_number field in PA_PROJECTS
7069:
7070: --Begin Add by rtarway FP.M Development
7071: G_PROJECT_SHARING_TYPE := PA_PROJ_TASK_STRUC_PUB.GET_SHARE_TYPE(l_project_id);
7072: IF (G_PROJECT_SHARING_TYPE='SPLIT_MAPPING' AND l_structure_type = 'WORKPLAN' ) THEN
7073: IF (
7074: ( l_task_in_rec.mapped_task_id IS NOT NULL AND l_task_in_rec.mapped_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM )
7075: OR

Line 7157: PA_PROJ_TASK_STRUC_PUB.rollup_dates(

7153:
7154: -- The rollup of dates must be completed before we do
7155: -- the task weightage calculation.
7156:
7157: PA_PROJ_TASK_STRUC_PUB.rollup_dates(
7158: p_tasks_in => l_tasks_out --null if called for one task
7159: ,p_task_version_id => l_task_version_id
7160: ,p_project_id => l_project_id
7161: ,P_structure_version_id => null

Line 7180: -- In new model PA_PROJ_TASK_STRUC_PUB.recalc_task_weightings

7176:
7177: l_task_weight_basis_code := PA_PROGRESS_UTILS.GET_TASK_WEIGHTING_BASIS(p_project_id => p_pa_project_id) ;
7178:
7179: -- PA L Changes 3010538
7180: -- In new model PA_PROJ_TASK_STRUC_PUB.recalc_task_weightings
7181: -- needs to be called only when task weight basis code is
7182: -- MANUAL.
7183: IF nvl(l_task_weight_basis_code,'-1') = 'MANUAL' THEN
7184:

Line 7185: PA_PROJ_TASK_STRUC_PUB.recalc_task_weightings(

7181: -- needs to be called only when task weight basis code is
7182: -- MANUAL.
7183: IF nvl(l_task_weight_basis_code,'-1') = 'MANUAL' THEN
7184:
7185: PA_PROJ_TASK_STRUC_PUB.recalc_task_weightings(
7186: p_tasks_in => l_tasks_out --null if called for one task
7187: ,p_task_version_id => l_task_version_id
7188: ,x_msg_count => l_msg_count
7189: ,x_msg_data => l_msg_data

Line 7229: PA_PROJ_TASK_STRUC_PUB.SET_UPDATE_WBS_FLAG

7225: THEN
7226:
7227: /* Starts added for Bug# 7264422 */
7228: IF (nvl(p_structure_updates_flag, 'Y') = 'N') THEN
7229: PA_PROJ_TASK_STRUC_PUB.SET_UPDATE_WBS_FLAG
7230: ( p_calling_context => 'AMG'
7231: ,p_project_id => l_project_id
7232: ,p_structure_version_id => l_structure_version_id
7233: ,p_update_wbs_flag => 'Y'

Line 7251: PA_PROJ_TASK_STRUC_PUB.PROCESS_WBS_UPDATES(p_calling_context => 'ONLINE_UPDATE'

7247:
7248: IF nvl(l_update_wbs_flag,'N') = 'Y' THEN
7249: IF p_process_mode = 'ONLINE' THEN
7250:
7251: PA_PROJ_TASK_STRUC_PUB.PROCESS_WBS_UPDATES(p_calling_context => 'ONLINE_UPDATE'
7252: ,p_project_id => l_project_id -- bug 3106457 p_pa_project_id
7253: ,p_structure_version_id => l_structure_version_id -- bug 3106457 p_structure_version_id
7254: ,x_return_status => l_return_status
7255: ,x_msg_count => l_msg_count

Line 7267: PA_PROJ_TASK_STRUC_PUB. PROCESS_WBS_UPDATES_CONC_WRP(p_calling_context => 'CONC_UPDATE' -- Bug 6842218 'CON_UPDATE'

7263: RAISE FND_API.G_EXC_ERROR;
7264: END IF;
7265: ELSIF p_process_mode = 'CONCURRENT' THEN
7266:
7267: PA_PROJ_TASK_STRUC_PUB. PROCESS_WBS_UPDATES_CONC_WRP(p_calling_context => 'CONC_UPDATE' -- Bug 6842218 'CON_UPDATE'
7268: ,p_project_id => l_project_id -- bug 3106457 p_pa_project_id
7269: ,p_structure_version_id => l_structure_version_id -- bug 3106457 p_structure_version_id
7270: ,x_return_status => l_return_status
7271: ,x_msg_count => l_msg_count

Line 7498: IF PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS( l_project_id ) = 'N' OR

7494: --end of bug 24771668
7495:
7496: IF p_structure_type = 'WORKPLAN'
7497: THEN
7498: IF PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS( l_project_id ) = 'N' OR
7499: PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN( l_project_id ) = 'N' -- 2876703 --delete_task
7500: THEN
7501: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
7502: THEN

Line 7499: PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN( l_project_id ) = 'N' -- 2876703 --delete_task

7495:
7496: IF p_structure_type = 'WORKPLAN'
7497: THEN
7498: IF PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS( l_project_id ) = 'N' OR
7499: PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN( l_project_id ) = 'N' -- 2876703 --delete_task
7500: THEN
7501: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
7502: THEN
7503: pa_interface_utils_pub.map_new_amg_msg

Line 7559: G_Published_version_exists := PA_PROJ_TASK_STRUC_PUB.Published_version_exists( l_project_id );

7555: -- switch flow to WORKPLAN
7556: -- i) Workplan is enabled;
7557: -- ii) Structure is SHARED;
7558: -- iii) Published version exists;
7559: G_Published_version_exists := PA_PROJ_TASK_STRUC_PUB.Published_version_exists( l_project_id );
7560: G_IS_WP_SEPARATE_FROM_FN := PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN( l_project_id );
7561: G_IS_WP_VERSIONING_ENABLED := PA_PROJ_TASK_STRUC_PUB.IS_WP_VERSIONING_ENABLED( l_project_id );
7562:
7563: IF PA_PROJECT_PUB.G_Published_version_exists = 'Y'

Line 7560: G_IS_WP_SEPARATE_FROM_FN := PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN( l_project_id );

7556: -- i) Workplan is enabled;
7557: -- ii) Structure is SHARED;
7558: -- iii) Published version exists;
7559: G_Published_version_exists := PA_PROJ_TASK_STRUC_PUB.Published_version_exists( l_project_id );
7560: G_IS_WP_SEPARATE_FROM_FN := PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN( l_project_id );
7561: G_IS_WP_VERSIONING_ENABLED := PA_PROJ_TASK_STRUC_PUB.IS_WP_VERSIONING_ENABLED( l_project_id );
7562:
7563: IF PA_PROJECT_PUB.G_Published_version_exists = 'Y'
7564: AND PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN = 'N'

Line 7561: G_IS_WP_VERSIONING_ENABLED := PA_PROJ_TASK_STRUC_PUB.IS_WP_VERSIONING_ENABLED( l_project_id );

7557: -- ii) Structure is SHARED;
7558: -- iii) Published version exists;
7559: G_Published_version_exists := PA_PROJ_TASK_STRUC_PUB.Published_version_exists( l_project_id );
7560: G_IS_WP_SEPARATE_FROM_FN := PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN( l_project_id );
7561: G_IS_WP_VERSIONING_ENABLED := PA_PROJ_TASK_STRUC_PUB.IS_WP_VERSIONING_ENABLED( l_project_id );
7562:
7563: IF PA_PROJECT_PUB.G_Published_version_exists = 'Y'
7564: AND PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN = 'N'
7565: AND PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'Y'

Line 7698: PA_PROJ_TASK_STRUC_PUB.PROCESS_WBS_UPDATES(p_calling_context => 'ONLINE_UPDATE'

7694:
7695: IF nvl(l_update_wbs_flag,'N') = 'Y' THEN
7696: IF p_process_mode = 'ONLINE' THEN
7697:
7698: PA_PROJ_TASK_STRUC_PUB.PROCESS_WBS_UPDATES(p_calling_context => 'ONLINE_UPDATE'
7699: ,p_project_id => l_project_id --Bug 3106457 p_pa_project_id
7700: ,p_structure_version_id => l_structure_version_id
7701: ,x_return_status => p_return_status
7702: ,x_msg_count => p_msg_count

Line 7714: PA_PROJ_TASK_STRUC_PUB. PROCESS_WBS_UPDATES_CONC_WRP(p_calling_context => 'CONC_UPDATE'

7710: RAISE FND_API.G_EXC_ERROR;
7711: END IF;
7712: ELSIF p_process_mode = 'CONCURRENT' THEN
7713:
7714: PA_PROJ_TASK_STRUC_PUB. PROCESS_WBS_UPDATES_CONC_WRP(p_calling_context => 'CONC_UPDATE'
7715: ,p_project_id => l_project_id -- Bug 3106457 p_pa_project_id
7716: ,p_structure_version_id => l_structure_version_id
7717: ,x_return_status => p_return_status
7718: ,x_msg_count => p_msg_count

Line 11070: G_Published_version_exists := PA_PROJ_TASK_STRUC_PUB.Published_version_exists( l_project_id );

11066: l_ctx_update_flag := 'N';
11067: -- End of changes
11068:
11069: --bug 2738747 --update project
11070: G_Published_version_exists := PA_PROJ_TASK_STRUC_PUB.Published_version_exists( l_project_id );
11071: G_IS_WP_SEPARATE_FROM_FN := PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN( l_project_id );
11072: G_IS_WP_VERSIONING_ENABLED := PA_PROJ_TASK_STRUC_PUB.IS_WP_VERSIONING_ENABLED( l_project_id );
11073: --bug 2738747
11074: G_WP_STR_EXISTS := PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS( l_project_id );

Line 11071: G_IS_WP_SEPARATE_FROM_FN := PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN( l_project_id );

11067: -- End of changes
11068:
11069: --bug 2738747 --update project
11070: G_Published_version_exists := PA_PROJ_TASK_STRUC_PUB.Published_version_exists( l_project_id );
11071: G_IS_WP_SEPARATE_FROM_FN := PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN( l_project_id );
11072: G_IS_WP_VERSIONING_ENABLED := PA_PROJ_TASK_STRUC_PUB.IS_WP_VERSIONING_ENABLED( l_project_id );
11073: --bug 2738747
11074: G_WP_STR_EXISTS := PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS( l_project_id );
11075:

Line 11072: G_IS_WP_VERSIONING_ENABLED := PA_PROJ_TASK_STRUC_PUB.IS_WP_VERSIONING_ENABLED( l_project_id );

11068:
11069: --bug 2738747 --update project
11070: G_Published_version_exists := PA_PROJ_TASK_STRUC_PUB.Published_version_exists( l_project_id );
11071: G_IS_WP_SEPARATE_FROM_FN := PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN( l_project_id );
11072: G_IS_WP_VERSIONING_ENABLED := PA_PROJ_TASK_STRUC_PUB.IS_WP_VERSIONING_ENABLED( l_project_id );
11073: --bug 2738747
11074: G_WP_STR_EXISTS := PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS( l_project_id );
11075:
11076: IF l_debug_mode = 'Y' THEN

Line 11074: G_WP_STR_EXISTS := PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS( l_project_id );

11070: G_Published_version_exists := PA_PROJ_TASK_STRUC_PUB.Published_version_exists( l_project_id );
11071: G_IS_WP_SEPARATE_FROM_FN := PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN( l_project_id );
11072: G_IS_WP_VERSIONING_ENABLED := PA_PROJ_TASK_STRUC_PUB.IS_WP_VERSIONING_ENABLED( l_project_id );
11073: --bug 2738747
11074: G_WP_STR_EXISTS := PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS( l_project_id );
11075:
11076: IF l_debug_mode = 'Y' THEN
11077: pa_debug.g_err_stage := 'G_Published_version_exists='||G_Published_version_exists;
11078: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);

Line 16343: --dbms_output.put_line ('before calling PA_PROJ_TASK_STRUC_PUB.create_structure ');

16339: l_update_task_structure := 'N';
16340: END IF; -- bug 3548473 : 3627124
16341:
16342: --dbms_output.put_line ('l_update_task_structure : ' || l_update_task_structure);
16343: --dbms_output.put_line ('before calling PA_PROJ_TASK_STRUC_PUB.create_structure ');
16344: --Creating a WORKPLAN structure
16345: IF p_structure_in.structure_type = 'WORKPLAN' --This should only be done for a WORKPLAN structure
16346: THEN
16347: PA_PROJ_TASK_STRUC_PUB.create_structure(

Line 16347: PA_PROJ_TASK_STRUC_PUB.create_structure(

16343: --dbms_output.put_line ('before calling PA_PROJ_TASK_STRUC_PUB.create_structure ');
16344: --Creating a WORKPLAN structure
16345: IF p_structure_in.structure_type = 'WORKPLAN' --This should only be done for a WORKPLAN structure
16346: THEN
16347: PA_PROJ_TASK_STRUC_PUB.create_structure(
16348: p_project_id => l_project_id
16349: ,p_structure_type =>l_structure_type --BUg 3548473 3627124 aditi
16350: ,p_structure_version_name => p_structure_in.structure_version_name
16351: ,p_description => p_structure_in.description

Line 16360: pa_debug.g_err_stage := 'After calling PA_PROJ_TASK_STRUC_PUB.create_structure l_return_status='||l_return_status;

16356: ,x_return_status => l_return_status
16357: );
16358:
16359: IF l_debug_mode = 'Y' THEN
16360: pa_debug.g_err_stage := 'After calling PA_PROJ_TASK_STRUC_PUB.create_structure l_return_status='||l_return_status;
16361: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
16362: END IF;
16363:
16364:

Line 16391: AND NVL( PA_PROJ_TASK_STRUC_PUB.IS_WP_VERSIONING_ENABLED(l_project_id), 'N' ) = 'Y'

16387: --creating structure version
16388: THEN
16389: IF l_structure_version_id IS NULL
16390: AND NVL( l_project_rec.template_flag,'N') = 'N'
16391: AND NVL( PA_PROJ_TASK_STRUC_PUB.IS_WP_VERSIONING_ENABLED(l_project_id), 'N' ) = 'Y'
16392: AND p_pm_product_code <> 'WORKPLAN' -- Bug 2871353
16393: THEN
16394: PA_PROJ_TASK_STRUC_PUB.create_update_struct_ver(
16395: p_project_id => l_project_id

Line 16394: PA_PROJ_TASK_STRUC_PUB.create_update_struct_ver(

16390: AND NVL( l_project_rec.template_flag,'N') = 'N'
16391: AND NVL( PA_PROJ_TASK_STRUC_PUB.IS_WP_VERSIONING_ENABLED(l_project_id), 'N' ) = 'Y'
16392: AND p_pm_product_code <> 'WORKPLAN' -- Bug 2871353
16393: THEN
16394: PA_PROJ_TASK_STRUC_PUB.create_update_struct_ver(
16395: p_project_id => l_project_id
16396: ,p_structure_type => p_structure_in.structure_type --no need to change this actual parameter for bug 2738747. The API takes care of financial stuff.
16397: ,p_structure_version_name => p_structure_in.structure_version_name
16398: ,p_structure_version_id => p_structure_in.structure_version_id

Line 16407: pa_debug.g_err_stage := 'After calling PA_PROJ_TASK_STRUC_PUB.create_update_struct_ver l_return_status='||l_return_status;

16403: ,x_return_status => l_return_status
16404: );
16405:
16406: IF l_debug_mode = 'Y' THEN
16407: pa_debug.g_err_stage := 'After calling PA_PROJ_TASK_STRUC_PUB.create_update_struct_ver l_return_status='||l_return_status;
16408: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
16409: END IF;
16410:
16411:

Line 16436: PA_PROJ_TASK_STRUC_PUB.create_tasks_versions_only(

16432: l_create_task_versions_only := 'Y';
16433:
16434: --Call create_tasks_versions_only api to create new task versions for the
16435: --existing tasks and add them to the new structure version.
16436: PA_PROJ_TASK_STRUC_PUB.create_tasks_versions_only(
16437: p_calling_module => 'AMG'
16438: --,p_structure_type => p_structure_in.structure_type --bug 2738747
16439: ,p_structure_type => l_structure_type --bug 2738747
16440: ,p_project_id => l_project_id

Line 16449: pa_debug.g_err_stage := 'After calling PA_PROJ_TASK_STRUC_PUB.create_tasks_versions_only l_return_status='||l_return_status;

16445: ,x_msg_data => l_msg_data
16446: ,x_return_status => l_return_status );
16447:
16448: IF l_debug_mode = 'Y' THEN
16449: pa_debug.g_err_stage := 'After calling PA_PROJ_TASK_STRUC_PUB.create_tasks_versions_only l_return_status='||l_return_status;
16450: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
16451: END IF;
16452:
16453:

Line 16531: l_is_wp_seperate_from_fn := PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN( l_project_id ); -- Added for Bug#3451073

16527: G_ParChildTsk_chks_deferred := 'Y';
16528: -- initialize the special global tables and counter set up
16529: -- to handle task number changes
16530:
16531: l_is_wp_seperate_from_fn := PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN( l_project_id ); -- Added for Bug#3451073
16532: WHILE i IS NOT NULL LOOP
16533:
16534: l_task_id := NULL;
16535:

Line 17608: PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED := PA_PROJ_TASK_STRUC_PUB.IS_WP_VERSIONING_ENABLED( l_project_id );

17604:
17605: -- Changes start for Bug# 3931805
17606: IF NVL( p_pm_product_code, 'WORKPLAN' ) <> 'WORKPLAN' -- We should not be calling the task weightage apis when it is the
17607: THEN -- publishing flow.
17608: PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED := PA_PROJ_TASK_STRUC_PUB.IS_WP_VERSIONING_ENABLED( l_project_id );
17609: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN := PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN( l_project_id );
17610: PA_PROJECT_PUB.G_Published_version_exists := PA_PROJ_TASK_STRUC_PUB.Published_version_exists( l_project_id );
17611:
17612: IF ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'N' ) OR

Line 17609: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN := PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN( l_project_id );

17605: -- Changes start for Bug# 3931805
17606: IF NVL( p_pm_product_code, 'WORKPLAN' ) <> 'WORKPLAN' -- We should not be calling the task weightage apis when it is the
17607: THEN -- publishing flow.
17608: PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED := PA_PROJ_TASK_STRUC_PUB.IS_WP_VERSIONING_ENABLED( l_project_id );
17609: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN := PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN( l_project_id );
17610: PA_PROJECT_PUB.G_Published_version_exists := PA_PROJ_TASK_STRUC_PUB.Published_version_exists( l_project_id );
17611:
17612: IF ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'N' ) OR
17613: ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'Y' AND

Line 17610: PA_PROJECT_PUB.G_Published_version_exists := PA_PROJ_TASK_STRUC_PUB.Published_version_exists( l_project_id );

17606: IF NVL( p_pm_product_code, 'WORKPLAN' ) <> 'WORKPLAN' -- We should not be calling the task weightage apis when it is the
17607: THEN -- publishing flow.
17608: PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED := PA_PROJ_TASK_STRUC_PUB.IS_WP_VERSIONING_ENABLED( l_project_id );
17609: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN := PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN( l_project_id );
17610: PA_PROJECT_PUB.G_Published_version_exists := PA_PROJ_TASK_STRUC_PUB.Published_version_exists( l_project_id );
17611:
17612: IF ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'N' ) OR
17613: ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'Y' AND
17614: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN = 'N' AND

Line 17622: PA_PROJ_TASK_STRUC_PUB.PROCESS_WBS_UPDATES(p_calling_context => 'ONLINE_UPDATE'

17618: l_update_wbs_flag := PA_PROJECT_STRUCTURE_UTILS.GET_UPDATE_WBS_FLAG(p_project_id => l_project_id
17619: ,p_structure_version_id => l_structure_version_id ) ;
17620: IF nvl(l_update_wbs_flag,'N') = 'Y' THEN
17621: IF p_project_in.process_mode = 'ONLINE' THEN
17622: PA_PROJ_TASK_STRUC_PUB.PROCESS_WBS_UPDATES(p_calling_context => 'ONLINE_UPDATE'
17623: ,p_project_id => l_project_id
17624: ,p_structure_version_id => l_structure_version_id
17625: ,x_return_status => l_return_status
17626: ,x_msg_count => l_msg_count

Line 17637: PA_PROJ_TASK_STRUC_PUB. PROCESS_WBS_UPDATES_CONC_WRP(p_calling_context => 'CONC_UPDATE'

17633: RAISE FND_API.G_EXC_ERROR;
17634: END IF;
17635: ELSIF p_project_in.process_mode = 'CONCURRENT' THEN
17636:
17637: PA_PROJ_TASK_STRUC_PUB. PROCESS_WBS_UPDATES_CONC_WRP(p_calling_context => 'CONC_UPDATE'
17638: ,p_project_id => l_project_id
17639: ,p_structure_version_id => l_structure_version_id
17640: ,x_return_status => l_return_status
17641: ,x_msg_count => l_msg_count

Line 17847: PA_PROJ_TASK_STRUC_PUB.convert_pm_parent_task_ref(

17843: AND p_tasks_in(i).pm_parent_task_reference IS NOT NULL)
17844: THEN
17845: --convert pm_parent_task_reference to parent_task_id.
17846: --All the parent tasks are created first then child tasks are created. See TRM for AMG load_task api.
17847: PA_PROJ_TASK_STRUC_PUB.convert_pm_parent_task_ref(
17848: p_pm_parent_task_reference => p_tasks_in(i).pm_parent_task_reference
17849: ,p_project_id => l_project_id
17850: ,x_parent_task_id => v_parent_task_id
17851: ,x_return_status => l_return_status

Line 17876: PA_PROJ_TASK_STRUC_PUB.CREATE_TASK_STRUCTURE(

17872: ELSE
17873: v_parent_task_id := null;
17874: END IF;
17875:
17876: PA_PROJ_TASK_STRUC_PUB.CREATE_TASK_STRUCTURE(
17877: p_project_id => l_project_id
17878: ,p_task_id => p_tasks_in(i).pa_task_id
17879: ,p_parent_task_id => v_parent_task_id
17880: ,p_ref_task_id => v_ref_task_id

Line 17990: PA_PROJ_TASK_STRUC_PUB.UPDATE_TASK_STRUCTURE(

17986: p_return_status := FND_API.G_RET_STS_ERROR;
17987: RAISE FND_API.G_EXC_ERROR;
17988: END IF;
17989:
17990: PA_PROJ_TASK_STRUC_PUB.UPDATE_TASK_STRUCTURE(
17991: p_project_id => l_project_id
17992: ,p_task_id => p_tasks_in(i).pa_task_id
17993: ,p_ref_task_id => v_ref_task_id
17994: ,p_task_number => p_tasks_in(i).pa_task_number

Line 18075: pa_debug.g_err_stage := 'Calling PA_PROJ_TASK_STRUC_PUB.PROCESS_TASK_STRUCTURE_BULK ' ;

18071: --Added for bug 2931183
18072: IF nvl(p_pm_product_code,'WORKPLAN') <> 'WORKPLAN' AND p_pass_entire_structure = 'Y' -- bug 3548473 : 3627124
18073: THEN
18074: IF l_debug_mode = 'Y' THEN
18075: pa_debug.g_err_stage := 'Calling PA_PROJ_TASK_STRUC_PUB.PROCESS_TASK_STRUCTURE_BULK ' ;
18076: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
18077: END IF;
18078:
18079: PA_PROJ_TASK_STRUC_PUB.PROCESS_TASK_STRUCTURE_BULK(

Line 18079: PA_PROJ_TASK_STRUC_PUB.PROCESS_TASK_STRUCTURE_BULK(

18075: pa_debug.g_err_stage := 'Calling PA_PROJ_TASK_STRUC_PUB.PROCESS_TASK_STRUCTURE_BULK ' ;
18076: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
18077: END IF;
18078:
18079: PA_PROJ_TASK_STRUC_PUB.PROCESS_TASK_STRUCTURE_BULK(
18080: p_api_version_number => p_api_version_number
18081: ,p_commit => FND_API.G_FALSE--bug 3766967
18082: ,p_project_id => l_project_id
18083: ,p_source_project_id => l_project_in_rec.created_from_project_id --ADUT. Included this new param.

Line 18100: pa_debug.g_err_stage := 'After PA_PROJ_TASK_STRUC_PUB.PROCESS_TASK_STRUCTURE_BULK...p_return_status=||p_return_status';

18096: ,x_msg_data => p_msg_data
18097: );
18098:
18099: IF l_debug_mode = 'Y' THEN
18100: pa_debug.g_err_stage := 'After PA_PROJ_TASK_STRUC_PUB.PROCESS_TASK_STRUCTURE_BULK...p_return_status=||p_return_status';
18101: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
18102: END IF;
18103:
18104:

Line 18115: pa_debug.g_err_stage := 'Returned from PA_PROJ_TASK_STRUC_PUB.PROCESS_TASK_STRUCTURE_BULK ' ;

18111: RAISE FND_API.G_EXC_ERROR;
18112: END IF;
18113:
18114: IF l_debug_mode = 'Y' THEN
18115: pa_debug.g_err_stage := 'Returned from PA_PROJ_TASK_STRUC_PUB.PROCESS_TASK_STRUCTURE_BULK ' ;
18116: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
18117: END IF;
18118: END IF; --for p_pm_product_code is not workplan
18119:

Line 18125: PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED := PA_PROJ_TASK_STRUC_PUB.IS_WP_VERSIONING_ENABLED( l_project_id );

18121: IF l_structure_type = 'FINANCIAL'
18122: THEN
18123: IF NVL( p_pm_product_code, 'WORKPLAN' ) <> 'WORKPLAN' -- We should not be calling the task weightage apis when it is the
18124: THEN -- publishing flow.
18125: PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED := PA_PROJ_TASK_STRUC_PUB.IS_WP_VERSIONING_ENABLED( l_project_id );
18126: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN := PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN( l_project_id );
18127: PA_PROJECT_PUB.G_Published_version_exists := PA_PROJ_TASK_STRUC_PUB.Published_version_exists( l_project_id );
18128:
18129: IF ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'N' ) OR

Line 18126: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN := PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN( l_project_id );

18122: THEN
18123: IF NVL( p_pm_product_code, 'WORKPLAN' ) <> 'WORKPLAN' -- We should not be calling the task weightage apis when it is the
18124: THEN -- publishing flow.
18125: PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED := PA_PROJ_TASK_STRUC_PUB.IS_WP_VERSIONING_ENABLED( l_project_id );
18126: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN := PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN( l_project_id );
18127: PA_PROJECT_PUB.G_Published_version_exists := PA_PROJ_TASK_STRUC_PUB.Published_version_exists( l_project_id );
18128:
18129: IF ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'N' ) OR
18130: ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'Y' AND

Line 18127: PA_PROJECT_PUB.G_Published_version_exists := PA_PROJ_TASK_STRUC_PUB.Published_version_exists( l_project_id );

18123: IF NVL( p_pm_product_code, 'WORKPLAN' ) <> 'WORKPLAN' -- We should not be calling the task weightage apis when it is the
18124: THEN -- publishing flow.
18125: PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED := PA_PROJ_TASK_STRUC_PUB.IS_WP_VERSIONING_ENABLED( l_project_id );
18126: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN := PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN( l_project_id );
18127: PA_PROJECT_PUB.G_Published_version_exists := PA_PROJ_TASK_STRUC_PUB.Published_version_exists( l_project_id );
18128:
18129: IF ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'N' ) OR
18130: ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'Y' AND
18131: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN = 'N' AND

Line 18139: PA_PROJ_TASK_STRUC_PUB.PROCESS_WBS_UPDATES(p_calling_context => 'ONLINE_UPDATE'

18135: l_update_wbs_flag := PA_PROJECT_STRUCTURE_UTILS.GET_UPDATE_WBS_FLAG(p_project_id => l_project_id
18136: ,p_structure_version_id => l_structure_version_id ) ;
18137: IF nvl(l_update_wbs_flag,'N') = 'Y' THEN
18138: IF p_project_in.process_mode = 'ONLINE' THEN
18139: PA_PROJ_TASK_STRUC_PUB.PROCESS_WBS_UPDATES(p_calling_context => 'ONLINE_UPDATE'
18140: ,p_project_id => l_project_id
18141: ,p_structure_version_id => l_structure_version_id
18142: ,x_return_status => l_return_status
18143: ,x_msg_count => l_msg_count

Line 18154: PA_PROJ_TASK_STRUC_PUB.PROCESS_WBS_UPDATES_CONC_WRP(p_calling_context => 'CONC_UPDATE'

18150: RAISE FND_API.G_EXC_ERROR;
18151: END IF;
18152: ELSIF p_project_in.process_mode = 'CONCURRENT' THEN
18153:
18154: PA_PROJ_TASK_STRUC_PUB.PROCESS_WBS_UPDATES_CONC_WRP(p_calling_context => 'CONC_UPDATE'
18155: ,p_project_id => l_project_id
18156: ,p_structure_version_id => l_structure_version_id
18157: ,x_return_status => l_return_status
18158: ,x_msg_count => l_msg_count

Line 18176: ----Commented The below code for bug 2931183 as the processing will be done in PA_PROJ_TASK_STRUC_PUB.PROCESS_TASK_STRUCTURE_BULK

18172: --Bug 6163090
18173:
18174:
18175:
18176: ----Commented The below code for bug 2931183 as the processing will be done in PA_PROJ_TASK_STRUC_PUB.PROCESS_TASK_STRUCTURE_BULK
18177:
18178: -- Bug # 5077599.
18179:
18180: -- Uncommented the code below.

Line 18190: PA_PROJ_TASK_STRUC_PUB.recalc_task_weightings(

18186: AND (p_pm_product_code <> 'WORKPLAN')
18187: --bug 2871308: added condition to by-pass when calling from publish api
18188: --should not call if new task is added to FINANCIAL structure version
18189: THEN
18190: PA_PROJ_TASK_STRUC_PUB.recalc_task_weightings(
18191: p_tasks_in => l_tasks_out
18192: ,p_task_version_id => null
18193: ,x_msg_count => l_msg_count
18194: ,x_msg_data => l_msg_data

Line 18226: PA_PROJ_TASK_STRUC_PUB.rollup_dates(

18222: ,p_pa_structure_version_id => l_structure_version_id
18223: ,p_struc_return_status => l_return_status
18224: );
18225: END IF;
18226: PA_PROJ_TASK_STRUC_PUB.rollup_dates(
18227: p_tasks_in => l_tasks_out --null if called for one task
18228: ,p_task_version_id => null
18229: ,p_project_id => l_project_id
18230: ,P_structure_version_id => l_structure_version_id

Line 21323: IF (PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS(l_project_id) = 'Y') AND

21319: --This has been discussed today may 18 with Sakthi and Hubert. The reason is performance.
21320: IF nvl(p_pm_product_code,'WORKPLAN') <> 'WORKPLAN' --Should not run in publishing flow.
21321: THEN
21322: --bug 3845240: use l_project_id instead of p_project_out.pa_project_id
21323: IF (PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS(l_project_id) = 'Y') AND
21324: l_update_structure_version_id IS NOT NULL AND
21325: l_update_structure_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
21326: THEN
21327: pa_proj_task_struc_pub.delete_intra_dependency(

Line 21327: pa_proj_task_struc_pub.delete_intra_dependency(

21323: IF (PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS(l_project_id) = 'Y') AND
21324: l_update_structure_version_id IS NOT NULL AND
21325: l_update_structure_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
21326: THEN
21327: pa_proj_task_struc_pub.delete_intra_dependency(
21328: p_element_version_id => l_update_structure_version_id
21329: ,x_return_status => l_return_status );
21330:
21331: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR

Line 21350: IF (PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS(l_project_id) = 'Y') THEN

21346: --Added by rtarway during FP.M Developement Mapping and Set Financial Changes.
21347: l_d_task_id := p_tasks_out(l_d_loop_count).pa_task_id;
21348:
21349: --bug 3845240: use l_project_id instead of p_project_out.pa_project_id
21350: IF (PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS(l_project_id) = 'Y') THEN
21351:
21352: --maansari5/18 replaced api call CONVERT_PM_TASKREF_TO_ID to CONVERT_PM_TASKREF_TO_ID_all
21353: IF l_d_task_id IS NULL AND l_task_in_rec.pm_task_reference IS NOT NULL AND
21354: l_task_in_rec.pm_task_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 21375: pa_proj_task_struc_pub.parse_predecessor_import(p_string => l_task_in_rec.pred_string

21371:
21372: l_d_task_ver_id := PA_PROJ_ELEMENTS_UTILS.GET_TASK_VERSION_ID(p_structure_version_id => l_update_structure_version_id
21373: ,p_task_id => l_d_task_id);
21374:
21375: pa_proj_task_struc_pub.parse_predecessor_import(p_string => l_task_in_rec.pred_string
21376: ,p_delimeter => l_task_in_rec.pred_delimiter
21377: ,p_task_version_Id => l_d_task_ver_id
21378: ,x_return_status => l_return_status
21379: ,x_msg_count => l_msg_count

Line 21442: G_PROJECT_SHARING_TYPE := PA_PROJ_TASK_STRUC_PUB.GET_SHARE_TYPE(l_project_id);

21438: END IF;
21439: --
21440:
21441: --Begin Add by rtarway FP.M changes for Mapping
21442: G_PROJECT_SHARING_TYPE := PA_PROJ_TASK_STRUC_PUB.GET_SHARE_TYPE(l_project_id);
21443: IF (G_PROJECT_SHARING_TYPE = 'SPLIT_MAPPING' AND p_structure_in.structure_type = 'WORKPLAN')
21444: THEN
21445: l_d_loop_count := p_tasks_in.first;
21446: WHILE l_d_loop_count IS NOT NULL LOOP

Line 22564: l_published_version_exists := PA_PROJ_TASK_STRUC_PUB.Published_version_exists( l_project_id );

22560: --only in public APIs.
22561:
22562: -- Initialize local variables
22563: -- Bug#3747312
22564: l_published_version_exists := PA_PROJ_TASK_STRUC_PUB.Published_version_exists( l_project_id );
22565: l_is_wp_separate_from_fn := PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN( l_project_id );
22566: l_is_wp_versioning_enabled := PA_PROJ_TASK_STRUC_PUB.IS_WP_VERSIONING_ENABLED( l_project_id );
22567:
22568: -- In case of shared structure p_structure_type should be passed as

Line 22565: l_is_wp_separate_from_fn := PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN( l_project_id );

22561:
22562: -- Initialize local variables
22563: -- Bug#3747312
22564: l_published_version_exists := PA_PROJ_TASK_STRUC_PUB.Published_version_exists( l_project_id );
22565: l_is_wp_separate_from_fn := PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN( l_project_id );
22566: l_is_wp_versioning_enabled := PA_PROJ_TASK_STRUC_PUB.IS_WP_VERSIONING_ENABLED( l_project_id );
22567:
22568: -- In case of shared structure p_structure_type should be passed as
22569: -- FINANCIAL and this should be the first validation.

Line 22566: l_is_wp_versioning_enabled := PA_PROJ_TASK_STRUC_PUB.IS_WP_VERSIONING_ENABLED( l_project_id );

22562: -- Initialize local variables
22563: -- Bug#3747312
22564: l_published_version_exists := PA_PROJ_TASK_STRUC_PUB.Published_version_exists( l_project_id );
22565: l_is_wp_separate_from_fn := PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN( l_project_id );
22566: l_is_wp_versioning_enabled := PA_PROJ_TASK_STRUC_PUB.IS_WP_VERSIONING_ENABLED( l_project_id );
22567:
22568: -- In case of shared structure p_structure_type should be passed as
22569: -- FINANCIAL and this should be the first validation.
22570: IF (p_structure_type is null OR p_structure_type = 'WORKPLAN') THEN

Line 22571: IF PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS( l_project_id ) = 'N' OR

22567:
22568: -- In case of shared structure p_structure_type should be passed as
22569: -- FINANCIAL and this should be the first validation.
22570: IF (p_structure_type is null OR p_structure_type = 'WORKPLAN') THEN
22571: IF PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS( l_project_id ) = 'N' OR
22572: NVL( l_is_wp_separate_from_fn,'N') = 'N' --bug 2876703 update_task
22573: THEN
22574: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
22575: THEN

Line 22633: l_project_sharing_type := PA_PROJ_TASK_STRUC_PUB.GET_SHARE_TYPE(l_project_id);

22629:
22630: --Added by rtarway for BUG 3919800
22631: --Validate for task and change the structure type, if structure type is shared partial and workplan task is being updated.
22632: --1. get the structure sharing code
22633: l_project_sharing_type := PA_PROJ_TASK_STRUC_PUB.GET_SHARE_TYPE(l_project_id);
22634: IF (l_project_sharing_type='SHARE_PARTIAL' )
22635: THEN
22636: --3. get the structure version id
22637: IF (l_structure_version_id is null or l_structure_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)

Line 23340: PA_PROJ_TASK_STRUC_PUB.update_task_structure

23336:
23337:
23338: ----dbms_output.put_line('Value of p_task_number passed to update_task_structure'||p_task_number);
23339:
23340: PA_PROJ_TASK_STRUC_PUB.update_task_structure
23341: (
23342: p_calling_module => 'AMG'
23343: ,p_task_id => l_pa_task_id --BUG 3919800, rtarway
23344: ,p_ref_task_id => l_ref_task_id --Bug 3705333 changed from p_ref_task_id to l_ref_task_id

Line 23460: -- IF PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS( l_project_id ) = 'N' OR

23456:
23457: ELSIF l_structure_type = 'WORKPLAN' --p_structure_type
23458: THEN
23459: -- Moved this code up. As this should be the first validation the should be performed
23460: -- IF PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS( l_project_id ) = 'N' OR
23461: --If update task is called from update_project api then PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN wont be called
23462: --bcoz G_IS_WP_SEPARATE_FROM_FN will already be set by upate_project.
23463: -- NVL( G_IS_WP_SEPARATE_FROM_FN, PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN( l_project_id ) ) = 'N' --bug 2876703 update_task
23464: --THEN

Line 23461: --If update task is called from update_project api then PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN wont be called

23457: ELSIF l_structure_type = 'WORKPLAN' --p_structure_type
23458: THEN
23459: -- Moved this code up. As this should be the first validation the should be performed
23460: -- IF PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS( l_project_id ) = 'N' OR
23461: --If update task is called from update_project api then PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN wont be called
23462: --bcoz G_IS_WP_SEPARATE_FROM_FN will already be set by upate_project.
23463: -- NVL( G_IS_WP_SEPARATE_FROM_FN, PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN( l_project_id ) ) = 'N' --bug 2876703 update_task
23464: --THEN
23465: -- IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

Line 23463: -- NVL( G_IS_WP_SEPARATE_FROM_FN, PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN( l_project_id ) ) = 'N' --bug 2876703 update_task

23459: -- Moved this code up. As this should be the first validation the should be performed
23460: -- IF PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS( l_project_id ) = 'N' OR
23461: --If update task is called from update_project api then PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN wont be called
23462: --bcoz G_IS_WP_SEPARATE_FROM_FN will already be set by upate_project.
23463: -- NVL( G_IS_WP_SEPARATE_FROM_FN, PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN( l_project_id ) ) = 'N' --bug 2876703 update_task
23464: --THEN
23465: -- IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
23466: -- THEN
23467: -- pa_interface_utils_pub.map_new_amg_msg

Line 23658: PA_PROJ_TASK_STRUC_PUB.update_task_structure

23654: --bug 2665656
23655: IF NVL( p_pm_product_code, 'WORKPLAN' ) <> 'WORKPLAN'
23656: THEN
23657: --bug 2665656
23658: PA_PROJ_TASK_STRUC_PUB.update_task_structure
23659: (
23660: p_calling_module => 'AMG'
23661: ,p_task_id => l_pa_task_id --BUG 3919800, rtarway
23662: ,p_ref_task_id => l_ref_task_id --Bug 3705333 changed from p_ref_task_id to l_ref_task_id

Line 23783: G_PROJECT_SHARING_TYPE := PA_PROJ_TASK_STRUC_PUB.GET_SHARE_TYPE(l_project_id);

23779: END IF; --<>
23780: --Begin Add by rtarway FP.M changes for Mapping
23781: --No Function Security Check required
23782: --Call the update_mapping only if p_mapped_task_reference or p_mapped_task_id is passed
23783: G_PROJECT_SHARING_TYPE := PA_PROJ_TASK_STRUC_PUB.GET_SHARE_TYPE(l_project_id);
23784: IF (G_PROJECT_SHARING_TYPE = 'SPLIT_MAPPING' and nvl(l_is_wp_separate_from_fn,'N') = 'Y')
23785: THEN
23786: IF (
23787: ( p_mapped_task_reference IS NULL OR p_mapped_task_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR )

Line 23865: IF PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS( l_project_id ) = 'Y'

23861: AND p_calling_api <> 'UPDATE_PROJECT' --bug 4199694 This is required otherwise dates rollup and concurrent program will called in update_project flow multiple times.
23862: THEN
23863: ---bug 4199694
23864: --call directly the PA_STRUCT_TASK_ROLLUP_PUB.Tasks_Rollup api. No need to call the rollup_dates here as its called per task.
23865: IF PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS( l_project_id ) = 'Y'
23866: THEN
23867: IF l_task_version_id IS NULL
23868: THEN
23869: l_task_version_id := PA_PROJ_ELEMENTS_UTILS.GET_TASK_VERSION_ID(l_structure_version_id, l_pa_task_id);

Line 23871: PA_PROJ_TASK_STRUC_PUB.rollup_dates(

23867: IF l_task_version_id IS NULL
23868: THEN
23869: l_task_version_id := PA_PROJ_ELEMENTS_UTILS.GET_TASK_VERSION_ID(l_structure_version_id, l_pa_task_id);
23870: END IF;
23871: PA_PROJ_TASK_STRUC_PUB.rollup_dates(
23872: p_tasks_in => l_tasks_out
23873: ,p_task_version_id => l_task_version_id
23874: ,p_project_id => l_project_id
23875: ,P_structure_version_id => l_structure_version_id

Line 23893: PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED := PA_PROJ_TASK_STRUC_PUB.IS_WP_VERSIONING_ENABLED( l_project_id ); -- Bug 3106457

23889: END IF;
23890: ---bug 4199694
23891:
23892: -- These globals have been intialized before they are used!
23893: PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED := PA_PROJ_TASK_STRUC_PUB.IS_WP_VERSIONING_ENABLED( l_project_id ); -- Bug 3106457
23894: /* Commented the code below for bug#3451073
23895: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN := PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN( l_project_id ); -- Bug 3106457 */
23896: /* Added the If condition Bug#3451073 */
23897: IF p_is_wp_seperate_from_fn = 'X'

Line 23895: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN := PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN( l_project_id ); -- Bug 3106457 */

23891:
23892: -- These globals have been intialized before they are used!
23893: PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED := PA_PROJ_TASK_STRUC_PUB.IS_WP_VERSIONING_ENABLED( l_project_id ); -- Bug 3106457
23894: /* Commented the code below for bug#3451073
23895: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN := PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN( l_project_id ); -- Bug 3106457 */
23896: /* Added the If condition Bug#3451073 */
23897: IF p_is_wp_seperate_from_fn = 'X'
23898: THEN
23899: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN := PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN( l_project_id ); -- Bug 3106457

Line 23899: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN := PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN( l_project_id ); -- Bug 3106457

23895: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN := PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN( l_project_id ); -- Bug 3106457 */
23896: /* Added the If condition Bug#3451073 */
23897: IF p_is_wp_seperate_from_fn = 'X'
23898: THEN
23899: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN := PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN( l_project_id ); -- Bug 3106457
23900: ELSE
23901: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN := p_is_wp_seperate_from_fn; -- Addded for bug#3451073
23902: END IF;
23903:

Line 23904: PA_PROJECT_PUB.G_Published_version_exists := PA_PROJ_TASK_STRUC_PUB.Published_version_exists( l_project_id ); -- Bug 3106457

23900: ELSE
23901: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN := p_is_wp_seperate_from_fn; -- Addded for bug#3451073
23902: END IF;
23903:
23904: PA_PROJECT_PUB.G_Published_version_exists := PA_PROJ_TASK_STRUC_PUB.Published_version_exists( l_project_id ); -- Bug 3106457
23905:
23906: IF ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'N' ) OR
23907: ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'Y' AND
23908: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN = 'N' AND

Line 23917: PA_PROJ_TASK_STRUC_PUB.PROCESS_WBS_UPDATES(p_calling_context => 'ONLINE_UPDATE'

23913: ,p_structure_version_id => l_structure_version_id ) ; -- Bug 3106457
23914: IF nvl(l_update_wbs_flag,'N') = 'Y' THEN
23915: IF p_process_mode = 'ONLINE' THEN
23916:
23917: PA_PROJ_TASK_STRUC_PUB.PROCESS_WBS_UPDATES(p_calling_context => 'ONLINE_UPDATE'
23918: ,p_project_id => l_project_id -- Bug 3106457 p_pa_project_id
23919: ,p_structure_version_id => l_structure_version_id -- Bug 3106457 p_structure_version_id
23920: ,x_return_status => l_return_status
23921: ,x_msg_count => l_msg_count

Line 23933: PA_PROJ_TASK_STRUC_PUB. PROCESS_WBS_UPDATES_CONC_WRP(p_calling_context => 'CONC_UPDATE'

23929: RAISE FND_API.G_EXC_ERROR;
23930: END IF;
23931: ELSIF p_process_mode = 'CONCURRENT' THEN
23932:
23933: PA_PROJ_TASK_STRUC_PUB. PROCESS_WBS_UPDATES_CONC_WRP(p_calling_context => 'CONC_UPDATE'
23934: ,p_project_id => l_project_id --Bug 3106457 p_pa_project_id
23935: ,p_structure_version_id => l_structure_version_id -- Bug 3106457 p_structure_version_id
23936: ,x_return_status => l_return_status
23937: ,x_msg_count => l_msg_count

Line 23961: IF (PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS(l_project_id) = 'Y') THEN --Bug#3747312

23957: ,p_out_task_id => l_d_task_id
23958: ,p_return_status => l_return_status);
23959: */
23960:
23961: IF (PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS(l_project_id) = 'Y') THEN --Bug#3747312
23962:
23963: IF l_d_task_id IS NULL AND p_pm_task_reference IS NOT NULL AND p_pm_task_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
23964: THEN
23965: PA_PROJECT_PVT.CONVERT_PM_TASKREF_TO_ID_all(p_pa_project_id => l_project_id --Bug#3747312 p_pa_project_id

Line 23989: pa_proj_task_struc_pub.parse_predecessor_import(p_string => p_pred_string

23985:
23986: l_d_task_ver_id := PA_PROJ_ELEMENTS_UTILS.GET_TASK_VERSION_ID(p_structure_version_id => l_structure_version_id
23987: ,p_task_id => l_d_task_id);
23988:
23989: pa_proj_task_struc_pub.parse_predecessor_import(p_string => p_pred_string
23990: ,p_delimeter => p_pred_delimiter
23991: ,p_task_version_Id => l_d_task_ver_id
23992: ,x_return_status => l_return_status
23993: ,x_msg_count => l_msg_count

Line 24384: IF PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS( p_project_id ) = 'N' OR

24380:
24381: --bug 2876703 --check_delete_task_ok
24382: IF p_structure_type = 'WORKPLAN' AND p_project_id IS NOT NULL AND p_project_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
24383: THEN
24384: IF PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS( p_project_id ) = 'N' OR
24385: PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN( p_project_id ) = 'N'
24386: THEN
24387: l_retrieve := 'Y' ;
24388: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

Line 24385: PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN( p_project_id ) = 'N'

24381: --bug 2876703 --check_delete_task_ok
24382: IF p_structure_type = 'WORKPLAN' AND p_project_id IS NOT NULL AND p_project_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
24383: THEN
24384: IF PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS( p_project_id ) = 'N' OR
24385: PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN( p_project_id ) = 'N'
24386: THEN
24387: l_retrieve := 'Y' ;
24388: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
24389: THEN

Line 27602: PA_PROJ_TASK_STRUC_PUB.PROCESS_WBS_UPDATES(p_calling_context => 'ONLINE_PUBLISH'

27598: IF p_process_mode = 'ONLINE' THEN
27599:
27600: --Added by rtarway for BUG 4032291
27601: if p_status_code = 'STRUCTURE_PUBLISHED' then
27602: PA_PROJ_TASK_STRUC_PUB.PROCESS_WBS_UPDATES(p_calling_context => 'ONLINE_PUBLISH'
27603: ,p_project_id => p_pa_project_id
27604: ,p_commit => p_commit
27605: -- Fix for Bug # 4314797.
27606: ,p_structure_version_id => p_structure_version_id

Line 27613: PA_PROJ_TASK_STRUC_PUB.PROCESS_WBS_UPDATES(p_calling_context => 'ONLINE_UPDATE'

27609: ,x_msg_count => l_msg_count
27610: ,x_msg_data => l_msg_data ) ;
27611: --Added by rtarway for BUG 4032291
27612: else
27613: PA_PROJ_TASK_STRUC_PUB.PROCESS_WBS_UPDATES(p_calling_context => 'ONLINE_UPDATE'
27614: ,p_project_id => p_pa_project_id
27615: ,p_structure_version_id => p_published_struct_ver_id
27616: ,x_return_status => l_return_status
27617: ,x_msg_count => l_msg_count

Line 27634: PA_PROJ_TASK_STRUC_PUB.PROCESS_WBS_UPDATES_CONC_WRP(p_calling_context => 'CONC_PUBLISH'

27630: ELSIF p_process_mode = 'CONCURRENT' THEN
27631: /* Added if block for bug 5390015 */
27632: IF p_status_code = 'STRUCTURE_PUBLISHED' THEN
27633:
27634: PA_PROJ_TASK_STRUC_PUB.PROCESS_WBS_UPDATES_CONC_WRP(p_calling_context => 'CONC_PUBLISH'
27635: ,p_project_id => p_pa_project_id
27636: ,p_commit => p_commit
27637: ,p_structure_version_id => p_structure_version_id
27638: ,p_pub_struc_ver_id => p_published_struct_ver_id

Line 27644: PA_PROJ_TASK_STRUC_PUB.PROCESS_WBS_UPDATES_CONC_WRP(p_calling_context => 'CONC_UPDATE'

27640: ,x_msg_count => l_msg_count
27641: ,x_msg_data => l_msg_data ) ;
27642: ELSE
27643:
27644: PA_PROJ_TASK_STRUC_PUB.PROCESS_WBS_UPDATES_CONC_WRP(p_calling_context => 'CONC_UPDATE'
27645: ,p_project_id => p_pa_project_id
27646: ,p_structure_version_id => p_published_struct_ver_id
27647: ,x_return_status => l_return_status
27648: ,x_msg_count => l_msg_count

Line 27831: PA_PROJ_TASK_STRUC_PUB.DELETE_STRUCTURE_VERSION(

27827: -- Set API return status to success
27828:
27829: p_return_status := FND_API.G_RET_STS_SUCCESS;
27830:
27831: PA_PROJ_TASK_STRUC_PUB.DELETE_STRUCTURE_VERSION(
27832: p_api_version => p_api_version_number
27833: ,p_init_msg_list => p_init_msg_list
27834: ,p_commit => FND_API.G_FALSE--bug 3766967
27835: ,p_calling_module => 'AMG'

Line 28210: PA_PROJ_TASK_STRUC_PUB.get_task_version_id(

28206: p_return_status := FND_API.G_RET_STS_ERROR;
28207: RAISE FND_API.G_EXC_ERROR;
28208: END IF;
28209:
28210: PA_PROJ_TASK_STRUC_PUB.get_task_version_id(
28211: p_project_id => p_pa_project_id
28212: ,p_structure_version_id => p_pa_structure_version_id
28213: ,p_task_id => p_pa_task_id
28214: ,x_task_version_id => p_task_version_id

Line 33495: IF (PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS(l_project_id) = 'Y') THEN

33491: AND ( p_wp_structure_version_id IS NULL OR p_wp_structure_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
33492: )
33493: THEN
33494:
33495: IF (PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS(l_project_id) = 'Y') THEN
33496: l_wp_structure_version_id := PA_PROJ_ELEMENTS_UTILS.LATEST_PUBLISHED_VER_ID(l_project_id, 'WORKPLAN');
33497: IF (l_wp_structure_version_id = -1 OR l_wp_structure_version_id = NULL)
33498: THEN
33499: l_wp_structure_version_id := PA_PROJECT_STRUCTURE_UTILS.get_current_working_ver_id(l_project_id);

Line 33850: IF (PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS(l_project_id) = 'Y') THEN

33846: --Get the task version id from Wkp task Id
33847: -- Avoid this call if wkp task name and wkp task version ids are passed
33848: IF (l_wkp_task_id IS NOT NULL AND l_wkp_structure_version_id IS NULL ) THEN
33849:
33850: IF (PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS(l_project_id) = 'Y') THEN
33851: l_wkp_structure_version_id := PA_PROJ_ELEMENTS_UTILS.LATEST_PUBLISHED_VER_ID(l_project_id, 'WORKPLAN');
33852: IF (l_wkp_structure_version_id = -1 OR l_wkp_structure_version_id = NULL)
33853: THEN
33854: l_wkp_structure_version_id := PA_PROJECT_STRUCTURE_UTILS.get_current_working_ver_id(l_project_id);

Line 34198: IF (PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS(l_project_id) = 'Y') THEN

34194:
34195: --Get the task version id from Wkp task Id
34196: -- Avoid this call if wkp task name and wkp task version ids are passed
34197: IF (l_wkp_task_id IS NOT NULL AND l_wkp_structure_version_id IS NULL ) THEN
34198: IF (PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS(l_project_id) = 'Y') THEN
34199: l_wkp_structure_version_id := PA_PROJ_ELEMENTS_UTILS.LATEST_PUBLISHED_VER_ID(l_project_id, 'WORKPLAN');
34200: IF (l_wkp_structure_version_id IS NULL OR l_wkp_structure_version_id = -1) THEN
34201: l_wkp_structure_version_id := PA_PROJECT_STRUCTURE_UTILS.get_current_working_ver_id(l_project_id);
34202: END IF;

Line 34402: l_proj_share_type := PA_PROJ_TASK_STRUC_PUB.GET_SHARE_TYPE(l_project_id);

34398: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
34399: RAISE FND_API.G_EXC_ERROR;
34400: END IF;
34401: -- Get the project sharing type
34402: l_proj_share_type := PA_PROJ_TASK_STRUC_PUB.GET_SHARE_TYPE(l_project_id);
34403: IF (l_proj_share_type = 'SHARE_PARTIAL' and p_structure_type = 'FINANCIAL')
34404: THEN
34405: FOR iCounter IN REVERSE p_tasks_in_tbl.FIRST..p_tasks_in_tbl.LAST LOOP
34406: l_task_rec := p_tasks_in_tbl(iCounter);

Line 35466: PA_PROJ_TASK_STRUC_PUB.get_version_ids

35462:
35463: END IF;
35464: --get structure_version_id and task_version_id
35465:
35466: PA_PROJ_TASK_STRUC_PUB.get_version_ids
35467: (p_task_id => l_task_id
35468: , p_task_version_id => p_task_version_id
35469: , p_project_id => l_project_id
35470: , x_structure_version_id => l_structure_version_id

Line 35530: l_wp_str_exists := PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS( p_project_id );

35526: open l_amg_task_csr(l_task_id );
35527: fetch l_amg_task_csr INTO l_amg_task_number;
35528: close l_amg_task_csr;
35529:
35530: l_wp_str_exists := PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS( p_project_id );
35531: l_versioning_enabled := PA_PROJ_TASK_STRUC_PUB.IS_WP_VERSIONING_ENABLED( l_project_id);
35532: l_pub_ver_exists := PA_PROJ_TASK_STRUC_PUB.Published_version_exists( l_project_id );
35533:
35534: -- If this passed task belongs to a Split - Fin. Only structure

Line 35531: l_versioning_enabled := PA_PROJ_TASK_STRUC_PUB.IS_WP_VERSIONING_ENABLED( l_project_id);

35527: fetch l_amg_task_csr INTO l_amg_task_number;
35528: close l_amg_task_csr;
35529:
35530: l_wp_str_exists := PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS( p_project_id );
35531: l_versioning_enabled := PA_PROJ_TASK_STRUC_PUB.IS_WP_VERSIONING_ENABLED( l_project_id);
35532: l_pub_ver_exists := PA_PROJ_TASK_STRUC_PUB.Published_version_exists( l_project_id );
35533:
35534: -- If this passed task belongs to a Split - Fin. Only structure
35535: IF nvl(l_wp_str_exists,'N') = 'N'

Line 35532: l_pub_ver_exists := PA_PROJ_TASK_STRUC_PUB.Published_version_exists( l_project_id );

35528: close l_amg_task_csr;
35529:
35530: l_wp_str_exists := PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS( p_project_id );
35531: l_versioning_enabled := PA_PROJ_TASK_STRUC_PUB.IS_WP_VERSIONING_ENABLED( l_project_id);
35532: l_pub_ver_exists := PA_PROJ_TASK_STRUC_PUB.Published_version_exists( l_project_id );
35533:
35534: -- If this passed task belongs to a Split - Fin. Only structure
35535: IF nvl(l_wp_str_exists,'N') = 'N'
35536: AND (PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version(l_structure_version_id, 'FINANCIAL') = 'Y')

Line 35899: PA_PROJ_TASK_STRUC_PUB.PROCESS_WBS_UPDATES(p_calling_context => 'ONLINE_UPDATE'

35895: IF nvl(l_message_type,'NOT_PROCESS') <> 'PROCESS' THEN
35896:
35897: IF p_process_mode = 'ONLINE' THEN
35898:
35899: PA_PROJ_TASK_STRUC_PUB.PROCESS_WBS_UPDATES(p_calling_context => 'ONLINE_UPDATE'
35900: ,p_project_id => l_project_id
35901: ,p_structure_version_id => p_structure_version_id
35902: ,x_return_status => l_return_status
35903: ,x_msg_count => l_msg_count

Line 35916: PA_PROJ_TASK_STRUC_PUB.PROCESS_WBS_UPDATES_CONC_WRP(p_calling_context => 'CONC_UPDATE'

35912: END IF;
35913:
35914: ELSIF p_process_mode = 'CONCURRENT' THEN
35915:
35916: PA_PROJ_TASK_STRUC_PUB.PROCESS_WBS_UPDATES_CONC_WRP(p_calling_context => 'CONC_UPDATE'
35917: ,p_project_id => l_project_id
35918: ,p_structure_version_id => p_structure_version_id
35919: ,x_return_status => l_return_status
35920: ,x_msg_count => l_msg_count