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

Line 8: l_org_dir_hrs_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_dir_hrs_id;

4: /*
5: * Amount type ids - locally cached at the
6: * package level.
7: */
8: l_org_dir_hrs_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_dir_hrs_id;
9: l_org_dir_wtdhrs_org_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_dir_wtdhrs_org_id;
10: l_org_dir_prvhrs_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_dir_prvhrs_id;
11: l_org_dir_prvwtdhrs_org_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_dir_prvwtdhrs_org_id;
12: l_org_dir_cap_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_dir_cap_id;

Line 9: l_org_dir_wtdhrs_org_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_dir_wtdhrs_org_id;

5: * Amount type ids - locally cached at the
6: * package level.
7: */
8: l_org_dir_hrs_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_dir_hrs_id;
9: l_org_dir_wtdhrs_org_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_dir_wtdhrs_org_id;
10: l_org_dir_prvhrs_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_dir_prvhrs_id;
11: l_org_dir_prvwtdhrs_org_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_dir_prvwtdhrs_org_id;
12: l_org_dir_cap_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_dir_cap_id;
13: l_org_dir_reducedcap_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_dir_reducedcap_id;

Line 10: l_org_dir_prvhrs_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_dir_prvhrs_id;

6: * package level.
7: */
8: l_org_dir_hrs_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_dir_hrs_id;
9: l_org_dir_wtdhrs_org_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_dir_wtdhrs_org_id;
10: l_org_dir_prvhrs_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_dir_prvhrs_id;
11: l_org_dir_prvwtdhrs_org_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_dir_prvwtdhrs_org_id;
12: l_org_dir_cap_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_dir_cap_id;
13: l_org_dir_reducedcap_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_dir_reducedcap_id;
14:

Line 11: l_org_dir_prvwtdhrs_org_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_dir_prvwtdhrs_org_id;

7: */
8: l_org_dir_hrs_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_dir_hrs_id;
9: l_org_dir_wtdhrs_org_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_dir_wtdhrs_org_id;
10: l_org_dir_prvhrs_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_dir_prvhrs_id;
11: l_org_dir_prvwtdhrs_org_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_dir_prvwtdhrs_org_id;
12: l_org_dir_cap_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_dir_cap_id;
13: l_org_dir_reducedcap_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_dir_reducedcap_id;
14:
15: l_org_sub_hrs_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_sub_hrs_id;

Line 12: l_org_dir_cap_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_dir_cap_id;

8: l_org_dir_hrs_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_dir_hrs_id;
9: l_org_dir_wtdhrs_org_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_dir_wtdhrs_org_id;
10: l_org_dir_prvhrs_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_dir_prvhrs_id;
11: l_org_dir_prvwtdhrs_org_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_dir_prvwtdhrs_org_id;
12: l_org_dir_cap_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_dir_cap_id;
13: l_org_dir_reducedcap_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_dir_reducedcap_id;
14:
15: l_org_sub_hrs_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_sub_hrs_id;
16: l_org_sub_wtdhrs_org_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_sub_wtdhrs_org_id;

Line 13: l_org_dir_reducedcap_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_dir_reducedcap_id;

9: l_org_dir_wtdhrs_org_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_dir_wtdhrs_org_id;
10: l_org_dir_prvhrs_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_dir_prvhrs_id;
11: l_org_dir_prvwtdhrs_org_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_dir_prvwtdhrs_org_id;
12: l_org_dir_cap_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_dir_cap_id;
13: l_org_dir_reducedcap_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_dir_reducedcap_id;
14:
15: l_org_sub_hrs_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_sub_hrs_id;
16: l_org_sub_wtdhrs_org_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_sub_wtdhrs_org_id;
17: l_org_sub_prvhrs_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_sub_prvhrs_id;

Line 15: l_org_sub_hrs_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_sub_hrs_id;

11: l_org_dir_prvwtdhrs_org_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_dir_prvwtdhrs_org_id;
12: l_org_dir_cap_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_dir_cap_id;
13: l_org_dir_reducedcap_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_dir_reducedcap_id;
14:
15: l_org_sub_hrs_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_sub_hrs_id;
16: l_org_sub_wtdhrs_org_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_sub_wtdhrs_org_id;
17: l_org_sub_prvhrs_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_sub_prvhrs_id;
18: l_org_sub_prvwtdhrs_org_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_sub_prvwtdhrs_org_id;
19: l_org_sub_cap_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_sub_cap_id;

Line 16: l_org_sub_wtdhrs_org_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_sub_wtdhrs_org_id;

12: l_org_dir_cap_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_dir_cap_id;
13: l_org_dir_reducedcap_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_dir_reducedcap_id;
14:
15: l_org_sub_hrs_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_sub_hrs_id;
16: l_org_sub_wtdhrs_org_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_sub_wtdhrs_org_id;
17: l_org_sub_prvhrs_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_sub_prvhrs_id;
18: l_org_sub_prvwtdhrs_org_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_sub_prvwtdhrs_org_id;
19: l_org_sub_cap_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_sub_cap_id;
20: l_org_sub_reducedcap_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_sub_reducedcap_id;

Line 17: l_org_sub_prvhrs_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_sub_prvhrs_id;

13: l_org_dir_reducedcap_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_dir_reducedcap_id;
14:
15: l_org_sub_hrs_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_sub_hrs_id;
16: l_org_sub_wtdhrs_org_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_sub_wtdhrs_org_id;
17: l_org_sub_prvhrs_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_sub_prvhrs_id;
18: l_org_sub_prvwtdhrs_org_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_sub_prvwtdhrs_org_id;
19: l_org_sub_cap_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_sub_cap_id;
20: l_org_sub_reducedcap_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_sub_reducedcap_id;
21:

Line 18: l_org_sub_prvwtdhrs_org_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_sub_prvwtdhrs_org_id;

14:
15: l_org_sub_hrs_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_sub_hrs_id;
16: l_org_sub_wtdhrs_org_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_sub_wtdhrs_org_id;
17: l_org_sub_prvhrs_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_sub_prvhrs_id;
18: l_org_sub_prvwtdhrs_org_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_sub_prvwtdhrs_org_id;
19: l_org_sub_cap_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_sub_cap_id;
20: l_org_sub_reducedcap_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_sub_reducedcap_id;
21:
22: l_org_tot_hrs_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_tot_hrs_id;

Line 19: l_org_sub_cap_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_sub_cap_id;

15: l_org_sub_hrs_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_sub_hrs_id;
16: l_org_sub_wtdhrs_org_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_sub_wtdhrs_org_id;
17: l_org_sub_prvhrs_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_sub_prvhrs_id;
18: l_org_sub_prvwtdhrs_org_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_sub_prvwtdhrs_org_id;
19: l_org_sub_cap_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_sub_cap_id;
20: l_org_sub_reducedcap_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_sub_reducedcap_id;
21:
22: l_org_tot_hrs_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_tot_hrs_id;
23: l_org_tot_wtdhrs_org_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_tot_wtdhrs_org_id;

Line 20: l_org_sub_reducedcap_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_sub_reducedcap_id;

16: l_org_sub_wtdhrs_org_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_sub_wtdhrs_org_id;
17: l_org_sub_prvhrs_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_sub_prvhrs_id;
18: l_org_sub_prvwtdhrs_org_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_sub_prvwtdhrs_org_id;
19: l_org_sub_cap_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_sub_cap_id;
20: l_org_sub_reducedcap_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_sub_reducedcap_id;
21:
22: l_org_tot_hrs_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_tot_hrs_id;
23: l_org_tot_wtdhrs_org_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_tot_wtdhrs_org_id;
24: l_org_tot_prvhrs_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_tot_prvhrs_id;

Line 22: l_org_tot_hrs_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_tot_hrs_id;

18: l_org_sub_prvwtdhrs_org_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_sub_prvwtdhrs_org_id;
19: l_org_sub_cap_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_sub_cap_id;
20: l_org_sub_reducedcap_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_sub_reducedcap_id;
21:
22: l_org_tot_hrs_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_tot_hrs_id;
23: l_org_tot_wtdhrs_org_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_tot_wtdhrs_org_id;
24: l_org_tot_prvhrs_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_tot_prvhrs_id;
25: l_org_tot_prvwtdhrs_org_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_tot_prvwtdhrs_org_id;
26: l_org_tot_cap_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_tot_cap_id;

Line 23: l_org_tot_wtdhrs_org_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_tot_wtdhrs_org_id;

19: l_org_sub_cap_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_sub_cap_id;
20: l_org_sub_reducedcap_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_sub_reducedcap_id;
21:
22: l_org_tot_hrs_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_tot_hrs_id;
23: l_org_tot_wtdhrs_org_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_tot_wtdhrs_org_id;
24: l_org_tot_prvhrs_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_tot_prvhrs_id;
25: l_org_tot_prvwtdhrs_org_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_tot_prvwtdhrs_org_id;
26: l_org_tot_cap_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_tot_cap_id;
27: l_org_tot_reducedcap_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_tot_reducedcap_id;

Line 24: l_org_tot_prvhrs_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_tot_prvhrs_id;

20: l_org_sub_reducedcap_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_sub_reducedcap_id;
21:
22: l_org_tot_hrs_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_tot_hrs_id;
23: l_org_tot_wtdhrs_org_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_tot_wtdhrs_org_id;
24: l_org_tot_prvhrs_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_tot_prvhrs_id;
25: l_org_tot_prvwtdhrs_org_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_tot_prvwtdhrs_org_id;
26: l_org_tot_cap_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_tot_cap_id;
27: l_org_tot_reducedcap_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_tot_reducedcap_id;
28:

Line 25: l_org_tot_prvwtdhrs_org_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_tot_prvwtdhrs_org_id;

21:
22: l_org_tot_hrs_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_tot_hrs_id;
23: l_org_tot_wtdhrs_org_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_tot_wtdhrs_org_id;
24: l_org_tot_prvhrs_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_tot_prvhrs_id;
25: l_org_tot_prvwtdhrs_org_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_tot_prvwtdhrs_org_id;
26: l_org_tot_cap_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_tot_cap_id;
27: l_org_tot_reducedcap_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_tot_reducedcap_id;
28:
29: /*

Line 26: l_org_tot_cap_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_tot_cap_id;

22: l_org_tot_hrs_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_tot_hrs_id;
23: l_org_tot_wtdhrs_org_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_tot_wtdhrs_org_id;
24: l_org_tot_prvhrs_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_tot_prvhrs_id;
25: l_org_tot_prvwtdhrs_org_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_tot_prvwtdhrs_org_id;
26: l_org_tot_cap_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_tot_cap_id;
27: l_org_tot_reducedcap_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_tot_reducedcap_id;
28:
29: /*
30: * Object types locally cached at the package level.

Line 27: l_org_tot_reducedcap_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_tot_reducedcap_id;

23: l_org_tot_wtdhrs_org_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_tot_wtdhrs_org_id;
24: l_org_tot_prvhrs_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_tot_prvhrs_id;
25: l_org_tot_prvwtdhrs_org_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_tot_prvwtdhrs_org_id;
26: l_org_tot_cap_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_tot_cap_id;
27: l_org_tot_reducedcap_id pa_amount_types_b.amount_type_id%TYPE := pa_rep_util_glob.G_amt_type_details.G_org_tot_reducedcap_id;
28:
29: /*
30: * Object types locally cached at the package level.
31: */

Line 32: l_obj_type_orgwt VARCHAR2(15) := pa_rep_util_glob.G_OBJ_TYPE_C.G_ORGWT_C;

28:
29: /*
30: * Object types locally cached at the package level.
31: */
32: l_obj_type_orgwt VARCHAR2(15) := pa_rep_util_glob.G_OBJ_TYPE_C.G_ORGWT_C;
33: l_obj_type_orguc VARCHAR2(15) := pa_rep_util_glob.G_OBJ_TYPE_C.G_ORGUC_C;
34: l_obj_type_org VARCHAR2(15) := pa_rep_util_glob.G_OBJ_TYPE_C.G_ORG_C;
35:
36: /*

Line 33: l_obj_type_orguc VARCHAR2(15) := pa_rep_util_glob.G_OBJ_TYPE_C.G_ORGUC_C;

29: /*
30: * Object types locally cached at the package level.
31: */
32: l_obj_type_orgwt VARCHAR2(15) := pa_rep_util_glob.G_OBJ_TYPE_C.G_ORGWT_C;
33: l_obj_type_orguc VARCHAR2(15) := pa_rep_util_glob.G_OBJ_TYPE_C.G_ORGUC_C;
34: l_obj_type_org VARCHAR2(15) := pa_rep_util_glob.G_OBJ_TYPE_C.G_ORG_C;
35:
36: /*
37: * Org ids locally cached at the package level.

Line 34: l_obj_type_org VARCHAR2(15) := pa_rep_util_glob.G_OBJ_TYPE_C.G_ORG_C;

30: * Object types locally cached at the package level.
31: */
32: l_obj_type_orgwt VARCHAR2(15) := pa_rep_util_glob.G_OBJ_TYPE_C.G_ORGWT_C;
33: l_obj_type_orguc VARCHAR2(15) := pa_rep_util_glob.G_OBJ_TYPE_C.G_ORGUC_C;
34: l_obj_type_org VARCHAR2(15) := pa_rep_util_glob.G_OBJ_TYPE_C.G_ORG_C;
35:
36: /*
37: * Org ids locally cached at the package level.
38: */

Line 39: l_start_org_id pa_implementations_all.start_organization_id%TYPE := pa_rep_util_glob.G_implementation_details.G_start_organization_id;

35:
36: /*
37: * Org ids locally cached at the package level.
38: */
39: l_start_org_id pa_implementations_all.start_organization_id%TYPE := pa_rep_util_glob.G_implementation_details.G_start_organization_id;
40: l_org_id pa_implementations_all.org_id%TYPE := pa_rep_util_glob.G_implementation_details.G_org_id;
41: l_org_structure_version_id pa_implementations_all.org_id%TYPE := pa_rep_util_glob.G_implementation_details.G_org_structure_version_id;
42:
43: /*

Line 40: l_org_id pa_implementations_all.org_id%TYPE := pa_rep_util_glob.G_implementation_details.G_org_id;

36: /*
37: * Org ids locally cached at the package level.
38: */
39: l_start_org_id pa_implementations_all.start_organization_id%TYPE := pa_rep_util_glob.G_implementation_details.G_start_organization_id;
40: l_org_id pa_implementations_all.org_id%TYPE := pa_rep_util_glob.G_implementation_details.G_org_id;
41: l_org_structure_version_id pa_implementations_all.org_id%TYPE := pa_rep_util_glob.G_implementation_details.G_org_structure_version_id;
42:
43: /*
44: * Period Set Name locally cached at the package level.

Line 41: l_org_structure_version_id pa_implementations_all.org_id%TYPE := pa_rep_util_glob.G_implementation_details.G_org_structure_version_id;

37: * Org ids locally cached at the package level.
38: */
39: l_start_org_id pa_implementations_all.start_organization_id%TYPE := pa_rep_util_glob.G_implementation_details.G_start_organization_id;
40: l_org_id pa_implementations_all.org_id%TYPE := pa_rep_util_glob.G_implementation_details.G_org_id;
41: l_org_structure_version_id pa_implementations_all.org_id%TYPE := pa_rep_util_glob.G_implementation_details.G_org_structure_version_id;
42:
43: /*
44: * Period Set Name locally cached at the package level.
45: * Changed for bug 3434019

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

43: /*
44: * Period Set Name locally cached at the package level.
45: * Changed for bug 3434019
46: */
47: -- l_period_set_name gl_sets_of_books.period_set_name%TYPE := pa_rep_util_glob.G_implementation_details.G_period_set_name;
48: 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;
49: 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;
50:
51: /*

Line 48: 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;

44: * Period Set Name locally cached at the package level.
45: * Changed for bug 3434019
46: */
47: -- l_period_set_name gl_sets_of_books.period_set_name%TYPE := pa_rep_util_glob.G_implementation_details.G_period_set_name;
48: 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;
49: 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;
50:
51: /*
52: * Commit and Fetch Sizes locally cached at the package level.

Line 49: 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;

45: * Changed for bug 3434019
46: */
47: -- l_period_set_name gl_sets_of_books.period_set_name%TYPE := pa_rep_util_glob.G_implementation_details.G_period_set_name;
48: 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;
49: 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;
50:
51: /*
52: * Commit and Fetch Sizes locally cached at the package level.
53: */

Line 54: l_commit_size PLS_INTEGER := pa_rep_util_glob.G_util_fetch_size;

50:
51: /*
52: * Commit and Fetch Sizes locally cached at the package level.
53: */
54: l_commit_size PLS_INTEGER := pa_rep_util_glob.G_util_fetch_size;
55: l_fetch_size PLS_INTEGER := pa_rep_util_glob.G_util_fetch_size;
56:
57: /*
58: * Unit of measure locally cached at the package level.

Line 55: l_fetch_size PLS_INTEGER := pa_rep_util_glob.G_util_fetch_size;

51: /*
52: * Commit and Fetch Sizes locally cached at the package level.
53: */
54: l_commit_size PLS_INTEGER := pa_rep_util_glob.G_util_fetch_size;
55: l_fetch_size PLS_INTEGER := pa_rep_util_glob.G_util_fetch_size;
56:
57: /*
58: * Unit of measure locally cached at the package level.
59: */

Line 60: l_unit_of_measure VARCHAR2(10) := pa_rep_util_glob.G_UNIT_OF_MEASURE_HRS_C;

56:
57: /*
58: * Unit of measure locally cached at the package level.
59: */
60: l_unit_of_measure VARCHAR2(10) := pa_rep_util_glob.G_UNIT_OF_MEASURE_HRS_C;
61:
62: /*
63: * Dummy Date locally cached at the package level.
64: */

Line 65: l_dummy_date DATE := pa_rep_util_glob.G_DUMMY_DATE_C;

61:
62: /*
63: * Dummy Date locally cached at the package level.
64: */
65: l_dummy_date DATE := pa_rep_util_glob.G_DUMMY_DATE_C;
66: l_dummy_period_set_name VARCHAR2(15) := PA_REP_UTIL_GLOB.G_DUMMY_C;
67:
68:
69: /*

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

62: /*
63: * Dummy Date locally cached at the package level.
64: */
65: l_dummy_date DATE := pa_rep_util_glob.G_DUMMY_DATE_C;
66: l_dummy_period_set_name VARCHAR2(15) := PA_REP_UTIL_GLOB.G_DUMMY_C;
67:
68:
69: /*
70: * Level of the start_org_id.

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

80: P_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N'); /* Added Debug Profile Option variable initialization for bug#2674619 */
81:
82: PROCEDURE refresh_org_hierarchy_rollup( p_balance_type_code IN VARCHAR2)
83: IS
84: l_pa_period_flag pa_utilization_options.pa_period_flag%TYPE := pa_rep_util_glob.G_util_option_details.G_pa_period_flag;
85: l_gl_period_flag pa_utilization_options.gl_period_flag%TYPE := pa_rep_util_glob.G_util_option_details.G_gl_period_flag;
86: l_ge_period_flag pa_utilization_options.global_exp_period_flag%TYPE := pa_rep_util_glob.G_util_option_details.G_ge_period_flag;
87:
88: /*

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

81:
82: PROCEDURE refresh_org_hierarchy_rollup( p_balance_type_code IN VARCHAR2)
83: IS
84: l_pa_period_flag pa_utilization_options.pa_period_flag%TYPE := pa_rep_util_glob.G_util_option_details.G_pa_period_flag;
85: l_gl_period_flag pa_utilization_options.gl_period_flag%TYPE := pa_rep_util_glob.G_util_option_details.G_gl_period_flag;
86: l_ge_period_flag pa_utilization_options.global_exp_period_flag%TYPE := pa_rep_util_glob.G_util_option_details.G_ge_period_flag;
87:
88: /*
89: * pa and gl period types.

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

82: PROCEDURE refresh_org_hierarchy_rollup( p_balance_type_code IN VARCHAR2)
83: IS
84: l_pa_period_flag pa_utilization_options.pa_period_flag%TYPE := pa_rep_util_glob.G_util_option_details.G_pa_period_flag;
85: l_gl_period_flag pa_utilization_options.gl_period_flag%TYPE := pa_rep_util_glob.G_util_option_details.G_gl_period_flag;
86: l_ge_period_flag pa_utilization_options.global_exp_period_flag%TYPE := pa_rep_util_glob.G_util_option_details.G_ge_period_flag;
87:
88: /*
89: * pa and gl period types.
90: */

Line 91: l_pa_period_type pa_implementations_all.pa_period_type%TYPE := pa_rep_util_glob.G_implementation_details.G_pa_period_type;

87:
88: /*
89: * pa and gl period types.
90: */
91: l_pa_period_type pa_implementations_all.pa_period_type%TYPE := pa_rep_util_glob.G_implementation_details.G_pa_period_type;
92: l_gl_period_type gl_sets_of_books.accounted_period_type%TYPE := pa_rep_util_glob.G_implementation_details.G_gl_period_type;
93:
94: /*
95: * Constants for 'PA' and 'GL'.

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

88: /*
89: * pa and gl period types.
90: */
91: l_pa_period_type pa_implementations_all.pa_period_type%TYPE := pa_rep_util_glob.G_implementation_details.G_pa_period_type;
92: l_gl_period_type gl_sets_of_books.accounted_period_type%TYPE := pa_rep_util_glob.G_implementation_details.G_gl_period_type;
93:
94: /*
95: * Constants for 'PA' and 'GL'.
96: */

Line 97: l_period_type_pa VARCHAR2(3) := pa_rep_util_glob.G_PERIOD_TYPE_C.G_PA_C;

93:
94: /*
95: * Constants for 'PA' and 'GL'.
96: */
97: l_period_type_pa VARCHAR2(3) := pa_rep_util_glob.G_PERIOD_TYPE_C.G_PA_C;
98: l_period_type_gl VARCHAR2(3) := pa_rep_util_glob.G_PERIOD_TYPE_C.G_GL_C;
99: l_period_type_ge VARCHAR2(3) := pa_rep_util_glob.G_PERIOD_TYPE_C.G_GE_C;
100:
101: l_balance_type_code pa_objects.balance_type_code%TYPE;

Line 98: l_period_type_gl VARCHAR2(3) := pa_rep_util_glob.G_PERIOD_TYPE_C.G_GL_C;

94: /*
95: * Constants for 'PA' and 'GL'.
96: */
97: l_period_type_pa VARCHAR2(3) := pa_rep_util_glob.G_PERIOD_TYPE_C.G_PA_C;
98: l_period_type_gl VARCHAR2(3) := pa_rep_util_glob.G_PERIOD_TYPE_C.G_GL_C;
99: l_period_type_ge VARCHAR2(3) := pa_rep_util_glob.G_PERIOD_TYPE_C.G_GE_C;
100:
101: l_balance_type_code pa_objects.balance_type_code%TYPE;
102: l_eff_start_pa_period_num PLS_INTEGER;

Line 99: l_period_type_ge VARCHAR2(3) := pa_rep_util_glob.G_PERIOD_TYPE_C.G_GE_C;

95: * Constants for 'PA' and 'GL'.
96: */
97: l_period_type_pa VARCHAR2(3) := pa_rep_util_glob.G_PERIOD_TYPE_C.G_PA_C;
98: l_period_type_gl VARCHAR2(3) := pa_rep_util_glob.G_PERIOD_TYPE_C.G_GL_C;
99: l_period_type_ge VARCHAR2(3) := pa_rep_util_glob.G_PERIOD_TYPE_C.G_GE_C;
100:
101: l_balance_type_code pa_objects.balance_type_code%TYPE;
102: l_eff_start_pa_period_num PLS_INTEGER;
103: l_eff_start_gl_period_num PLS_INTEGER;

Line 115: l_start_date := pa_rep_util_glob.G_input_parameters.G_ac_start_date;

111: END IF;
112: l_balance_type_code := p_balance_type_code;
113:
114: IF (l_balance_type_code = 'ACTUALS') THEN
115: l_start_date := pa_rep_util_glob.G_input_parameters.G_ac_start_date;
116: l_end_date := pa_rep_util_glob.G_input_parameters.G_ac_end_date;
117: l_eff_start_pa_period_num := pa_rep_util_glob.G_eff_ac_start_pa_period_num;
118: l_eff_start_gl_period_num := pa_rep_util_glob.G_eff_ac_start_gl_period_num;
119: ELSIF (l_balance_type_code = 'FORECAST') THEN

Line 116: l_end_date := pa_rep_util_glob.G_input_parameters.G_ac_end_date;

112: l_balance_type_code := p_balance_type_code;
113:
114: IF (l_balance_type_code = 'ACTUALS') THEN
115: l_start_date := pa_rep_util_glob.G_input_parameters.G_ac_start_date;
116: l_end_date := pa_rep_util_glob.G_input_parameters.G_ac_end_date;
117: l_eff_start_pa_period_num := pa_rep_util_glob.G_eff_ac_start_pa_period_num;
118: l_eff_start_gl_period_num := pa_rep_util_glob.G_eff_ac_start_gl_period_num;
119: ELSIF (l_balance_type_code = 'FORECAST') THEN
120: l_start_date := pa_rep_util_glob.G_input_parameters.G_fc_start_date;

Line 117: l_eff_start_pa_period_num := pa_rep_util_glob.G_eff_ac_start_pa_period_num;

113:
114: IF (l_balance_type_code = 'ACTUALS') THEN
115: l_start_date := pa_rep_util_glob.G_input_parameters.G_ac_start_date;
116: l_end_date := pa_rep_util_glob.G_input_parameters.G_ac_end_date;
117: l_eff_start_pa_period_num := pa_rep_util_glob.G_eff_ac_start_pa_period_num;
118: l_eff_start_gl_period_num := pa_rep_util_glob.G_eff_ac_start_gl_period_num;
119: ELSIF (l_balance_type_code = 'FORECAST') THEN
120: l_start_date := pa_rep_util_glob.G_input_parameters.G_fc_start_date;
121: l_end_date := pa_rep_util_glob.G_input_parameters.G_fc_end_date;

Line 118: l_eff_start_gl_period_num := pa_rep_util_glob.G_eff_ac_start_gl_period_num;

114: IF (l_balance_type_code = 'ACTUALS') THEN
115: l_start_date := pa_rep_util_glob.G_input_parameters.G_ac_start_date;
116: l_end_date := pa_rep_util_glob.G_input_parameters.G_ac_end_date;
117: l_eff_start_pa_period_num := pa_rep_util_glob.G_eff_ac_start_pa_period_num;
118: l_eff_start_gl_period_num := pa_rep_util_glob.G_eff_ac_start_gl_period_num;
119: ELSIF (l_balance_type_code = 'FORECAST') THEN
120: l_start_date := pa_rep_util_glob.G_input_parameters.G_fc_start_date;
121: l_end_date := pa_rep_util_glob.G_input_parameters.G_fc_end_date;
122: l_eff_start_pa_period_num := pa_rep_util_glob.G_eff_fc_start_pa_period_num;

Line 120: l_start_date := pa_rep_util_glob.G_input_parameters.G_fc_start_date;

116: l_end_date := pa_rep_util_glob.G_input_parameters.G_ac_end_date;
117: l_eff_start_pa_period_num := pa_rep_util_glob.G_eff_ac_start_pa_period_num;
118: l_eff_start_gl_period_num := pa_rep_util_glob.G_eff_ac_start_gl_period_num;
119: ELSIF (l_balance_type_code = 'FORECAST') THEN
120: l_start_date := pa_rep_util_glob.G_input_parameters.G_fc_start_date;
121: l_end_date := pa_rep_util_glob.G_input_parameters.G_fc_end_date;
122: l_eff_start_pa_period_num := pa_rep_util_glob.G_eff_fc_start_pa_period_num;
123: l_eff_start_gl_period_num := pa_rep_util_glob.G_eff_fc_start_gl_period_num;
124: END IF;

Line 121: l_end_date := pa_rep_util_glob.G_input_parameters.G_fc_end_date;

117: l_eff_start_pa_period_num := pa_rep_util_glob.G_eff_ac_start_pa_period_num;
118: l_eff_start_gl_period_num := pa_rep_util_glob.G_eff_ac_start_gl_period_num;
119: ELSIF (l_balance_type_code = 'FORECAST') THEN
120: l_start_date := pa_rep_util_glob.G_input_parameters.G_fc_start_date;
121: l_end_date := pa_rep_util_glob.G_input_parameters.G_fc_end_date;
122: l_eff_start_pa_period_num := pa_rep_util_glob.G_eff_fc_start_pa_period_num;
123: l_eff_start_gl_period_num := pa_rep_util_glob.G_eff_fc_start_gl_period_num;
124: END IF;
125:

Line 122: l_eff_start_pa_period_num := pa_rep_util_glob.G_eff_fc_start_pa_period_num;

118: l_eff_start_gl_period_num := pa_rep_util_glob.G_eff_ac_start_gl_period_num;
119: ELSIF (l_balance_type_code = 'FORECAST') THEN
120: l_start_date := pa_rep_util_glob.G_input_parameters.G_fc_start_date;
121: l_end_date := pa_rep_util_glob.G_input_parameters.G_fc_end_date;
122: l_eff_start_pa_period_num := pa_rep_util_glob.G_eff_fc_start_pa_period_num;
123: l_eff_start_gl_period_num := pa_rep_util_glob.G_eff_fc_start_gl_period_num;
124: END IF;
125:
126: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */

Line 123: l_eff_start_gl_period_num := pa_rep_util_glob.G_eff_fc_start_gl_period_num;

119: ELSIF (l_balance_type_code = 'FORECAST') THEN
120: l_start_date := pa_rep_util_glob.G_input_parameters.G_fc_start_date;
121: l_end_date := pa_rep_util_glob.G_input_parameters.G_fc_end_date;
122: l_eff_start_pa_period_num := pa_rep_util_glob.G_eff_fc_start_pa_period_num;
123: l_eff_start_gl_period_num := pa_rep_util_glob.G_eff_fc_start_gl_period_num;
124: END IF;
125:
126: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
127: PA_DEBUG.g_err_stage := '100:Balance Type is [' || l_balance_type_code || ']';

Line 493: AND bal.period_set_name = decode(bal.period_type, pa_rep_util_glob.G_PERIOD_TYPE_C.G_PA_C, l_pa_period_set_name, l_gl_period_set_name) -- bug 3434019

489: AND bal.version_id = -1
490: AND bal.period_num >= p_effective_start_period_num
491: AND bal.period_type = p_period_type
492: -- AND bal.period_set_name = l_period_set_name
493: AND bal.period_set_name = decode(bal.period_type, pa_rep_util_glob.G_PERIOD_TYPE_C.G_PA_C, l_pa_period_set_name, l_gl_period_set_name) -- bug 3434019
494: AND bal.object_type_code = obj.object_type_code
495: AND obj.expenditure_organization_id = hier.child_organization_id
496: AND obj.expenditure_org_id = p_org_id
497: AND obj.balance_type_code = p_balance_type_code

Line 570: AND bal.period_set_name = decode(bal.period_type, pa_rep_util_glob.G_PERIOD_TYPE_C.G_PA_C, l_pa_period_set_name, l_gl_period_set_name) -- bug 3434019

566: AND bal.version_id = -1
567: AND bal.period_num >= p_effective_start_period_num
568: AND bal.period_type = p_period_type
569: -- AND bal.period_set_name = l_period_set_name
570: AND bal.period_set_name = decode(bal.period_type, pa_rep_util_glob.G_PERIOD_TYPE_C.G_PA_C, l_pa_period_set_name, l_gl_period_set_name) -- bug 3434019
571: AND bal.amount_type_id IN ( l_org_tot_hrs_id
572: ,l_org_tot_wtdhrs_org_id
573: ,l_org_tot_prvhrs_id
574: ,l_org_tot_prvwtdhrs_org_id

Line 773: ,decode(p_period_type, pa_rep_util_glob.G_PERIOD_TYPE_C.G_PA_C, l_pa_period_set_name, l_gl_period_set_name) -- bug 3434019

769: ,-1
770: ,l_object_type_code_tab(i)
771: ,p_period_type
772: -- ,l_period_set_name
773: ,decode(p_period_type, pa_rep_util_glob.G_PERIOD_TYPE_C.G_PA_C, l_pa_period_set_name, l_gl_period_set_name) -- bug 3434019
774: ,l_period_name_tab(i)
775: ,l_dummy_date
776: ,l_period_year_tab(i)
777: ,l_quarter_or_month_number_tab(i)

Line 902: ,decode(p_period_type, pa_rep_util_glob.G_PERIOD_TYPE_C.G_PA_C, l_pa_period_set_name, l_gl_period_set_name) -- bug 3434019

898: ,-1
899: ,l_object_type_code_tab(i)
900: ,p_period_type
901: -- ,l_period_set_name
902: ,decode(p_period_type, pa_rep_util_glob.G_PERIOD_TYPE_C.G_PA_C, l_pa_period_set_name, l_gl_period_set_name) -- bug 3434019
903: ,l_period_name_tab(i)
904: ,l_dummy_date
905: ,l_period_year_tab(i)
906: ,l_quarter_or_month_number_tab(i)

Line 937: AND bal.period_set_name = decode(bal.period_type, pa_rep_util_glob.G_PERIOD_TYPE_C.G_PA_C, l_pa_period_set_name, l_gl_period_set_name) -- bug 3434019

933: AND bal.version_id = -1
934: AND bal.object_type_code = l_object_type_code_tab(i)
935: AND bal.period_type = p_period_type
936: -- AND bal.period_set_name = l_period_set_name
937: AND bal.period_set_name = decode(bal.period_type, pa_rep_util_glob.G_PERIOD_TYPE_C.G_PA_C, l_pa_period_set_name, l_gl_period_set_name) -- bug 3434019
938: AND bal.period_name = l_period_name_tab(i)
939: -- AND bal.global_exp_period_end_date = l_ge_period_end_date_tab(i)
940: AND bal.global_exp_period_end_date = l_dummy_date
941: AND bal.period_year = l_period_year_tab(i)

Line 987: ,decode(p_period_type, pa_rep_util_glob.G_PERIOD_TYPE_C.G_PA_C, l_pa_period_set_name, l_gl_period_set_name) -- bug 3434019

983: ,-1
984: ,l_object_type_code_tab(i)
985: ,p_period_type
986: -- ,l_period_set_name
987: ,decode(p_period_type, pa_rep_util_glob.G_PERIOD_TYPE_C.G_PA_C, l_pa_period_set_name, l_gl_period_set_name) -- bug 3434019
988: ,l_period_name_tab(i)
989: ,l_dummy_date
990: ,l_period_year_tab(i)
991: ,l_quarter_or_month_number_tab(i)

Line 1363: ,decode(p_period_type, pa_rep_util_glob.G_PERIOD_TYPE_C.G_PA_C, l_pa_period_set_name, l_gl_period_set_name) -- bug 3434019

1359: ,-1
1360: ,l_object_type_code_tab(i)
1361: ,p_period_type
1362: -- ,l_dummy_period_set_name
1363: ,decode(p_period_type, pa_rep_util_glob.G_PERIOD_TYPE_C.G_PA_C, l_pa_period_set_name, l_gl_period_set_name) -- bug 3434019
1364: ,l_period_name_tab(i)
1365: ,l_ge_period_end_date_tab(i)
1366: ,l_period_year_tab(i)
1367: ,l_quarter_or_month_number_tab(i)