PACKAGE: APPS.OKS_OKSSCOFM_XMLP_PKG

Source

1 PACKAGE OKS_OKSSCOFM_XMLP_PKG AUTHID CURRENT_USER 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