[Home] [Help]
PACKAGE: APPS.FA_FASRSVES_XMLP_PKG
Source
1 PACKAGE FA_FASRSVES_XMLP_PKG AS
2 /* $Header: FASRSVESS.pls 120.0.12010000.1 2008/07/28 13:17:33 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_ca_set_of_books_id_1 number;
14 p_mrcsobtype varchar2(10);
15 lp_fa_book_controls varchar2(50);
16 ACCT_BAL_APROMPT varchar2(222);
17 ACCT_CC_APROMPT varchar2(222);
18 CAT_MAJ_RPROMPT varchar2(222);
19 Period1_POD date;
20 Period1_PCD date;
21 Period1_FY number;
22 Period2_POD date;
23 Period2_PCD date;
24 Period2_FY number;
25 RP_COMPANY_NAME varchar2(30);
26 RP_REPORT_NAME varchar2(80);
27 RP_BAL_LPROMPT varchar2(222);
28 RP_CTR_APROMPT varchar2(222);
29 PERIOD_FROM varchar2(20);
30 PERIOD_TO varchar2(20);
31 function report_nameformula(Company_Name in varchar2) return varchar2 ;
32 function BeforeReport return boolean ;
33 function AfterReport return boolean ;
34 function Period1_PCFormula return Number ;
35 function Period2_PCFormula return Number ;
36 function DO_INSERTFormula return Number ;
37 function out_of_balanceformula(BEGIN_P in number, ADDITION in number, DEPRECIATION in number, RECLASS in number, RETIREMENT in number, ADJUST in number, TRANSFER in number, END_P in number) return varchar2 ;
38 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 ;
39 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 ;
40 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 ;
41 function adjustformula(TAX in number, REVALUATION in number) return number ;
42 function reval_tax_flagformula(REVALUATION in number, TAX in number) return varchar2 ;
43 function AfterPForm return boolean ;
44 function G_SETUPGroupFilter 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_BAL_LPROMPT_p(acct_bal_lprompt varchar2) return varchar2 ;
58
59 Function RP_CTR_APROMPT_p return varchar2;
60 --Function PERIOD_FROM_p return varchar2;
61 --Function PERIOD_TO_p return varchar2;
62 Function PERIOD_FROM_p(p_period1 varchar2) return varchar2 ;
63 Function PERIOD_TO_p(p_period2 varchar2) return varchar2 ;
64
65
66 --added during pls compilation
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
124 (Book in varchar2,
125 Start_Period_Name in varchar2,
126 End_Period_Name in varchar2,
127 Report_Type in varchar2,
128 Adj_Mode in varchar2);
129
130 END FA_FASRSVES_XMLP_PKG;
131