1 PACKAGE GL_MC_INQUIRY_PKG AUTHID CURRENT_USER AS
2 /* $Header: glmcinqs.pls 120.2 2004/12/07 03:11:39 lpoon noship $ */
3 TYPE id_arr IS TABLE OF NUMBER (15);
4
5 TYPE var_arr1 IS TABLE OF VARCHAR2 (1);
6
7 TYPE var_arr15 IS TABLE OF VARCHAR2 (15);
8
9 TYPE var_arr20 IS TABLE OF VARCHAR2 (20);
10
11 TYPE var_arr30 IS TABLE OF VARCHAR2 (30);
12
13 TYPE date_arr IS TABLE OF DATE;
14
15 TYPE num_arr IS TABLE OF NUMBER;
16
17 /* All attributes of this type of record are table of scalar type
18 (NUMBER/VARCHAR2), so we can use it for BULK COLLECT */
19 TYPE r_fa_bulk_data IS RECORD (
20 asset_id id_arr,
21 sob_currency_code var_arr30,
22 sob_name var_arr30,
23 sob_book_type var_arr1,
24 sob_id id_arr,
25 sob_book_type_code var_arr30,
26 COST num_arr,
27 recoverable_cost num_arr,
28 net_book_value num_arr,
29 original_cost num_arr,
30 salvage_value num_arr,
31 ytd_deprn num_arr,
32 bonus_ytd_deprn num_arr,
33 deprn_reserve num_arr,
34 bonus_deprn_reserve num_arr,
35 reval_ceiling num_arr,
36 reval_reserve num_arr);
37
38 TYPE r_fa_fin_rec IS RECORD (
39 primary_data NUMBER,
40 rsob1 NUMBER,
41 rsob2 NUMBER,
42 rsob3 NUMBER,
43 rsob4 NUMBER,
44 rsob5 NUMBER,
45 rsob6 NUMBER,
46 rsob7 NUMBER,
47 rsob8 NUMBER);
48
49 TYPE r_fa_fin_rec_list IS TABLE OF r_fa_fin_rec;
50
51 -- r_sob_list is same as gl_mc_info.r_sob_list
52 -- Instead of redefining it, just define the subtype
53 SUBTYPE r_sob_list_type IS gl_mc_info.r_sob_list;
54
55 /* All attributes of this type of record are table of scalar type
56 (NUMBER/VARCHAR2), so we can use it for BULK COLLECT */
57 /* TYPE r_sob_rec_col IS RECORD (
58 r_sob_id id_arr,
59 r_sob_name var_arr30,
60 r_sob_type var_arr1,
61 r_sob_curr var_arr15,
62 r_sob_user_type var_arr15,
63 r_sob_short_name var_arr20,
64 r_sob_start_date date_arr,
65 r_sob_end_date date_arr);
66
67 TYPE r_sob_rec IS RECORD (
68 r_sob_id NUMBER (15),
69 r_sob_name VARCHAR2 (30),
70 r_sob_type VARCHAR2 (1),
71 r_sob_curr VARCHAR2 (15),
72 r_sob_user_type VARCHAR2 (15),
73 r_sob_short_name VARCHAR2 (20),
74 r_sob_start_date DATE,
75 r_sob_end_date DATE);
76
77 TYPE r_sob_list IS TABLE OF r_sob_rec;
78 */
79 FUNCTION mrc_enabled(n_application_id NUMBER, n_primary_sob_id NUMBER, n_org_id NUMBER)
80 RETURN BOOLEAN;
81 PROCEDURE query_balances (
82 x_asset_id NUMBER,
83 x_book VARCHAR2,
84 x_period_ctr NUMBER DEFAULT 0,
85 x_dist_id NUMBER DEFAULT 0,
86 -- Bug fix 3975695: Remove the default string value
87 x_run_mode VARCHAR2 DEFAULT NULL
88 );
89
90 PROCEDURE add_adj_to_deprn (
91 x_adj_drs IN OUT NOCOPY fa_std_types.fa_deprn_row_struct,
92 x_dest_drs IN OUT NOCOPY fa_std_types.fa_deprn_row_struct,
93 x_book_type VARCHAR2,
94 x_book_id IN NUMBER,
95 x_calling_fn VARCHAR2
96 );
97
98 PROCEDURE query_balances_int (
99 x_dpr_row IN OUT NOCOPY fa_std_types.fa_deprn_row_struct,
100 x_run_mode VARCHAR2,
101 x_book_type IN VARCHAR2,
102 x_book_id IN NUMBER,
103 x_calling_fn VARCHAR2,
104 x_original_cost IN OUT NOCOPY NUMBER,
105 x_salvage_value IN OUT NOCOPY NUMBER,
106 x_reval_ceiling IN OUT NOCOPY NUMBER,
107 x_reval_reserve IN OUT NOCOPY NUMBER,
108 x_cost IN OUT NOCOPY NUMBER,
109 x_recoverable_cost IN OUT NOCOPY NUMBER,
110 x_transaction_header_id IN NUMBER DEFAULT -1
111 );
112
113 PROCEDURE get_period_info (
114 x_book VARCHAR2,
115 x_cur_per_ctr IN OUT NOCOPY NUMBER,
116 x_cur_fy IN OUT NOCOPY NUMBER,
117 x_num_pers_fy IN OUT NOCOPY NUMBER,
118 x_book_type IN VARCHAR2,
119 x_book_id IN NUMBER,
120 x_calling_fn VARCHAR2
121 );
122
123 PROCEDURE query_deprn_summary (
124 x_dpr_row IN OUT NOCOPY fa_std_types.fa_deprn_row_struct,
125 x_found_per_ctr IN OUT NOCOPY NUMBER,
126 x_run_mode VARCHAR2,
127 x_book_type IN VARCHAR2,
128 x_book_id IN NUMBER,
129 x_original_cost IN OUT NOCOPY NUMBER,
130 x_salvage_value IN OUT NOCOPY NUMBER,
131 x_reval_ceiling IN OUT NOCOPY NUMBER,
132 x_reval_reserve IN OUT NOCOPY NUMBER,
133 x_cost IN OUT NOCOPY NUMBER,
134 x_recoverable_cost IN OUT NOCOPY NUMBER,
135 x_calling_fn VARCHAR2
136 );
137
138 PROCEDURE get_adjustments_info (
139 x_adj_row IN OUT NOCOPY fa_std_types.fa_deprn_row_struct,
140 x_found_per_ctr IN OUT NOCOPY NUMBER,
141 x_run_mode VARCHAR2,
142 x_transaction_header_id NUMBER,
143 x_book_type IN VARCHAR2,
144 x_book_id IN NUMBER,
145 x_calling_fn VARCHAR2
146 );
147
148 PROCEDURE ar_init_cash_receipts (p_cash_receipt_id IN NUMBER);
149
150 PROCEDURE init_invoice (l_inv_id IN NUMBER);
151
152 PROCEDURE init_payment (l_pay_id IN NUMBER);
153
154 PROCEDURE transaction_balances(
155 p_customer_trx_id IN Number
156 );
157
158 -- R11i.X Changes - replace r_sob_list by r_sob_list_type
159 PROCEDURE get_associated_sobs(
160 n_sob_id IN NUMBER,
161 n_appl_id IN NUMBER,
162 n_org_id IN NUMBER,
163 n_fa_book_code IN VARCHAR2,
164 n_num_rec IN NUMBER DEFAULT NULL,
165 n_sob_list IN OUT NOCOPY r_sob_list_type
166 );
167
168 END gl_mc_inquiry_pkg;