APPS.PA_PROJECT_CORE1 dependencies on PA_PROJECT_ASSETS

Line 4375: INSERT INTO pa_project_assets (

4371: FETCH cur_get_flag INTO l_fn_assets_flag;
4372: CLOSE cur_get_flag;
4373:
4374: IF 'Y' = l_fn_assets_flag THEN
4375: INSERT INTO pa_project_assets (
4376: PROJECT_ASSET_ID,
4377: PROJECT_ID,
4378: ASSET_NUMBER,
4379: ASSET_NAME,

Line 4441: pa_project_assets_s.nextval,

4437: --end PA L Changes 2872708
4438: ORG_ID --R12: MOAC changes: Bug 4363092
4439: )
4440: select
4441: pa_project_assets_s.nextval,
4442: x_new_PROJECT_ID,
4443: NULL,
4444: ASSET_NAME,
4445: ASSET_DESCRIPTION,

Line 4507: from pa_project_assets

4503: --FA_ASSET_ID,
4504: decode( x_orig_template_flag, 'Y', CAPITAL_HOLD_FLAG, 'N', 'N' ),
4505: --end PA L chanegs 2872708
4506: org_id --R12: MOAC changes: Bug 4363092
4507: from pa_project_assets
4508: where project_id = x_orig_project_id;
4509: END IF;--IF 'Y' = l_fn_assets_flag THEN
4510:
4511: -- This block copies the attachments for a

Line 4519: from pa_project_assets orig, pa_project_assets new

4515: Declare
4516: cursor c_attach_assets is
4517: select orig.project_asset_id orig_project_asset_id,
4518: new.project_asset_id new_project_asset_id
4519: from pa_project_assets orig, pa_project_assets new
4520: where orig.project_id = x_orig_project_id
4521: and new.asset_name = orig.asset_name
4522: and new.project_id = x_new_project_id ;
4523:

Line 4535: ('PA_PROJECT_ASSETS',

4531: if c_attach_assets%notfound then
4532: exit ;
4533: end if;
4534: fnd_attached_documents2_pkg.copy_attachments
4535: ('PA_PROJECT_ASSETS',
4536: c_atch.orig_project_asset_id,
4537: null, null, null, null,
4538: 'PA_PROJECT_ASSETS',
4539: c_atch.new_project_asset_id,

Line 4538: 'PA_PROJECT_ASSETS',

4534: fnd_attached_documents2_pkg.copy_attachments
4535: ('PA_PROJECT_ASSETS',
4536: c_atch.orig_project_asset_id,
4537: null, null, null, null,
4538: 'PA_PROJECT_ASSETS',
4539: c_atch.new_project_asset_id,
4540: null, null, null, null,
4541: FND_GLOBAL.USER_ID,
4542: FND_GLOBAL.LOGIN_ID,

Line 4576: -- and hence would not have a relevant record in pa_project_assets

4572: LAST_UPDATE_LOGIN)
4573: -- changed to remove bug#604496 :ashia bagai 30-dec-97
4574: -- added UNION to remove bug#604496 : ashia bagai 30-dec-97
4575: -- Common Cost asset assignments would have an asset id = 0
4576: -- and hence would not have a relevant record in pa_project_assets
4577: /* select
4578: new_asset.PROJECT_ASSET_ID,
4579: 0,
4580: new_asset.PROJECT_ID,

Line 4587: pa_project_assets old_asset,

4583: sysdate,
4584: FND_GLOBAL.USER_ID,
4585: FND_GLOBAL.LOGIN_ID
4586: from pa_project_asset_assignments assign,
4587: pa_project_assets old_asset,
4588: pa_project_assets new_asset
4589: where old_asset.project_id = x_orig_project_id
4590: and old_asset.project_asset_id =
4591: assign.project_asset_id

Line 4588: pa_project_assets new_asset

4584: FND_GLOBAL.USER_ID,
4585: FND_GLOBAL.LOGIN_ID
4586: from pa_project_asset_assignments assign,
4587: pa_project_assets old_asset,
4588: pa_project_assets new_asset
4589: where old_asset.project_id = x_orig_project_id
4590: and old_asset.project_asset_id =
4591: assign.project_asset_id
4592: and assign.task_id = 0

Line 4606: pa_project_assets old_asset,

4602: sysdate,
4603: FND_GLOBAL.USER_ID,
4604: FND_GLOBAL.LOGIN_ID
4605: from pa_project_asset_assignments assign,
4606: pa_project_assets old_asset,
4607: pa_project_assets new_asset
4608: where old_asset.project_id = x_orig_project_id
4609: and old_asset.project_asset_id =
4610: assign.project_asset_id

Line 4607: pa_project_assets new_asset

4603: FND_GLOBAL.USER_ID,
4604: FND_GLOBAL.LOGIN_ID
4605: from pa_project_asset_assignments assign,
4606: pa_project_assets old_asset,
4607: pa_project_assets new_asset
4608: where old_asset.project_id = x_orig_project_id
4609: and old_asset.project_asset_id =
4610: assign.project_asset_id
4611: and assign.task_id = 0