APPS.PA_PROJ_ACCUM_MAIN dependencies on PA_PROJECT_ACCUM_HEADERS

Line 612: FROM pa_project_accum_headers

608: BEGIN
609:
610: SELECT DISTINCT accum_period
611: INTO l_prev_accum_period
612: FROM pa_project_accum_headers
613: WHERE project_id = x_project_id
614: AND Task_id = 0
615: AND Resource_List_member_id = 0 ;
616:

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

804: l_current_start_date DATE ;
805: l_current_end_date DATE ;
806: l_project_id NUMBER ;
807: l_segment1 VARCHAR2(25);
808: l_sum_exception_code pa_project_accum_headers.sum_exception_code%TYPE := NULL;
809: l_invalid_proj_cnt NUMBER := 0;
810: tmp_bud_type_code VARCHAR2(30);
811: x_actions_in action_tbl_type ;
812: x_actions_cnt BINARY_INTEGER ;

Line 1108: FROM pa_project_accum_headers pah

1104: WHERE proj.segment1
1105: BETWEEN l_project_num_from AND l_project_num_to
1106: AND proj.project_type = NVL(x_project_type, project_type) --for bug 2543021
1107: AND EXISTS (SELECT 'x'
1108: FROM pa_project_accum_headers pah
1109: WHERE pah.project_id = proj.project_id
1110: AND NVL(pah.tasks_restructured_flag, 'N') = 'Y')
1111: UNION ALL
1112: SELECT proj.project_id, x_request_id request_id,

Line 1279: UPDATE pa_project_accum_headers

1275: Pa_Debug.debug('proj_accum: ' || 'Cannot update summarization exception for project'||
1276: filter_proj.segment1,Pa_Debug.DEBUG_LEVEL_EXCEPTION);
1277: END IF;
1278: ELSE
1279: UPDATE pa_project_accum_headers
1280: SET sum_exception_code = l_sum_exception_code
1281: WHERE project_id = filter_proj.project_id
1282: AND task_id = 0
1283: AND resource_list_member_id = 0;

Line 1371: UPDATE pa_project_accum_headers

1367: l_accum_period_type_changed) ;
1368:
1369: --Bug 5060439. Null out the sum_exception_code. It might have got populated in the
1370: --previous run
1371: UPDATE pa_project_accum_headers
1372: SET sum_exception_code=NULL
1373: WHERE project_accum_id=x_proj_level_accum_id;
1374:
1375:

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

2759: )
2760: IS
2761: P_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N'); /* Added Debug Profile Option variable initialization for bug#2674619 */
2762: l_accum_period_type_changed BOOLEAN;
2763: l_sum_exception_code pa_project_accum_headers.sum_exception_code%TYPE := NULL;
2764: l_current_start_date DATE := NULL;
2765: l_current_end_date DATE := NULL;
2766:
2767: -- Declare cursor for Projects

Line 2883: FROM pa_project_accum_headers pah

2879: SELECT 'Y'
2880: INTO x_tasks_restructured_flag
2881: FROM sys.dual
2882: WHERE EXISTS (SELECT 'x'
2883: FROM pa_project_accum_headers pah
2884: WHERE pah.project_id = projrec.project_id
2885: AND NVL(pah.tasks_restructured_flag,'N') = 'Y');
2886:
2887: IF ( x_tasks_restructured_flag = 'Y') THEN

Line 2912: UPDATE pa_project_accum_headers

2908: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2909: Pa_Debug.debug('ref_rl_accum: ' || 'Cannot update summarization exception for project'||projrec.segment1,Pa_Debug.DEBUG_LEVEL_EXCEPTION);
2910: END IF;
2911: ELSE
2912: UPDATE pa_project_accum_headers
2913: SET sum_exception_code = l_sum_exception_code
2914: WHERE project_id = projrec.project_id
2915: AND task_id = 0
2916: AND resource_list_member_id = 0;

Line 3526: pa_project_accum_headers pah

3522: pah.project_id
3523: INTO
3524: dummy_project_id
3525: FROM
3526: pa_project_accum_headers pah
3527: WHERE
3528: pah.project_id = x_project_id
3529: AND pah.task_id = 0
3530: AND pah.resource_list_id = 0