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.PQH_MGMT_RPT_PKG dependencies on PER_SHARED_TYPES

Line 23: From per_shared_types

19: Budget Unit */
20: --
21: Cursor csr_budget_measurement_type is
22: Select system_type_cd
23: From per_shared_types
24: Where shared_type_id = p_unit_of_measure_id
25: AND lookup_type = 'BUDGET_MEASUREMENT_TYPE';
26: --
27: l_proc varchar2(72) := g_package||'get_budget_measurement_type';

Line 29: l_budget_measurement_type per_shared_types.system_type_cd%TYPE;

25: AND lookup_type = 'BUDGET_MEASUREMENT_TYPE';
26: --
27: l_proc varchar2(72) := g_package||'get_budget_measurement_type';
28: --
29: l_budget_measurement_type per_shared_types.system_type_cd%TYPE;
30: --
31: Begin
32: --
33: hr_utility.set_location('Entering:'||l_proc, 5);

Line 35: -- Check if the unit of measure exists in per_shared_types

31: Begin
32: --
33: hr_utility.set_location('Entering:'||l_proc, 5);
34: --
35: -- Check if the unit of measure exists in per_shared_types
36: --
37: Open csr_budget_measurement_type;
38: --
39: Fetch csr_budget_measurement_type into l_budget_measurement_type;

Line 791: l_budget_measurement_type per_shared_types.system_type_cd%TYPE;

787: p_budgeted_or_cmmt IN varchar2
788: )
789: RETURN NUMBER IS
790: l_curr_ver_tot number := 0;
791: l_budget_measurement_type per_shared_types.system_type_cd%TYPE;
792:
793: BEGIN
794: IF (p_summarize_by in ('BUDGET', 'ELEMENT')) THEN
795: --

Line 1043: l_budget_measurement_type per_shared_types.system_type_cd%TYPE;

1039: l_total_amt NUMBER := 0;
1040: l_curr_ver_tot NUMBER := 0;
1041: l_budget_version_id pqh_budget_versions.budget_version_id%TYPE;
1042: l_currency_code fnd_currencies.currency_code%TYPE;
1043: l_budget_measurement_type per_shared_types.system_type_cd%TYPE;
1044: l_business_group_id number;
1045:
1046: CURSOR csr_bdgts_job(p_business_group_id number) IS
1047: SELECT

Line 1379: l_budget_measurement_type per_shared_types.system_type_cd%TYPE;

1375: l_total_amt NUMBER := 0;
1376: l_curr_ver_tot NUMBER := 0;
1377: l_budget_version_id pqh_budget_versions.budget_version_id%TYPE;
1378: l_currency_code fnd_currencies.currency_code%TYPE;
1379: l_budget_measurement_type per_shared_types.system_type_cd%TYPE;
1380: l_business_group_id number;
1381:
1382: CURSOR csr_bdgts_job(p_business_group_id number) IS
1383: SELECT

Line 1705: l_budget_measurement_type per_shared_types.system_type_cd%TYPE;

1701: l_total_amt NUMBER := 0;
1702: l_curr_ver_tot NUMBER := 0;
1703: l_budget_version_id pqh_budget_versions.budget_version_id%TYPE;
1704: l_currency_code fnd_currencies.currency_code%TYPE;
1705: l_budget_measurement_type per_shared_types.system_type_cd%TYPE;
1706: l_business_group_id number;
1707:
1708: CURSOR csr_bdgt_jobs IS
1709: SELECT

Line 1944: l_budget_measurement_type per_shared_types.system_type_cd%TYPE;

1940: l_total_amt NUMBER := 0;
1941: l_curr_ver_tot NUMBER := 0;
1942: l_budget_version_id pqh_budget_versions.budget_version_id%TYPE;
1943: l_currency_code fnd_currencies.currency_code%TYPE;
1944: l_budget_measurement_type per_shared_types.system_type_cd%TYPE;
1945: l_business_group_id number;
1946:
1947: CURSOR csr_bdgt_grades IS
1948: SELECT

Line 2178: l_budget_measurement_type per_shared_types.system_type_cd%TYPE;

2174: l_total_amt NUMBER := 0;
2175: l_curr_ver_tot NUMBER := 0;
2176: l_budget_version_id pqh_budget_versions.budget_version_id%TYPE;
2177: l_currency_code fnd_currencies.currency_code%TYPE;
2178: l_budget_measurement_type per_shared_types.system_type_cd%TYPE;
2179: l_business_group_id number;
2180:
2181: CURSOR csr_bdgt_orgs IS
2182: SELECT

Line 2314: l_budget_measurement_type per_shared_types.system_type_cd%TYPE;

2310: l_total_amt NUMBER := 0;
2311: l_curr_ver_tot NUMBER := 0;
2312: l_budget_version_id pqh_budget_versions.budget_version_id%TYPE;
2313: l_currency_code fnd_currencies.currency_code%TYPE;
2314: l_budget_measurement_type per_shared_types.system_type_cd%TYPE;
2315: l_business_group_id number;
2316:
2317: CURSOR csr_bdgt_positions IS
2318: SELECT DISTINCT

Line 2433: l_budget_measurement_type per_shared_types.system_type_cd%TYPE;

2429: l_total_amt NUMBER := 0;
2430: l_curr_ver_tot NUMBER := 0;
2431: l_budget_version_id pqh_budget_versions.budget_version_id%TYPE;
2432: l_currency_code fnd_currencies.currency_code%TYPE;
2433: l_budget_measurement_type per_shared_types.system_type_cd%TYPE;
2434: l_business_group_id number;
2435:
2436: CURSOR csr_bdgt_jobs IS
2437: SELECT DISTINCT

Line 2550: l_budget_measurement_type per_shared_types.system_type_cd%TYPE;

2546: l_total_amt NUMBER := 0;
2547: l_curr_ver_tot NUMBER := 0;
2548: l_budget_version_id pqh_budget_versions.budget_version_id%TYPE;
2549: l_currency_code fnd_currencies.currency_code%TYPE;
2550: l_budget_measurement_type per_shared_types.system_type_cd%TYPE;
2551: l_business_group_id number;
2552:
2553: CURSOR csr_bdgt_grades IS
2554: SELECT DISTINCT

Line 2666: l_budget_measurement_type per_shared_types.system_type_cd%TYPE;

2662: l_total_amt NUMBER := 0;
2663: l_curr_ver_tot NUMBER := 0;
2664: l_budget_version_id pqh_budget_versions.budget_version_id%TYPE;
2665: l_currency_code fnd_currencies.currency_code%TYPE;
2666: l_budget_measurement_type per_shared_types.system_type_cd%TYPE;
2667: l_business_group_id number;
2668:
2669: CURSOR csr_bdgt_orgs IS
2670: SELECT DISTINCT

Line 2875: l_budget_measurement_type per_shared_types.system_type_cd%TYPE;

2871: l_total_amt NUMBER := 0;
2872: l_curr_posn_tot NUMBER := 0;
2873:
2874: l_currency_code fnd_currencies.currency_code%TYPE;
2875: l_budget_measurement_type per_shared_types.system_type_cd%TYPE;
2876: l_business_group_id number;
2877:
2878: CURSOR csr_bdgt_positions(p_business_group_id number) IS
2879: SELECT DISTINCT

Line 2965: l_budget_measurement_type per_shared_types.system_type_cd%TYPE;

2961: l_total_amt NUMBER := 0;
2962: l_curr_posn_tot NUMBER := 0;
2963:
2964: l_currency_code fnd_currencies.currency_code%TYPE;
2965: l_budget_measurement_type per_shared_types.system_type_cd%TYPE;
2966: l_business_group_id number;
2967:
2968: CURSOR csr_bdgt_positions(p_business_group_id number) IS
2969: SELECT DISTINCT

Line 3054: l_budget_measurement_type per_shared_types.system_type_cd%TYPE;

3050: l_total_amt NUMBER := 0;
3051: l_curr_posn_tot NUMBER := 0;
3052:
3053: l_currency_code fnd_currencies.currency_code%TYPE;
3054: l_budget_measurement_type per_shared_types.system_type_cd%TYPE;
3055:
3056: CURSOR csr_bdgt_positions IS
3057: SELECT DISTINCT
3058: bvr.BUDGET_VERSION_ID BUDGET_VERSION_ID,

Line 3137: l_budget_measurement_type per_shared_types.system_type_cd%TYPE;

3133: l_total_amt NUMBER := 0;
3134: l_curr_posn_tot NUMBER := 0;
3135:
3136: l_currency_code fnd_currencies.currency_code%TYPE;
3137: l_budget_measurement_type per_shared_types.system_type_cd%TYPE;
3138:
3139: CURSOR csr_bdgt_positions IS
3140: SELECT DISTINCT
3141: bvr.BUDGET_VERSION_ID BUDGET_VERSION_ID,

Line 3223: l_budget_measurement_type per_shared_types.system_type_cd%TYPE;

3219: l_total_amt NUMBER := 0;
3220: l_curr_posn_tot NUMBER := 0;
3221:
3222: l_currency_code fnd_currencies.currency_code%TYPE;
3223: l_budget_measurement_type per_shared_types.system_type_cd%TYPE;
3224: l_business_group_id number;
3225:
3226: CURSOR csr_bdgt_positions(p_business_group_id number) IS
3227: SELECT DISTINCT

Line 3319: l_budget_measurement_type per_shared_types.system_type_cd%TYPE;

3315: l_total_amt NUMBER := 0;
3316: l_curr_posn_tot NUMBER := 0;
3317:
3318: l_currency_code fnd_currencies.currency_code%TYPE;
3319: l_budget_measurement_type per_shared_types.system_type_cd%TYPE;
3320: l_business_group_id number;
3321:
3322: CURSOR csr_bdgt_jobs(p_business_group_id number) IS
3323: SELECT DISTINCT

Line 3416: l_budget_measurement_type per_shared_types.system_type_cd%TYPE;

3412: l_total_amt NUMBER := 0;
3413: l_curr_posn_tot NUMBER := 0;
3414:
3415: l_currency_code fnd_currencies.currency_code%TYPE;
3416: l_budget_measurement_type per_shared_types.system_type_cd%TYPE;
3417: l_business_group_id number;
3418: CURSOR csr_bdgt_grades(p_business_group_id number) IS
3419: SELECT DISTINCT
3420: bvr.BUDGET_VERSION_ID BUDGET_VERSION_ID,

Line 3511: l_budget_measurement_type per_shared_types.system_type_cd%TYPE;

3507: l_total_amt NUMBER := 0;
3508: l_curr_posn_tot NUMBER := 0;
3509:
3510: l_currency_code fnd_currencies.currency_code%TYPE;
3511: l_budget_measurement_type per_shared_types.system_type_cd%TYPE;
3512: l_business_group_id number;
3513:
3514: CURSOR csr_bdgt_orgs(p_business_group_id number) IS
3515: SELECT DISTINCT

Line 3609: l_budget_measurement_type per_shared_types.system_type_cd%TYPE;

3605: l_total_amt NUMBER := 0;
3606: l_curr_posn_tot NUMBER := 0;
3607:
3608: l_currency_code fnd_currencies.currency_code%TYPE;
3609: l_budget_measurement_type per_shared_types.system_type_cd%TYPE;
3610: l_business_group_id number;
3611:
3612: CURSOR csr_bdgt_positions(p_business_group_id number) IS
3613: SELECT DISTINCT

Line 3717: l_budget_measurement_type per_shared_types.system_type_cd%TYPE;

3713: l_total_amt NUMBER := 0;
3714: l_curr_job_tot NUMBER := 0;
3715:
3716: l_currency_code fnd_currencies.currency_code%TYPE;
3717: l_budget_measurement_type per_shared_types.system_type_cd%TYPE;
3718: l_business_group_id number;
3719:
3720: CURSOR csr_bdgt_jobs(p_business_group_id number) IS
3721: SELECT DISTINCT

Line 3824: l_budget_measurement_type per_shared_types.system_type_cd%TYPE;

3820: l_total_amt NUMBER := 0;
3821: l_curr_grade_tot NUMBER := 0;
3822:
3823: l_currency_code fnd_currencies.currency_code%TYPE;
3824: l_budget_measurement_type per_shared_types.system_type_cd%TYPE;
3825: l_business_group_id number;
3826:
3827: CURSOR csr_bdgt_grades(p_business_group_id number) IS
3828: SELECT DISTINCT

Line 3931: l_budget_measurement_type per_shared_types.system_type_cd%TYPE;

3927: l_total_amt NUMBER := 0;
3928: l_curr_orgn_tot NUMBER := 0;
3929:
3930: l_currency_code fnd_currencies.currency_code%TYPE;
3931: l_budget_measurement_type per_shared_types.system_type_cd%TYPE;
3932: l_business_group_id number;
3933:
3934: CURSOR csr_bdgt_orgs(p_business_group_id number) IS
3935: SELECT DISTINCT

Line 4041: l_shared_type_cd per_shared_types.system_type_cd%TYPE;

4037: l_actual_amt NUMBER := 0;
4038: l_cmmtmnt_amt NUMBER := 0;
4039: l_projected_amt NUMBER := 0;
4040: l_balance_amt NUMBER := 0;
4041: l_shared_type_cd per_shared_types.system_type_cd%TYPE;
4042: BEGIN
4043: hr_utility.set_location('Entering: '||l_proc, 5);
4044:
4045: l_budgeted_amt := pqh_mgmt_rpt_pkg.get_position_budget_amt

Line 4143: l_shared_type_cd per_shared_types.system_type_cd%TYPE;

4139: l_cmmtmnt_amt NUMBER := 0;
4140: l_projected_amt NUMBER := 0;
4141: l_balance_amt NUMBER := 0;
4142: l_variance_prcnt NUMBER := 0;
4143: l_shared_type_cd per_shared_types.system_type_cd%TYPE;
4144:
4145: BEGIN
4146: hr_utility.set_location('Entering: '||l_proc, 5);
4147: IF p_position_type = 'A' THEN

Line 4277: l_shared_type_cd Per_Shared_Types.System_Type_Cd%TYPE;

4273: l_cmmtmnt_amt NUMBER := 0;
4274: l_projected_amt NUMBER := 0;
4275: l_balance_amt NUMBER := 0;
4276: l_variance_prcnt NUMBER := 0;
4277: l_shared_type_cd Per_Shared_Types.System_Type_Cd%TYPE;
4278:
4279: BEGIN
4280: hr_utility.set_location('Entering: '||l_proc, 5);
4281: IF p_entity_type = 'A' THEN

Line 4416: l_shared_type_cd Per_Shared_Types.System_Type_Cd%TYPE;

4412: l_cmmtmnt_amt NUMBER := 0;
4413: l_projected_amt NUMBER := 0;
4414: l_balance_amt NUMBER := 0;
4415: l_variance_prcnt NUMBER := 0;
4416: l_shared_type_cd Per_Shared_Types.System_Type_Cd%TYPE;
4417:
4418: BEGIN
4419: hr_utility.set_location('Entering: '||l_proc, 5);
4420: IF p_entity_type = 'A' THEN

Line 4553: l_shared_type_cd per_shared_types.system_type_cd%TYPE;

4549: l_cmmtmnt_amt NUMBER := 0;
4550: l_projected_amt NUMBER := 0;
4551: l_balance_amt NUMBER := 0;
4552: l_variance_prcnt NUMBER := 0;
4553: l_shared_type_cd per_shared_types.system_type_cd%TYPE;
4554:
4555: BEGIN
4556: hr_utility.set_location('Entering: '||l_proc, 5);
4557: IF p_entity_type = 'A' THEN