1 PACKAGE FA_TRX_APPROVAL_PKG AS
2 /* $Header: FATRXAPS.pls 120.2 2005/06/24 02:33:33 lson ship $ */
3
4 /*=====================================================================================+
5 |
6 | Name: faxcat()
7 |
8 | Description: This function checks whether depreciation or any Mass process is
9 | running on the book. Then it calls faxcti() to ensure that this
10 | transaction does not conflict with any other transactionon on the
11 | asset.
12 |
13 | Parameters: X_book - Book type code for the transaction
14 | X_asset_id - Asset_Id for the transaction
15 | X_trx_type - Requested transaction type
16 | X_trx_date - Requested transaction date
17 | -- X_result - OUT parameter to check transaction integrity
18 |
19 | Returns: TRUE (boolean) if no errors
20 |
21 | Notes: Called from the user-exit faxcatx() -- #OFA TRX_APPROVAL
22 |
23 +====================================================================================*/
24
25 FUNCTION faxcat (X_book VARCHAR2,
26 X_asset_id NUMBER,
27 X_trx_type VARCHAR2,
28 X_trx_date DATE,
29 X_init_message_flag VARCHAR2 DEFAULT 'NO',
30 p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
31 ) RETURN BOOLEAN;
32
33
34
35 /*=====================================================================================+
36 |
37 | Name: faxcti()
38 |
39 | Description: This function checks transaction integrity. It checks whether there
40 | any transactions entered for this asset on a date after this
41 | transaction date. Also checks whether there are retirements
42 | pending for the asset.
43 |
44 | Parameters: X_book - Book type code for the transaction
45 | X_asset_id - Asset_Id for the transaction
46 | X_trx_type - Requested transaction type
47 | X_trx_date - Requested transaction date
48 | X_result - OUT NOCOPY parameter to check transaction integrity
49 |
50 | Modifies: X_result = TRUE (boolean) if transaction is allowed
51 |
52 | Returns: TRUE(boolean) if no errors
53 |
54 | Notes: Called by the function faxcat()
55 |
56 +====================================================================================*/
57
58
59 FUNCTION faxcti (X_book VARCHAR2,
60 X_asset_id NUMBER,
61 X_trx_type VARCHAR2,
62 X_trx_date DATE,
63 X_result IN OUT NOCOPY BOOLEAN,
64 p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN;
65
66 END FA_TRX_APPROVAL_PKG;