PACKAGE: APPS.AR_ARBRRMLT_XMLP_PKG

Source

1 PACKAGE AR_ARBRRMLT_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: ARBRRMLTS.pls 120.0 2007/12/27 13:18:57 abraghun noship $ */
3   P_CONC_REQUEST_ID NUMBER := 0;
4 
5   P_CREATION_DATE_FROM DATE;
6   LP_CREATION_DATE_FROM DATE;
7 
8   P_CREATION_DATE_TO DATE;
9   LP_CREATION_DATE_TO DATE;
10 
11   P_DRAWEE_NAME_FROM VARCHAR2(40);
12   LP_DRAWEE_NAME_FROM VARCHAR2(40);
13 
14   P_DRAWEE_NAME_TO VARCHAR2(40);
15   LP_DRAWEE_NAME_TO VARCHAR2(40);
16 
17   P_DRAWEE_NUMBER_FROM NUMBER;
18   LP_DRAWEE_NUMBER_FROM NUMBER;
19 
20   P_DRAWEE_NUMBER_TO NUMBER;
21   LP_DRAWEE_NUMBER_TO NUMBER;
22 
23   P_DAYS_LATE_SINCE_CREATION NUMBER;
24 
25   LP_CUSTOMER_RANGE VARCHAR2(240) := ' AND 1 = 1';
26 
27   LP_CUSTOMER_NUMBER_RANGE VARCHAR2(100) := ' AND 1 = 1';
28 
29   LP_CREATION_DATE_RANGE VARCHAR2(240) := ' AND 1 = 1';
30 
31   LP_CREATION_DATE VARCHAR2(40) := ' AND 1 = 1';
32 
33   P_SET_OF_BOOKS_ID NUMBER;
34 
35   LP_DAYS_LATE_SINCE_CREATION VARCHAR2(240);
36 
37   P_PRINT_HOME_COUNTRY_FLAG VARCHAR2(40);
38 
39   P_DEFAULT_COUNTRY VARCHAR2(60);
40 
41   P_DEFAULT_COUNTRY_DESCRIPTION VARCHAR2(80);
42 
43   C_OUR_STREET VARCHAR2(60);
44 
45   C_OUR_ZIPCITY VARCHAR2(90);
46 
47   C_LISTNUM NUMBER;
48 
49   C_OUR_SOB_NAME VARCHAR2(40);
50 
51   C_LOCATION VARCHAR2(50);
52 
53   FUNCTION BEFOREREPORT RETURN BOOLEAN;
54 
55   FUNCTION AFTERREPORT RETURN BOOLEAN;
56 
57   FUNCTION CF_CURRENT_DATEFORMULA RETURN CHAR;
58 
59   FUNCTION CF_BR_DATEFORMULA(BR_DATE IN DATE) RETURN CHAR;
60 
61   FUNCTION AFTERPFORM RETURN BOOLEAN;
62 
63   FUNCTION GET_COUNTRY_DESCRIPTION(COUNTRY_CODE IN VARCHAR2) RETURN VARCHAR2;
64 
65   FUNCTION CUSTOMER_ADDRESS_STRINGFORMULA(CUST_NAME IN VARCHAR2
66                                          ,CUST_ADDRESS1 IN VARCHAR2
67                                          ,CUST_ADDRESS2 IN VARCHAR2
68                                          ,CUST_ADDRESS3 IN VARCHAR2
69                                          ,CUST_ADDRESS4 IN VARCHAR2
70                                          ,CUST_CITY IN VARCHAR2
71                                          ,CUST_STATE IN VARCHAR2
72                                          ,CUST_POSTAL_CODE IN VARCHAR2
73                                          ,CUST_COUNTRY IN VARCHAR2) RETURN VARCHAR2;
74 
75   FUNCTION C_OUR_STREET_P RETURN VARCHAR2;
76 
77   FUNCTION C_OUR_ZIPCITY_P RETURN VARCHAR2;
78 
79   FUNCTION C_LISTNUM_P RETURN NUMBER;
80 
81   FUNCTION C_OUR_SOB_NAME_P RETURN VARCHAR2;
82 
83   FUNCTION C_LOCATION_P RETURN VARCHAR2;
84 
85 END AR_ARBRRMLT_XMLP_PKG;
86