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

Line 78: l_pm_product_code pa_percent_completes.pm_product_code%TYPE := NULL;

74: l_task_id_out NUMBER := 0;
75: l_msg_data VARCHAR2(2000);
76: l_function_allowed VARCHAR2(1);
77: l_resp_id NUMBER := 0;
78: l_pm_product_code pa_percent_completes.pm_product_code%TYPE := NULL;
79: l_description pa_percent_completes.description%TYPE := NULL;
80: l_as_of_date DATE;
81: l_current_flag VARCHAR2(1);
82: l_dummy VARCHAR2(1);

Line 79: l_description pa_percent_completes.description%TYPE := NULL;

75: l_msg_data VARCHAR2(2000);
76: l_function_allowed VARCHAR2(1);
77: l_resp_id NUMBER := 0;
78: l_pm_product_code pa_percent_completes.pm_product_code%TYPE := NULL;
79: l_description pa_percent_completes.description%TYPE := NULL;
80: l_as_of_date DATE;
81: l_current_flag VARCHAR2(1);
82: l_dummy VARCHAR2(1);
83: l_module_name VARCHAR2(80);

Line 90: l_progress_status_code pa_percent_completes.progress_status_code%TYPE;

86:
87: l_object_type VARCHAR2(30);
88: l_object_id NUMBER;
89: l_object_version_id NUMBER;
90: l_progress_status_code pa_percent_completes.progress_status_code%TYPE;
91: l_progress_comment pa_percent_completes.progress_comment%TYPE;
92: l_actual_start_date pa_percent_completes.actual_start_date%TYPE;
93: l_actual_finish_date pa_percent_completes.actual_finish_date%TYPE;
94: l_estimated_start_date pa_percent_completes.estimated_start_date%TYPE;

Line 91: l_progress_comment pa_percent_completes.progress_comment%TYPE;

87: l_object_type VARCHAR2(30);
88: l_object_id NUMBER;
89: l_object_version_id NUMBER;
90: l_progress_status_code pa_percent_completes.progress_status_code%TYPE;
91: l_progress_comment pa_percent_completes.progress_comment%TYPE;
92: l_actual_start_date pa_percent_completes.actual_start_date%TYPE;
93: l_actual_finish_date pa_percent_completes.actual_finish_date%TYPE;
94: l_estimated_start_date pa_percent_completes.estimated_start_date%TYPE;
95: l_estimated_finish_date pa_percent_completes.estimated_finish_date%TYPE;

Line 92: l_actual_start_date pa_percent_completes.actual_start_date%TYPE;

88: l_object_id NUMBER;
89: l_object_version_id NUMBER;
90: l_progress_status_code pa_percent_completes.progress_status_code%TYPE;
91: l_progress_comment pa_percent_completes.progress_comment%TYPE;
92: l_actual_start_date pa_percent_completes.actual_start_date%TYPE;
93: l_actual_finish_date pa_percent_completes.actual_finish_date%TYPE;
94: l_estimated_start_date pa_percent_completes.estimated_start_date%TYPE;
95: l_estimated_finish_date pa_percent_completes.estimated_finish_date%TYPE;
96: l_scheduled_start_date pa_tasks.scheduled_start_date%TYPE;

Line 93: l_actual_finish_date pa_percent_completes.actual_finish_date%TYPE;

89: l_object_version_id NUMBER;
90: l_progress_status_code pa_percent_completes.progress_status_code%TYPE;
91: l_progress_comment pa_percent_completes.progress_comment%TYPE;
92: l_actual_start_date pa_percent_completes.actual_start_date%TYPE;
93: l_actual_finish_date pa_percent_completes.actual_finish_date%TYPE;
94: l_estimated_start_date pa_percent_completes.estimated_start_date%TYPE;
95: l_estimated_finish_date pa_percent_completes.estimated_finish_date%TYPE;
96: l_scheduled_start_date pa_tasks.scheduled_start_date%TYPE;
97: l_scheduled_finish_date pa_tasks.scheduled_finish_date%TYPE;

Line 94: l_estimated_start_date pa_percent_completes.estimated_start_date%TYPE;

90: l_progress_status_code pa_percent_completes.progress_status_code%TYPE;
91: l_progress_comment pa_percent_completes.progress_comment%TYPE;
92: l_actual_start_date pa_percent_completes.actual_start_date%TYPE;
93: l_actual_finish_date pa_percent_completes.actual_finish_date%TYPE;
94: l_estimated_start_date pa_percent_completes.estimated_start_date%TYPE;
95: l_estimated_finish_date pa_percent_completes.estimated_finish_date%TYPE;
96: l_scheduled_start_date pa_tasks.scheduled_start_date%TYPE;
97: l_scheduled_finish_date pa_tasks.scheduled_finish_date%TYPE;
98: l_est_remaining_effort NUMBER;

Line 95: l_estimated_finish_date pa_percent_completes.estimated_finish_date%TYPE;

91: l_progress_comment pa_percent_completes.progress_comment%TYPE;
92: l_actual_start_date pa_percent_completes.actual_start_date%TYPE;
93: l_actual_finish_date pa_percent_completes.actual_finish_date%TYPE;
94: l_estimated_start_date pa_percent_completes.estimated_start_date%TYPE;
95: l_estimated_finish_date pa_percent_completes.estimated_finish_date%TYPE;
96: l_scheduled_start_date pa_tasks.scheduled_start_date%TYPE;
97: l_scheduled_finish_date pa_tasks.scheduled_finish_date%TYPE;
98: l_est_remaining_effort NUMBER;
99: l_ETC_cost NUMBER;

Line 108: FROM pa_percent_completes pc

104: --Bug 3606627 : Unnecessary Cursor : Commenting
105: /*CURSOR l_percent_complete_csr (l_task_id_out NUMBER, l_as_of_date DATE)
106: IS
107: SELECT trunc(date_computed)
108: FROM pa_percent_completes pc
109: WHERE pc.project_id = l_project_id_out
110: AND pc.task_id = l_task_id_out
111: AND pc.current_flag = 'Y';*/
112:

Line 2244: where exists (select 1 from pa_percent_completes

2240: IF G_TASK_PROGRESS_in_tbl(i).OBJECT_TYPE = 'PA_ASSIGNMENTS'
2241: THEN
2242: begin
2243: select 'Y' into l_rollup from dual
2244: where exists (select 1 from pa_percent_completes
2245: where task_id = l_TASK_ID
2246: AND PROJECT_ID = l_project_id_out
2247: and object_type = 'PA_TASKS'
2248: and PROGRESS_STATUS_CODE is not null);

Line 2893: l_pm_product_code pa_percent_completes.pm_product_code%TYPE := NULL;

2889: l_return_status VARCHAR2(1):= 'S';
2890: l_project_id_out NUMBER := 0;
2891: l_function_allowed VARCHAR2(1);
2892: l_resp_id NUMBER := 0;
2893: l_pm_product_code pa_percent_completes.pm_product_code%TYPE := NULL;
2894: l_description pa_percent_completes.description%TYPE := NULL;
2895: l_as_of_date DATE;
2896: l_current_flag VARCHAR2(1);
2897: l_dummy VARCHAR2(1);

Line 2894: l_description pa_percent_completes.description%TYPE := NULL;

2890: l_project_id_out NUMBER := 0;
2891: l_function_allowed VARCHAR2(1);
2892: l_resp_id NUMBER := 0;
2893: l_pm_product_code pa_percent_completes.pm_product_code%TYPE := NULL;
2894: l_description pa_percent_completes.description%TYPE := NULL;
2895: l_as_of_date DATE;
2896: l_current_flag VARCHAR2(1);
2897: l_dummy VARCHAR2(1);
2898: l_module_name VARCHAR2(80);