DBA Data[Home] [Help]

APPS.PA_ACCUM_PROJ_LIST dependencies on PA_PROJECT_ACCUM_COMMITMENTS

Line 12: -- 3) pa_project_accum_commitments

8: -- Description: For a given project, this procedure inserts one project-level row
9: -- for each of the following summarization tables:
10: -- 1) pa_project_accum_headers
11: -- 2) pa_project_accum_actuals
12: -- 3) pa_project_accum_commitments
13: --
14: -- For the pa_project_accum_budgets, one row each is inserted for
15: -- budget_type_codes AC and AR (Approved Cost and Approved Revenue,
16: -- respectively).

Line 187: Insert into PA_PROJECT_ACCUM_COMMITMENTS (

183:
184:
185: -- Commitments Record, If NOT Already Exist
186:
187: Insert into PA_PROJECT_ACCUM_COMMITMENTS (
188: PROJECT_ACCUM_ID,CMT_RAW_COST_ITD,CMT_RAW_COST_YTD,CMT_RAW_COST_PP,
189: CMT_RAW_COST_PTD,
190: CMT_BURDENED_COST_ITD,CMT_BURDENED_COST_YTD,
191: CMT_BURDENED_COST_PP,CMT_BURDENED_COST_PTD,

Line 215: from pa_project_accum_commitments

211: Trunc(Sysdate),G_created_by,
212: G_last_update_login
213: FROM dual
214: WHERE NOT EXISTS (select 'X'
215: from pa_project_accum_commitments
216: where project_accum_id = l_project_accum_id
217: );
218:
219: -- Approved Cost Budget Record, If NOT Already Exist

Line 356: -- 3) pa_project_accum_commitments

352: -- Description: For a given project, this procedure inserts one project-level row
353: -- for each of the following summarization tables:
354: -- 1) pa_project_accum_headers
355: -- 2) pa_project_accum_actuals
356: -- 3) pa_project_accum_commitments
357: --
358: -- For the pa_project_accum_budgets, one row each is inserted for
359: -- budget_type_codes AC and AR (Approved Cost and Approved Revenue,
360: -- respectively).

Line 526: Insert into PA_PROJECT_ACCUM_COMMITMENTS (

522:
523:
524: -- Commitments Record, If NOT Already Exist
525:
526: Insert into PA_PROJECT_ACCUM_COMMITMENTS (
527: PROJECT_ACCUM_ID,CMT_RAW_COST_ITD,CMT_RAW_COST_YTD,CMT_RAW_COST_PP,
528: CMT_RAW_COST_PTD,
529: CMT_BURDENED_COST_ITD,CMT_BURDENED_COST_YTD,
530: CMT_BURDENED_COST_PP,CMT_BURDENED_COST_PTD,

Line 554: from pa_project_accum_commitments

550: Trunc(Sysdate),G_created_by,
551: G_last_update_login
552: FROM dual
553: WHERE NOT EXISTS (select 'X'
554: from pa_project_accum_commitments
555: where project_accum_id = l_project_accum_id
556: );
557:
558: -- Approved Cost Budget Record, If NOT Already Exist