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.IPA_APIS dependencies on PA_PROJECTS

Line 10: l_project_id pa_projects.project_id%TYPE ;

6: retcode IN OUT NOCOPY varchar2 ) IS
7: l_interface_asset_cost_code pa_project_types.interface_asset_cost_code%TYPE ;
8: l_xface_complete_asset_flag pa_project_types.interface_complete_asset_flag%TYPE;
9: l_earliest_fa_dpis DATE ;
10: l_project_id pa_projects.project_id%TYPE ;
11: l_project_number pa_projects.segment1%TYPE;
12: l_project_name pa_projects.name%TYPE ;
13: l_project_type pa_projects.project_type%TYPE ;
14: l_project_asset_id pa_project_assets.project_asset_id%TYPE ;

Line 11: l_project_number pa_projects.segment1%TYPE;

7: l_interface_asset_cost_code pa_project_types.interface_asset_cost_code%TYPE ;
8: l_xface_complete_asset_flag pa_project_types.interface_complete_asset_flag%TYPE;
9: l_earliest_fa_dpis DATE ;
10: l_project_id pa_projects.project_id%TYPE ;
11: l_project_number pa_projects.segment1%TYPE;
12: l_project_name pa_projects.name%TYPE ;
13: l_project_type pa_projects.project_type%TYPE ;
14: l_project_asset_id pa_project_assets.project_asset_id%TYPE ;
15: l_asset_number pa_project_assets.asset_number%TYPE;

Line 12: l_project_name pa_projects.name%TYPE ;

8: l_xface_complete_asset_flag pa_project_types.interface_complete_asset_flag%TYPE;
9: l_earliest_fa_dpis DATE ;
10: l_project_id pa_projects.project_id%TYPE ;
11: l_project_number pa_projects.segment1%TYPE;
12: l_project_name pa_projects.name%TYPE ;
13: l_project_type pa_projects.project_type%TYPE ;
14: l_project_asset_id pa_project_assets.project_asset_id%TYPE ;
15: l_asset_number pa_project_assets.asset_number%TYPE;
16: l_asset_name pa_project_assets.asset_name%TYPE;

Line 13: l_project_type pa_projects.project_type%TYPE ;

9: l_earliest_fa_dpis DATE ;
10: l_project_id pa_projects.project_id%TYPE ;
11: l_project_number pa_projects.segment1%TYPE;
12: l_project_name pa_projects.name%TYPE ;
13: l_project_type pa_projects.project_type%TYPE ;
14: l_project_asset_id pa_project_assets.project_asset_id%TYPE ;
15: l_asset_number pa_project_assets.asset_number%TYPE;
16: l_asset_name pa_project_assets.asset_name%TYPE;
17: l_book_type_code pa_project_assets.book_type_code%TYPE;

Line 241: pa_projects_all pp,

237: l_book_type_code ,l_asset_units ,
238: l_asset_category_id ,l_asset_location_id ,
239: l_depreciate_flag ,l_depreciation_expense_ccid
240: FROM pa_project_assets_all pa,
241: pa_projects_all pp,
242: pa_project_types ppt
243: WHERE ( pa.project_asset_id = apis_rec.project_asset_id
244: OR pa.asset_number = apis_rec.asset_number
245: OR pa.asset_name = apis_rec.asset_name )

Line 290: FROM pa_projects_all pp,

286: ppt.interface_asset_cost_code, ppt.interface_complete_asset_flag
287: INTO l_project_id , l_project_name ,
288: l_project_number, l_project_type,
289: l_interface_asset_cost_code , l_xface_complete_asset_flag
290: FROM pa_projects_all pp,
291: pa_project_types ppt
292: WHERE (pp.project_id = apis_rec.project_id
293: OR pp.name = apis_rec.project_name
294: OR pp.segment1 = apis_rec.project_number)

Line 340: FROM pa_projects_all pp,

336: ppt.interface_asset_cost_code, ppt.interface_complete_asset_flag
337: INTO l_project_id , l_project_name ,
338: l_project_number, l_project_type,
339: l_interface_asset_cost_code , l_xface_complete_asset_flag
340: FROM pa_projects_all pp,
341: pa_project_types ppt
342: WHERE (pp.project_id = apis_rec.project_id
343: OR pp.name = apis_rec.project_name
344: OR pp.segment1 = apis_rec.project_number)