PACKAGE: APPS.CE_PAYMENT_TRXN_PKG

Source

1 PACKAGE CE_PAYMENT_TRXN_PKG as
2 /* $Header: cebtpths.pls 120.0 2005/07/26 08:42:23 jikumar noship $ */
3 
4 
5   G_spec_revision 	VARCHAR2(1000) := '$Revision: 120.0 $';
6 
7   FUNCTION spec_revision RETURN VARCHAR2;
8 
9   FUNCTION body_revision RETURN VARCHAR2;
10 
11 PROCEDURE INSERT_ROW (
12 			X_ROWID						IN OUT NOCOPY VARCHAR2,
13 			X_TRXN_REFERENCE_NUMBER		IN OUT NOCOPY NUMBER,
14 			X_SETTLE_BY_SYSTEM_FLAG		VARCHAR2,
15 			X_TRANSACTION_TYPE			VARCHAR2,
16 			X_TRXN_SUBTYPE_CODE_ID		NUMBER,
17 			X_TRANSACTION_DATE			DATE,
18 			X_ANTICIPATED_VALUE_DATE	DATE,
19 			X_TRANSACTION_DESCRIPTION	VARCHAR2,
20 			X_PAYMENT_CURRENCY_CODE		VARCHAR2,
21 			X_PAYMENT_AMOUNT			NUMBER,
22 			X_SOURCE_PARTY_ID			NUMBER,
23 			X_SOURCE_LEGAL_ENTITY_ID	NUMBER,
24 			X_SOURCE_BANK_ACCOUNT_ID	NUMBER,
25 			X_DEST_PARTY_ID				NUMBER,
26 			X_DEST_LEGAL_ENTITY_ID		NUMBER,
27 			X_DEST_BANK_ACCOUNT_ID		NUMBER,
28 			X_DEST_PARTY_SITE_ID		NUMBER,
29 			X_REPETITIVE_PAYMENT_CODE	VARCHAR2,
30 			X_TRXN_STATUS_CODE			VARCHAR2,
31 			X_PAYMENT_METHOD_CODE		VARCHAR2,
32 			X_AUTHORIZE_FLAG			VARCHAR2,
33 			X_BANK_CHARGE_BEARER		VARCHAR2,
34 			X_PAYMENT_REASON_CODE		VARCHAR2,
35 			X_PAYMENT_REASON_COMMENTS	VARCHAR2,
36 			X_REMITTANCE_MESSAGE1		VARCHAR2,
37 			X_REMITTANCE_MESSAGE2		VARCHAR2,
38 			X_REMITTANCE_MESSAGE3		VARCHAR2,
39 			X_CREATED_FROM_DIR			VARCHAR2,
40 			X_CREATE_FROM_STMTLINE_ID	NUMBER,
41 			X_BANK_TRXN_NUMBER			VARCHAR2,
42 			X_PAYMENT_REQUEST_NUMBER	NUMBER,
43 			X_PAPER_DOCUMENT_NUMBER		NUMBER,
44 			X_DOC_SEQUENCE_ID			NUMBER,
45 			X_DOC_SEQUENCE_VALUE		NUMBER,
46 			X_DOC_CATEGORY_CODE			VARCHAR2,
47 			X_PAYMENT_OFFSET_CCID		NUMBER,
48 			X_RECEIPT_OFFSET_CCID		NUMBER,
49 			X_CASHPOOL_ID				NUMBER,
50 			X_EXT_BANK_ACCOUNT_ID		NUMBER,
51 			X_ATTRIBUTE_CATEGORY		VARCHAR2,
52 			X_ATTRIBUTE1				VARCHAR2,
53 			X_ATTRIBUTE2				VARCHAR2,
54 			X_ATTRIBUTE3				VARCHAR2,
55 			X_ATTRIBUTE4				VARCHAR2,
56 			X_ATTRIBUTE5				VARCHAR2,
57 			X_ATTRIBUTE6				VARCHAR2,
58 			X_ATTRIBUTE7				VARCHAR2,
59 			X_ATTRIBUTE8				VARCHAR2,
60 			X_ATTRIBUTE9				VARCHAR2,
61 			X_ATTRIBUTE10				VARCHAR2,
62 			X_ATTRIBUTE11				VARCHAR2,
63 			X_ATTRIBUTE12				VARCHAR2,
64 			X_ATTRIBUTE13				VARCHAR2,
65 			X_ATTRIBUTE14				VARCHAR2,
66 			X_ATTRIBUTE15				VARCHAR2,
67 			X_CREATED_BY				NUMBER,
68 			X_CREATION_DATE				DATE,
69 			X_LAST_UPDATED_BY			NUMBER,
70 			X_LAST_UPDATE_DATE			DATE,
71 			X_LAST_UPDATE_LOGIN			NUMBER
72 			 );
73 
74 
75 
76 PROCEDURE UPDATE_ROW (
77 			X_ROWID						VARCHAR2,
78 			X_TRXN_REFERENCE_NUMBER		NUMBER,
79 			X_SETTLE_BY_SYSTEM_FLAG		VARCHAR2,
80 			X_TRANSACTION_TYPE			VARCHAR2,
81 			X_TRXN_SUBTYPE_CODE_ID		NUMBER,
82 			X_TRANSACTION_DATE			DATE,
83 			X_ANTICIPATED_VALUE_DATE	DATE,
84 			X_TRANSACTION_DESCRIPTION	VARCHAR2,
85 			X_PAYMENT_CURRENCY_CODE		VARCHAR2,
86 			X_PAYMENT_AMOUNT			NUMBER,
87 			X_SOURCE_PARTY_ID			NUMBER,
88 			X_SOURCE_LEGAL_ENTITY_ID	NUMBER,
89 			X_SOURCE_BANK_ACCOUNT_ID	NUMBER,
90 			X_DEST_PARTY_ID				NUMBER,
91 			X_DEST_LEGAL_ENTITY_ID		NUMBER,
92 			X_DEST_BANK_ACCOUNT_ID		NUMBER,
93 			X_DEST_PARTY_SITE_ID		NUMBER,
94 			X_REPETITIVE_PAYMENT_CODE	VARCHAR2,
95 			X_TRXN_STATUS_CODE			VARCHAR2,
96 			X_PAYMENT_METHOD_CODE		VARCHAR2,
97 			X_AUTHORIZE_FLAG			VARCHAR2,
98 			X_BANK_CHARGE_BEARER		VARCHAR2,
99 			X_PAYMENT_REASON_CODE		VARCHAR2,
100 			X_PAYMENT_REASON_COMMENTS	VARCHAR2,
101 			X_REMITTANCE_MESSAGE1		VARCHAR2,
102 			X_REMITTANCE_MESSAGE2		VARCHAR2,
103 			X_REMITTANCE_MESSAGE3		VARCHAR2,
104 			X_CREATED_FROM_DIR			VARCHAR2,
105 			X_CREATE_FROM_STMTLINE_ID	NUMBER,
106 			X_BANK_TRXN_NUMBER			VARCHAR2,
107 			X_PAYMENT_REQUEST_NUMBER	NUMBER,
108 			X_PAPER_DOCUMENT_NUMBER		NUMBER,
109 			X_DOC_SEQUENCE_ID			NUMBER,
110 			X_DOC_SEQUENCE_VALUE		NUMBER,
111 			X_DOC_CATEGORY_CODE			VARCHAR2,
112 			X_PAYMENT_OFFSET_CCID		NUMBER,
113 			X_RECEIPT_OFFSET_CCID		NUMBER,
114 			X_CASHPOOL_ID				NUMBER,
115 			X_EXT_BANK_ACCOUNT_ID		NUMBER,
116 			X_ATTRIBUTE_CATEGORY		VARCHAR2,
117 			X_ATTRIBUTE1				VARCHAR2,
118 			X_ATTRIBUTE2				VARCHAR2,
119 			X_ATTRIBUTE3				VARCHAR2,
120 			X_ATTRIBUTE4				VARCHAR2,
121 			X_ATTRIBUTE5				VARCHAR2,
122 			X_ATTRIBUTE6				VARCHAR2,
123 			X_ATTRIBUTE7				VARCHAR2,
124 			X_ATTRIBUTE8				VARCHAR2,
125 			X_ATTRIBUTE9				VARCHAR2,
126 			X_ATTRIBUTE10				VARCHAR2,
127 			X_ATTRIBUTE11				VARCHAR2,
128 			X_ATTRIBUTE12				VARCHAR2,
129 			X_ATTRIBUTE13				VARCHAR2,
130 			X_ATTRIBUTE14				VARCHAR2,
131 			X_ATTRIBUTE15				VARCHAR2,
132 			X_LAST_UPDATED_BY			NUMBER,
133 			X_LAST_UPDATE_DATE			DATE,
134 			X_LAST_UPDATE_LOGIN			NUMBER,
135 			X_OBJECT_VERSION_NUMBER 	NUMBER );
136 
137 PROCEDURE Delete_Row( X_Row_id VARCHAR2 );
138 
139 PROCEDURE Update_Transfer_Status (X_TRXN_NUMBER NUMBER, X_STATUS VARCHAR2);
140 
141 END CE_PAYMENT_TRXN_PKG;