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 FND_CURRENCIES

Line 980: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL

976: p_start_date IN pqh_budgets.budget_start_date%TYPE,
977: p_end_date IN pqh_budgets.budget_end_date%TYPE,
978: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
979: p_value_type IN varchar2 DEFAULT 'T',
980: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
981: )
982: RETURN NUMBER is
983: /*
984: This function is a wrapper on pqh_bdgt_actual_cmmtmnt_pkg. get_pos_actual_and_cmmtmnt as we did not want any errors

Line 1024: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL

1020: p_start_date IN pqh_budgets.budget_start_date%TYPE,
1021: p_end_date IN pqh_budgets.budget_end_date%TYPE,
1022: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
1023: p_value_type IN varchar2 DEFAULT 'T',
1024: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
1025: )
1026: RETURN NUMBER IS
1027: /*
1028: This function is a wrapper on pqh_bdgt_actual_cmmtmnt_pkg. get_ent_actual_and_cmmtmnt.

Line 1042: l_currency_code fnd_currencies.currency_code%TYPE;

1038: l_proc varchar2(72) := g_package||'get_entity_actual_cmmtmnts';
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

Line 1326: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL

1322: p_position_id IN per_positions.position_id%TYPE,
1323: p_start_date IN pqh_budgets.budget_start_date%TYPE,
1324: p_end_date IN pqh_budgets.budget_end_date%TYPE,
1325: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
1326: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
1327: )
1328: RETURN NUMBER IS
1329: /*
1330: This function will return the budgeted amt for a position. If the budget version is

Line 1363: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL

1359: p_organization_id IN hr_organization_units.organization_id%TYPE DEFAULT NULL,
1360: p_start_date IN pqh_budgets.budget_start_date%TYPE,
1361: p_end_date IN pqh_budgets.budget_end_date%TYPE,
1362: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
1363: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
1364: )
1365: RETURN NUMBER IS
1366:
1367: /*

Line 1378: l_currency_code fnd_currencies.currency_code%TYPE;

1374: l_proc varchar2(72) := g_package||'get_entity_budget_amt';
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

Line 1521: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL

1517: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
1518: p_start_date IN pqh_budgets.budget_start_date%TYPE,
1519: p_end_date IN pqh_budgets.budget_end_date%TYPE,
1520: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
1521: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
1522: )
1523: RETURN NUMBER IS
1524: BEGIN
1525: return get_position_budgeted_or_cmmt

Line 1697: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL

1693: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
1694: p_start_date IN pqh_budgets.budget_start_date%TYPE,
1695: p_end_date IN pqh_budgets.budget_end_date%TYPE,
1696: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
1697: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
1698: )
1699: RETURN NUMBER IS
1700: l_proc varchar2(72) := g_package||'get_job_element_bdgt_amt';
1701: l_total_amt NUMBER := 0;

Line 1704: l_currency_code fnd_currencies.currency_code%TYPE;

1700: l_proc varchar2(72) := g_package||'get_job_element_bdgt_amt';
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

Line 1932: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL

1928: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
1929: p_start_date IN pqh_budgets.budget_start_date%TYPE,
1930: p_end_date IN pqh_budgets.budget_end_date%TYPE,
1931: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
1932: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
1933: )
1934: RETURN NUMBER IS
1935:
1936: /*

Line 1943: l_currency_code fnd_currencies.currency_code%TYPE;

1939: l_proc varchar2(72) := g_package||'get_grde_element_bdgt_amt';
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

Line 2170: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL

2166: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
2167: p_start_date IN pqh_budgets.budget_start_date%TYPE,
2168: p_end_date IN pqh_budgets.budget_end_date%TYPE,
2169: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
2170: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
2171: )
2172: RETURN NUMBER IS
2173: l_proc varchar2(72) := g_package||'get_orgn_element_bdgt_amt';
2174: l_total_amt NUMBER := 0;

Line 2177: l_currency_code fnd_currencies.currency_code%TYPE;

2173: l_proc varchar2(72) := g_package||'get_orgn_element_bdgt_amt';
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

Line 2293: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL

2289: p_start_date IN pqh_budgets.budget_start_date%TYPE,
2290: p_end_date IN pqh_budgets.budget_end_date%TYPE,
2291: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
2292: p_value_type IN varchar2 DEFAULT 'T',
2293: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
2294: )
2295: RETURN NUMBER IS
2296:
2297: /*

Line 2313: l_currency_code fnd_currencies.currency_code%TYPE;

2309: l_proc varchar2(72) := g_package||'get_posn_elmnt_actual_cmmtmnts';
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

Line 2412: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL

2408: p_start_date IN pqh_budgets.budget_start_date%TYPE,
2409: p_end_date IN pqh_budgets.budget_end_date%TYPE,
2410: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
2411: p_value_type IN varchar2 DEFAULT 'T',
2412: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
2413: )
2414: RETURN NUMBER IS
2415:
2416: /*

Line 2432: l_currency_code fnd_currencies.currency_code%TYPE;

2428: l_proc varchar2(72) := g_package||'get_job_elmnt_actual_cmmtmnts';
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

Line 2529: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL

2525: p_start_date IN pqh_budgets.budget_start_date%TYPE,
2526: p_end_date IN pqh_budgets.budget_end_date%TYPE,
2527: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
2528: p_value_type IN varchar2 DEFAULT 'T',
2529: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
2530: )
2531: RETURN NUMBER IS
2532:
2533: /*

Line 2549: l_currency_code fnd_currencies.currency_code%TYPE;

2545: l_proc varchar2(72) := g_package||'get_grde_elmnt_actual_cmmtmnts';
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

Line 2645: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL

2641: p_start_date IN pqh_budgets.budget_start_date%TYPE,
2642: p_end_date IN pqh_budgets.budget_end_date%TYPE,
2643: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
2644: p_value_type IN varchar2 DEFAULT 'T',
2645: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
2646: )
2647: RETURN NUMBER IS
2648:
2649: /*

Line 2665: l_currency_code fnd_currencies.currency_code%TYPE;

2661: l_proc varchar2(72) := g_package||'get_orgn_elmnt_actual_cmmtmnts';
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

Line 2863: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL

2859: p_organization_id IN pqh_budget_details.organization_id%TYPE,
2860: p_start_date IN pqh_budgets.budget_start_date%TYPE,
2861: p_end_date IN pqh_budgets.budget_end_date%TYPE,
2862: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
2863: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
2864: )
2865: RETURN NUMBER IS
2866: /*
2867: */

Line 2874: l_currency_code fnd_currencies.currency_code%TYPE;

2870: l_position_id pqh_budget_details.position_id%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

Line 2952: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL

2948: p_start_date IN pqh_budgets.budget_start_date%TYPE,
2949: p_end_date IN pqh_budgets.budget_end_date%TYPE,
2950: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
2951: p_value_type IN varchar2 DEFAULT 'T',
2952: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
2953: )
2954: RETURN NUMBER IS
2955: /*
2956: */

Line 2964: l_currency_code fnd_currencies.currency_code%TYPE;

2960: l_position_id pqh_budget_details.position_id%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

Line 3043: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL

3039: p_business_group_id IN pqh_budgets.business_group_id%TYPE,
3040: p_start_date IN pqh_budgets.budget_start_date%TYPE,
3041: p_end_date IN pqh_budgets.budget_end_date%TYPE,
3042: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
3043: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
3044: )
3045: RETURN NUMBER IS
3046:
3047: l_proc varchar2(72) := g_package||'get_bgrp_posn_budget_amt';

Line 3053: l_currency_code fnd_currencies.currency_code%TYPE;

3049: l_position_id pqh_budget_details.position_id%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

Line 3126: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL

3122: p_start_date IN pqh_budgets.budget_start_date%TYPE,
3123: p_end_date IN pqh_budgets.budget_end_date%TYPE,
3124: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
3125: p_value_type IN varchar2 DEFAULT 'T',
3126: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
3127: )
3128: RETURN NUMBER IS
3129:
3130: l_proc varchar2(72) := g_package||'get_bgrp_posn_actual_cmmtmnts';

Line 3136: l_currency_code fnd_currencies.currency_code%TYPE;

3132: l_position_id pqh_budget_details.position_id%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

Line 3212: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL

3208: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
3209: p_start_date IN pqh_budgets.budget_start_date%TYPE,
3210: p_end_date IN pqh_budgets.budget_end_date%TYPE,
3211: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
3212: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
3213: )
3214: RETURN NUMBER IS
3215:
3216: l_proc varchar2(72) := g_package||'get_elem_posn_budget_amt';

Line 3222: l_currency_code fnd_currencies.currency_code%TYPE;

3218: l_position_id pqh_budget_details.position_id%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

Line 3308: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL

3304: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
3305: p_start_date IN pqh_budgets.budget_start_date%TYPE,
3306: p_end_date IN pqh_budgets.budget_end_date%TYPE,
3307: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
3308: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
3309: )
3310: RETURN NUMBER IS
3311:
3312: l_proc varchar2(72) := g_package||'get_elem_job_budget_amt';

Line 3318: l_currency_code fnd_currencies.currency_code%TYPE;

3314: l_job_id pqh_budget_details.job_id%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

Line 3405: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL

3401: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
3402: p_start_date IN pqh_budgets.budget_start_date%TYPE,
3403: p_end_date IN pqh_budgets.budget_end_date%TYPE,
3404: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
3405: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
3406: )
3407: RETURN NUMBER IS
3408:
3409: l_proc varchar2(72) := g_package||'get_elem_grd_budget_amt';

Line 3415: l_currency_code fnd_currencies.currency_code%TYPE;

3411: l_grade_id pqh_budget_details.grade_id%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

Line 3500: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL

3496: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
3497: p_start_date IN pqh_budgets.budget_start_date%TYPE,
3498: p_end_date IN pqh_budgets.budget_end_date%TYPE,
3499: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
3500: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
3501: )
3502: RETURN NUMBER IS
3503:
3504: l_proc varchar2(72) := g_package||'get_elem_org_budget_amt';

Line 3510: l_currency_code fnd_currencies.currency_code%TYPE;

3506: l_organization_id pqh_budget_details.organization_id%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

Line 3596: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL

3592: p_start_date IN pqh_budgets.budget_start_date%TYPE,
3593: p_end_date IN pqh_budgets.budget_end_date%TYPE,
3594: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
3595: p_value_type IN varchar2 DEFAULT 'T',
3596: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
3597: )
3598: RETURN NUMBER IS
3599: /*
3600: */

Line 3608: l_currency_code fnd_currencies.currency_code%TYPE;

3604: l_position_id pqh_budget_details.position_id%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

Line 3704: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL

3700: p_start_date IN pqh_budgets.budget_start_date%TYPE,
3701: p_end_date IN pqh_budgets.budget_end_date%TYPE,
3702: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
3703: p_value_type IN varchar2 DEFAULT 'T',
3704: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
3705: )
3706: RETURN NUMBER IS
3707: /*
3708: */

Line 3716: l_currency_code fnd_currencies.currency_code%TYPE;

3712: l_job_id pqh_budget_details.job_id%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

Line 3811: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL

3807: p_start_date IN pqh_budgets.budget_start_date%TYPE,
3808: p_end_date IN pqh_budgets.budget_end_date%TYPE,
3809: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
3810: p_value_type IN varchar2 DEFAULT 'T',
3811: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
3812: )
3813: RETURN NUMBER IS
3814: /*
3815: */

Line 3823: l_currency_code fnd_currencies.currency_code%TYPE;

3819: l_grade_id pqh_budget_details.grade_id%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

Line 3918: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL

3914: p_start_date IN pqh_budgets.budget_start_date%TYPE,
3915: p_end_date IN pqh_budgets.budget_end_date%TYPE,
3916: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
3917: p_value_type IN varchar2 DEFAULT 'T',
3918: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
3919: )
3920: RETURN NUMBER IS
3921: /*
3922: */

Line 3930: l_currency_code fnd_currencies.currency_code%TYPE;

3926: l_organization_id pqh_budget_details.organization_id%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

Line 4025: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL

4021: p_position_id IN per_positions.position_id%TYPE,
4022: p_start_date IN pqh_budgets.budget_start_date%TYPE,
4023: p_end_date IN pqh_budgets.budget_end_date%TYPE,
4024: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
4025: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
4026: )
4027: RETURN VARCHAR2 IS
4028: /*
4029: This function will return

Line 4124: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL

4120: p_end_date IN pqh_budgets.budget_end_date%TYPE,
4121: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
4122: p_position_type IN VARCHAR2 DEFAULT 'Y',
4123: p_variance_prcnt IN NUMBER DEFAULT 0,
4124: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
4125: )
4126: RETURN VARCHAR2 IS
4127: /*
4128: This function will return

Line 4258: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL

4254: p_end_date IN pqh_budgets.budget_end_date%TYPE,
4255: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
4256: p_entity_type IN VARCHAR2 DEFAULT 'Y',
4257: p_variance_prcnt IN NUMBER DEFAULT 0,
4258: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
4259: )
4260: RETURN VARCHAR2 IS
4261: /*
4262: This function will return

Line 4397: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL

4393: p_end_date IN pqh_budgets.budget_end_date%TYPE,
4394: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
4395: p_entity_type IN VARCHAR2 DEFAULT 'Y',
4396: p_variance_prcnt IN NUMBER DEFAULT 0,
4397: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
4398: )
4399: RETURN VARCHAR2 IS
4400: /*
4401: This function will return

Line 4534: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL

4530: p_end_date IN pqh_budgets.budget_end_date%TYPE,
4531: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
4532: p_entity_type IN VARCHAR2 DEFAULT 'Y',
4533: p_variance_prcnt IN NUMBER DEFAULT 0,
4534: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
4535: )
4536: RETURN VARCHAR2 IS
4537: /*
4538: This function will return

Line 4672: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL

4668: p_end_date IN pqh_budgets.budget_end_date%TYPE,
4669: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
4670: p_entity_type IN VARCHAR2 DEFAULT 'Y',
4671: p_variance_prcnt IN NUMBER DEFAULT 0,
4672: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
4673: )
4674: RETURN VARCHAR2 IS
4675:
4676: l_entity_type varchar2(10);

Line 4766: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL

4762: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
4763: p_start_date IN pqh_budgets.budget_start_date%TYPE,
4764: p_end_date IN pqh_budgets.budget_end_date%TYPE,
4765: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
4766: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
4767: )
4768:
4769: RETURN NUMBER IS
4770:

Line 4853: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL

4849: p_start_date IN pqh_budgets.budget_start_date%TYPE,
4850: p_end_date IN pqh_budgets.budget_end_date%TYPE,
4851: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
4852: p_value_type IN varchar2 DEFAULT 'T',
4853: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
4854: )
4855: RETURN NUMBER IS
4856:
4857: l_curr_ent_tot NUMBER :=0;

Line 4941: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL

4937: p_budgeted_entity_cd IN pqh_budgets.budgeted_entity_cd%TYPE,
4938: p_start_date IN pqh_budgets.budget_start_date%TYPE,
4939: p_end_date IN pqh_budgets.budget_end_date%TYPE,
4940: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
4941: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
4942: )
4943: RETURN NUMBER IS
4944:
4945: l_curr_ent_tot NUMBER :=0;

Line 5012: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL

5008: p_start_date IN pqh_budgets.budget_start_date%TYPE,
5009: p_end_date IN pqh_budgets.budget_end_date%TYPE,
5010: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
5011: p_value_type IN varchar2 DEFAULT 'T',
5012: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
5013: )
5014: RETURN NUMBER IS
5015:
5016: l_curr_ent_tot NUMBER :=0;