DBA Data[Home] [Help]

PACKAGE: APPS.AR_ARBRATBR_XMLP_PKG

Source


1 PACKAGE AR_ARBRATBR_XMLP_PKG AS
2 /* $Header: ARBRATBRS.pls 120.0 2007/12/27 13:17:10 abraghun noship $ */
3   P_VERSION VARCHAR2(32767);
4 
5   P_BATCH NUMBER;
6 
7   P_REQUEST_ID NUMBER;
8 
9   P_SET_OF_BOOKS_ID NUMBER;
10 
11   P_CONC_REQUEST_ID NUMBER;
12 
13   CP_SOB VARCHAR2(30);
14 
15   CP_PRECISION NUMBER;
16 
17   CP_FUNC_CURR VARCHAR2(20);
18 
19   CP_VERSION VARCHAR2(20);
20 
21   CP_REQUEST_ID NUMBER;
22 
23   CP_BATCH_NAME VARCHAR2(50);
24 
25   CP_BATCH_STATUS VARCHAR2(80);
26 
27   CP_DUE_DATE_LOW VARCHAR2(21);
28 
29   CP_DUE_DATE_HIGH VARCHAR2(21);
30 
31   CP_TRX_DATE_LOW VARCHAR2(21);
32 
33   CP_TRX_DATE_HIGH VARCHAR2(21);
34 
35   CP_TRX_NUMBER_LOW VARCHAR2(255);
36 
37   CP_TRX_NUMBER_HIGH VARCHAR2(255);
38 
39   CP_PAYMENT_METHOD VARCHAR2(30);
40 
41   CP_ISSUE_DATE VARCHAR2(21);
42 
43   CP_CUSTOMER_CLASS VARCHAR2(80);
44 
45   CP_CUSTOMER_CATEGORY VARCHAR2(80);
46 
47   CP_CUSTOMER_NAME VARCHAR2(50);
48 
49   CP_CUSTOMER_NUMBER VARCHAR2(30);
50 
51   CP_LOCATION VARCHAR2(40);
52 
53   CP_BANK_NAME VARCHAR2(80);
54 
55   CP_TRX_TYPE VARCHAR2(20);
56 
57   CP_CURRENCY_CODE VARCHAR2(15);
58 
59   CP_SOURCE VARCHAR2(50);
60 
61   FUNCTION CF_MATURITY_DATEFORMULA(MATURITY_DATE IN DATE) RETURN CHAR;
62 
63   FUNCTION CF_SYSDATEFORMULA RETURN CHAR;
64 
65   FUNCTION BEFOREREPORT RETURN BOOLEAN;
66 
67   FUNCTION AFTERREPORT RETURN BOOLEAN;
68 
69   FUNCTION CF_TRX_DATEFORMULA(TRX_DATE IN DATE) RETURN CHAR;
70 
71   FUNCTION CF_FUNC_AMT_ASSIGNEDFORMULA(EXCHANGE_RATE IN NUMBER
72                                       ,AMOUNT_ASSIGNED IN NUMBER) RETURN NUMBER;
73 
74   FUNCTION CF_REPORT_TITLEFORMULA RETURN CHAR;
75 
76   FUNCTION CF_DUE_DATE_LOWFORMULA RETURN CHAR;
77 
78   FUNCTION CF_DUE_DATE_HIGHFORMULA RETURN CHAR;
79 
80   FUNCTION CF_TRX_DATE_LOWFORMULA RETURN CHAR;
81 
82   FUNCTION CF_TRX_DATE_HIGHFORMULA RETURN CHAR;
83 
84   FUNCTION CF_ISSUE_DATEFORMULA RETURN CHAR;
85 
86   FUNCTION CP_SOB_P RETURN VARCHAR2;
87 
88   FUNCTION CP_PRECISION_P RETURN NUMBER;
89 
90   FUNCTION CP_FUNC_CURR_P RETURN VARCHAR2;
91 
92   FUNCTION CP_VERSION_P RETURN VARCHAR2;
93 
94   FUNCTION CP_REQUEST_ID_P RETURN NUMBER;
95 
96   FUNCTION CP_BATCH_NAME_P RETURN VARCHAR2;
97 
98   FUNCTION CP_BATCH_STATUS_P RETURN VARCHAR2;
99 
100   FUNCTION CP_DUE_DATE_LOW_P RETURN VARCHAR2;
101 
102   FUNCTION CP_DUE_DATE_HIGH_P RETURN VARCHAR2;
103 
104   FUNCTION CP_TRX_DATE_LOW_P RETURN VARCHAR2;
105 
106   FUNCTION CP_TRX_DATE_HIGH_P RETURN VARCHAR2;
107 
108   FUNCTION CP_TRX_NUMBER_LOW_P RETURN VARCHAR2;
109 
110   FUNCTION CP_TRX_NUMBER_HIGH_P RETURN VARCHAR2;
111 
112   FUNCTION CP_PAYMENT_METHOD_P RETURN VARCHAR2;
113 
114   FUNCTION CP_ISSUE_DATE_P RETURN VARCHAR2;
115 
116   FUNCTION CP_CUSTOMER_CLASS_P RETURN VARCHAR2;
117 
118   FUNCTION CP_CUSTOMER_CATEGORY_P RETURN VARCHAR2;
119 
120   FUNCTION CP_CUSTOMER_NAME_P RETURN VARCHAR2;
121 
122   FUNCTION CP_CUSTOMER_NUMBER_P RETURN VARCHAR2;
123 
124   FUNCTION CP_LOCATION_P RETURN VARCHAR2;
125 
126   FUNCTION CP_BANK_NAME_P RETURN VARCHAR2;
127 
128   FUNCTION CP_TRX_TYPE_P RETURN VARCHAR2;
129 
130   FUNCTION CP_CURRENCY_CODE_P RETURN VARCHAR2;
131 
132   FUNCTION CP_SOURCE_P RETURN VARCHAR2;
133 
134 END AR_ARBRATBR_XMLP_PKG;
135