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

Line 466: , pa_percent_completes ppc

462: asgn.assignment_end_date scheduled_finish_date,
463: ppc.progress_comment,
464: ppc.description progress_overview
465: from pa_task_asgmts_v asgn
466: , pa_percent_completes ppc
467: , pa_progress_rollup ppr
468: where
469: ppc.PROJECT_ID = l_project_id
470: AND ppr.project_id = ppc.project_id

Line 509: FROM pa_percent_completes ppc

505: ppr.actual_start_date,
506: ppr.actual_finish_date,
507: ppc.record_version_number percomp_record_version_number,
508: ppc.status_code del_status_code
509: FROM pa_percent_completes ppc
510: , pa_progress_rollup ppr
511: WHERE
512: ppc.project_id=l_project_id
513: AND ppc.project_id = ppr.project_id

Line 534: FROM pa_percent_completes

530:
531: -- Bug 3922325 Begin
532: CURSOR c_previous_task_status IS
533: SELECT status_code
534: FROM pa_percent_completes
535: WHERE project_id = p_project_id
536: AND object_id = p_object_id
537: AND object_type = 'PA_TASKS'
538: AND structure_type = 'WORKPLAN'

Line 864: DELETE FROM pa_percent_completes

860: --check and delete for any other working version record.
861: -- Amit : This code is not required as l_db_action will switch mode to update and the existing working record will be updated
862: IF p_action = 'SAVE' AND p_structure_type = 'WORKPLAN'
863: THEN
864: DELETE FROM pa_percent_completes
865: WHERE project_id= p_project_id
866: AND object_id = p_object_id
867: AND published_flag = 'N'
868: --AND date_computed <> p_as_of_date --bug 4185364, delete all the working records

Line 885: DELETE FROM pa_percent_completes

881:
882: --This code is required is PUBLISH mode to delete working progress records on previous dates.
883: IF p_action = 'PUBLISH' AND p_structure_type = 'WORKPLAN'
884: THEN
885: DELETE FROM pa_percent_completes
886: WHERE project_id= p_project_id
887: AND object_id = p_object_id
888: AND published_flag = 'N'
889: AND date_computed <= p_as_of_date --- 4245168

Line 2360: UPDATE pa_percent_completes

2356: ( p_progress_mode = 'BACKDATED'
2357: AND p_as_of_date = l_last_progress_date ) --bug 2646965
2358: THEN
2359: l_current_flag := 'Y';
2360: UPDATE pa_percent_completes
2361: SET current_flag = 'N'
2362: WHERE project_id = p_project_id
2363: AND object_id = p_object_id
2364: AND current_flag = 'Y'

Line 2450: PA_PERCENT_COMPLETES_PKG.INSERT_ROW(

2446: l_percent_complete_id := null;
2447: l_att_pc_id := p_percent_complete_id;
2448: --Create record in PPC
2449:
2450: PA_PERCENT_COMPLETES_PKG.INSERT_ROW(
2451: p_task_id => l_task_id
2452: ,p_date_computed => p_as_of_date
2453: ,p_last_update_date => sysdate
2454: ,p_last_updated_by => l_user_id

Line 2998: FROM pa_percent_completes

2994: );
2995: -- FPM Dev CR 3 Getting Record Version Number too
2996: BEGIN
2997: SELECT record_version_number into l_record_version_number
2998: FROM pa_percent_completes
2999: where percent_complete_id = l_percent_complete_id;
3000: END;
3001:
3002: IF g1_debug_mode = 'Y' THEN

Line 3012: PA_PERCENT_COMPLETES_PKG.UPDATE_ROW(

3008: l_percent_complete_id := p_percent_complete_id;
3009: l_record_version_number := p_record_version_number;
3010: END IF;
3011:
3012: PA_PERCENT_COMPLETES_PKG.UPDATE_ROW(
3013: p_task_id => l_task_id
3014: ,p_date_computed => p_as_of_date
3015: ,p_last_update_date => sysdate
3016: ,p_last_updated_by => l_user_id

Line 4987: FROM pa_percent_completes

4983:
4984: CURSOR cur_pa_ppc_str( c_project_id NUMBER, c_proj_element_id NUMBER )
4985: IS
4986: SELECT rowid
4987: FROM pa_percent_completes
4988: WHERE object_version_id = p_structure_version_id
4989: AND object_id = c_proj_element_id
4990: AND project_id = c_project_id
4991: AND object_type = 'PA_STRUCTURES';

Line 5005: FROM pa_percent_completes

5001:
5002: CURSOR cur_pa_ppc_tsk( c_project_id NUMBER, c_proj_element_id NUMBER )
5003: IS
5004: SELECT rowid
5005: FROM pa_percent_completes
5006: WHERE object_version_id = p_task_version_id
5007: AND object_id = c_proj_element_id
5008: AND project_id = c_project_id
5009: AND object_type = 'PA_TASKS';

Line 5085: PA_PERCENT_COMPLETES_PKG.DELETE_ROW( l_ppc_row_id );

5081: FETCH cur_pa_ppr_tsk INTO l_rollup_row_id;
5082: CLOSE cur_pa_ppr_tsk;
5083: END IF;
5084:
5085: PA_PERCENT_COMPLETES_PKG.DELETE_ROW( l_ppc_row_id );
5086: PA_PROGRESS_ROLLUP_PKG.DELETE_ROW( l_rollup_row_id );
5087:
5088: EXCEPTION
5089: when FND_API.G_EXC_ERROR then

Line 5174: pa_percent_completes ppc

5170: cursor get_task_pc_info(l_obj_id number) is
5171: select completed_percentage, published_flag, current_flag,
5172: actual_start_date, actual_finish_date
5173: from
5174: pa_percent_completes ppc
5175: WHERE ppc.object_id = l_obj_id
5176: AND ppc.object_type = 'PA_TASKS'
5177: AND ppc.structure_type = 'WORKPLAN' -- FPM Dev CR 3
5178: AND ppc.project_id = p_project_id

Line 5388: UPDATE pa_percent_completes

5384: WHERE proj_element_id = p_object_id
5385: AND project_id = p_project_id;
5386:
5387: -- Update Percent complete --
5388: UPDATE pa_percent_completes
5389: SET status_code = p_task_status,
5390: completed_percentage = 100,
5391: Actual_Finish_date = p_actual_finish_date
5392: WHERE object_id = P_Object_ID

Line 5778: UPDATE pa_percent_completes

5774: --END IF;-- PA_PROGRESS_UTILS.get_system_task_status(l_old_status_code) <> 'COMPLETED' THEN
5775: END IF; -- IF cur_task_assignments_rec.current_flag = 'Y' OR cur_task_assignments_rec.current_flag = 'X' THEN
5776:
5777: -- Update Percent complete --
5778: UPDATE pa_percent_completes
5779: SET Actual_Finish_date = p_actual_finish_date
5780: WHERE object_id = cur_task_assignments_rec.resource_list_member_id
5781: AND project_id = p_project_id
5782: AND task_id = cur_task_assignments_rec.proj_element_id

Line 6280: UPDATE pa_percent_completes

6276: NOT IN ( 'CANCELLED', 'COMPLETED' );
6277:
6278:
6279: -- Update Percent complete --
6280: UPDATE pa_percent_completes
6281: SET status_code = p_task_status,
6282: completed_percentage = 100,
6283: Actual_Finish_date = p_actual_finish_date,
6284: actual_start_date = decode(actual_start_date, null, cur_tasks_rec.scheduled_start_date, actual_start_date)

Line 6569: UPDATE pa_percent_completes

6565: -- Taks Status does not drill down to Delievrables IN ('PA_TASKS', 'PA_DELIVERABLES')
6566: AND PA_PROGRESS_UTILS.get_system_task_status( status_code )
6567: NOT IN ( 'CANCELLED', 'COMPLETED' );
6568:
6569: UPDATE pa_percent_completes
6570: SET status_code = p_task_status
6571: WHERE object_id = cur_tasks_rec.proj_element_id
6572: AND project_id = p_project_id
6573: and object_type = 'PA_TASKS'

Line 6647: UPDATE pa_percent_completes

6643:
6644: end if;
6645:
6646: if (get_task_pc_info_rec.published_flag = 'Y' and get_task_pc_info_rec.current_flag = 'Y') then
6647: UPDATE pa_percent_completes
6648: SET status_code = l_status_code
6649: WHERE object_id = cur_tasks_rec.proj_element_id
6650: AND project_id = p_project_id
6651: and Object_Type = 'PA_TASKS' -- Bhumesh

Line 6657: UPDATE pa_percent_completes

6653: AND PA_PROGRESS_UTILS.get_system_task_status( status_code )
6654: NOT IN ( 'CANCELLED', 'COMPLETED' )
6655: AND current_flag = 'Y' and published_flag = 'Y';
6656: elsif (get_task_pc_info_rec.published_flag = 'N' and get_task_pc_info_rec.current_flag = 'N') then
6657: UPDATE pa_percent_completes
6658: SET status_code = l_status_code
6659: WHERE object_id = cur_tasks_rec.proj_element_id
6660: AND project_id = p_project_id
6661: and Object_Type = 'PA_TASKS' -- Bhumesh

Line 6790: -- The goal is to fix the PUBLISHED_BY_PARTY_ID in pa_percent_completes table to point to the

6786:
6787: -- Update_PC_PARTY_MAERGE (PUBLIC)
6788: -- This is the procedure being called during the Party Merge.
6789: -- The input/output arguments format matches the document PartyMergeDD.doc.
6790: -- The goal is to fix the PUBLISHED_BY_PARTY_ID in pa_percent_completes table to point to the
6791: -- same party when two similar parties are begin merged.
6792: --
6793: -- Usage example in pl/sql
6794: -- This procedure should only be called from the PartyMerge utility.

Line 6810: update pa_percent_completes

6806: p_return_status := FND_API.G_RET_STS_SUCCESS;
6807:
6808: if (p_from_fk_id <> p_to_fk_id) then
6809:
6810: update pa_percent_completes
6811: set PUBLISHED_BY_PARTY_ID = p_to_fk_id,
6812: last_update_date = hz_utility_pub.last_update_date,
6813: last_updated_by = hz_utility_pub.user_id,
6814: last_update_login = hz_utility_pub.last_update_login

Line 8496: delete from pa_percent_completes

8492: where project_id = p_project_id
8493: and object_version_id = p_task_version_id(i);
8494:
8495: forall i in p_task_version_id.first..p_task_version_id.last
8496: delete from pa_percent_completes
8497: where project_id = p_project_id
8498: and object_version_id = p_task_version_id(i);
8499:
8500: end if;

Line 8911: from pa_percent_completes

8907: and as_of_date = p_as_of_date
8908: and structure_type = 'WORKPLAN'
8909: and current_flag = 'Y'
8910: and not exists (select 1
8911: from pa_percent_completes
8912: where project_id = p_project_id
8913: and object_id = p_object_id
8914: and object_type = p_object_type
8915: and date_computed = p_as_of_date

Line 11255: from pa_percent_completes ppc

11251:
11252:
11253: CURSOR c_get_ppc_rec(c_project_id NUMBER, c_object_id NUMBER, c_proj_element_id NUMBER, c_object_type VARCHAR2, c_as_of_date DATE) is
11254: select rowid, ppc.*
11255: from pa_percent_completes ppc
11256: where ppc.project_id = c_project_id
11257: and ppc.structure_type = 'WORKPLAN'
11258: --and trunc(ppc.date_computed) = trunc(c_as_of_date) -- Bug 4227280
11259: and ppc.published_flag = 'N' -- Bug 4227280

Line 11266: from pa_percent_completes ppc

11262: and ppc.object_type = c_object_type;
11263:
11264: CURSOR c_get_last_ppc_rec(c_project_id NUMBER, c_object_id NUMBER, c_proj_element_id NUMBER, c_object_type VARCHAR2, c_as_of_date DATE) is
11265: select ppc.*
11266: from pa_percent_completes ppc
11267: where ppc.project_id = c_project_id
11268: and ppc.structure_type = 'WORKPLAN'
11269: ---and trunc(ppc.date_computed) <= trunc(c_as_of_date)
11270: and ppc.object_id = c_object_id

Line 11374: L_TASK_STATUS pa_percent_completes.status_code%TYPE;

11370: L_ACTUAL_START_DATE DATE;
11371: L_ACTUAL_FINISH_DATE DATE;
11372: L_ESTIMATED_START_DATE DATE;
11373: L_ESTIMATED_FINISH_DATE DATE;
11374: L_TASK_STATUS pa_percent_completes.status_code%TYPE;
11375: L_PERCENT_COMPLETE_ID NUMBER;
11376: L_SYSTEM_STATUS_CODE pa_project_statuses.project_system_status_code%TYPE;
11377: L_PROGRESS_ROLLUP_ID NUMBER;
11378: L_BAC_VALUE NUMBER;

Line 11709: DELETE from pa_percent_completes

11705:
11706: -- Bug 4111107 : Delete all Working Progress Records
11707: -- Previously it was getting deleted inside the curosr
11708:
11709: DELETE from pa_percent_completes
11710: where project_id = p_project_id
11711: and structure_type = 'WORKPLAN'
11712: and published_flag = 'N';
11713:

Line 11765: -- PA_PERCENT_COMPLETES_PKG.DELETE_ROW(l_ppc_rec.rowid);

11761: -- delete it
11762: -- IF g1_debug_mode = 'Y' THEN
11763: -- pa_debug.write(x_Module=>'PA_PROGRESS_PUB.PUBLISH_PROGRESS', x_Msg => 'Working PPC Record Found, Deleting it', x_Log_Level=> 3);
11764: -- END IF;
11765: -- PA_PERCENT_COMPLETES_PKG.DELETE_ROW(l_ppc_rec.rowid);
11766: --END IF;
11767:
11768: l_last_ppc_rec := null;
11769: OPEN c_get_last_ppc_rec(l_rec.project_id, l_rec.object_id, l_rec.proj_element_id, l_rec.object_type, l_as_of_date);

Line 11801: FROM pa_percent_completes

11797: --Bug 6499700 .For already published records, incremental_work_quantity should not be considered.
11798: BEGIN
11799: SELECT published_flag
11800: INTO l_last_ppc_pub_flag
11801: FROM pa_percent_completes
11802: WHERE percent_complete_id=l_last_ppr_rec.percent_complete_id;
11803: EXCEPTION
11804: WHEN NO_DATA_FOUND THEN
11805: l_last_ppc_pub_flag:='N';

Line 12402: update pa_percent_completes

12398: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.PUBLISH_PROGRESS', x_Msg => 'After plsql table is built l_index='||l_index, x_Log_Level=> 3);
12399: END IF;
12400:
12401: FORALL i IN 1..l_index
12402: update pa_percent_completes
12403: set current_flag = 'N'
12404: where project_id = l_project_id_tbl(i)
12405: and current_flag = 'Y'
12406: and structure_type = 'WORKPLAN'

Line 12430: insert into pa_percent_completes(TASK_ID,

12426: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.PUBLISH_PROGRESS', x_Msg => 'After second bulk update' , x_Log_Level=> 3);
12427: END IF;
12428:
12429: FORALL i IN 1..l_index
12430: insert into pa_percent_completes(TASK_ID,
12431: DATE_COMPUTED,
12432: LAST_UPDATE_DATE,
12433: LAST_UPDATED_BY,
12434: CREATION_DATE,

Line 12468: ,PA_PERCENT_COMPLETES_S.nextval

12464: ,l_login_id
12465: ,l_completed_percentage_tbl(i)
12466: ,l_project_id_tbl(i)
12467: ,'Y'
12468: ,PA_PERCENT_COMPLETES_S.nextval
12469: ,l_object_version_id_tbl(i)
12470: ,l_object_type_tbl(i)
12471: ,l_object_id_tbl(i)
12472: ,l_progress_status_code_tbl(i)

Line 12498: DELETE pa_percent_completes

12494: -- The seprate delete is added after the insertion
12495: -- This is because of Bulk returning clause, we can not use select .. from dual ..where with bulk returning
12496: FOR i IN 1..l_index LOOP
12497: IF l_prog_enabled_tbl(i) = 'N' THEN
12498: DELETE pa_percent_completes
12499: where percent_complete_id = l_percent_complete_id_tbl(i);
12500:
12501: l_percent_complete_id_tbl(i):=null;
12502: END IF;

Line 12934: select max(date_computed) from pa_percent_completes ppc

12930: skip_proj_thru_dates_tbl SYSTEM.pa_date_tbl_type:= SYSTEM.pa_date_tbl_type();
12931: /* End: Fix for Bug # 5526638. */
12932:
12933: cursor max_as_of_Date is
12934: select max(date_computed) from pa_percent_completes ppc
12935: where project_id = l_project_id
12936: and published_flag ='Y'
12937: and current_flag = 'Y'
12938: and object_type = 'PA_TASKS'

Line 12947: select max(date_computed) from pa_percent_completes

12943: and relationship_type = 'S'
12944: and object_id_from1 = ppc.object_version_id);
12945:
12946: cursor max_as_of_date_assign is
12947: select max(date_computed) from pa_percent_completes
12948: where project_id = l_project_id
12949: and published_flag ='Y'
12950: and current_flag = 'Y'
12951: and object_type = 'PA_ASSIGNMENTS'

Line 18737: UPDATE pa_percent_completes

18733:
18734: IF p_as_of_date >= NVL( l_last_progress_date, p_as_of_date ) -- FPM Dev CR 5 : Equal to was missing
18735: THEN
18736: l_current_flag := 'Y';
18737: UPDATE pa_percent_completes
18738: SET current_flag = 'N'
18739: WHERE project_id = p_project_id
18740: AND object_id = l_object_id
18741: AND current_flag = 'Y'

Line 18776: UPDATE pa_percent_completes

18772:
18773: IF l_db_action = 'CREATE'
18774: THEN
18775: /* Bug 3603636 : Putiing the following code. After confirmation we will uncomment
18776: UPDATE pa_percent_completes
18777: SET history_flag = 'Y'
18778: WHERE project_id = p_project_id
18779: AND object_id = l_object_id
18780: AND trunc(date_computed) = trunc(p_as_of_date)

Line 18785: PA_PERCENT_COMPLETES_PKG.INSERT_ROW(

18781: AND object_type = l_object_type
18782: AND structure_type = p_structure_type;
18783: */
18784:
18785: PA_PERCENT_COMPLETES_PKG.INSERT_ROW(
18786: p_TASK_ID => l_task_id
18787: ,p_DATE_COMPUTED => p_as_of_date
18788: ,p_LAST_UPDATE_DATE => SYSDATE
18789: ,p_LAST_UPDATED_BY => l_user_id

Line 19132: FROM pa_percent_completes

19128: );
19129: -- FPM Dev CR 6 Getting Record Version Number too
19130: BEGIN
19131: SELECT record_version_number into l_record_version_number
19132: FROM pa_percent_completes
19133: where percent_complete_id = l_percent_complete_id;
19134: END;
19135:
19136: ELSE

Line 19146: PA_PERCENT_COMPLETES_PKG.UPDATE_ROW(

19142: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_FINANCIAL_TASK_PROGRESS', x_Msg => 'l_percent_complete_id: '||l_percent_complete_id, x_Log_Level=> 3);
19143: END IF;
19144:
19145:
19146: PA_PERCENT_COMPLETES_PKG.UPDATE_ROW(
19147: p_TASK_ID => l_task_id
19148: ,p_DATE_COMPUTED => p_as_of_date
19149: ,p_LAST_UPDATE_DATE => SYSDATE
19150: ,p_LAST_UPDATED_BY => l_user_id