eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_PROJ_ACCUM_MAIN dependencies on PA_ACCUM_UTILS

Line 215: Pa_Accum_Utils.get_impl_option

211: ELSE
212: Pa_Proj_Accum_Main.x_commit_size := 500;
213: END IF;
214:
215: Pa_Accum_Utils.get_impl_option
216: (x_impl_option,
217: x_err_stack,
218: x_err_stage,
219: x_err_code);

Line 229: Pa_Accum_Utils.get_current_period_info

225:
226:
227: -- Get the information pertaining to the Current PA PERIOD
228:
229: Pa_Accum_Utils.get_current_period_info
230: (x_current_pa_period,
231: x_current_gl_period,
232: x_current_pa_start_date,
233: x_current_pa_end_date,

Line 243: Pa_Accum_Utils.g_current_pa_period := x_current_pa_period ;

239: x_err_code);
240: -- Caching pa_period and gl_period names,
241: -- to be used in the view pa_commitment_txns_v
242:
243: Pa_Accum_Utils.g_current_pa_period := x_current_pa_period ;
244: Pa_Accum_Utils.g_current_gl_period := x_current_gl_period ;
245:
246: -- Getting current period year's start and end dates
247:

Line 244: Pa_Accum_Utils.g_current_gl_period := x_current_gl_period ;

240: -- Caching pa_period and gl_period names,
241: -- to be used in the view pa_commitment_txns_v
242:
243: Pa_Accum_Utils.g_current_pa_period := x_current_pa_period ;
244: Pa_Accum_Utils.g_current_gl_period := x_current_gl_period ;
245:
246: -- Getting current period year's start and end dates
247:
248: Pa_Accum_Utils.Get_period_year_Info

Line 248: Pa_Accum_Utils.Get_period_year_Info

244: Pa_Accum_Utils.g_current_gl_period := x_current_gl_period ;
245:
246: -- Getting current period year's start and end dates
247:
248: Pa_Accum_Utils.Get_period_year_Info
249: (x_current_gl_period,
250: x_period_yr_start_date,
251: x_err_stack,
252: x_err_stage,

Line 265: Pa_Accum_Utils.get_pa_period_info1

261: END IF;
262:
263: -- Start for performance bug 3653978
264:
265: Pa_Accum_Utils.get_pa_period_info1
266: (x_impl_option,
267: x_current_pa_start_date,
268: x_current_gl_start_date,
269: x_prev_pa_period,

Line 390: Pa_Accum_Utils.proj_level_record

386: x_proj_level_accum_id := 0;
387:
388: -- Create/Get the Project level header record for this project
389:
390: Pa_Accum_Utils.proj_level_record
391: (x_project_id,
392: x_current_pa_period,
393: x_current_gl_period,
394: x_impl_option,

Line 405: Pa_Accum_Utils.get_pa_period_info

401: -- Get the other details from PA_PERIOD
402: -- (PREVIOUS period,previously accumulated period etc )
403:
404: /* Commented out as part of performance fix 3653978
405: Pa_Accum_Utils.get_pa_period_info
406: (x_impl_option,
407: x_prev_accum_period,
408: x_current_pa_period,
409: x_current_gl_period ,

Line 471: Pa_Accum_Utils.get_pa_period_info2

467: x_prev_accum_start_date := NULL;
468: x_prev_accum_end_date := NULL;
469: x_prev_prev_accum_period := NULL;
470:
471: Pa_Accum_Utils.get_pa_period_info2
472: (x_impl_option,
473: x_prev_accum_period,
474: x_prev_accum_year,
475: x_prev_accum_start_date,

Line 524: Pa_Accum_Utils.get_current_period_info

520: END IF;
521:
522: -- Get the information pertaining to the Current PA PERIOD
523:
524: Pa_Accum_Utils.get_current_period_info
525: (x_new_current_pa_period,
526: x_new_current_gl_period,
527: x_new_current_pa_start_date,
528: x_new_current_pa_end_date,

Line 941: WHERE proj.segment1 BETWEEN pa_accum_utils.Get_project_info('F')

937: SELECT
938: proj.project_id ,
939: proj.segment1 ,proj.project_type
940: FROM pa_projects proj
941: WHERE proj.segment1 BETWEEN pa_accum_utils.Get_project_info('F')
942: AND pa_accum_utils.Get_project_info('T')
943: AND pa_accum_utils.Get_context_info = 'REGULAR'
944: AND NVL(proj.template_flag,'N') <> 'Y'
945: AND NVL(proj.cbs_enable_flag,'N') <> 'Y' --bug#16461684

Line 942: AND pa_accum_utils.Get_project_info('T')

938: proj.project_id ,
939: proj.segment1 ,proj.project_type
940: FROM pa_projects proj
941: WHERE proj.segment1 BETWEEN pa_accum_utils.Get_project_info('F')
942: AND pa_accum_utils.Get_project_info('T')
943: AND pa_accum_utils.Get_context_info = 'REGULAR'
944: AND NVL(proj.template_flag,'N') <> 'Y'
945: AND NVL(proj.cbs_enable_flag,'N') <> 'Y' --bug#16461684
946: AND proj.segment1 BETWEEN l_project_num_from AND l_project_num_to

Line 943: AND pa_accum_utils.Get_context_info = 'REGULAR'

939: proj.segment1 ,proj.project_type
940: FROM pa_projects proj
941: WHERE proj.segment1 BETWEEN pa_accum_utils.Get_project_info('F')
942: AND pa_accum_utils.Get_project_info('T')
943: AND pa_accum_utils.Get_context_info = 'REGULAR'
944: AND NVL(proj.template_flag,'N') <> 'Y'
945: AND NVL(proj.cbs_enable_flag,'N') <> 'Y' --bug#16461684
946: AND proj.segment1 BETWEEN l_project_num_from AND l_project_num_to
947: AND proj.project_type = NVL(x_project_type, project_type)

Line 959: AND alloc.run_id = pa_accum_utils.Get_grouping_id)

955: FROM pa_projects proj
956: WHERE proj.segment1 BETWEEN l_project_num_from AND l_project_num_to
957: AND EXISTS ( select 1 from pa_alloc_txn_details alloc
958: where alloc.project_id = proj.project_id
959: AND alloc.run_id = pa_accum_utils.Get_grouping_id)
960: AND pa_accum_utils.Get_context_info = 'AUTO_ALLOCATION'
961: AND proj.project_type = NVL(x_project_type, project_type)
962: AND NVL(proj.cbs_enable_flag,'N') <> 'Y' --bug#16461684
963: AND NOT EXISTS (SELECT 1

Line 960: AND pa_accum_utils.Get_context_info = 'AUTO_ALLOCATION'

956: WHERE proj.segment1 BETWEEN l_project_num_from AND l_project_num_to
957: AND EXISTS ( select 1 from pa_alloc_txn_details alloc
958: where alloc.project_id = proj.project_id
959: AND alloc.run_id = pa_accum_utils.Get_grouping_id)
960: AND pa_accum_utils.Get_context_info = 'AUTO_ALLOCATION'
961: AND proj.project_type = NVL(x_project_type, project_type)
962: AND NVL(proj.cbs_enable_flag,'N') <> 'Y' --bug#16461684
963: AND NOT EXISTS (SELECT 1
964: FROM pa_projects_for_accum proj_invalid

Line 1053: Pa_Accum_Utils.G_start_proj := l_project_num_from;

1049: END IF ;
1050:
1051: -- Value for Global variables G_start_proj, G_end_proj, G_context
1052: -- and G_grouping_id being set
1053: Pa_Accum_Utils.G_start_proj := l_project_num_from;
1054: Pa_Accum_Utils.G_end_proj := l_project_num_to;
1055: Pa_Accum_Utils.G_context := x_summ_context;
1056: Pa_Accum_Utils.G_grouping_id := x_grouping_id;
1057:

Line 1054: Pa_Accum_Utils.G_end_proj := l_project_num_to;

1050:
1051: -- Value for Global variables G_start_proj, G_end_proj, G_context
1052: -- and G_grouping_id being set
1053: Pa_Accum_Utils.G_start_proj := l_project_num_from;
1054: Pa_Accum_Utils.G_end_proj := l_project_num_to;
1055: Pa_Accum_Utils.G_context := x_summ_context;
1056: Pa_Accum_Utils.G_grouping_id := x_grouping_id;
1057:
1058: -- inserts records onto pa_projects_for_accum

Line 1055: Pa_Accum_Utils.G_context := x_summ_context;

1051: -- Value for Global variables G_start_proj, G_end_proj, G_context
1052: -- and G_grouping_id being set
1053: Pa_Accum_Utils.G_start_proj := l_project_num_from;
1054: Pa_Accum_Utils.G_end_proj := l_project_num_to;
1055: Pa_Accum_Utils.G_context := x_summ_context;
1056: Pa_Accum_Utils.G_grouping_id := x_grouping_id;
1057:
1058: -- inserts records onto pa_projects_for_accum
1059:

Line 1056: Pa_Accum_Utils.G_grouping_id := x_grouping_id;

1052: -- and G_grouping_id being set
1053: Pa_Accum_Utils.G_start_proj := l_project_num_from;
1054: Pa_Accum_Utils.G_end_proj := l_project_num_to;
1055: Pa_Accum_Utils.G_context := x_summ_context;
1056: Pa_Accum_Utils.G_grouping_id := x_grouping_id;
1057:
1058: -- inserts records onto pa_projects_for_accum
1059:
1060: BEGIN

Line 1791: Pa_Accum_Utils.update_proj_accum_header

1787: END IF;
1788:
1789: END IF ;
1790:
1791: Pa_Accum_Utils.update_proj_accum_header
1792: (x_proj_level_accum_id,
1793: x_current_period,
1794: x_err_stack,
1795: x_err_stage,

Line 2536: Pa_Accum_Utils.update_proj_accum_header

2532: IF x_log_summ_mode = 'Y' THEN
2533: x_PrcCmtEnd := SYSDATE; /* End time process_txn_accum_cmt */
2534: END IF;
2535:
2536: Pa_Accum_Utils.update_proj_accum_header
2537: (x_proj_level_accum_id,
2538: x_current_period,
2539: x_err_stack,
2540: x_err_stage,

Line 2545: Pa_Accum_Utils.update_tasks_restructured_flag (x_proj_level_accum_id,

2541: x_err_code);
2542:
2543: -- Update the tasks_restructured_flag to 'N'
2544:
2545: Pa_Accum_Utils.update_tasks_restructured_flag (x_proj_level_accum_id,
2546: 'N',
2547: x_err_stack,
2548: x_err_stage,
2549: x_err_code);

Line 3470: Pa_Accum_Utils.update_proj_accum_header

3466: x_system_linkage_function,
3467: x_err_stage,
3468: x_err_code);
3469:
3470: Pa_Accum_Utils.update_proj_accum_header
3471: (x_proj_level_accum_id,
3472: x_current_period,
3473: x_err_stack,
3474: x_err_stage,