[Home] [Help]
PACKAGE: APPS.OKS_OKSSCOFM_XMLP_PKG
Source
1 PACKAGE OKS_OKSSCOFM_XMLP_PKG AS
2 /* $Header: OKSSCOFMS.pls 120.2 2007/12/25 07:59:17 nchinnam noship $ */
3 P_SALESREP NUMBER;
4 P_OPERATING_UNIT NUMBER;
5 P_STATUS_CODE VARCHAR2(100);
6 P_FORECAST_ST_PERIOD DATE;
7 P_FORECAST_END_PERIOD DATE;
8 P_FORECAST_ST_PERIOD_V varchar2(40);
9 P_FORECAST_END_PERIOD_V varchar2(40);
10 P_MINIMUM_CONTRACT_VALUE NUMBER;
11 P_REVENUE_RECONIZED NUMBER;
12 P_REGZ_DATE DATE;
13 P_MAXIMUM_CONTRACT_VALUE NUMBER;
14 P_CURRENCY_CODE VARCHAR2(32767);
15 P_WHERE_CLAUSE VARCHAR2(5000) := ' ';
16 P_SALESREP_NAME VARCHAR2(1000);
17 P_ORG_NAME VARCHAR2(1000);
18 P_CONTRACT_GROUP NUMBER;
19 P_CONTRACT_GROUP_WHERE VARCHAR2(2000) := ' ';
20 P_CONTRACT_GROUP_NAME VARCHAR2(200);
21 P_CONC_REQUEST_ID NUMBER;
22 FUNCTION BEFOREREPORT RETURN BOOLEAN;
23 FUNCTION CF_FORECAST_REVFORMULA(CF_CONTRACT_VALUE IN NUMBER
24 ,FORECAST_PER IN NUMBER
25 ,CF_REV_REC IN NUMBER) RETURN NUMBER;
26 FUNCTION CF_SALESREP_NAMEFORMULA(SR_SALESREP_ID IN VARCHAR2
27 ,ORG_ID IN NUMBER) RETURN CHAR;
28 FUNCTION CF_PARTY_NAMEFORMULA(HZ_PARTY_ID IN VARCHAR2) RETURN CHAR;
29 FUNCTION CF_CONTRACT_VALUEFORMULA(CONTRACT_ID IN NUMBER) RETURN NUMBER;
30 FUNCTION CF_CONTRACT_FORECASTFORMULA(CF_CONTRACT_VALUE IN NUMBER
31 ,FORECAST_PER IN NUMBER) RETURN NUMBER;
32 FUNCTION CF_REV_RECFORMULA(CONTRACT_ID IN NUMBER
33 ,CF_CONTRACT_VALUE IN NUMBER) RETURN NUMBER;
34 FUNCTION AFTERPFORM RETURN BOOLEAN;
35 FUNCTION AFTERREPORT RETURN BOOLEAN;
36 END OKS_OKSSCOFM_XMLP_PKG;
37