1 PACKAGE JL_BR_AR_BANK_RETURNS_PKG as
2 /* $Header: jlbrrems.pls 120.5 2003/09/15 21:51:46 vsidhart ship $ */
3
4 PROCEDURE Insert_Row(
5 X_rowid IN OUT NOCOPY VARCHAR2,
6 X_RETURN_ID NUMBER,
7 X_BANK_OCCURRENCE_CODE NUMBER,
8 X_OCCURRENCE_DATE DATE,
9 X_FILE_CONTROL VARCHAR2,
10 X_ENTRY_SEQUENTIAL_NUMBER NUMBER,
11 X_GENERATION_DATE DATE,
12 X_PROCESSING_DATE DATE,
13 X_DOCUMENT_ID NUMBER,
14 --X_BANK_NUMBER VARCHAR2,
15 X_BANK_PARTY_ID NUMBER,
16 X_BATCH_SOURCE_ID NUMBER,
17 X_OUR_NUMBER VARCHAR2,
18 X_TRADE_NOTE_NUMBER VARCHAR2,
19 X_DUE_DATE DATE,
20 X_TRADE_NOTE_AMOUNT NUMBER,
21 X_COLLECTOR_BANK_PARTY_ID NUMBER,
22 X_COLLECTOR_BRANCH_PARTY_ID NUMBER,
23 X_BANK_CHARGE_AMOUNT NUMBER,
24 X_ABATEMENT_AMOUNT NUMBER,
25 X_DISCOUNT_AMOUNT NUMBER,
26 X_CREDIT_AMOUNT NUMBER,
27 X_INTEREST_AMOUNT_RECEIVED NUMBER,
28 X_CUSTOMER_ID NUMBER,
29 X_RETURN_INFO VARCHAR2,
30 X_BANK_USE VARCHAR2,
31 X_COMPANY_USE NUMBER,
32 X_LAST_UPDATE_DATE DATE,
33 X_LAST_UPDATED_BY NUMBER,
34 X_CREATION_DATE DATE,
35 X_CREATED_BY NUMBER,
36 X_LAST_UPDATE_LOGIN NUMBER,
37 X_calling_sequence IN VARCHAR2,
38 X_ORG_ID NUMBER
39 );
40
41 PROCEDURE Lock_Row(
42 X_rowid VARCHAR2,
43 X_RETURN_ID NUMBER,
44 X_BANK_OCCURRENCE_CODE NUMBER,
45 X_OCCURRENCE_DATE DATE,
46 X_FILE_CONTROL VARCHAR2,
47 X_ENTRY_SEQUENTIAL_NUMBER NUMBER,
48 X_GENERATION_DATE DATE,
49 X_PROCESSING_DATE DATE,
50 X_DOCUMENT_ID NUMBER,
51 --X_BANK_NUMBER VARCHAR2,
52 X_BANK_PARTY_ID NUMBER,
53 X_BATCH_SOURCE_ID NUMBER,
54 X_OUR_NUMBER VARCHAR2,
55 X_TRADE_NOTE_NUMBER VARCHAR2,
56 X_DUE_DATE DATE,
57 X_TRADE_NOTE_AMOUNT NUMBER,
58 X_COLLECTOR_BANK_PARTY_ID NUMBER,
59 X_COLLECTOR_BRANCH_PARTY_ID NUMBER,
60 X_BANK_CHARGE_AMOUNT NUMBER,
61 X_ABATEMENT_AMOUNT NUMBER,
62 X_DISCOUNT_AMOUNT NUMBER,
63 X_CREDIT_AMOUNT NUMBER,
64 X_INTEREST_AMOUNT_RECEIVED NUMBER,
65 X_CUSTOMER_ID NUMBER,
66 X_RETURN_INFO VARCHAR2,
67 X_BANK_USE VARCHAR2,
68 X_COMPANY_USE NUMBER,
69 X_LAST_UPDATE_DATE DATE,
70 X_LAST_UPDATED_BY NUMBER,
71 X_CREATION_DATE DATE,
72 X_CREATED_BY NUMBER,
73 X_LAST_UPDATE_LOGIN NUMBER,
74 X_calling_sequence IN VARCHAR2
75 );
76
77 PROCEDURE Update_Row(
78 X_rowid VARCHAR2,
79 X_RETURN_ID NUMBER,
80 X_BANK_OCCURRENCE_CODE NUMBER,
81 X_OCCURRENCE_DATE DATE,
82 X_FILE_CONTROL VARCHAR2,
83 X_ENTRY_SEQUENTIAL_NUMBER NUMBER,
84 X_GENERATION_DATE DATE,
85 X_PROCESSING_DATE DATE,
86 X_DOCUMENT_ID NUMBER,
87 --X_BANK_NUMBER VARCHAR2,
88 X_BANK_PARTY_ID NUMBER,
89 X_BATCH_SOURCE_ID NUMBER,
90 X_OUR_NUMBER VARCHAR2,
91 X_TRADE_NOTE_NUMBER VARCHAR2,
92 X_DUE_DATE DATE,
93 X_TRADE_NOTE_AMOUNT NUMBER,
94 X_COLLECTOR_BANK_PARTY_ID NUMBER,
95 X_COLLECTOR_BRANCH_PARTY_ID NUMBER,
96 X_BANK_CHARGE_AMOUNT NUMBER,
97 X_ABATEMENT_AMOUNT NUMBER,
98 X_DISCOUNT_AMOUNT NUMBER,
99 X_CREDIT_AMOUNT NUMBER,
100 X_INTEREST_AMOUNT_RECEIVED NUMBER,
101 X_CUSTOMER_ID NUMBER,
102 X_RETURN_INFO VARCHAR2,
103 X_BANK_USE VARCHAR2,
104 X_COMPANY_USE NUMBER,
105 X_LAST_UPDATE_DATE DATE,
106 X_LAST_UPDATED_BY NUMBER,
107 X_CREATION_DATE DATE,
108 X_CREATED_BY NUMBER,
109 X_LAST_UPDATE_LOGIN NUMBER,
110 X_calling_sequence IN VARCHAR2
111 );
112
113 PROCEDURE Delete_Row(
114 X_rowid VARCHAR2
115 );
116 END JL_BR_AR_BANK_RETURNS_PKG;
|
|
|