APPS.IPA_APIS dependencies on PA_PROJECT_TYPES

Line 7: l_interface_asset_cost_code pa_project_types.interface_asset_cost_code%TYPE ;

3:
4: PROCEDURE summarize_dpis (
5: errbug IN OUT NOCOPY VARCHAR2 ,
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;

Line 8: l_xface_complete_asset_flag pa_project_types.interface_complete_asset_flag%TYPE;

4: PROCEDURE summarize_dpis (
5: errbug IN OUT NOCOPY VARCHAR2 ,
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 ;

Line 242: pa_project_types ppt

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 )
246: AND capitalized_flag <> 'Y'

Line 290: pa_project_types ppt

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

Line 339: pa_project_types ppt

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