APPS.PA_SUMMARIZE_ACTUAL_UTIL_PVT dependencies on PA_REP_UTIL_SUMM0_TMP

Line 70: INTO pa_rep_util_summ0_tmp

66: -- Starts here
67: --
68:
69: INSERT
70: INTO pa_rep_util_summ0_tmp
71: ( row_id
72: , parent_row_id
73: , expenditure_organization_id
74: , person_id

Line 304: FROM pa_rep_util_summ0_tmp

300: WHERE util_summarized_flag = 'N' AND
301: NVL(org_id,-99) = l_org_id
302: AND ROWID IN (
303: SELECT row_id
304: FROM pa_rep_util_summ0_tmp
305: )
306: RETURNING ROWID BULK COLLECT INTO l_cdl_rowid_tab;
307:
308: l_records_updated := SQL%ROWCOUNT;

Line 313: * (FILTER - based on the PA_REP_UTIL_SUMM0_TMP.delete_flag).

309: /*
310: * Check if the all records (in CDL) corresponding to the
311: * records in temp0 have been updated with util_summarized_flag = NULL
312: * if YES, process_method = 'A' ( ALL) ELSE process_method = 'F'
313: * (FILTER - based on the PA_REP_UTIL_SUMM0_TMP.delete_flag).
314: *
315: * The delete flag in pa_rep_util_summ0_tmp is initialized
316: * to 'Y' when inserted. But if updation of util_summarized_flag = 'S'
317: * goes through fine for those records, then those records

Line 315: * The delete flag in pa_rep_util_summ0_tmp is initialized

311: * records in temp0 have been updated with util_summarized_flag = NULL
312: * if YES, process_method = 'A' ( ALL) ELSE process_method = 'F'
313: * (FILTER - based on the PA_REP_UTIL_SUMM0_TMP.delete_flag).
314: *
315: * The delete flag in pa_rep_util_summ0_tmp is initialized
316: * to 'Y' when inserted. But if updation of util_summarized_flag = 'S'
317: * goes through fine for those records, then those records
318: * are updated to delete_flag = 'N' - meaning that, those
319: * records SHOULD processed and hence to be considered as

Line 333: UPDATE pa_rep_util_summ0_tmp tmp1

329: l_process_method := 'A';
330: IF (l_records_updated < l_records_inserted AND l_cdl_rowid_tab.COUNT > 0 ) THEN /* Added second condition 2084888 */
331: l_process_method := 'F';
332: FORALL i IN l_cdl_rowid_tab.FIRST .. l_cdl_rowid_tab.LAST
333: UPDATE pa_rep_util_summ0_tmp tmp1
334: SET tmp1.delete_flag = 'N'
335: WHERE tmp1.row_id = l_cdl_rowid_tab(i);
336: END IF;
337: /*

Line 383: FROM pa_rep_util_summ0_tmp

379: ,program_update_date = l_program_update_date
380: WHERE util_summarized_flag = 'S' -- Do we require this?
381: AND NVL(org_id,-99) = l_org_id -- Do we require this?
382: AND ROWID IN ( SELECT row_id
383: FROM pa_rep_util_summ0_tmp
384: WHERE delete_flag = 'N'
385: );
386: ELSIF l_process_method = 'A' THEN
387: UPDATE pa_cost_distribution_lines_all

Line 397: FROM pa_rep_util_summ0_tmp

393: ,program_update_date = l_program_update_date
394: WHERE util_summarized_flag = 'S' -- Do we require this?
395: AND NVL(org_id,-99) = l_org_id -- Do we require this?
396: AND ROWID IN ( SELECT row_id
397: FROM pa_rep_util_summ0_tmp
398: );
399: END IF;
400:
401: /*

Line 406: WHERE row_id IN (SELECT row_id FROM pa_rep_util_summ0_tmp);

402: * delete the processed data from the intitial temporary workspace
403: */
404:
405: DELETE FROM pa_rep_util_summ00_tmp
406: WHERE row_id IN (SELECT row_id FROM pa_rep_util_summ0_tmp);
407:
408:
409: IF l_debug ='Y'THEN -- bug 2674619
410: PA_DEBUG.g_err_stage := '500: After updating PA_CDL.UTIL_SUMM_FLAG to Y';