PACKAGE: APPS.OKS_OKSNREPD_XMLP_PKG

Source

1 PACKAGE OKS_OKSNREPD_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: OKSNREPDS.pls 120.2 2007/12/25 07:58:33 nchinnam noship $ */
3   P_ORG_ID NUMBER;
4 
5   P_FROM_END_DATE DATE;
6 
7   P_TO_END_DATE DATE;
8 
9   P_SALESREP VARCHAR2(120);
10 
11   P_CUSTOMER_NAME VARCHAR2(240);
12 
13   P_CUSTOMER_NAME_WHERE VARCHAR2(800):=' ';
14 
15   P_ORG_ID_WHERE VARCHAR2(800):=' ';
16 
17   P_SALESREP_WHERE VARCHAR2(800):=' ';
18 
19   P_CONTRACT_GROUP NUMBER;
20 
21   P_CONTRACT_GROUP_WHERE VARCHAR2(2000):=' ';
22 
23   P_FROM_END_DATE_WHERE VARCHAR2(2000):=' ';
24 
25   P_TO_END_DATE_WHERE VARCHAR2(2000):=' ';
26 
27   P_CONC_REQUEST_ID NUMBER;
28 
29   CP_DESCRIPTION VARCHAR2(500);
30 
31   FUNCTION CF_1FORMULA(CUSTOMER_PRODUCT_ID_v IN VARCHAR2) RETURN VARCHAR2;
32 
33   FUNCTION CF_2FORMULA(CUSTOMER_PRODUCT_ID_v IN VARCHAR2
34                       ,ORGANIZATION_ID_v IN NUMBER) RETURN CHAR;
35 
36   FUNCTION BEFOREREPORT RETURN BOOLEAN;
37 
38   FUNCTION CF_SALESREP_NAMEFORMULA(SALESREP_ID_v IN VARCHAR2
39                                   ,ORG_ID_v IN NUMBER) RETURN CHAR;
40 
41   FUNCTION AFTERPFORM RETURN BOOLEAN;
42 
43   FUNCTION AFTERREPORT RETURN BOOLEAN;
44 
45   FUNCTION CP_DESCRIPTION_P RETURN VARCHAR2;
46 
47 END OKS_OKSNREPD_XMLP_PKG;
48