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 1173: IF (UPPER(PA_PROJECT_STRUCTURE_UTILS.check_dep_on_summary_tk_ok(p_src_proj_id)) <> 'Y') THEN

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

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

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

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

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

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

3157: END IF;
3158: --
3159: --bug 4279634
3160: --set chargeable to N
3161: l_sharing_code := PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(p_src_proj_id);
3162:
3163: -- Begin fix for Bug # 4490532.
3164: -- Modifications to allow the collection of progress on those tasks in the parent project
3165: -- that have sub-projects linked to them.

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

3169: IF (l_sharing_code = 'SHARE_FULL')
3170: OR (l_sharing_code = 'SHARE_PARTIAL') THEN
3171: IF PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(p_src_proj_id) = 'Y' THEN
3172: --IF no publishing version, set flag to N
3173: IF 'N' = PA_PROJECT_STRUCTURE_UTILS.CHECK_PUBLISHED_VER_EXISTS(p_src_proj_id, p_src_struc_elem_id) THEN
3174: UPDATE PA_TASKS
3175: SET
3176: CHARGEABLE_FLAG = 'N',
3177: RECORD_VERSION_NUMBER = nvl(RECORD_VERSION_NUMBER,0)+1,

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

3579: pa_debug.debug('The value of the passed comments=> '||p_comment);
3580: END IF;
3581: --
3582: -- Check for source structure type
3583: l_src_proj_sharing_code:=PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(p_src_proj_id);
3584: --
3585: --
3586: IF (p_debug_mode = 'Y') THEN
3587: pa_debug.debug('The src project id value => '||p_src_proj_id);

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

3637: pa_debug.debug('The value of src task financial flag => '||l_src_task_financial_flag);
3638: pa_debug.debug('The value of src task elem id => '||l_src_task_elem_id);
3639: END IF;
3640: --
3641: /* IF PA_PROJECT_STRUCTURE_UTILS.get_element_struc_type(p_src_proj_id,p_task_ver_id,'PA_TASKS') = 'WORKPLAN' THEN
3642: l_src_str_wp_enable_fl:='Y';
3643: END IF;*/
3644: --
3645: /* IF PA_PROJECT_STRUCTURE_UTILS.get_element_struc_type(p_src_proj_id,p_task_ver_id,'PA_TASKS') = 'FINANCIAL' THEN

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

3641: /* IF PA_PROJECT_STRUCTURE_UTILS.get_element_struc_type(p_src_proj_id,p_task_ver_id,'PA_TASKS') = 'WORKPLAN' THEN
3642: l_src_str_wp_enable_fl:='Y';
3643: END IF;*/
3644: --
3645: /* IF PA_PROJECT_STRUCTURE_UTILS.get_element_struc_type(p_src_proj_id,p_task_ver_id,'PA_TASKS') = 'FINANCIAL' THEN
3646: l_src_str_fin_enable_fl:='Y';
3647: END IF;*/
3648: --
3649: IF ('Y' = PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Structure(l_src_struc_elem_id, 'WORKPLAN')) THEN

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

3645: /* IF PA_PROJECT_STRUCTURE_UTILS.get_element_struc_type(p_src_proj_id,p_task_ver_id,'PA_TASKS') = 'FINANCIAL' THEN
3646: l_src_str_fin_enable_fl:='Y';
3647: END IF;*/
3648: --
3649: IF ('Y' = PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Structure(l_src_struc_elem_id, 'WORKPLAN')) THEN
3650: l_src_str_wp_enable_fl:='Y';
3651: END IF;
3652:
3653: IF ('Y' = PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Structure(l_src_struc_elem_id, 'FINANCIAL')) THEN

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

3649: IF ('Y' = PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Structure(l_src_struc_elem_id, 'WORKPLAN')) THEN
3650: l_src_str_wp_enable_fl:='Y';
3651: END IF;
3652:
3653: IF ('Y' = PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Structure(l_src_struc_elem_id, 'FINANCIAL')) THEN
3654: l_src_str_fin_enable_fl:='Y';
3655: END IF;
3656: --
3657: IF (p_debug_mode = 'Y') THEN

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

3670: --
3671: -- Check for target structure type
3672: -- Get the latest published structure, if there is one for the given project_id(p_dest_proj_id)
3673: --
3674: l_dest_proj_sharing_code:=PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(p_dest_proj_id);
3675: --
3676: l_dest_fin_str_ver_id:=PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_FIN_STRUC_VER_ID(p_dest_proj_id);
3677: l_dest_wp_str_ver_id:=PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION(p_dest_proj_id);
3678:

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

3672: -- Get the latest published structure, if there is one for the given project_id(p_dest_proj_id)
3673: --
3674: l_dest_proj_sharing_code:=PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(p_dest_proj_id);
3675: --
3676: l_dest_fin_str_ver_id:=PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_FIN_STRUC_VER_ID(p_dest_proj_id);
3677: l_dest_wp_str_ver_id:=PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION(p_dest_proj_id);
3678:
3679: --bug 4370533 --Issue #3
3680: l_dest_published_wp_str_id := l_dest_wp_str_ver_id;

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

3673: --
3674: l_dest_proj_sharing_code:=PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(p_dest_proj_id);
3675: --
3676: l_dest_fin_str_ver_id:=PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_FIN_STRUC_VER_ID(p_dest_proj_id);
3677: l_dest_wp_str_ver_id:=PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION(p_dest_proj_id);
3678:
3679: --bug 4370533 --Issue #3
3680: l_dest_published_wp_str_id := l_dest_wp_str_ver_id;
3681: --bug 4370533 --Issue #3

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

3682:
3683: --
3684: /* IF l_dest_fin_str_ver_id IS NULL AND l_dest_wp_str_ver_id IS NULL THEN
3685: --get current working wp ver
3686: l_dest_wp_str_ver_id :=PA_PROJECT_STRUCTURE_UTILS.get_current_working_ver_id(p_dest_proj_id);
3687: --get only version for fin
3688: PA_PROJECT_STRUCTURE_UTILS.Get_Financial_Version(p_dest_proj_id,l_dest_fin_str_ver_id);
3689: END IF;*/
3690:

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

3684: /* IF l_dest_fin_str_ver_id IS NULL AND l_dest_wp_str_ver_id IS NULL THEN
3685: --get current working wp ver
3686: l_dest_wp_str_ver_id :=PA_PROJECT_STRUCTURE_UTILS.get_current_working_ver_id(p_dest_proj_id);
3687: --get only version for fin
3688: PA_PROJECT_STRUCTURE_UTILS.Get_Financial_Version(p_dest_proj_id,l_dest_fin_str_ver_id);
3689: END IF;*/
3690:
3691: IF l_dest_fin_str_ver_id IS NULL THEN --SMukka added if block
3692: --get only version for fin

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

3689: END IF;*/
3690:
3691: IF l_dest_fin_str_ver_id IS NULL THEN --SMukka added if block
3692: --get only version for fin
3693: PA_PROJECT_STRUCTURE_UTILS.Get_Financial_Version(p_dest_proj_id,l_dest_fin_str_ver_id);
3694:
3695: -- Begin fix for Bug # 4426392.
3696:
3697: if (l_dest_fin_str_ver_id = -1) then

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

3705: END IF;
3706: --
3707: IF l_dest_wp_str_ver_id IS NULL THEN --SMukka added if block
3708: --get current working wp ver
3709: l_dest_wp_str_ver_id :=PA_PROJECT_STRUCTURE_UTILS.get_current_working_ver_id(p_dest_proj_id);
3710: END IF;
3711: --
3712: IF (p_debug_mode = 'Y') THEN
3713: pa_debug.debug('Dest WP Str Ver Id => '||l_dest_wp_str_ver_id);

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

4160: -- Begin Bug # 4573015.
4161: (
4162: l_dest_fin_str_ver_id is not null
4163: or
4164: pa_project_structure_utils.check_struc_ver_published(p_dest_proj_id, l_dest_wp_str_ver_id) = 'Y'
4165: )
4166: -- End Bug # 4573015.
4167: )
4168: or

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

4178: l_dest_wp_str_ver_id IS NOT NULL
4179: and
4180: l_src_str_wp_enable_fl = 'Y'
4181: and
4182: pa_project_structure_utils.check_struc_ver_published(p_dest_proj_id, l_dest_wp_str_ver_id) = 'Y'
4183: )
4184: or
4185: (
4186: l_dest_fin_str_ver_id IS NOT NULL

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

4188: l_src_task_financial_flag='Y'
4189: and
4190: l_src_str_fin_enable_fl = 'Y'
4191: and
4192: pa_project_structure_utils.check_struc_ver_published(p_dest_proj_id, l_dest_fin_str_ver_id) = 'Y'
4193: )
4194: )
4195: )
4196: -- Begin Bug # 4573015.

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

4199: l_src_str_wp_enable_fl = 'Y'
4200: and
4201: l_src_str_fin_enable_fl = 'N'
4202: and
4203: pa_project_structure_utils.check_struc_ver_published(p_dest_proj_id, l_dest_wp_str_ver_id) = 'Y'
4204: )
4205: or
4206: (
4207: l_src_str_fin_enable_fl = 'Y'

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

4738:
4739: /* bug 4541039
4740: -- Begin fix for Bug # 4385027.
4741:
4742: if pa_project_structure_utils.get_struc_type_for_version(l_src_structure_ver_id, 'WORKPLAN') = 'Y' then
4743:
4744: l_tasks_ver_ids.extend(1);
4745: l_tasks_ver_ids(1) := get_src_task_ver_id_rec.object_id_from1;
4746:

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

4801: --Update dirty only if workplan gets deleted.
4802: -- Added If condition for Bug 8889029
4803: -- If user wants to defer the rollup of programs, we need not set the version to dirty as another message will be displayed to run UPPD.
4804: IF NVL(FND_PROFILE.value('PA_ROLLUP_PROGRAM_AMOUNTS'),'AUTOMATIC') = 'AUTOMATIC' THEN
4805: IF PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(l_src_structure_ver_id, 'WORKPLAN') = 'Y'
4806: THEN
4807: PA_PROJ_TASK_STRUC_PUB.SET_UPDATE_WBS_FLAG
4808: (
4809: p_calling_context => 'SELF_SERVICE'