1 PACKAGE FA_TRX_APPROVAL_PKG AUTHID CURRENT_USER AS
2 /* $Header: FATRXAPS.pls 120.3 2009/03/26 23:10:20 bridgway 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) RETURN BOOLEAN;
31
32
33
34 /*=====================================================================================+
35 |
36 | Name: faxcti()
37 |
38 | Description: This function checks transaction integrity. It checks whether there
39 | any transactions entered for this asset on a date after this
40 | transaction date. Also checks whether there are retirements
41 | pending for the asset.
42 |
43 | Parameters: X_book - Book type code for the transaction
44 | X_asset_id - Asset_Id for the transaction
45 | X_trx_type - Requested transaction type
46 | X_trx_date - Requested transaction date
47 | X_result - OUT NOCOPY parameter to check transaction integrity
48 |
49 | Modifies: X_result = TRUE (boolean) if transaction is allowed
50 |
51 | Returns: TRUE(boolean) if no errors
52 |
53 | Notes: Called by the function faxcat()
54 |
55 +====================================================================================*/
56
57
58 FUNCTION faxcti (X_book VARCHAR2,
59 X_asset_id NUMBER,
60 X_trx_type VARCHAR2,
61 X_trx_date DATE,
62 X_result IN OUT NOCOPY BOOLEAN, p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
63
64 END FA_TRX_APPROVAL_PKG;