1 PACKAGE FA_FASRSVED_XMLP_PKG AS
2 /* $Header: FASRSVEDS.pls 120.0.12010000.1 2008/07/28 13:17:31 appldev ship $ */
3 P_BOOK varchar2(15);
4 P_PERIOD1 varchar2(15);
5 P_CONC_REQUEST_ID number;
6 P_PERIOD2 varchar2(15);
7 P_MIN_PRECISION number;
8 P_REPORT_TYPE varchar2(30);
9 P_ADJ_MODE varchar2(32767);
10 lp_currency_code varchar2(15);
11 p_ca_org_id number;
12 p_ca_set_of_books_id number;
13 p_mrcsobtype varchar2(10);
14 lp_fa_book_controls varchar2(50);
15 ACCT_BAL_APROMPT varchar2(222);
16 ACCT_CC_APROMPT varchar2(222);
17 CAT_MAJ_RPROMPT varchar2(222);
18 Period1_POD date;
19 Period1_PCD date;
20 Period1_FY number;
21 Period2_POD date;
22 Period2_PCD date;
23 Period2_FY number;
24 RP_COMPANY_NAME varchar2(30);
25 RP_REPORT_NAME varchar2(80);
26 RP_BAL_LPROMPT varchar2(222);
27 RP_CTR_LPROMPT varchar2(50);
28 RP_PERIOD_FROM varchar2(20);
29 RP_PERIOD_TO varchar2(20);
30 function report_nameformula(Company_Name in varchar2) return varchar2 ;
31 function BeforeReport return boolean ;
32 function AfterReport return boolean ;
33 function Period1_PCFormula return Number ;
34 function Period2_PCFormula return Number ;
35 function DO_INSERTFormula return Number ;
36 --function out_of_balanceformula(BEGIN in number, ADDITION in number, DEPRECIATION in number, RECLASS in number, RETIREMENT in number, ADJUST in number, TRANSFER in number, END in number) return varchar2 ;
37 function out_of_balanceformula(CHANGED_BEGIN in number, ADDITION in number, DEPRECIATION in number, RECLASS in number, RETIREMENT in number, ADJUST in number, TRANSFER in number, CHANGED_END in number) return varchar2 ;
38 function ctr_out_of_balanceformula(CTR_BEGIN in number, CTR_ADD in number, CTR_DEPRN in number, CTR_RECLASS in number, CTR_RETIRE in number, CTR_ADJUST in number, CTR_TRANS in number, CTR_END in number) return varchar2 ;
39 function acct_out_of_balanceformula(ACCT_BEGIN in number, ACCT_ADD in number, ACCT_DEPRN in number, ACCT_RECLASS in number, ACCT_RETIRE in number, ACCT_ADJUST in number, ACCT_TRANS in number, ACCT_END in number) return varchar2 ;
40 function bal_out_of_balanceformula(BAL_BEGIN in number, BAL_ADD in number, BAL_DEPRN in number, BAL_RECLASS in number, BAL_RETIRE in number, BAL_ADJUST in number, BAL_TRANS in number, BAL_END in number) return varchar2 ;
41 function rp_out_of_balanceformula(RP_BEGIN in number, RP_ADD in number, RP_DEPRN in number, RP_RECLASS in number, RP_RETIRE in number, RP_ADJUST in number, RP_TRANS in number, RP_END in number) return varchar2 ;
42 function adjustformula(TAX in number, REVALUATION in number) return number ;
43 function reval_tax_flagformula(REVALUATION in number, TAX in number) return varchar2 ;
44 function AfterPForm return boolean ;
45 Function ACCT_BAL_APROMPT_p return varchar2;
46 Function ACCT_CC_APROMPT_p return varchar2;
47 Function CAT_MAJ_RPROMPT_p return varchar2;
48 Function Period1_POD_p return date;
49 Function Period1_PCD_p return date;
50 Function Period1_FY_p return number;
51 Function Period2_POD_p return date;
52 Function Period2_PCD_p return date;
53 Function Period2_FY_p return number;
54 Function RP_COMPANY_NAME_p return varchar2;
55 Function RP_REPORT_NAME_p return varchar2;
56 Function RP_BAL_LPROMPT_p return varchar2;
57 Function RP_CTR_LPROMPT_p return varchar2;
58 Function RP_PERIOD_FROM_p return varchar2;
59 Function RP_PERIOD_TO_p return varchar2;
60
61 --Added during DT Fix
62 procedure Get_Adjustments
63 (Book in varchar2,
64 Distribution_Source_Book in varchar2,
65 Period1_PC in number,
66 Period2_PC in number,
67 Report_Type in varchar2,
68 Balance_Type in varchar2);
69
70 PROCEDURE get_adjustments_for_group
71 (Book in varchar2,
72 Distribution_Source_Book in varchar2,
73 Period1_PC in number,
74 Period2_PC in number,
75 Report_Type in varchar2,
76 Balance_Type in varchar2);
77
78 procedure Get_Balance
79 (Book in varchar2,
80 Distribution_Source_Book in varchar2,
81 Period_PC in number,
82 Earliest_PC in number,
83 Period_Date in date,
84 Additions_Date in date,
85 Report_Type in varchar2,
86 Balance_Type in varchar2,
87 Begin_or_End in varchar2);
88
89 procedure get_balance_group_begin
90 (Book in varchar2,
91 Distribution_Source_Book in varchar2,
92 Period_PC in number,
93 Earliest_PC in number,
94 Period_Date in date,
95 Additions_Date in date,
96 Report_Type in varchar2,
97 Balance_Type in varchar2,
98 Begin_or_End in varchar2);
99
100 procedure get_balance_group_end
101 (Book in varchar2,
102 Distribution_Source_Book in varchar2,
103 Period_PC in number,
104 Earliest_PC in number,
105 Period_Date in date,
106 Additions_Date in date,
107 Report_Type in varchar2,
108 Balance_Type in varchar2,
109 Begin_or_End in varchar2);
110
111 procedure Get_Deprn_Effects
112 (Book in varchar2,
113 Distribution_Source_Book in varchar2,
114 Period1_PC in number,
115 Period2_PC in number,
116 Report_Type in varchar2);
117
118 procedure Insert_Info(Book in varchar2,
119 Start_Period_Name in varchar2,
120 End_Period_Name in varchar2,
121 Report_Type in varchar2,
122 Adj_Mode in varchar2);
123
124 --End of DT Fix
125 END FA_FASRSVED_XMLP_PKG;
126