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 PQH_BDGT_ACTUAL_CMMTMNT_PKG

Line 812: l_curr_ver_tot := pqh_bdgt_actual_cmmtmnt_pkg.get_pos_actual_and_cmmtmnt

808: p_position_id => p_position_id,
809: p_unit_of_measure_id => p_unit_of_measure_id
810: );
811: elsif (p_summarize_by = 'BUDGET' and p_budgeted_or_cmmt = 'CMMT') then
812: l_curr_ver_tot := pqh_bdgt_actual_cmmtmnt_pkg.get_pos_actual_and_cmmtmnt
813: (
814: p_budget_version_id => p_budget_version_id,
815: p_position_id => p_position_id,
816: p_start_date => p_start_date,

Line 984: This function is a wrapper on pqh_bdgt_actual_cmmtmnt_pkg. get_pos_actual_and_cmmtmnt as we did not want any errors

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
985: to be returned by the original function.
986: This function will return the actual or commitment for a position. If the budget version is
987: specified then it would return the actual or commitment for that budget version. If no budget version is
988: specified the it would return the actual or commitment for all the budget versions where the position is

Line 1028: This function is a wrapper on pqh_bdgt_actual_cmmtmnt_pkg. get_ent_actual_and_cmmtmnt.

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.
1029: This function will return the actual or commitment for an entity. If the budget version is
1030: specified then it would return the actual or commitment for that budget version. If no budget version is
1031: specified the it would return the actual or commitment for all the budget versions where the entity is
1032: budgeted between the start date and end date.

Line 1113: l_curr_ver_tot := pqh_bdgt_actual_cmmtmnt_pkg.get_ent_actual_and_cmmtmnt

1109: if (( l_budget_measurement_type <> 'MONEY') OR
1110: ( l_budget_measurement_type = 'MONEY' and
1111: nvl(l_currency_code,'X') = nvl(p_currency_code,'X') )) then
1112:
1113: l_curr_ver_tot := pqh_bdgt_actual_cmmtmnt_pkg.get_ent_actual_and_cmmtmnt
1114: (
1115: p_budget_version_id => l_budget_version_id,
1116: p_budgeted_entity_cd => p_budgeted_entity_cd,
1117: p_entity_id => p_job_id,

Line 1138: l_curr_ver_tot := pqh_bdgt_actual_cmmtmnt_pkg.get_ent_actual_and_cmmtmnt

1134:
1135: if (( l_budget_measurement_type <> 'MONEY') OR
1136: ( l_budget_measurement_type = 'MONEY' and
1137: nvl(l_currency_code,'X') = nvl(p_currency_code,'X') )) then
1138: l_curr_ver_tot := pqh_bdgt_actual_cmmtmnt_pkg.get_ent_actual_and_cmmtmnt
1139: (
1140: p_budget_version_id => l_budget_version_id,
1141: p_budgeted_entity_cd => p_budgeted_entity_cd,
1142: p_entity_id => p_grade_id,

Line 1162: l_curr_ver_tot := pqh_bdgt_actual_cmmtmnt_pkg.get_ent_actual_and_cmmtmnt

1158:
1159: if (( l_budget_measurement_type <> 'MONEY') OR
1160: ( l_budget_measurement_type = 'MONEY' and
1161: nvl(l_currency_code,'X') = nvl(p_currency_code,'X') )) then
1162: l_curr_ver_tot := pqh_bdgt_actual_cmmtmnt_pkg.get_ent_actual_and_cmmtmnt
1163: (
1164: p_budget_version_id => l_budget_version_id,
1165: p_budgeted_entity_cd => p_budgeted_entity_cd,
1166: p_entity_id => p_organization_id,

Line 1246: This function is a wrapper to pqh_bdgt_actual_cmmtmnt_pkg.get_assignment_actuals

1242: p_unit_of_measure_id IN number
1243: )
1244: RETURN NUMBER IS
1245: /*
1246: This function is a wrapper to pqh_bdgt_actual_cmmtmnt_pkg.get_assignment_actuals
1247: */
1248: l_proc varchar2(72) := g_package||'get_assignment_actuals';
1249: l_total_amt NUMBER := 0;
1250: l_last_payroll_date DATE;

Line 1255: l_total_amt := pqh_bdgt_actual_cmmtmnt_pkg.get_assignment_actuals

1251:
1252: BEGIN
1253: hr_utility.set_location('Entering: '||l_proc, 5);
1254:
1255: l_total_amt := pqh_bdgt_actual_cmmtmnt_pkg.get_assignment_actuals
1256: (
1257: p_assignment_id => p_assignment_id,
1258: p_element_type_id => p_element_type_id,
1259: p_actuals_start_date => p_actuals_start_date,

Line 1287: This function is a wrapper to pqh_bdgt_actual_cmmtmnt_pkg.get_assignment_commitment

1283: p_unit_of_measure_id IN number
1284: )
1285: RETURN NUMBER IS
1286: /*
1287: This function is a wrapper to pqh_bdgt_actual_cmmtmnt_pkg.get_assignment_commitment
1288: */
1289: l_proc varchar2(72) := g_package||'get_assignment_commitment';
1290: l_total_amt NUMBER := 0;
1291: l_last_payroll_date DATE;

Line 1296: l_total_amt := pqh_bdgt_actual_cmmtmnt_pkg.get_assignment_commitment

1292:
1293: BEGIN
1294: hr_utility.set_location('Entering: '||l_proc, 5);
1295:
1296: l_total_amt := pqh_bdgt_actual_cmmtmnt_pkg.get_assignment_commitment
1297: (
1298: p_assignment_id => p_assignment_id,
1299: p_budget_version_id => p_budget_version_id,
1300: p_period_start_date => p_period_start_date,

Line 2298: This function is a wrapper on pqh_bdgt_actual_cmmtmnt_pkg.get_pos_actual_and_cmmtmnt as we did not want any errors

2294: )
2295: RETURN NUMBER IS
2296:
2297: /*
2298: This function is a wrapper on pqh_bdgt_actual_cmmtmnt_pkg.get_pos_actual_and_cmmtmnt as we did not want any errors
2299: to be returned by the original function.
2300: This function will return the actual or commitment for a position. If the budget version is
2301: specified then it would return the actual or commitment for that budget version. If no budget version is
2302: specified the it would return the actual or commitment for all the budget versions where the position is

Line 2350: l_curr_ver_tot := pqh_bdgt_actual_cmmtmnt_pkg.get_ent_actual_and_cmmtmnt

2346: if (( l_budget_measurement_type <> 'MONEY') OR
2347: ( l_budget_measurement_type = 'MONEY' and
2348: nvl(l_currency_code,'X') = nvl(p_currency_code,'X') )) then
2349:
2350: l_curr_ver_tot := pqh_bdgt_actual_cmmtmnt_pkg.get_ent_actual_and_cmmtmnt
2351: (
2352: p_budget_version_id => l_budget_version_id,
2353: p_budgeted_entity_cd => 'POSITION',
2354: p_entity_id => p_position_id,

Line 2417: This function is a wrapper on pqh_bdgt_actual_cmmtmnt_pkg.get_pos_actual_and_cmmtmnt as we did not want any errors

2413: )
2414: RETURN NUMBER IS
2415:
2416: /*
2417: This function is a wrapper on pqh_bdgt_actual_cmmtmnt_pkg.get_pos_actual_and_cmmtmnt as we did not want any errors
2418: to be returned by the original function.
2419: This function will return the actual or commitment for a job. If the budget version is
2420: specified then it would return the actual or commitment for that budget version. If no budget version is
2421: specified the it would return the actual or commitment for all the budget versions where the job is

Line 2468: l_curr_ver_tot := pqh_bdgt_actual_cmmtmnt_pkg.get_ent_actual_and_cmmtmnt

2464: BEGIN
2465: if (( l_budget_measurement_type <> 'MONEY') OR
2466: ( l_budget_measurement_type = 'MONEY' and
2467: nvl(l_currency_code,'X') = nvl(p_currency_code,'X') )) then
2468: l_curr_ver_tot := pqh_bdgt_actual_cmmtmnt_pkg.get_ent_actual_and_cmmtmnt
2469: (
2470: p_budget_version_id => l_budget_version_id,
2471: p_budgeted_entity_cd => 'JOB',
2472: p_entity_id => p_job_id,

Line 2534: This function is a wrapper on pqh_bdgt_actual_cmmtmnt_pkg.get_pos_actual_and_cmmtmnt as we did not want any errors

2530: )
2531: RETURN NUMBER IS
2532:
2533: /*
2534: This function is a wrapper on pqh_bdgt_actual_cmmtmnt_pkg.get_pos_actual_and_cmmtmnt as we did not want any errors
2535: to be returned by the original function.
2536: This function will return the actual or commitment for a grade. If the budget version is
2537: specified then it would return the actual or commitment for that budget version. If no budget version is
2538: specified the it would return the actual or commitment for all the budget versions where the grade is

Line 2585: l_curr_ver_tot := pqh_bdgt_actual_cmmtmnt_pkg.get_ent_actual_and_cmmtmnt

2581: BEGIN
2582: if (( l_budget_measurement_type <> 'MONEY') OR
2583: ( l_budget_measurement_type = 'MONEY' and
2584: nvl(l_currency_code,'X') = nvl(p_currency_code,'X') )) then
2585: l_curr_ver_tot := pqh_bdgt_actual_cmmtmnt_pkg.get_ent_actual_and_cmmtmnt
2586: (
2587: p_budget_version_id => l_budget_version_id,
2588: p_budgeted_entity_cd => 'GRADE',
2589: p_entity_id => p_grade_id,

Line 2650: This function is a wrapper on pqh_bdgt_actual_cmmtmnt_pkg.get_pos_actual_and_cmmtmnt as we did not want any errors

2646: )
2647: RETURN NUMBER IS
2648:
2649: /*
2650: This function is a wrapper on pqh_bdgt_actual_cmmtmnt_pkg.get_pos_actual_and_cmmtmnt as we did not want any errors
2651: to be returned by the original function.
2652: This function will return the actual or commitment for a organization. If the budget version is
2653: specified then it would return the actual or commitment for that budget version. If no budget version is
2654: specified the it would return the actual or commitment for all the budget versions where the organization is

Line 2702: l_curr_ver_tot := pqh_bdgt_actual_cmmtmnt_pkg.get_ent_actual_and_cmmtmnt

2698: BEGIN
2699: if (( l_budget_measurement_type <> 'MONEY') OR
2700: ( l_budget_measurement_type = 'MONEY' and
2701: nvl(l_currency_code,'X') = nvl(p_currency_code,'X') )) then
2702: l_curr_ver_tot := pqh_bdgt_actual_cmmtmnt_pkg.get_ent_actual_and_cmmtmnt
2703: (
2704: p_budget_version_id => l_budget_version_id,
2705: p_budgeted_entity_cd => 'ORGANIZATION',
2706: p_entity_id => p_organization_id,

Line 2804: l_curr_ver_tot := pqh_bdgt_actual_cmmtmnt_pkg.get_pos_actual_and_cmmtmnt

2800: WHERE dflt_budget_set_id = p_budget_set_id;
2801:
2802: procedure proc1 is
2803: BEGIN
2804: l_curr_ver_tot := pqh_bdgt_actual_cmmtmnt_pkg.get_pos_actual_and_cmmtmnt
2805: (
2806: p_budget_version_id => l_budget_version_id,
2807: p_position_id => p_position_id,
2808: p_element_type_id => l_element_type_id,

Line 2994: l_curr_posn_tot := pqh_bdgt_actual_cmmtmnt_pkg.get_pos_actual_and_cmmtmnt

2990: BEGIN
2991: if (( l_budget_measurement_type <> 'MONEY') OR
2992: ( l_budget_measurement_type = 'MONEY' and
2993: nvl(l_currency_code,'X') = nvl(p_currency_code,'X') )) then
2994: l_curr_posn_tot := pqh_bdgt_actual_cmmtmnt_pkg.get_pos_actual_and_cmmtmnt
2995: (
2996: p_budget_version_id => l_budget_version_id,
2997: p_position_id => l_position_id,
2998: p_start_date => p_start_date,

Line 3175: l_curr_posn_tot := pqh_bdgt_actual_cmmtmnt_pkg.get_pos_actual_and_cmmtmnt

3171: BEGIN
3172: if (( l_budget_measurement_type <> 'MONEY') OR
3173: ( l_budget_measurement_type = 'MONEY' and
3174: nvl(l_currency_code,'X') = nvl(p_currency_code,'X') )) then
3175: l_curr_posn_tot := pqh_bdgt_actual_cmmtmnt_pkg.get_pos_actual_and_cmmtmnt
3176: (
3177: p_budget_version_id => l_budget_version_id,
3178: p_position_id => l_position_id,
3179: p_start_date => p_start_date,

Line 3657: l_curr_posn_tot := pqh_bdgt_actual_cmmtmnt_pkg.get_ent_actual_and_cmmtmnt

3653: BEGIN
3654: if (( l_budget_measurement_type <> 'MONEY') OR
3655: ( l_budget_measurement_type = 'MONEY' and
3656: nvl(l_currency_code,'X') = nvl(p_currency_code,'X') )) then
3657: l_curr_posn_tot := pqh_bdgt_actual_cmmtmnt_pkg.get_ent_actual_and_cmmtmnt
3658: (
3659: p_budget_version_id => l_budget_version_id,
3660: p_budgeted_entity_cd => 'POSITION',
3661: p_element_type_id => p_element_type_id, /* Bug Fix 2719170 */

Line 3764: l_curr_job_tot := pqh_bdgt_actual_cmmtmnt_pkg.get_ent_actual_and_cmmtmnt

3760: BEGIN
3761: if (( l_budget_measurement_type <> 'MONEY') OR
3762: ( l_budget_measurement_type = 'MONEY' and
3763: nvl(l_currency_code,'X') = nvl(p_currency_code,'X') )) then
3764: l_curr_job_tot := pqh_bdgt_actual_cmmtmnt_pkg.get_ent_actual_and_cmmtmnt
3765: (
3766: p_budget_version_id => l_budget_version_id,
3767: p_budgeted_entity_cd => 'JOB',
3768: p_element_type_id => p_element_type_id, /* Bug Fix 2719170 */

Line 3872: l_curr_grade_tot := pqh_bdgt_actual_cmmtmnt_pkg.get_ent_actual_and_cmmtmnt

3868: BEGIN
3869: if (( l_budget_measurement_type <> 'MONEY') OR
3870: ( l_budget_measurement_type = 'MONEY' and
3871: nvl(l_currency_code,'X') = nvl(p_currency_code,'X') )) then
3872: l_curr_grade_tot := pqh_bdgt_actual_cmmtmnt_pkg.get_ent_actual_and_cmmtmnt
3873: (
3874: p_budget_version_id => l_budget_version_id,
3875: p_budgeted_entity_cd => 'GRADE',
3876: p_element_type_id => p_element_type_id, /* Bug Fix 2719170 */

Line 3979: l_curr_orgn_tot := pqh_bdgt_actual_cmmtmnt_pkg.get_ent_actual_and_cmmtmnt

3975: BEGIN
3976: if (( l_budget_measurement_type <> 'MONEY') OR
3977: ( l_budget_measurement_type = 'MONEY' and
3978: nvl(l_currency_code,'X') = nvl(p_currency_code,'X') )) then
3979: l_curr_orgn_tot := pqh_bdgt_actual_cmmtmnt_pkg.get_ent_actual_and_cmmtmnt
3980: (
3981: p_budget_version_id => l_budget_version_id,
3982: p_budgeted_entity_cd => 'ORGANIZATION',
3983: p_element_type_id => p_element_type_id, /* Bug Fix 2719170 */