1: PACKAGE BODY OKS_OKSFOSUM_XMLP_PKG AS
2: /* $Header: OKSFOSUMB.pls 120.2 2007/12/25 07:57:32 nchinnam noship $ */
3: FUNCTION BEFOREREPORT RETURN BOOLEAN IS
4: CURSOR ORG IS
5: SELECT
19: FETCH ORG
20: INTO CP_ORG_NAME;
21: CLOSE ORG;
22: END IF;
23: OKS_EXTWAR_UTIL_PVT.CALCULATE_REV_REC(P_CONC_REQUEST_ID => OKS_OKSFOSUM_XMLP_PKG.P_CONC_REQUEST_ID
24: ,P_CONTRACT_GROUP => OKS_OKSFOSUM_XMLP_PKG.P_CONTRACT_GROUP
25: ,P_ORGID => LP_OPERATING_UNIT
26: ,P_FORFDATE => P_START_DATE
27: ,P_FORTDATE => P_END_DATE
20: INTO CP_ORG_NAME;
21: CLOSE ORG;
22: END IF;
23: OKS_EXTWAR_UTIL_PVT.CALCULATE_REV_REC(P_CONC_REQUEST_ID => OKS_OKSFOSUM_XMLP_PKG.P_CONC_REQUEST_ID
24: ,P_CONTRACT_GROUP => OKS_OKSFOSUM_XMLP_PKG.P_CONTRACT_GROUP
25: ,P_ORGID => LP_OPERATING_UNIT
26: ,P_FORFDATE => P_START_DATE
27: ,P_FORTDATE => P_END_DATE
28: ,P_MIN => P_MIN_VAL
97: FUNCTION CP_ORG_NAME_P RETURN VARCHAR2 IS
98: BEGIN
99: RETURN CP_ORG_NAME;
100: END CP_ORG_NAME_P;
101: END OKS_OKSFOSUM_XMLP_PKG;
102: