DBA Data[Home] [Help]

PACKAGE: APPS.OKS_OKSCOBKS_XMLP_PKG

Source


1 PACKAGE OKS_OKSCOBKS_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: OKSCOBKSS.pls 120.2 2007/12/25 07:56:44 nchinnam noship $ */
3   P_ORG VARCHAR2(40);
4 
5   P_SALESREP NUMBER;
6 
7   P_DATE_FROM DATE;
8 
9   P_DATE_TO DATE;
10 
11   P_VALUE VARCHAR2(40);
12 
13   P_SALESREP_WHERE VARCHAR2(1000) := ' ';
14 
15   P_ORG_WHERE VARCHAR2(1000) := ' ';
16 
17   P_VALUE_WHERE VARCHAR2(1000) := ' ';
18 
19   P_ORDER_BY VARCHAR2(100);
20 
21   P_ORDER_BY_ORDER VARCHAR2(1000) := ' ';
22 
23   P_ORDER_BY_ORDER1 VARCHAR2(1000) := ' ';
24 
25   P_START_DATE_FROM DATE;
26 
27   P_START_DATE_TO DATE;
28 
29   P_CONTRACT_GROUP NUMBER;
30 
31   P_CONTRACT_GROUP_WHERE VARCHAR2(2000) := ' ';
32 
33   P_START_DATE_WHERE VARCHAR2(2000) := ' ';
34 
35   P_APPROVED_DATE_WHERE VARCHAR2(2000) := ' ';
36 
37   P_CONC_REQUEST_ID NUMBER;
38 
39   P_SALESREP_CHAR VARCHAR2(100);
40 
41   P_CONTRACT_GROUP_FROM VARCHAR2(2000) := ' ';
42 
43   FUNCTION BEFOREREPORT RETURN BOOLEAN;
44 
45   FUNCTION AFTERPFORM RETURN BOOLEAN;
46 
47   FUNCTION AFTERREPORT RETURN BOOLEAN;
48 
49 END OKS_OKSCOBKS_XMLP_PKG;
50