APPS.PA_ACCUM_UTILS dependencies on PA_PROJECT_ACCUM_ACTUALS

Line 116: INSERT INTO PA_PROJECT_ACCUM_ACTUALS (

112: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
113: pa_debug.debug('Proj_level_record: ' || 'Creating Project Level Header record for Actuals');
114: END IF;
115:
116: INSERT INTO PA_PROJECT_ACCUM_ACTUALS (
117: PROJECT_ACCUM_ID,RAW_COST_ITD,RAW_COST_YTD,RAW_COST_PP,RAW_COST_PTD,
118: BILLABLE_RAW_COST_ITD,BILLABLE_RAW_COST_YTD,BILLABLE_RAW_COST_PP,
119: BILLABLE_RAW_COST_PTD,BURDENED_COST_ITD,BURDENED_COST_YTD,
120: BURDENED_COST_PP,BURDENED_COST_PTD,BILLABLE_BURDENED_COST_ITD,

Line 513: -- PA_PROJECT_ACCUM_ACTUALS table. It is possible

509:
510: -- Check_Actuals_Details - For the given Project,Task and Resource
511: -- combination in the PA_PROJECT_ACCUM_HEADERS table,
512: -- checks for detail records in
513: -- PA_PROJECT_ACCUM_ACTUALS table. It is possible
514: -- that the Headers table might have a record
515: -- but no corresponding detail record. This procedure
516: -- creates the detail records for all the tasks in
517: -- the hierarchy

Line 529: -- corresponding record in PA_PROJECT_ACCUM_ACTUALS.

525: V_Old_Stack Varchar2(630);
526:
527: -- This cursor gets the Accum_id for the given Project,Task and Resource
528: -- combination which has a record in PA_PROJECT_ACCUM_HEADERS but no
529: -- corresponding record in PA_PROJECT_ACCUM_ACTUALS.
530:
531: CURSOR Get_Accum_Id_Cur is
532: Select Project_accum_id
533: FROM

Line 541: PA_PROJECT_ACCUM_ACTUALS paa

537: and RESOURCE_LIST_MEMBER_ID = x_resource_list_member_id
538: and not exists
539: (Select Project_accum_id
540: from
541: PA_PROJECT_ACCUM_ACTUALS paa
542: where paa.project_accum_id = pah.project_accum_id);
543:
544: Begin
545: V_Old_Stack := x_err_stack;

Line 555: Insert into PA_PROJECT_ACCUM_ACTUALS (

551: -- If we get such a record in Headers, then we insert one record in
552: -- the Actuals Detail table
553:
554: If Get_Accum_Id_Cur%FOUND Then
555: Insert into PA_PROJECT_ACCUM_ACTUALS (
556: PROJECT_ACCUM_ID,RAW_COST_ITD,RAW_COST_YTD,RAW_COST_PP,RAW_COST_PTD,
557: BILLABLE_RAW_COST_ITD,BILLABLE_RAW_COST_YTD,BILLABLE_RAW_COST_PP,
558: BILLABLE_RAW_COST_PTD,BURDENED_COST_ITD,BURDENED_COST_YTD,
559: BURDENED_COST_PP,BURDENED_COST_PTD,BILLABLE_BURDENED_COST_ITD,

Line 605: Insert into PA_PROJECT_ACCUM_ACTUALS (

601: -- tasks, if they have not been created.
602:
603: IF v_noof_tasks > 0 then
604: FOR i in 1..v_noof_tasks LOOP
605: Insert into PA_PROJECT_ACCUM_ACTUALS (
606: PROJECT_ACCUM_ID,RAW_COST_ITD,RAW_COST_YTD,RAW_COST_PP,RAW_COST_PTD,
607: BILLABLE_RAW_COST_ITD,BILLABLE_RAW_COST_YTD,BILLABLE_RAW_COST_PP,
608: BILLABLE_RAW_COST_PTD,BURDENED_COST_ITD,BURDENED_COST_YTD,
609: BURDENED_COST_PP,BURDENED_COST_PTD,BILLABLE_BURDENED_COST_ITD,

Line 632: PA_PROJECT_ACCUM_ACTUALS PAA

628: and Resource_list_member_id = x_Resource_list_member_id
629: and Not Exists
630: (Select 'x'
631: from
632: PA_PROJECT_ACCUM_ACTUALS PAA
633: Where
634: PAH.PROJECT_ACCUM_ID = PAA.PROJECT_ACCUM_ID);
635: v_recs_processed := V_recs_processed + 1;
636: END LOOP; -- (i in 1..v_noof_tasks LOOP )