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 210: Pa_Accum_Utils.get_impl_option

206: ELSE
207: Pa_Proj_Accum_Main.x_commit_size := 500;
208: END IF;
209:
210: Pa_Accum_Utils.get_impl_option
211: (x_impl_option,
212: x_err_stack,
213: x_err_stage,
214: x_err_code);

Line 224: Pa_Accum_Utils.get_current_period_info

220:
221:
222: -- Get the information pertaining to the Current PA PERIOD
223:
224: Pa_Accum_Utils.get_current_period_info
225: (x_current_pa_period,
226: x_current_gl_period,
227: x_current_pa_start_date,
228: x_current_pa_end_date,

Line 238: Pa_Accum_Utils.g_current_pa_period := x_current_pa_period ;

234: x_err_code);
235: -- Caching pa_period and gl_period names,
236: -- to be used in the view pa_commitment_txns_v
237:
238: Pa_Accum_Utils.g_current_pa_period := x_current_pa_period ;
239: Pa_Accum_Utils.g_current_gl_period := x_current_gl_period ;
240:
241: -- Getting current period year's start and end dates
242:

Line 239: Pa_Accum_Utils.g_current_gl_period := x_current_gl_period ;

235: -- Caching pa_period and gl_period names,
236: -- to be used in the view pa_commitment_txns_v
237:
238: Pa_Accum_Utils.g_current_pa_period := x_current_pa_period ;
239: Pa_Accum_Utils.g_current_gl_period := x_current_gl_period ;
240:
241: -- Getting current period year's start and end dates
242:
243: Pa_Accum_Utils.Get_period_year_Info

Line 243: Pa_Accum_Utils.Get_period_year_Info

239: Pa_Accum_Utils.g_current_gl_period := x_current_gl_period ;
240:
241: -- Getting current period year's start and end dates
242:
243: Pa_Accum_Utils.Get_period_year_Info
244: (x_current_gl_period,
245: x_period_yr_start_date,
246: x_err_stack,
247: x_err_stage,

Line 260: Pa_Accum_Utils.get_pa_period_info1

256: END IF;
257:
258: -- Start for performance bug 3653978
259:
260: Pa_Accum_Utils.get_pa_period_info1
261: (x_impl_option,
262: x_current_pa_start_date,
263: x_current_gl_start_date,
264: x_prev_pa_period,

Line 385: Pa_Accum_Utils.proj_level_record

381: x_proj_level_accum_id := 0;
382:
383: -- Create/Get the Project level header record for this project
384:
385: Pa_Accum_Utils.proj_level_record
386: (x_project_id,
387: x_current_pa_period,
388: x_current_gl_period,
389: x_impl_option,

Line 400: Pa_Accum_Utils.get_pa_period_info

396: -- Get the other details from PA_PERIOD
397: -- (PREVIOUS period,previously accumulated period etc )
398:
399: /* Commented out as part of performance fix 3653978
400: Pa_Accum_Utils.get_pa_period_info
401: (x_impl_option,
402: x_prev_accum_period,
403: x_current_pa_period,
404: x_current_gl_period ,

Line 466: Pa_Accum_Utils.get_pa_period_info2

462: x_prev_accum_start_date := NULL;
463: x_prev_accum_end_date := NULL;
464: x_prev_prev_accum_period := NULL;
465:
466: Pa_Accum_Utils.get_pa_period_info2
467: (x_impl_option,
468: x_prev_accum_period,
469: x_prev_accum_year,
470: x_prev_accum_start_date,

Line 519: Pa_Accum_Utils.get_current_period_info

515: END IF;
516:
517: -- Get the information pertaining to the Current PA PERIOD
518:
519: Pa_Accum_Utils.get_current_period_info
520: (x_new_current_pa_period,
521: x_new_current_gl_period,
522: x_new_current_pa_start_date,
523: x_new_current_pa_end_date,

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

907: SELECT
908: proj.project_id ,
909: proj.segment1 ,proj.project_type
910: FROM pa_projects proj
911: WHERE proj.segment1 BETWEEN pa_accum_utils.Get_project_info('F')
912: AND pa_accum_utils.Get_project_info('T')
913: AND pa_accum_utils.Get_context_info = 'REGULAR'
914: AND NVL(proj.template_flag,'N') <> 'Y'
915: AND proj.segment1 BETWEEN l_project_num_from AND l_project_num_to

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

908: proj.project_id ,
909: proj.segment1 ,proj.project_type
910: FROM pa_projects proj
911: WHERE proj.segment1 BETWEEN pa_accum_utils.Get_project_info('F')
912: AND pa_accum_utils.Get_project_info('T')
913: AND pa_accum_utils.Get_context_info = 'REGULAR'
914: AND NVL(proj.template_flag,'N') <> 'Y'
915: AND proj.segment1 BETWEEN l_project_num_from AND l_project_num_to
916: AND proj.project_type = NVL(x_project_type, project_type)

Line 913: AND pa_accum_utils.Get_context_info = 'REGULAR'

909: proj.segment1 ,proj.project_type
910: FROM pa_projects proj
911: WHERE proj.segment1 BETWEEN pa_accum_utils.Get_project_info('F')
912: AND pa_accum_utils.Get_project_info('T')
913: AND pa_accum_utils.Get_context_info = 'REGULAR'
914: AND NVL(proj.template_flag,'N') <> 'Y'
915: AND proj.segment1 BETWEEN l_project_num_from AND l_project_num_to
916: AND proj.project_type = NVL(x_project_type, project_type)
917: AND NOT EXISTS (SELECT 1

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

924: FROM pa_projects proj
925: WHERE proj.segment1 BETWEEN l_project_num_from AND l_project_num_to
926: AND EXISTS ( select 1 from pa_alloc_txn_details alloc
927: where alloc.project_id = proj.project_id
928: AND alloc.run_id = pa_accum_utils.Get_grouping_id)
929: AND pa_accum_utils.Get_context_info = 'AUTO_ALLOCATION'
930: AND proj.project_type = NVL(x_project_type, project_type)
931: AND NOT EXISTS (SELECT 1
932: FROM pa_projects_for_accum proj_invalid

Line 929: AND pa_accum_utils.Get_context_info = 'AUTO_ALLOCATION'

925: WHERE proj.segment1 BETWEEN l_project_num_from AND l_project_num_to
926: AND EXISTS ( select 1 from pa_alloc_txn_details alloc
927: where alloc.project_id = proj.project_id
928: AND alloc.run_id = pa_accum_utils.Get_grouping_id)
929: AND pa_accum_utils.Get_context_info = 'AUTO_ALLOCATION'
930: AND proj.project_type = NVL(x_project_type, project_type)
931: AND NOT EXISTS (SELECT 1
932: FROM pa_projects_for_accum proj_invalid
933: WHERE proj_invalid.project_id = proj.project_id

Line 1021: Pa_Accum_Utils.G_start_proj := l_project_num_from;

1017: END IF ;
1018:
1019: -- Value for Global variables G_start_proj, G_end_proj, G_context
1020: -- and G_grouping_id being set
1021: Pa_Accum_Utils.G_start_proj := l_project_num_from;
1022: Pa_Accum_Utils.G_end_proj := l_project_num_to;
1023: Pa_Accum_Utils.G_context := x_summ_context;
1024: Pa_Accum_Utils.G_grouping_id := x_grouping_id;
1025:

Line 1022: Pa_Accum_Utils.G_end_proj := l_project_num_to;

1018:
1019: -- Value for Global variables G_start_proj, G_end_proj, G_context
1020: -- and G_grouping_id being set
1021: Pa_Accum_Utils.G_start_proj := l_project_num_from;
1022: Pa_Accum_Utils.G_end_proj := l_project_num_to;
1023: Pa_Accum_Utils.G_context := x_summ_context;
1024: Pa_Accum_Utils.G_grouping_id := x_grouping_id;
1025:
1026: -- inserts records onto pa_projects_for_accum

Line 1023: Pa_Accum_Utils.G_context := x_summ_context;

1019: -- Value for Global variables G_start_proj, G_end_proj, G_context
1020: -- and G_grouping_id being set
1021: Pa_Accum_Utils.G_start_proj := l_project_num_from;
1022: Pa_Accum_Utils.G_end_proj := l_project_num_to;
1023: Pa_Accum_Utils.G_context := x_summ_context;
1024: Pa_Accum_Utils.G_grouping_id := x_grouping_id;
1025:
1026: -- inserts records onto pa_projects_for_accum
1027:

Line 1024: Pa_Accum_Utils.G_grouping_id := x_grouping_id;

1020: -- and G_grouping_id being set
1021: Pa_Accum_Utils.G_start_proj := l_project_num_from;
1022: Pa_Accum_Utils.G_end_proj := l_project_num_to;
1023: Pa_Accum_Utils.G_context := x_summ_context;
1024: Pa_Accum_Utils.G_grouping_id := x_grouping_id;
1025:
1026: -- inserts records onto pa_projects_for_accum
1027:
1028: BEGIN

Line 1748: Pa_Accum_Utils.update_proj_accum_header

1744: END IF;
1745:
1746: END IF ;
1747:
1748: Pa_Accum_Utils.update_proj_accum_header
1749: (x_proj_level_accum_id,
1750: x_current_period,
1751: x_err_stack,
1752: x_err_stage,

Line 2473: Pa_Accum_Utils.update_proj_accum_header

2469: IF x_log_summ_mode = 'Y' THEN
2470: x_PrcCmtEnd := SYSDATE; /* End time process_txn_accum_cmt */
2471: END IF;
2472:
2473: Pa_Accum_Utils.update_proj_accum_header
2474: (x_proj_level_accum_id,
2475: x_current_period,
2476: x_err_stack,
2477: x_err_stage,

Line 2482: Pa_Accum_Utils.update_tasks_restructured_flag (x_proj_level_accum_id,

2478: x_err_code);
2479:
2480: -- Update the tasks_restructured_flag to 'N'
2481:
2482: Pa_Accum_Utils.update_tasks_restructured_flag (x_proj_level_accum_id,
2483: 'N',
2484: x_err_stack,
2485: x_err_stage,
2486: x_err_code);

Line 3407: Pa_Accum_Utils.update_proj_accum_header

3403: x_system_linkage_function,
3404: x_err_stage,
3405: x_err_code);
3406:
3407: Pa_Accum_Utils.update_proj_accum_header
3408: (x_proj_level_accum_id,
3409: x_current_period,
3410: x_err_stack,
3411: x_err_stage,