DBA Data[Home] [Help]

APPS.PA_COPY_ASSET_PVT dependencies on PA_PROJECT_ASSETS_ALL

Line 28: current_asset_rec pa_project_assets_all%ROWTYPE;

24: WHERE project_asset_id = p_cur_project_asset_id;
25:
26: assignments_rec assignments_cur%ROWTYPE;
27:
28: current_asset_rec pa_project_assets_all%ROWTYPE;
29:
30: v_user NUMBER := FND_GLOBAL.user_id;
31: v_login NUMBER := FND_GLOBAL.login_id;
32:

Line 43: FROM pa_project_assets_all

39:
40: --Get the current asset information
41: SELECT *
42: INTO current_asset_rec
43: FROM pa_project_assets_all
44: WHERE project_asset_id = p_cur_project_asset_id;
45:
46:
47: --Get next project_asset_id sequence value

Line 53: INSERT INTO pa_project_assets_all(

49: INTO x_new_project_asset_id
50: FROM SYS.DUAL;
51:
52: --Insert new project asset, since all validations have passed
53: INSERT INTO pa_project_assets_all(
54: project_asset_id,
55: project_id,
56: asset_number,
57: asset_name,