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

Line 15: l_org_c VARCHAR2(15) := PA_REP_UTIL_GLOB.G_OBJ_TYPE_C.G_ORG_C;

11:
12: /*
13: * Cache all object types for insert.
14: */
15: l_org_c VARCHAR2(15) := PA_REP_UTIL_GLOB.G_OBJ_TYPE_C.G_ORG_C;
16: l_orguc_c VARCHAR2(15) := PA_REP_UTIL_GLOB.G_OBJ_TYPE_C.G_ORGUC_C;
17: l_orgwt_c VARCHAR2(15) := PA_REP_UTIL_GLOB.G_OBJ_TYPE_C.G_ORGWT_C;
18: l_res_c VARCHAR2(15) := PA_REP_UTIL_GLOB.G_OBJ_TYPE_C.G_RES_C;
19: l_resuco_c VARCHAR2(15) := PA_REP_UTIL_GLOB.G_OBJ_TYPE_C.G_RESUCO_C;

Line 16: l_orguc_c VARCHAR2(15) := PA_REP_UTIL_GLOB.G_OBJ_TYPE_C.G_ORGUC_C;

12: /*
13: * Cache all object types for insert.
14: */
15: l_org_c VARCHAR2(15) := PA_REP_UTIL_GLOB.G_OBJ_TYPE_C.G_ORG_C;
16: l_orguc_c VARCHAR2(15) := PA_REP_UTIL_GLOB.G_OBJ_TYPE_C.G_ORGUC_C;
17: l_orgwt_c VARCHAR2(15) := PA_REP_UTIL_GLOB.G_OBJ_TYPE_C.G_ORGWT_C;
18: l_res_c VARCHAR2(15) := PA_REP_UTIL_GLOB.G_OBJ_TYPE_C.G_RES_C;
19: l_resuco_c VARCHAR2(15) := PA_REP_UTIL_GLOB.G_OBJ_TYPE_C.G_RESUCO_C;
20: l_resucr_c VARCHAR2(15) := PA_REP_UTIL_GLOB.G_OBJ_TYPE_C.G_RESUCR_C;

Line 17: l_orgwt_c VARCHAR2(15) := PA_REP_UTIL_GLOB.G_OBJ_TYPE_C.G_ORGWT_C;

13: * Cache all object types for insert.
14: */
15: l_org_c VARCHAR2(15) := PA_REP_UTIL_GLOB.G_OBJ_TYPE_C.G_ORG_C;
16: l_orguc_c VARCHAR2(15) := PA_REP_UTIL_GLOB.G_OBJ_TYPE_C.G_ORGUC_C;
17: l_orgwt_c VARCHAR2(15) := PA_REP_UTIL_GLOB.G_OBJ_TYPE_C.G_ORGWT_C;
18: l_res_c VARCHAR2(15) := PA_REP_UTIL_GLOB.G_OBJ_TYPE_C.G_RES_C;
19: l_resuco_c VARCHAR2(15) := PA_REP_UTIL_GLOB.G_OBJ_TYPE_C.G_RESUCO_C;
20: l_resucr_c VARCHAR2(15) := PA_REP_UTIL_GLOB.G_OBJ_TYPE_C.G_RESUCR_C;
21: l_reswt_c VARCHAR2(15) := PA_REP_UTIL_GLOB.G_OBJ_TYPE_C.G_RESWT_C;

Line 18: l_res_c VARCHAR2(15) := PA_REP_UTIL_GLOB.G_OBJ_TYPE_C.G_RES_C;

14: */
15: l_org_c VARCHAR2(15) := PA_REP_UTIL_GLOB.G_OBJ_TYPE_C.G_ORG_C;
16: l_orguc_c VARCHAR2(15) := PA_REP_UTIL_GLOB.G_OBJ_TYPE_C.G_ORGUC_C;
17: l_orgwt_c VARCHAR2(15) := PA_REP_UTIL_GLOB.G_OBJ_TYPE_C.G_ORGWT_C;
18: l_res_c VARCHAR2(15) := PA_REP_UTIL_GLOB.G_OBJ_TYPE_C.G_RES_C;
19: l_resuco_c VARCHAR2(15) := PA_REP_UTIL_GLOB.G_OBJ_TYPE_C.G_RESUCO_C;
20: l_resucr_c VARCHAR2(15) := PA_REP_UTIL_GLOB.G_OBJ_TYPE_C.G_RESUCR_C;
21: l_reswt_c VARCHAR2(15) := PA_REP_UTIL_GLOB.G_OBJ_TYPE_C.G_RESWT_C;
22: l_utildet_c VARCHAR2(15) := PA_REP_UTIL_GLOB.G_OBJ_TYPE_C.G_UTILDET_C;

Line 19: l_resuco_c VARCHAR2(15) := PA_REP_UTIL_GLOB.G_OBJ_TYPE_C.G_RESUCO_C;

15: l_org_c VARCHAR2(15) := PA_REP_UTIL_GLOB.G_OBJ_TYPE_C.G_ORG_C;
16: l_orguc_c VARCHAR2(15) := PA_REP_UTIL_GLOB.G_OBJ_TYPE_C.G_ORGUC_C;
17: l_orgwt_c VARCHAR2(15) := PA_REP_UTIL_GLOB.G_OBJ_TYPE_C.G_ORGWT_C;
18: l_res_c VARCHAR2(15) := PA_REP_UTIL_GLOB.G_OBJ_TYPE_C.G_RES_C;
19: l_resuco_c VARCHAR2(15) := PA_REP_UTIL_GLOB.G_OBJ_TYPE_C.G_RESUCO_C;
20: l_resucr_c VARCHAR2(15) := PA_REP_UTIL_GLOB.G_OBJ_TYPE_C.G_RESUCR_C;
21: l_reswt_c VARCHAR2(15) := PA_REP_UTIL_GLOB.G_OBJ_TYPE_C.G_RESWT_C;
22: l_utildet_c VARCHAR2(15) := PA_REP_UTIL_GLOB.G_OBJ_TYPE_C.G_UTILDET_C;
23: /*

Line 20: l_resucr_c VARCHAR2(15) := PA_REP_UTIL_GLOB.G_OBJ_TYPE_C.G_RESUCR_C;

16: l_orguc_c VARCHAR2(15) := PA_REP_UTIL_GLOB.G_OBJ_TYPE_C.G_ORGUC_C;
17: l_orgwt_c VARCHAR2(15) := PA_REP_UTIL_GLOB.G_OBJ_TYPE_C.G_ORGWT_C;
18: l_res_c VARCHAR2(15) := PA_REP_UTIL_GLOB.G_OBJ_TYPE_C.G_RES_C;
19: l_resuco_c VARCHAR2(15) := PA_REP_UTIL_GLOB.G_OBJ_TYPE_C.G_RESUCO_C;
20: l_resucr_c VARCHAR2(15) := PA_REP_UTIL_GLOB.G_OBJ_TYPE_C.G_RESUCR_C;
21: l_reswt_c VARCHAR2(15) := PA_REP_UTIL_GLOB.G_OBJ_TYPE_C.G_RESWT_C;
22: l_utildet_c VARCHAR2(15) := PA_REP_UTIL_GLOB.G_OBJ_TYPE_C.G_UTILDET_C;
23: /*
24: * End Caching object types.

Line 21: l_reswt_c VARCHAR2(15) := PA_REP_UTIL_GLOB.G_OBJ_TYPE_C.G_RESWT_C;

17: l_orgwt_c VARCHAR2(15) := PA_REP_UTIL_GLOB.G_OBJ_TYPE_C.G_ORGWT_C;
18: l_res_c VARCHAR2(15) := PA_REP_UTIL_GLOB.G_OBJ_TYPE_C.G_RES_C;
19: l_resuco_c VARCHAR2(15) := PA_REP_UTIL_GLOB.G_OBJ_TYPE_C.G_RESUCO_C;
20: l_resucr_c VARCHAR2(15) := PA_REP_UTIL_GLOB.G_OBJ_TYPE_C.G_RESUCR_C;
21: l_reswt_c VARCHAR2(15) := PA_REP_UTIL_GLOB.G_OBJ_TYPE_C.G_RESWT_C;
22: l_utildet_c VARCHAR2(15) := PA_REP_UTIL_GLOB.G_OBJ_TYPE_C.G_UTILDET_C;
23: /*
24: * End Caching object types.
25: */

Line 22: l_utildet_c VARCHAR2(15) := PA_REP_UTIL_GLOB.G_OBJ_TYPE_C.G_UTILDET_C;

18: l_res_c VARCHAR2(15) := PA_REP_UTIL_GLOB.G_OBJ_TYPE_C.G_RES_C;
19: l_resuco_c VARCHAR2(15) := PA_REP_UTIL_GLOB.G_OBJ_TYPE_C.G_RESUCO_C;
20: l_resucr_c VARCHAR2(15) := PA_REP_UTIL_GLOB.G_OBJ_TYPE_C.G_RESUCR_C;
21: l_reswt_c VARCHAR2(15) := PA_REP_UTIL_GLOB.G_OBJ_TYPE_C.G_RESWT_C;
22: l_utildet_c VARCHAR2(15) := PA_REP_UTIL_GLOB.G_OBJ_TYPE_C.G_UTILDET_C;
23: /*
24: * End Caching object types.
25: */
26:

Line 31: := PA_REP_UTIL_GLOB.G_amt_type_details.G_res_hrs_id;

27: /*
28: * Cache Amount Type Id.
29: */
30: l_tot_hrs_id pa_amount_types_b.amount_type_id%TYPE
31: := PA_REP_UTIL_GLOB.G_amt_type_details.G_res_hrs_id;
32: l_tot_prov_hrs_id pa_amount_types_b.amount_type_id%TYPE
33: := PA_REP_UTIL_GLOB.G_amt_type_details.G_res_prvhrs_id;
34: l_tot_wght_hrs_people_id pa_amount_types_b.amount_type_id%TYPE
35: := PA_REP_UTIL_GLOB.G_amt_type_details.G_res_wtdhrs_people_id;

Line 33: := PA_REP_UTIL_GLOB.G_amt_type_details.G_res_prvhrs_id;

29: */
30: l_tot_hrs_id pa_amount_types_b.amount_type_id%TYPE
31: := PA_REP_UTIL_GLOB.G_amt_type_details.G_res_hrs_id;
32: l_tot_prov_hrs_id pa_amount_types_b.amount_type_id%TYPE
33: := PA_REP_UTIL_GLOB.G_amt_type_details.G_res_prvhrs_id;
34: l_tot_wght_hrs_people_id pa_amount_types_b.amount_type_id%TYPE
35: := PA_REP_UTIL_GLOB.G_amt_type_details.G_res_wtdhrs_people_id;
36: l_tot_wght_hrs_org_id pa_amount_types_b.amount_type_id%TYPE
37: := PA_REP_UTIL_GLOB.G_amt_type_details.G_res_wtdhrs_org_id;

Line 35: := PA_REP_UTIL_GLOB.G_amt_type_details.G_res_wtdhrs_people_id;

31: := PA_REP_UTIL_GLOB.G_amt_type_details.G_res_hrs_id;
32: l_tot_prov_hrs_id pa_amount_types_b.amount_type_id%TYPE
33: := PA_REP_UTIL_GLOB.G_amt_type_details.G_res_prvhrs_id;
34: l_tot_wght_hrs_people_id pa_amount_types_b.amount_type_id%TYPE
35: := PA_REP_UTIL_GLOB.G_amt_type_details.G_res_wtdhrs_people_id;
36: l_tot_wght_hrs_org_id pa_amount_types_b.amount_type_id%TYPE
37: := PA_REP_UTIL_GLOB.G_amt_type_details.G_res_wtdhrs_org_id;
38: l_prov_wght_hrs_people_id pa_amount_types_b.amount_type_id%TYPE
39: := PA_REP_UTIL_GLOB.G_amt_type_details.G_res_prvwtdhrs_people_id;

Line 37: := PA_REP_UTIL_GLOB.G_amt_type_details.G_res_wtdhrs_org_id;

33: := PA_REP_UTIL_GLOB.G_amt_type_details.G_res_prvhrs_id;
34: l_tot_wght_hrs_people_id pa_amount_types_b.amount_type_id%TYPE
35: := PA_REP_UTIL_GLOB.G_amt_type_details.G_res_wtdhrs_people_id;
36: l_tot_wght_hrs_org_id pa_amount_types_b.amount_type_id%TYPE
37: := PA_REP_UTIL_GLOB.G_amt_type_details.G_res_wtdhrs_org_id;
38: l_prov_wght_hrs_people_id pa_amount_types_b.amount_type_id%TYPE
39: := PA_REP_UTIL_GLOB.G_amt_type_details.G_res_prvwtdhrs_people_id;
40: l_prov_wght_hrs_org_id pa_amount_types_b.amount_type_id%TYPE
41: := PA_REP_UTIL_GLOB.G_amt_type_details.G_res_prvwtdhrs_org_id;

Line 39: := PA_REP_UTIL_GLOB.G_amt_type_details.G_res_prvwtdhrs_people_id;

35: := PA_REP_UTIL_GLOB.G_amt_type_details.G_res_wtdhrs_people_id;
36: l_tot_wght_hrs_org_id pa_amount_types_b.amount_type_id%TYPE
37: := PA_REP_UTIL_GLOB.G_amt_type_details.G_res_wtdhrs_org_id;
38: l_prov_wght_hrs_people_id pa_amount_types_b.amount_type_id%TYPE
39: := PA_REP_UTIL_GLOB.G_amt_type_details.G_res_prvwtdhrs_people_id;
40: l_prov_wght_hrs_org_id pa_amount_types_b.amount_type_id%TYPE
41: := PA_REP_UTIL_GLOB.G_amt_type_details.G_res_prvwtdhrs_org_id;
42: l_red_cap_id pa_amount_types_b.amount_type_id%TYPE
43: := PA_REP_UTIL_GLOB.G_amt_type_details.G_res_reducedcap_id;

Line 41: := PA_REP_UTIL_GLOB.G_amt_type_details.G_res_prvwtdhrs_org_id;

37: := PA_REP_UTIL_GLOB.G_amt_type_details.G_res_wtdhrs_org_id;
38: l_prov_wght_hrs_people_id pa_amount_types_b.amount_type_id%TYPE
39: := PA_REP_UTIL_GLOB.G_amt_type_details.G_res_prvwtdhrs_people_id;
40: l_prov_wght_hrs_org_id pa_amount_types_b.amount_type_id%TYPE
41: := PA_REP_UTIL_GLOB.G_amt_type_details.G_res_prvwtdhrs_org_id;
42: l_red_cap_id pa_amount_types_b.amount_type_id%TYPE
43: := PA_REP_UTIL_GLOB.G_amt_type_details.G_res_reducedcap_id;
44: l_tot_cap_id pa_amount_types_b.amount_type_id%TYPE
45: := PA_REP_UTIL_GLOB.G_amt_type_details.G_res_cap_id;

Line 43: := PA_REP_UTIL_GLOB.G_amt_type_details.G_res_reducedcap_id;

39: := PA_REP_UTIL_GLOB.G_amt_type_details.G_res_prvwtdhrs_people_id;
40: l_prov_wght_hrs_org_id pa_amount_types_b.amount_type_id%TYPE
41: := PA_REP_UTIL_GLOB.G_amt_type_details.G_res_prvwtdhrs_org_id;
42: l_red_cap_id pa_amount_types_b.amount_type_id%TYPE
43: := PA_REP_UTIL_GLOB.G_amt_type_details.G_res_reducedcap_id;
44: l_tot_cap_id pa_amount_types_b.amount_type_id%TYPE
45: := PA_REP_UTIL_GLOB.G_amt_type_details.G_res_cap_id;
46: /*
47: * End Caching.

Line 45: := PA_REP_UTIL_GLOB.G_amt_type_details.G_res_cap_id;

41: := PA_REP_UTIL_GLOB.G_amt_type_details.G_res_prvwtdhrs_org_id;
42: l_red_cap_id pa_amount_types_b.amount_type_id%TYPE
43: := PA_REP_UTIL_GLOB.G_amt_type_details.G_res_reducedcap_id;
44: l_tot_cap_id pa_amount_types_b.amount_type_id%TYPE
45: := PA_REP_UTIL_GLOB.G_amt_type_details.G_res_cap_id;
46: /*
47: * End Caching.
48: */
49:

Line 59: l_exp_org_id NUMBER := PA_REP_UTIL_GLOB.G_implementation_details.G_org_id;

55:
56: /*
57: * Cache the Expenditure Org Id.
58: */
59: l_exp_org_id NUMBER := PA_REP_UTIL_GLOB.G_implementation_details.G_org_id;
60:
61: /*
62: * Cache the concurrent program related globals.
63: */

Line 64: l_last_updated_by NUMBER := PA_REP_UTIL_GLOB.G_who_columns.G_last_updated_by;

60:
61: /*
62: * Cache the concurrent program related globals.
63: */
64: l_last_updated_by NUMBER := PA_REP_UTIL_GLOB.G_who_columns.G_last_updated_by;
65: l_created_by NUMBER := PA_REP_UTIL_GLOB.G_who_columns.G_created_by;
66: l_creation_date DATE := PA_REP_UTIL_GLOB.G_who_columns.G_creation_date;
67: l_last_update_date DATE := PA_REP_UTIL_GLOB.G_who_columns.G_last_update_date;
68: l_last_update_login NUMBER := PA_REP_UTIL_GLOB.G_who_columns.G_program_application_id;

Line 65: l_created_by NUMBER := PA_REP_UTIL_GLOB.G_who_columns.G_created_by;

61: /*
62: * Cache the concurrent program related globals.
63: */
64: l_last_updated_by NUMBER := PA_REP_UTIL_GLOB.G_who_columns.G_last_updated_by;
65: l_created_by NUMBER := PA_REP_UTIL_GLOB.G_who_columns.G_created_by;
66: l_creation_date DATE := PA_REP_UTIL_GLOB.G_who_columns.G_creation_date;
67: l_last_update_date DATE := PA_REP_UTIL_GLOB.G_who_columns.G_last_update_date;
68: l_last_update_login NUMBER := PA_REP_UTIL_GLOB.G_who_columns.G_program_application_id;
69: l_request_id NUMBER := PA_REP_UTIL_GLOB.G_who_columns.G_request_id;

Line 66: l_creation_date DATE := PA_REP_UTIL_GLOB.G_who_columns.G_creation_date;

62: * Cache the concurrent program related globals.
63: */
64: l_last_updated_by NUMBER := PA_REP_UTIL_GLOB.G_who_columns.G_last_updated_by;
65: l_created_by NUMBER := PA_REP_UTIL_GLOB.G_who_columns.G_created_by;
66: l_creation_date DATE := PA_REP_UTIL_GLOB.G_who_columns.G_creation_date;
67: l_last_update_date DATE := PA_REP_UTIL_GLOB.G_who_columns.G_last_update_date;
68: l_last_update_login NUMBER := PA_REP_UTIL_GLOB.G_who_columns.G_program_application_id;
69: l_request_id NUMBER := PA_REP_UTIL_GLOB.G_who_columns.G_request_id;
70: l_program_id NUMBER := PA_REP_UTIL_GLOB.G_who_columns.G_program_id;

Line 67: l_last_update_date DATE := PA_REP_UTIL_GLOB.G_who_columns.G_last_update_date;

63: */
64: l_last_updated_by NUMBER := PA_REP_UTIL_GLOB.G_who_columns.G_last_updated_by;
65: l_created_by NUMBER := PA_REP_UTIL_GLOB.G_who_columns.G_created_by;
66: l_creation_date DATE := PA_REP_UTIL_GLOB.G_who_columns.G_creation_date;
67: l_last_update_date DATE := PA_REP_UTIL_GLOB.G_who_columns.G_last_update_date;
68: l_last_update_login NUMBER := PA_REP_UTIL_GLOB.G_who_columns.G_program_application_id;
69: l_request_id NUMBER := PA_REP_UTIL_GLOB.G_who_columns.G_request_id;
70: l_program_id NUMBER := PA_REP_UTIL_GLOB.G_who_columns.G_program_id;
71: l_program_application_id NUMBER

Line 68: l_last_update_login NUMBER := PA_REP_UTIL_GLOB.G_who_columns.G_program_application_id;

64: l_last_updated_by NUMBER := PA_REP_UTIL_GLOB.G_who_columns.G_last_updated_by;
65: l_created_by NUMBER := PA_REP_UTIL_GLOB.G_who_columns.G_created_by;
66: l_creation_date DATE := PA_REP_UTIL_GLOB.G_who_columns.G_creation_date;
67: l_last_update_date DATE := PA_REP_UTIL_GLOB.G_who_columns.G_last_update_date;
68: l_last_update_login NUMBER := PA_REP_UTIL_GLOB.G_who_columns.G_program_application_id;
69: l_request_id NUMBER := PA_REP_UTIL_GLOB.G_who_columns.G_request_id;
70: l_program_id NUMBER := PA_REP_UTIL_GLOB.G_who_columns.G_program_id;
71: l_program_application_id NUMBER
72: := PA_REP_UTIL_GLOB.G_who_columns.G_program_application_id;

Line 69: l_request_id NUMBER := PA_REP_UTIL_GLOB.G_who_columns.G_request_id;

65: l_created_by NUMBER := PA_REP_UTIL_GLOB.G_who_columns.G_created_by;
66: l_creation_date DATE := PA_REP_UTIL_GLOB.G_who_columns.G_creation_date;
67: l_last_update_date DATE := PA_REP_UTIL_GLOB.G_who_columns.G_last_update_date;
68: l_last_update_login NUMBER := PA_REP_UTIL_GLOB.G_who_columns.G_program_application_id;
69: l_request_id NUMBER := PA_REP_UTIL_GLOB.G_who_columns.G_request_id;
70: l_program_id NUMBER := PA_REP_UTIL_GLOB.G_who_columns.G_program_id;
71: l_program_application_id NUMBER
72: := PA_REP_UTIL_GLOB.G_who_columns.G_program_application_id;
73:

Line 70: l_program_id NUMBER := PA_REP_UTIL_GLOB.G_who_columns.G_program_id;

66: l_creation_date DATE := PA_REP_UTIL_GLOB.G_who_columns.G_creation_date;
67: l_last_update_date DATE := PA_REP_UTIL_GLOB.G_who_columns.G_last_update_date;
68: l_last_update_login NUMBER := PA_REP_UTIL_GLOB.G_who_columns.G_program_application_id;
69: l_request_id NUMBER := PA_REP_UTIL_GLOB.G_who_columns.G_request_id;
70: l_program_id NUMBER := PA_REP_UTIL_GLOB.G_who_columns.G_program_id;
71: l_program_application_id NUMBER
72: := PA_REP_UTIL_GLOB.G_who_columns.G_program_application_id;
73:
74: /*

Line 72: := PA_REP_UTIL_GLOB.G_who_columns.G_program_application_id;

68: l_last_update_login NUMBER := PA_REP_UTIL_GLOB.G_who_columns.G_program_application_id;
69: l_request_id NUMBER := PA_REP_UTIL_GLOB.G_who_columns.G_request_id;
70: l_program_id NUMBER := PA_REP_UTIL_GLOB.G_who_columns.G_program_id;
71: l_program_application_id NUMBER
72: := PA_REP_UTIL_GLOB.G_who_columns.G_program_application_id;
73:
74: /*
75: * End Caching Who Columns.
76: */

Line 82: -- := PA_REP_UTIL_GLOB.G_implementation_details.G_period_set_name;

78: /*
79: * Cache period set name and UOM.
80: */
81: --l_period_set_name gl_sets_of_books.period_set_name%TYPE
82: -- := PA_REP_UTIL_GLOB.G_implementation_details.G_period_set_name;
83: l_gl_period_set_name gl_sets_of_books.period_set_name%TYPE
84: := PA_REP_UTIL_GLOB.G_implementation_details.G_gl_period_set_name; -- Bug 3434019
85: l_pa_period_set_name gl_sets_of_books.period_set_name%TYPE
86: := PA_REP_UTIL_GLOB.G_implementation_details.G_pa_period_set_name; -- Bug 3434019

Line 84: := PA_REP_UTIL_GLOB.G_implementation_details.G_gl_period_set_name; -- Bug 3434019

80: */
81: --l_period_set_name gl_sets_of_books.period_set_name%TYPE
82: -- := PA_REP_UTIL_GLOB.G_implementation_details.G_period_set_name;
83: l_gl_period_set_name gl_sets_of_books.period_set_name%TYPE
84: := PA_REP_UTIL_GLOB.G_implementation_details.G_gl_period_set_name; -- Bug 3434019
85: l_pa_period_set_name gl_sets_of_books.period_set_name%TYPE
86: := PA_REP_UTIL_GLOB.G_implementation_details.G_pa_period_set_name; -- Bug 3434019
87: l_unit_of_measure VARCHAR2(10) := PA_REP_UTIL_GLOB.G_UNIT_OF_MEASURE_HRS_C;
88:

Line 86: := PA_REP_UTIL_GLOB.G_implementation_details.G_pa_period_set_name; -- Bug 3434019

82: -- := PA_REP_UTIL_GLOB.G_implementation_details.G_period_set_name;
83: l_gl_period_set_name gl_sets_of_books.period_set_name%TYPE
84: := PA_REP_UTIL_GLOB.G_implementation_details.G_gl_period_set_name; -- Bug 3434019
85: l_pa_period_set_name gl_sets_of_books.period_set_name%TYPE
86: := PA_REP_UTIL_GLOB.G_implementation_details.G_pa_period_set_name; -- Bug 3434019
87: l_unit_of_measure VARCHAR2(10) := PA_REP_UTIL_GLOB.G_UNIT_OF_MEASURE_HRS_C;
88:
89: /*
90: * Cache Period Type.

Line 87: l_unit_of_measure VARCHAR2(10) := PA_REP_UTIL_GLOB.G_UNIT_OF_MEASURE_HRS_C;

83: l_gl_period_set_name gl_sets_of_books.period_set_name%TYPE
84: := PA_REP_UTIL_GLOB.G_implementation_details.G_gl_period_set_name; -- Bug 3434019
85: l_pa_period_set_name gl_sets_of_books.period_set_name%TYPE
86: := PA_REP_UTIL_GLOB.G_implementation_details.G_pa_period_set_name; -- Bug 3434019
87: l_unit_of_measure VARCHAR2(10) := PA_REP_UTIL_GLOB.G_UNIT_OF_MEASURE_HRS_C;
88:
89: /*
90: * Cache Period Type.
91: */

Line 92: l_gl_c VARCHAR2(3) := PA_REP_UTIL_GLOB.G_PERIOD_TYPE_C.G_GL_C;

88:
89: /*
90: * Cache Period Type.
91: */
92: l_gl_c VARCHAR2(3) := PA_REP_UTIL_GLOB.G_PERIOD_TYPE_C.G_GL_C;
93: l_pa_c VARCHAR2(3) := PA_REP_UTIL_GLOB.G_PERIOD_TYPE_C.G_PA_C;
94: l_ge_c VARCHAR2(3) := PA_REP_UTIL_GLOB.G_PERIOD_TYPE_C.G_GE_C;
95: /*
96: * End Caching Period Type.

Line 93: l_pa_c VARCHAR2(3) := PA_REP_UTIL_GLOB.G_PERIOD_TYPE_C.G_PA_C;

89: /*
90: * Cache Period Type.
91: */
92: l_gl_c VARCHAR2(3) := PA_REP_UTIL_GLOB.G_PERIOD_TYPE_C.G_GL_C;
93: l_pa_c VARCHAR2(3) := PA_REP_UTIL_GLOB.G_PERIOD_TYPE_C.G_PA_C;
94: l_ge_c VARCHAR2(3) := PA_REP_UTIL_GLOB.G_PERIOD_TYPE_C.G_GE_C;
95: /*
96: * End Caching Period Type.
97: */

Line 94: l_ge_c VARCHAR2(3) := PA_REP_UTIL_GLOB.G_PERIOD_TYPE_C.G_GE_C;

90: * Cache Period Type.
91: */
92: l_gl_c VARCHAR2(3) := PA_REP_UTIL_GLOB.G_PERIOD_TYPE_C.G_GL_C;
93: l_pa_c VARCHAR2(3) := PA_REP_UTIL_GLOB.G_PERIOD_TYPE_C.G_PA_C;
94: l_ge_c VARCHAR2(3) := PA_REP_UTIL_GLOB.G_PERIOD_TYPE_C.G_GE_C;
95: /*
96: * End Caching Period Type.
97: */
98:

Line 102: l_dummy_period_set_name VARCHAR2(15) := PA_REP_UTIL_GLOB.G_DUMMY_C;

98:
99: /*
100: * Dummy period set name and period name.
101: */
102: l_dummy_period_set_name VARCHAR2(15) := PA_REP_UTIL_GLOB.G_DUMMY_C;
103: l_dummy_period_name VARCHAR2(15) := PA_REP_UTIL_GLOB.G_DUMMY_C;
104: l_dummy_ge_date DATE := PA_REP_UTIL_GLOB.G_DUMMY_DATE_C;
105:
106: /*

Line 103: l_dummy_period_name VARCHAR2(15) := PA_REP_UTIL_GLOB.G_DUMMY_C;

99: /*
100: * Dummy period set name and period name.
101: */
102: l_dummy_period_set_name VARCHAR2(15) := PA_REP_UTIL_GLOB.G_DUMMY_C;
103: l_dummy_period_name VARCHAR2(15) := PA_REP_UTIL_GLOB.G_DUMMY_C;
104: l_dummy_ge_date DATE := PA_REP_UTIL_GLOB.G_DUMMY_DATE_C;
105:
106: /*
107: * Cache org level direct amount type Id.

Line 104: l_dummy_ge_date DATE := PA_REP_UTIL_GLOB.G_DUMMY_DATE_C;

100: * Dummy period set name and period name.
101: */
102: l_dummy_period_set_name VARCHAR2(15) := PA_REP_UTIL_GLOB.G_DUMMY_C;
103: l_dummy_period_name VARCHAR2(15) := PA_REP_UTIL_GLOB.G_DUMMY_C;
104: l_dummy_ge_date DATE := PA_REP_UTIL_GLOB.G_DUMMY_DATE_C;
105:
106: /*
107: * Cache org level direct amount type Id.
108: */

Line 110: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_dir_hrs_id;

106: /*
107: * Cache org level direct amount type Id.
108: */
109: l_dirct_tot_hrs_id pa_amount_types_b.amount_type_id%TYPE
110: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_dir_hrs_id;
111: l_dirct_tot_prov_hrs_id pa_amount_types_b.amount_type_id%TYPE
112: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_dir_prvhrs_id;
113: l_dirct_tot_wght_hrs_org_id pa_amount_types_b.amount_type_id%TYPE
114: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_dir_wtdhrs_org_id;

Line 112: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_dir_prvhrs_id;

108: */
109: l_dirct_tot_hrs_id pa_amount_types_b.amount_type_id%TYPE
110: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_dir_hrs_id;
111: l_dirct_tot_prov_hrs_id pa_amount_types_b.amount_type_id%TYPE
112: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_dir_prvhrs_id;
113: l_dirct_tot_wght_hrs_org_id pa_amount_types_b.amount_type_id%TYPE
114: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_dir_wtdhrs_org_id;
115: l_dirct_prov_wght_hrs_org_id pa_amount_types_b.amount_type_id%TYPE
116: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_dir_prvwtdhrs_org_id;

Line 114: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_dir_wtdhrs_org_id;

110: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_dir_hrs_id;
111: l_dirct_tot_prov_hrs_id pa_amount_types_b.amount_type_id%TYPE
112: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_dir_prvhrs_id;
113: l_dirct_tot_wght_hrs_org_id pa_amount_types_b.amount_type_id%TYPE
114: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_dir_wtdhrs_org_id;
115: l_dirct_prov_wght_hrs_org_id pa_amount_types_b.amount_type_id%TYPE
116: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_dir_prvwtdhrs_org_id;
117: l_dirct_cap_id pa_amount_types_b.amount_type_id%TYPE
118: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_dir_cap_id;

Line 116: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_dir_prvwtdhrs_org_id;

112: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_dir_prvhrs_id;
113: l_dirct_tot_wght_hrs_org_id pa_amount_types_b.amount_type_id%TYPE
114: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_dir_wtdhrs_org_id;
115: l_dirct_prov_wght_hrs_org_id pa_amount_types_b.amount_type_id%TYPE
116: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_dir_prvwtdhrs_org_id;
117: l_dirct_cap_id pa_amount_types_b.amount_type_id%TYPE
118: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_dir_cap_id;
119: l_dirct_reduce_cap_id pa_amount_types_b.amount_type_id%TYPE
120: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_dir_reducedcap_id;

Line 118: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_dir_cap_id;

114: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_dir_wtdhrs_org_id;
115: l_dirct_prov_wght_hrs_org_id pa_amount_types_b.amount_type_id%TYPE
116: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_dir_prvwtdhrs_org_id;
117: l_dirct_cap_id pa_amount_types_b.amount_type_id%TYPE
118: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_dir_cap_id;
119: l_dirct_reduce_cap_id pa_amount_types_b.amount_type_id%TYPE
120: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_dir_reducedcap_id;
121: /*
122: * End Cache org level direct amount type Id.

Line 120: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_dir_reducedcap_id;

116: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_dir_prvwtdhrs_org_id;
117: l_dirct_cap_id pa_amount_types_b.amount_type_id%TYPE
118: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_dir_cap_id;
119: l_dirct_reduce_cap_id pa_amount_types_b.amount_type_id%TYPE
120: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_dir_reducedcap_id;
121: /*
122: * End Cache org level direct amount type Id.
123: */
124:

Line 129: := PA_REP_UTIL_GLOB.G_input_parameters.G_org_rollup_method;

125: /*
126: * Cache Incremental Method flag.
127: */
128: l_org_rollup_method VARCHAR2(1)
129: := PA_REP_UTIL_GLOB.G_input_parameters.G_org_rollup_method;
130: /*
131: * Cache Actual and Forecast balance type Constants.
132: */
133: l_actual_c VARCHAR2(15) := PA_REP_UTIL_GLOB.G_BAL_TYPE_C.G_ACTUALS_C;

Line 133: l_actual_c VARCHAR2(15) := PA_REP_UTIL_GLOB.G_BAL_TYPE_C.G_ACTUALS_C;

129: := PA_REP_UTIL_GLOB.G_input_parameters.G_org_rollup_method;
130: /*
131: * Cache Actual and Forecast balance type Constants.
132: */
133: l_actual_c VARCHAR2(15) := PA_REP_UTIL_GLOB.G_BAL_TYPE_C.G_ACTUALS_C;
134: l_forecast_c VARCHAR2(15) := PA_REP_UTIL_GLOB.G_BAL_TYPE_C.G_FORECAST_C;
135:
136: /*
137: * Predefination of local procedure.

Line 134: l_forecast_c VARCHAR2(15) := PA_REP_UTIL_GLOB.G_BAL_TYPE_C.G_FORECAST_C;

130: /*
131: * Cache Actual and Forecast balance type Constants.
132: */
133: l_actual_c VARCHAR2(15) := PA_REP_UTIL_GLOB.G_BAL_TYPE_C.G_ACTUALS_C;
134: l_forecast_c VARCHAR2(15) := PA_REP_UTIL_GLOB.G_BAL_TYPE_C.G_FORECAST_C;
135:
136: /*
137: * Predefination of local procedure.
138: */

Line 1385: IF ( PA_REP_UTIL_GLOB.G_util_option_details.G_pa_period_flag = 'Y')

1381: /*
1382: * Summarization by PA period if enabled.
1383: */
1384:
1385: IF ( PA_REP_UTIL_GLOB.G_util_option_details.G_pa_period_flag = 'Y')
1386: THEN
1387: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1388: PA_DEBUG.g_err_stage:='Summarization By PA Period';
1389: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);

Line 1481: IF ( PA_REP_UTIL_GLOB.G_util_option_details.G_gl_period_flag = 'Y')

1477: /*
1478: * Summarization by GL period if enabled.
1479: */
1480:
1481: IF ( PA_REP_UTIL_GLOB.G_util_option_details.G_gl_period_flag = 'Y')
1482: THEN
1483: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1484: PA_DEBUG.g_err_stage:='Summarization By GL Period';
1485: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);

Line 1576: IF (PA_REP_UTIL_GLOB.G_util_option_details.G_ge_period_flag = 'Y')

1572: /*
1573: * Summarization by Global Expenditure week if enabled.
1574: */
1575:
1576: IF (PA_REP_UTIL_GLOB.G_util_option_details.G_ge_period_flag = 'Y')
1577: THEN
1578: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1579: PA_DEBUG.g_err_stage:='Summarization By GE Period';
1580: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);

Line 1811: WHERE resource_org_id = PA_REP_UTIL_GLOB.GetOrgId

1807: , resource_id
1808: , resource_effective_start_date
1809: , resource_effective_end_date
1810: FROM pa_resources_denorm
1811: WHERE resource_org_id = PA_REP_UTIL_GLOB.GetOrgId
1812: AND utilization_flag = 'Y'
1813: AND (
1814: (RESOURCE_EFFECTIVE_START_DATE BETWEEN p_start_date AND p_end_date)
1815: OR

Line 1852: -- l_period_set_name VARCHAR2(15) := PA_REP_UTIL_GLOB.GetPeriodSetName;

1848: l_this_fetch NUMBER:=0;
1849: l_totally_fetched NUMBER:=0;
1850: l_run_start_date DATE;
1851: l_run_end_date DATE;
1852: -- l_period_set_name VARCHAR2(15) := PA_REP_UTIL_GLOB.GetPeriodSetName;
1853: l_gl_period_set_name VARCHAR2(15) := PA_REP_UTIL_GLOB.G_implementation_details.G_gl_period_set_name; -- Bug 3434019
1854: l_pa_period_set_name VARCHAR2(15) := PA_REP_UTIL_GLOB.G_implementation_details.G_pa_period_set_name; -- Bug 3434019
1855: l_gl_c VARCHAR2(3) := PA_REP_UTIL_GLOB.G_PERIOD_TYPE_C.G_GL_C; -- Bug 3434019
1856: l_pa_c VARCHAR2(3) := PA_REP_UTIL_GLOB.G_PERIOD_TYPE_C.G_PA_C; -- Bug 3434019

Line 1853: l_gl_period_set_name VARCHAR2(15) := PA_REP_UTIL_GLOB.G_implementation_details.G_gl_period_set_name; -- Bug 3434019

1849: l_totally_fetched NUMBER:=0;
1850: l_run_start_date DATE;
1851: l_run_end_date DATE;
1852: -- l_period_set_name VARCHAR2(15) := PA_REP_UTIL_GLOB.GetPeriodSetName;
1853: l_gl_period_set_name VARCHAR2(15) := PA_REP_UTIL_GLOB.G_implementation_details.G_gl_period_set_name; -- Bug 3434019
1854: l_pa_period_set_name VARCHAR2(15) := PA_REP_UTIL_GLOB.G_implementation_details.G_pa_period_set_name; -- Bug 3434019
1855: l_gl_c VARCHAR2(3) := PA_REP_UTIL_GLOB.G_PERIOD_TYPE_C.G_GL_C; -- Bug 3434019
1856: l_pa_c VARCHAR2(3) := PA_REP_UTIL_GLOB.G_PERIOD_TYPE_C.G_PA_C; -- Bug 3434019
1857:

Line 1854: l_pa_period_set_name VARCHAR2(15) := PA_REP_UTIL_GLOB.G_implementation_details.G_pa_period_set_name; -- Bug 3434019

1850: l_run_start_date DATE;
1851: l_run_end_date DATE;
1852: -- l_period_set_name VARCHAR2(15) := PA_REP_UTIL_GLOB.GetPeriodSetName;
1853: l_gl_period_set_name VARCHAR2(15) := PA_REP_UTIL_GLOB.G_implementation_details.G_gl_period_set_name; -- Bug 3434019
1854: l_pa_period_set_name VARCHAR2(15) := PA_REP_UTIL_GLOB.G_implementation_details.G_pa_period_set_name; -- Bug 3434019
1855: l_gl_c VARCHAR2(3) := PA_REP_UTIL_GLOB.G_PERIOD_TYPE_C.G_GL_C; -- Bug 3434019
1856: l_pa_c VARCHAR2(3) := PA_REP_UTIL_GLOB.G_PERIOD_TYPE_C.G_PA_C; -- Bug 3434019
1857:
1858: BEGIN

Line 1855: l_gl_c VARCHAR2(3) := PA_REP_UTIL_GLOB.G_PERIOD_TYPE_C.G_GL_C; -- Bug 3434019

1851: l_run_end_date DATE;
1852: -- l_period_set_name VARCHAR2(15) := PA_REP_UTIL_GLOB.GetPeriodSetName;
1853: l_gl_period_set_name VARCHAR2(15) := PA_REP_UTIL_GLOB.G_implementation_details.G_gl_period_set_name; -- Bug 3434019
1854: l_pa_period_set_name VARCHAR2(15) := PA_REP_UTIL_GLOB.G_implementation_details.G_pa_period_set_name; -- Bug 3434019
1855: l_gl_c VARCHAR2(3) := PA_REP_UTIL_GLOB.G_PERIOD_TYPE_C.G_GL_C; -- Bug 3434019
1856: l_pa_c VARCHAR2(3) := PA_REP_UTIL_GLOB.G_PERIOD_TYPE_C.G_PA_C; -- Bug 3434019
1857:
1858: BEGIN
1859:

Line 1856: l_pa_c VARCHAR2(3) := PA_REP_UTIL_GLOB.G_PERIOD_TYPE_C.G_PA_C; -- Bug 3434019

1852: -- l_period_set_name VARCHAR2(15) := PA_REP_UTIL_GLOB.GetPeriodSetName;
1853: l_gl_period_set_name VARCHAR2(15) := PA_REP_UTIL_GLOB.G_implementation_details.G_gl_period_set_name; -- Bug 3434019
1854: l_pa_period_set_name VARCHAR2(15) := PA_REP_UTIL_GLOB.G_implementation_details.G_pa_period_set_name; -- Bug 3434019
1855: l_gl_c VARCHAR2(3) := PA_REP_UTIL_GLOB.G_PERIOD_TYPE_C.G_GL_C; -- Bug 3434019
1856: l_pa_c VARCHAR2(3) := PA_REP_UTIL_GLOB.G_PERIOD_TYPE_C.G_PA_C; -- Bug 3434019
1857:
1858: BEGIN
1859:
1860:

Line 1870: IF l_balance_type_code = PA_REP_UTIL_GLOB.GetBalTypeActuals then

1866: /*
1867: * First figure out which balance_type is the current call for so as
1868: * to set the appropriate start and end dates for the run
1869: */
1870: IF l_balance_type_code = PA_REP_UTIL_GLOB.GetBalTypeActuals then
1871: l_run_start_date := PA_REP_UTIL_GLOB.G_input_parameters.G_ac_start_date;
1872: l_run_end_date := PA_REP_UTIL_GLOB.G_input_parameters.G_ac_end_date;
1873: ELSIF l_balance_type_code = PA_REP_UTIL_GLOB.GetBalTypeForecast then
1874: l_run_start_date := PA_REP_UTIL_GLOB.G_input_parameters.G_fc_start_date;

Line 1871: l_run_start_date := PA_REP_UTIL_GLOB.G_input_parameters.G_ac_start_date;

1867: * First figure out which balance_type is the current call for so as
1868: * to set the appropriate start and end dates for the run
1869: */
1870: IF l_balance_type_code = PA_REP_UTIL_GLOB.GetBalTypeActuals then
1871: l_run_start_date := PA_REP_UTIL_GLOB.G_input_parameters.G_ac_start_date;
1872: l_run_end_date := PA_REP_UTIL_GLOB.G_input_parameters.G_ac_end_date;
1873: ELSIF l_balance_type_code = PA_REP_UTIL_GLOB.GetBalTypeForecast then
1874: l_run_start_date := PA_REP_UTIL_GLOB.G_input_parameters.G_fc_start_date;
1875: l_run_end_date := PA_REP_UTIL_GLOB.G_input_parameters.G_fc_end_date;

Line 1872: l_run_end_date := PA_REP_UTIL_GLOB.G_input_parameters.G_ac_end_date;

1868: * to set the appropriate start and end dates for the run
1869: */
1870: IF l_balance_type_code = PA_REP_UTIL_GLOB.GetBalTypeActuals then
1871: l_run_start_date := PA_REP_UTIL_GLOB.G_input_parameters.G_ac_start_date;
1872: l_run_end_date := PA_REP_UTIL_GLOB.G_input_parameters.G_ac_end_date;
1873: ELSIF l_balance_type_code = PA_REP_UTIL_GLOB.GetBalTypeForecast then
1874: l_run_start_date := PA_REP_UTIL_GLOB.G_input_parameters.G_fc_start_date;
1875: l_run_end_date := PA_REP_UTIL_GLOB.G_input_parameters.G_fc_end_date;
1876: END IF;

Line 1873: ELSIF l_balance_type_code = PA_REP_UTIL_GLOB.GetBalTypeForecast then

1869: */
1870: IF l_balance_type_code = PA_REP_UTIL_GLOB.GetBalTypeActuals then
1871: l_run_start_date := PA_REP_UTIL_GLOB.G_input_parameters.G_ac_start_date;
1872: l_run_end_date := PA_REP_UTIL_GLOB.G_input_parameters.G_ac_end_date;
1873: ELSIF l_balance_type_code = PA_REP_UTIL_GLOB.GetBalTypeForecast then
1874: l_run_start_date := PA_REP_UTIL_GLOB.G_input_parameters.G_fc_start_date;
1875: l_run_end_date := PA_REP_UTIL_GLOB.G_input_parameters.G_fc_end_date;
1876: END IF;
1877:

Line 1874: l_run_start_date := PA_REP_UTIL_GLOB.G_input_parameters.G_fc_start_date;

1870: IF l_balance_type_code = PA_REP_UTIL_GLOB.GetBalTypeActuals then
1871: l_run_start_date := PA_REP_UTIL_GLOB.G_input_parameters.G_ac_start_date;
1872: l_run_end_date := PA_REP_UTIL_GLOB.G_input_parameters.G_ac_end_date;
1873: ELSIF l_balance_type_code = PA_REP_UTIL_GLOB.GetBalTypeForecast then
1874: l_run_start_date := PA_REP_UTIL_GLOB.G_input_parameters.G_fc_start_date;
1875: l_run_end_date := PA_REP_UTIL_GLOB.G_input_parameters.G_fc_end_date;
1876: END IF;
1877:
1878: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */

Line 1875: l_run_end_date := PA_REP_UTIL_GLOB.G_input_parameters.G_fc_end_date;

1871: l_run_start_date := PA_REP_UTIL_GLOB.G_input_parameters.G_ac_start_date;
1872: l_run_end_date := PA_REP_UTIL_GLOB.G_input_parameters.G_ac_end_date;
1873: ELSIF l_balance_type_code = PA_REP_UTIL_GLOB.GetBalTypeForecast then
1874: l_run_start_date := PA_REP_UTIL_GLOB.G_input_parameters.G_fc_start_date;
1875: l_run_end_date := PA_REP_UTIL_GLOB.G_input_parameters.G_fc_end_date;
1876: END IF;
1877:
1878: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1879: PA_DEBUG.g_err_stage := 'Opening the Cursor';

Line 2467: := PA_REP_UTIL_GLOB.G_amt_type_details.G_res_cap_id;

2463: L_QUARTER_OR_MONTH_NUMBER_TAB PA_PLSQL_DATATYPES.NumTabTyp;
2464: L_AMOUNT_TYPE_ID_TAB PA_PLSQL_DATATYPES.IdTabTyp;
2465:
2466: l_tot_cap_id pa_amount_types_b.amount_type_id%TYPE
2467: := PA_REP_UTIL_GLOB.G_amt_type_details.G_res_cap_id;
2468: l_dirct_cap_id pa_amount_types_b.amount_type_id%TYPE
2469: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_dir_cap_id;
2470: l_sub_org_cap_id pa_amount_types_b.amount_type_id%TYPE
2471: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_sub_cap_id;

Line 2469: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_dir_cap_id;

2465:
2466: l_tot_cap_id pa_amount_types_b.amount_type_id%TYPE
2467: := PA_REP_UTIL_GLOB.G_amt_type_details.G_res_cap_id;
2468: l_dirct_cap_id pa_amount_types_b.amount_type_id%TYPE
2469: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_dir_cap_id;
2470: l_sub_org_cap_id pa_amount_types_b.amount_type_id%TYPE
2471: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_sub_cap_id;
2472: l_org_tot_cap_id pa_amount_types_b.amount_type_id%TYPE
2473: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_tot_cap_id;

Line 2471: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_sub_cap_id;

2467: := PA_REP_UTIL_GLOB.G_amt_type_details.G_res_cap_id;
2468: l_dirct_cap_id pa_amount_types_b.amount_type_id%TYPE
2469: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_dir_cap_id;
2470: l_sub_org_cap_id pa_amount_types_b.amount_type_id%TYPE
2471: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_sub_cap_id;
2472: l_org_tot_cap_id pa_amount_types_b.amount_type_id%TYPE
2473: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_tot_cap_id;
2474:
2475: l_totally_fetched NUMBER := 0;

Line 2473: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_tot_cap_id;

2469: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_dir_cap_id;
2470: l_sub_org_cap_id pa_amount_types_b.amount_type_id%TYPE
2471: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_sub_cap_id;
2472: l_org_tot_cap_id pa_amount_types_b.amount_type_id%TYPE
2473: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_tot_cap_id;
2474:
2475: l_totally_fetched NUMBER := 0;
2476:
2477: CURSOR cur_update_bal

Line 2697: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_tot_hrs_id;

2693: /*
2694: * Cache sub org and total level amount types.
2695: */
2696: l_org_tot_hrs_id pa_amount_types_b.amount_type_id%TYPE
2697: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_tot_hrs_id;
2698: l_org_tot_wght_hrs_org_id pa_amount_types_b.amount_type_id%TYPE
2699: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_tot_wtdhrs_org_id;
2700: l_org_tot_prov_hrs_id pa_amount_types_b.amount_type_id%TYPE
2701: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_tot_prvhrs_id;

Line 2699: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_tot_wtdhrs_org_id;

2695: */
2696: l_org_tot_hrs_id pa_amount_types_b.amount_type_id%TYPE
2697: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_tot_hrs_id;
2698: l_org_tot_wght_hrs_org_id pa_amount_types_b.amount_type_id%TYPE
2699: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_tot_wtdhrs_org_id;
2700: l_org_tot_prov_hrs_id pa_amount_types_b.amount_type_id%TYPE
2701: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_tot_prvhrs_id;
2702: l_org_prov_wght_hrs_org_id pa_amount_types_b.amount_type_id%TYPE
2703: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_tot_prvwtdhrs_org_id;

Line 2701: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_tot_prvhrs_id;

2697: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_tot_hrs_id;
2698: l_org_tot_wght_hrs_org_id pa_amount_types_b.amount_type_id%TYPE
2699: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_tot_wtdhrs_org_id;
2700: l_org_tot_prov_hrs_id pa_amount_types_b.amount_type_id%TYPE
2701: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_tot_prvhrs_id;
2702: l_org_prov_wght_hrs_org_id pa_amount_types_b.amount_type_id%TYPE
2703: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_tot_prvwtdhrs_org_id;
2704: l_org_tot_cap_id pa_amount_types_b.amount_type_id%TYPE
2705: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_tot_cap_id;

Line 2703: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_tot_prvwtdhrs_org_id;

2699: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_tot_wtdhrs_org_id;
2700: l_org_tot_prov_hrs_id pa_amount_types_b.amount_type_id%TYPE
2701: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_tot_prvhrs_id;
2702: l_org_prov_wght_hrs_org_id pa_amount_types_b.amount_type_id%TYPE
2703: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_tot_prvwtdhrs_org_id;
2704: l_org_tot_cap_id pa_amount_types_b.amount_type_id%TYPE
2705: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_tot_cap_id;
2706: l_org_tot_reducedcap_id pa_amount_types_b.amount_type_id%TYPE
2707: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_tot_reducedcap_id;

Line 2705: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_tot_cap_id;

2701: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_tot_prvhrs_id;
2702: l_org_prov_wght_hrs_org_id pa_amount_types_b.amount_type_id%TYPE
2703: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_tot_prvwtdhrs_org_id;
2704: l_org_tot_cap_id pa_amount_types_b.amount_type_id%TYPE
2705: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_tot_cap_id;
2706: l_org_tot_reducedcap_id pa_amount_types_b.amount_type_id%TYPE
2707: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_tot_reducedcap_id;
2708: l_sub_org_tot_hrs_id pa_amount_types_b.amount_type_id%TYPE
2709: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_sub_hrs_id;

Line 2707: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_tot_reducedcap_id;

2703: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_tot_prvwtdhrs_org_id;
2704: l_org_tot_cap_id pa_amount_types_b.amount_type_id%TYPE
2705: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_tot_cap_id;
2706: l_org_tot_reducedcap_id pa_amount_types_b.amount_type_id%TYPE
2707: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_tot_reducedcap_id;
2708: l_sub_org_tot_hrs_id pa_amount_types_b.amount_type_id%TYPE
2709: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_sub_hrs_id;
2710: l_sub_org_tot_prov_hrs_id pa_amount_types_b.amount_type_id%TYPE
2711: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_sub_prvhrs_id;

Line 2709: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_sub_hrs_id;

2705: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_tot_cap_id;
2706: l_org_tot_reducedcap_id pa_amount_types_b.amount_type_id%TYPE
2707: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_tot_reducedcap_id;
2708: l_sub_org_tot_hrs_id pa_amount_types_b.amount_type_id%TYPE
2709: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_sub_hrs_id;
2710: l_sub_org_tot_prov_hrs_id pa_amount_types_b.amount_type_id%TYPE
2711: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_sub_prvhrs_id;
2712: l_sub_org_tot_wght_hrs_org_id pa_amount_types_b.amount_type_id%TYPE
2713: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_sub_wtdhrs_org_id;

Line 2711: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_sub_prvhrs_id;

2707: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_tot_reducedcap_id;
2708: l_sub_org_tot_hrs_id pa_amount_types_b.amount_type_id%TYPE
2709: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_sub_hrs_id;
2710: l_sub_org_tot_prov_hrs_id pa_amount_types_b.amount_type_id%TYPE
2711: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_sub_prvhrs_id;
2712: l_sub_org_tot_wght_hrs_org_id pa_amount_types_b.amount_type_id%TYPE
2713: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_sub_wtdhrs_org_id;
2714: l_sub_org_prov_wght_hrs_org_id pa_amount_types_b.amount_type_id%TYPE
2715: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_sub_prvwtdhrs_org_id;

Line 2713: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_sub_wtdhrs_org_id;

2709: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_sub_hrs_id;
2710: l_sub_org_tot_prov_hrs_id pa_amount_types_b.amount_type_id%TYPE
2711: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_sub_prvhrs_id;
2712: l_sub_org_tot_wght_hrs_org_id pa_amount_types_b.amount_type_id%TYPE
2713: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_sub_wtdhrs_org_id;
2714: l_sub_org_prov_wght_hrs_org_id pa_amount_types_b.amount_type_id%TYPE
2715: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_sub_prvwtdhrs_org_id;
2716: l_sub_org_cap_id pa_amount_types_b.amount_type_id%TYPE
2717: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_sub_cap_id;

Line 2715: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_sub_prvwtdhrs_org_id;

2711: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_sub_prvhrs_id;
2712: l_sub_org_tot_wght_hrs_org_id pa_amount_types_b.amount_type_id%TYPE
2713: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_sub_wtdhrs_org_id;
2714: l_sub_org_prov_wght_hrs_org_id pa_amount_types_b.amount_type_id%TYPE
2715: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_sub_prvwtdhrs_org_id;
2716: l_sub_org_cap_id pa_amount_types_b.amount_type_id%TYPE
2717: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_sub_cap_id;
2718: l_sub_org_reducedcap_id pa_amount_types_b.amount_type_id%TYPE
2719: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_sub_reducedcap_id;

Line 2717: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_sub_cap_id;

2713: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_sub_wtdhrs_org_id;
2714: l_sub_org_prov_wght_hrs_org_id pa_amount_types_b.amount_type_id%TYPE
2715: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_sub_prvwtdhrs_org_id;
2716: l_sub_org_cap_id pa_amount_types_b.amount_type_id%TYPE
2717: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_sub_cap_id;
2718: l_sub_org_reducedcap_id pa_amount_types_b.amount_type_id%TYPE
2719: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_sub_reducedcap_id;
2720: /** End Cache sub org and total level amount types **/
2721:

Line 2719: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_sub_reducedcap_id;

2715: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_sub_prvwtdhrs_org_id;
2716: l_sub_org_cap_id pa_amount_types_b.amount_type_id%TYPE
2717: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_sub_cap_id;
2718: l_sub_org_reducedcap_id pa_amount_types_b.amount_type_id%TYPE
2719: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_sub_reducedcap_id;
2720: /** End Cache sub org and total level amount types **/
2721:
2722:
2723: BEGIN

Line 2869: IF PA_REP_UTIL_GLOB.G_is_this_first_fetch = 'Y' THEN

2865: END IF;
2866:
2867: summarize_temp_data_by_res;
2868:
2869: IF PA_REP_UTIL_GLOB.G_is_this_first_fetch = 'Y' THEN
2870: populate_tmp_for_capacity;
2871: PA_REP_UTIL_GLOB.G_is_this_first_fetch := 'N';
2872: END IF;
2873:

Line 2871: PA_REP_UTIL_GLOB.G_is_this_first_fetch := 'N';

2867: summarize_temp_data_by_res;
2868:
2869: IF PA_REP_UTIL_GLOB.G_is_this_first_fetch = 'Y' THEN
2870: populate_tmp_for_capacity;
2871: PA_REP_UTIL_GLOB.G_is_this_first_fetch := 'N';
2872: END IF;
2873:
2874: summarize_temp_data_by_org;
2875: