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 467: , pa_percent_completes ppc

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

Line 510: FROM pa_percent_completes ppc

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

Line 534: SELECT /+ INDEX(PA_PERCENT_COMPLETES PA_PERCENT_COMPLETES_N6)/ status_code -- added hint for bug 16325523

530: --end add by rtarway, 4085882
531:
532: -- Bug 3922325 Begin
533: CURSOR c_previous_task_status IS
534: SELECT /*+ INDEX(PA_PERCENT_COMPLETES PA_PERCENT_COMPLETES_N6)*/ status_code -- added hint for bug 16325523
535: FROM pa_percent_completes
536: WHERE project_id = p_project_id
537: AND object_id = p_object_id
538: AND object_type = 'PA_TASKS'

Line 535: FROM pa_percent_completes

531:
532: -- Bug 3922325 Begin
533: CURSOR c_previous_task_status IS
534: SELECT /*+ INDEX(PA_PERCENT_COMPLETES PA_PERCENT_COMPLETES_N6)*/ status_code -- added hint for bug 16325523
535: FROM pa_percent_completes
536: WHERE project_id = p_project_id
537: AND object_id = p_object_id
538: AND object_type = 'PA_TASKS'
539: AND structure_type = 'WORKPLAN'

Line 884: DELETE FROM pa_percent_completes

880: --check and delete for any other working version record.
881: -- Amit : This code is not required as l_db_action will switch mode to update and the existing working record will be updated
882: IF p_action = 'SAVE' AND p_structure_type = 'WORKPLAN'
883: THEN
884: DELETE FROM pa_percent_completes
885: WHERE project_id= p_project_id
886: AND object_id = p_object_id
887: AND published_flag = 'N'
888: --AND date_computed <> p_as_of_date --bug 4185364, delete all the working records

Line 905: DELETE /+ INDEX(PA_PERCENT_COMPLETES PA_PERCENT_COMPLETES_N6)/ FROM pa_percent_completes -- added hint for bug 16325523

901:
902: --This code is required is PUBLISH mode to delete working progress records on previous dates.
903: IF p_action = 'PUBLISH' AND p_structure_type = 'WORKPLAN'
904: THEN
905: DELETE /*+ INDEX(PA_PERCENT_COMPLETES PA_PERCENT_COMPLETES_N6)*/ FROM pa_percent_completes -- added hint for bug 16325523
906: WHERE project_id= p_project_id
907: AND object_id = p_object_id
908: AND published_flag = 'N'
909: AND date_computed <= p_as_of_date --- 4245168

Line 2667: UPDATE /+ INDEX(pa_percent_completes PA_PERCENT_COMPLETES_N3)/ pa_percent_completes --Added hint for 15876400

2663: ( p_progress_mode = 'BACKDATED'
2664: AND p_as_of_date = l_last_progress_date ) --bug 2646965
2665: THEN
2666: l_current_flag := 'Y';
2667: UPDATE /*+ INDEX(pa_percent_completes PA_PERCENT_COMPLETES_N3)*/ pa_percent_completes --Added hint for 15876400
2668: SET current_flag = 'N'
2669: WHERE project_id = p_project_id
2670: AND object_id = p_object_id
2671: AND current_flag = 'Y'

Line 2757: PA_PERCENT_COMPLETES_PKG.INSERT_ROW(

2753: l_percent_complete_id := null;
2754: l_att_pc_id := p_percent_complete_id;
2755: --Create record in PPC
2756:
2757: PA_PERCENT_COMPLETES_PKG.INSERT_ROW(
2758: p_task_id => l_task_id
2759: ,p_date_computed => p_as_of_date
2760: ,p_last_update_date => sysdate
2761: ,p_last_updated_by => l_user_id

Line 3305: FROM pa_percent_completes

3301: );
3302: -- FPM Dev CR 3 Getting Record Version Number too
3303: BEGIN
3304: SELECT record_version_number into l_record_version_number
3305: FROM pa_percent_completes
3306: where percent_complete_id = l_percent_complete_id;
3307: END;
3308:
3309: IF g1_debug_mode = 'Y' THEN

Line 3319: PA_PERCENT_COMPLETES_PKG.UPDATE_ROW(

3315: l_percent_complete_id := p_percent_complete_id;
3316: l_record_version_number := p_record_version_number;
3317: END IF;
3318:
3319: PA_PERCENT_COMPLETES_PKG.UPDATE_ROW(
3320: p_task_id => l_task_id
3321: ,p_date_computed => p_as_of_date
3322: ,p_last_update_date => sysdate
3323: ,p_last_updated_by => l_user_id

Line 5391: FROM pa_percent_completes

5387:
5388: CURSOR cur_pa_ppc_str( c_project_id NUMBER, c_proj_element_id NUMBER )
5389: IS
5390: SELECT rowid
5391: FROM pa_percent_completes
5392: WHERE object_version_id = p_structure_version_id
5393: AND object_id = c_proj_element_id
5394: AND project_id = c_project_id
5395: AND object_type = 'PA_STRUCTURES';

Line 5409: FROM pa_percent_completes

5405:
5406: CURSOR cur_pa_ppc_tsk( c_project_id NUMBER, c_proj_element_id NUMBER )
5407: IS
5408: SELECT rowid
5409: FROM pa_percent_completes
5410: WHERE object_version_id = p_task_version_id
5411: AND object_id = c_proj_element_id
5412: AND project_id = c_project_id
5413: AND object_type = 'PA_TASKS';

Line 5489: PA_PERCENT_COMPLETES_PKG.DELETE_ROW( l_ppc_row_id );

5485: FETCH cur_pa_ppr_tsk INTO l_rollup_row_id;
5486: CLOSE cur_pa_ppr_tsk;
5487: END IF;
5488:
5489: PA_PERCENT_COMPLETES_PKG.DELETE_ROW( l_ppc_row_id );
5490: PA_PROGRESS_ROLLUP_PKG.DELETE_ROW( l_rollup_row_id );
5491:
5492: EXCEPTION
5493: when FND_API.G_EXC_ERROR then

Line 5578: pa_percent_completes ppc

5574: cursor get_task_pc_info(l_obj_id number) is
5575: select completed_percentage, published_flag, current_flag,
5576: actual_start_date, actual_finish_date
5577: from
5578: pa_percent_completes ppc
5579: WHERE ppc.object_id = l_obj_id
5580: AND ppc.object_type = 'PA_TASKS'
5581: AND ppc.structure_type = 'WORKPLAN' -- FPM Dev CR 3
5582: AND ppc.project_id = p_project_id

Line 5792: UPDATE pa_percent_completes

5788: WHERE proj_element_id = p_object_id
5789: AND project_id = p_project_id;
5790:
5791: -- Update Percent complete --
5792: UPDATE pa_percent_completes
5793: SET status_code = p_task_status,
5794: completed_percentage = 100,
5795: Actual_Finish_date = p_actual_finish_date
5796: WHERE object_id = P_Object_ID

Line 6182: UPDATE pa_percent_completes

6178: --END IF;-- PA_PROGRESS_UTILS.get_system_task_status(l_old_status_code) <> 'COMPLETED' THEN
6179: END IF; -- IF cur_task_assignments_rec.current_flag = 'Y' OR cur_task_assignments_rec.current_flag = 'X' THEN
6180:
6181: -- Update Percent complete --
6182: UPDATE pa_percent_completes
6183: SET Actual_Finish_date = p_actual_finish_date
6184: WHERE object_id = cur_task_assignments_rec.resource_list_member_id
6185: AND project_id = p_project_id
6186: AND task_id = cur_task_assignments_rec.proj_element_id

Line 6684: UPDATE pa_percent_completes

6680: NOT IN ( 'CANCELLED', 'COMPLETED' );
6681:
6682:
6683: -- Update Percent complete --
6684: UPDATE pa_percent_completes
6685: SET status_code = p_task_status,
6686: completed_percentage = 100,
6687: Actual_Finish_date = p_actual_finish_date,
6688: actual_start_date = decode(actual_start_date, null, cur_tasks_rec.scheduled_start_date, actual_start_date)

Line 6973: UPDATE pa_percent_completes

6969: -- Taks Status does not drill down to Delievrables IN ('PA_TASKS', 'PA_DELIVERABLES')
6970: AND PA_PROGRESS_UTILS.get_system_task_status( status_code )
6971: NOT IN ( 'CANCELLED', 'COMPLETED' );
6972:
6973: UPDATE pa_percent_completes
6974: SET status_code = p_task_status
6975: WHERE object_id = cur_tasks_rec.proj_element_id
6976: AND project_id = p_project_id
6977: and object_type = 'PA_TASKS'

Line 7051: UPDATE pa_percent_completes

7047:
7048: end if;
7049:
7050: if (get_task_pc_info_rec.published_flag = 'Y' and get_task_pc_info_rec.current_flag = 'Y') then
7051: UPDATE pa_percent_completes
7052: SET status_code = l_status_code
7053: WHERE object_id = cur_tasks_rec.proj_element_id
7054: AND project_id = p_project_id
7055: and Object_Type = 'PA_TASKS' -- Bhumesh

Line 7061: UPDATE pa_percent_completes

7057: AND PA_PROGRESS_UTILS.get_system_task_status( status_code )
7058: NOT IN ( 'CANCELLED', 'COMPLETED' )
7059: AND current_flag = 'Y' and published_flag = 'Y';
7060: elsif (get_task_pc_info_rec.published_flag = 'N' and get_task_pc_info_rec.current_flag = 'N') then
7061: UPDATE pa_percent_completes
7062: SET status_code = l_status_code
7063: WHERE object_id = cur_tasks_rec.proj_element_id
7064: AND project_id = p_project_id
7065: and Object_Type = 'PA_TASKS' -- Bhumesh

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

7190:
7191: -- Update_PC_PARTY_MAERGE (PUBLIC)
7192: -- This is the procedure being called during the Party Merge.
7193: -- The input/output arguments format matches the document PartyMergeDD.doc.
7194: -- The goal is to fix the PUBLISHED_BY_PARTY_ID in pa_percent_completes table to point to the
7195: -- same party when two similar parties are begin merged.
7196: --
7197: -- Usage example in pl/sql
7198: -- This procedure should only be called from the PartyMerge utility.

Line 7214: update pa_percent_completes

7210: p_return_status := FND_API.G_RET_STS_SUCCESS;
7211:
7212: if (p_from_fk_id <> p_to_fk_id) then
7213:
7214: update pa_percent_completes
7215: set PUBLISHED_BY_PARTY_ID = p_to_fk_id,
7216: last_update_date = hz_utility_pub.last_update_date,
7217: last_updated_by = hz_utility_pub.user_id,
7218: last_update_login = hz_utility_pub.last_update_login

Line 8914: delete /+ INDEX(PA_PERCENT_COMPLETES PA_PERCENT_COMPLETES_N5)/ from pa_percent_completes -- added hint for bug 16325523

8910: where project_id = p_project_id
8911: and object_version_id = p_task_version_id(i);
8912:
8913: forall i in p_task_version_id.first..p_task_version_id.last
8914: delete /*+ INDEX(PA_PERCENT_COMPLETES PA_PERCENT_COMPLETES_N5)*/ from pa_percent_completes -- added hint for bug 16325523
8915: where project_id = p_project_id
8916: and object_version_id = p_task_version_id(i);
8917:
8918: end if;

Line 9329: from pa_percent_completes

9325: and as_of_date = p_as_of_date
9326: and structure_type = 'WORKPLAN'
9327: and current_flag = 'Y'
9328: and not exists (select 1
9329: from pa_percent_completes
9330: where project_id = p_project_id
9331: and object_id = p_object_id
9332: and object_type = p_object_type
9333: and date_computed = p_as_of_date

Line 11699: from pa_percent_completes ppc

11695:
11696:
11697: 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,c_cbs_element_id Number) is
11698: select rowid, ppc.*
11699: from pa_percent_completes ppc
11700: where ppc.project_id = c_project_id
11701: and ppc.structure_type = 'WORKPLAN'
11702: --and trunc(ppc.date_computed) = trunc(c_as_of_date) -- Bug 4227280
11703: and ppc.published_flag = 'N' -- Bug 4227280

Line 11711: from pa_percent_completes ppc

11707: and NVL(ppc.cbs_element_id,-1)=NVL(c_cbs_element_id,-1);
11708:
11709: 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,c_cbs_element_id Number) is
11710: select ppc.*
11711: from pa_percent_completes ppc
11712: where ppc.project_id = c_project_id
11713: and ppc.structure_type = 'WORKPLAN'
11714: ---and trunc(ppc.date_computed) <= trunc(c_as_of_date)
11715: and ppc.object_id = c_object_id

Line 11824: L_TASK_STATUS pa_percent_completes.status_code%TYPE;

11820: L_ACTUAL_START_DATE DATE;
11821: L_ACTUAL_FINISH_DATE DATE;
11822: L_ESTIMATED_START_DATE DATE;
11823: L_ESTIMATED_FINISH_DATE DATE;
11824: L_TASK_STATUS pa_percent_completes.status_code%TYPE;
11825: L_PERCENT_COMPLETE_ID NUMBER;
11826: L_SYSTEM_STATUS_CODE pa_project_statuses.project_system_status_code%TYPE;
11827: L_PROGRESS_ROLLUP_ID NUMBER;
11828: L_BAC_VALUE NUMBER;

Line 12162: DELETE from pa_percent_completes

12158:
12159: -- Bug 4111107 : Delete all Working Progress Records
12160: -- Previously it was getting deleted inside the curosr
12161:
12162: DELETE from pa_percent_completes
12163: where project_id = p_project_id
12164: and structure_type = 'WORKPLAN'
12165: and published_flag = 'N';
12166:

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

12214: -- delete it
12215: -- IF g1_debug_mode = 'Y' THEN
12216: -- pa_debug.write(x_Module=>'PA_PROGRESS_PUB.PUBLISH_PROGRESS', x_Msg => 'Working PPC Record Found, Deleting it', x_Log_Level=> 3);
12217: -- END IF;
12218: -- PA_PERCENT_COMPLETES_PKG.DELETE_ROW(l_ppc_rec.rowid);
12219: --END IF;
12220:
12221: l_last_ppc_rec := null;
12222: 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,l_rec.cbs_element_id);

Line 12254: FROM pa_percent_completes

12250: --Bug 6499700 .For already published records, incremental_work_quantity should not be considered.
12251: BEGIN
12252: SELECT published_flag
12253: INTO l_last_ppc_pub_flag
12254: FROM pa_percent_completes
12255: WHERE percent_complete_id=l_last_ppr_rec.percent_complete_id;
12256: EXCEPTION
12257: WHEN NO_DATA_FOUND THEN
12258: l_last_ppc_pub_flag:='N';

Line 12858: update pa_percent_completes

12854: 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);
12855: END IF;
12856:
12857: FORALL i IN 1..l_index
12858: update pa_percent_completes
12859: set current_flag = 'N'
12860: where project_id = l_project_id_tbl(i)
12861: and current_flag = 'Y'
12862: and structure_type = 'WORKPLAN'

Line 12887: insert into pa_percent_completes(TASK_ID,

12883: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.PUBLISH_PROGRESS', x_Msg => 'After second bulk update' , x_Log_Level=> 3);
12884: END IF;
12885:
12886: FORALL i IN 1..l_index
12887: insert into pa_percent_completes(TASK_ID,
12888: DATE_COMPUTED,
12889: LAST_UPDATE_DATE,
12890: LAST_UPDATED_BY,
12891: CREATION_DATE,

Line 12926: ,PA_PERCENT_COMPLETES_S.nextval

12922: ,l_login_id
12923: ,l_completed_percentage_tbl(i)
12924: ,l_project_id_tbl(i)
12925: ,'Y'
12926: ,PA_PERCENT_COMPLETES_S.nextval
12927: ,l_object_version_id_tbl(i)
12928: ,l_object_type_tbl(i)
12929: ,l_object_id_tbl(i)
12930: ,l_progress_status_code_tbl(i)

Line 12957: DELETE pa_percent_completes

12953: -- The seprate delete is added after the insertion
12954: -- This is because of Bulk returning clause, we can not use select .. from dual ..where with bulk returning
12955: FOR i IN 1..l_index LOOP
12956: IF l_prog_enabled_tbl(i) = 'N' THEN
12957: DELETE pa_percent_completes
12958: where percent_complete_id = l_percent_complete_id_tbl(i);
12959:
12960: l_percent_complete_id_tbl(i):=null;
12961: END IF;

Line 13405: select max(date_computed) from pa_percent_completes ppc

13401: skip_proj_thru_dates_tbl SYSTEM.pa_date_tbl_type:= SYSTEM.pa_date_tbl_type();
13402: /* End: Fix for Bug # 5526638. */
13403:
13404: cursor max_as_of_Date is
13405: select max(date_computed) from pa_percent_completes ppc
13406: where project_id = l_project_id
13407: and published_flag ='Y'
13408: and current_flag = 'Y'
13409: and object_type = 'PA_TASKS'

Line 13418: select max(date_computed) from pa_percent_completes

13414: and relationship_type = 'S'
13415: and object_id_from1 = ppc.object_version_id);
13416:
13417: cursor max_as_of_date_assign is
13418: select max(date_computed) from pa_percent_completes
13419: where project_id = l_project_id
13420: and published_flag ='Y'
13421: and current_flag = 'Y'
13422: and object_type = 'PA_ASSIGNMENTS'

Line 20200: UPDATE /+ INDEX(pa_percent_completes PA_PERCENT_COMPLETES_N3)/ pa_percent_completes --Added hint for 15876400

20196:
20197: IF p_as_of_date >= NVL( l_last_progress_date, p_as_of_date ) -- FPM Dev CR 5 : Equal to was missing
20198: THEN
20199: l_current_flag := 'Y';
20200: UPDATE /*+ INDEX(pa_percent_completes PA_PERCENT_COMPLETES_N3)*/ pa_percent_completes --Added hint for 15876400
20201: SET current_flag = 'N'
20202: WHERE project_id = p_project_id
20203: AND object_id = l_object_id
20204: AND current_flag = 'Y'

Line 20239: UPDATE pa_percent_completes

20235:
20236: IF l_db_action = 'CREATE'
20237: THEN
20238: /* Bug 3603636 : Putiing the following code. After confirmation we will uncomment
20239: UPDATE pa_percent_completes
20240: SET history_flag = 'Y'
20241: WHERE project_id = p_project_id
20242: AND object_id = l_object_id
20243: AND trunc(date_computed) = trunc(p_as_of_date)

Line 20248: PA_PERCENT_COMPLETES_PKG.INSERT_ROW(

20244: AND object_type = l_object_type
20245: AND structure_type = p_structure_type;
20246: */
20247:
20248: PA_PERCENT_COMPLETES_PKG.INSERT_ROW(
20249: p_TASK_ID => l_task_id
20250: ,p_DATE_COMPUTED => p_as_of_date
20251: ,p_LAST_UPDATE_DATE => SYSDATE
20252: ,p_LAST_UPDATED_BY => l_user_id

Line 20595: FROM pa_percent_completes

20591: );
20592: -- FPM Dev CR 6 Getting Record Version Number too
20593: BEGIN
20594: SELECT record_version_number into l_record_version_number
20595: FROM pa_percent_completes
20596: where percent_complete_id = l_percent_complete_id;
20597: END;
20598:
20599: ELSE

Line 20609: PA_PERCENT_COMPLETES_PKG.UPDATE_ROW(

20605: 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);
20606: END IF;
20607:
20608:
20609: PA_PERCENT_COMPLETES_PKG.UPDATE_ROW(
20610: p_TASK_ID => l_task_id
20611: ,p_DATE_COMPUTED => p_as_of_date
20612: ,p_LAST_UPDATE_DATE => SYSDATE
20613: ,p_LAST_UPDATED_BY => l_user_id