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_RELATIONSHIP_PVT dependencies on PA_PROJECT_STRUCTURE_UTILS

Line 443: if PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(p_structure_version_id_from, 'WORKPLAN') = 'Y' then

439: end if;
440: RAISE FND_API.G_EXC_ERROR;
441: end if;
442:
443: if PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(p_structure_version_id_from, 'WORKPLAN') = 'Y' then
444: PA_TASK_PUB1.CREATE_SCHEDULE_VERSION
445: ( p_validate_only => FND_API.G_FALSE
446: ,p_element_version_id => l_task_version_id
447: ,p_scheduled_start_date => l_scheduled_start_date

Line 1172: IF (UPPER(PA_PROJECT_STRUCTURE_UTILS.check_dep_on_summary_tk_ok(p_src_proj_id)) <> 'Y') THEN

1168: END IF;
1169: END IF;
1170:
1171: /* Checking source task is summary task or not */
1172: IF (UPPER(PA_PROJECT_STRUCTURE_UTILS.check_dep_on_summary_tk_ok(p_src_proj_id)) <> 'Y') THEN
1173: l_cnt := 0;
1174: BEGIN
1175: OPEN is_summary_task(p_src_task_ver_id);
1176: FETCH is_summary_task into l_cnt;

Line 1191: IF (UPPER(PA_PROJECT_STRUCTURE_UTILS.check_dep_on_summary_tk_ok(p_dest_proj_id)) <> 'Y') THEN

1187: END IF;
1188:
1189:
1190: /* Checking destination task is summary task or not */
1191: IF (UPPER(PA_PROJECT_STRUCTURE_UTILS.check_dep_on_summary_tk_ok(p_dest_proj_id)) <> 'Y') THEN
1192: l_cnt := 0;
1193: BEGIN
1194: OPEN is_summary_task(p_dest_task_ver_id);
1195: FETCH IS_SUMMARY_TASK into l_cnt;

Line 1713: IF PA_PROJECT_STRUCTURE_UTILS.Check_Struc_Ver_Published(l_project_id,l_struc_ver_id) = 'Y' THEN

1709: --
1710: -- Bug No 3494587, added this to code check if the the structure ver is published
1711: -- if the sturcture ver is published then the process should not allow to delete dependency
1712: IF PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(l_project_id) = 'Y' THEN
1713: IF PA_PROJECT_STRUCTURE_UTILS.Check_Struc_Ver_Published(l_project_id,l_struc_ver_id) = 'Y' THEN
1714: PA_UTILS.ADD_MESSAGE('PA','PA_DEL_DEP_FOR_PUB_STR');
1715: RAISE FND_API.G_EXC_ERROR;
1716: END IF;
1717: END IF;

Line 3148: l_sharing_code := PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(p_src_proj_id);

3144: END IF;
3145: --
3146: --bug 4279634
3147: --set chargeable to N
3148: l_sharing_code := PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(p_src_proj_id);
3149:
3150: -- Begin fix for Bug # 4490532.
3151: -- Modifications to allow the collection of progress on those tasks in the parent project
3152: -- that have sub-projects linked to them.

Line 3160: IF 'N' = PA_PROJECT_STRUCTURE_UTILS.CHECK_PUBLISHED_VER_EXISTS(p_src_proj_id, p_src_struc_elem_id) THEN

3156: IF (l_sharing_code = 'SHARE_FULL')
3157: OR (l_sharing_code = 'SHARE_PARTIAL') THEN
3158: IF PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(p_src_proj_id) = 'Y' THEN
3159: --IF no publishing version, set flag to N
3160: IF 'N' = PA_PROJECT_STRUCTURE_UTILS.CHECK_PUBLISHED_VER_EXISTS(p_src_proj_id, p_src_struc_elem_id) THEN
3161: UPDATE PA_TASKS
3162: SET
3163: CHARGEABLE_FLAG = 'N',
3164: RECORD_VERSION_NUMBER = nvl(RECORD_VERSION_NUMBER,0)+1,

Line 3570: l_src_proj_sharing_code:=PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(p_src_proj_id);

3566: pa_debug.debug('The value of the passed comments=> '||p_comment);
3567: END IF;
3568: --
3569: -- Check for source structure type
3570: l_src_proj_sharing_code:=PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(p_src_proj_id);
3571: --
3572: --
3573: IF (p_debug_mode = 'Y') THEN
3574: pa_debug.debug('The src project id value => '||p_src_proj_id);

Line 3628: /* IF PA_PROJECT_STRUCTURE_UTILS.get_element_struc_type(p_src_proj_id,p_task_ver_id,'PA_TASKS') = 'WORKPLAN' THEN

3624: pa_debug.debug('The value of src task financial flag => '||l_src_task_financial_flag);
3625: pa_debug.debug('The value of src task elem id => '||l_src_task_elem_id);
3626: END IF;
3627: --
3628: /* IF PA_PROJECT_STRUCTURE_UTILS.get_element_struc_type(p_src_proj_id,p_task_ver_id,'PA_TASKS') = 'WORKPLAN' THEN
3629: l_src_str_wp_enable_fl:='Y';
3630: END IF;*/
3631: --
3632: /* IF PA_PROJECT_STRUCTURE_UTILS.get_element_struc_type(p_src_proj_id,p_task_ver_id,'PA_TASKS') = 'FINANCIAL' THEN

Line 3632: /* IF PA_PROJECT_STRUCTURE_UTILS.get_element_struc_type(p_src_proj_id,p_task_ver_id,'PA_TASKS') = 'FINANCIAL' THEN

3628: /* IF PA_PROJECT_STRUCTURE_UTILS.get_element_struc_type(p_src_proj_id,p_task_ver_id,'PA_TASKS') = 'WORKPLAN' THEN
3629: l_src_str_wp_enable_fl:='Y';
3630: END IF;*/
3631: --
3632: /* IF PA_PROJECT_STRUCTURE_UTILS.get_element_struc_type(p_src_proj_id,p_task_ver_id,'PA_TASKS') = 'FINANCIAL' THEN
3633: l_src_str_fin_enable_fl:='Y';
3634: END IF;*/
3635: --
3636: IF ('Y' = PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Structure(l_src_struc_elem_id, 'WORKPLAN')) THEN

Line 3636: IF ('Y' = PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Structure(l_src_struc_elem_id, 'WORKPLAN')) THEN

3632: /* IF PA_PROJECT_STRUCTURE_UTILS.get_element_struc_type(p_src_proj_id,p_task_ver_id,'PA_TASKS') = 'FINANCIAL' THEN
3633: l_src_str_fin_enable_fl:='Y';
3634: END IF;*/
3635: --
3636: IF ('Y' = PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Structure(l_src_struc_elem_id, 'WORKPLAN')) THEN
3637: l_src_str_wp_enable_fl:='Y';
3638: END IF;
3639:
3640: IF ('Y' = PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Structure(l_src_struc_elem_id, 'FINANCIAL')) THEN

Line 3640: IF ('Y' = PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Structure(l_src_struc_elem_id, 'FINANCIAL')) THEN

3636: IF ('Y' = PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Structure(l_src_struc_elem_id, 'WORKPLAN')) THEN
3637: l_src_str_wp_enable_fl:='Y';
3638: END IF;
3639:
3640: IF ('Y' = PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Structure(l_src_struc_elem_id, 'FINANCIAL')) THEN
3641: l_src_str_fin_enable_fl:='Y';
3642: END IF;
3643: --
3644: IF (p_debug_mode = 'Y') THEN

Line 3661: l_dest_proj_sharing_code:=PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(p_dest_proj_id);

3657: --
3658: -- Check for target structure type
3659: -- Get the latest published structure, if there is one for the given project_id(p_dest_proj_id)
3660: --
3661: l_dest_proj_sharing_code:=PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(p_dest_proj_id);
3662: --
3663: l_dest_fin_str_ver_id:=PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_FIN_STRUC_VER_ID(p_dest_proj_id);
3664: l_dest_wp_str_ver_id:=PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION(p_dest_proj_id);
3665:

Line 3663: l_dest_fin_str_ver_id:=PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_FIN_STRUC_VER_ID(p_dest_proj_id);

3659: -- Get the latest published structure, if there is one for the given project_id(p_dest_proj_id)
3660: --
3661: l_dest_proj_sharing_code:=PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(p_dest_proj_id);
3662: --
3663: l_dest_fin_str_ver_id:=PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_FIN_STRUC_VER_ID(p_dest_proj_id);
3664: l_dest_wp_str_ver_id:=PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION(p_dest_proj_id);
3665:
3666: --bug 4370533 --Issue #3
3667: l_dest_published_wp_str_id := l_dest_wp_str_ver_id;

Line 3664: l_dest_wp_str_ver_id:=PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION(p_dest_proj_id);

3660: --
3661: l_dest_proj_sharing_code:=PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(p_dest_proj_id);
3662: --
3663: l_dest_fin_str_ver_id:=PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_FIN_STRUC_VER_ID(p_dest_proj_id);
3664: l_dest_wp_str_ver_id:=PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION(p_dest_proj_id);
3665:
3666: --bug 4370533 --Issue #3
3667: l_dest_published_wp_str_id := l_dest_wp_str_ver_id;
3668: --bug 4370533 --Issue #3

Line 3673: l_dest_wp_str_ver_id :=PA_PROJECT_STRUCTURE_UTILS.get_current_working_ver_id(p_dest_proj_id);

3669:
3670: --
3671: /* IF l_dest_fin_str_ver_id IS NULL AND l_dest_wp_str_ver_id IS NULL THEN
3672: --get current working wp ver
3673: l_dest_wp_str_ver_id :=PA_PROJECT_STRUCTURE_UTILS.get_current_working_ver_id(p_dest_proj_id);
3674: --get only version for fin
3675: PA_PROJECT_STRUCTURE_UTILS.Get_Financial_Version(p_dest_proj_id,l_dest_fin_str_ver_id);
3676: END IF;*/
3677:

Line 3675: PA_PROJECT_STRUCTURE_UTILS.Get_Financial_Version(p_dest_proj_id,l_dest_fin_str_ver_id);

3671: /* IF l_dest_fin_str_ver_id IS NULL AND l_dest_wp_str_ver_id IS NULL THEN
3672: --get current working wp ver
3673: l_dest_wp_str_ver_id :=PA_PROJECT_STRUCTURE_UTILS.get_current_working_ver_id(p_dest_proj_id);
3674: --get only version for fin
3675: PA_PROJECT_STRUCTURE_UTILS.Get_Financial_Version(p_dest_proj_id,l_dest_fin_str_ver_id);
3676: END IF;*/
3677:
3678: IF l_dest_fin_str_ver_id IS NULL THEN --SMukka added if block
3679: --get only version for fin

Line 3680: PA_PROJECT_STRUCTURE_UTILS.Get_Financial_Version(p_dest_proj_id,l_dest_fin_str_ver_id);

3676: END IF;*/
3677:
3678: IF l_dest_fin_str_ver_id IS NULL THEN --SMukka added if block
3679: --get only version for fin
3680: PA_PROJECT_STRUCTURE_UTILS.Get_Financial_Version(p_dest_proj_id,l_dest_fin_str_ver_id);
3681:
3682: -- Begin fix for Bug # 4426392.
3683:
3684: if (l_dest_fin_str_ver_id = -1) then

Line 3696: l_dest_wp_str_ver_id :=PA_PROJECT_STRUCTURE_UTILS.get_current_working_ver_id(p_dest_proj_id);

3692: END IF;
3693: --
3694: IF l_dest_wp_str_ver_id IS NULL THEN --SMukka added if block
3695: --get current working wp ver
3696: l_dest_wp_str_ver_id :=PA_PROJECT_STRUCTURE_UTILS.get_current_working_ver_id(p_dest_proj_id);
3697: END IF;
3698: --
3699: IF (p_debug_mode = 'Y') THEN
3700: pa_debug.debug('Dest WP Str Ver Id => '||l_dest_wp_str_ver_id);

Line 4151: pa_project_structure_utils.check_struc_ver_published(p_dest_proj_id, l_dest_wp_str_ver_id) = 'Y'

4147: -- Begin Bug # 4573015.
4148: (
4149: l_dest_fin_str_ver_id is not null
4150: or
4151: pa_project_structure_utils.check_struc_ver_published(p_dest_proj_id, l_dest_wp_str_ver_id) = 'Y'
4152: )
4153: -- End Bug # 4573015.
4154: )
4155: or

Line 4169: pa_project_structure_utils.check_struc_ver_published(p_dest_proj_id, l_dest_wp_str_ver_id) = 'Y'

4165: l_dest_wp_str_ver_id IS NOT NULL
4166: and
4167: l_src_str_wp_enable_fl = 'Y'
4168: and
4169: pa_project_structure_utils.check_struc_ver_published(p_dest_proj_id, l_dest_wp_str_ver_id) = 'Y'
4170: )
4171: or
4172: (
4173: l_dest_fin_str_ver_id IS NOT NULL

Line 4179: pa_project_structure_utils.check_struc_ver_published(p_dest_proj_id, l_dest_fin_str_ver_id) = 'Y'

4175: l_src_task_financial_flag='Y'
4176: and
4177: l_src_str_fin_enable_fl = 'Y'
4178: and
4179: pa_project_structure_utils.check_struc_ver_published(p_dest_proj_id, l_dest_fin_str_ver_id) = 'Y'
4180: )
4181: )
4182: )
4183: -- Begin Bug # 4573015.

Line 4190: pa_project_structure_utils.check_struc_ver_published(p_dest_proj_id, l_dest_wp_str_ver_id) = 'Y'

4186: l_src_str_wp_enable_fl = 'Y'
4187: and
4188: l_src_str_fin_enable_fl = 'N'
4189: and
4190: pa_project_structure_utils.check_struc_ver_published(p_dest_proj_id, l_dest_wp_str_ver_id) = 'Y'
4191: )
4192: or
4193: (
4194: l_src_str_fin_enable_fl = 'Y'

Line 4724: if pa_project_structure_utils.get_struc_type_for_version(l_src_structure_ver_id, 'WORKPLAN') = 'Y' then

4720:
4721: /* bug 4541039
4722: -- Begin fix for Bug # 4385027.
4723:
4724: if pa_project_structure_utils.get_struc_type_for_version(l_src_structure_ver_id, 'WORKPLAN') = 'Y' then
4725:
4726: l_tasks_ver_ids.extend(1);
4727: l_tasks_ver_ids(1) := get_src_task_ver_id_rec.object_id_from1;
4728:

Line 4784: IF PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(l_src_structure_ver_id, 'WORKPLAN') = 'Y'

4780:
4781: -- set WBS flag dirty for the project
4782:
4783: --Update dirty only if workplan gets deleted.
4784: IF PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(l_src_structure_ver_id, 'WORKPLAN') = 'Y'
4785: THEN
4786: PA_PROJ_TASK_STRUC_PUB.SET_UPDATE_WBS_FLAG
4787: (
4788: p_calling_context => 'SELF_SERVICE'