PACKAGE: APPS.JL_JLBRRCAD_XMLP_PKG

Source

1 PACKAGE JL_JLBRRCAD_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: JLBRRCADS.pls 120.1 2007/12/25 16:41:44 dwkrishn noship $ */
3   P_CONC_REQUEST_ID NUMBER;
4 
5   P_END_OF_REPORT VARCHAR2(21);
6 
7   P_NO_DATA_FOUND VARCHAR2(21);
8 
9   P_INVOICE_NUMBER_LOW VARCHAR2(30);
10 
11   P_INVOICE_NUMBER_HIGH VARCHAR2(30);
12 
13   P_CUSTOMER_NUMBER_LOW VARCHAR2(30);
14 
15   P_CUSTOMER_NUMBER_HIGH VARCHAR2(30);
16 
17   P_CUSTOMER_NAME_LOW VARCHAR2(50);
18 
19   P_CUSTOMER_NAME_HIGH VARCHAR2(50);
20 
21   H_DAYS_LATE NUMBER;
22 
23   C_CHART_OF_ACCOUNTS_ID VARCHAR2(40) := '0';
24 
25   C_BASE_CURRENCY_CODE VARCHAR2(15);
26 
27   C_BASE_PRECISION NUMBER;
28 
29   C_BASE_MIN_ACCT_UNIT NUMBER;
30 
31   C_BASE_DESCRIPTION VARCHAR2(240);
32 
33   C_ORGANISATION_NAME VARCHAR2(30);
34 
35   C_NAME VARCHAR2(80);
36 
37   H_CALENDAR VARCHAR2(30);
38 
39   H_NONWORKDAY VARCHAR2(30);
40 
41   C_START_INV_NUMBER_PREDICATE VARCHAR2(300);
42 
43   C_END_INV_NUMBER_PREDICATE VARCHAR2(300);
44 
45   C_START_CUST_NUMBER_PREDICATE VARCHAR2(300);
46 
47   C_END_CUST_NUMBER_PREDICATE VARCHAR2(300);
48 
49   C_START_CUST_NAME_PREDICATE VARCHAR2(300);
50 
51   C_END_CUST_NAME_PREDICATE VARCHAR2(300);
52 
53   FUNCTION AFTERREPORT RETURN BOOLEAN;
54 
55   FUNCTION BEFOREREPORT RETURN BOOLEAN;
56 
57   PROCEDURE GET_BASE_CURR_DATA;
58 
59   PROCEDURE RAISE_ERR(ERRNO IN VARCHAR2
60                      ,MSGNAME IN VARCHAR2);
61 
62   PROCEDURE RAISE_ORA_ERR(ERRNO IN VARCHAR2);
63 
64   PROCEDURE GET_COMPANY_NAME;
65 
66   FUNCTION SET_P_WHERE RETURN BOOLEAN;
67 
68   FUNCTION CF_INT_CALFORMULA(C_CUSTOMER_TRX_ID IN NUMBER
69                             ,C_DUE_DATE IN DATE
70                             ,C_BALANCE_DUE IN NUMBER
71                             ,C_PAYMENT_SCHEDULE_ID IN NUMBER) RETURN NUMBER;
72 
73   FUNCTION C_BEARER_OF_TRADE_NOTEFORMULA(C_GLOBAL_ATTRIBUTE9 IN VARCHAR2) RETURN VARCHAR2;
74 
75   FUNCTION C_DOCUMENT_STATUSFORMULA(SELECTED_FOR_RECEIPT_BATCH_ID IN NUMBER
76                                    ,C_PAYMENT_SCHEDULE_ID IN NUMBER) RETURN VARCHAR2;
77 
78   FUNCTION C_BORDERO_NUMBERFORMULA(SELECTED_FOR_RECEIPT_BATCH_ID IN NUMBER
79                                   ,C_PAYMENT_SCHEDULE_ID IN NUMBER) RETURN NUMBER;
80 
81   FUNCTION C_SELECTION_NUMBERFORMULA(SELECTED_FOR_RECEIPT_BATCH_ID IN NUMBER
82                                     ,C_PAYMENT_SCHEDULE_ID IN NUMBER) RETURN NUMBER;
83 
84   FUNCTION CF_STATUS_MEANINGFORMULA(C_STATUS IN VARCHAR2) RETURN VARCHAR2;
85 
86   FUNCTION CF_CLASS_MEANINGFORMULA(C_CLASS IN VARCHAR2) RETURN VARCHAR2;
87 
88   FUNCTION H_DAYS_LATE_P RETURN NUMBER;
89 
90   FUNCTION C_CHART_OF_ACCOUNTS_ID_P RETURN VARCHAR2;
91 
92   FUNCTION C_BASE_CURRENCY_CODE_P RETURN VARCHAR2;
93 
94   FUNCTION C_BASE_PRECISION_P RETURN NUMBER;
95 
96   FUNCTION C_BASE_MIN_ACCT_UNIT_P RETURN NUMBER;
97 
98   FUNCTION C_BASE_DESCRIPTION_P RETURN VARCHAR2;
99 
100   FUNCTION C_ORGANISATION_NAME_P RETURN VARCHAR2;
101 
102   FUNCTION C_NAME_P RETURN VARCHAR2;
103 
104   FUNCTION H_CALENDAR_P RETURN VARCHAR2;
105 
106   FUNCTION H_NONWORKDAY_P RETURN VARCHAR2;
107 
108   FUNCTION C_START_INV_NUMBER_PREDICATE_P RETURN VARCHAR2;
109 
110   FUNCTION C_END_INV_NUMBER_PREDICATE_P RETURN VARCHAR2;
111 
112   FUNCTION C_START_CUST_NUMBER_PREDIC_p RETURN VARCHAR2;
113 
114   FUNCTION C_END_CUST_NUMBER_PREDICATE_P RETURN VARCHAR2;
115 
116   FUNCTION C_START_CUST_NAME_PREDICATE_P RETURN VARCHAR2;
117 
118   FUNCTION C_END_CUST_NAME_PREDICATE_P RETURN VARCHAR2;
119 
120   PROCEDURE SET_NAME(APPLICATION IN VARCHAR2
121                     ,NAME IN VARCHAR2);
122 
123   PROCEDURE SET_TOKEN(TOKEN IN VARCHAR2
124                      ,VALUE IN VARCHAR2
125                      ,TRANSLATE IN BOOLEAN);
126 
127   PROCEDURE RETRIEVE(MSGOUT OUT NOCOPY VARCHAR2);
128 
129   PROCEDURE CLEAR;
130 
131   FUNCTION GET_STRING(APPIN IN VARCHAR2
132                      ,NAMEIN IN VARCHAR2) RETURN VARCHAR2;
133 
134   FUNCTION GET RETURN VARCHAR2;
135 
136   FUNCTION GET_ENCODED RETURN VARCHAR2;
137 
138   PROCEDURE PARSE_ENCODED(ENCODED_MESSAGE IN VARCHAR2
139                          ,APP_SHORT_NAME OUT NOCOPY VARCHAR2
140                          ,MESSAGE_NAME OUT NOCOPY VARCHAR2);
141 
142   PROCEDURE SET_ENCODED(ENCODED_MESSAGE IN VARCHAR2);
143 
144   PROCEDURE RAISE_ERROR;
145 
146   PROCEDURE JL_BR_INTEREST(X_INTEREST_TYPE IN VARCHAR2
147                           ,X_INTEREST_RATE_AMOUNT IN NUMBER
148                           ,X_PERIOD_DAYS IN NUMBER
149                           ,X_INTEREST_FORMULA IN VARCHAR2
150                           ,X_GRACE_DAYS IN NUMBER
151                           ,X_PENALTY_TYPE IN VARCHAR2
152                           ,X_PENALTY_RATE_AMOUNT IN NUMBER
153                           ,X_DUE_DATE IN DATE
154                           ,X_PAYMENT_DATE IN DATE
155                           ,X_INVOICE_AMOUNT IN NUMBER
156                           ,X_JLBR_CALENDAR IN VARCHAR2
157                           ,X_JLBR_LOCAL_HOLIDAY IN VARCHAR2
158                           ,X_JLBR_ACTION_NON_WORKDAY IN VARCHAR2
159                           ,X_INTEREST_CALCULATED IN OUT NOCOPY NUMBER
160                           ,X_DAYS_LATE IN OUT NOCOPY NUMBER
161                           ,X_EXIT_CODE OUT NOCOPY NUMBER);
162 
163 END JL_JLBRRCAD_XMLP_PKG;
164 
165 
166