APPS.PA_PROGRESS_PUB dependencies on PA_PROGRESS_ROLLUP_S

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

8137: -- Assign the pl/sql tables bug 4050532
8138:
8139: l_index2 := l_index2 + 1;
8140:
8141: select pa_progress_rollup_s.nextval into progress_rollup_id(l_index2) from dual;
8142: percent_complete_id(l_index2) := to_number(null);
8143: PROJECT_ID(l_index2) := p_project_Id;
8144: OBJECT_ID(l_index2) := l_new_object_id;
8145: l_cbs_element_id(l_index2) := l_c1rec.cbs_element_id;-- added for 16895485

Line 13108: PA_PROGRESS_ROLLUP_S.nextval

13104: ,EQPMT_ETC_RAWCOST_PC
13105: ,BASE_PERCENT_COMPLETE -- 4604661
13106: ,CBS_ELEMENT_ID
13107: ) VALUES (
13108: PA_PROGRESS_ROLLUP_S.nextval
13109: ,l_project_id_tbl(i)
13110: ,l_object_id_tbl(i)
13111: ,l_object_type_tbl(i)
13112: ,l_as_of_date

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

15977: --- call an api to check if a record exists on that date
15978:
15979: if (l_db_case = '1') then
15980: --- insert with defaults
15981: select pa_progress_rollup_s.nextval into progress_rollup_id(l_index2) from dual;
15982: percent_complete_id(l_index2) := to_number(null);
15983: project_id(l_index2) := l_project_id;
15984: object_id(l_index2) := l_object_id;
15985: pa_debug.log_message('Inside loop object_id '|| object_id(l_index2), 1);

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

17187:
17188: elsif (l_db_case = '3') then
17189: --- get progress attrs for the task/assignment
17190:
17191: select pa_progress_rollup_s.nextval into progress_rollup_id(l_index2) from dual;
17192: percent_complete_id(l_index2) := to_number(null);
17193: project_id(l_index2) := l_project_id;
17194: object_id(l_index2) := l_object_id;
17195: OBJECT_TYPE(l_index2) := l_rollup_rec_asofdate.object_Type;

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

18230: if (l_match_found = 'N') then
18231: 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)
18232: + 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
18233: l_index2 := l_index2 + 1;
18234: select pa_progress_rollup_s.nextval into progress_rollup_id(l_index2) from dual;
18235: percent_complete_id(l_index2) := to_number(null);
18236: project_id(l_index2) := l_project_id;
18237: object_id(l_index2) := all_assign_prev_asofdate_rec.object_id;
18238: OBJECT_TYPE(l_index2) := all_assign_prev_asofdate_rec.object_Type;

Line 19302: update pa_progress_rollup set

19298: -- Bug 6917961
19299:
19300: --- do bulk update
19301: forall l_index1 in 1..l_index3
19302: update pa_progress_rollup set
19303: OBJECT_VERSION_ID = u_object_version_id(l_index1)
19304: ,LAST_UPDATE_DATE = sysdate
19305: ,LAST_UPDATED_BY = fnd_global.user_id
19306: ,LAST_UPDATE_LOGIN = fnd_global.login_id

Line 19372: update pa_progress_rollup set

19368: x_Log_Level=> 3);
19369: END IF;
19370:
19371: forall l_index1 in 1..l_index4
19372: update pa_progress_rollup set
19373: CURRENT_FLAG = 'N'
19374: where progress_rollup_id = u1_progress_rollup_id(l_index1);
19375:
19376: IF g1_debug_mode = 'Y' THEN