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 3514: IF PA_PROJ_ELEMENTS_UTILS.check_sharedstruct_deliv(p_structure_version_id) = 'Y' THEN

3510: x_msg_data := 'PA_PS_STRUC_VER_NAM_UNIQUE';
3511: RAISE FND_API.G_EXC_ERROR;
3512: END IF;
3513: --Bug No 3450684 Smukka Checking for deliverable type
3514: IF PA_PROJ_ELEMENTS_UTILS.check_sharedstruct_deliv(p_structure_version_id) = 'Y' THEN
3515: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
3516: p_msg_name => 'PA_PS_CHK_DEL_FAIL_PUB_STR');
3517: RAISE FND_API.G_EXC_ERROR;
3518: END IF;

Line 3866: --Call PA_PROJ_ELEMENTS_UTILS.Check_Del_all_task_Ver_Ok

3862: EXIT WHEN get_task_versions_csr%NOTFOUND;
3863:
3864: --hsiu added for task version status
3865: --Check if this task can be deleted.
3866: --Call PA_PROJ_ELEMENTS_UTILS.Check_Del_all_task_Ver_Ok
3867: --If ok to be deleted, move on to the next task and don't add this task
3868: -- (goto l_endofloop);
3869: --otherwise add this task and set status to 'CANCELLED'
3870: l_create_task_ver_flag := 'Y';

Line 3885: -- PA_PROJ_ELEMENTS_UTILS.Check_create_subtask_ok(

3881: and object_type_to = 'PA_TASKS';
3882:
3883: --If it is financial task, check if this task should be created
3884:
3885: -- PA_PROJ_ELEMENTS_UTILS.Check_create_subtask_ok(
3886: -- p_parent_task_ver_id => l_parent_ver_id
3887: -- ,x_return_status => l_return_status
3888: -- ,x_error_message_code => l_error_message_code);
3889:

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

3888: -- ,x_error_message_code => l_error_message_code);
3889:
3890: --bug: 2805602
3891: --hsiu: commented because this has been done in check_txn_on_summary_tasks
3892: -- If (PA_PROJ_ELEMENTS_UTILS.CHECK_IS_FINANCIAL_TASK(l_parent_id) = 'Y') THEN
3893: -- PA_TASK_UTILS.CHECK_CREATE_SUBTASK_OK(x_task_id => l_parent_id,
3894: -- x_err_code => l_err_code,
3895: -- x_err_stack => l_err_stack,
3896: -- x_err_stage => l_err_stage

Line 3909: PA_PROJ_ELEMENTS_UTILS.Check_Del_all_task_Ver_Ok(

3905: -- END IF;
3906:
3907: IF (l_task_versions_rec.TASK_UNPUB_VER_STATUS_CODE = 'TO_BE_DELETED') THEN
3908:
3909: PA_PROJ_ELEMENTS_UTILS.Check_Del_all_task_Ver_Ok(
3910: p_project_id => l_task_versions_rec.project_id
3911: ,p_task_version_id => l_task_versions_rec.element_version_id
3912: ,p_parent_structure_ver_id=> l_task_versions_rec.parent_structure_version_id
3913: ,x_return_status => l_return_status

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

5407: --hsiu: prorate tasks for tasks that have to be deleted peer tasks
5408: l_parent_ver_id := l_parent_tbl.FIRST;
5409: FOR i IN 1..l_parent_tbl.COUNT LOOP
5410: --if it has child then prorate
5411: -- IF (PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(l_parent_ver_id) = 'N') THEN
5412: OPEN is_summary_elem(l_parent_ver_id);
5413: FETCH is_summary_elem INTO l_dummy;
5414: IF is_summary_elem%FOUND THEN
5415: PA_TASK_PVT1.RECALC_TASKS_WEIGHTING(

Line 9888: PA_PROJ_ELEMENTS_UTILS.check_del_all_task_ver_ok(

9884: LOOP
9885: FETCH get_top_tasks into l_task_ver_id;
9886: EXIT WHEN get_top_tasks%NOTFOUND;
9887:
9888: PA_PROJ_ELEMENTS_UTILS.check_del_all_task_ver_ok(
9889: p_project_id => p_project_id
9890: ,p_task_version_id => l_task_ver_id
9891: ,p_parent_structure_ver_id => l_del_struc_ver_id
9892: ,x_return_status => l_return_status

Line 10048: PA_PROJ_ELEMENTS_UTILS.check_del_all_task_ver_ok(

10044: LOOP
10045: FETCH get_top_tasks into l_task_ver_id;
10046: EXIT WHEN get_top_tasks%NOTFOUND;
10047:
10048: PA_PROJ_ELEMENTS_UTILS.check_del_all_task_ver_ok(
10049: p_project_id => p_project_id
10050: ,p_task_version_id => l_task_ver_id
10051: ,p_parent_structure_ver_id => l_del_struc_ver_id
10052: ,x_return_status => l_return_status

Line 10158: PA_PROJ_ELEMENTS_UTILS.check_del_all_task_ver_ok(

10154: LOOP
10155: FETCH get_top_tasks into l_task_ver_id;
10156: EXIT WHEN get_top_tasks%NOTFOUND;
10157:
10158: PA_PROJ_ELEMENTS_UTILS.check_del_all_task_ver_ok(
10159: p_project_id => p_project_id
10160: ,p_task_version_id => l_task_ver_id
10161: ,p_parent_structure_ver_id => l_del_struc_ver_id
10162: ,x_return_status => l_return_status

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

10332:
10333: --If it is lowest task, get dates
10334: --hsiu: commented for performance
10335: -- IF (l_object_type = 'PA_TASKS' AND
10336: -- PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(l_element_version_id) = 'Y') THEN
10337: -- OPEN sel_task_dates(l_task_id);
10338: -- FETCH sel_task_dates into l_start_date, l_completion_date;
10339: -- CLOSE sel_task_dates;
10340:

Line 10399: 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))),

10395: SYSDATE,
10396: FND_GLOBAL.USER_ID,
10397: SYSDATE,
10398: FND_GLOBAL.USER_ID,
10399: 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))),
10400: 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))),
10401: 'N',
10402: 'N',
10403: l_calendar_id,

Line 10400: 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))),

10396: FND_GLOBAL.USER_ID,
10397: SYSDATE,
10398: FND_GLOBAL.USER_ID,
10399: 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))),
10400: 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))),
10401: 'N',
10402: 'N',
10403: l_calendar_id,
10404: 0,

Line 10580: PA_PROJ_ELEMENTS_UTILS.check_del_all_task_ver_ok(

10576: LOOP
10577: FETCH get_top_tasks into l_task_ver_id;
10578: EXIT WHEN get_top_tasks%NOTFOUND;
10579:
10580: PA_PROJ_ELEMENTS_UTILS.check_del_all_task_ver_ok(
10581: p_project_id => p_project_id
10582: ,p_task_version_id => l_task_ver_id
10583: ,p_parent_structure_ver_id => l_del_struc_ver_id
10584: ,x_return_status => l_return_status

Line 15105: 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))),

15101: SYSDATE,
15102: FND_GLOBAL.USER_ID,
15103: SYSDATE,
15104: FND_GLOBAL.USER_ID,
15105: 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))),
15106: 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))),
15107: 'N',
15108: 'N',
15109: NULL,

Line 15106: 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))),

15102: FND_GLOBAL.USER_ID,
15103: SYSDATE,
15104: FND_GLOBAL.USER_ID,
15105: 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))),
15106: 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))),
15107: 'N',
15108: 'N',
15109: NULL,
15110: 0,

Line 15407: PA_PROJ_ELEMENTS_UTILS.check_del_all_task_ver_ok(

15403: LOOP
15404: FETCH get_top_tasks into l_task_ver_id;
15405: EXIT WHEN get_top_tasks%NOTFOUND;
15406:
15407: PA_PROJ_ELEMENTS_UTILS.check_del_all_task_ver_ok(
15408: p_project_id => p_project_id
15409: ,p_task_version_id => l_task_ver_id
15410: ,p_parent_structure_ver_id => l_del_struc_ver_id
15411: ,x_return_status => l_return_status

Line 15984: PA_PROJ_ELEMENTS_UTILS.check_del_all_task_ver_ok(

15980: LOOP
15981: FETCH get_top_tasks into l_task_ver_id;
15982: EXIT WHEN get_top_tasks%NOTFOUND;
15983:
15984: PA_PROJ_ELEMENTS_UTILS.check_del_all_task_ver_ok(
15985: p_project_id => p_project_id
15986: ,p_task_version_id => l_task_ver_id
15987: ,p_parent_structure_ver_id => l_del_struc_ver_id
15988: ,x_return_status => l_return_status

Line 16519: PA_PROJ_ELEMENTS_UTILS.check_del_all_task_ver_ok(

16515: LOOP
16516: FETCH get_top_tasks into l_task_ver_id;
16517: EXIT WHEN get_top_tasks%NOTFOUND;
16518:
16519: PA_PROJ_ELEMENTS_UTILS.check_del_all_task_ver_ok(
16520: p_project_id => p_project_id
16521: ,p_task_version_id => l_task_ver_id
16522: ,p_parent_structure_ver_id => l_del_struc_ver_id
16523: ,x_return_status => l_return_status

Line 16854: PA_PROJ_ELEMENTS_UTILS.check_del_all_task_ver_ok(

16850: LOOP
16851: FETCH get_top_tasks into l_task_ver_id;
16852: EXIT WHEN get_top_tasks%NOTFOUND;
16853:
16854: PA_PROJ_ELEMENTS_UTILS.check_del_all_task_ver_ok(
16855: p_project_id => p_project_id
16856: ,p_task_version_id => l_task_ver_id
16857: ,p_parent_structure_ver_id => l_del_struc_ver_id
16858: ,x_return_status => l_return_status

Line 16948: PA_PROJ_ELEMENTS_UTILS.check_del_all_task_ver_ok(

16944: LOOP
16945: FETCH get_top_tasks into l_task_ver_id;
16946: EXIT WHEN get_top_tasks%NOTFOUND;
16947:
16948: PA_PROJ_ELEMENTS_UTILS.check_del_all_task_ver_ok(
16949: p_project_id => p_project_id
16950: ,p_task_version_id => l_task_ver_id
16951: ,p_parent_structure_ver_id => l_del_struc_ver_id
16952: ,x_return_status => l_return_status

Line 17094: 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))),

17090: SYSDATE,
17091: FND_GLOBAL.USER_ID,
17092: SYSDATE,
17093: FND_GLOBAL.USER_ID,
17094: 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))),
17095: 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))),
17096: 'N',
17097: 'N',
17098: NULL,

Line 17095: 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))),

17091: FND_GLOBAL.USER_ID,
17092: SYSDATE,
17093: FND_GLOBAL.USER_ID,
17094: 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))),
17095: 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))),
17096: 'N',
17097: 'N',
17098: NULL,
17099: 0,

Line 17248: PA_PROJ_ELEMENTS_UTILS.check_del_all_task_ver_ok(

17244: LOOP
17245: FETCH get_top_tasks into l_task_ver_id;
17246: EXIT WHEN get_top_tasks%NOTFOUND;
17247:
17248: PA_PROJ_ELEMENTS_UTILS.check_del_all_task_ver_ok(
17249: p_project_id => p_project_id
17250: ,p_task_version_id => l_task_ver_id
17251: ,p_parent_structure_ver_id => l_del_struc_ver_id
17252: ,x_return_status => l_return_status

Line 17340: PA_PROJ_ELEMENTS_UTILS.check_del_all_task_ver_ok(

17336: LOOP
17337: FETCH get_top_tasks into l_task_ver_id;
17338: EXIT WHEN get_top_tasks%NOTFOUND;
17339:
17340: PA_PROJ_ELEMENTS_UTILS.check_del_all_task_ver_ok(
17341: p_project_id => p_project_id
17342: ,p_task_version_id => l_task_ver_id
17343: ,p_parent_structure_ver_id => l_del_struc_ver_id
17344: ,x_return_status => l_return_status

Line 17486: 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))),

17482: SYSDATE,
17483: FND_GLOBAL.USER_ID,
17484: SYSDATE,
17485: FND_GLOBAL.USER_ID,
17486: 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))),
17487: 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))),
17488: 'N',
17489: 'N',
17490: NULL,

Line 17487: 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))),

17483: FND_GLOBAL.USER_ID,
17484: SYSDATE,
17485: FND_GLOBAL.USER_ID,
17486: 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))),
17487: 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))),
17488: 'N',
17489: 'N',
17490: NULL,
17491: 0,