DBA Data[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;