[Home] [Help]
PACKAGE: APPS.FARX_DP
Source
1 PACKAGE FARX_DP AUTHID CURRENT_USER AS
2 /* $Header: farxdps.pls 120.9 2011/02/16 14:06:58 gigupta ship $ */
3
4 --
5 -- Backward compatible version
6 --
7 PROCEDURE deprn_run (
8 book in varchar2,
9 sob_id in varchar2 default NULL, -- MRC: Set of books id
10 period in varchar2,
11 from_bal in varchar2,
12 to_bal in varchar2,
13 from_acct in varchar2,
14 to_acct in varchar2,
15 from_cc in varchar2,
16 to_cc in varchar2,
17 major_category in varchar2,
18 minor_category in varchar2,
19 cat_seg_num in varchar2,
20 cat_seg_val in varchar2,
21 prop_type in varchar2,
22 request_id in number,
23 login_id in number,
24 retcode out nocopy number,
25 errbuf out nocopy varchar2
26 );
27
28 --
29 -- Main version
30 --
31 PROCEDURE deprn_run (
32 book in varchar2,
33 sob_id in varchar2 default NULL, -- MRC: Set of books id
34 period in varchar2,
35 from_bal in varchar2,
36 to_bal in varchar2,
37 from_acct in varchar2,
38 to_acct in varchar2,
39 from_cc in varchar2,
40 to_cc in varchar2,
41 from_maj_cat in varchar2,
42 to_maj_cat in varchar2,
43 from_min_cat in varchar2,
44 to_min_cat in varchar2,
45 cat_seg_num in varchar2,
46 from_cat_seg_val in varchar2,
47 to_cat_seg_val in varchar2,
48 prop_type in varchar2,
49 from_asset_num in varchar2,
50 to_asset_num in varchar2,
51 report_style in varchar2 default 'S',
52 request_id in number,
53 login_id in number,
54 retcode out nocopy number,
55 errbuf out nocopy varchar2
56 );
57
58
59
60 PROCEDURE before_report;
61 PROCEDURE bind(c IN INTEGER);
62 PROCEDURE after_fetch;
63
64 TYPE var_t IS RECORD (
65 book VARCHAR2(15),
66 book_class VARCHAR2(15),
67 dist_source_book VARCHAR2(15),
68 currency_code VARCHAR2(15),
69 precision NUMBER,
70 fy_name VARCHAR2(30),
71 period VARCHAR2(15),
72 period_name VARCHAR2(15),
73 period_counter NUMBER,
74 period_open_date DATE,
75 period_close_date DATE,
76 period_fy NUMBER,
77 cat_flex_struct NUMBER,
78 loc_flex_struct NUMBER,
79 assetkey_flex_struct NUMBER,
80 acct_flex_struct NUMBER,
81 bal_segnum NUMBER,
82 acct_segnum NUMBER,
83 acct_appl_col VARCHAR2(30),
84 acct_segname VARCHAR2(30),
85 acct_prompt VARCHAR2(80),
86 acct_valueset_name VARCHAR2(60),
87 cc_segnum NUMBER,
88 ccid NUMBER,
89 concat_acct_str VARCHAR2(500),
90 acct_all_segs fa_rx_shared_pkg.seg_array,
91 account_description VARCHAR2(240),
92 fy NUMBER,
93 asset_cost_acct VARCHAR2(25),
94 deprn_rsv_acct VARCHAR2(25),
95 asset_number VARCHAR2(15),
96 description VARCHAR2(80),
97 tag_number VARCHAR2(15),
98 serial_number VARCHAR2(35),
99 inventorial VARCHAR2(3),
100 date_placed_in_service DATE,
101 method_code VARCHAR2(15),
102 life NUMBER,
103 life_yr_mo VARCHAR2(20),
104 rate NUMBER,
105 bonus_rate NUMBER,
106 capacity NUMBER,
107 cost NUMBER,
108 deprn_amount NUMBER,
109 ytd_deprn NUMBER,
110 reserve NUMBER,
111 percent NUMBER,
112 transaction_type VARCHAR2(1),
113 location_id NUMBER,
114 concat_loc_str VARCHAR2(500),
115 loc_segs fa_rx_shared_pkg.seg_array,
116 category_id NUMBER,
117 concat_cat_str VARCHAR2(500),
118 cat_segs fa_rx_shared_pkg.seg_array,
119 asset_key_ccid NUMBER,
120 concat_key_str VARCHAR2(500),
121 key_segs fa_rx_shared_pkg.seg_array,
122 company_description VARCHAR2(240),
123 expense_acct_description VARCHAR2(240),
124 cost_center_description VARCHAR2(240),
125 category_description VARCHAR2(240),
126 emp_name VARCHAR2(240),
127 emp_number VARCHAR2(30),
128 units NUMBER,
129 organization_name VARCHAR2(30),
130 chart_of_accounts_id NUMBER,
131 nbv NUMBER,
132 nbv_beginning_fy NUMBER,
133 set_of_books_id NUMBER,
134 major_category VARCHAR2(240),
135 minor_category VARCHAR2(240),
136 major_category_desc VARCHAR2(240),
137 minor_category_desc VARCHAR2(240),
138 cat_seg_num VARCHAR2(15),
139 specified_cat_seg VARCHAR2(240),
140 specified_cat_seg_desc VARCHAR2(240),
141 reserve_acct VARCHAR2(25),
142 reserve_acct_desc VARCHAR2(240),
143 date_idled DATE,
144 asset_id NUMBER,
145 group_asset_id NUMBER,
146 group_asset_number VARCHAR2(15),
147 report_style VARCHAR2(1),
148 salvage_value NUMBER,
149 login_id NUMBER,
150 user_id NUMBER,
151 calendar_period_open_date DATE, -- Bug3499862
152 calendar_period_close_date DATE, -- Bug3499862
153 impairment_reserve NUMBER --Bug10412874
154 );
155
156 var var_t;
157 END FARX_DP;