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_PROGRESS_ROLLUP_S

Line 7726: select pa_progress_rollup_s.nextval into progress_rollup_id(l_index2) from dual;

7722: -- Assign the pl/sql tables bug 4050532
7723:
7724: l_index2 := l_index2 + 1;
7725:
7726: select pa_progress_rollup_s.nextval into progress_rollup_id(l_index2) from dual;
7727: percent_complete_id(l_index2) := to_number(null);
7728: PROJECT_ID(l_index2) := p_project_Id;
7729: OBJECT_ID(l_index2) := l_new_object_id;
7730: OBJECT_TYPE(l_index2) := l_c1rec.object_type;

Line 12646: PA_PROGRESS_ROLLUP_S.nextval

12642: ,EQPMT_ETC_RAWCOST_FC
12643: ,EQPMT_ETC_RAWCOST_PC
12644: ,BASE_PERCENT_COMPLETE -- 4604661
12645: ) VALUES (
12646: PA_PROGRESS_ROLLUP_S.nextval
12647: ,l_project_id_tbl(i)
12648: ,l_object_id_tbl(i)
12649: ,l_object_type_tbl(i)
12650: ,l_as_of_date

Line 15283: select pa_progress_rollup_s.nextval into progress_rollup_id(l_index2) from dual;

15279: --- u_ tables else populate the insert tables, for bulk processing
15280: --- call an api to check if a record exists on that date
15281: if (l_db_case = '1') then
15282: --- insert with defaults
15283: select pa_progress_rollup_s.nextval into progress_rollup_id(l_index2) from dual;
15284: percent_complete_id(l_index2) := to_number(null);
15285: project_id(l_index2) := l_project_id;
15286: object_id(l_index2) := l_object_id;
15287: OBJECT_TYPE(l_index2) := l_object_Type;

Line 16214: select pa_progress_rollup_s.nextval into progress_rollup_id(l_index2) from dual;

16210:
16211: elsif (l_db_case = '3') then
16212: --- get progress attrs for the task/assignment
16213:
16214: select pa_progress_rollup_s.nextval into progress_rollup_id(l_index2) from dual;
16215: percent_complete_id(l_index2) := to_number(null);
16216: project_id(l_index2) := l_project_id;
16217: object_id(l_index2) := l_object_id;
16218: OBJECT_TYPE(l_index2) := l_rollup_rec_asofdate.object_Type;

Line 17066: select pa_progress_rollup_s.nextval into progress_rollup_id(l_index2) from dual;

17062: if (l_match_found = 'N') then
17063: if (nvl(all_assign_prev_asofdate_rec.ppl_act_effort_to_date,0) + nvl(all_assign_prev_asofdate_rec.eqpmt_act_effort_to_date,0) + nvl(all_assign_prev_asofdate_rec.oth_quantity_to_date,0)
17064: + nvl(all_assign_prev_asofdate_rec.ppl_act_cost_to_date_tc,0) + nvl(all_assign_prev_asofdate_rec.eqpmt_act_cost_to_date_tc,0) + nvl(all_assign_prev_asofdate_rec.oth_act_cost_to_date_tc,0) <> 0) then ---4461052
17065: l_index2 := l_index2 + 1;
17066: select pa_progress_rollup_s.nextval into progress_rollup_id(l_index2) from dual;
17067: percent_complete_id(l_index2) := to_number(null);
17068: project_id(l_index2) := l_project_id;
17069: object_id(l_index2) := all_assign_prev_asofdate_rec.object_id;
17070: OBJECT_TYPE(l_index2) := all_assign_prev_asofdate_rec.object_Type;

Line 17866: update pa_progress_rollup set

17862: -- Bug 6917961
17863:
17864: --- do bulk update
17865: forall l_index1 in 1..l_index3
17866: update pa_progress_rollup set
17867: OBJECT_VERSION_ID = u_object_version_id(l_index1)
17868: ,LAST_UPDATE_DATE = sysdate
17869: ,LAST_UPDATED_BY = fnd_global.user_id
17870: ,LAST_UPDATE_LOGIN = fnd_global.login_id

Line 17936: update pa_progress_rollup set

17932: x_Log_Level=> 3);
17933: END IF;
17934:
17935: forall l_index1 in 1..l_index4
17936: update pa_progress_rollup set
17937: CURRENT_FLAG = 'N'
17938: where progress_rollup_id = u1_progress_rollup_id(l_index1);
17939:
17940: IF g1_debug_mode = 'Y' THEN