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_PVT1 dependencies on PA_PROJ_ELEMENTS_UTILS

Line 3574: IF PA_PROJ_ELEMENTS_UTILS.check_sharedstruct_deliv(p_structure_version_id) = 'Y' THEN

3570: x_msg_data := 'PA_PS_STRUC_VER_NAM_UNIQUE';
3571: RAISE FND_API.G_EXC_ERROR;
3572: END IF;
3573: --Bug No 3450684 Smukka Checking for deliverable type
3574: IF PA_PROJ_ELEMENTS_UTILS.check_sharedstruct_deliv(p_structure_version_id) = 'Y' THEN
3575: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
3576: p_msg_name => 'PA_PS_CHK_DEL_FAIL_PUB_STR');
3577: RAISE FND_API.G_EXC_ERROR;
3578: END IF;

Line 3926: --Call PA_PROJ_ELEMENTS_UTILS.Check_Del_all_task_Ver_Ok

3922: EXIT WHEN get_task_versions_csr%NOTFOUND;
3923:
3924: --hsiu added for task version status
3925: --Check if this task can be deleted.
3926: --Call PA_PROJ_ELEMENTS_UTILS.Check_Del_all_task_Ver_Ok
3927: --If ok to be deleted, move on to the next task and don't add this task
3928: -- (goto l_endofloop);
3929: --otherwise add this task and set status to 'CANCELLED'
3930: l_create_task_ver_flag := 'Y';

Line 3945: -- PA_PROJ_ELEMENTS_UTILS.Check_create_subtask_ok(

3941: and object_type_to = 'PA_TASKS';
3942:
3943: --If it is financial task, check if this task should be created
3944:
3945: -- PA_PROJ_ELEMENTS_UTILS.Check_create_subtask_ok(
3946: -- p_parent_task_ver_id => l_parent_ver_id
3947: -- ,x_return_status => l_return_status
3948: -- ,x_error_message_code => l_error_message_code);
3949:

Line 3952: -- If (PA_PROJ_ELEMENTS_UTILS.CHECK_IS_FINANCIAL_TASK(l_parent_id) = 'Y') THEN

3948: -- ,x_error_message_code => l_error_message_code);
3949:
3950: --bug: 2805602
3951: --hsiu: commented because this has been done in check_txn_on_summary_tasks
3952: -- If (PA_PROJ_ELEMENTS_UTILS.CHECK_IS_FINANCIAL_TASK(l_parent_id) = 'Y') THEN
3953: -- PA_TASK_UTILS.CHECK_CREATE_SUBTASK_OK(x_task_id => l_parent_id,
3954: -- x_err_code => l_err_code,
3955: -- x_err_stack => l_err_stack,
3956: -- x_err_stage => l_err_stage

Line 3969: PA_PROJ_ELEMENTS_UTILS.Check_Del_all_task_Ver_Ok(

3965: -- END IF;
3966:
3967: IF (l_task_versions_rec.TASK_UNPUB_VER_STATUS_CODE = 'TO_BE_DELETED') THEN
3968:
3969: PA_PROJ_ELEMENTS_UTILS.Check_Del_all_task_Ver_Ok(
3970: p_project_id => l_task_versions_rec.project_id
3971: ,p_task_version_id => l_task_versions_rec.element_version_id
3972: ,p_parent_structure_ver_id=> l_task_versions_rec.parent_structure_version_id
3973: ,x_return_status => l_return_status

Line 5471: -- IF (PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(l_parent_ver_id) = 'N') THEN

5467: --hsiu: prorate tasks for tasks that have to be deleted peer tasks
5468: l_parent_ver_id := l_parent_tbl.FIRST;
5469: FOR i IN 1..l_parent_tbl.COUNT LOOP
5470: --if it has child then prorate
5471: -- IF (PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(l_parent_ver_id) = 'N') THEN
5472: OPEN is_summary_elem(l_parent_ver_id);
5473: FETCH is_summary_elem INTO l_dummy;
5474: IF is_summary_elem%FOUND THEN
5475: PA_TASK_PVT1.RECALC_TASKS_WEIGHTING(

Line 10260: PA_PROJ_ELEMENTS_UTILS.check_del_all_task_ver_ok(

10256: LOOP
10257: FETCH get_top_tasks into l_task_ver_id;
10258: EXIT WHEN get_top_tasks%NOTFOUND;
10259:
10260: PA_PROJ_ELEMENTS_UTILS.check_del_all_task_ver_ok(
10261: p_project_id => p_project_id
10262: ,p_task_version_id => l_task_ver_id
10263: ,p_parent_structure_ver_id => l_del_struc_ver_id
10264: ,x_return_status => l_return_status

Line 10420: PA_PROJ_ELEMENTS_UTILS.check_del_all_task_ver_ok(

10416: LOOP
10417: FETCH get_top_tasks into l_task_ver_id;
10418: EXIT WHEN get_top_tasks%NOTFOUND;
10419:
10420: PA_PROJ_ELEMENTS_UTILS.check_del_all_task_ver_ok(
10421: p_project_id => p_project_id
10422: ,p_task_version_id => l_task_ver_id
10423: ,p_parent_structure_ver_id => l_del_struc_ver_id
10424: ,x_return_status => l_return_status

Line 10530: PA_PROJ_ELEMENTS_UTILS.check_del_all_task_ver_ok(

10526: LOOP
10527: FETCH get_top_tasks into l_task_ver_id;
10528: EXIT WHEN get_top_tasks%NOTFOUND;
10529:
10530: PA_PROJ_ELEMENTS_UTILS.check_del_all_task_ver_ok(
10531: p_project_id => p_project_id
10532: ,p_task_version_id => l_task_ver_id
10533: ,p_parent_structure_ver_id => l_del_struc_ver_id
10534: ,x_return_status => l_return_status

Line 10708: -- PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(l_element_version_id) = 'Y') THEN

10704:
10705: --If it is lowest task, get dates
10706: --hsiu: commented for performance
10707: -- IF (l_object_type = 'PA_TASKS' AND
10708: -- PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(l_element_version_id) = 'Y') THEN
10709: -- OPEN sel_task_dates(l_task_id);
10710: -- FETCH sel_task_dates into l_start_date, l_completion_date;
10711: -- CLOSE sel_task_dates;
10712:

Line 10771: DECODE(PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(PPEV.element_version_id), 'N', trunc(SYSDATE), 'Y', decode(PT.COMPLETION_DATE, NULL, trunc(l_target_start_date), trunc(PT.START_DATE))),

10767: SYSDATE,
10768: FND_GLOBAL.USER_ID,
10769: SYSDATE,
10770: FND_GLOBAL.USER_ID,
10771: DECODE(PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(PPEV.element_version_id), 'N', trunc(SYSDATE), 'Y', decode(PT.COMPLETION_DATE, NULL, trunc(l_target_start_date), trunc(PT.START_DATE))),
10772: DECODE(PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(PPEV.element_version_id), 'N', trunc(SYSDATE), 'Y', NVL(trunc(PT.COMPLETION_DATE), trunc(l_target_finish_date))),
10773: 'N',
10774: 'N',
10775: l_calendar_id,

Line 10772: DECODE(PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(PPEV.element_version_id), 'N', trunc(SYSDATE), 'Y', NVL(trunc(PT.COMPLETION_DATE), trunc(l_target_finish_date))),

10768: FND_GLOBAL.USER_ID,
10769: SYSDATE,
10770: FND_GLOBAL.USER_ID,
10771: DECODE(PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(PPEV.element_version_id), 'N', trunc(SYSDATE), 'Y', decode(PT.COMPLETION_DATE, NULL, trunc(l_target_start_date), trunc(PT.START_DATE))),
10772: DECODE(PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(PPEV.element_version_id), 'N', trunc(SYSDATE), 'Y', NVL(trunc(PT.COMPLETION_DATE), trunc(l_target_finish_date))),
10773: 'N',
10774: 'N',
10775: l_calendar_id,
10776: 0,

Line 10952: PA_PROJ_ELEMENTS_UTILS.check_del_all_task_ver_ok(

10948: LOOP
10949: FETCH get_top_tasks into l_task_ver_id;
10950: EXIT WHEN get_top_tasks%NOTFOUND;
10951:
10952: PA_PROJ_ELEMENTS_UTILS.check_del_all_task_ver_ok(
10953: p_project_id => p_project_id
10954: ,p_task_version_id => l_task_ver_id
10955: ,p_parent_structure_ver_id => l_del_struc_ver_id
10956: ,x_return_status => l_return_status

Line 15481: DECODE(PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(PPEV.element_version_id), 'N', trunc(SYSDATE), 'Y', NVL(trunc(PT.START_DATE), trunc(l_proj_start_date))),

15477: SYSDATE,
15478: FND_GLOBAL.USER_ID,
15479: SYSDATE,
15480: FND_GLOBAL.USER_ID,
15481: DECODE(PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(PPEV.element_version_id), 'N', trunc(SYSDATE), 'Y', NVL(trunc(PT.START_DATE), trunc(l_proj_start_date))),
15482: DECODE(PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(PPEV.element_version_id), 'N', trunc(SYSDATE), 'Y', NVL(trunc(PT.COMPLETION_DATE), trunc(l_proj_completion_date))),
15483: 'N',
15484: 'N',
15485: NULL,

Line 15482: DECODE(PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(PPEV.element_version_id), 'N', trunc(SYSDATE), 'Y', NVL(trunc(PT.COMPLETION_DATE), trunc(l_proj_completion_date))),

15478: FND_GLOBAL.USER_ID,
15479: SYSDATE,
15480: FND_GLOBAL.USER_ID,
15481: DECODE(PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(PPEV.element_version_id), 'N', trunc(SYSDATE), 'Y', NVL(trunc(PT.START_DATE), trunc(l_proj_start_date))),
15482: DECODE(PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(PPEV.element_version_id), 'N', trunc(SYSDATE), 'Y', NVL(trunc(PT.COMPLETION_DATE), trunc(l_proj_completion_date))),
15483: 'N',
15484: 'N',
15485: NULL,
15486: 0,

Line 15783: PA_PROJ_ELEMENTS_UTILS.check_del_all_task_ver_ok(

15779: LOOP
15780: FETCH get_top_tasks into l_task_ver_id;
15781: EXIT WHEN get_top_tasks%NOTFOUND;
15782:
15783: PA_PROJ_ELEMENTS_UTILS.check_del_all_task_ver_ok(
15784: p_project_id => p_project_id
15785: ,p_task_version_id => l_task_ver_id
15786: ,p_parent_structure_ver_id => l_del_struc_ver_id
15787: ,x_return_status => l_return_status

Line 16360: PA_PROJ_ELEMENTS_UTILS.check_del_all_task_ver_ok(

16356: LOOP
16357: FETCH get_top_tasks into l_task_ver_id;
16358: EXIT WHEN get_top_tasks%NOTFOUND;
16359:
16360: PA_PROJ_ELEMENTS_UTILS.check_del_all_task_ver_ok(
16361: p_project_id => p_project_id
16362: ,p_task_version_id => l_task_ver_id
16363: ,p_parent_structure_ver_id => l_del_struc_ver_id
16364: ,x_return_status => l_return_status

Line 16895: PA_PROJ_ELEMENTS_UTILS.check_del_all_task_ver_ok(

16891: LOOP
16892: FETCH get_top_tasks into l_task_ver_id;
16893: EXIT WHEN get_top_tasks%NOTFOUND;
16894:
16895: PA_PROJ_ELEMENTS_UTILS.check_del_all_task_ver_ok(
16896: p_project_id => p_project_id
16897: ,p_task_version_id => l_task_ver_id
16898: ,p_parent_structure_ver_id => l_del_struc_ver_id
16899: ,x_return_status => l_return_status

Line 17230: PA_PROJ_ELEMENTS_UTILS.check_del_all_task_ver_ok(

17226: LOOP
17227: FETCH get_top_tasks into l_task_ver_id;
17228: EXIT WHEN get_top_tasks%NOTFOUND;
17229:
17230: PA_PROJ_ELEMENTS_UTILS.check_del_all_task_ver_ok(
17231: p_project_id => p_project_id
17232: ,p_task_version_id => l_task_ver_id
17233: ,p_parent_structure_ver_id => l_del_struc_ver_id
17234: ,x_return_status => l_return_status

Line 17324: PA_PROJ_ELEMENTS_UTILS.check_del_all_task_ver_ok(

17320: LOOP
17321: FETCH get_top_tasks into l_task_ver_id;
17322: EXIT WHEN get_top_tasks%NOTFOUND;
17323:
17324: PA_PROJ_ELEMENTS_UTILS.check_del_all_task_ver_ok(
17325: p_project_id => p_project_id
17326: ,p_task_version_id => l_task_ver_id
17327: ,p_parent_structure_ver_id => l_del_struc_ver_id
17328: ,x_return_status => l_return_status

Line 17470: DECODE(PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(PPEV.element_version_id), 'N', trunc(SYSDATE), 'Y', NVL(trunc(PT.START_DATE), trunc(l_proj_start_date))),

17466: SYSDATE,
17467: FND_GLOBAL.USER_ID,
17468: SYSDATE,
17469: FND_GLOBAL.USER_ID,
17470: DECODE(PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(PPEV.element_version_id), 'N', trunc(SYSDATE), 'Y', NVL(trunc(PT.START_DATE), trunc(l_proj_start_date))),
17471: DECODE(PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(PPEV.element_version_id), 'N', trunc(SYSDATE), 'Y', NVL(trunc(PT.COMPLETION_DATE), trunc(l_proj_completion_date))),
17472: 'N',
17473: 'N',
17474: NULL,

Line 17471: DECODE(PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(PPEV.element_version_id), 'N', trunc(SYSDATE), 'Y', NVL(trunc(PT.COMPLETION_DATE), trunc(l_proj_completion_date))),

17467: FND_GLOBAL.USER_ID,
17468: SYSDATE,
17469: FND_GLOBAL.USER_ID,
17470: DECODE(PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(PPEV.element_version_id), 'N', trunc(SYSDATE), 'Y', NVL(trunc(PT.START_DATE), trunc(l_proj_start_date))),
17471: DECODE(PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(PPEV.element_version_id), 'N', trunc(SYSDATE), 'Y', NVL(trunc(PT.COMPLETION_DATE), trunc(l_proj_completion_date))),
17472: 'N',
17473: 'N',
17474: NULL,
17475: 0,

Line 17624: PA_PROJ_ELEMENTS_UTILS.check_del_all_task_ver_ok(

17620: LOOP
17621: FETCH get_top_tasks into l_task_ver_id;
17622: EXIT WHEN get_top_tasks%NOTFOUND;
17623:
17624: PA_PROJ_ELEMENTS_UTILS.check_del_all_task_ver_ok(
17625: p_project_id => p_project_id
17626: ,p_task_version_id => l_task_ver_id
17627: ,p_parent_structure_ver_id => l_del_struc_ver_id
17628: ,x_return_status => l_return_status

Line 17716: PA_PROJ_ELEMENTS_UTILS.check_del_all_task_ver_ok(

17712: LOOP
17713: FETCH get_top_tasks into l_task_ver_id;
17714: EXIT WHEN get_top_tasks%NOTFOUND;
17715:
17716: PA_PROJ_ELEMENTS_UTILS.check_del_all_task_ver_ok(
17717: p_project_id => p_project_id
17718: ,p_task_version_id => l_task_ver_id
17719: ,p_parent_structure_ver_id => l_del_struc_ver_id
17720: ,x_return_status => l_return_status

Line 17862: DECODE(PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(PPEV.element_version_id), 'N', trunc(SYSDATE), 'Y', NVL(trunc(PT.START_DATE), trunc(l_proj_start_date))),

17858: SYSDATE,
17859: FND_GLOBAL.USER_ID,
17860: SYSDATE,
17861: FND_GLOBAL.USER_ID,
17862: DECODE(PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(PPEV.element_version_id), 'N', trunc(SYSDATE), 'Y', NVL(trunc(PT.START_DATE), trunc(l_proj_start_date))),
17863: DECODE(PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(PPEV.element_version_id), 'N', trunc(SYSDATE), 'Y', NVL(trunc(PT.COMPLETION_DATE), trunc(l_proj_completion_date))),
17864: 'N',
17865: 'N',
17866: NULL,

Line 17863: DECODE(PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(PPEV.element_version_id), 'N', trunc(SYSDATE), 'Y', NVL(trunc(PT.COMPLETION_DATE), trunc(l_proj_completion_date))),

17859: FND_GLOBAL.USER_ID,
17860: SYSDATE,
17861: FND_GLOBAL.USER_ID,
17862: DECODE(PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(PPEV.element_version_id), 'N', trunc(SYSDATE), 'Y', NVL(trunc(PT.START_DATE), trunc(l_proj_start_date))),
17863: DECODE(PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(PPEV.element_version_id), 'N', trunc(SYSDATE), 'Y', NVL(trunc(PT.COMPLETION_DATE), trunc(l_proj_completion_date))),
17864: 'N',
17865: 'N',
17866: NULL,
17867: 0,