DBA Data[Home] [Help]

APPS.IPA_ASSET_MECH_APIS_PKG dependencies on PA_PROJECT_ASSETS

Line 421: x_err_stage := 'Inserting Into PA_PROJECT_ASSETS_ALL';

417: goto next_row;
418: end if;
419: end if; /* v_deprn_expense_ccid check - Added for Bug#3571657 */
420:
421: x_err_stage := 'Inserting Into PA_PROJECT_ASSETS_ALL';
422:
423: PA_PROJECT_ASSETS_PKG.Insert_Row(
424: X_Rowid =>v_Row_id
425: ,X_Project_Asset_Id =>v_Project_Asset_ID

Line 423: PA_PROJECT_ASSETS_PKG.Insert_Row(

419: end if; /* v_deprn_expense_ccid check - Added for Bug#3571657 */
420:
421: x_err_stage := 'Inserting Into PA_PROJECT_ASSETS_ALL';
422:
423: PA_PROJECT_ASSETS_PKG.Insert_Row(
424: X_Rowid =>v_Row_id
425: ,X_Project_Asset_Id =>v_Project_Asset_ID
426: ,X_Project_Id =>ei_rec.Project_Id
427: ,X_Asset_Number =>null

Line 483: x_err_stage := 'Updating PA_PROJECT_ASSETS_ALL';

479: , X_Ret_Target_Asset_Id =>null
480: , X_ORG_ID => v_org_id -- MOAC changes
481: );
482:
483: x_err_stage := 'Updating PA_PROJECT_ASSETS_ALL';
484: update pa_project_assets
485: set asset_name = substr(v_asset_name,1,30-length(asset_naming_method_rec.asset_desc_separator||to_char(v_project_asset_id)))
486: ||asset_naming_method_rec.asset_desc_separator||to_char(v_project_asset_id),
487: org_id = v_org_id,

Line 484: update pa_project_assets

480: , X_ORG_ID => v_org_id -- MOAC changes
481: );
482:
483: x_err_stage := 'Updating PA_PROJECT_ASSETS_ALL';
484: update pa_project_assets
485: set asset_name = substr(v_asset_name,1,30-length(asset_naming_method_rec.asset_desc_separator||to_char(v_project_asset_id)))
486: ||asset_naming_method_rec.asset_desc_separator||to_char(v_project_asset_id),
487: org_id = v_org_id,
488: request_id = x_request_id,

Line 494: x_err_stage := 'Inserting Into PA_PROJECT_ASSETS_ASSIGNMENTS';

490: program_id = x_program_id,
491: program_update_date = sysdate
492: where rowid = v_row_id;
493:
494: x_err_stage := 'Inserting Into PA_PROJECT_ASSETS_ASSIGNMENTS';
495: PA_PROJ_ASSET_ASSIGN_PKG.insert_row(X_Rowid =>v_row_id2
496: ,X_Project_Asset_Id =>v_project_asset_id
497: ,X_Task_Id => ei_rec.task_id
498: ,X_Project_Id => ei_rec.project_id

Line 510: x_err_stage := 'Updating PA_PROJECT_ASSETS_ASSIGNMENTS';

506: -- for crl scm 3.1 modification that an item must be its own
507: -- asset. tls 5/9/99
508:
509: /* Bug#3043050. Added decode for attributes 6 and 7 based on NL Installed flag */
510: x_err_stage := 'Updating PA_PROJECT_ASSETS_ASSIGNMENTS';
511: update pa_project_asset_assignments
512: set attribute8 = ei_rec.attribute8
513: ,attribute9 = ei_rec.attribute9
514: ,attribute10 = ei_rec.attribute10