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_REVERSE_COSTED_LAB dependencies on PA_PLSQL_DATATYPES

Line 294: l_Project_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;

290: AND EXCEPTION_ACTIVITY_CODE = 'REINITIATE EI TO DIST' )
291: ) ; --Added for Bug 12779047
292:
293: /*Declaring the Global Varible for the Rever*/
294: l_Project_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
295: l_Cost_Dist_Flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
296: l_Exp_item_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
297: l_adj_exp_item_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
298: l_NewExp_item_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;

Line 295: l_Cost_Dist_Flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;

291: ) ; --Added for Bug 12779047
292:
293: /*Declaring the Global Varible for the Rever*/
294: l_Project_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
295: l_Cost_Dist_Flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
296: l_Exp_item_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
297: l_adj_exp_item_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
298: l_NewExp_item_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
299: l_SysLinkTab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 296: l_Exp_item_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;

292:
293: /*Declaring the Global Varible for the Rever*/
294: l_Project_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
295: l_Cost_Dist_Flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
296: l_Exp_item_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
297: l_adj_exp_item_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
298: l_NewExp_item_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
299: l_SysLinkTab PA_PLSQL_DATATYPES.Char30TabTyp;
300: l_PersonIdTab PA_PLSQL_DATATYPES.IdTabTyp;

Line 297: l_adj_exp_item_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;

293: /*Declaring the Global Varible for the Rever*/
294: l_Project_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
295: l_Cost_Dist_Flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
296: l_Exp_item_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
297: l_adj_exp_item_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
298: l_NewExp_item_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
299: l_SysLinkTab PA_PLSQL_DATATYPES.Char30TabTyp;
300: l_PersonIdTab PA_PLSQL_DATATYPES.IdTabTyp;
301: l_Interface_run_idTab PA_PLSQL_DATATYPES.IdTabTyp;

Line 298: l_NewExp_item_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;

294: l_Project_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
295: l_Cost_Dist_Flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
296: l_Exp_item_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
297: l_adj_exp_item_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
298: l_NewExp_item_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
299: l_SysLinkTab PA_PLSQL_DATATYPES.Char30TabTyp;
300: l_PersonIdTab PA_PLSQL_DATATYPES.IdTabTyp;
301: l_Interface_run_idTab PA_PLSQL_DATATYPES.IdTabTyp;
302: l_Reverse_eligibile_flag_Tab PA_PLSQL_DATATYPES.Char1TabTyp;

Line 299: l_SysLinkTab PA_PLSQL_DATATYPES.Char30TabTyp;

295: l_Cost_Dist_Flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
296: l_Exp_item_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
297: l_adj_exp_item_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
298: l_NewExp_item_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
299: l_SysLinkTab PA_PLSQL_DATATYPES.Char30TabTyp;
300: l_PersonIdTab PA_PLSQL_DATATYPES.IdTabTyp;
301: l_Interface_run_idTab PA_PLSQL_DATATYPES.IdTabTyp;
302: l_Reverse_eligibile_flag_Tab PA_PLSQL_DATATYPES.Char1TabTyp;
303: l_Reverse_error_code_Tab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 300: l_PersonIdTab PA_PLSQL_DATATYPES.IdTabTyp;

296: l_Exp_item_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
297: l_adj_exp_item_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
298: l_NewExp_item_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
299: l_SysLinkTab PA_PLSQL_DATATYPES.Char30TabTyp;
300: l_PersonIdTab PA_PLSQL_DATATYPES.IdTabTyp;
301: l_Interface_run_idTab PA_PLSQL_DATATYPES.IdTabTyp;
302: l_Reverse_eligibile_flag_Tab PA_PLSQL_DATATYPES.Char1TabTyp;
303: l_Reverse_error_code_Tab PA_PLSQL_DATATYPES.Char30TabTyp;
304: l_row_count NUMBER := 0;

Line 301: l_Interface_run_idTab PA_PLSQL_DATATYPES.IdTabTyp;

297: l_adj_exp_item_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
298: l_NewExp_item_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
299: l_SysLinkTab PA_PLSQL_DATATYPES.Char30TabTyp;
300: l_PersonIdTab PA_PLSQL_DATATYPES.IdTabTyp;
301: l_Interface_run_idTab PA_PLSQL_DATATYPES.IdTabTyp;
302: l_Reverse_eligibile_flag_Tab PA_PLSQL_DATATYPES.Char1TabTyp;
303: l_Reverse_error_code_Tab PA_PLSQL_DATATYPES.Char30TabTyp;
304: l_row_count NUMBER := 0;
305: l_temp_num_processed NUMBER := 500;

Line 302: l_Reverse_eligibile_flag_Tab PA_PLSQL_DATATYPES.Char1TabTyp;

298: l_NewExp_item_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
299: l_SysLinkTab PA_PLSQL_DATATYPES.Char30TabTyp;
300: l_PersonIdTab PA_PLSQL_DATATYPES.IdTabTyp;
301: l_Interface_run_idTab PA_PLSQL_DATATYPES.IdTabTyp;
302: l_Reverse_eligibile_flag_Tab PA_PLSQL_DATATYPES.Char1TabTyp;
303: l_Reverse_error_code_Tab PA_PLSQL_DATATYPES.Char30TabTyp;
304: l_row_count NUMBER := 0;
305: l_temp_num_processed NUMBER := 500;
306: temp_status NUMBER DEFAULT NULL;

Line 303: l_Reverse_error_code_Tab PA_PLSQL_DATATYPES.Char30TabTyp;

299: l_SysLinkTab PA_PLSQL_DATATYPES.Char30TabTyp;
300: l_PersonIdTab PA_PLSQL_DATATYPES.IdTabTyp;
301: l_Interface_run_idTab PA_PLSQL_DATATYPES.IdTabTyp;
302: l_Reverse_eligibile_flag_Tab PA_PLSQL_DATATYPES.Char1TabTyp;
303: l_Reverse_error_code_Tab PA_PLSQL_DATATYPES.Char30TabTyp;
304: l_row_count NUMBER := 0;
305: l_temp_num_processed NUMBER := 500;
306: temp_status NUMBER DEFAULT NULL;
307: l_status VARCHAR2(10) := NULL;

Line 310: l_Exp_item_id_tb2 PA_PLSQL_DATATYPES.IdTabTyp;

306: temp_status NUMBER DEFAULT NULL;
307: l_status VARCHAR2(10) := NULL;
308: l_result NUMBER;
309: l_temp_emp_id pa_expenditures.incurred_by_person_id%TYPE := -1;
310: l_Exp_item_id_tb2 PA_PLSQL_DATATYPES.IdTabTyp;
311: l_Exp_item_id_tb3 PA_PLSQL_DATATYPES.IdTabTyp; --Bug12779047
312: l_temp_interface_run_id pa_expenditure_items.interface_run_id%TYPE :=-1;
313: -- =======================================================================
314: -- Start of Comments

Line 311: l_Exp_item_id_tb3 PA_PLSQL_DATATYPES.IdTabTyp; --Bug12779047

307: l_status VARCHAR2(10) := NULL;
308: l_result NUMBER;
309: l_temp_emp_id pa_expenditures.incurred_by_person_id%TYPE := -1;
310: l_Exp_item_id_tb2 PA_PLSQL_DATATYPES.IdTabTyp;
311: l_Exp_item_id_tb3 PA_PLSQL_DATATYPES.IdTabTyp; --Bug12779047
312: l_temp_interface_run_id pa_expenditure_items.interface_run_id%TYPE :=-1;
313: -- =======================================================================
314: -- Start of Comments
315: -- API Name : CLEAR_PLSQL_TABLES