DBA Data[Home] [Help]

PACKAGE: APPS.ONT_OEXAUCRC_XMLP_PKG

Source


1 PACKAGE ONT_OEXAUCRC_XMLP_PKG AS
2 /* $Header: OEXAUCRCS.pls 120.1 2007/12/25 07:07:49 npannamp noship $ */
3   P_ORDER_BY VARCHAR2(50);
4 
5   P_HEADER_ID NUMBER;
6 
7   P_PARTY_NAME_LOW VARCHAR2(50);
8 
9   P_PARTY_NAME_HIGH VARCHAR2(50);
10 
11   P_ORG_ID NUMBER;
12 
13   P_CUST_PROF_CLASS_LOW VARCHAR2(30);
14 
15   P_CUST_PROF_CLASS_HIGH VARCHAR2(30);
16 
17   P_CUST_ACCT_NUMBER_LOW VARCHAR2(30);
18 
19   P_CUST_ACCT_NUMBER_HIGH VARCHAR2(30);
20 
21   P_ORDER_DATE_LOW DATE;
22 
23   LP_ORDER_DATE_LOW varchar2(30);
24 
25   P_ORDER_DATE_HIGH DATE;
26 
27   LP_ORDER_DATE_HIGH varchar2(30);
28 
29   P_CONC_REQUEST_ID NUMBER;
30 
31   RP_REPORT_NAME VARCHAR2(100) := 'Credit Check Processor Report';
32 
33   RP_DATA_FOUND VARCHAR2(300);
34 
35   RP_ORDER_TYPE VARCHAR2(30);
36 
37   RP_ORDER_BY VARCHAR2(80);
38 
39   RP_OPERATING_UNIT VARCHAR2(240);
40 
41   RP_ORDER_NUMBER NUMBER;
42 
43   FUNCTION BEFOREREPORT RETURN BOOLEAN;
44 
45   FUNCTION AFTERREPORT RETURN BOOLEAN;
46 
47   FUNCTION RP_REPORT_NAME_P RETURN VARCHAR2;
48 
49   FUNCTION RP_DATA_FOUND_P RETURN VARCHAR2;
50 
51   FUNCTION RP_ORDER_TYPE_P RETURN VARCHAR2;
52 
53   FUNCTION RP_ORDER_BY_P RETURN VARCHAR2;
54 
55   FUNCTION RP_OPERATING_UNIT_P RETURN VARCHAR2;
56 
57   FUNCTION RP_ORDER_NUMBER_P RETURN NUMBER;
58 
59 END ONT_OEXAUCRC_XMLP_PKG;
60