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 4440: l_delta := PA_PROJ_TASK_STRUC_PUB.get_proj_dates_delta(

4436:
4437: --Project Structure Integration
4438: --This creates the
4439: /* not required as
4440: l_delta := PA_PROJ_TASK_STRUC_PUB.get_proj_dates_delta(
4441: l_project_in_rec.created_from_project_id
4442: ,l_out_start_date );
4443: */
4444:

Line 4446: PA_PROJ_TASK_STRUC_PUB.COPY_STRUCTURE(

4442: ,l_out_start_date );
4443: */
4444:
4445: /*--bug 2805602 we dont this anymore as copy project will take care of creating structures only
4446: PA_PROJ_TASK_STRUC_PUB.COPY_STRUCTURE(
4447: p_dest_project_id => l_project_id
4448: ,p_src_project_id => l_project_in_rec.created_from_project_id
4449: ,p_delta => l_delta
4450: ,p_copy_task_flag => 'N'

Line 4477: PA_PROJ_TASK_STRUC_PUB.Clean_unwanted_tasks(

4473:
4474: --Clean up first the unwanted tasks that are created by copy_structure in pa_proj_elements
4475: --although they had not been created in pa_tasks.
4476:
4477: PA_PROJ_TASK_STRUC_PUB.Clean_unwanted_tasks(
4478: p_project_id => l_project_id
4479: ,x_msg_count => l_msg_count
4480: ,x_msg_data => l_msg_data
4481: ,x_return_status => l_return_status

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

4493:
4494: --Project Structure Integration
4495:
4496: --bug 2738747 --create project api. Here ther is actually no pupose of this call
4497: G_Published_version_exists := PA_PROJ_TASK_STRUC_PUB.Published_version_exists( l_project_id );
4498: G_IS_WP_SEPARATE_FROM_FN := PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN( l_project_id );
4499: G_IS_WP_VERSIONING_ENABLED := PA_PROJ_TASK_STRUC_PUB.IS_WP_VERSIONING_ENABLED( l_project_id );
4500: --bug 2738747
4501:

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

4494: --Project Structure Integration
4495:
4496: --bug 2738747 --create project api. Here ther is actually no pupose of this call
4497: G_Published_version_exists := PA_PROJ_TASK_STRUC_PUB.Published_version_exists( l_project_id );
4498: G_IS_WP_SEPARATE_FROM_FN := PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN( l_project_id );
4499: G_IS_WP_VERSIONING_ENABLED := PA_PROJ_TASK_STRUC_PUB.IS_WP_VERSIONING_ENABLED( l_project_id );
4500: --bug 2738747
4501:
4502: G_WP_STR_EXISTS := PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS( l_project_id );

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

4495:
4496: --bug 2738747 --create project api. Here ther is actually no pupose of this call
4497: G_Published_version_exists := PA_PROJ_TASK_STRUC_PUB.Published_version_exists( l_project_id );
4498: G_IS_WP_SEPARATE_FROM_FN := PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN( l_project_id );
4499: G_IS_WP_VERSIONING_ENABLED := PA_PROJ_TASK_STRUC_PUB.IS_WP_VERSIONING_ENABLED( l_project_id );
4500: --bug 2738747
4501:
4502: G_WP_STR_EXISTS := PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS( l_project_id );
4503: --Begin Add by rtarway FP.M changes for mapping

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

4498: G_IS_WP_SEPARATE_FROM_FN := PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN( l_project_id );
4499: G_IS_WP_VERSIONING_ENABLED := PA_PROJ_TASK_STRUC_PUB.IS_WP_VERSIONING_ENABLED( l_project_id );
4500: --bug 2738747
4501:
4502: G_WP_STR_EXISTS := PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS( l_project_id );
4503: --Begin Add by rtarway FP.M changes for mapping
4504: G_PROJECT_SHARING_TYPE := PA_PROJ_TASK_STRUC_PUB.GET_SHARE_TYPE(l_project_id);
4505: --End Add by rtarway FP.M changes for mapping
4506:

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

4500: --bug 2738747
4501:
4502: G_WP_STR_EXISTS := PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS( l_project_id );
4503: --Begin Add by rtarway FP.M changes for mapping
4504: G_PROJECT_SHARING_TYPE := PA_PROJ_TASK_STRUC_PUB.GET_SHARE_TYPE(l_project_id);
4505: --End Add by rtarway FP.M changes for mapping
4506:
4507: --TASK
4508: --add tasks to the just created project

Line 4843: PA_PROJ_TASK_STRUC_PUB.convert_pm_parent_task_ref(

4839: AND l_task_in_rec.pm_parent_task_reference IS NOT NULL)
4840: THEN
4841: --convert pm_parent_task_reference to parent_task_id.
4842: --All the parent tasks are created first then child tasks are created. See TRM for AMG load_task api.
4843: PA_PROJ_TASK_STRUC_PUB.convert_pm_parent_task_ref(
4844: p_pm_parent_task_reference => l_task_in_rec.pm_parent_task_reference
4845: ,p_project_id => l_project_id
4846: ,x_parent_task_id => v_parent_task_id
4847: ,x_return_status => l_return_status

Line 4881: PA_PROJ_TASK_STRUC_PUB.CREATE_TASK_STRUCTURE(

4877: l_ref_task_id := v_task_id;
4878: END IF;
4879: --proj conn
4880:
4881: PA_PROJ_TASK_STRUC_PUB.CREATE_TASK_STRUCTURE(
4882: p_project_id => l_project_id
4883: ,p_task_id => l_task_in_rec.pa_task_id
4884: ,p_parent_task_id => v_parent_task_id
4885: ,p_ref_task_id => l_ref_task_id --proj conn

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

4981:
4982: -- Made the following changes for post FP K one off. Bug 2931183
4983: -- Performance changes.
4984: IF l_debug_mode = 'Y' THEN
4985: pa_debug.g_err_stage := 'Calling PA_PROJ_TASK_STRUC_PUB.PROCESS_TASK_STRUCTURE_BULK ' ;
4986: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
4987: END IF;
4988:
4989: --Set the global variable G_OP_VALIDATE_FLAG.

Line 4993: PA_PROJ_TASK_STRUC_PUB.PROCESS_TASK_STRUCTURE_BULK

4989: --Set the global variable G_OP_VALIDATE_FLAG.
4990: --BUG 4218977
4991: G_OP_VALIDATE_FLAG := p_op_validate_flag;
4992:
4993: PA_PROJ_TASK_STRUC_PUB.PROCESS_TASK_STRUCTURE_BULK
4994: ( p_api_version_number => p_api_version_number
4995: ,p_commit => FND_API.G_FALSE --p_commit : Bug 3668424: passing p_commit as FND_API.G_FALSE
4996: ,p_project_id => l_project_id -- Changed during UT.
4997: ,p_source_project_id => l_project_in_rec.created_from_project_id --ADUT. Included this new param.

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

5017: p_multiple_task_msg := 'F';
5018: END IF;
5019:
5020: IF l_debug_mode = 'Y' THEN
5021: pa_debug.g_err_stage := 'Returned from PA_PROJ_TASK_STRUC_PUB.PROCESS_TASK_STRUCTURE_BULK ' ;
5022: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
5023: END IF;
5024:
5025: /* Post FP K one off. Bug 2931183

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

5022: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
5023: END IF;
5024:
5025: /* Post FP K one off. Bug 2931183
5026: Commenting this code as this is done in PA_PROJ_TASK_STRUC_PUB.process_task_structure_bulk.
5027: --bug 2732895 --create_project
5028: IF ( G_WP_STR_EXISTS = 'Y' AND G_IS_WP_SEPARATE_FROM_FN = 'N' ) OR
5029: ( 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
5030: THEN

Line 5031: PA_PROJ_TASK_STRUC_PUB.recalc_task_weightings(

5027: --bug 2732895 --create_project
5028: IF ( G_WP_STR_EXISTS = 'Y' AND G_IS_WP_SEPARATE_FROM_FN = 'N' ) OR
5029: ( 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
5030: THEN
5031: PA_PROJ_TASK_STRUC_PUB.recalc_task_weightings(
5032: p_tasks_in => p_tasks_out
5033: ,p_task_version_id => null
5034: ,x_msg_count => l_msg_count
5035: ,x_msg_data => l_msg_data

Line 5051: PA_PROJ_TASK_STRUC_PUB.rollup_dates(

5047: END IF;
5048:
5049: --bug 2856033
5050:
5051: PA_PROJ_TASK_STRUC_PUB.rollup_dates(
5052: p_tasks_in => p_tasks_out
5053: ,p_task_version_id => null
5054: ,p_project_id => l_project_id
5055: ,P_structure_version_id => null

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

5095: -- p_project_out.pa_project_id is not available till this point. Should be replaced by following.
5096: -- l_d_task_id := p_tasks_out(l_d_loop_count).pa_task_id;
5097:
5098: --Commented by rtarway FP.M Changes for Mapping
5099: --IF (PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS(p_project_out.pa_project_id) = 'Y') THEN
5100: IF (PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS(l_project_id) = 'Y') THEN
5101:
5102: --maansari5/18 replaced api call CONVERT_PM_TASKREF_TO_ID to CONVERT_PM_TASKREF_TO_ID_all
5103: IF l_d_task_id IS NULL AND

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

5096: -- l_d_task_id := p_tasks_out(l_d_loop_count).pa_task_id;
5097:
5098: --Commented by rtarway FP.M Changes for Mapping
5099: --IF (PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS(p_project_out.pa_project_id) = 'Y') THEN
5100: IF (PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS(l_project_id) = 'Y') THEN
5101:
5102: --maansari5/18 replaced api call CONVERT_PM_TASKREF_TO_ID to CONVERT_PM_TASKREF_TO_ID_all
5103: IF l_d_task_id IS NULL AND
5104: l_task_in_rec.pm_task_reference IS NOT NULL AND

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

5132:
5133: l_d_task_ver_id := PA_PROJ_ELEMENTS_UTILS.GET_TASK_VERSION_ID(p_structure_version_id => l_d_structure_version_id
5134: ,p_task_id => l_d_task_id);
5135:
5136: pa_proj_task_struc_pub.parse_predecessor_import(p_string => l_task_in_rec.pred_string
5137: ,p_delimeter => l_task_in_rec.pred_delimiter
5138: ,p_task_version_Id => l_d_task_ver_id
5139: ,x_return_status => l_return_status
5140: ,x_msg_count => l_msg_count

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

6072: FETCH cur_get_str_type_from_str_id INTO l_str_type;
6073: IF cur_get_str_type_from_str_id%NOTFOUND THEN
6074: l_str_type := p_structure_type;
6075: --Foll IF condition added for Bug 3810365
6076: ELSIF 'N' = PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN( l_project_id ) THEN
6077: l_str_type := 'FINANCIAL';
6078: END IF;
6079: CLOSE cur_get_str_type_from_str_id;
6080: END IF;

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

6290: FETCH l_amg_project_csr INTO l_amg_segment1;
6291: CLOSE l_amg_project_csr;
6292:
6293: --bug 2738747 ---Add task
6294: G_Published_version_exists := PA_PROJ_TASK_STRUC_PUB.Published_version_exists( l_project_id );
6295: G_IS_WP_SEPARATE_FROM_FN := PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN( l_project_id );
6296: G_IS_WP_VERSIONING_ENABLED := PA_PROJ_TASK_STRUC_PUB.IS_WP_VERSIONING_ENABLED( l_project_id );
6297: --bug 2738747
6298: G_WP_STR_EXISTS := PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS( l_project_id );

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

6291: CLOSE l_amg_project_csr;
6292:
6293: --bug 2738747 ---Add task
6294: G_Published_version_exists := PA_PROJ_TASK_STRUC_PUB.Published_version_exists( l_project_id );
6295: G_IS_WP_SEPARATE_FROM_FN := PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN( l_project_id );
6296: G_IS_WP_VERSIONING_ENABLED := PA_PROJ_TASK_STRUC_PUB.IS_WP_VERSIONING_ENABLED( l_project_id );
6297: --bug 2738747
6298: G_WP_STR_EXISTS := PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS( l_project_id );
6299: G_OP_VALIDATE_FLAG := p_op_validate_flag; --added by rtarway for bug 4218977

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

6292:
6293: --bug 2738747 ---Add task
6294: G_Published_version_exists := PA_PROJ_TASK_STRUC_PUB.Published_version_exists( l_project_id );
6295: G_IS_WP_SEPARATE_FROM_FN := PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN( l_project_id );
6296: G_IS_WP_VERSIONING_ENABLED := PA_PROJ_TASK_STRUC_PUB.IS_WP_VERSIONING_ENABLED( l_project_id );
6297: --bug 2738747
6298: G_WP_STR_EXISTS := PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS( l_project_id );
6299: G_OP_VALIDATE_FLAG := p_op_validate_flag; --added by rtarway for bug 4218977
6300:

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

6294: G_Published_version_exists := PA_PROJ_TASK_STRUC_PUB.Published_version_exists( l_project_id );
6295: G_IS_WP_SEPARATE_FROM_FN := PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN( l_project_id );
6296: G_IS_WP_VERSIONING_ENABLED := PA_PROJ_TASK_STRUC_PUB.IS_WP_VERSIONING_ENABLED( l_project_id );
6297: --bug 2738747
6298: G_WP_STR_EXISTS := PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS( l_project_id );
6299: G_OP_VALIDATE_FLAG := p_op_validate_flag; --added by rtarway for bug 4218977
6300:
6301: --bug 2876703 --Add_task
6302: IF G_IS_WP_SEPARATE_FROM_FN = 'N' AND

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

7110: ,p_out_task_id => l_d_task_id
7111: ,p_return_status => l_return_status);
7112: */
7113:
7114: IF (PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS(p_pa_project_id) = 'Y') THEN
7115:
7116: IF l_d_task_id IS NULL AND l_task_in_rec.pm_task_reference IS NOT NULL AND
7117: l_task_in_rec.pm_task_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
7118: THEN

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

7157:
7158: l_d_task_ver_id := PA_PROJ_ELEMENTS_UTILS.GET_TASK_VERSION_ID(p_structure_version_id => l_d_struct_ver_id
7159: ,p_task_id => l_d_task_id);
7160:
7161: pa_proj_task_struc_pub.parse_predecessor_import(p_string => l_task_in_rec.pred_string
7162: ,p_delimeter => l_task_in_rec.pred_delimiter
7163: ,p_task_version_Id => l_d_task_ver_id
7164: ,x_return_status => l_return_status
7165: ,x_msg_count => l_msg_count

Line 7219: PA_PROJ_TASK_STRUC_PUB.CREATE_TASK_STRUCTURE(

7215: l_task_in_rec.scheduled_start_date := p_scheduled_start_date;
7216: l_task_in_rec.scheduled_finish_date := p_scheduled_finish_date;
7217: l_task_in_rec.PM_task_reference := p_pm_task_reference;
7218:
7219: PA_PROJ_TASK_STRUC_PUB.CREATE_TASK_STRUCTURE(
7220: p_project_id => l_project_id
7221: ,p_task_id => l_task_in_rec.pa_task_id
7222: ,p_parent_task_id => l_task_in_rec.pa_parent_task_id
7223: ,p_ref_task_id => l_ref_task_id --proj conn

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

7310: p_pa_project_id_out := l_project_rec.project_id;
7311: p_pa_project_number_out := l_project_rec.segment1; --this is the project_number field in PA_PROJECTS
7312:
7313: --Begin Add by rtarway FP.M Development
7314: G_PROJECT_SHARING_TYPE := PA_PROJ_TASK_STRUC_PUB.GET_SHARE_TYPE(l_project_id);
7315: IF (G_PROJECT_SHARING_TYPE='SPLIT_MAPPING' AND l_structure_type = 'WORKPLAN' ) THEN
7316: IF (
7317: ( 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 )
7318: OR

Line 7401: PA_PROJ_TASK_STRUC_PUB.rollup_dates(

7397:
7398: -- The rollup of dates must be completed before we do
7399: -- the task weightage calculation.
7400:
7401: PA_PROJ_TASK_STRUC_PUB.rollup_dates(
7402: p_tasks_in => l_tasks_out --null if called for one task
7403: ,p_task_version_id => l_task_version_id
7404: ,p_project_id => l_project_id
7405: ,P_structure_version_id => null

Line 7424: -- In new model PA_PROJ_TASK_STRUC_PUB.recalc_task_weightings

7420:
7421: l_task_weight_basis_code := PA_PROGRESS_UTILS.GET_TASK_WEIGHTING_BASIS(p_project_id => p_pa_project_id) ;
7422:
7423: -- PA L Changes 3010538
7424: -- In new model PA_PROJ_TASK_STRUC_PUB.recalc_task_weightings
7425: -- needs to be called only when task weight basis code is
7426: -- MANUAL.
7427: IF nvl(l_task_weight_basis_code,'-1') = 'MANUAL' THEN
7428:

Line 7429: PA_PROJ_TASK_STRUC_PUB.recalc_task_weightings(

7425: -- needs to be called only when task weight basis code is
7426: -- MANUAL.
7427: IF nvl(l_task_weight_basis_code,'-1') = 'MANUAL' THEN
7428:
7429: PA_PROJ_TASK_STRUC_PUB.recalc_task_weightings(
7430: p_tasks_in => l_tasks_out --null if called for one task
7431: ,p_task_version_id => l_task_version_id
7432: ,x_msg_count => l_msg_count
7433: ,x_msg_data => l_msg_data

Line 7473: PA_PROJ_TASK_STRUC_PUB.SET_UPDATE_WBS_FLAG

7469: THEN
7470:
7471: /* Starts added for Bug# 7264422 */
7472: IF (nvl(p_structure_updates_flag, 'Y') = 'N') THEN
7473: PA_PROJ_TASK_STRUC_PUB.SET_UPDATE_WBS_FLAG
7474: ( p_calling_context => 'AMG'
7475: ,p_project_id => l_project_id
7476: ,p_structure_version_id => l_structure_version_id
7477: ,p_update_wbs_flag => 'Y'

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

7491:
7492: IF nvl(l_update_wbs_flag,'N') = 'Y' THEN
7493: IF p_process_mode = 'ONLINE' THEN
7494:
7495: PA_PROJ_TASK_STRUC_PUB.PROCESS_WBS_UPDATES(p_calling_context => 'ONLINE_UPDATE'
7496: ,p_project_id => l_project_id -- bug 3106457 p_pa_project_id
7497: ,p_structure_version_id => l_structure_version_id -- bug 3106457 p_structure_version_id
7498: ,x_return_status => l_return_status
7499: ,x_msg_count => l_msg_count

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

7507: RAISE FND_API.G_EXC_ERROR;
7508: END IF;
7509: ELSIF p_process_mode = 'CONCURRENT' THEN
7510:
7511: PA_PROJ_TASK_STRUC_PUB. PROCESS_WBS_UPDATES_CONC_WRP(p_calling_context => 'CONC_UPDATE' -- Bug 6842218 'CON_UPDATE'
7512: ,p_project_id => l_project_id -- bug 3106457 p_pa_project_id
7513: ,p_structure_version_id => l_structure_version_id -- bug 3106457 p_structure_version_id
7514: ,x_return_status => l_return_status
7515: ,x_msg_count => l_msg_count

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

7738: --end of bug 24771668
7739:
7740: IF p_structure_type = 'WORKPLAN'
7741: THEN
7742: IF PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS( l_project_id ) = 'N' OR
7743: PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN( l_project_id ) = 'N' -- 2876703 --delete_task
7744: THEN
7745: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
7746: THEN

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

7739:
7740: IF p_structure_type = 'WORKPLAN'
7741: THEN
7742: IF PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS( l_project_id ) = 'N' OR
7743: PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN( l_project_id ) = 'N' -- 2876703 --delete_task
7744: THEN
7745: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
7746: THEN
7747: pa_interface_utils_pub.map_new_amg_msg

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

7799: -- switch flow to WORKPLAN
7800: -- i) Workplan is enabled;
7801: -- ii) Structure is SHARED;
7802: -- iii) Published version exists;
7803: G_Published_version_exists := PA_PROJ_TASK_STRUC_PUB.Published_version_exists( l_project_id );
7804: G_IS_WP_SEPARATE_FROM_FN := PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN( l_project_id );
7805: G_IS_WP_VERSIONING_ENABLED := PA_PROJ_TASK_STRUC_PUB.IS_WP_VERSIONING_ENABLED( l_project_id );
7806:
7807: IF PA_PROJECT_PUB.G_Published_version_exists = 'Y'

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

7800: -- i) Workplan is enabled;
7801: -- ii) Structure is SHARED;
7802: -- iii) Published version exists;
7803: G_Published_version_exists := PA_PROJ_TASK_STRUC_PUB.Published_version_exists( l_project_id );
7804: G_IS_WP_SEPARATE_FROM_FN := PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN( l_project_id );
7805: G_IS_WP_VERSIONING_ENABLED := PA_PROJ_TASK_STRUC_PUB.IS_WP_VERSIONING_ENABLED( l_project_id );
7806:
7807: IF PA_PROJECT_PUB.G_Published_version_exists = 'Y'
7808: AND PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN = 'N'

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

7801: -- ii) Structure is SHARED;
7802: -- iii) Published version exists;
7803: G_Published_version_exists := PA_PROJ_TASK_STRUC_PUB.Published_version_exists( l_project_id );
7804: G_IS_WP_SEPARATE_FROM_FN := PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN( l_project_id );
7805: G_IS_WP_VERSIONING_ENABLED := PA_PROJ_TASK_STRUC_PUB.IS_WP_VERSIONING_ENABLED( l_project_id );
7806:
7807: IF PA_PROJECT_PUB.G_Published_version_exists = 'Y'
7808: AND PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN = 'N'
7809: AND PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'Y'

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

7938:
7939: IF nvl(l_update_wbs_flag,'N') = 'Y' THEN
7940: IF p_process_mode = 'ONLINE' THEN
7941:
7942: PA_PROJ_TASK_STRUC_PUB.PROCESS_WBS_UPDATES(p_calling_context => 'ONLINE_UPDATE'
7943: ,p_project_id => l_project_id --Bug 3106457 p_pa_project_id
7944: ,p_structure_version_id => l_structure_version_id
7945: ,x_return_status => p_return_status
7946: ,x_msg_count => p_msg_count

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

7954: RAISE FND_API.G_EXC_ERROR;
7955: END IF;
7956: ELSIF p_process_mode = 'CONCURRENT' THEN
7957:
7958: PA_PROJ_TASK_STRUC_PUB. PROCESS_WBS_UPDATES_CONC_WRP(p_calling_context => 'CONC_UPDATE'
7959: ,p_project_id => l_project_id -- Bug 3106457 p_pa_project_id
7960: ,p_structure_version_id => l_structure_version_id
7961: ,x_return_status => p_return_status
7962: ,x_msg_count => p_msg_count

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

11384: l_ctx_update_flag := 'N';
11385: -- End of changes
11386:
11387: --bug 2738747 --update project
11388: G_Published_version_exists := PA_PROJ_TASK_STRUC_PUB.Published_version_exists( l_project_id );
11389: G_IS_WP_SEPARATE_FROM_FN := PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN( l_project_id );
11390: G_IS_WP_VERSIONING_ENABLED := PA_PROJ_TASK_STRUC_PUB.IS_WP_VERSIONING_ENABLED( l_project_id );
11391: --bug 2738747
11392: G_WP_STR_EXISTS := PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS( l_project_id );

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

11385: -- End of changes
11386:
11387: --bug 2738747 --update project
11388: G_Published_version_exists := PA_PROJ_TASK_STRUC_PUB.Published_version_exists( l_project_id );
11389: G_IS_WP_SEPARATE_FROM_FN := PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN( l_project_id );
11390: G_IS_WP_VERSIONING_ENABLED := PA_PROJ_TASK_STRUC_PUB.IS_WP_VERSIONING_ENABLED( l_project_id );
11391: --bug 2738747
11392: G_WP_STR_EXISTS := PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS( l_project_id );
11393:

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

11386:
11387: --bug 2738747 --update project
11388: G_Published_version_exists := PA_PROJ_TASK_STRUC_PUB.Published_version_exists( l_project_id );
11389: G_IS_WP_SEPARATE_FROM_FN := PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN( l_project_id );
11390: G_IS_WP_VERSIONING_ENABLED := PA_PROJ_TASK_STRUC_PUB.IS_WP_VERSIONING_ENABLED( l_project_id );
11391: --bug 2738747
11392: G_WP_STR_EXISTS := PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS( l_project_id );
11393:
11394: IF l_debug_mode = 'Y' THEN

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

11388: G_Published_version_exists := PA_PROJ_TASK_STRUC_PUB.Published_version_exists( l_project_id );
11389: G_IS_WP_SEPARATE_FROM_FN := PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN( l_project_id );
11390: G_IS_WP_VERSIONING_ENABLED := PA_PROJ_TASK_STRUC_PUB.IS_WP_VERSIONING_ENABLED( l_project_id );
11391: --bug 2738747
11392: G_WP_STR_EXISTS := PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS( l_project_id );
11393:
11394: IF l_debug_mode = 'Y' THEN
11395: pa_debug.g_err_stage := 'G_Published_version_exists='||G_Published_version_exists;
11396: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);

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

16693: l_update_task_structure := 'N';
16694: END IF; -- bug 3548473 : 3627124
16695:
16696: --dbms_output.put_line ('l_update_task_structure : ' || l_update_task_structure);
16697: --dbms_output.put_line ('before calling PA_PROJ_TASK_STRUC_PUB.create_structure ');
16698: --Creating a WORKPLAN structure
16699: IF p_structure_in.structure_type = 'WORKPLAN' --This should only be done for a WORKPLAN structure
16700: THEN
16701: PA_PROJ_TASK_STRUC_PUB.create_structure(

Line 16701: PA_PROJ_TASK_STRUC_PUB.create_structure(

16697: --dbms_output.put_line ('before calling PA_PROJ_TASK_STRUC_PUB.create_structure ');
16698: --Creating a WORKPLAN structure
16699: IF p_structure_in.structure_type = 'WORKPLAN' --This should only be done for a WORKPLAN structure
16700: THEN
16701: PA_PROJ_TASK_STRUC_PUB.create_structure(
16702: p_project_id => l_project_id
16703: ,p_structure_type =>l_structure_type --BUg 3548473 3627124 aditi
16704: ,p_structure_version_name => p_structure_in.structure_version_name
16705: ,p_description => p_structure_in.description

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

16710: ,x_return_status => l_return_status
16711: );
16712:
16713: IF l_debug_mode = 'Y' THEN
16714: pa_debug.g_err_stage := 'After calling PA_PROJ_TASK_STRUC_PUB.create_structure l_return_status='||l_return_status;
16715: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
16716: END IF;
16717:
16718:

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

16741: --creating structure version
16742: THEN
16743: IF l_structure_version_id IS NULL
16744: AND NVL( l_project_rec.template_flag,'N') = 'N'
16745: AND NVL( PA_PROJ_TASK_STRUC_PUB.IS_WP_VERSIONING_ENABLED(l_project_id), 'N' ) = 'Y'
16746: AND p_pm_product_code <> 'WORKPLAN' -- Bug 2871353
16747: THEN
16748: PA_PROJ_TASK_STRUC_PUB.create_update_struct_ver(
16749: p_project_id => l_project_id

Line 16748: PA_PROJ_TASK_STRUC_PUB.create_update_struct_ver(

16744: AND NVL( l_project_rec.template_flag,'N') = 'N'
16745: AND NVL( PA_PROJ_TASK_STRUC_PUB.IS_WP_VERSIONING_ENABLED(l_project_id), 'N' ) = 'Y'
16746: AND p_pm_product_code <> 'WORKPLAN' -- Bug 2871353
16747: THEN
16748: PA_PROJ_TASK_STRUC_PUB.create_update_struct_ver(
16749: p_project_id => l_project_id
16750: ,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.
16751: ,p_structure_version_name => p_structure_in.structure_version_name
16752: ,p_structure_version_id => p_structure_in.structure_version_id

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

16757: ,x_return_status => l_return_status
16758: );
16759:
16760: IF l_debug_mode = 'Y' THEN
16761: pa_debug.g_err_stage := 'After calling PA_PROJ_TASK_STRUC_PUB.create_update_struct_ver l_return_status='||l_return_status;
16762: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
16763: END IF;
16764:
16765:

Line 16790: PA_PROJ_TASK_STRUC_PUB.create_tasks_versions_only(

16786: l_create_task_versions_only := 'Y';
16787:
16788: --Call create_tasks_versions_only api to create new task versions for the
16789: --existing tasks and add them to the new structure version.
16790: PA_PROJ_TASK_STRUC_PUB.create_tasks_versions_only(
16791: p_calling_module => 'AMG'
16792: --,p_structure_type => p_structure_in.structure_type --bug 2738747
16793: ,p_structure_type => l_structure_type --bug 2738747
16794: ,p_project_id => l_project_id

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

16799: ,x_msg_data => l_msg_data
16800: ,x_return_status => l_return_status );
16801:
16802: IF l_debug_mode = 'Y' THEN
16803: pa_debug.g_err_stage := 'After calling PA_PROJ_TASK_STRUC_PUB.create_tasks_versions_only l_return_status='||l_return_status;
16804: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
16805: END IF;
16806:
16807:

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

16884: -- G_ParChildTsk_chks_deferred := 'Y'; -- Bug 10127973
16885: -- initialize the special global tables and counter set up
16886: -- to handle task number changes
16887:
16888: l_is_wp_seperate_from_fn := PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN( l_project_id ); -- Added for Bug#3451073
16889: WHILE i IS NOT NULL LOOP
16890:
16891: l_task_id := NULL;
16892:

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

17989:
17990: -- Changes start for Bug# 3931805
17991: IF NVL( p_pm_product_code, 'WORKPLAN' ) <> 'WORKPLAN' -- We should not be calling the task weightage apis when it is the
17992: THEN -- publishing flow.
17993: PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED := PA_PROJ_TASK_STRUC_PUB.IS_WP_VERSIONING_ENABLED( l_project_id );
17994: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN := PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN( l_project_id );
17995: PA_PROJECT_PUB.G_Published_version_exists := PA_PROJ_TASK_STRUC_PUB.Published_version_exists( l_project_id );
17996:
17997: IF ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'N' ) OR

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

17990: -- Changes start for Bug# 3931805
17991: IF NVL( p_pm_product_code, 'WORKPLAN' ) <> 'WORKPLAN' -- We should not be calling the task weightage apis when it is the
17992: THEN -- publishing flow.
17993: PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED := PA_PROJ_TASK_STRUC_PUB.IS_WP_VERSIONING_ENABLED( l_project_id );
17994: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN := PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN( l_project_id );
17995: PA_PROJECT_PUB.G_Published_version_exists := PA_PROJ_TASK_STRUC_PUB.Published_version_exists( l_project_id );
17996:
17997: IF ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'N' ) OR
17998: ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'Y' AND

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

17991: IF NVL( p_pm_product_code, 'WORKPLAN' ) <> 'WORKPLAN' -- We should not be calling the task weightage apis when it is the
17992: THEN -- publishing flow.
17993: PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED := PA_PROJ_TASK_STRUC_PUB.IS_WP_VERSIONING_ENABLED( l_project_id );
17994: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN := PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN( l_project_id );
17995: PA_PROJECT_PUB.G_Published_version_exists := PA_PROJ_TASK_STRUC_PUB.Published_version_exists( l_project_id );
17996:
17997: IF ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'N' ) OR
17998: ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'Y' AND
17999: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN = 'N' AND

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

18003: l_update_wbs_flag := PA_PROJECT_STRUCTURE_UTILS.GET_UPDATE_WBS_FLAG(p_project_id => l_project_id
18004: ,p_structure_version_id => l_structure_version_id ) ;
18005: IF nvl(l_update_wbs_flag,'N') = 'Y' THEN
18006: IF p_project_in.process_mode = 'ONLINE' THEN
18007: PA_PROJ_TASK_STRUC_PUB.PROCESS_WBS_UPDATES(p_calling_context => 'ONLINE_UPDATE'
18008: ,p_project_id => l_project_id
18009: ,p_structure_version_id => l_structure_version_id
18010: ,x_return_status => l_return_status
18011: ,x_msg_count => l_msg_count

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

18018: RAISE FND_API.G_EXC_ERROR;
18019: END IF;
18020: ELSIF p_project_in.process_mode = 'CONCURRENT' THEN
18021:
18022: PA_PROJ_TASK_STRUC_PUB. PROCESS_WBS_UPDATES_CONC_WRP(p_calling_context => 'CONC_UPDATE'
18023: ,p_project_id => l_project_id
18024: ,p_structure_version_id => l_structure_version_id
18025: ,x_return_status => l_return_status
18026: ,x_msg_count => l_msg_count

Line 18232: PA_PROJ_TASK_STRUC_PUB.convert_pm_parent_task_ref(

18228: AND p_tasks_in(i).pm_parent_task_reference IS NOT NULL)
18229: THEN
18230: --convert pm_parent_task_reference to parent_task_id.
18231: --All the parent tasks are created first then child tasks are created. See TRM for AMG load_task api.
18232: PA_PROJ_TASK_STRUC_PUB.convert_pm_parent_task_ref(
18233: p_pm_parent_task_reference => p_tasks_in(i).pm_parent_task_reference
18234: ,p_project_id => l_project_id
18235: ,x_parent_task_id => v_parent_task_id
18236: ,x_return_status => l_return_status

Line 18261: PA_PROJ_TASK_STRUC_PUB.CREATE_TASK_STRUCTURE(

18257: ELSE
18258: v_parent_task_id := null;
18259: END IF;
18260:
18261: PA_PROJ_TASK_STRUC_PUB.CREATE_TASK_STRUCTURE(
18262: p_project_id => l_project_id
18263: ,p_task_id => p_tasks_in(i).pa_task_id
18264: ,p_parent_task_id => v_parent_task_id
18265: ,p_ref_task_id => v_ref_task_id

Line 18375: PA_PROJ_TASK_STRUC_PUB.UPDATE_TASK_STRUCTURE(

18371: p_return_status := FND_API.G_RET_STS_ERROR;
18372: RAISE FND_API.G_EXC_ERROR;
18373: END IF;
18374:
18375: PA_PROJ_TASK_STRUC_PUB.UPDATE_TASK_STRUCTURE(
18376: p_project_id => l_project_id
18377: ,p_task_id => p_tasks_in(i).pa_task_id
18378: ,p_ref_task_id => v_ref_task_id
18379: ,p_task_number => p_tasks_in(i).pa_task_number

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

18456: --Added for bug 2931183
18457: IF nvl(p_pm_product_code,'WORKPLAN') <> 'WORKPLAN' AND p_pass_entire_structure = 'Y' -- bug 3548473 : 3627124
18458: THEN
18459: IF l_debug_mode = 'Y' THEN
18460: pa_debug.g_err_stage := 'Calling PA_PROJ_TASK_STRUC_PUB.PROCESS_TASK_STRUCTURE_BULK ' ;
18461: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
18462: END IF;
18463:
18464: PA_PROJ_TASK_STRUC_PUB.PROCESS_TASK_STRUCTURE_BULK(

Line 18464: PA_PROJ_TASK_STRUC_PUB.PROCESS_TASK_STRUCTURE_BULK(

18460: pa_debug.g_err_stage := 'Calling PA_PROJ_TASK_STRUC_PUB.PROCESS_TASK_STRUCTURE_BULK ' ;
18461: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
18462: END IF;
18463:
18464: PA_PROJ_TASK_STRUC_PUB.PROCESS_TASK_STRUCTURE_BULK(
18465: p_api_version_number => p_api_version_number
18466: ,p_commit => FND_API.G_FALSE--bug 3766967
18467: ,p_project_id => l_project_id
18468: ,p_source_project_id => l_project_in_rec.created_from_project_id --ADUT. Included this new param.

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

18481: ,x_msg_data => p_msg_data
18482: );
18483:
18484: IF l_debug_mode = 'Y' THEN
18485: pa_debug.g_err_stage := 'After PA_PROJ_TASK_STRUC_PUB.PROCESS_TASK_STRUCTURE_BULK...p_return_status=||p_return_status';
18486: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
18487: END IF;
18488:
18489:

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

18496: RAISE FND_API.G_EXC_ERROR;
18497: END IF;
18498:
18499: IF l_debug_mode = 'Y' THEN
18500: pa_debug.g_err_stage := 'Returned from PA_PROJ_TASK_STRUC_PUB.PROCESS_TASK_STRUCTURE_BULK ' ;
18501: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
18502: END IF;
18503: END IF; --for p_pm_product_code is not workplan
18504:

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

18506: IF l_structure_type = 'FINANCIAL'
18507: THEN
18508: IF NVL( p_pm_product_code, 'WORKPLAN' ) <> 'WORKPLAN' -- We should not be calling the task weightage apis when it is the
18509: THEN -- publishing flow.
18510: PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED := PA_PROJ_TASK_STRUC_PUB.IS_WP_VERSIONING_ENABLED( l_project_id );
18511: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN := PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN( l_project_id );
18512: PA_PROJECT_PUB.G_Published_version_exists := PA_PROJ_TASK_STRUC_PUB.Published_version_exists( l_project_id );
18513: IF NVL(PA_PROJECT_PUB.G_ROLLUP_DEFER, 'N') = 'N' /*added IF condition for bug#13923366*/
18514: THEN

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

18507: THEN
18508: IF NVL( p_pm_product_code, 'WORKPLAN' ) <> 'WORKPLAN' -- We should not be calling the task weightage apis when it is the
18509: THEN -- publishing flow.
18510: PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED := PA_PROJ_TASK_STRUC_PUB.IS_WP_VERSIONING_ENABLED( l_project_id );
18511: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN := PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN( l_project_id );
18512: PA_PROJECT_PUB.G_Published_version_exists := PA_PROJ_TASK_STRUC_PUB.Published_version_exists( l_project_id );
18513: IF NVL(PA_PROJECT_PUB.G_ROLLUP_DEFER, 'N') = 'N' /*added IF condition for bug#13923366*/
18514: THEN
18515: IF ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'N' ) OR

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

18508: IF NVL( p_pm_product_code, 'WORKPLAN' ) <> 'WORKPLAN' -- We should not be calling the task weightage apis when it is the
18509: THEN -- publishing flow.
18510: PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED := PA_PROJ_TASK_STRUC_PUB.IS_WP_VERSIONING_ENABLED( l_project_id );
18511: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN := PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN( l_project_id );
18512: PA_PROJECT_PUB.G_Published_version_exists := PA_PROJ_TASK_STRUC_PUB.Published_version_exists( l_project_id );
18513: IF NVL(PA_PROJECT_PUB.G_ROLLUP_DEFER, 'N') = 'N' /*added IF condition for bug#13923366*/
18514: THEN
18515: IF ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'N' ) OR
18516: ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'Y' AND

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

18521: l_update_wbs_flag := PA_PROJECT_STRUCTURE_UTILS.GET_UPDATE_WBS_FLAG(p_project_id => l_project_id
18522: ,p_structure_version_id => l_structure_version_id ) ;
18523: IF nvl(l_update_wbs_flag,'N') = 'Y' THEN
18524: IF p_project_in.process_mode = 'ONLINE' THEN
18525: PA_PROJ_TASK_STRUC_PUB.PROCESS_WBS_UPDATES(p_calling_context => 'ONLINE_UPDATE'
18526: ,p_project_id => l_project_id
18527: ,p_structure_version_id => l_structure_version_id
18528: ,x_return_status => l_return_status
18529: ,x_msg_count => l_msg_count

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

18536: RAISE FND_API.G_EXC_ERROR;
18537: END IF;
18538: ELSIF p_project_in.process_mode = 'CONCURRENT' THEN
18539:
18540: PA_PROJ_TASK_STRUC_PUB.PROCESS_WBS_UPDATES_CONC_WRP(p_calling_context => 'CONC_UPDATE'
18541: ,p_project_id => l_project_id
18542: ,p_structure_version_id => l_structure_version_id
18543: ,x_return_status => l_return_status
18544: ,x_msg_count => l_msg_count

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

18559: --Bug 6163090
18560:
18561:
18562:
18563: ----Commented The below code for bug 2931183 as the processing will be done in PA_PROJ_TASK_STRUC_PUB.PROCESS_TASK_STRUCTURE_BULK
18564:
18565: -- Bug # 5077599.
18566:
18567: -- Uncommented the code below.

Line 18580: PA_PROJ_TASK_STRUC_PUB.recalc_task_weightings(

18576: THEN
18577: -- 14556729:Huawei Code change to defer the roll up API when G_ROLLUP_DEFER is set to Y , so that all the roll up is processed once at the end .
18578: IF NVL(PA_PROJECT_PUB.G_ROLLUP_DEFER, 'N') = 'N'
18579: then
18580: PA_PROJ_TASK_STRUC_PUB.recalc_task_weightings(
18581: p_tasks_in => l_tasks_out
18582: ,p_task_version_id => null
18583: ,x_msg_count => l_msg_count
18584: ,x_msg_data => l_msg_data

Line 18622: PA_PROJ_TASK_STRUC_PUB.rollup_dates(

18618: -- 14556729:Huawei Code change to defer the roll up API when G_ROLLUP_DEFER is set to Y , so that all the roll up is processed once at the end .
18619: IF NVL(PA_PROJECT_PUB.G_ROLLUP_DEFER, 'N') = 'N' THEN
18620: IF NVL(PA_PROJECT_PUB.G_BULK_UPDATE_MODE,' ') <> 'NO_DATES' THEN
18621:
18622: PA_PROJ_TASK_STRUC_PUB.rollup_dates(
18623: p_tasks_in => l_tasks_out --null if called for one task
18624: ,p_task_version_id => null
18625: ,p_project_id => l_project_id
18626: ,P_structure_version_id => l_structure_version_id

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

21778: --This has been discussed today may 18 with Sakthi and Hubert. The reason is performance.
21779: IF nvl(p_pm_product_code,'WORKPLAN') <> 'WORKPLAN' --Should not run in publishing flow.
21780: THEN
21781: --bug 3845240: use l_project_id instead of p_project_out.pa_project_id
21782: IF (PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS(l_project_id) = 'Y') AND
21783: l_update_structure_version_id IS NOT NULL AND
21784: l_update_structure_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
21785: AND NVL(PA_PROJECT_PUB.G_MASS_UPDATE_TASKS,'N') = 'N' -- For performance improvement 14556729
21786: THEN

Line 21787: pa_proj_task_struc_pub.delete_intra_dependency(

21783: l_update_structure_version_id IS NOT NULL AND
21784: l_update_structure_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
21785: AND NVL(PA_PROJECT_PUB.G_MASS_UPDATE_TASKS,'N') = 'N' -- For performance improvement 14556729
21786: THEN
21787: pa_proj_task_struc_pub.delete_intra_dependency(
21788: p_element_version_id => l_update_structure_version_id
21789: ,x_return_status => l_return_status );
21790:
21791: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR

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

21806: --Added by rtarway during FP.M Developement Mapping and Set Financial Changes.
21807: l_d_task_id := p_tasks_out(l_d_loop_count).pa_task_id;
21808:
21809: --bug 3845240: use l_project_id instead of p_project_out.pa_project_id
21810: IF (PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS(l_project_id) = 'Y') THEN
21811:
21812: --maansari5/18 replaced api call CONVERT_PM_TASKREF_TO_ID to CONVERT_PM_TASKREF_TO_ID_all
21813: IF l_d_task_id IS NULL AND l_task_in_rec.pm_task_reference IS NOT NULL AND
21814: l_task_in_rec.pm_task_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

21831:
21832: l_d_task_ver_id := PA_PROJ_ELEMENTS_UTILS.GET_TASK_VERSION_ID(p_structure_version_id => l_update_structure_version_id
21833: ,p_task_id => l_d_task_id);
21834:
21835: pa_proj_task_struc_pub.parse_predecessor_import(p_string => l_task_in_rec.pred_string
21836: ,p_delimeter => l_task_in_rec.pred_delimiter
21837: ,p_task_version_Id => l_d_task_ver_id
21838: ,x_return_status => l_return_status
21839: ,x_msg_count => l_msg_count

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

21898: END IF;
21899: --
21900:
21901: --Begin Add by rtarway FP.M changes for Mapping
21902: G_PROJECT_SHARING_TYPE := PA_PROJ_TASK_STRUC_PUB.GET_SHARE_TYPE(l_project_id);
21903: IF (G_PROJECT_SHARING_TYPE = 'SPLIT_MAPPING' AND p_structure_in.structure_type = 'WORKPLAN')
21904: THEN
21905: l_d_loop_count := p_tasks_in.first;
21906: WHILE l_d_loop_count IS NOT NULL LOOP

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

23122: --only in public APIs.
23123:
23124: -- Initialize local variables
23125: -- Bug#3747312
23126: l_published_version_exists := PA_PROJ_TASK_STRUC_PUB.Published_version_exists( l_project_id );
23127: l_is_wp_separate_from_fn := PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN( l_project_id );
23128: l_is_wp_versioning_enabled := PA_PROJ_TASK_STRUC_PUB.IS_WP_VERSIONING_ENABLED( l_project_id );
23129:
23130: -- In case of shared structure p_structure_type should be passed as

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

23123:
23124: -- Initialize local variables
23125: -- Bug#3747312
23126: l_published_version_exists := PA_PROJ_TASK_STRUC_PUB.Published_version_exists( l_project_id );
23127: l_is_wp_separate_from_fn := PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN( l_project_id );
23128: l_is_wp_versioning_enabled := PA_PROJ_TASK_STRUC_PUB.IS_WP_VERSIONING_ENABLED( l_project_id );
23129:
23130: -- In case of shared structure p_structure_type should be passed as
23131: -- FINANCIAL and this should be the first validation.

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

23124: -- Initialize local variables
23125: -- Bug#3747312
23126: l_published_version_exists := PA_PROJ_TASK_STRUC_PUB.Published_version_exists( l_project_id );
23127: l_is_wp_separate_from_fn := PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN( l_project_id );
23128: l_is_wp_versioning_enabled := PA_PROJ_TASK_STRUC_PUB.IS_WP_VERSIONING_ENABLED( l_project_id );
23129:
23130: -- In case of shared structure p_structure_type should be passed as
23131: -- FINANCIAL and this should be the first validation.
23132: IF (p_structure_type is null OR p_structure_type = 'WORKPLAN') THEN

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

23129:
23130: -- In case of shared structure p_structure_type should be passed as
23131: -- FINANCIAL and this should be the first validation.
23132: IF (p_structure_type is null OR p_structure_type = 'WORKPLAN') THEN
23133: IF PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS( l_project_id ) = 'N' OR
23134: NVL( l_is_wp_separate_from_fn,'N') = 'N' --bug 2876703 update_task
23135: THEN
23136: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
23137: THEN

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

23191:
23192: --Added by rtarway for BUG 3919800
23193: --Validate for task and change the structure type, if structure type is shared partial and workplan task is being updated.
23194: --1. get the structure sharing code
23195: l_project_sharing_type := PA_PROJ_TASK_STRUC_PUB.GET_SHARE_TYPE(l_project_id);
23196: IF (l_project_sharing_type='SHARE_PARTIAL' )
23197: THEN
23198: --3. get the structure version id
23199: IF (l_structure_version_id is null or l_structure_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)

Line 23952: PA_PROJ_TASK_STRUC_PUB.update_task_structure

23948:
23949:
23950: ----dbms_output.put_line('Value of p_task_number passed to update_task_structure'||p_task_number);
23951:
23952: PA_PROJ_TASK_STRUC_PUB.update_task_structure
23953: (
23954: p_calling_module => 'AMG'
23955: ,p_task_id => l_pa_task_id --BUG 3919800, rtarway
23956: ,p_ref_task_id => l_ref_task_id --Bug 3705333 changed from p_ref_task_id to l_ref_task_id

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

24068:
24069: ELSIF l_structure_type = 'WORKPLAN' --p_structure_type
24070: THEN
24071: -- Moved this code up. As this should be the first validation the should be performed
24072: -- IF PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS( l_project_id ) = 'N' OR
24073: --If update task is called from update_project api then PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN wont be called
24074: --bcoz G_IS_WP_SEPARATE_FROM_FN will already be set by upate_project.
24075: -- 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
24076: --THEN

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

24069: ELSIF l_structure_type = 'WORKPLAN' --p_structure_type
24070: THEN
24071: -- Moved this code up. As this should be the first validation the should be performed
24072: -- IF PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS( l_project_id ) = 'N' OR
24073: --If update task is called from update_project api then PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN wont be called
24074: --bcoz G_IS_WP_SEPARATE_FROM_FN will already be set by upate_project.
24075: -- 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
24076: --THEN
24077: -- IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

Line 24075: -- 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

24071: -- Moved this code up. As this should be the first validation the should be performed
24072: -- IF PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS( l_project_id ) = 'N' OR
24073: --If update task is called from update_project api then PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN wont be called
24074: --bcoz G_IS_WP_SEPARATE_FROM_FN will already be set by upate_project.
24075: -- 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
24076: --THEN
24077: -- IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
24078: -- THEN
24079: -- pa_interface_utils_pub.map_new_amg_msg

Line 24271: PA_PROJ_TASK_STRUC_PUB.update_task_structure

24267: --bug 2665656
24268: IF NVL( p_pm_product_code, 'WORKPLAN' ) <> 'WORKPLAN'
24269: THEN
24270: --bug 2665656
24271: PA_PROJ_TASK_STRUC_PUB.update_task_structure
24272: (
24273: p_calling_module => 'AMG'
24274: ,p_task_id => l_pa_task_id --BUG 3919800, rtarway
24275: ,p_ref_task_id => l_ref_task_id --Bug 3705333 changed from p_ref_task_id to l_ref_task_id

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

24393: END IF; --<>
24394: --Begin Add by rtarway FP.M changes for Mapping
24395: --No Function Security Check required
24396: --Call the update_mapping only if p_mapped_task_reference or p_mapped_task_id is passed
24397: G_PROJECT_SHARING_TYPE := PA_PROJ_TASK_STRUC_PUB.GET_SHARE_TYPE(l_project_id);
24398: IF (G_PROJECT_SHARING_TYPE = 'SPLIT_MAPPING' and nvl(l_is_wp_separate_from_fn,'N') = 'Y')
24399: THEN
24400: IF (
24401: ( p_mapped_task_reference IS NULL OR p_mapped_task_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR )

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

24475: 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.
24476: THEN
24477: ---bug 4199694
24478: --call directly the PA_STRUCT_TASK_ROLLUP_PUB.Tasks_Rollup api. No need to call the rollup_dates here as its called per task.
24479: IF PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS( l_project_id ) = 'Y'
24480: THEN
24481: IF l_task_version_id IS NULL
24482: THEN
24483: l_task_version_id := PA_PROJ_ELEMENTS_UTILS.GET_TASK_VERSION_ID(l_structure_version_id, l_pa_task_id);

Line 24485: PA_PROJ_TASK_STRUC_PUB.rollup_dates(

24481: IF l_task_version_id IS NULL
24482: THEN
24483: l_task_version_id := PA_PROJ_ELEMENTS_UTILS.GET_TASK_VERSION_ID(l_structure_version_id, l_pa_task_id);
24484: END IF;
24485: PA_PROJ_TASK_STRUC_PUB.rollup_dates(
24486: p_tasks_in => l_tasks_out
24487: ,p_task_version_id => l_task_version_id
24488: ,p_project_id => l_project_id
24489: ,P_structure_version_id => l_structure_version_id

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

24503: END IF;
24504: ---bug 4199694
24505:
24506: -- These globals have been intialized before they are used!
24507: PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED := PA_PROJ_TASK_STRUC_PUB.IS_WP_VERSIONING_ENABLED( l_project_id ); -- Bug 3106457
24508: /* Commented the code below for bug#3451073
24509: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN := PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN( l_project_id ); -- Bug 3106457 */
24510: /* Added the If condition Bug#3451073 */
24511: IF p_is_wp_seperate_from_fn = 'X'

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

24505:
24506: -- These globals have been intialized before they are used!
24507: PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED := PA_PROJ_TASK_STRUC_PUB.IS_WP_VERSIONING_ENABLED( l_project_id ); -- Bug 3106457
24508: /* Commented the code below for bug#3451073
24509: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN := PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN( l_project_id ); -- Bug 3106457 */
24510: /* Added the If condition Bug#3451073 */
24511: IF p_is_wp_seperate_from_fn = 'X'
24512: THEN
24513: 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 24513: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN := PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN( l_project_id ); -- Bug 3106457

24509: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN := PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN( l_project_id ); -- Bug 3106457 */
24510: /* Added the If condition Bug#3451073 */
24511: IF p_is_wp_seperate_from_fn = 'X'
24512: THEN
24513: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN := PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN( l_project_id ); -- Bug 3106457
24514: ELSE
24515: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN := p_is_wp_seperate_from_fn; -- Addded for bug#3451073
24516: END IF;
24517:

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

24514: ELSE
24515: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN := p_is_wp_seperate_from_fn; -- Addded for bug#3451073
24516: END IF;
24517:
24518: PA_PROJECT_PUB.G_Published_version_exists := PA_PROJ_TASK_STRUC_PUB.Published_version_exists( l_project_id ); -- Bug 3106457
24519:
24520: IF ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'N' ) OR
24521: ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'Y' AND
24522: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN = 'N' AND

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

24527: ,p_structure_version_id => l_structure_version_id ) ; -- Bug 3106457
24528: IF nvl(l_update_wbs_flag,'N') = 'Y' THEN
24529: IF p_process_mode = 'ONLINE' THEN
24530:
24531: PA_PROJ_TASK_STRUC_PUB.PROCESS_WBS_UPDATES(p_calling_context => 'ONLINE_UPDATE'
24532: ,p_project_id => l_project_id -- Bug 3106457 p_pa_project_id
24533: ,p_structure_version_id => l_structure_version_id -- Bug 3106457 p_structure_version_id
24534: ,x_return_status => l_return_status
24535: ,x_msg_count => l_msg_count

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

24543: RAISE FND_API.G_EXC_ERROR;
24544: END IF;
24545: ELSIF p_process_mode = 'CONCURRENT' THEN
24546:
24547: PA_PROJ_TASK_STRUC_PUB. PROCESS_WBS_UPDATES_CONC_WRP(p_calling_context => 'CONC_UPDATE'
24548: ,p_project_id => l_project_id --Bug 3106457 p_pa_project_id
24549: ,p_structure_version_id => l_structure_version_id -- Bug 3106457 p_structure_version_id
24550: ,x_return_status => l_return_status
24551: ,x_msg_count => l_msg_count

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

24571: ,p_out_task_id => l_d_task_id
24572: ,p_return_status => l_return_status);
24573: */
24574:
24575: IF (PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS(l_project_id) = 'Y') THEN --Bug#3747312
24576:
24577: 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
24578: THEN
24579: PA_PROJECT_PVT.CONVERT_PM_TASKREF_TO_ID_all(p_pa_project_id => l_project_id --Bug#3747312 p_pa_project_id

Line 24604: pa_proj_task_struc_pub.parse_predecessor_import(p_string => p_pred_string

24600:
24601: l_d_task_ver_id := PA_PROJ_ELEMENTS_UTILS.GET_TASK_VERSION_ID(p_structure_version_id => l_structure_version_id
24602: ,p_task_id => l_d_task_id);
24603:
24604: pa_proj_task_struc_pub.parse_predecessor_import(p_string => p_pred_string
24605: ,p_delimeter => p_pred_delimiter
24606: ,p_task_version_Id => l_d_task_ver_id
24607: ,x_return_status => l_return_status
24608: ,x_msg_count => l_msg_count

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

24995:
24996: --bug 2876703 --check_delete_task_ok
24997: IF p_structure_type = 'WORKPLAN' AND p_project_id IS NOT NULL AND p_project_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
24998: THEN
24999: IF PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS( p_project_id ) = 'N' OR
25000: PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN( p_project_id ) = 'N'
25001: THEN
25002: l_retrieve := 'Y' ;
25003: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

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

24996: --bug 2876703 --check_delete_task_ok
24997: IF p_structure_type = 'WORKPLAN' AND p_project_id IS NOT NULL AND p_project_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
24998: THEN
24999: IF PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS( p_project_id ) = 'N' OR
25000: PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN( p_project_id ) = 'N'
25001: THEN
25002: l_retrieve := 'Y' ;
25003: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
25004: THEN

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

28215: IF p_process_mode = 'ONLINE' THEN
28216:
28217: --Added by rtarway for BUG 4032291
28218: if p_status_code = 'STRUCTURE_PUBLISHED' then
28219: PA_PROJ_TASK_STRUC_PUB.PROCESS_WBS_UPDATES(p_calling_context => 'ONLINE_PUBLISH'
28220: ,p_project_id => p_pa_project_id
28221: ,p_commit => p_commit
28222: -- Fix for Bug # 4314797.
28223: ,p_structure_version_id => p_structure_version_id

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

28226: ,x_msg_count => l_msg_count
28227: ,x_msg_data => l_msg_data ) ;
28228: --Added by rtarway for BUG 4032291
28229: else
28230: PA_PROJ_TASK_STRUC_PUB.PROCESS_WBS_UPDATES(p_calling_context => 'ONLINE_UPDATE'
28231: ,p_project_id => p_pa_project_id
28232: ,p_structure_version_id => p_published_struct_ver_id
28233: ,x_return_status => l_return_status
28234: ,x_msg_count => l_msg_count

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

28247: ELSIF p_process_mode = 'CONCURRENT' THEN
28248: /* Added if block for bug 5390015 */
28249: IF p_status_code = 'STRUCTURE_PUBLISHED' THEN
28250:
28251: PA_PROJ_TASK_STRUC_PUB.PROCESS_WBS_UPDATES_CONC_WRP(p_calling_context => 'CONC_PUBLISH'
28252: ,p_project_id => p_pa_project_id
28253: ,p_commit => p_commit
28254: ,p_structure_version_id => p_structure_version_id
28255: ,p_pub_struc_ver_id => p_published_struct_ver_id

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

28257: ,x_msg_count => l_msg_count
28258: ,x_msg_data => l_msg_data ) ;
28259: ELSE
28260:
28261: PA_PROJ_TASK_STRUC_PUB.PROCESS_WBS_UPDATES_CONC_WRP(p_calling_context => 'CONC_UPDATE'
28262: ,p_project_id => p_pa_project_id
28263: ,p_structure_version_id => p_published_struct_ver_id
28264: ,x_return_status => l_return_status
28265: ,x_msg_count => l_msg_count

Line 28456: PA_PROJ_TASK_STRUC_PUB.DELETE_STRUCTURE_VERSION(

28452: -- Set API return status to success
28453:
28454: p_return_status := FND_API.G_RET_STS_SUCCESS;
28455:
28456: PA_PROJ_TASK_STRUC_PUB.DELETE_STRUCTURE_VERSION(
28457: p_api_version => p_api_version_number
28458: ,p_init_msg_list => p_init_msg_list
28459: ,p_commit => FND_API.G_FALSE--bug 3766967
28460: ,p_calling_module => 'AMG'

Line 28835: PA_PROJ_TASK_STRUC_PUB.get_task_version_id(

28831: p_return_status := FND_API.G_RET_STS_ERROR;
28832: RAISE FND_API.G_EXC_ERROR;
28833: END IF;
28834:
28835: PA_PROJ_TASK_STRUC_PUB.get_task_version_id(
28836: p_project_id => p_pa_project_id
28837: ,p_structure_version_id => p_pa_structure_version_id
28838: ,p_task_id => p_pa_task_id
28839: ,x_task_version_id => p_task_version_id

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

34116: AND ( p_wp_structure_version_id IS NULL OR p_wp_structure_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
34117: )
34118: THEN
34119:
34120: IF (PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS(l_project_id) = 'Y') THEN
34121: l_wp_structure_version_id := PA_PROJ_ELEMENTS_UTILS.LATEST_PUBLISHED_VER_ID(l_project_id, 'WORKPLAN');
34122: IF (l_wp_structure_version_id = -1 OR l_wp_structure_version_id = NULL)
34123: THEN
34124: l_wp_structure_version_id := PA_PROJECT_STRUCTURE_UTILS.get_current_working_ver_id(l_project_id);

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

34471: --Get the task version id from Wkp task Id
34472: -- Avoid this call if wkp task name and wkp task version ids are passed
34473: IF (l_wkp_task_id IS NOT NULL AND l_wkp_structure_version_id IS NULL ) THEN
34474:
34475: IF (PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS(l_project_id) = 'Y') THEN
34476: l_wkp_structure_version_id := PA_PROJ_ELEMENTS_UTILS.LATEST_PUBLISHED_VER_ID(l_project_id, 'WORKPLAN');
34477: IF (l_wkp_structure_version_id = -1 OR l_wkp_structure_version_id = NULL)
34478: THEN
34479: l_wkp_structure_version_id := PA_PROJECT_STRUCTURE_UTILS.get_current_working_ver_id(l_project_id);

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

34819:
34820: --Get the task version id from Wkp task Id
34821: -- Avoid this call if wkp task name and wkp task version ids are passed
34822: IF (l_wkp_task_id IS NOT NULL AND l_wkp_structure_version_id IS NULL ) THEN
34823: IF (PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS(l_project_id) = 'Y') THEN
34824: l_wkp_structure_version_id := PA_PROJ_ELEMENTS_UTILS.LATEST_PUBLISHED_VER_ID(l_project_id, 'WORKPLAN');
34825: IF (l_wkp_structure_version_id IS NULL OR l_wkp_structure_version_id = -1) THEN
34826: l_wkp_structure_version_id := PA_PROJECT_STRUCTURE_UTILS.get_current_working_ver_id(l_project_id);
34827: END IF;

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

35044: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
35045: RAISE FND_API.G_EXC_ERROR;
35046: END IF;
35047: -- Get the project sharing type
35048: l_proj_share_type := PA_PROJ_TASK_STRUC_PUB.GET_SHARE_TYPE(l_project_id);
35049: IF (l_proj_share_type = 'SHARE_PARTIAL' and p_structure_type = 'FINANCIAL')
35050: THEN
35051: FOR iCounter IN REVERSE p_tasks_in_tbl.FIRST..p_tasks_in_tbl.LAST LOOP
35052: l_task_rec := p_tasks_in_tbl(iCounter);

Line 36113: PA_PROJ_TASK_STRUC_PUB.get_version_ids

36109:
36110: END IF;
36111: --get structure_version_id and task_version_id
36112:
36113: PA_PROJ_TASK_STRUC_PUB.get_version_ids
36114: (p_task_id => l_task_id
36115: , p_task_version_id => p_task_version_id
36116: , p_project_id => l_project_id
36117: , x_structure_version_id => l_structure_version_id

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

36173: open l_amg_task_csr(l_task_id );
36174: fetch l_amg_task_csr INTO l_amg_task_number;
36175: close l_amg_task_csr;
36176:
36177: l_wp_str_exists := PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS( p_project_id );
36178: l_versioning_enabled := PA_PROJ_TASK_STRUC_PUB.IS_WP_VERSIONING_ENABLED( l_project_id);
36179: l_pub_ver_exists := PA_PROJ_TASK_STRUC_PUB.Published_version_exists( l_project_id );
36180:
36181: -- If this passed task belongs to a Split - Fin. Only structure

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

36174: fetch l_amg_task_csr INTO l_amg_task_number;
36175: close l_amg_task_csr;
36176:
36177: l_wp_str_exists := PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS( p_project_id );
36178: l_versioning_enabled := PA_PROJ_TASK_STRUC_PUB.IS_WP_VERSIONING_ENABLED( l_project_id);
36179: l_pub_ver_exists := PA_PROJ_TASK_STRUC_PUB.Published_version_exists( l_project_id );
36180:
36181: -- If this passed task belongs to a Split - Fin. Only structure
36182: IF nvl(l_wp_str_exists,'N') = 'N'

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

36175: close l_amg_task_csr;
36176:
36177: l_wp_str_exists := PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS( p_project_id );
36178: l_versioning_enabled := PA_PROJ_TASK_STRUC_PUB.IS_WP_VERSIONING_ENABLED( l_project_id);
36179: l_pub_ver_exists := PA_PROJ_TASK_STRUC_PUB.Published_version_exists( l_project_id );
36180:
36181: -- If this passed task belongs to a Split - Fin. Only structure
36182: IF nvl(l_wp_str_exists,'N') = 'N'
36183: AND (PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version(l_structure_version_id, 'FINANCIAL') = 'Y')

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

36547: IF nvl(l_message_type,'NOT_PROCESS') <> 'PROCESS' THEN
36548:
36549: IF p_process_mode = 'ONLINE' THEN
36550:
36551: PA_PROJ_TASK_STRUC_PUB.PROCESS_WBS_UPDATES(p_calling_context => 'ONLINE_UPDATE'
36552: ,p_project_id => l_project_id
36553: ,p_structure_version_id => p_structure_version_id
36554: ,x_return_status => l_return_status
36555: ,x_msg_count => l_msg_count

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

36564: END IF;
36565:
36566: ELSIF p_process_mode = 'CONCURRENT' THEN
36567:
36568: PA_PROJ_TASK_STRUC_PUB.PROCESS_WBS_UPDATES_CONC_WRP(p_calling_context => 'CONC_UPDATE'
36569: ,p_project_id => l_project_id
36570: ,p_structure_version_id => p_structure_version_id
36571: ,x_return_status => l_return_status
36572: ,x_msg_count => l_msg_count

Line 41158: PA_PROJ_TASK_STRUC_PUB.SET_UPDATE_WBS_FLAG

41154: END IF;
41155: END IF;
41156:
41157: IF (l_wp_process_flag = 'Y') THEN
41158: PA_PROJ_TASK_STRUC_PUB.SET_UPDATE_WBS_FLAG
41159: (
41160: p_calling_context => 'SELF_SERVICE'
41161: ,p_project_id => p_project_id
41162: ,p_structure_version_id => p_structure_version_id

Line 42675: PA_PROJ_TASK_STRUC_PUB.SET_UPDATE_WBS_FLAG

42671: l_wp_process_flag := 'Y';
42672: END IF;
42673: END IF;
42674:
42675: PA_PROJ_TASK_STRUC_PUB.SET_UPDATE_WBS_FLAG
42676: (
42677: p_calling_context => 'SELF_SERVICE'
42678: ,p_project_id => p_project_id
42679: ,p_structure_version_id => p_structure_version_id