1 PACKAGE FA_FASCOSTD_XMLP_PKG AS
2 /* $Header: FASCOSTDS.pls 120.0.12010000.1 2008/07/28 13:16:35 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 lp_fa_book_controls varchar2(50);
12 p_ca_org_id number;
13 p_ca_set_of_books_id number;
14 p_mrcsobtype varchar2(10);
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(222);
28 P_PERIOD_FROM varchar2(20);
29 P_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, REVALUATION in number, RECLASS in number, RETIREMENT in number, ADJUSTMENT in number, TRANSFER in number, CAPITALIZATION in number, END in number) return varchar2 ;
37 function out_of_balanceformula(BEGIN_P in number, ADDITION in number, REVALUATION in number, RECLASS in number, RETIREMENT in number,
38 ADJUSTMENT in number, TRANSFER in number, CAPITALIZATION in number, END_P in number) return varchar2 ;
39
40 function ctr_out_of_balanceformula(CTR_BEGIN in number, CTR_ADD in number, CTR_REVAL in number, CTR_RECLASS in number, CTR_RETIRE in number,
41 CTR_ADJUST in number, CTR_TRANS in number, CTR_CAPITAL in number, CTR_END in number) return varchar2 ;
42 function acct_out_of_balanceformula(ACCT_BEGIN in number, ACCT_ADD in number, ACCT_REVAL in number, ACCT_RECLASS in number, ACCT_RETIRE in number,
43 ACCT_ADJUST in number, ACCT_TRANS in number, ACCT_CAPITAL in number, ACCT_END in number) return varchar2 ;
44 function bal_out_of_balanceformula(BAL_BEGIN in number, BAL_ADD in number, BAL_REVAL in number, BAL_RECLASS in number, BAL_RETIRE in number,
45 BAL_ADJUST in number, BAL_TRANS in number, BAL_CAPITAL in number, BAL_END in number) return varchar2 ;
46 function rp_out_of_balanceformula(RP_BEGIN in number, RP_ADD in number, RP_REVAL in number, RP_RECLASS in number, RP_RETIRE in number,
47 RP_ADJUST in number, RP_TRANS in number, RP_CAPITAL in number, RP_END in number) return varchar2 ;
48 function caprevalformula(REVALUATION in number, CAPITALIZATION in number) return number ;
49 function AfterPForm return boolean ;
50 Function ACCT_BAL_APROMPT_p return varchar2;
51 Function ACCT_CC_APROMPT_p return varchar2;
52 Function CAT_MAJ_RPROMPT_p return varchar2;
53 Function Period1_POD_p return date;
54 Function Period1_PCD_p return date;
55 Function Period1_FY_p return number;
56 Function Period2_POD_p return date;
57 Function Period2_PCD_p return date;
58 Function Period2_FY_p return number;
59 Function RP_COMPANY_NAME_p return varchar2;
60 Function RP_REPORT_NAME_p return varchar2;
61 Function RP_BAL_LPROMPT_p return varchar2;
62 Function RP_CTR_LPROMPT_p return varchar2;
63 Function P_PERIOD_FROM_p return varchar2;
64 Function P_PERIOD_TO_p return varchar2;
65
66 --Added during DT Fix
67 procedure Get_Adjustments
68 (Book in varchar2,
69 Distribution_Source_Book in varchar2,
70 Period1_PC in number,
71 Period2_PC in number,
72 Report_Type in varchar2,
73 Balance_Type in varchar2);
74
75 PROCEDURE get_adjustments_for_group
76 (Book in varchar2,
77 Distribution_Source_Book in varchar2,
78 Period1_PC in number,
79 Period2_PC in number,
80 Report_Type in varchar2,
81 Balance_Type in varchar2);
82
83 procedure Get_Balance
84 (Book in varchar2,
85 Distribution_Source_Book in varchar2,
86 Period_PC in number,
87 Earliest_PC in number,
88 Period_Date in date,
89 Additions_Date in date,
90 Report_Type in varchar2,
91 Balance_Type in varchar2,
92 Begin_or_End in varchar2);
93
94 procedure get_balance_group_begin
95 (Book in varchar2,
96 Distribution_Source_Book in varchar2,
97 Period_PC in number,
98 Earliest_PC in number,
99 Period_Date in date,
100 Additions_Date in date,
101 Report_Type in varchar2,
102 Balance_Type in varchar2,
103 Begin_or_End in varchar2);
104
105 procedure get_balance_group_end
106 (Book in varchar2,
107 Distribution_Source_Book in varchar2,
108 Period_PC in number,
109 Earliest_PC in number,
110 Period_Date in date,
111 Additions_Date in date,
112 Report_Type in varchar2,
113 Balance_Type in varchar2,
114 Begin_or_End in varchar2);
115
116 procedure Get_Deprn_Effects
117 (Book in varchar2,
118 Distribution_Source_Book in varchar2,
119 Period1_PC in number,
120 Period2_PC in number,
121 Report_Type in varchar2);
122
123 procedure Insert_Info(Book in varchar2,
124 Start_Period_Name in varchar2,
125 End_Period_Name in varchar2,
126 Report_Type in varchar2,
127 Adj_Mode in varchar2);
128
129 --End of DT Fix
130
131 END FA_FASCOSTD_XMLP_PKG;
132
[Home] [Help]