[Home] [Help]
26:
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
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;
36: l_tot_wght_hrs_org_id pa_amount_types_b.amount_type_id%TYPE
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;
38: l_prov_wght_hrs_people_id pa_amount_types_b.amount_type_id%TYPE
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;
40: l_prov_wght_hrs_org_id pa_amount_types_b.amount_type_id%TYPE
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;
42: l_red_cap_id pa_amount_types_b.amount_type_id%TYPE
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;
44: l_tot_cap_id pa_amount_types_b.amount_type_id%TYPE
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;
46: /*
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.
48: */
105:
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
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;
115: l_dirct_prov_wght_hrs_org_id pa_amount_types_b.amount_type_id%TYPE
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;
117: l_dirct_cap_id pa_amount_types_b.amount_type_id%TYPE
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;
119: l_dirct_reduce_cap_id pa_amount_types_b.amount_type_id%TYPE
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;
121: /*
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.
123: */
2461: L_PERIOD_YEAR_TAB PA_PLSQL_DATATYPES.NumTabTyp;
2462: L_QUARTER_OR_MONTH_NUMBER_TAB PA_PLSQL_DATATYPES.NumTabTyp;
2463: L_AMOUNT_TYPE_ID_TAB PA_PLSQL_DATATYPES.IdTabTyp;
2464:
2465: l_tot_cap_id pa_amount_types_b.amount_type_id%TYPE
2466: := PA_REP_UTIL_GLOB.G_amt_type_details.G_res_cap_id;
2467: l_dirct_cap_id pa_amount_types_b.amount_type_id%TYPE
2468: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_dir_cap_id;
2469: l_sub_org_cap_id pa_amount_types_b.amount_type_id%TYPE
2463: L_AMOUNT_TYPE_ID_TAB PA_PLSQL_DATATYPES.IdTabTyp;
2464:
2465: l_tot_cap_id pa_amount_types_b.amount_type_id%TYPE
2466: := PA_REP_UTIL_GLOB.G_amt_type_details.G_res_cap_id;
2467: l_dirct_cap_id pa_amount_types_b.amount_type_id%TYPE
2468: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_dir_cap_id;
2469: l_sub_org_cap_id pa_amount_types_b.amount_type_id%TYPE
2470: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_sub_cap_id;
2471: l_org_tot_cap_id pa_amount_types_b.amount_type_id%TYPE
2465: l_tot_cap_id pa_amount_types_b.amount_type_id%TYPE
2466: := PA_REP_UTIL_GLOB.G_amt_type_details.G_res_cap_id;
2467: l_dirct_cap_id pa_amount_types_b.amount_type_id%TYPE
2468: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_dir_cap_id;
2469: l_sub_org_cap_id pa_amount_types_b.amount_type_id%TYPE
2470: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_sub_cap_id;
2471: l_org_tot_cap_id pa_amount_types_b.amount_type_id%TYPE
2472: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_tot_cap_id;
2473:
2467: l_dirct_cap_id pa_amount_types_b.amount_type_id%TYPE
2468: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_dir_cap_id;
2469: l_sub_org_cap_id pa_amount_types_b.amount_type_id%TYPE
2470: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_sub_cap_id;
2471: l_org_tot_cap_id pa_amount_types_b.amount_type_id%TYPE
2472: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_tot_cap_id;
2473:
2474: l_totally_fetched NUMBER := 0;
2475:
2691: IS
2692: /*
2693: * Cache sub org and total level amount types.
2694: */
2695: l_org_tot_hrs_id pa_amount_types_b.amount_type_id%TYPE
2696: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_tot_hrs_id;
2697: l_org_tot_wght_hrs_org_id pa_amount_types_b.amount_type_id%TYPE
2698: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_tot_wtdhrs_org_id;
2699: l_org_tot_prov_hrs_id pa_amount_types_b.amount_type_id%TYPE
2693: * Cache sub org and total level amount types.
2694: */
2695: l_org_tot_hrs_id pa_amount_types_b.amount_type_id%TYPE
2696: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_tot_hrs_id;
2697: l_org_tot_wght_hrs_org_id pa_amount_types_b.amount_type_id%TYPE
2698: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_tot_wtdhrs_org_id;
2699: l_org_tot_prov_hrs_id pa_amount_types_b.amount_type_id%TYPE
2700: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_tot_prvhrs_id;
2701: l_org_prov_wght_hrs_org_id pa_amount_types_b.amount_type_id%TYPE
2695: l_org_tot_hrs_id pa_amount_types_b.amount_type_id%TYPE
2696: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_tot_hrs_id;
2697: l_org_tot_wght_hrs_org_id pa_amount_types_b.amount_type_id%TYPE
2698: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_tot_wtdhrs_org_id;
2699: l_org_tot_prov_hrs_id pa_amount_types_b.amount_type_id%TYPE
2700: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_tot_prvhrs_id;
2701: l_org_prov_wght_hrs_org_id pa_amount_types_b.amount_type_id%TYPE
2702: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_tot_prvwtdhrs_org_id;
2703: l_org_tot_cap_id pa_amount_types_b.amount_type_id%TYPE
2697: l_org_tot_wght_hrs_org_id pa_amount_types_b.amount_type_id%TYPE
2698: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_tot_wtdhrs_org_id;
2699: l_org_tot_prov_hrs_id pa_amount_types_b.amount_type_id%TYPE
2700: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_tot_prvhrs_id;
2701: l_org_prov_wght_hrs_org_id pa_amount_types_b.amount_type_id%TYPE
2702: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_tot_prvwtdhrs_org_id;
2703: l_org_tot_cap_id pa_amount_types_b.amount_type_id%TYPE
2704: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_tot_cap_id;
2705: l_org_tot_reducedcap_id pa_amount_types_b.amount_type_id%TYPE
2699: l_org_tot_prov_hrs_id pa_amount_types_b.amount_type_id%TYPE
2700: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_tot_prvhrs_id;
2701: l_org_prov_wght_hrs_org_id pa_amount_types_b.amount_type_id%TYPE
2702: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_tot_prvwtdhrs_org_id;
2703: l_org_tot_cap_id pa_amount_types_b.amount_type_id%TYPE
2704: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_tot_cap_id;
2705: l_org_tot_reducedcap_id pa_amount_types_b.amount_type_id%TYPE
2706: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_tot_reducedcap_id;
2707: l_sub_org_tot_hrs_id pa_amount_types_b.amount_type_id%TYPE
2701: l_org_prov_wght_hrs_org_id pa_amount_types_b.amount_type_id%TYPE
2702: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_tot_prvwtdhrs_org_id;
2703: l_org_tot_cap_id pa_amount_types_b.amount_type_id%TYPE
2704: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_tot_cap_id;
2705: l_org_tot_reducedcap_id pa_amount_types_b.amount_type_id%TYPE
2706: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_tot_reducedcap_id;
2707: l_sub_org_tot_hrs_id pa_amount_types_b.amount_type_id%TYPE
2708: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_sub_hrs_id;
2709: l_sub_org_tot_prov_hrs_id pa_amount_types_b.amount_type_id%TYPE
2703: l_org_tot_cap_id pa_amount_types_b.amount_type_id%TYPE
2704: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_tot_cap_id;
2705: l_org_tot_reducedcap_id pa_amount_types_b.amount_type_id%TYPE
2706: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_tot_reducedcap_id;
2707: l_sub_org_tot_hrs_id pa_amount_types_b.amount_type_id%TYPE
2708: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_sub_hrs_id;
2709: l_sub_org_tot_prov_hrs_id pa_amount_types_b.amount_type_id%TYPE
2710: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_sub_prvhrs_id;
2711: l_sub_org_tot_wght_hrs_org_id pa_amount_types_b.amount_type_id%TYPE
2705: l_org_tot_reducedcap_id pa_amount_types_b.amount_type_id%TYPE
2706: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_tot_reducedcap_id;
2707: l_sub_org_tot_hrs_id pa_amount_types_b.amount_type_id%TYPE
2708: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_sub_hrs_id;
2709: l_sub_org_tot_prov_hrs_id pa_amount_types_b.amount_type_id%TYPE
2710: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_sub_prvhrs_id;
2711: l_sub_org_tot_wght_hrs_org_id pa_amount_types_b.amount_type_id%TYPE
2712: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_sub_wtdhrs_org_id;
2713: l_sub_org_prov_wght_hrs_org_id pa_amount_types_b.amount_type_id%TYPE
2707: l_sub_org_tot_hrs_id pa_amount_types_b.amount_type_id%TYPE
2708: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_sub_hrs_id;
2709: l_sub_org_tot_prov_hrs_id pa_amount_types_b.amount_type_id%TYPE
2710: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_sub_prvhrs_id;
2711: l_sub_org_tot_wght_hrs_org_id pa_amount_types_b.amount_type_id%TYPE
2712: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_sub_wtdhrs_org_id;
2713: l_sub_org_prov_wght_hrs_org_id pa_amount_types_b.amount_type_id%TYPE
2714: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_sub_prvwtdhrs_org_id;
2715: l_sub_org_cap_id pa_amount_types_b.amount_type_id%TYPE
2709: l_sub_org_tot_prov_hrs_id pa_amount_types_b.amount_type_id%TYPE
2710: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_sub_prvhrs_id;
2711: l_sub_org_tot_wght_hrs_org_id pa_amount_types_b.amount_type_id%TYPE
2712: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_sub_wtdhrs_org_id;
2713: l_sub_org_prov_wght_hrs_org_id pa_amount_types_b.amount_type_id%TYPE
2714: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_sub_prvwtdhrs_org_id;
2715: l_sub_org_cap_id pa_amount_types_b.amount_type_id%TYPE
2716: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_sub_cap_id;
2717: l_sub_org_reducedcap_id pa_amount_types_b.amount_type_id%TYPE
2711: l_sub_org_tot_wght_hrs_org_id pa_amount_types_b.amount_type_id%TYPE
2712: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_sub_wtdhrs_org_id;
2713: l_sub_org_prov_wght_hrs_org_id pa_amount_types_b.amount_type_id%TYPE
2714: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_sub_prvwtdhrs_org_id;
2715: l_sub_org_cap_id pa_amount_types_b.amount_type_id%TYPE
2716: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_sub_cap_id;
2717: l_sub_org_reducedcap_id pa_amount_types_b.amount_type_id%TYPE
2718: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_sub_reducedcap_id;
2719: /** End Cache sub org and total level amount types **/
2713: l_sub_org_prov_wght_hrs_org_id pa_amount_types_b.amount_type_id%TYPE
2714: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_sub_prvwtdhrs_org_id;
2715: l_sub_org_cap_id pa_amount_types_b.amount_type_id%TYPE
2716: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_sub_cap_id;
2717: l_sub_org_reducedcap_id pa_amount_types_b.amount_type_id%TYPE
2718: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_sub_reducedcap_id;
2719: /** End Cache sub org and total level amount types **/
2720:
2721: