APPS.PA_PROJ_ACCUM_MAIN dependencies on PA_PROJECT_ACCUM_HEADERS

Line 618: FROM pa_project_accum_headers

614: BEGIN
615:
616: SELECT DISTINCT accum_period
617: INTO l_prev_accum_period
618: FROM pa_project_accum_headers
619: WHERE project_id = x_project_id
620: AND Task_id = 0
621: AND Resource_List_member_id = 0 ;
622:

Line 836: l_sum_exception_code pa_project_accum_headers.sum_exception_code%TYPE := NULL;

832: l_current_start_date DATE ;
833: l_current_end_date DATE ;
834: l_project_id NUMBER ;
835: l_segment1 VARCHAR2(25);
836: l_sum_exception_code pa_project_accum_headers.sum_exception_code%TYPE := NULL;
837: l_invalid_proj_cnt NUMBER := 0;
838: tmp_bud_type_code VARCHAR2(30);
839: x_actions_in action_tbl_type ;
840: x_actions_cnt BINARY_INTEGER ;

Line 1145: FROM pa_project_accum_headers pah

1141: BETWEEN l_project_num_from AND l_project_num_to
1142: AND proj.project_type = NVL(x_project_type, project_type) --for bug 2543021
1143: AND PA_ALTERNATE_TASK_PVT.Is_Cbs_Enabled(proj.project_id) = 'N' --bug#16461684
1144: AND EXISTS (SELECT 'x'
1145: FROM pa_project_accum_headers pah
1146: WHERE pah.project_id = proj.project_id
1147: AND NVL(pah.tasks_restructured_flag, 'N') = 'Y')
1148: UNION ALL
1149: SELECT proj.project_id, x_request_id request_id,

Line 1322: UPDATE pa_project_accum_headers

1318: Pa_Debug.debug('proj_accum: ' || 'Cannot update summarization exception for project'||
1319: filter_proj.segment1,Pa_Debug.DEBUG_LEVEL_EXCEPTION);
1320: END IF;
1321: ELSE
1322: UPDATE pa_project_accum_headers
1323: SET sum_exception_code = l_sum_exception_code
1324: WHERE project_id = filter_proj.project_id
1325: AND task_id = 0
1326: AND resource_list_member_id = 0;

Line 1414: UPDATE pa_project_accum_headers

1410: l_accum_period_type_changed) ;
1411:
1412: --Bug 5060439. Null out the sum_exception_code. It might have got populated in the
1413: --previous run
1414: UPDATE pa_project_accum_headers
1415: SET sum_exception_code=NULL
1416: WHERE project_accum_id=x_proj_level_accum_id;
1417:
1418:

Line 2826: l_sum_exception_code pa_project_accum_headers.sum_exception_code%TYPE := NULL;

2822: )
2823: IS
2824: P_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N'); /* Added Debug Profile Option variable initialization for bug#2674619 */
2825: l_accum_period_type_changed BOOLEAN;
2826: l_sum_exception_code pa_project_accum_headers.sum_exception_code%TYPE := NULL;
2827: l_current_start_date DATE := NULL;
2828: l_current_end_date DATE := NULL;
2829:
2830: -- Declare cursor for Projects

Line 2946: FROM pa_project_accum_headers pah

2942: SELECT 'Y'
2943: INTO x_tasks_restructured_flag
2944: FROM sys.dual
2945: WHERE EXISTS (SELECT 'x'
2946: FROM pa_project_accum_headers pah
2947: WHERE pah.project_id = projrec.project_id
2948: AND NVL(pah.tasks_restructured_flag,'N') = 'Y');
2949:
2950: IF ( x_tasks_restructured_flag = 'Y') THEN

Line 2975: UPDATE pa_project_accum_headers

2971: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2972: Pa_Debug.debug('ref_rl_accum: ' || 'Cannot update summarization exception for project'||projrec.segment1,Pa_Debug.DEBUG_LEVEL_EXCEPTION);
2973: END IF;
2974: ELSE
2975: UPDATE pa_project_accum_headers
2976: SET sum_exception_code = l_sum_exception_code
2977: WHERE project_id = projrec.project_id
2978: AND task_id = 0
2979: AND resource_list_member_id = 0;

Line 3589: pa_project_accum_headers pah

3585: pah.project_id
3586: INTO
3587: dummy_project_id
3588: FROM
3589: pa_project_accum_headers pah
3590: WHERE
3591: pah.project_id = x_project_id
3592: AND pah.task_id = 0
3593: AND pah.resource_list_id = 0