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 339: FROM pa_percent_completes

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

Line 3337: UPDATE pa_percent_completes

3333: END IF;
3334: END IF;
3335: END IF;
3336:
3337: UPDATE pa_percent_completes
3338: SET status_code = l_status_code
3339: , actual_start_date = l_actual_start_date -- Bug 3956299
3340: , actual_finish_date = l_actual_finish_date -- Bug 3956299
3341: WHERE object_id = cur_reverse_tree_rec.proj_element_id

Line 3351: UPDATE pa_percent_completes

3347: AND current_flag = 'N' and published_flag = 'N'
3348: ;
3349:
3350: -- 14-Feb-2005 : Added Patched thru Bug 4180026
3351: UPDATE pa_percent_completes
3352: SET status_code = l_status_code
3353: , actual_start_date = l_actual_start_date -- Bug 3956299
3354: , actual_finish_date = l_actual_finish_date -- Bug 3956299
3355: WHERE object_id = cur_reverse_tree_rec.proj_element_id

Line 3543: FROM pa_percent_completes

3539: l_tsk_create_required(task_index):='Y';
3540: BEGIN
3541: SELECT percent_complete_id
3542: INTO l_percent_complete_id
3543: FROM pa_percent_completes
3544: WHERE project_id = p_project_id
3545: AND object_id = cur_reverse_tree_rec.proj_element_id
3546: AND object_Type = l_rollup_table1(i).object_Type
3547: AND structure_type = p_structure_type

Line 3549: FROM pa_percent_completes

3545: AND object_id = cur_reverse_tree_rec.proj_element_id
3546: AND object_Type = l_rollup_table1(i).object_Type
3547: AND structure_type = p_structure_type
3548: AND date_computed = ( SELECT max(date_computed)
3549: FROM pa_percent_completes
3550: WHERE project_id = p_project_id
3551: AND object_id = cur_reverse_tree_rec.proj_element_id
3552: AND object_Type = l_rollup_table1(i).object_Type
3553: AND structure_type = p_structure_type

Line 4161: from pa_progress_rollup ppr, pa_percent_completes ppc

4157: -- Bug 3764224 : This cursor deals with tasks only, so no need to add join of proj_element_id
4158: CURSOR cur_tree_rollup_dates
4159: IS
4160: select as_of_date, published_flag, ppc.current_flag
4161: from pa_progress_rollup ppr, pa_percent_completes ppc
4162: where ppr.project_id = p_project_id
4163: and ppr.object_id = l_object_id
4164: and ppr.as_of_Date > p_as_of_date
4165: and ppr.project_id = ppc.project_id(+)

Line 6673: FROM pa_percent_completes

6669: CURSOR c_get_dlv_status IS
6670: SELECT 'Y' FROM DUAL
6671: WHERE EXISTS
6672: (SELECT 'xyz'
6673: FROM pa_percent_completes
6674: WHERE project_id = p_project_id
6675: AND task_id = p_task_id
6676: AND object_type = 'PA_DELIVERABLES'
6677: AND trunc(date_computed)<= trunc(p_as_of_date)

Line 8205: UPDATE pa_percent_completes

8201: l_status_code := '125';
8202: END IF;
8203:
8204:
8205: UPDATE pa_percent_completes
8206: SET status_code = l_status_code
8207: WHERE object_id = p_task_id
8208: AND project_id = p_project_id
8209: AND PA_PROGRESS_UTILS.get_system_task_status( status_code ) NOT IN ( 'CANCELLED' )

Line 8332: UPDATE pa_percent_completes

8328: END IF;
8329: END IF;
8330: -- Bug 3956299 End
8331:
8332: UPDATE pa_percent_completes
8333: SET status_code = l_status_code
8334: , actual_start_date = l_actual_start_date -- Bug 3956299
8335: , actual_finish_date = l_actual_finish_date -- Bug 3956299
8336: WHERE object_id = p_task_id

Line 8680: FROM pa_percent_completes

8676: -- get percent_complete_id
8677: BEGIN
8678: SELECT percent_complete_id
8679: INTO l_percent_complete_id
8680: FROM pa_percent_completes
8681: WHERE project_id = p_project_id
8682: AND object_id = p_task_id
8683: AND object_Type = l_rollup_table1(i).object_Type
8684: AND structure_type = 'WORKPLAN'

Line 8686: FROM pa_percent_completes

8682: AND object_id = p_task_id
8683: AND object_Type = l_rollup_table1(i).object_Type
8684: AND structure_type = 'WORKPLAN'
8685: AND date_computed = ( SELECT max(date_computed)
8686: FROM pa_percent_completes
8687: WHERE project_id = p_project_id
8688: AND object_id = p_task_id
8689: AND object_Type = l_rollup_table1(i).object_Type
8690: AND structure_type = 'WORKPLAN'

Line 9164: delete from pa_percent_completes

9160:
9161: --bug 3958686, start
9162:
9163: IF p_action = 'SAVE' THEN
9164: delete from pa_percent_completes
9165: where project_id= p_project_id
9166: and task_id = p_task_id
9167: and object_id = p_resource_list_mem_id
9168: and object_type = 'PA_ASSIGNMENTS'

Line 9186: delete from pa_percent_completes

9182: END IF;
9183:
9184:
9185: IF p_action = 'PUBLISH' THEN
9186: delete from pa_percent_completes
9187: where project_id= p_project_id
9188: and task_id = p_task_id
9189: and object_id = p_resource_list_mem_id
9190: and object_type = 'PA_ASSIGNMENTS'

Line 9196: delete from pa_percent_completes

9192: and date_computed <= p_as_of_date
9193: and structure_type = 'WORKPLAN'
9194: ;
9195:
9196: delete from pa_percent_completes
9197: WHERE project_id = p_project_id
9198: and object_id = p_resource_list_mem_id
9199: and task_id = p_task_id
9200: and trunc(date_computed) = trunc(p_as_of_date)

Line 9238: UPDATE pa_percent_completes

9234: -- Added update code to set current_flag as N otherwise upon publishinh it will give error
9235: -- ORA-00001: unique constraint (PA.PA_BUDGET_LINES_U1) violated in Package PA_FP_MAINTAIN_ACTUAL_PUB Procedure MAINTAIN_ACTUAL_AMT_RA
9236: -- Patched thru Bug 4183307
9237: IF p_action = 'PUBLISH' THEN
9238: UPDATE pa_percent_completes
9239: SET current_flag = 'N'
9240: WHERE project_id = p_project_id
9241: AND object_id = p_resource_list_mem_id
9242: AND task_id = p_task_id

Line 9313: select PA_PERCENT_COMPLETES_S.nextval

9309: END IF;
9310: -- Bug 4490532 End
9311:
9312:
9313: select PA_PERCENT_COMPLETES_S.nextval
9314: into x_percent_complete_id
9315: from dual;
9316:
9317: select PA_PROGRESS_ROLLUP_S.nextval

Line 9321: 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);

9317: select PA_PROGRESS_ROLLUP_S.nextval
9318: into X_PROGRESS_ROLLUP_ID
9319: from dual;
9320: IF g1_debug_mode = 'Y' THEN
9321: 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);
9322: END IF;
9323: INSERT INTO pa_percent_completes(
9324: TASK_ID
9325: ,DATE_COMPUTED

Line 9323: INSERT INTO pa_percent_completes(

9319: from dual;
9320: IF g1_debug_mode = 'Y' THEN
9321: 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);
9322: END IF;
9323: INSERT INTO pa_percent_completes(
9324: TASK_ID
9325: ,DATE_COMPUTED
9326: ,LAST_UPDATE_DATE
9327: ,LAST_UPDATED_BY

Line 9414: FROM pa_percent_completes

9410: ,ATTRIBUTE13
9411: ,ATTRIBUTE14
9412: ,ATTRIBUTE15
9413: ,STRUCTURE_TYPE
9414: FROM pa_percent_completes
9415: WHERE project_id = p_project_id
9416: and object_id = p_task_id
9417: and task_id = p_task_id
9418: and structure_type = 'WORKPLAN'

Line 9427: 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);

9423: or (p_action = 'PUBLISH' and published_flag = 'Y' and current_flag = 'Y'))
9424: ;
9425:
9426: IF g1_debug_mode = 'Y' THEN
9427: 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);
9428: END IF;
9429: -- Bug 4490532 : Subtracting the subproject amounts if available.
9430: -- Bug 4661350 : Using newly introduced local variable to store subprojects sum value
9431: INSERT INTO pa_progress_rollup(

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

10391: l_new_element_version_id_tab,
10392: l_proj_element_id_tab;
10393: close obj_version_id;
10394:
10395: --- update pa_percent_completes table with new object_version_ids
10396: IF l_new_element_version_id_tab.count > 0 THEN
10397: --- update pa_percent_completes table with new object_version_ids
10398: Forall i in l_new_element_version_id_tab.first..l_new_element_version_id_tab.last
10399: update pa_percent_completes ppc

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

10393: close obj_version_id;
10394:
10395: --- update pa_percent_completes table with new object_version_ids
10396: IF l_new_element_version_id_tab.count > 0 THEN
10397: --- update pa_percent_completes table with new object_version_ids
10398: Forall i in l_new_element_version_id_tab.first..l_new_element_version_id_tab.last
10399: update pa_percent_completes ppc
10400: set object_version_id = l_new_element_version_id_tab(i)
10401: where project_id = p_project_id

Line 10399: update pa_percent_completes ppc

10395: --- update pa_percent_completes table with new object_version_ids
10396: IF l_new_element_version_id_tab.count > 0 THEN
10397: --- update pa_percent_completes table with new object_version_ids
10398: Forall i in l_new_element_version_id_tab.first..l_new_element_version_id_tab.last
10399: update pa_percent_completes ppc
10400: set object_version_id = l_new_element_version_id_tab(i)
10401: where project_id = p_project_id
10402: and task_id = l_proj_element_id_tab(i)
10403: and structure_type = 'WORKPLAN'