[Home] [Help]
PACKAGE: APPS.JL_BR_AR_RET_INTERFACE_EXT_PKG
Source
1 PACKAGE JL_BR_AR_RET_INTERFACE_EXT_PKG AS
2 /*$Header: jlbrrcbs.pls 120.2 2005/02/23 23:28:11 vsidhart noship $*/
3 PROCEDURE Update_Row(X_Rowid VARCHAR2,
4 X_FILE_CONTROL VARCHAR2,
5 X_ENTRY_SEQUENTIAL_NUMBER NUMBER,
6 X_COMPANY_CODE NUMBER,
7 X_COMPANY_NAME VARCHAR2,
8 X_GENERATION_DATE DATE,
9 X_REMITTANCE_CODE NUMBER,
10 --X_BANK_NUMBER VARCHAR2,
11 X_BANK_PARTY_ID NUMBER,
12 X_BANK_OCCURRENCE_CODE NUMBER,
13 X_OCCURRENCE_DATE DATE,
14 X_PROCESSING_DATE DATE,
15 X_LAST_VALIDATION_DATE DATE,
16 X_INSCRIPTION_NUMBER NUMBER,
17 X_COMPANY_USE NUMBER,
18 X_OUR_NUMBER VARCHAR2,
19 X_PORTFOLIO_CODE NUMBER,
20 X_YOUR_NUMBER VARCHAR2,
21 X_DUE_DATE DATE,
22 X_TRADE_NOTE_AMOUNT NUMBER,
23 X_COLLECTOR_BANK_PARTY_ID NUMBER,
24 X_COLLECTOR_BRANCH_PARTY_ID NUMBER,
25 X_TRADE_NOTE_TYPE VARCHAR2,
26 X_BANK_CHARGE_AMOUNT NUMBER,
27 X_ABATEMENT_AMOUNT NUMBER,
28 X_DISCOUNT_AMOUNT NUMBER,
29 X_CREDIT_AMOUNT NUMBER,
30 X_INTEREST_AMOUNT_RECEIVED NUMBER,
31 X_CUSTOMER_NAME VARCHAR2,
32 X_RETURN_INFO VARCHAR2,
33 X_BANK_USE VARCHAR2,
34 X_ERROR_CODE VARCHAR2,
35 X_CANCELLATION_CODE VARCHAR2,
36 X_ORG_ID NUMBER,
37 X_LAST_UPDATE_DATE DATE,
38 X_LAST_UPDATED_BY NUMBER,
39 X_CREATION_DATE DATE,
40 X_CREATED_BY NUMBER,
41 X_LAST_UPDATE_LOGIN NUMBER,
42 X_CALLING_SEQUENCE IN VARCHAR2);
43 PROCEDURE Delete_Row(X_Rowid VARCHAR2,
44 X_CALLING_SEQUENCE IN VARCHAR2);
45 PROCEDURE Lock_Row(X_ROWID VARCHAR2,
46 X_FILE_CONTROL VARCHAR2,
47 X_ENTRY_SEQUENTIAL_NUMBER NUMBER,
48 X_COMPANY_CODE NUMBER DEFAULT NULL,
49 X_COMPANY_NAME VARCHAR2,
50 X_GENERATION_DATE DATE,
51 X_REMITTANCE_CODE NUMBER,
52 --X_BANK_NUMBER VARCHAR2,
53 X_BANK_PARTY_ID NUMBER,
54 X_BANK_OCCURRENCE_CODE NUMBER,
55 X_OCCURRENCE_DATE DATE,
56 X_PROCESSING_DATE DATE,
57 X_LAST_VALIDATION_DATE DATE,
58 X_INSCRIPTION_NUMBER NUMBER DEFAULT NULL,
59 X_COMPANY_USE NUMBER DEFAULT NULL,
60 X_OUR_NUMBER VARCHAR2 DEFAULT NULL,
61 X_PORTFOLIO_CODE NUMBER DEFAULT NULL,
62 X_YOUR_NUMBER VARCHAR2 DEFAULT NULL,
63 X_DUE_DATE DATE DEFAULT NULL,
64 X_TRADE_NOTE_AMOUNT NUMBER DEFAULT NULL,
65 X_COLLECTOR_BANK_PARTY_ID NUMBER DEFAULT NULL,
66 X_COLLECTOR_BRANCH_PARTY_ID NUMBER DEFAULT NULL,
67 X_TRADE_NOTE_TYPE VARCHAR2 DEFAULT NULL,
68 X_BANK_CHARGE_AMOUNT NUMBER DEFAULT NULL,
69 X_ABATEMENT_AMOUNT NUMBER DEFAULT NULL,
70 X_DISCOUNT_AMOUNT NUMBER DEFAULT NULL,
71 X_CREDIT_AMOUNT NUMBER DEFAULT NULL,
72 X_INTEREST_AMOUNT_RECEIVED NUMBER DEFAULT NULL,
73 X_CUSTOMER_NAME VARCHAR2 DEFAULT NULL,
74 X_RETURN_INFO VARCHAR2 DEFAULT NULL,
75 X_BANK_USE VARCHAR2 DEFAULT NULL,
76 X_ERROR_CODE VARCHAR2 DEFAULT NULL,
77 X_CANCELLATION_CODE VARCHAR2 DEFAULT NULL,
78 X_ORG_ID NUMBER DEFAULT NULL,
79 X_LAST_UPDATE_DATE DATE,
80 X_LAST_UPDATED_BY NUMBER,
81 X_CREATION_DATE DATE DEFAULT NULL,
82 X_CREATED_BY NUMBER DEFAULT NULL,
83 X_LAST_UPDATE_LOGIN NUMBER DEFAULT NULL,
84 X_CALLING_SEQUENCE IN VARCHAR2);
85 END JL_BR_AR_RET_INTERFACE_EXT_PKG;