[Home] [Help]
PACKAGE: APPS.FA_RES_LDG_PKG
Source
1 PACKAGE FA_RES_LDG_PKG AUTHID CURRENT_USER AS
2 -- $Header: FARESLDGPS.pls 120.3.12010000.2 2009/07/19 08:08:03 glchen ship $
3 -- ****************************************************************************************
4 -- Copyright (c) 2000 Oracle Solution Services (India) Product Development
5 -- All rights reserved
6 -- ****************************************************************************************
7 --
8 -- PROGRAM NAME
9 -- FARESLDGPS.pls
10 --
11 -- DESCRIPTION
12 -- This script creates the package specification of FA_RES_LDG_PKG
13 -- This package is used to generate Bulgarian Reserve Ledger Report
14 --
15 -- USAGE
16 -- To install How to Install
17 -- To execute How to Execute
18 --
19 -- DEPENDENCIES
20 -- None.
21 --
22 --
23 -- LAST UPDATE DATE 26-JAN-2007
24 -- Date the program has been modified for the last time
25 --
26 -- HISTORY
27 -- =======
28 --
29 -- VERSION DATE AUTHOR(S) DESCRIPTION
30 -- ------- ----------- --------------- ------------------------------------
31 -- 1.0 26-JAN-2007 Praveen Gollu M Creation
32 --
33 --****************************************************************************************
34 -------------------------------------------------------------------------------------------------------------------------------------------------------------
35 -------------------------------------------------------------------------------------------------------------------------------------------------------------
36 P_BOOK VARCHAR2(15);
37 P_PERIOD1 VARCHAR2(15);
38 p_ca_set_of_books_id NUMBER;
39 --p_ca_org_id NUMBER;
40 --p_mrcsobtype VARCHAR2(10);
41 --lp_currency_code VARCHAR2(15);
42 --lp_fa_deprn_summary VARCHAR2(50);
43 gn_accounting_flex_structure NUMBER;
44 gc_currency_code VARCHAR2(15);
45 gc_book_class VARCHAR2(15);
46 gc_distribution_source_book VARCHAR2(15);
47 gn_period1_pc NUMBER;
48 gd_period1_pcd DATE;
49 gd_period1_pod DATE;
50 gn_period1_fy NUMBER;
51 gc_period_closed VARCHAR2(32767);
52 C_Errbuf VARCHAR2(250);
53 C_RetCode NUMBER;
54 FUNCTION BookFormula RETURN VARCHAR2 ;
55 FUNCTION Period1Formula RETURN VARCHAR2 ;
56 --FUNCTION Report_NameFormula RETURN VARCHAR2 ;
57 FUNCTION BeforeReport RETURN BOOLEAN ;
58 FUNCTION AfterReport RETURN BOOLEAN ;
59 FUNCTION c_do_insertformula(Book IN VARCHAR2, Period1 IN VARCHAR2) RETURN NUMBER ;
60 FUNCTION d_lifeformula(LIFE IN NUMBER, ADJ_RATE IN NUMBER, BONUS_RATE IN NUMBER, PROD IN NUMBER) RETURN VARCHAR2 ;
61 --FUNCTION AfterPForm RETURN BOOLEAN ;
62 FUNCTION Accounting_Flex_Structure_p RETURN NUMBER;
63 --FUNCTION ACCT_CC_APROMPT_p RETURN VARCHAR2;
64 --FUNCTION CAT_MAJ_APROMPT_p RETURN VARCHAR2;
65 FUNCTION Currency_Code_p RETURN VARCHAR2;
66 --FUNCTION Book_Class_p RETURN VARCHAR2;
67 --FUNCTION Distribution_Source_Book_p RETURN VARCHAR2;
68 --FUNCTION Period1_PC_p RETURN NUMBER;
69 --FUNCTION Period1_PCD_p RETURN DATE;
70 --FUNCTION Period1_POD_p RETURN DATE;
71 --FUNCTION Period1_FY_p RETURN NUMBER;
72 --FUNCTION Period_Closed_p RETURN VARCHAR2;
73 --FUNCTION C_Errbuf_p RETURN VARCHAR2;
74 --FUNCTION C_RetCode_p RETURN NUMBER;
75 PROCEDURE FA_RSVLDG(book IN VARCHAR2,
76 period IN VARCHAR2,
77 errbuf OUT NOCOPY VARCHAR2,
78 retcode OUT NOCOPY NUMBER);
79 FUNCTION fadolif(life NUMBER,adj_rate NUMBER,bonus_rate NUMBER,prod NUMBER) RETURN CHAR;
80 END FA_RES_LDG_PKG;