[Home] [Help]
PACKAGE: APPS.AR_ARBRRMLT_XMLP_PKG
Source
1 PACKAGE AR_ARBRRMLT_XMLP_PKG 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