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_PROGRESS_PVT dependencies on PA_PERCENT_COMPLETES

Line 340: FROM pa_percent_completes

336: CURSOR c_get_dlv_status(c_task_id NUMBER) IS
337: SELECT 'Y' FROM DUAL
338: WHERE EXISTS
339: (SELECT 'xyz'
340: FROM pa_percent_completes
341: WHERE project_id = p_project_id
342: AND task_id = c_task_id
343: AND object_type = 'PA_DELIVERABLES'
344: AND trunc(date_computed)<= trunc(p_as_of_date)

Line 3380: UPDATE pa_percent_completes

3376: END IF;
3377: END IF;
3378: END IF;
3379:
3380: UPDATE pa_percent_completes
3381: SET status_code = l_status_code
3382: , actual_start_date = l_actual_start_date -- Bug 3956299
3383: , actual_finish_date = l_actual_finish_date -- Bug 3956299
3384: WHERE object_id = cur_reverse_tree_rec.proj_element_id

Line 3394: UPDATE pa_percent_completes

3390: AND current_flag = 'N' and published_flag = 'N'
3391: ;
3392:
3393: -- 14-Feb-2005 : Added Patched thru Bug 4180026
3394: UPDATE pa_percent_completes
3395: SET status_code = l_status_code
3396: , actual_start_date = l_actual_start_date -- Bug 3956299
3397: , actual_finish_date = l_actual_finish_date -- Bug 3956299
3398: WHERE object_id = cur_reverse_tree_rec.proj_element_id

Line 3586: FROM pa_percent_completes

3582: l_tsk_create_required(task_index):='Y';
3583: BEGIN
3584: SELECT percent_complete_id
3585: INTO l_percent_complete_id
3586: FROM pa_percent_completes
3587: WHERE project_id = p_project_id
3588: AND object_id = cur_reverse_tree_rec.proj_element_id
3589: AND object_Type = l_rollup_table1(i).object_Type
3590: AND structure_type = p_structure_type

Line 3592: FROM pa_percent_completes

3588: AND object_id = cur_reverse_tree_rec.proj_element_id
3589: AND object_Type = l_rollup_table1(i).object_Type
3590: AND structure_type = p_structure_type
3591: AND date_computed = ( SELECT max(date_computed)
3592: FROM pa_percent_completes
3593: WHERE project_id = p_project_id
3594: AND object_id = cur_reverse_tree_rec.proj_element_id
3595: AND object_Type = l_rollup_table1(i).object_Type
3596: AND structure_type = p_structure_type

Line 4204: from pa_progress_rollup ppr, pa_percent_completes ppc

4200: -- Bug 3764224 : This cursor deals with tasks only, so no need to add join of proj_element_id
4201: CURSOR cur_tree_rollup_dates
4202: IS
4203: select as_of_date, published_flag, ppc.current_flag
4204: from pa_progress_rollup ppr, pa_percent_completes ppc
4205: where ppr.project_id = p_project_id
4206: and ppr.object_id = l_object_id
4207: and ppr.as_of_Date > p_as_of_date
4208: and ppr.project_id = ppc.project_id(+)

Line 6739: FROM pa_percent_completes

6735: CURSOR c_get_dlv_status IS
6736: SELECT 'Y' FROM DUAL
6737: WHERE EXISTS
6738: (SELECT 'xyz'
6739: FROM pa_percent_completes
6740: WHERE project_id = p_project_id
6741: AND task_id = p_task_id
6742: AND object_type = 'PA_DELIVERABLES'
6743: AND trunc(date_computed)<= trunc(p_as_of_date)

Line 8271: UPDATE pa_percent_completes

8267: l_status_code := '125';
8268: END IF;
8269:
8270:
8271: UPDATE pa_percent_completes
8272: SET status_code = l_status_code
8273: WHERE object_id = p_task_id
8274: AND project_id = p_project_id
8275: AND PA_PROGRESS_UTILS.get_system_task_status( status_code ) NOT IN ( 'CANCELLED' )

Line 8398: UPDATE pa_percent_completes

8394: END IF;
8395: END IF;
8396: -- Bug 3956299 End
8397:
8398: UPDATE pa_percent_completes
8399: SET status_code = l_status_code
8400: , actual_start_date = l_actual_start_date -- Bug 3956299
8401: , actual_finish_date = l_actual_finish_date -- Bug 3956299
8402: WHERE object_id = p_task_id

Line 8746: FROM pa_percent_completes

8742: -- get percent_complete_id
8743: BEGIN
8744: SELECT percent_complete_id
8745: INTO l_percent_complete_id
8746: FROM pa_percent_completes
8747: WHERE project_id = p_project_id
8748: AND object_id = p_task_id
8749: AND object_Type = l_rollup_table1(i).object_Type
8750: AND structure_type = 'WORKPLAN'

Line 8752: FROM pa_percent_completes

8748: AND object_id = p_task_id
8749: AND object_Type = l_rollup_table1(i).object_Type
8750: AND structure_type = 'WORKPLAN'
8751: AND date_computed = ( SELECT max(date_computed)
8752: FROM pa_percent_completes
8753: WHERE project_id = p_project_id
8754: AND object_id = p_task_id
8755: AND object_Type = l_rollup_table1(i).object_Type
8756: AND structure_type = 'WORKPLAN'

Line 9230: delete from pa_percent_completes

9226:
9227: --bug 3958686, start
9228:
9229: IF p_action = 'SAVE' THEN
9230: delete from pa_percent_completes
9231: where project_id= p_project_id
9232: and task_id = p_task_id
9233: and object_id = p_resource_list_mem_id
9234: and object_type = 'PA_ASSIGNMENTS'

Line 9252: delete from pa_percent_completes

9248: END IF;
9249:
9250:
9251: IF p_action = 'PUBLISH' THEN
9252: delete from pa_percent_completes
9253: where project_id= p_project_id
9254: and task_id = p_task_id
9255: and object_id = p_resource_list_mem_id
9256: and object_type = 'PA_ASSIGNMENTS'

Line 9262: delete from pa_percent_completes

9258: and date_computed <= p_as_of_date
9259: and structure_type = 'WORKPLAN'
9260: ;
9261:
9262: delete from pa_percent_completes
9263: WHERE project_id = p_project_id
9264: and object_id = p_resource_list_mem_id
9265: and task_id = p_task_id
9266: and trunc(date_computed) = trunc(p_as_of_date)

Line 9304: UPDATE pa_percent_completes

9300: -- Added update code to set current_flag as N otherwise upon publishinh it will give error
9301: -- ORA-00001: unique constraint (PA.PA_BUDGET_LINES_U1) violated in Package PA_FP_MAINTAIN_ACTUAL_PUB Procedure MAINTAIN_ACTUAL_AMT_RA
9302: -- Patched thru Bug 4183307
9303: IF p_action = 'PUBLISH' THEN
9304: UPDATE pa_percent_completes
9305: SET current_flag = 'N'
9306: WHERE project_id = p_project_id
9307: AND object_id = p_resource_list_mem_id
9308: AND task_id = p_task_id

Line 9379: select PA_PERCENT_COMPLETES_S.nextval

9375: END IF;
9376: -- Bug 4490532 End
9377:
9378:
9379: select PA_PERCENT_COMPLETES_S.nextval
9380: into x_percent_complete_id
9381: from dual;
9382:
9383: select PA_PROGRESS_ROLLUP_S.nextval

Line 9387: pa_debug.write(x_Module=>'PA_PROGRESS_PVT.convert_task_prog_to_assgn', x_Msg => 'Before Inserting into pa_percent_completes', x_Log_Level=> 3);

9383: select PA_PROGRESS_ROLLUP_S.nextval
9384: into X_PROGRESS_ROLLUP_ID
9385: from dual;
9386: IF g1_debug_mode = 'Y' THEN
9387: pa_debug.write(x_Module=>'PA_PROGRESS_PVT.convert_task_prog_to_assgn', x_Msg => 'Before Inserting into pa_percent_completes', x_Log_Level=> 3);
9388: END IF;
9389: INSERT INTO pa_percent_completes(
9390: TASK_ID
9391: ,DATE_COMPUTED

Line 9389: INSERT INTO pa_percent_completes(

9385: from dual;
9386: IF g1_debug_mode = 'Y' THEN
9387: pa_debug.write(x_Module=>'PA_PROGRESS_PVT.convert_task_prog_to_assgn', x_Msg => 'Before Inserting into pa_percent_completes', x_Log_Level=> 3);
9388: END IF;
9389: INSERT INTO pa_percent_completes(
9390: TASK_ID
9391: ,DATE_COMPUTED
9392: ,LAST_UPDATE_DATE
9393: ,LAST_UPDATED_BY

Line 9480: FROM pa_percent_completes

9476: ,ATTRIBUTE13
9477: ,ATTRIBUTE14
9478: ,ATTRIBUTE15
9479: ,STRUCTURE_TYPE
9480: FROM pa_percent_completes
9481: WHERE project_id = p_project_id
9482: and object_id = p_task_id
9483: and task_id = p_task_id
9484: and structure_type = 'WORKPLAN'

Line 9493: pa_debug.write(x_Module=>'PA_PROGRESS_PVT.convert_task_prog_to_assgn', x_Msg => 'Done Inserting into pa_percent_completes', x_Log_Level=> 3);

9489: or (p_action = 'PUBLISH' and published_flag = 'Y' and current_flag = 'Y'))
9490: ;
9491:
9492: IF g1_debug_mode = 'Y' THEN
9493: pa_debug.write(x_Module=>'PA_PROGRESS_PVT.convert_task_prog_to_assgn', x_Msg => 'Done Inserting into pa_percent_completes', x_Log_Level=> 3);
9494: END IF;
9495: -- Bug 4490532 : Subtracting the subproject amounts if available.
9496: -- Bug 4661350 : Using newly introduced local variable to store subprojects sum value
9497: INSERT INTO pa_progress_rollup(

Line 10511: --- update pa_percent_completes table with new object_version_ids

10507: l_new_element_version_id_tab,
10508: l_proj_element_id_tab;
10509: close obj_version_id;
10510:
10511: --- update pa_percent_completes table with new object_version_ids
10512: IF l_new_element_version_id_tab.count > 0 THEN
10513: --- update pa_percent_completes table with new object_version_ids
10514: Forall i in l_new_element_version_id_tab.first..l_new_element_version_id_tab.last
10515: update pa_percent_completes ppc

Line 10513: --- update pa_percent_completes table with new object_version_ids

10509: close obj_version_id;
10510:
10511: --- update pa_percent_completes table with new object_version_ids
10512: IF l_new_element_version_id_tab.count > 0 THEN
10513: --- update pa_percent_completes table with new object_version_ids
10514: Forall i in l_new_element_version_id_tab.first..l_new_element_version_id_tab.last
10515: update pa_percent_completes ppc
10516: set object_version_id = l_new_element_version_id_tab(i)
10517: where project_id = p_project_id

Line 10515: update pa_percent_completes ppc

10511: --- update pa_percent_completes table with new object_version_ids
10512: IF l_new_element_version_id_tab.count > 0 THEN
10513: --- update pa_percent_completes table with new object_version_ids
10514: Forall i in l_new_element_version_id_tab.first..l_new_element_version_id_tab.last
10515: update pa_percent_completes ppc
10516: set object_version_id = l_new_element_version_id_tab(i)
10517: where project_id = p_project_id
10518: and task_id = l_proj_element_id_tab(i)
10519: and structure_type = 'WORKPLAN'

Line 10851: FROM pa_percent_completes

10847: CURSOR c_get_dlv_status(c_task_id NUMBER) IS
10848: SELECT 'Y' FROM DUAL
10849: WHERE EXISTS
10850: (SELECT 'xyz'
10851: FROM pa_percent_completes
10852: WHERE project_id = p_project_id
10853: AND task_id = c_task_id
10854: AND object_type = 'PA_DELIVERABLES'
10855: AND trunc(date_computed)<= trunc(p_as_of_date)

Line 13465: UPDATE pa_percent_completes

13461: END IF;
13462: END IF;
13463: END IF;
13464:
13465: UPDATE pa_percent_completes
13466: SET status_code = l_status_code
13467: , actual_start_date = l_actual_start_date -- Bug 3956299
13468: , actual_finish_date = l_actual_finish_date -- Bug 3956299
13469: WHERE object_id = cur_reverse_tree_rec.proj_element_id

Line 13478: UPDATE pa_percent_completes

13474: AND structure_type = p_structure_type -- FPM Dev CR 3
13475: AND current_flag = 'N' and published_flag = 'N';
13476:
13477: -- 14-Feb-2005 : Added Patched thru Bug 4180026
13478: UPDATE pa_percent_completes
13479: SET status_code = l_status_code
13480: , actual_start_date = l_actual_start_date -- Bug 3956299
13481: , actual_finish_date = l_actual_finish_date -- Bug 3956299
13482: WHERE object_id = cur_reverse_tree_rec.proj_element_id

Line 13664: FROM pa_percent_completes

13660: l_tsk_create_required(task_index):='Y';
13661: BEGIN
13662: SELECT percent_complete_id
13663: INTO l_percent_complete_id
13664: FROM pa_percent_completes
13665: WHERE project_id = p_project_id
13666: AND object_id = cur_reverse_tree_rec.proj_element_id
13667: AND object_Type = l_rollup_table1(i).object_Type
13668: AND structure_type = p_structure_type

Line 13670: FROM pa_percent_completes

13666: AND object_id = cur_reverse_tree_rec.proj_element_id
13667: AND object_Type = l_rollup_table1(i).object_Type
13668: AND structure_type = p_structure_type
13669: AND date_computed = ( SELECT max(date_computed)
13670: FROM pa_percent_completes
13671: WHERE project_id = p_project_id
13672: AND object_id = cur_reverse_tree_rec.proj_element_id
13673: AND object_Type = l_rollup_table1(i).object_Type
13674: AND structure_type = p_structure_type

Line 14411: FROM pa_percent_completes

14407: CURSOR c_get_dlv_status(c_task_id NUMBER) IS
14408: SELECT 'Y' FROM DUAL
14409: WHERE EXISTS
14410: (SELECT 'xyz'
14411: FROM pa_percent_completes
14412: WHERE project_id = p_project_id
14413: AND task_id = c_task_id
14414: AND object_type = 'PA_DELIVERABLES'
14415: AND trunc(date_computed)<= trunc(p_as_of_date)

Line 17082: UPDATE pa_percent_completes

17078: END IF;
17079: END IF;
17080: END IF;
17081:
17082: UPDATE pa_percent_completes
17083: SET status_code = l_status_code
17084: , actual_start_date = l_actual_start_date -- Bug 3956299
17085: , actual_finish_date = l_actual_finish_date -- Bug 3956299
17086: /* -- sridhar_rollup

Line 17099: UPDATE pa_percent_completes

17095: AND structure_type = p_structure_type -- FPM Dev CR 3
17096: AND current_flag = 'N' and published_flag = 'N';
17097:
17098: -- 14-Feb-2005 : Added Patched thru Bug 4180026
17099: UPDATE pa_percent_completes
17100: SET status_code = l_status_code
17101: , actual_start_date = l_actual_start_date -- Bug 3956299
17102: , actual_finish_date = l_actual_finish_date -- Bug 3956299
17103: WHERE object_id = l_defer_arr_task_id(l_rollup_table1(i).object_id) -- sridhar_rollup

Line 17285: FROM pa_percent_completes

17281: l_tsk_create_required(task_index):='Y';
17282: BEGIN
17283: SELECT percent_complete_id
17284: INTO l_percent_complete_id
17285: FROM pa_percent_completes
17286: WHERE project_id = p_project_id
17287: AND object_id = l_defer_arr_task_id(l_rollup_table1(i).object_id) -- sridhar_rollup
17288: AND object_Type = l_rollup_table1(i).object_Type
17289: AND structure_type = p_structure_type

Line 17291: FROM pa_percent_completes

17287: AND object_id = l_defer_arr_task_id(l_rollup_table1(i).object_id) -- sridhar_rollup
17288: AND object_Type = l_rollup_table1(i).object_Type
17289: AND structure_type = p_structure_type
17290: AND date_computed = ( SELECT max(date_computed)
17291: FROM pa_percent_completes
17292: WHERE project_id = p_project_id
17293: AND object_id = l_defer_arr_task_id(l_rollup_table1(i).object_id) -- sridhar_rollup
17294: AND object_Type = l_rollup_table1(i).object_Type
17295: AND structure_type = p_structure_type