APPS.PA_PROJECT_CORE1 dependencies on PA_PROJECT_ASSETS

Line 4327: INSERT INTO pa_project_assets (

4323: FETCH cur_get_flag INTO l_fn_assets_flag;
4324: CLOSE cur_get_flag;
4325:
4326: IF 'Y' = l_fn_assets_flag THEN
4327: INSERT INTO pa_project_assets (
4328: PROJECT_ASSET_ID,
4329: PROJECT_ID,
4330: ASSET_NUMBER,
4331: ASSET_NAME,

Line 4393: pa_project_assets_s.nextval,

4389: --end PA L Changes 2872708
4390: ORG_ID --R12: MOAC changes: Bug 4363092
4391: )
4392: select
4393: pa_project_assets_s.nextval,
4394: x_new_PROJECT_ID,
4395: NULL,
4396: ASSET_NAME,
4397: ASSET_DESCRIPTION,

Line 4459: from pa_project_assets

4455: --FA_ASSET_ID,
4456: decode( x_orig_template_flag, 'Y', CAPITAL_HOLD_FLAG, 'N', 'N' ),
4457: --end PA L chanegs 2872708
4458: org_id --R12: MOAC changes: Bug 4363092
4459: from pa_project_assets
4460: where project_id = x_orig_project_id;
4461: END IF;--IF 'Y' = l_fn_assets_flag THEN
4462:
4463: -- This block copies the attachments for a

Line 4471: from pa_project_assets orig, pa_project_assets new

4467: Declare
4468: cursor c_attach_assets is
4469: select orig.project_asset_id orig_project_asset_id,
4470: new.project_asset_id new_project_asset_id
4471: from pa_project_assets orig, pa_project_assets new
4472: where orig.project_id = x_orig_project_id
4473: and new.asset_name = orig.asset_name
4474: and new.project_id = x_new_project_id ;
4475:

Line 4487: ('PA_PROJECT_ASSETS',

4483: if c_attach_assets%notfound then
4484: exit ;
4485: end if;
4486: fnd_attached_documents2_pkg.copy_attachments
4487: ('PA_PROJECT_ASSETS',
4488: c_atch.orig_project_asset_id,
4489: null, null, null, null,
4490: 'PA_PROJECT_ASSETS',
4491: c_atch.new_project_asset_id,

Line 4490: 'PA_PROJECT_ASSETS',

4486: fnd_attached_documents2_pkg.copy_attachments
4487: ('PA_PROJECT_ASSETS',
4488: c_atch.orig_project_asset_id,
4489: null, null, null, null,
4490: 'PA_PROJECT_ASSETS',
4491: c_atch.new_project_asset_id,
4492: null, null, null, null,
4493: FND_GLOBAL.USER_ID,
4494: FND_GLOBAL.LOGIN_ID,

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

4524: LAST_UPDATE_LOGIN)
4525: -- changed to remove bug#604496 :ashia bagai 30-dec-97
4526: -- added UNION to remove bug#604496 : ashia bagai 30-dec-97
4527: -- Common Cost asset assignments would have an asset id = 0
4528: -- and hence would not have a relevant record in pa_project_assets
4529: /* select
4530: new_asset.PROJECT_ASSET_ID,
4531: 0,
4532: new_asset.PROJECT_ID,

Line 4539: pa_project_assets old_asset,

4535: sysdate,
4536: FND_GLOBAL.USER_ID,
4537: FND_GLOBAL.LOGIN_ID
4538: from pa_project_asset_assignments assign,
4539: pa_project_assets old_asset,
4540: pa_project_assets new_asset
4541: where old_asset.project_id = x_orig_project_id
4542: and old_asset.project_asset_id =
4543: assign.project_asset_id

Line 4540: pa_project_assets new_asset

4536: FND_GLOBAL.USER_ID,
4537: FND_GLOBAL.LOGIN_ID
4538: from pa_project_asset_assignments assign,
4539: pa_project_assets old_asset,
4540: pa_project_assets new_asset
4541: where old_asset.project_id = x_orig_project_id
4542: and old_asset.project_asset_id =
4543: assign.project_asset_id
4544: and assign.task_id = 0

Line 4558: pa_project_assets old_asset,

4554: sysdate,
4555: FND_GLOBAL.USER_ID,
4556: FND_GLOBAL.LOGIN_ID
4557: from pa_project_asset_assignments assign,
4558: pa_project_assets old_asset,
4559: pa_project_assets new_asset
4560: where old_asset.project_id = x_orig_project_id
4561: and old_asset.project_asset_id =
4562: assign.project_asset_id

Line 4559: pa_project_assets new_asset

4555: FND_GLOBAL.USER_ID,
4556: FND_GLOBAL.LOGIN_ID
4557: from pa_project_asset_assignments assign,
4558: pa_project_assets old_asset,
4559: pa_project_assets new_asset
4560: where old_asset.project_id = x_orig_project_id
4561: and old_asset.project_asset_id =
4562: assign.project_asset_id
4563: and assign.task_id = 0