1 PACKAGE FA_TOFES_YUD_ALEF_PKG
2 -- $Header: FASTYAPS.pls 120.4.12010000.4 2009/10/09 19:18:28 mswetha 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 AUTHID CURRENT_USER 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 P_ca_set_of_books_id number;
61 P_mrcsobtype varchar2(10);
62 lp_currency_code varchar2(15);
63 lp_fa_book_controls varchar2(50);
64 lp_fa_books varchar2(50);
65 lp_fa_adjustments varchar2(50);
66 lp_fa_retirements varchar2(50);
67 lp_fa_deprn_periods varchar2(50);
68 lp_fa_asset_invoices varchar2(50);
69 /*=========================================
70 Lexical Variables to obtain dynamic values
71 =========================================*/
72
73 p_lex_begin_period_counter NUMBER; -- Obtains the Period number for a beginning Period
74 p_lex_end_period_counter NUMBER; -- Obtains the Period number for a ending Period
75 lc_acct_flex_struc NUMBER;
76
77 /*=========================================
78 Public Functions
79 =========================================*/
80
81 FUNCTION ytd_trans_amt(p_asset_id_in IN NUMBER) RETURN NUMBER;
82 FUNCTION deprn_claim_number(p_asset_id_in IN NUMBER) RETURN NUMBER;
83 FUNCTION ytd_deprn_amt(p_asset_id_in IN NUMBER) RETURN NUMBER;
84 FUNCTION ytd_deprn_retire_amt(p_asset_id_in IN NUMBER
85 ,p_period_counter IN NUMBER) RETURN NUMBER;
86 FUNCTION accm_deprn_pr_amt(p_asset_id_in IN NUMBER) RETURN NUMBER;
87 FUNCTION accm_deprn_pr_retire_amt(p_asset_id_in IN NUMBER
88 ,p_period_counter IN NUMBER) RETURN NUMBER;
89 FUNCTION purchase_date(p_asset_id_in IN NUMBER) RETURN DATE;
90 FUNCTION beforereport RETURN BOOLEAN;
91 function AfterPForm return boolean ;
92 END FA_TOFES_YUD_ALEF_PKG;