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.HRI_APL_DGNSTC_WBM dependencies on HRI_APL_DGNSTC_WBM

Line 1: PACKAGE BODY HRI_APL_DGNSTC_WBM AS

1: PACKAGE BODY HRI_APL_DGNSTC_WBM AS
2: /* $Header: hridgwbm.pkb 120.6 2006/08/23 15:39:06 rlpatil noship $ */
3:
4: FUNCTION GET_CTRL_HDCNT_BDGTS
5: RETURN VARCHAR2

Line 502: HRI_APL_DGNSTC_WBM.GET_ELE_NAME(ELE.BUDGET_ELEMENT_ID,:p_start_date),

498: l_sql_stmt :=
499: '
500: SELECT PB.BUDGET_NAME ||'' (''|| PBV.VERSION_NUMBER ||'')'',
501: PDBS.DFLT_BUDGET_SET_NAME,
502: HRI_APL_DGNSTC_WBM.GET_ELE_NAME(ELE.BUDGET_ELEMENT_ID,:p_start_date),
503: NULL COL4,
504: NULL COL5
505: FROM PQH_BUDGETS PB,
506: PQH_BUDGET_VERSIONS PBV,

Line 553: HRI_APL_DGNSTC_WBM.GET_BSET_NAME(BSET.BUDGET_SET_ID,BSET.BUSINESS_GROUP_ID),

549: BEGIN
550: l_sql_stmt :=
551: '
552: SELECT BSET.BUDGET,
553: HRI_APL_DGNSTC_WBM.GET_BSET_NAME(BSET.BUDGET_SET_ID,BSET.BUSINESS_GROUP_ID),
554: SUM( CASE WHEN BSET.BUDGET_UNIT1_ID = BSET.SHARED_TYPE_ID THEN ELE.DISTRIBUTION_PERCENTAGE
555: WHEN BSET.BUDGET_UNIT2_ID = BSET.SHARED_TYPE_ID THEN ELE.DISTRIBUTION_PERCENTAGE
556: WHEN BSET.BUDGET_UNIT3_ID = BSET.SHARED_TYPE_ID THEN ELE.DISTRIBUTION_PERCENTAGE
557: END ),

Line 1322: HRI_APL_DGNSTC_WBM.GET_BSET_NAME(BSET.BUDGET_SET_ID,PB.BUSINESS_GROUP_ID) ,

1318: BEGIN
1319: l_sql_stmt :=
1320: '
1321: SELECT DISTINCT PB.BUDGET_NAME ||'' (''|| PBV.VERSION_NUMBER ||'')'' ,
1322: HRI_APL_DGNSTC_WBM.GET_BSET_NAME(BSET.BUDGET_SET_ID,PB.BUSINESS_GROUP_ID) ,
1323: HRI_APL_DGNSTC_WBM.GET_ELE_NAME(ELE.ELEMENT_TYPE_ID,:p_start_date) ,
1324: HRI_APL_DGNSTC_WBM.GET_FSC_NAME(SRC.COST_ALLOCATION_KEYFLEX_ID) ,
1325: (src.distribution_percentage * ele.distribution_percentage / 100 )
1326: FROM PQH_BUDGETS PB,

Line 1323: HRI_APL_DGNSTC_WBM.GET_ELE_NAME(ELE.ELEMENT_TYPE_ID,:p_start_date) ,

1319: l_sql_stmt :=
1320: '
1321: SELECT DISTINCT PB.BUDGET_NAME ||'' (''|| PBV.VERSION_NUMBER ||'')'' ,
1322: HRI_APL_DGNSTC_WBM.GET_BSET_NAME(BSET.BUDGET_SET_ID,PB.BUSINESS_GROUP_ID) ,
1323: HRI_APL_DGNSTC_WBM.GET_ELE_NAME(ELE.ELEMENT_TYPE_ID,:p_start_date) ,
1324: HRI_APL_DGNSTC_WBM.GET_FSC_NAME(SRC.COST_ALLOCATION_KEYFLEX_ID) ,
1325: (src.distribution_percentage * ele.distribution_percentage / 100 )
1326: FROM PQH_BUDGETS PB,
1327: PQH_BUDGET_VERSIONS PBV,

Line 1324: HRI_APL_DGNSTC_WBM.GET_FSC_NAME(SRC.COST_ALLOCATION_KEYFLEX_ID) ,

1320: '
1321: SELECT DISTINCT PB.BUDGET_NAME ||'' (''|| PBV.VERSION_NUMBER ||'')'' ,
1322: HRI_APL_DGNSTC_WBM.GET_BSET_NAME(BSET.BUDGET_SET_ID,PB.BUSINESS_GROUP_ID) ,
1323: HRI_APL_DGNSTC_WBM.GET_ELE_NAME(ELE.ELEMENT_TYPE_ID,:p_start_date) ,
1324: HRI_APL_DGNSTC_WBM.GET_FSC_NAME(SRC.COST_ALLOCATION_KEYFLEX_ID) ,
1325: (src.distribution_percentage * ele.distribution_percentage / 100 )
1326: FROM PQH_BUDGETS PB,
1327: PQH_BUDGET_VERSIONS PBV,
1328: PQH_BUDGET_DETAILS PBD,

Line 1357: ORDER BY HRI_APL_DGNSTC_WBM.GET_BSET_NAME(BSET.BUDGET_SET_ID,PB.BUSINESS_GROUP_ID) ,

1353: AND PRD.START_TIME_PERIOD_ID = PTPS.TIME_PERIOD_ID
1354: AND PRD.END_TIME_PERIOD_ID = PTPE.TIME_PERIOD_ID
1355: AND BSET.BUDGET_SET_ID = ELE.BUDGET_SET_ID
1356: AND ELE.BUDGET_ELEMENT_ID = SRC.BUDGET_ELEMENT_ID
1357: ORDER BY HRI_APL_DGNSTC_WBM.GET_BSET_NAME(BSET.BUDGET_SET_ID,PB.BUSINESS_GROUP_ID) ,
1358: HRI_APL_DGNSTC_WBM.GET_ELE_NAME(ELE.ELEMENT_TYPE_ID,:p_start_date)
1359: ';
1360: RETURN l_sql_stmt;
1361: END GET_BDGTS_BSET;

Line 1358: HRI_APL_DGNSTC_WBM.GET_ELE_NAME(ELE.ELEMENT_TYPE_ID,:p_start_date)

1354: AND PRD.END_TIME_PERIOD_ID = PTPE.TIME_PERIOD_ID
1355: AND BSET.BUDGET_SET_ID = ELE.BUDGET_SET_ID
1356: AND ELE.BUDGET_ELEMENT_ID = SRC.BUDGET_ELEMENT_ID
1357: ORDER BY HRI_APL_DGNSTC_WBM.GET_BSET_NAME(BSET.BUDGET_SET_ID,PB.BUSINESS_GROUP_ID) ,
1358: HRI_APL_DGNSTC_WBM.GET_ELE_NAME(ELE.ELEMENT_TYPE_ID,:p_start_date)
1359: ';
1360: RETURN l_sql_stmt;
1361: END GET_BDGTS_BSET;
1362:

Line 1371: SELECT HRI_APL_DGNSTC_WBM.GET_ELE_NAME(ELEMENT_TYPE_ID,:p_start_date),

1367: l_sql_stmt VARCHAR2 (32000);
1368: BEGIN
1369: l_sql_stmt :=
1370: '
1371: SELECT HRI_APL_DGNSTC_WBM.GET_ELE_NAME(ELEMENT_TYPE_ID,:p_start_date),
1372: NULL COL2,
1373: NULL COL3,
1374: NULL COL4,
1375: NULL COL5

Line 1389: ORDER BY HRI_APL_DGNSTC_WBM.GET_ELE_NAME(ELEMENT_TYPE_ID,:p_start_date)

1385: FROM HRI_MB_ACTLS_CT
1386: WHERE EFFECTIVE_DATE <= :p_end_date
1387: AND EFFECTIVE_DATE >= :p_start_date
1388: )
1389: ORDER BY HRI_APL_DGNSTC_WBM.GET_ELE_NAME(ELEMENT_TYPE_ID,:p_start_date)
1390: ';
1391: RETURN l_sql_stmt;
1392: END GET_ELE_NOT_IN_ACTLS;
1393:

Line 1472: END HRI_APL_DGNSTC_WBM;

1468: RETURN l_fsc_name;
1469: END GET_FSC_NAME;
1470:
1471:
1472: END HRI_APL_DGNSTC_WBM;