DBA Data[Home] [Help]

PACKAGE BODY: APPS.FA_XLA_DRILL_GT_PKG

Source


1 PACKAGE BODY FA_XLA_DRILL_GT_PKG AS
2 /* $Header: FAXLAGTB.pls 120.0.12010000.3 2009/07/19 08:28:59 glchen ship $   */
3 
4 /*=========================================================================+
5  | Function Name:                                                          |
6  |    load_trx_gt                                                  |
7  |                                                                         |
8  | Description:                                                            |
9  |    This function will insert the transaction_header_id into the GT table|
10  |    so that the inquiry view fa_ael_sl_v returns correct data.           |
11  |                                                                         |
12  +=========================================================================*/
13 FUNCTION load_trx_gt(
14    p_transaction_header_id       NUMBER,
15    p_book_type_code              VARCHAR2
16 ) return BOOLEAN IS
17 
18 BEGIN
19 
20    insert into
21    fa_inquiry_trx_gt (transaction_header_id, book_type_code)
22    values(p_transaction_header_id, p_book_type_code);
23 
24    return TRUE;
25 
26 EXCEPTION
27 
28    when others then
29       return FALSE;
30 END load_trx_gt;
31 
32 
33 END FA_XLA_DRILL_GT_PKG;