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