DBA Data[Home] [Help]

APPS.HRI_OLTP_PMV_LBRCST_ORGMGR dependencies on HRI_OLTP_PMV_LBRCST_ORGMGR

Line 1: PACKAGE BODY HRI_OLTP_PMV_LBRCST_ORGMGR AS

1: PACKAGE BODY HRI_OLTP_PMV_LBRCST_ORGMGR AS
2: /* $Header: hrirplom.pkb 120.15 2006/03/14 20:12:44 rlpatil noship $ */
3:
4: l_currency VARCHAR2(10);
5: l_rateType VARCHAR2(10);

Line 100: HRI_OLTP_PMV_LBRCST_ORGMGR.CALC_PREV_VALUE_ORG

96: HRI_OLTP_VIEW_CURRENCY.CONVERT_CURRENCY_AMOUNT
97: (CURRENCY_CODE,
98: '''||l_currency||''',
99: &BIS_CURRENT_ASOF_DATE,
100: HRI_OLTP_PMV_LBRCST_ORGMGR.CALC_PREV_VALUE_ORG
101: (&HRI_PERSON+HRI_PER_USRDR_H
102: ,ORGANIZATION_ID
103: ,&BIS_PREVIOUS_EFFECTIVE_START_DATE
104: ,&BIS_PREVIOUS_EFFECTIVE_END_DATE

Line 312: HRI_OLTP_PMV_LBRCST_ORGMGR.GET_KPI_MGR_TOTALS

308: HRI_OLTP_VIEW_CURRENCY.CONVERT_CURRENCY_AMOUNT
309: (CURRENCY_CODE,
310: '''||l_currency||''',
311: &BIS_CURRENT_ASOF_DATE,
312: HRI_OLTP_PMV_LBRCST_ORGMGR.GET_KPI_MGR_TOTALS
313: (&HRI_PERSON+HRI_PER_USRDR_H
314: ,&BIS_PREVIOUS_EFFECTIVE_START_DATE
315: ,&BIS_PREVIOUS_EFFECTIVE_END_DATE
316: ,''ACTUAL''

Line 323: HRI_OLTP_PMV_LBRCST_ORGMGR.GET_KPI_MGR_TOTALS

319: HRI_OLTP_VIEW_CURRENCY.CONVERT_CURRENCY_AMOUNT
320: (CURRENCY_CODE,
321: '''||l_currency||''',
322: &BIS_CURRENT_ASOF_DATE,
323: HRI_OLTP_PMV_LBRCST_ORGMGR.GET_KPI_MGR_TOTALS
324: (&HRI_PERSON+HRI_PER_USRDR_H
325: ,&BIS_PREVIOUS_EFFECTIVE_START_DATE
326: ,&BIS_PREVIOUS_EFFECTIVE_END_DATE
327: ,''CMMT''

Line 354: HRI_OLTP_PMV_LBRCST_ORGMGR.GET_KPI_MGR_TOTALS

350: HRI_OLTP_VIEW_CURRENCY.CONVERT_CURRENCY_AMOUNT
351: (CURRENCY_CODE,
352: '''||l_currency||''',
353: &BIS_CURRENT_ASOF_DATE,
354: HRI_OLTP_PMV_LBRCST_ORGMGR.GET_KPI_MGR_TOTALS
355: (&HRI_PERSON+HRI_PER_USRDR_H
356: ,&BIS_PREVIOUS_EFFECTIVE_START_DATE
357: ,&BIS_PREVIOUS_EFFECTIVE_END_DATE
358: ,''BDGT''

Line 414: HRI_OLTP_PMV_LBRCST_ORGMGR.GET_KPI_TOTALS

410: HRI_OLTP_VIEW_CURRENCY.CONVERT_CURRENCY_AMOUNT
411: (CURRENCY_CODE,
412: '''||l_currency||''',
413: &BIS_CURRENT_ASOF_DATE,
414: HRI_OLTP_PMV_LBRCST_ORGMGR.GET_KPI_TOTALS
415: (&HRI_PERSON+HRI_PER_USRDR_H
416: ,&BIS_PREVIOUS_EFFECTIVE_START_DATE
417: ,&BIS_PREVIOUS_EFFECTIVE_END_DATE
418: ,''ACTUAL''

Line 425: HRI_OLTP_PMV_LBRCST_ORGMGR.GET_KPI_TOTALS

421: HRI_OLTP_VIEW_CURRENCY.CONVERT_CURRENCY_AMOUNT
422: (CURRENCY_CODE,
423: '''||l_currency||''',
424: &BIS_CURRENT_ASOF_DATE,
425: HRI_OLTP_PMV_LBRCST_ORGMGR.GET_KPI_TOTALS
426: (&HRI_PERSON+HRI_PER_USRDR_H
427: ,&BIS_PREVIOUS_EFFECTIVE_START_DATE
428: ,&BIS_PREVIOUS_EFFECTIVE_END_DATE
429: ,''CMMT''

Line 450: HRI_OLTP_PMV_LBRCST_ORGMGR.GET_KPI_TOTALS

446: HRI_OLTP_VIEW_CURRENCY.CONVERT_CURRENCY_AMOUNT
447: (CURRENCY_CODE,
448: '''||l_currency||''',
449: &BIS_CURRENT_ASOF_DATE,
450: HRI_OLTP_PMV_LBRCST_ORGMGR.GET_KPI_TOTALS
451: (&HRI_PERSON+HRI_PER_USRDR_H
452: ,&BIS_PREVIOUS_EFFECTIVE_START_DATE
453: ,&BIS_PREVIOUS_EFFECTIVE_END_DATE
454: ,''BDGT''

Line 755: HRI_OLTP_PMV_LBRCST_ORGMGR.CALC_PREV_VALUE_POS

751: HRI_OLTP_VIEW_CURRENCY.CONVERT_CURRENCY_AMOUNT
752: (CURRENCY_CODE,
753: '''||l_currency||''',
754: &BIS_CURRENT_ASOF_DATE,
755: HRI_OLTP_PMV_LBRCST_ORGMGR.CALC_PREV_VALUE_POS
756: (&HRI_PERSON+HRI_PER_USRDR_H
757: ,&HRI_P_CHAR2_GA
758: ,&BIS_PREVIOUS_EFFECTIVE_START_DATE
759: ,&BIS_PREVIOUS_EFFECTIVE_END_DATE

Line 1063: HRI_OLTP_PMV_LBRCST_ORGMGR.CALC_PREV_VALUE_ELE

1059: HRI_OLTP_VIEW_CURRENCY.CONVERT_CURRENCY_AMOUNT
1060: (CURRENCY_CODE,
1061: '''||l_currency||''',
1062: &BIS_CURRENT_ASOF_DATE,
1063: HRI_OLTP_PMV_LBRCST_ORGMGR.CALC_PREV_VALUE_ELE
1064: (&HRI_PERSON+HRI_PER_USRDR_H
1065: ,&HRI_P_CHAR2_GA
1066: ,&HRI_P_CHAR4_GA
1067: ,&BIS_PREVIOUS_EFFECTIVE_START_DATE

Line 1258: HRI_OLTP_PMV_LBRCST_ORGMGR.CALC_PREV_VALUE_FSC

1254: HRI_OLTP_VIEW_CURRENCY.CONVERT_CURRENCY_AMOUNT
1255: (CURRENCY_CODE,
1256: '''||l_currency||''',
1257: &BIS_CURRENT_ASOF_DATE,
1258: HRI_OLTP_PMV_LBRCST_ORGMGR.CALC_PREV_VALUE_FSC
1259: (&HRI_PERSON+HRI_PER_USRDR_H
1260: ,&HRI_P_CHAR2_GA
1261: ,&HRI_P_CHAR4_GA
1262: ,&BIS_PREVIOUS_EFFECTIVE_START_DATE

Line 1308: END HRI_OLTP_PMV_LBRCST_ORGMGR;

1304: x_custom_sql := l_SQLText;
1305:
1306: END GET_FSC_SQL;
1307:
1308: END HRI_OLTP_PMV_LBRCST_ORGMGR;
1309: