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_SUMMARIZE_ACTUAL_UTIL_PVT dependencies on PA_REP_UTIL_GLOB

Line 9: l_bal_type_actual VARCHAR2(15) := pa_rep_util_glob.G_BAL_TYPE_C.G_ACTUALS_C;

5: * The contents of the global variables - used throughout this
6: * package are stored in local variables - so that we dont
7: * hit the global package each time.
8: */
9: l_bal_type_actual VARCHAR2(15) := pa_rep_util_glob.G_BAL_TYPE_C.G_ACTUALS_C;
10: /*
11: * Input Parameters.
12: */
13: l_ac_start_date DATE := pa_rep_util_glob.G_input_parameters.G_ac_start_date;

Line 13: l_ac_start_date DATE := pa_rep_util_glob.G_input_parameters.G_ac_start_date;

9: l_bal_type_actual VARCHAR2(15) := pa_rep_util_glob.G_BAL_TYPE_C.G_ACTUALS_C;
10: /*
11: * Input Parameters.
12: */
13: l_ac_start_date DATE := pa_rep_util_glob.G_input_parameters.G_ac_start_date;
14: l_ac_end_date DATE := pa_rep_util_glob.G_input_parameters.G_ac_end_date;
15: /*
16: * Utilization Option details.
17: */

Line 14: l_ac_end_date DATE := pa_rep_util_glob.G_input_parameters.G_ac_end_date;

10: /*
11: * Input Parameters.
12: */
13: l_ac_start_date DATE := pa_rep_util_glob.G_input_parameters.G_ac_start_date;
14: l_ac_end_date DATE := pa_rep_util_glob.G_input_parameters.G_ac_end_date;
15: /*
16: * Utilization Option details.
17: */
18: l_actuals_thru_date pa_utilization_options.actuals_thru_date%TYPE := pa_rep_util_glob.G_util_option_details.G_actuals_thru_date;

Line 18: l_actuals_thru_date pa_utilization_options.actuals_thru_date%TYPE := pa_rep_util_glob.G_util_option_details.G_actuals_thru_date;

14: l_ac_end_date DATE := pa_rep_util_glob.G_input_parameters.G_ac_end_date;
15: /*
16: * Utilization Option details.
17: */
18: l_actuals_thru_date pa_utilization_options.actuals_thru_date%TYPE := pa_rep_util_glob.G_util_option_details.G_actuals_thru_date;
19: l_pa_period_flag pa_utilization_options.pa_period_flag%TYPE := pa_rep_util_glob.G_util_option_details.G_pa_period_flag;
20: l_gl_period_flag pa_utilization_options.gl_period_flag%TYPE := pa_rep_util_glob.G_util_option_details.G_gl_period_flag;
21: l_ge_period_flag pa_utilization_options.global_exp_period_flag%TYPE := pa_rep_util_glob.G_util_option_details.G_ge_period_flag;
22: /*

Line 19: l_pa_period_flag pa_utilization_options.pa_period_flag%TYPE := pa_rep_util_glob.G_util_option_details.G_pa_period_flag;

15: /*
16: * Utilization Option details.
17: */
18: l_actuals_thru_date pa_utilization_options.actuals_thru_date%TYPE := pa_rep_util_glob.G_util_option_details.G_actuals_thru_date;
19: l_pa_period_flag pa_utilization_options.pa_period_flag%TYPE := pa_rep_util_glob.G_util_option_details.G_pa_period_flag;
20: l_gl_period_flag pa_utilization_options.gl_period_flag%TYPE := pa_rep_util_glob.G_util_option_details.G_gl_period_flag;
21: l_ge_period_flag pa_utilization_options.global_exp_period_flag%TYPE := pa_rep_util_glob.G_util_option_details.G_ge_period_flag;
22: /*
23: * Implementation.

Line 20: l_gl_period_flag pa_utilization_options.gl_period_flag%TYPE := pa_rep_util_glob.G_util_option_details.G_gl_period_flag;

16: * Utilization Option details.
17: */
18: l_actuals_thru_date pa_utilization_options.actuals_thru_date%TYPE := pa_rep_util_glob.G_util_option_details.G_actuals_thru_date;
19: l_pa_period_flag pa_utilization_options.pa_period_flag%TYPE := pa_rep_util_glob.G_util_option_details.G_pa_period_flag;
20: l_gl_period_flag pa_utilization_options.gl_period_flag%TYPE := pa_rep_util_glob.G_util_option_details.G_gl_period_flag;
21: l_ge_period_flag pa_utilization_options.global_exp_period_flag%TYPE := pa_rep_util_glob.G_util_option_details.G_ge_period_flag;
22: /*
23: * Implementation.
24: */

Line 21: l_ge_period_flag pa_utilization_options.global_exp_period_flag%TYPE := pa_rep_util_glob.G_util_option_details.G_ge_period_flag;

17: */
18: l_actuals_thru_date pa_utilization_options.actuals_thru_date%TYPE := pa_rep_util_glob.G_util_option_details.G_actuals_thru_date;
19: l_pa_period_flag pa_utilization_options.pa_period_flag%TYPE := pa_rep_util_glob.G_util_option_details.G_pa_period_flag;
20: l_gl_period_flag pa_utilization_options.gl_period_flag%TYPE := pa_rep_util_glob.G_util_option_details.G_gl_period_flag;
21: l_ge_period_flag pa_utilization_options.global_exp_period_flag%TYPE := pa_rep_util_glob.G_util_option_details.G_ge_period_flag;
22: /*
23: * Implementation.
24: */
25: l_org_id pa_implementations.org_id%TYPE := pa_rep_util_glob.G_implementation_details.G_org_id;

Line 25: l_org_id pa_implementations.org_id%TYPE := pa_rep_util_glob.G_implementation_details.G_org_id;

21: l_ge_period_flag pa_utilization_options.global_exp_period_flag%TYPE := pa_rep_util_glob.G_util_option_details.G_ge_period_flag;
22: /*
23: * Implementation.
24: */
25: l_org_id pa_implementations.org_id%TYPE := pa_rep_util_glob.G_implementation_details.G_org_id;
26: /*
27: * Profile Options.
28: */
29: l_global_week_start_day PLS_INTEGER := pa_rep_util_glob.G_global_week_start_day;

Line 29: l_global_week_start_day PLS_INTEGER := pa_rep_util_glob.G_global_week_start_day;

25: l_org_id pa_implementations.org_id%TYPE := pa_rep_util_glob.G_implementation_details.G_org_id;
26: /*
27: * Profile Options.
28: */
29: l_global_week_start_day PLS_INTEGER := pa_rep_util_glob.G_global_week_start_day;
30: l_fetch_size PLS_INTEGER := pa_rep_util_glob.G_util_fetch_size;
31:
32: /*
33: * Period Information.

Line 30: l_fetch_size PLS_INTEGER := pa_rep_util_glob.G_util_fetch_size;

26: /*
27: * Profile Options.
28: */
29: l_global_week_start_day PLS_INTEGER := pa_rep_util_glob.G_global_week_start_day;
30: l_fetch_size PLS_INTEGER := pa_rep_util_glob.G_util_fetch_size;
31:
32: /*
33: * Period Information.
34: */

Line 35: -- l_period_set_name gl_sets_of_books.period_set_name%TYPE := pa_rep_util_glob.G_implementation_details.G_period_set_name;

31:
32: /*
33: * Period Information.
34: */
35: -- l_period_set_name gl_sets_of_books.period_set_name%TYPE := pa_rep_util_glob.G_implementation_details.G_period_set_name;
36: l_gl_period_set_name gl_sets_of_books.period_set_name%TYPE := pa_rep_util_glob.G_implementation_details.G_gl_period_set_name; -- bug 3434019
37: l_pa_period_set_name gl_sets_of_books.period_set_name%TYPE := pa_rep_util_glob.G_implementation_details.G_pa_period_set_name; -- bug 3434019
38: l_pa_period_type pa_implementations.pa_period_type%TYPE := pa_rep_util_glob.G_implementation_details.G_pa_period_type;
39: l_gl_period_type gl_sets_of_books.accounted_period_type%TYPE := pa_rep_util_glob.G_implementation_details.G_gl_period_type;

Line 36: l_gl_period_set_name gl_sets_of_books.period_set_name%TYPE := pa_rep_util_glob.G_implementation_details.G_gl_period_set_name; -- bug 3434019

32: /*
33: * Period Information.
34: */
35: -- l_period_set_name gl_sets_of_books.period_set_name%TYPE := pa_rep_util_glob.G_implementation_details.G_period_set_name;
36: l_gl_period_set_name gl_sets_of_books.period_set_name%TYPE := pa_rep_util_glob.G_implementation_details.G_gl_period_set_name; -- bug 3434019
37: l_pa_period_set_name gl_sets_of_books.period_set_name%TYPE := pa_rep_util_glob.G_implementation_details.G_pa_period_set_name; -- bug 3434019
38: l_pa_period_type pa_implementations.pa_period_type%TYPE := pa_rep_util_glob.G_implementation_details.G_pa_period_type;
39: l_gl_period_type gl_sets_of_books.accounted_period_type%TYPE := pa_rep_util_glob.G_implementation_details.G_gl_period_type;
40: /*

Line 37: l_pa_period_set_name gl_sets_of_books.period_set_name%TYPE := pa_rep_util_glob.G_implementation_details.G_pa_period_set_name; -- bug 3434019

33: * Period Information.
34: */
35: -- l_period_set_name gl_sets_of_books.period_set_name%TYPE := pa_rep_util_glob.G_implementation_details.G_period_set_name;
36: l_gl_period_set_name gl_sets_of_books.period_set_name%TYPE := pa_rep_util_glob.G_implementation_details.G_gl_period_set_name; -- bug 3434019
37: l_pa_period_set_name gl_sets_of_books.period_set_name%TYPE := pa_rep_util_glob.G_implementation_details.G_pa_period_set_name; -- bug 3434019
38: l_pa_period_type pa_implementations.pa_period_type%TYPE := pa_rep_util_glob.G_implementation_details.G_pa_period_type;
39: l_gl_period_type gl_sets_of_books.accounted_period_type%TYPE := pa_rep_util_glob.G_implementation_details.G_gl_period_type;
40: /*
41: * Who Columns.

Line 38: l_pa_period_type pa_implementations.pa_period_type%TYPE := pa_rep_util_glob.G_implementation_details.G_pa_period_type;

34: */
35: -- l_period_set_name gl_sets_of_books.period_set_name%TYPE := pa_rep_util_glob.G_implementation_details.G_period_set_name;
36: l_gl_period_set_name gl_sets_of_books.period_set_name%TYPE := pa_rep_util_glob.G_implementation_details.G_gl_period_set_name; -- bug 3434019
37: l_pa_period_set_name gl_sets_of_books.period_set_name%TYPE := pa_rep_util_glob.G_implementation_details.G_pa_period_set_name; -- bug 3434019
38: l_pa_period_type pa_implementations.pa_period_type%TYPE := pa_rep_util_glob.G_implementation_details.G_pa_period_type;
39: l_gl_period_type gl_sets_of_books.accounted_period_type%TYPE := pa_rep_util_glob.G_implementation_details.G_gl_period_type;
40: /*
41: * Who Columns.
42: */

Line 39: l_gl_period_type gl_sets_of_books.accounted_period_type%TYPE := pa_rep_util_glob.G_implementation_details.G_gl_period_type;

35: -- l_period_set_name gl_sets_of_books.period_set_name%TYPE := pa_rep_util_glob.G_implementation_details.G_period_set_name;
36: l_gl_period_set_name gl_sets_of_books.period_set_name%TYPE := pa_rep_util_glob.G_implementation_details.G_gl_period_set_name; -- bug 3434019
37: l_pa_period_set_name gl_sets_of_books.period_set_name%TYPE := pa_rep_util_glob.G_implementation_details.G_pa_period_set_name; -- bug 3434019
38: l_pa_period_type pa_implementations.pa_period_type%TYPE := pa_rep_util_glob.G_implementation_details.G_pa_period_type;
39: l_gl_period_type gl_sets_of_books.accounted_period_type%TYPE := pa_rep_util_glob.G_implementation_details.G_gl_period_type;
40: /*
41: * Who Columns.
42: */
43: l_created_by NUMBER(15) := pa_rep_util_glob.G_who_columns.G_created_by;

Line 43: l_created_by NUMBER(15) := pa_rep_util_glob.G_who_columns.G_created_by;

39: l_gl_period_type gl_sets_of_books.accounted_period_type%TYPE := pa_rep_util_glob.G_implementation_details.G_gl_period_type;
40: /*
41: * Who Columns.
42: */
43: l_created_by NUMBER(15) := pa_rep_util_glob.G_who_columns.G_created_by;
44: l_request_id NUMBER(15) := pa_rep_util_glob.G_who_columns.G_request_id;
45: l_program_id NUMBER(15) := pa_rep_util_glob.G_who_columns.G_program_id;
46: l_program_application_id NUMBER(15) := pa_rep_util_glob.G_who_columns.G_program_application_id;
47: l_creation_date DATE := pa_rep_util_glob.G_who_columns.G_creation_date;

Line 44: l_request_id NUMBER(15) := pa_rep_util_glob.G_who_columns.G_request_id;

40: /*
41: * Who Columns.
42: */
43: l_created_by NUMBER(15) := pa_rep_util_glob.G_who_columns.G_created_by;
44: l_request_id NUMBER(15) := pa_rep_util_glob.G_who_columns.G_request_id;
45: l_program_id NUMBER(15) := pa_rep_util_glob.G_who_columns.G_program_id;
46: l_program_application_id NUMBER(15) := pa_rep_util_glob.G_who_columns.G_program_application_id;
47: l_creation_date DATE := pa_rep_util_glob.G_who_columns.G_creation_date;
48: l_program_update_date DATE := pa_rep_util_glob.G_who_columns.G_last_update_date;

Line 45: l_program_id NUMBER(15) := pa_rep_util_glob.G_who_columns.G_program_id;

41: * Who Columns.
42: */
43: l_created_by NUMBER(15) := pa_rep_util_glob.G_who_columns.G_created_by;
44: l_request_id NUMBER(15) := pa_rep_util_glob.G_who_columns.G_request_id;
45: l_program_id NUMBER(15) := pa_rep_util_glob.G_who_columns.G_program_id;
46: l_program_application_id NUMBER(15) := pa_rep_util_glob.G_who_columns.G_program_application_id;
47: l_creation_date DATE := pa_rep_util_glob.G_who_columns.G_creation_date;
48: l_program_update_date DATE := pa_rep_util_glob.G_who_columns.G_last_update_date;
49: l_debug varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');

Line 46: l_program_application_id NUMBER(15) := pa_rep_util_glob.G_who_columns.G_program_application_id;

42: */
43: l_created_by NUMBER(15) := pa_rep_util_glob.G_who_columns.G_created_by;
44: l_request_id NUMBER(15) := pa_rep_util_glob.G_who_columns.G_request_id;
45: l_program_id NUMBER(15) := pa_rep_util_glob.G_who_columns.G_program_id;
46: l_program_application_id NUMBER(15) := pa_rep_util_glob.G_who_columns.G_program_application_id;
47: l_creation_date DATE := pa_rep_util_glob.G_who_columns.G_creation_date;
48: l_program_update_date DATE := pa_rep_util_glob.G_who_columns.G_last_update_date;
49: l_debug varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
50:

Line 47: l_creation_date DATE := pa_rep_util_glob.G_who_columns.G_creation_date;

43: l_created_by NUMBER(15) := pa_rep_util_glob.G_who_columns.G_created_by;
44: l_request_id NUMBER(15) := pa_rep_util_glob.G_who_columns.G_request_id;
45: l_program_id NUMBER(15) := pa_rep_util_glob.G_who_columns.G_program_id;
46: l_program_application_id NUMBER(15) := pa_rep_util_glob.G_who_columns.G_program_application_id;
47: l_creation_date DATE := pa_rep_util_glob.G_who_columns.G_creation_date;
48: l_program_update_date DATE := pa_rep_util_glob.G_who_columns.G_last_update_date;
49: l_debug varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
50:
51: -------------------------------------------------------

Line 48: l_program_update_date DATE := pa_rep_util_glob.G_who_columns.G_last_update_date;

44: l_request_id NUMBER(15) := pa_rep_util_glob.G_who_columns.G_request_id;
45: l_program_id NUMBER(15) := pa_rep_util_glob.G_who_columns.G_program_id;
46: l_program_application_id NUMBER(15) := pa_rep_util_glob.G_who_columns.G_program_application_id;
47: l_creation_date DATE := pa_rep_util_glob.G_who_columns.G_creation_date;
48: l_program_update_date DATE := pa_rep_util_glob.G_who_columns.G_last_update_date;
49: l_debug varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
50:
51: -------------------------------------------------------
52:

Line 416: IF pa_rep_util_glob.G_input_parameters.G_org_rollup_method = 'R' THEN

412: END IF;
413:
414: COMMIT;
415: END LOOP;
416: IF pa_rep_util_glob.G_input_parameters.G_org_rollup_method = 'R' THEN
417:
418: IF l_debug ='Y'THEN -- bug 2674619
419: PA_DEBUG.g_err_stage := '510: Before calling Rollup if rollup method is R';
420: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);