1 PACKAGE FA_TOFES_YUD_ALEF_PKG
2 -- $Header: FASTYAPS.pls 120.4.12010000.1 2008/07/28 13:17:47 appldev ship $
3 -- ****************************************************************************************
4 -- Copyright (c) 2000 Oracle Product Development
5 -- All rights reserved
6 -- ****************************************************************************************
7 --
8 -- PROGRAM NAME
9 -- FASTYAPS.pls
10 --
11 -- DESCRIPTION
12 -- This script creates the PackageSpecification of FA_TOFES_YUD_ALEF_PKG.
13 -- This package is used to generate IsraeliFA Report.
14 --
15 -- USAGE
16 -- To install How to Install
17 -- To execute How to Execute
18 --
19 -- PROGRAM LIST DESCRIPTION
20 --
21 -- BEFOREREPORT This function is used to dynamically get the
22 -- WHERE clause in SELECT statement.
23 --
24 --YTD_TRANS_AMT This Funtion is used to Calculate the YTD TRANSACTION AMOUNT
25 --
26 --YTD_DEPRN_AMT This Funtion is used to Calculate the YTD Depreciation Amount
27 --
28 --YTD_DEPRN_RETIRE_AMT This Funtion is used to calcualte the YTD Depreciation retire Amount
29 --
30 --ACCM_DEPRN_PR_AMT This Funtion is used to calcualte the Accumulated Depreciation Prior Year Amount
31 --
32 --PURCHASE_DATE This Funtion is used to calculate the Purchase Date
33 --
34 -- DEPENDENCIES
35 -- None
36 --
37 -- CALLED BY
38 -- Tofes Yud Alef Report 1342 (Israel)
39 --
40 -- LAST UPDATE DATE 22-Jan-2007
41 -- Date the program has been modified for the last time.
42 --
43 -- HISTORY
44 -- =======
45 --
46 -- VERSION DATE AUTHOR(S) DESCRIPTION
47 -- ------- ----------- --------------- --------------------------------------
48 -- Draft1A 22-Jan-2007 Karna Kumar M Initial Creation
49 --===========================================================================*/
50 AS
51
52 /*=========================================
53 Variables to Hold the Parameter Values
54 =========================================*/
55 p_book_name VARCHAR2(30);
56 p_ledger_id NUMBER;
57 p_legal_entity NUMBER;
58 p_begin_period VARCHAR2(30);
59 p_end_period VARCHAR2(30);
60
61 /*=========================================
62 Lexical Variables to obtain dynamic values
63 =========================================*/
64
65 p_lex_begin_period_counter NUMBER; -- Obtains the Period number for a beginning Period
66 p_lex_end_period_counter NUMBER; -- Obtains the Period number for a ending Period
67 lc_acct_flex_struc NUMBER;
68
69 /*=========================================
70 Public Functions
71 =========================================*/
72
73 FUNCTION ytd_trans_amt(p_asset_id_in IN NUMBER) RETURN NUMBER;
74 FUNCTION deprn_claim_number RETURN NUMBER;
75 FUNCTION ytd_deprn_amt(p_asset_id_in IN NUMBER) RETURN NUMBER;
76 FUNCTION ytd_deprn_retire_amt(p_asset_id_in IN NUMBER
77 ,p_period_counter IN NUMBER) RETURN NUMBER;
78 FUNCTION accm_deprn_pr_amt(p_asset_id_in IN NUMBER) RETURN NUMBER;
79 FUNCTION accm_deprn_pr_retire_amt(p_asset_id_in IN NUMBER
80 ,p_period_counter IN NUMBER) RETURN NUMBER;
81 FUNCTION purchase_date(p_asset_id_in IN NUMBER) RETURN DATE;
82 FUNCTION beforereport RETURN BOOLEAN;
83 END FA_TOFES_YUD_ALEF_PKG;
[Home] [Help]