PACKAGE: APPS.OKS_OKSSUMRP_XMLP_PKG

Source

1 PACKAGE OKS_OKSSUMRP_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: OKSSUMRPS.pls 120.2 2007/12/25 08:02:30 nchinnam noship $ */
3   P_REP_NAME_WHERE VARCHAR2(1000) := ' ';
4 
5   P_CUSTOMER_NAME_WHERE VARCHAR2(1000) := ' ';
6 
7   P_FROM_DATE DATE;
8 
9   P_TO_DATE DATE;
10 
11   P_CUSTOMER_NAME NUMBER;
12 
13   P_REP_NAME NUMBER;
14 
15   P_OPERATING_UNIT NUMBER;
16 
17   P_ORG_ID_WHERE VARCHAR2(1000);
18 
19   P_CUSTOMER_NUMBER NUMBER;
20 
21   P_CUSTOMER_NUMBER_WHERE VARCHAR2(1000) := ' ';
22 
23   P_CURRENCY_CODE_WHERE VARCHAR2(1000) := ' ';
24 
25   P_CURRENCY_CODE VARCHAR2(50);
26 
27   P_CONTRACT_GROUP NUMBER;
28 
29   P_CONTRACT_GROUP_WHERE VARCHAR2(2000) := ' ';
30 
31   P_START_DATE_WHERE VARCHAR2(2000) := ' ';
32 
33   P_CONC_REQUEST_ID NUMBER;
34 
35   FUNCTION BEFOREREPORT RETURN BOOLEAN;
36 
37   FUNCTION CF_1FORMULA(REP_NAME1 IN VARCHAR2
38                       ,ORG_ID IN NUMBER) RETURN VARCHAR2;
39 
40   FUNCTION CF_LAST_INTRERACTIONFORMULA(CONTRACT_ID IN NUMBER) RETURN CHAR;
41 
42   FUNCTION AFTERPFORM RETURN BOOLEAN;
43 
44   FUNCTION AFTERREPORT RETURN BOOLEAN;
45 
46 END OKS_OKSSUMRP_XMLP_PKG;
47