PACKAGE: APPS.OKS_OKSSUMCO_XMLP_PKG

Source

1 PACKAGE OKS_OKSSUMCO_XMLP_PKG AS
2 /* $Header: OKSSUMCOS.pls 120.2 2007/12/25 07:59:55 nchinnam noship $ */
3   P_REP_NAME_WHERE VARCHAR2(1000) := ' ';
4 
5   P_CUSTOMER_NAME_WHERE VARCHAR2(1000) := ' ';
6 
7   P_STATUS_CODE_WHERE VARCHAR2(1000) := ' ';
8 
9   P_START_FROM_DATE DATE;
10   LP_START_FROM_DATE varchar2(11);
11 
12   P_CUSTOMER_NAME NUMBER;
13 
14   P_REP_NAME NUMBER;
15 
16   P_STATUS_CODE VARCHAR2(500);
17 
18   P_START_TO_DATE DATE;
19   LP_START_TO_DATE varchar2(11);
20 
21   P_END_FROM_DATE DATE;
22   LP_END_FROM_DATE varchar2(11);
23 
24   P_END_TO_DATE DATE;
25   LP_END_TO_DATE varchar2(11);
26 
27   P_CUSTOMER_NUMBER NUMBER;
28 
29   P_CUSTOMER_NUMBER_WHERE VARCHAR2(1000) := ' ';
30 
31   P_STATUS_TYPE VARCHAR2(500);
32 
33   P_STATUS_TYPE_WHERE VARCHAR2(1000) := ' ';
34 
35   P_ORG_ID NUMBER;
36 
37   P_ORG_ID_WHERE VARCHAR2(1000) := ' ';
38 
39   P_DETAIL_YN VARCHAR2(5);
40 
41   P_CURRENCY_CODE VARCHAR2(50);
42 
43   P_CURRENCY_CODE_WHERE VARCHAR2(1000) := ' ';
44 
45   P_CONTRACT_GROUP NUMBER;
46 
47   P_CONTRACT_GROUP_WHERE VARCHAR2(2000) := ' ';
48 
49   P_START_END_DATE_WHERE VARCHAR2(2000) := ' ';
50 
51   P_CONC_REQUEST_ID NUMBER;
52 
53   P_VENDOR_CONT_ROLE VARCHAR2(500);
54 
55   P_REP_ID_CHAR VARCHAR2(500);
56 
57   P_PARTY_ID_NUM_CHAR VARCHAR2(500);
58 
59   P_PARTY_ID_NAME_CHAR VARCHAR2(500);
60 
61   P_CONTRACT_GROUP_FROM VARCHAR2(2000) := ' ';
62 
63   FUNCTION BEFOREREPORT RETURN BOOLEAN;
64 
65   FUNCTION CF_SALESREP_NAMEFORMULA(REP_NAME IN VARCHAR2
66                                   ,ORG_ID IN NUMBER) RETURN CHAR;
67 
68   FUNCTION AFTERPFORM RETURN BOOLEAN;
69 
70   FUNCTION CF_TYPEFORMULA(STATUS_TYPE_SUBSTR IN VARCHAR2) RETURN CHAR;
71 
72   FUNCTION CF_STATUSCODEFORMULA(STATUS_CODE_SUBSTR IN VARCHAR2) RETURN CHAR;
73 
74   FUNCTION CF_PRODLINEVALUEFORMULA(CONTRACT_ID IN NUMBER
75                                   ,STATUS_CODE IN VARCHAR2
76                                   ,CURRENCY_CODE IN VARCHAR2) RETURN NUMBER;
77 
78   FUNCTION CF_RECCOUNTFORMULA RETURN NUMBER;
79 
80   FUNCTION CF_PRODLINE_VALUEPERDAYFORMULA(CONTRACT_ID IN NUMBER
81                                          ,STATUS_CODE IN VARCHAR2
82                                          ,CURRENCY_CODE IN VARCHAR2) RETURN NUMBER;
83 
84   FUNCTION CF_PRODLINE_ANNRATEFORMULA(CF_PRODLINE_VALUEPERDAY IN NUMBER) RETURN NUMBER;
85 
86   FUNCTION AFTERREPORT RETURN BOOLEAN;
87 
88 END OKS_OKSSUMCO_XMLP_PKG;
89