[Home] [Help]
PACKAGE: APPS.JL_BR_AR_REC_MET_ACCTS_EXT_PKG
Source
1 PACKAGE JL_BR_AR_REC_MET_ACCTS_EXT_PKG as
2 /* $Header: jlbrrdps.pls 120.7 2005/06/22 04:19:56 appradha ship $ */
3
4
5 PROCEDURE Insert_Row( X_Rowid IN OUT NOCOPY VARCHAR2,
6
7 X_BANK_ACCT_USE_ID NUMBER,
8 X_RECEIPT_METHOD_ID NUMBER,
9 X_BANK_CHARGES_CCID NUMBER DEFAULT NULL,
10 X_COLL_ENDORSEMENT_CCID NUMBER DEFAULT NULL,
11 X_BILLS_COLLECTION_CCID NUMBER DEFAULT NULL,
12 X_OTHER_CREDITS_CCID NUMBER DEFAULT NULL,
13 X_FACTORING_DOCS_CCID NUMBER DEFAULT NULL,
14 X_BILLS_DISCOUNT_CCID NUMBER DEFAULT NULL,
15 X_DISC_ENDORSEMENT_CCID NUMBER DEFAULT NULL,
16 X_FACTORING_CHARGES_CCID NUMBER DEFAULT NULL,
17 X_DISCOUNTED_BILLS_CCID NUMBER DEFAULT NULL,
18 X_PORTFOLIO_CODE NUMBER DEFAULT NULL,
19 X_MIN_DOCUMENT_AMOUNT NUMBER DEFAULT NULL,
20 X_MAX_DOCUMENT_AMOUNT NUMBER DEFAULT NULL,
21 X_MIN_REMITTANCE_AMOUNT NUMBER DEFAULT NULL,
22 X_MAX_REMITTANCE_AMOUNT NUMBER DEFAULT NULL,
23 X_BANK_INSTRUCTION_CODE1 NUMBER DEFAULT NULL,
24 X_BANK_INSTRUCTION_CODE2 NUMBER DEFAULT NULL,
25 X_BANK_CHARGE_AMOUNT NUMBER DEFAULT NULL,
26 X_FACTORING_RATE NUMBER DEFAULT NULL,
27 X_FACTORING_RATE_PERIOD NUMBER DEFAULT NULL,
28 X_BATCH_SOURCE_ID NUMBER DEFAULT NULL,
29 X_CALCULATED_INTEREST_CCID NUMBER DEFAULT NULL,
30 X_INTEREST_WRITEOFF_CCID NUMBER DEFAULT NULL,
31 X_FACTORING_INTEREST_CCID NUMBER DEFAULT NULL,
32 X_ABATEMENT_WRITEOFF_CCID NUMBER DEFAULT NULL,
33 X_ABATEMENT_REVENUE_CCID NUMBER DEFAULT NULL,
34 X_INTEREST_REVENUE_CCID NUMBER DEFAULT NULL,
35 X_CALC_INTEREST_RECTRX_ID NUMBER DEFAULT NULL,
36 X_INTEREST_WRITEOFF_RECTRX_ID NUMBER DEFAULT NULL,
37 X_INTEREST_REVENUE_RECTRX_ID NUMBER DEFAULT NULL,
38 X_ABATEMENT_WRITEOFF_RECTRX_ID NUMBER DEFAULT NULL,
39 X_ABATEMENT_REVENUE_RECTRX_ID NUMBER DEFAULT NULL,
40 X_WRITEOFF_PERC_TOLERANCE NUMBER DEFAULT NULL,
41 X_WRITEOFF_AMOUNT_TOLERANCE NUMBER DEFAULT NULL,
42 X_GL_DATE_BANK_RETURN VARCHAR2 DEFAULT NULL,
43 X_FLOATING NUMBER DEFAULT NULL,
44 X_LAST_UPDATE_DATE DATE,
45 X_LAST_UPDATED_BY NUMBER,
46 X_CREATION_DATE DATE,
47 X_CREATED_BY NUMBER,
48 X_LAST_UPDATE_LOGIN NUMBER,
49 X_COLL_REMITTANCE_MEDIA VARCHAR2,
50 X_COLL_FORMAT_PGM_ID NUMBER,
51 X_FACTOR_REMITTANCE_MEDIA VARCHAR2,
52 X_FACTOR_FORMAT_PGM_ID NUMBER,
53 X_OCC_REP_FORMAT_PGM_ID NUMBER,
54 X_OCC_FILE_FORMAT_PGM_ID NUMBER,
55 X_MAX_COLLECTION_DOCS NUMBER,
56 X_calling_sequence VARCHAR2,
57 X_ORG_ID NUMBER
58 );
59
60
61 PROCEDURE Lock_Row( X_Rowid VARCHAR2,
62
63 X_BANK_ACCT_USE_ID NUMBER,
64 X_RECEIPT_METHOD_ID NUMBER,
65 X_BANK_CHARGES_CCID NUMBER DEFAULT NULL,
66 X_COLL_ENDORSEMENT_CCID NUMBER DEFAULT NULL,
67 X_BILLS_COLLECTION_CCID NUMBER DEFAULT NULL,
68 X_OTHER_CREDITS_CCID NUMBER DEFAULT NULL,
69 X_FACTORING_DOCS_CCID NUMBER DEFAULT NULL,
70 X_BILLS_DISCOUNT_CCID NUMBER DEFAULT NULL,
71 X_DISC_ENDORSEMENT_CCID NUMBER DEFAULT NULL,
72 X_FACTORING_CHARGES_CCID NUMBER DEFAULT NULL,
73 X_DISCOUNTED_BILLS_CCID NUMBER DEFAULT NULL,
74 X_PORTFOLIO_CODE NUMBER DEFAULT NULL,
75 X_MIN_DOCUMENT_AMOUNT NUMBER DEFAULT NULL,
76 X_MAX_DOCUMENT_AMOUNT NUMBER DEFAULT NULL,
77 X_MIN_REMITTANCE_AMOUNT NUMBER DEFAULT NULL,
78 X_MAX_REMITTANCE_AMOUNT NUMBER DEFAULT NULL,
79 X_BANK_INSTRUCTION_CODE1 NUMBER DEFAULT NULL,
80 X_BANK_INSTRUCTION_CODE2 NUMBER DEFAULT NULL,
81 X_BANK_CHARGE_AMOUNT NUMBER DEFAULT NULL,
82 X_FACTORING_RATE NUMBER DEFAULT NULL,
83 X_FACTORING_RATE_PERIOD NUMBER DEFAULT NULL,
84 X_BATCH_SOURCE_ID NUMBER DEFAULT NULL,
85 X_CALCULATED_INTEREST_CCID NUMBER DEFAULT NULL,
86 X_INTEREST_WRITEOFF_CCID NUMBER DEFAULT NULL,
87 X_FACTORING_INTEREST_CCID NUMBER DEFAULT NULL,
88 X_ABATEMENT_WRITEOFF_CCID NUMBER DEFAULT NULL,
89 X_ABATEMENT_REVENUE_CCID NUMBER DEFAULT NULL,
90 X_INTEREST_REVENUE_CCID NUMBER DEFAULT NULL,
91 X_CALC_INTEREST_RECTRX_ID NUMBER DEFAULT NULL,
92 X_INTEREST_WRITEOFF_RECTRX_ID NUMBER DEFAULT NULL,
93 X_INTEREST_REVENUE_RECTRX_ID NUMBER DEFAULT NULL,
94 X_ABATEMENT_WRITEOFF_RECTRX_ID NUMBER DEFAULT NULL,
95 X_ABATEMENT_REVENUE_RECTRX_ID NUMBER DEFAULT NULL,
96 X_WRITEOFF_PERC_TOLERANCE NUMBER DEFAULT NULL,
97 X_WRITEOFF_AMOUNT_TOLERANCE NUMBER DEFAULT NULL,
98 X_GL_DATE_BANK_RETURN VARCHAR2 DEFAULT NULL,
99 X_FLOATING NUMBER DEFAULT NULL,
100 X_LAST_UPDATE_DATE DATE,
101 X_LAST_UPDATED_BY NUMBER,
102 X_CREATION_DATE DATE,
103 X_CREATED_BY NUMBER,
104 X_LAST_UPDATE_LOGIN NUMBER,
105 X_COLL_REMITTANCE_MEDIA VARCHAR2,
106 X_COLL_FORMAT_PGM_ID NUMBER,
107 X_FACTOR_REMITTANCE_MEDIA VARCHAR2,
108 X_FACTOR_FORMAT_PGM_ID NUMBER,
109 X_OCC_REP_FORMAT_PGM_ID NUMBER,
110 X_OCC_FILE_FORMAT_PGM_ID NUMBER,
111 X_MAX_COLLECTION_DOCS NUMBER,
112 X_calling_sequence VARCHAR2
113 );
114
115
116 PROCEDURE Update_Row( X_Rowid VARCHAR2,
117
118 X_BANK_ACCT_USE_ID NUMBER,
119 X_RECEIPT_METHOD_ID NUMBER,
120 X_BANK_CHARGES_CCID NUMBER DEFAULT NULL,
121 X_COLL_ENDORSEMENT_CCID NUMBER DEFAULT NULL,
122 X_BILLS_COLLECTION_CCID NUMBER DEFAULT NULL,
123 X_OTHER_CREDITS_CCID NUMBER DEFAULT NULL,
124 X_FACTORING_DOCS_CCID NUMBER DEFAULT NULL,
125 X_BILLS_DISCOUNT_CCID NUMBER DEFAULT NULL,
126 X_DISC_ENDORSEMENT_CCID NUMBER DEFAULT NULL,
127 X_FACTORING_CHARGES_CCID NUMBER DEFAULT NULL,
128 X_DISCOUNTED_BILLS_CCID NUMBER DEFAULT NULL,
129 X_PORTFOLIO_CODE NUMBER DEFAULT NULL,
130 X_MIN_DOCUMENT_AMOUNT NUMBER DEFAULT NULL,
131 X_MAX_DOCUMENT_AMOUNT NUMBER DEFAULT NULL,
132 X_MIN_REMITTANCE_AMOUNT NUMBER DEFAULT NULL,
133 X_MAX_REMITTANCE_AMOUNT NUMBER DEFAULT NULL,
134 X_BANK_INSTRUCTION_CODE1 NUMBER DEFAULT NULL,
135 X_BANK_INSTRUCTION_CODE2 NUMBER DEFAULT NULL,
136 X_BANK_CHARGE_AMOUNT NUMBER DEFAULT NULL,
137 X_FACTORING_RATE NUMBER DEFAULT NULL,
138 X_FACTORING_RATE_PERIOD NUMBER DEFAULT NULL,
139 X_BATCH_SOURCE_ID NUMBER DEFAULT NULL,
140 X_CALCULATED_INTEREST_CCID NUMBER DEFAULT NULL,
141 X_INTEREST_WRITEOFF_CCID NUMBER DEFAULT NULL,
142 X_FACTORING_INTEREST_CCID NUMBER DEFAULT NULL,
143 X_ABATEMENT_WRITEOFF_CCID NUMBER DEFAULT NULL,
144 X_ABATEMENT_REVENUE_CCID NUMBER DEFAULT NULL,
145 X_INTEREST_REVENUE_CCID NUMBER DEFAULT NULL,
146 X_CALC_INTEREST_RECTRX_ID NUMBER DEFAULT NULL,
147 X_INTEREST_WRITEOFF_RECTRX_ID NUMBER DEFAULT NULL,
148 X_INTEREST_REVENUE_RECTRX_ID NUMBER DEFAULT NULL,
149 X_ABATEMENT_WRITEOFF_RECTRX_ID NUMBER DEFAULT NULL,
150 X_ABATEMENT_REVENUE_RECTRX_ID NUMBER DEFAULT NULL,
151 X_WRITEOFF_PERC_TOLERANCE NUMBER DEFAULT NULL,
152 X_WRITEOFF_AMOUNT_TOLERANCE NUMBER DEFAULT NULL,
153 X_GL_DATE_BANK_RETURN VARCHAR2 DEFAULT NULL,
154 X_FLOATING NUMBER DEFAULT NULL,
155 X_LAST_UPDATE_DATE DATE,
156 X_LAST_UPDATED_BY NUMBER,
157 X_CREATION_DATE DATE,
158 X_CREATED_BY NUMBER,
159 X_LAST_UPDATE_LOGIN NUMBER,
160 X_COLL_REMITTANCE_MEDIA VARCHAR2,
161 X_COLL_FORMAT_PGM_ID NUMBER,
162 X_FACTOR_REMITTANCE_MEDIA VARCHAR2,
163 X_FACTOR_FORMAT_PGM_ID NUMBER,
164 X_OCC_REP_FORMAT_PGM_ID NUMBER,
165 X_OCC_FILE_FORMAT_PGM_ID NUMBER,
166 X_MAX_COLLECTION_DOCS NUMBER,
167 X_calling_sequence VARCHAR2
168 );
169
170
171 PROCEDURE Delete_Row( X_Rowid VARCHAR2,
172 X_calling_sequence VARCHAR2
173 );
174
175 END JL_BR_AR_REC_MET_ACCTS_EXT_PKG;