[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