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_MGMT_RPT_PKG

Line 1: PACKAGE BODY PQH_MGMT_RPT_PKG AS

1: PACKAGE BODY PQH_MGMT_RPT_PKG AS
2: /* $Header: pqmgtpkg.pkb 120.2 2006/05/11 14:53:19 nsanghal noship $ */
3: --
4: --
5: -- ----------------------------------------------------------------------------

Line 9: g_package varchar2(33) := ' pqh_mgmt_rpt_pkg.'; -- Global package name

5: -- ----------------------------------------------------------------------------
6: -- | Private Global Definitions |
7: -- ----------------------------------------------------------------------------
8: --
9: g_package varchar2(33) := ' pqh_mgmt_rpt_pkg.'; -- Global package name
10:
11: -------------------------------------------------------------------------------
12: FUNCTION get_budget_measurement_type
13: (

Line 4045: l_budgeted_amt := pqh_mgmt_rpt_pkg.get_position_budget_amt

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
4046: (
4047: p_budget_version_id => p_budget_version_id,
4048: p_position_id => p_position_id,
4049: p_start_date => p_start_date,

Line 4057: l_actual_amt := pqh_mgmt_rpt_pkg.get_position_actual_cmmtmnts

4053: );
4054:
4055: hr_utility.set_location('Budgeted Amt : '||NVL(l_budgeted_amt,0),10);
4056:
4057: l_actual_amt := pqh_mgmt_rpt_pkg.get_position_actual_cmmtmnts
4058: (
4059: p_budget_version_id => p_budget_version_id,
4060: p_position_id => p_position_id,
4061: p_start_date => p_start_date,

Line 4070: l_cmmtmnt_amt := pqh_mgmt_rpt_pkg.get_position_actual_cmmtmnts

4066: );
4067:
4068: hr_utility.set_location('Actual Amt : '||NVL(l_actual_amt,0),20);
4069:
4070: l_cmmtmnt_amt := pqh_mgmt_rpt_pkg.get_position_actual_cmmtmnts
4071: (
4072: p_budget_version_id => p_budget_version_id,
4073: p_position_id => p_position_id,
4074: p_start_date => p_start_date,

Line 4151: l_budgeted_amt := pqh_mgmt_rpt_pkg.get_position_budget_amt

4147: IF p_position_type = 'A' THEN
4148: RETURN 'A';
4149: END IF;
4150:
4151: l_budgeted_amt := pqh_mgmt_rpt_pkg.get_position_budget_amt
4152: (
4153: p_budget_version_id => p_budget_version_id,
4154: p_position_id => p_position_id,
4155: p_start_date => p_start_date,

Line 4163: l_actual_amt := pqh_mgmt_rpt_pkg.get_position_actual_cmmtmnts

4159: );
4160:
4161: hr_utility.set_location('Budgeted Amt : '||NVL(l_budgeted_amt,0),10);
4162:
4163: l_actual_amt := pqh_mgmt_rpt_pkg.get_position_actual_cmmtmnts
4164: (
4165: p_budget_version_id => p_budget_version_id,
4166: p_position_id => p_position_id,
4167: p_start_date => p_start_date,

Line 4176: l_cmmtmnt_amt := pqh_mgmt_rpt_pkg.get_position_actual_cmmtmnts

4172: );
4173:
4174: hr_utility.set_location('Actual Amt : '||NVL(l_actual_amt,0),20);
4175:
4176: l_cmmtmnt_amt := pqh_mgmt_rpt_pkg.get_position_actual_cmmtmnts
4177: (
4178: p_budget_version_id => p_budget_version_id,
4179: p_position_id => p_position_id,
4180: p_start_date => p_start_date,

Line 4285: l_budgeted_amt := pqh_mgmt_rpt_pkg.get_entity_budget_amt

4281: IF p_entity_type = 'A' THEN
4282: RETURN 'A';
4283: END IF;
4284:
4285: l_budgeted_amt := pqh_mgmt_rpt_pkg.get_entity_budget_amt
4286: (
4287: p_budget_version_id => p_budget_version_id,
4288: p_budgeted_entity_cd => 'JOB',
4289: p_job_id => p_job_id,

Line 4298: l_actual_amt := pqh_mgmt_rpt_pkg.get_entity_actual_cmmtmnts

4294: );
4295:
4296: hr_utility.set_location('Budgeted Amt : '||NVL(l_budgeted_amt,0),10);
4297:
4298: l_actual_amt := pqh_mgmt_rpt_pkg.get_entity_actual_cmmtmnts
4299: (
4300: p_budget_version_id => p_budget_version_id,
4301: p_budgeted_entity_cd => 'JOB',
4302: p_job_id => p_job_id,

Line 4312: l_cmmtmnt_amt := pqh_mgmt_rpt_pkg.get_entity_actual_cmmtmnts

4308: );
4309:
4310: hr_utility.set_location('Actual Amt : '||NVL(l_actual_amt,0),20);
4311:
4312: l_cmmtmnt_amt := pqh_mgmt_rpt_pkg.get_entity_actual_cmmtmnts
4313: (
4314: p_budget_version_id => p_budget_version_id,
4315: p_budgeted_entity_cd => 'JOB',
4316: p_job_id => p_job_id,

Line 4424: l_budgeted_amt := pqh_mgmt_rpt_pkg.get_entity_budget_amt

4420: IF p_entity_type = 'A' THEN
4421: RETURN 'A';
4422: END IF;
4423:
4424: l_budgeted_amt := pqh_mgmt_rpt_pkg.get_entity_budget_amt
4425: (
4426: p_budget_version_id => p_budget_version_id,
4427: p_budgeted_entity_cd => 'GRADE',
4428: p_grade_id => p_grade_id,

Line 4437: l_actual_amt := pqh_mgmt_rpt_pkg.get_entity_actual_cmmtmnts

4433: );
4434:
4435: hr_utility.set_location('Budgeted Amt : '||NVL(l_budgeted_amt,0),10);
4436:
4437: l_actual_amt := pqh_mgmt_rpt_pkg.get_entity_actual_cmmtmnts
4438: (
4439: p_budget_version_id => p_budget_version_id,
4440: p_budgeted_entity_cd => 'GRADE',
4441: p_grade_id => p_grade_id,

Line 4451: l_cmmtmnt_amt := pqh_mgmt_rpt_pkg.get_entity_actual_cmmtmnts

4447: );
4448:
4449: hr_utility.set_location('Actual Amt : '||NVL(l_actual_amt,0),20);
4450:
4451: l_cmmtmnt_amt := pqh_mgmt_rpt_pkg.get_entity_actual_cmmtmnts
4452: (
4453: p_budget_version_id => p_budget_version_id,
4454: p_budgeted_entity_cd => 'GRADE',
4455: p_grade_id => p_grade_id,

Line 4561: l_budgeted_amt := pqh_mgmt_rpt_pkg.get_entity_budget_amt

4557: IF p_entity_type = 'A' THEN
4558: RETURN 'A';
4559: END IF;
4560:
4561: l_budgeted_amt := pqh_mgmt_rpt_pkg.get_entity_budget_amt
4562: (
4563: p_budget_version_id => p_budget_version_id,
4564: p_budgeted_entity_cd => 'ORGANIZATION',
4565: p_organization_id => p_organization_id,

Line 4574: l_actual_amt := pqh_mgmt_rpt_pkg.get_entity_actual_cmmtmnts

4570: );
4571:
4572: hr_utility.set_location('Budgeted Amt : '||NVL(l_budgeted_amt,0),10);
4573:
4574: l_actual_amt := pqh_mgmt_rpt_pkg.get_entity_actual_cmmtmnts
4575: (
4576: p_budget_version_id => p_budget_version_id,
4577: p_budgeted_entity_cd => 'ORGANIZATION',
4578: p_organization_id => p_organization_id,

Line 4588: l_cmmtmnt_amt := pqh_mgmt_rpt_pkg.get_entity_actual_cmmtmnts

4584: );
4585:
4586: hr_utility.set_location('Actual Amt : '||NVL(l_actual_amt,0),20);
4587:
4588: l_cmmtmnt_amt := pqh_mgmt_rpt_pkg.get_entity_actual_cmmtmnts
4589: (
4590: p_budget_version_id => p_budget_version_id,
4591: p_budgeted_entity_cd => 'ORGANIZATION',
4592: p_organization_id => p_organization_id,

Line 5147: END pqh_mgmt_rpt_pkg;

5143: Exception
5144: When Others THen
5145: Return 0;
5146: END GET_ENTITY_BUDGET_AMT;
5147: END pqh_mgmt_rpt_pkg;