1 PACKAGE FA_FASCOSTS_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: FASCOSTSS.pls 120.1 2009/07/19 08:56:01 glchen 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_fa_book_controls varchar2(50);
11 lp_currency_code varchar2(15);
12 p_ca_org_id number;
13 p_ca_set_of_books_id number;
14 p_mrcsobtype varchar2(10):='P';
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_APROMPT varchar2(222);
28 PERIOD_FROM varchar2(20);
29 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, ADJUSTMENT in number, TRANSFER in number, CAPITALIZATION in number, END_P in number) return varchar2 ;
38 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, ACCT_ADJUST in number, ACCT_TRANS in number, ACCT_CAPITAL in number, ACCT_END in number)
39 return varchar2 ;
40 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, BAL_ADJUST in number, BAL_TRANS in number, BAL_CAPITAL in number, BAL_END in number) return varchar2 ;
41 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, RP_ADJUST in number, RP_TRANS in number, RP_CAPITAL in number, RP_END in number) return varchar2 ;
42 function caprevalformula(REVALUATION in number, CAPITALIZATION in number) return number ;
43 function AfterPForm return boolean ;
44 Function ACCT_BAL_APROMPT_p return varchar2;
45 Function ACCT_CC_APROMPT_p return varchar2;
46 Function CAT_MAJ_RPROMPT_p return varchar2;
47 Function Period1_POD_p return date;
48 Function Period1_PCD_p return date;
49 Function Period1_FY_p return number;
50 Function Period2_POD_p return date;
51 Function Period2_PCD_p return date;
52 Function Period2_FY_p return number;
53 Function RP_COMPANY_NAME_p return varchar2;
54 Function RP_REPORT_NAME_p return varchar2;
55 Function RP_BAL_LPROMPT_p(ACCT_BAL_LPROMPT VARCHAR2) return varchar2;
56 --Function RP_BAL_LPROMPT_p return varchar2;
57 Function RP_CTR_APROMPT_p return varchar2;
58 Function PERIOD_FROM_p return varchar2;
59 Function PERIOD_TO_p return varchar2;
60 --added during pls fixes
61 procedure Get_Adjustments
62 (Book in varchar2,
63 Distribution_Source_Book in varchar2,
64 Period1_PC in number,
65 Period2_PC in number,
66 Report_Type in varchar2,
67 Balance_Type in varchar2);
68
69 PROCEDURE get_adjustments_for_group
70 (Book in varchar2,
71 Distribution_Source_Book in varchar2,
72 Period1_PC in number,
73 Period2_PC in number,
74 Report_Type in varchar2,
75 Balance_Type in varchar2);
76
77 procedure Get_Balance
78 (Book in varchar2,
79 Distribution_Source_Book in varchar2,
80 Period_PC in number,
81 Earliest_PC in number,
82 Period_Date in date,
83 Additions_Date in date,
84 Report_Type in varchar2,
85 Balance_Type in varchar2,
86 Begin_or_End in varchar2);
87
88 procedure get_balance_group_begin
89 (Book in varchar2,
90 Distribution_Source_Book in varchar2,
91 Period_PC in number,
92 Earliest_PC in number,
93 Period_Date in date,
94 Additions_Date in date,
95 Report_Type in varchar2,
96 Balance_Type in varchar2,
97 Begin_or_End in varchar2);
98
99 procedure get_balance_group_end
100 (Book in varchar2,
101 Distribution_Source_Book in varchar2,
102 Period_PC in number,
103 Earliest_PC in number,
104 Period_Date in date,
105 Additions_Date in date,
106 Report_Type in varchar2,
107 Balance_Type in varchar2,
108 Begin_or_End in varchar2);
109
110 procedure Get_Deprn_Effects
111 (Book in varchar2,
112 Distribution_Source_Book in varchar2,
113 Period1_PC in number,
114 Period2_PC in number,
115 Report_Type in varchar2);
116
117 procedure Insert_Info
118 (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 Function LP_FA_BOOK_CONTROLS_P return varchar2 ;
125
126
127 END FA_FASCOSTS_XMLP_PKG;
128
129