[Home] [Help]
PACKAGE: APPS.JG_RX_FAREG
Source
1 PACKAGE JG_RX_FAREG AUTHID CURRENT_USER AS
2 /* $Header: jgrxfrs.pls 120.11 2008/06/13 09:02:25 pakumare ship $ */
3
4 -- Main Core Report
5 PROCEDURE fa_get_report (
6 p_book_type_code IN VARCHAR2,
7 p_period_from IN VARCHAR2,
8 p_period_to IN VARCHAR2,
9 p_dummy IN NUMBER,
10 p_major_category IN VARCHAR2,
11 p_minor_category IN VARCHAR2,
12 p_type IN VARCHAR2, -- ASSET or RTRMNT
13 request_id IN NUMBER,
14 retcode OUT NOCOPY NUMBER,
15 errbuf OUT NOCOPY VARCHAR2);
16
17
18
19 --
20 -- All event trigger procedures must be defined as public procedures
21 -- Procedure written for the Main/Core Report.
22
23 PROCEDURE fa_ASSET_before_report;
24
25 PROCEDURE fa_ASSET_bind (c IN INTEGER);
26
27 PROCEDURE fa_ASSET_after_fetch;
28
29 PROCEDURE fa_ASSET_after_report;
30
31
32 PROCEDURE fa_RTRMNT_before_report;
33
34 PROCEDURE fa_RTRMNT_bind (c IN INTEGER);
35
36 PROCEDURE fa_RTRMNT_after_fetch;
37
38 PROCEDURE fa_RTRMNT_after_report;
39
40
41 --
42 -- These are local procedure
43 --
44 FUNCTION Get_category_segment RETURN VARCHAR2;
45
46 PROCEDURE Get_period_date (
47 p_period_from IN VARCHAR2,
48 p_period_to IN VARCHAR2);
49
50 PROCEDURE Startup;
51 PROCEDURE Get_RTRMNT_reserve ;
52 PROCEDURE Get_cost_value;
53 PROCEDURE Get_cost_increase;
54 PROCEDURE Get_cost_decrease;
55
56 PROCEDURE Get_revaluation;
57 PROCEDURE Get_revaluation_change;
58
59 PROCEDURE Get_deprn_reserve_value;
60 PROCEDURE Get_deprn_reserve_increase;
61 PROCEDURE Get_deprn_reserve_decrease;
62
63 PROCEDURE Get_bonus_reserve_value;
64 PROCEDURE Get_bonus_reserve_increase;
65 PROCEDURE Get_bonus_reserve_decrease;
66
67 PROCEDURE Get_fiscal_year_date;
68 PROCEDURE Get_depreciation_rate;
69 PROCEDURE Get_bonus_rate;
70
71 PROCEDURE Get_transactions;
72 PROCEDURE Get_addition_transactions;
73 PROCEDURE Get_adjustment_transactions;
74 PROCEDURE Get_retirement_transactions;
75 PROCEDURE Get_revaluation_transactions;
76
77 PROCEDURE Insert_transaction( p_transaction_date IN DATE,
78 p_transaction_number IN NUMBER,
79 p_transaction_code IN VARCHAR2,
80 p_transaction_amount IN NUMBER);
81
82 PROCEDURE Get_Net_Book_Value;
83 PROCEDURE Get_invoice_number;
84 procedure Get_deprn_accounts;
85
86 FUNCTION Get_starting_depreciation_year RETURN NUMBER;
87
88 FUNCTION Get_parent_asset_number RETURN VARCHAR2;
89
90 FUNCTION Get_account_segment RETURN VARCHAR2;
91
92 --
93 -- This is the structure to hold the placeholder values
94 --
95 TYPE var_t IS RECORD(
96 ORGANIZATION_NAME VARCHAR2(60),
97 FUNCTIONAL_CURRENCY_CODE VARCHAR2(15),
98 LAST_UPDATE_DATE DATE,
99 LAST_UPDATED_BY NUMBER,
100 LAST_UPDATE_LOGIN NUMBER,
101 CREATION_DATE DATE,
102 CREATED_BY NUMBER,
103 MAJOR_CATEGORY VARCHAR2(30),
104 MINOR_CATEGORY VARCHAR2(30),
105 DEPRN_RATE NUMBER,
106 STARTING_DEPRN_YEAR VARCHAR2(4),
107 ASSET_HEADING VARCHAR2(15),
108 ASSET_NUMBER VARCHAR2(25),
109 DESCRIPTION VARCHAR2(80),
110 PARENT_ASSET_ID NUMBER,
111 PARENT_ASSET_NUMBER VARCHAR2(15),
112 ASSET_COST_ORIG NUMBER,
113 BONUS_RATE NUMBER,
114 INVOICE_NUMBER VARCHAR2(50),
115 SUPPLIER_NAME VARCHAR2(360),
116 COST_ACCOUNT VARCHAR2(25),
117 EXPENSE_ACCOUNT VARCHAR2(25),
118 RESERVE_ACCOUNT VARCHAR2(25),
119 BONUS_DEPRN_ACCOUNT VARCHAR2(25),
120 BONUS_RESERVE_ACCOUNT VARCHAR2(25),
121 ASSET_COST_INITIAL NUMBER,
122 ASSET_COST_INCREASE NUMBER,
123 ASSET_COST_DECREASE NUMBER,
124 ASSET_COST_FINAL NUMBER,
125 REVALUATION_INITIAL NUMBER,
126 REVALUATION_INCREASE NUMBER,
127 REVALUATION_DECREASE NUMBER,
128 REVALUATION_FINAL NUMBER,
129 DEPRN_RESERVE_INITIAL NUMBER,
130 DEPRN_RESERVE_INCREASE NUMBER,
131 DEPRN_RESERVE_DECREASE NUMBER,
132 DEPRN_RESERVE_FINAL NUMBER,
133 BONUS_RESERVE_INITIAL NUMBER,
134 BONUS_RESERVE_INCREASE NUMBER,
135 BONUS_RESERVE_DECREASE NUMBER,
136 BONUS_RESERVE_FINAL NUMBER,
137 NET_BOOK_VALUE_INITIAL NUMBER,
138 NET_BOOK_VALUE_INCREASE NUMBER,
139 NET_BOOK_VALUE_DECREASE NUMBER,
140 NET_BOOK_VALUE_FINAL NUMBER,
141 TRANSACTION_DATE DATE,
142 TRANSACTION_NUMBER NUMBER,
143 TRANSACTION_CODE VARCHAR2(20),
144 TRANSACTION_AMOUNT NUMBER,
145 SALES_AMOUNT NUMBER,
146 COST_RETIRED NUMBER,
147 DEPRN_RESERVE NUMBER,
148 BONUS_RESERVE NUMBER,
149 NET_BOOK_VALUE NUMBER,
150 GAIN_LOSS NUMBER,
151 ASSET_ID NUMBER,
152 PRORATE_DATE DATE,
153 RATE_SOURCE_ROULE VARCHAR2(10),
154 date_placed_in_service DATE,
155 method_id NUMBER,
156 adjusted_rate NUMBER,
157 life_in_months NUMBER,
158 rate_source_rule VARCHAR2(10),
159 bonus_rule VARCHAR2(30),
160 date_retired DATE,
161 transaction_header_id NUMBER,
162 INITIAL_HEADING VARCHAR(15),
163 VARIATION_HEADING VARCHAR(15),
164 FINAL_HEADING VARCHAR(132),
165 ASSET_VARIATION NUMBER,
166 REVAL_VARIATION NUMBER,
167 DEPRN_VARIATION NUMBER,
168 BONUS_VARIATION NUMBER,
169 NETBO_VARIATION NUMBER,
170 REVALUATION_TOTAL NUMBER,
171 DEPRICIATION_METHOD VARCHAR2(12),
172 LIFE_IN_YEARS NUMBER,
173 PRORATE_CONVENTION VARCHAR2(10),
174 TAG_NUMBER VARCHAR2(15),
175 SERIAL_NUMBER VARCHAR2(35),
176 ASSET_KEY_CCID NUMBER,
177 ASSET_KEY_FLEXFIELD VARCHAR2(320),
178 YTD_DEPRN NUMBER
179 );
180
181 var var_t;
182
183 END JG_RX_FAREG;