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_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 1934: IF ('Y' <> PA_PROJECT_STRUCTURE_UTILS.Check_Publish_Struc_Ver_Ok(p_structure_version_id)) THEN

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

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

2448: FND_MSG_PUB.initialize;
2449: END IF;
2450:
2451: --Check if this structure can be published (ie, if linked structures are published)
2452: IF ('Y' <> PA_PROJECT_STRUCTURE_UTILS.Check_Publish_Struc_Ver_Ok(p_structure_version_id)) THEN
2453: PA_UTILS.ADD_MESSAGE('PA','PA_PS_OTHER_WORKING_LOCKED');
2454: x_msg_data := 'PA_PS_OTHER_WORKING_LOCKED';
2455: RAISE FND_API.G_EXC_ERROR;
2456: END IF;

Line 2999: PA_PROJECT_STRUCTURE_UTILS.Check_Delete_Structure_Ver_Ok(

2995: FETCH c1 into l_project_id;
2996: CLOSE c1;
2997:
2998: --Check if locked
2999: PA_PROJECT_STRUCTURE_UTILS.Check_Delete_Structure_Ver_Ok(
3000: l_project_id
3001: ,p_structure_version_id
3002: ,l_return_status
3003: ,l_error_message_code);

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

3008: RAISE FND_API.G_EXC_ERROR;
3009: END IF;
3010:
3011: --Check if it is ok to delete working version
3012: IF ('N' = PA_PROJECT_STRUCTURE_UTILS.check_del_work_struc_ver_ok(p_structure_version_id)) THEN
3013: PA_UTILS.ADD_MESSAGE('PA', 'PA_PS_DEL_WK_STRUC_VER_ERR');
3014: x_msg_data := 'PA_PS_DEL_WK_STRUC_VER_ERR';
3015: RAISE FND_API.G_EXC_ERROR;
3016: END IF;

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

3331: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
3332: FND_MSG_PUB.initialize;
3333: END IF;
3334:
3335: l_check_sharing_enabled := PA_PROJECT_STRUCTURE_UTILS.CHECK_SHARING_ENABLED(p_project_id);
3336:
3337: /* hsiu: added, 3305199 */
3338: select a.proj_element_id into l_parent_structure_id
3339: from pa_proj_elements a, pa_proj_structure_types b, pa_structure_types c

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

3870: -- If Y is returned then proceed with the
3871: -- progress rollup and
3872: -- actual deletion.
3873: -- l_structure_version_rec := p_structure_version_in_tbl(i);
3874: l_val_return_status := PA_PROJECT_STRUCTURE_UTILS.check_del_pub_struc_ver_ok(p_structure_version_id_tbl(i));
3875:
3876: IF (l_val_return_status = 'Y') then
3877:
3878: if (l_validation_failed <> 'Y'))THEN

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

4034:
4035: -- If Y is returned then proceed with the
4036: -- progress rollup and
4037: -- actual deletion.
4038: l_val_return_status := PA_PROJECT_STRUCTURE_UTILS.check_del_pub_struc_ver_ok(p_structure_version_id_tbl(i),p_project_id);
4039: IF l_val_return_status = 'Y' THEN
4040: -- Call Progress rollup API
4041:
4042: pa_progress_pvt.UPD_PROG_RECS_STR_DELETE(

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

4121: l_share_code VARCHAR2(30) := NULL;
4122:
4123: BEGIN
4124:
4125: l_wp_enabled := PA_PROJECT_STRUCTURE_UTILS.Check_workplan_enabled(p_project_id);
4126: l_fin_enabled := PA_PROJECT_STRUCTURE_UTILS.Check_financial_enabled(p_project_id);
4127: l_delv_enabled := PA_PROJECT_STRUCTURE_UTILS.Check_deliverable_enabled(p_project_id);
4128: l_share_code := PA_PROJECT_STRUCTURE_UTILS.Get_Structure_sharing_code(p_project_id);
4129:

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

4122:
4123: BEGIN
4124:
4125: l_wp_enabled := PA_PROJECT_STRUCTURE_UTILS.Check_workplan_enabled(p_project_id);
4126: l_fin_enabled := PA_PROJECT_STRUCTURE_UTILS.Check_financial_enabled(p_project_id);
4127: l_delv_enabled := PA_PROJECT_STRUCTURE_UTILS.Check_deliverable_enabled(p_project_id);
4128: l_share_code := PA_PROJECT_STRUCTURE_UTILS.Get_Structure_sharing_code(p_project_id);
4129:
4130: PA_PROJECT_STRUCTURE_PUB1.UPDATE_STRUCTURES_SETUP_ATTR(

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

4123: BEGIN
4124:
4125: l_wp_enabled := PA_PROJECT_STRUCTURE_UTILS.Check_workplan_enabled(p_project_id);
4126: l_fin_enabled := PA_PROJECT_STRUCTURE_UTILS.Check_financial_enabled(p_project_id);
4127: l_delv_enabled := PA_PROJECT_STRUCTURE_UTILS.Check_deliverable_enabled(p_project_id);
4128: l_share_code := PA_PROJECT_STRUCTURE_UTILS.Get_Structure_sharing_code(p_project_id);
4129:
4130: PA_PROJECT_STRUCTURE_PUB1.UPDATE_STRUCTURES_SETUP_ATTR(
4131: p_api_version => 1.0

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

4124:
4125: l_wp_enabled := PA_PROJECT_STRUCTURE_UTILS.Check_workplan_enabled(p_project_id);
4126: l_fin_enabled := PA_PROJECT_STRUCTURE_UTILS.Check_financial_enabled(p_project_id);
4127: l_delv_enabled := PA_PROJECT_STRUCTURE_UTILS.Check_deliverable_enabled(p_project_id);
4128: l_share_code := PA_PROJECT_STRUCTURE_UTILS.Get_Structure_sharing_code(p_project_id);
4129:
4130: PA_PROJECT_STRUCTURE_PUB1.UPDATE_STRUCTURES_SETUP_ATTR(
4131: p_api_version => 1.0
4132: ,p_init_msg_list => 'T'