PACKAGE: APPS.OKS_OKSCODET_XMLP_PKG

Source

1 PACKAGE OKS_OKSCODET_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: OKSCODETS.pls 120.2 2007/12/25 07:57:11 nchinnam noship $ */
3   P_CONTRACT_ID varchar2(100);
4   --seq_val number;
5 
6   P_CUSTOMER_ID NUMBER;
7 
8   P_START_DATE_FROM DATE;
9 
10   P_END_DATE_FROM DATE;
11 
12   P_STATUS_CODE VARCHAR2(40);
13 
14   P_STATUS_TYPE VARCHAR2(40);
15 
16   P_START_DATE_TO DATE;
17 
18   P_END_DATE_TO DATE;
19 
20   P_CONTRACT_GROUP NUMBER;
21 
22   P_CONTRACT_GROUP_WHERE VARCHAR2(2000) := ' ';
23 
24   P_ORG_WHERE VARCHAR2(2000) := ' ';
25 
26   P_CONTRACT_ID_WHERE VARCHAR2(2000) := ' ';
27 
28   P_CUSTOMER_ID_WHERE VARCHAR2(2000) := ' ';
29 
30   P_STATUS_TYPE_WHERE VARCHAR2(2000) := ' ';
31 
32   P_STATUS_CODE_WHERE VARCHAR2(2000) := ' ';
33 
34   P_START_DATE_FROM_WHERE VARCHAR2(2000) := ' ';
35 
36   P_START_DATE_TO_WHERE VARCHAR2(2000) := ' ';
37 
38   P_END_DATE_FROM_WHERE VARCHAR2(2000) := ' ';
39 
40   P_END_DATE_TO_WHERE VARCHAR2(2000) := ' ';
41 
42   P_ORG NUMBER;
43 
44   P_CONC_REQUEST_ID NUMBER;
45 
46   P_OPERATING_UNIT NUMBER;
47 
48   CP_PROD_NAME VARCHAR2(300);
49 
50   CP_CSI VARCHAR2(100);
51 
52   CP_PROD_SERIAL_NO VARCHAR2(50);
53 
54   CP_PROD_REF_NO VARCHAR2(50);
55 
56   CP_PROD_QTY NUMBER;
57 
58   CP_NUM_OF_USERS VARCHAR2(150);
59 
60   CP_PRICING_LIC_LVL VARCHAR2(150);
61 
62   CP_LIC_LVL VARCHAR2(150);
63 
64   FUNCTION BEFOREREPORT RETURN BOOLEAN;
65 
66   FUNCTION CF_PARTYROLEFORMULA(RLE_CODE IN VARCHAR2) RETURN CHAR;
67 
68   FUNCTION CF_PARTYNAMEFORMULA(OBJECT1_ID1 IN VARCHAR2
69                               ,JTOT_OBJECT1_CODE IN VARCHAR2) RETURN CHAR;
70 
71   FUNCTION CF_PRICE_NEGOTIATED_ROUNDFORMU(PRICE_NEGOTIATED IN NUMBER
72                                          ,CURRENCY_CODE IN VARCHAR2) RETURN NUMBER;
73 
74   FUNCTION CF_SRV_PRICE_ROUNDFORMULA(SL_PRICE_NEGOTIATED IN NUMBER
75                                     ,CURRENCY_CODE IN VARCHAR2) RETURN NUMBER;
76 
77   FUNCTION CF_HDR_PRICE_ROUNDFORMULA(CS_HDR_PRICE IN NUMBER
78                                     ,CURRENCY_CODE IN VARCHAR2) RETURN NUMBER;
79 
80   FUNCTION CF_PRODUCT_DETAILSFORMULA(CL_ID IN NUMBER) RETURN NUMBER;
81 
82   FUNCTION CF_SERVICE_LEVELFORMULA(SL_LSE_ID IN NUMBER
83                                   ,SL_ID IN NUMBER) RETURN CHAR;
84 
85   FUNCTION AFTERPFORM RETURN BOOLEAN;
86 
87   FUNCTION AFTERREPORT RETURN BOOLEAN;
88 
89   FUNCTION CF_TOTAL_VALUEFORMULA(CL_STE_CODE IN VARCHAR2
90                                 ,PRICE_NEGOTIATED IN NUMBER) RETURN NUMBER;
91 
92   FUNCTION CF_CANCELLED_VALUEFORMULA(CL_STE_CODE IN VARCHAR2
93                                     ,PRICE_NEGOTIATED IN NUMBER) RETURN NUMBER;
94 
95   FUNCTION CF_CANCELLED_PRICE_ROUNDFORMUL(CS_CANCELLED_PRICE IN NUMBER
96                                          ,CURRENCY_CODE IN VARCHAR2) RETURN NUMBER;
97 
98   FUNCTION CP_PROD_NAME_P RETURN VARCHAR2;
99 
100   FUNCTION CP_CSI_P RETURN VARCHAR2;
101 
102   FUNCTION CP_PROD_SERIAL_NO_P RETURN VARCHAR2;
103 
104   FUNCTION CP_PROD_REF_NO_P RETURN VARCHAR2;
105 
106   FUNCTION CP_PROD_QTY_P RETURN NUMBER;
107 
108   FUNCTION CP_NUM_OF_USERS_P RETURN VARCHAR2;
109 
110   FUNCTION CP_PRICING_LIC_LVL_P RETURN VARCHAR2;
111 
112   FUNCTION CP_LIC_LVL_P RETURN VARCHAR2;
113 
114 END OKS_OKSCODET_XMLP_PKG;
115