DBA Data[Home] [Help]

PACKAGE: APPS.CE_999_PKG

Source


1 PACKAGE CE_999_PKG AUTHID CURRENT_USER AS
2 /* $Header: ceab999s.pls 115.8 2002/01/25 16:51:45 pkm ship   $	*/
3   PROCEDURE lock_row(
4     X_call_mode		VARCHAR2, -- 'U' from reconcile, 'M' from unreconcile
5     X_trx_type 		VARCHAR2, -- trx_type of the transaction
6     X_trx_rowid		VARCHAR2  -- rowid of the transaction
7   );
8 
9   PROCEDURE clear(
10     X_trx_id		NUMBER,	  -- transaction id
11     X_trx_type		VARCHAR2, -- transaction type
12     X_status            VARCHAR2, -- status
13     X_trx_number        VARCHAR2, -- transaction number
14     X_trx_date		DATE,	  -- transaction date
15     X_trx_currency	VARCHAR2, -- transaction currency code
16     X_gl_date		DATE,	  -- gl date
17     X_bank_currency	VARCHAR2, -- bank currency code
18     X_cleared_amount	NUMBER,	  -- amount to be cleared
19     X_cleared_date      DATE,     -- cleared date
20     X_charges_amount	NUMBER,	  -- charges amount
21     X_errors_amount	NUMBER,	  -- errors amount
22     X_exchange_date	DATE,	  -- exchange rate date
23     X_exchange_type	VARCHAR2, -- exchange rate type
24     X_exchange_rate	NUMBER 	  -- exchange rate
25   );
26 
27   PROCEDURE unclear(
28     X_trx_id		NUMBER,	  -- transaction id
29     X_trx_type		VARCHAR2, -- transaction type
30     X_status            VARCHAR2, -- status
31     X_trx_date		DATE,	  -- transaction date
32     X_gl_date		DATE	  -- gl date
33   );
34 
35 END CE_999_PKG;