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.GMS_MULTI_FUNDING dependencies on PA_PROJECTS_ALL

Line 168: UPDATE PA_PROJECTS_ALL

164: X_Err_Code OUT NOCOPY VARCHAR2,
165: X_Err_Stage OUT NOCOPY VARCHAR2) IS
166: BEGIN
167: --dbms_output.put_line('Inside UPDATE Project Info');
168: UPDATE PA_PROJECTS_ALL
169: SET cost_ind_rate_sch_id = X_IDC_Schedule_Id,
170: cost_ind_sch_fixed_date = X_IDC_Schedule_Fixed_Date,
171: labor_invoice_format_id = X_Labor_Invoice_Format_Id,
172: non_labor_invoice_format_Id = X_Non_Labor_Invoice_Format_Id,

Line 228: l_awd_proj_temp pa_projects_all%rowtype;

224: ,X_Err_Code OUT NOCOPY VARCHAR2
225: ,X_Err_Stage OUT NOCOPY VARCHAR2) IS
226:
227: l_struct_exists varchar2(1) := 'N';
228: l_awd_proj_temp pa_projects_all%rowtype;
229: l_msg_count NUMBER;
230: l_msg_data VARCHAR2(2000);
231: l_return_status VARCHAR2(1);
232:

Line 235: Select * FROM pa_projects_all

231: l_return_status VARCHAR2(1);
232:
233:
234: CURSOR c_awd_proj_temp is
235: Select * FROM pa_projects_all
236: WHERE project_id = x_award_project_id;
237:
238: CURSOR c_struc_exists is
239: Select 'Y' FROM pa_proj_elements