DBA Data[Home] [Help]

APPS.PA_ACCUM_PROJ_LIST dependencies on PA_PROJECT_ACCUM_ACTUALS

Line 11: -- 2) pa_project_accum_actuals

7: --
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,

Line 152: Insert into PA_PROJECT_ACCUM_ACTUALS (

148: -- As Necessary, Create Detail Records -------------------------
149:
150: -- Actuals Record, If NOT Already Exist
151:
152: Insert into PA_PROJECT_ACCUM_ACTUALS (
153: PROJECT_ACCUM_ID,RAW_COST_ITD,RAW_COST_YTD,RAW_COST_PP,RAW_COST_PTD,
154: BILLABLE_RAW_COST_ITD,BILLABLE_RAW_COST_YTD,BILLABLE_RAW_COST_PP,
155: BILLABLE_RAW_COST_PTD,BURDENED_COST_ITD,BURDENED_COST_YTD,
156: BURDENED_COST_PP,BURDENED_COST_PTD,BILLABLE_BURDENED_COST_ITD,

Line 180: from pa_project_accum_actuals

176: 0,NULL,G_request_id,G_last_updated_by,Trunc(sysdate),
177: Trunc(Sysdate),G_created_by,G_last_update_login
178: FROM dual
179: WHERE NOT EXISTS (select 'X'
180: from pa_project_accum_actuals
181: where project_accum_id = l_project_accum_id
182: );
183:
184:

Line 355: -- 2) pa_project_accum_actuals

351: --
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,

Line 491: Insert into PA_PROJECT_ACCUM_ACTUALS (

487: -- As Necessary, Create Detail Records -------------------------
488:
489: -- Actuals Record, If NOT Already Exist
490:
491: Insert into PA_PROJECT_ACCUM_ACTUALS (
492: PROJECT_ACCUM_ID,RAW_COST_ITD,RAW_COST_YTD,RAW_COST_PP,RAW_COST_PTD,
493: BILLABLE_RAW_COST_ITD,BILLABLE_RAW_COST_YTD,BILLABLE_RAW_COST_PP,
494: BILLABLE_RAW_COST_PTD,BURDENED_COST_ITD,BURDENED_COST_YTD,
495: BURDENED_COST_PP,BURDENED_COST_PTD,BILLABLE_BURDENED_COST_ITD,

Line 519: from pa_project_accum_actuals

515: 0,NULL,G_request_id,G_last_updated_by,Trunc(sysdate),
516: Trunc(Sysdate),G_created_by,G_last_update_login
517: FROM dual
518: WHERE NOT EXISTS (select 'X'
519: from pa_project_accum_actuals
520: where project_accum_id = l_project_accum_id
521: );
522:
523: