APPS.PQH_CBR_ENGINE dependencies on PQH_MGMT_RPT_PKG

Line 70: p_prd_act_amt := pqh_mgmt_rpt_pkg.get_position_actual_cmmtmnts

66: p_prd_bgt_amt := nvl(l_unit3_value,0);
67: end if;
68: hr_utility.set_Location('bgt_amt is'||p_prd_bgt_amt,20);
69: if g_budget_entity ='POSITION' then
70: p_prd_act_amt := pqh_mgmt_rpt_pkg.get_position_actual_cmmtmnts
71: (p_budget_version_id => g_budget_version_id,
72: p_position_id => p_budget_entity_id,
73: p_start_date => l_prd_start_date,
74: p_end_date => l_prd_end_date,

Line 80: p_prd_com_amt:= pqh_mgmt_rpt_pkg.get_position_actual_cmmtmnts

76: p_value_type => 'A' ,
77: p_currency_code => g_budget_currency);
78: hr_utility.set_Location('act_amt is'||p_prd_act_amt,30);
79: if g_budget_unit_type ='M' then
80: p_prd_com_amt:= pqh_mgmt_rpt_pkg.get_position_actual_cmmtmnts
81: (p_budget_version_id => g_budget_version_id,
82: p_position_id => p_budget_entity_id,
83: p_start_date => l_prd_start_date,
84: p_end_date => l_prd_end_date,

Line 100: p_prd_act_amt := pqh_mgmt_rpt_pkg.get_entity_actual_cmmtmnts

96: l_grade_id := p_budget_entity_id;
97: elsif g_budget_entity ='ORGANIZATION' then
98: l_organization_id := p_budget_entity_id;
99: end if;
100: p_prd_act_amt := pqh_mgmt_rpt_pkg.get_entity_actual_cmmtmnts
101: (p_budget_version_id => g_budget_version_id,
102: p_budgeted_entity_cd => g_budget_entity,
103: p_job_id => l_job_id,
104: p_grade_id => l_grade_id,

Line 113: p_prd_com_amt := pqh_mgmt_rpt_pkg.get_entity_actual_cmmtmnts

109: p_value_type => 'A' ,
110: p_currency_code => g_budget_currency);
111: hr_utility.set_Location('act_amt is'||p_prd_act_amt,50);
112: if g_budget_unit_type ='M' then
113: p_prd_com_amt := pqh_mgmt_rpt_pkg.get_entity_actual_cmmtmnts
114: (p_budget_version_id => g_budget_version_id,
115: p_budgeted_entity_cd => g_budget_entity,
116: p_job_id => l_job_id,
117: p_grade_id => l_grade_id,

Line 1612: elsif upper(l_attribute_rec.column_name) like 'PQH_MGMT_RPT_PKG.GET_ENTITY_BUDGET_AMT(FLD.ENTITY_TYPE,TRNXAMT.ENTITY_ID,FLD.BUDGET_VERSION_ID%' then

1608: l_applicability := 'BOTH';
1609: elsif upper(l_attribute_rec.column_name) in ('ORU.LOCATION_ID','ORU.TYPE','ORU.NAME','HR_GENERAL.DECODE_LOCATION(ORU.LOCATION_ID)') then
1610: l_entity_type := 'ORGANIZATION';
1611: l_applicability := 'BOTH';
1612: elsif upper(l_attribute_rec.column_name) like 'PQH_MGMT_RPT_PKG.GET_ENTITY_BUDGET_AMT(FLD.ENTITY_TYPE,TRNXAMT.ENTITY_ID,FLD.BUDGET_VERSION_ID%' then
1613: l_entity_type := 'ALL';
1614: l_applicability := 'BOTH';
1615: elsif upper(l_attribute_rec.column_name) like 'PQH_BDGT_ACTUAL_CMMTMNT_PKG.GET_ENT_ACTUAL_AND_CMMTMNT(FLD.BUDGET_VERSION_ID%' then
1616: l_entity_type := 'ALL';