DBA Data[Home] [Help]

APPS.PA_PROJECT_STRUCTURE_PUB1 dependencies on PA_PROJECT_STRUCTURE_UTILS

Line 103: l_approval_opt := PA_PROJECT_STRUCTURE_UTILS.get_approval_option(l_project_id);

99: FETCH get_project_id_csr INTO l_project_id;
100: CLOSE get_project_id_csr;
101: */
102:
103: l_approval_opt := PA_PROJECT_STRUCTURE_UTILS.get_approval_option(l_project_id);
104:
105: if l_approval_opt = 'N' then
106: if p_status_code = 'STRUCTURE_WORKING' then
107: OPEN get_locked_status_csr(p_version_id,l_project_id);

Line 1534: PA_PROJECT_STRUCTURE_UTILS.Check_Delete_Structure_Ver_Ok(l_project_id,

1530:
1531: ELSE -- Not a published structure version. Going with the existing regular flow.
1532:
1533: --Check delete structure version ok
1534: PA_PROJECT_STRUCTURE_UTILS.Check_Delete_Structure_Ver_Ok(l_project_id,
1535: p_structure_version_id,
1536: l_return_status,
1537: l_error_message_code);
1538: IF (l_return_status <> 'S') THEN

Line 1546: IF ('N' = PA_PROJECT_STRUCTURE_UTILS.check_del_work_struc_ver_ok(p_structure_version_id)) THEN

1542: END IF;
1543:
1544: -- 4369486 : Added this check : If this is the last working structure version,we wont be allowed to delete it.
1545:
1546: IF ('N' = PA_PROJECT_STRUCTURE_UTILS.check_del_work_struc_ver_ok(p_structure_version_id)) THEN
1547: PA_UTILS.ADD_MESSAGE('PA', 'PA_PS_DEL_WK_STRUC_VER_ERR');
1548: x_msg_data := 'PA_PS_DEL_WK_STRUC_VER_ERR';
1549: RAISE FND_API.G_EXC_ERROR;
1550: END IF;

Line 1604: IF (PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version(p_structure_version_id, 'WORKPLAN') = 'Y') THEN

1600: --If all tasks are deleted, delete schedule if workplan
1601: --Check if this is workplan
1602:
1603: -- Amit : Added IF condition below
1604: IF (PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version(p_structure_version_id, 'WORKPLAN') = 'Y') THEN
1605: l_structure_type := 'WORKPLAN';
1606: ELSE
1607: l_structure_type := 'FINANCIAL';
1608: END IF;

Line 1702: IF (PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Structure(l_proj_element_id, 'WORKPLAN') = 'Y') THEN

1698: IF (p_debug_mode = 'Y') THEN
1699: pa_debug.debug('delete non-versioned structure');
1700: END IF;
1701:
1702: IF (PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Structure(l_proj_element_id, 'WORKPLAN') = 'Y') THEN
1703: --delete workplan attribute
1704: OPEN sel_wp_attr(l_proj_element_id);
1705: FETCH sel_wp_attr into l_wp_attr_rvn;
1706: CLOSE sel_wp_attr;

Line 1935: IF ('Y' <> PA_PROJECT_STRUCTURE_UTILS.Check_Publish_Struc_Ver_Ok(p_structure_version_id)) THEN

1931: FND_MSG_PUB.initialize;
1932: END IF;
1933:
1934: --Check if this structure can be published (ie, if linked structures are published)
1935: IF ('Y' <> PA_PROJECT_STRUCTURE_UTILS.Check_Publish_Struc_Ver_Ok(p_structure_version_id)) THEN
1936: PA_UTILS.ADD_MESSAGE('PA','PA_PS_OTHER_WORKING_LOCKED');
1937: x_msg_data := 'PA_PS_OTHER_WORKING_LOCKED';
1938: RAISE FND_API.G_EXC_ERROR;
1939: END IF;

Line 2468: IF ('Y' <> PA_PROJECT_STRUCTURE_UTILS.Check_Publish_Struc_Ver_Ok(p_structure_version_id)) THEN

2464: FND_MSG_PUB.initialize;
2465: END IF;
2466:
2467: --Check if this structure can be published (ie, if linked structures are published)
2468: IF ('Y' <> PA_PROJECT_STRUCTURE_UTILS.Check_Publish_Struc_Ver_Ok(p_structure_version_id)) THEN
2469: PA_UTILS.ADD_MESSAGE('PA','PA_PS_OTHER_WORKING_LOCKED');
2470: x_msg_data := 'PA_PS_OTHER_WORKING_LOCKED';
2471: RAISE FND_API.G_EXC_ERROR;
2472: END IF;

Line 3019: PA_PROJECT_STRUCTURE_UTILS.Check_Delete_Structure_Ver_Ok(

3015: FETCH c1 into l_project_id;
3016: CLOSE c1;
3017:
3018: --Check if locked
3019: PA_PROJECT_STRUCTURE_UTILS.Check_Delete_Structure_Ver_Ok(
3020: l_project_id
3021: ,p_structure_version_id
3022: ,l_return_status
3023: ,l_error_message_code);

Line 3032: IF ('N' = PA_PROJECT_STRUCTURE_UTILS.check_del_work_struc_ver_ok(p_structure_version_id)) THEN

3028: RAISE FND_API.G_EXC_ERROR;
3029: END IF;
3030:
3031: --Check if it is ok to delete working version
3032: IF ('N' = PA_PROJECT_STRUCTURE_UTILS.check_del_work_struc_ver_ok(p_structure_version_id)) THEN
3033: PA_UTILS.ADD_MESSAGE('PA', 'PA_PS_DEL_WK_STRUC_VER_ERR');
3034: x_msg_data := 'PA_PS_DEL_WK_STRUC_VER_ERR';
3035: RAISE FND_API.G_EXC_ERROR;
3036: END IF;

Line 3355: l_check_sharing_enabled := PA_PROJECT_STRUCTURE_UTILS.CHECK_SHARING_ENABLED(p_project_id);

3351: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
3352: FND_MSG_PUB.initialize;
3353: END IF;
3354:
3355: l_check_sharing_enabled := PA_PROJECT_STRUCTURE_UTILS.CHECK_SHARING_ENABLED(p_project_id);
3356:
3357: /* hsiu: added, 3305199 */
3358: select a.proj_element_id into l_parent_structure_id
3359: from pa_proj_elements a, pa_proj_structure_types b, pa_structure_types c

Line 3894: l_val_return_status := PA_PROJECT_STRUCTURE_UTILS.check_del_pub_struc_ver_ok(p_structure_version_id_tbl(i));

3890: -- If Y is returned then proceed with the
3891: -- progress rollup and
3892: -- actual deletion.
3893: -- l_structure_version_rec := p_structure_version_in_tbl(i);
3894: l_val_return_status := PA_PROJECT_STRUCTURE_UTILS.check_del_pub_struc_ver_ok(p_structure_version_id_tbl(i));
3895:
3896: IF (l_val_return_status = 'Y') then
3897:
3898: if (l_validation_failed <> 'Y'))THEN

Line 4058: l_val_return_status := PA_PROJECT_STRUCTURE_UTILS.check_del_pub_struc_ver_ok(p_structure_version_id_tbl(i),p_project_id);

4054:
4055: -- If Y is returned then proceed with the
4056: -- progress rollup and
4057: -- actual deletion.
4058: l_val_return_status := PA_PROJECT_STRUCTURE_UTILS.check_del_pub_struc_ver_ok(p_structure_version_id_tbl(i),p_project_id);
4059: IF l_val_return_status = 'Y' THEN
4060: -- Call Progress rollup API
4061:
4062: pa_progress_pvt.UPD_PROG_RECS_STR_DELETE(

Line 4145: l_wp_enabled := PA_PROJECT_STRUCTURE_UTILS.Check_workplan_enabled(p_project_id);

4141: l_share_code VARCHAR2(30) := NULL;
4142:
4143: BEGIN
4144:
4145: l_wp_enabled := PA_PROJECT_STRUCTURE_UTILS.Check_workplan_enabled(p_project_id);
4146: l_fin_enabled := PA_PROJECT_STRUCTURE_UTILS.Check_financial_enabled(p_project_id);
4147: l_delv_enabled := PA_PROJECT_STRUCTURE_UTILS.Check_deliverable_enabled(p_project_id);
4148: l_share_code := PA_PROJECT_STRUCTURE_UTILS.Get_Structure_sharing_code(p_project_id);
4149:

Line 4146: l_fin_enabled := PA_PROJECT_STRUCTURE_UTILS.Check_financial_enabled(p_project_id);

4142:
4143: BEGIN
4144:
4145: l_wp_enabled := PA_PROJECT_STRUCTURE_UTILS.Check_workplan_enabled(p_project_id);
4146: l_fin_enabled := PA_PROJECT_STRUCTURE_UTILS.Check_financial_enabled(p_project_id);
4147: l_delv_enabled := PA_PROJECT_STRUCTURE_UTILS.Check_deliverable_enabled(p_project_id);
4148: l_share_code := PA_PROJECT_STRUCTURE_UTILS.Get_Structure_sharing_code(p_project_id);
4149:
4150: PA_PROJECT_STRUCTURE_PUB1.UPDATE_STRUCTURES_SETUP_ATTR(

Line 4147: l_delv_enabled := PA_PROJECT_STRUCTURE_UTILS.Check_deliverable_enabled(p_project_id);

4143: BEGIN
4144:
4145: l_wp_enabled := PA_PROJECT_STRUCTURE_UTILS.Check_workplan_enabled(p_project_id);
4146: l_fin_enabled := PA_PROJECT_STRUCTURE_UTILS.Check_financial_enabled(p_project_id);
4147: l_delv_enabled := PA_PROJECT_STRUCTURE_UTILS.Check_deliverable_enabled(p_project_id);
4148: l_share_code := PA_PROJECT_STRUCTURE_UTILS.Get_Structure_sharing_code(p_project_id);
4149:
4150: PA_PROJECT_STRUCTURE_PUB1.UPDATE_STRUCTURES_SETUP_ATTR(
4151: p_api_version => 1.0

Line 4148: l_share_code := PA_PROJECT_STRUCTURE_UTILS.Get_Structure_sharing_code(p_project_id);

4144:
4145: l_wp_enabled := PA_PROJECT_STRUCTURE_UTILS.Check_workplan_enabled(p_project_id);
4146: l_fin_enabled := PA_PROJECT_STRUCTURE_UTILS.Check_financial_enabled(p_project_id);
4147: l_delv_enabled := PA_PROJECT_STRUCTURE_UTILS.Check_deliverable_enabled(p_project_id);
4148: l_share_code := PA_PROJECT_STRUCTURE_UTILS.Get_Structure_sharing_code(p_project_id);
4149:
4150: PA_PROJECT_STRUCTURE_PUB1.UPDATE_STRUCTURES_SETUP_ATTR(
4151: p_api_version => 1.0
4152: ,p_init_msg_list => 'T'