1 PACKAGE BODY GL_MC_INQUIRY_PKG AS
2 /* $Header: glmcinqb.pls 120.5 2006/01/13 12:13:49 jvarkey noship $ */
3
4 -- WRONG!! need to pass fa_book_type_code???
5 FUNCTION mrc_enabled(
6 n_application_id NUMBER,
7 n_primary_sob_id NUMBER,
8 n_org_id NUMBER)
9 RETURN BOOLEAN IS
10 BEGIN
11 RETURN(FALSE);
12 END;
13
14 --
15 -- PROCEDURE : get_associated_sobs
16 -- PARAMETERS : n_sob_id (IN) -- Primary SOB ID
17 -- n_appl_id (IN) -- Application ID
18 -- n_org_id (IN) -- Org ID
19 -- n_fa_book_code (IN) -- FA BOOK Code
20 -- n_sob_list (IN OUT) -- r_sob_list_type
21 -- DESCRIPTION : Set of Books Array
22 --
23 PROCEDURE get_associated_sobs(
24 n_sob_id IN NUMBER,
25 n_appl_id IN NUMBER,
26 n_org_id IN NUMBER,
27 n_fa_book_code IN VARCHAR2,
28 n_num_rec IN NUMBER,
29 n_sob_list IN OUT NOCOPY r_sob_list_type) IS
30 BEGIN
31 null;
32 END get_associated_sobs;
33
34 PROCEDURE query_balances(
35 x_asset_id NUMBER,
36 x_book VARCHAR2,
37 x_period_ctr NUMBER ,
38 x_dist_id NUMBER ,
39 x_run_mode VARCHAR2 ) IS
40 BEGIN
41 null;
42 END query_balances;
43
44
45 -- Adds the current period's adjustments (ADJ_DRS) to the
46 -- financial info in the most recent depreciation row (DEST_DRS).
47 -- S.B. called right after get_adjustments.
48 -- This should go away in Rel11, where adjustments will update
49 -- deprn rows.
50
51
52 PROCEDURE add_adj_to_deprn(
53 x_adj_drs IN OUT NOCOPY fa_std_types.fa_deprn_row_struct,
54 x_dest_drs IN OUT NOCOPY fa_std_types.fa_deprn_row_struct,
55 x_book_type IN VARCHAR2,
56 x_book_id IN NUMBER,
57 x_calling_fn VARCHAR2) IS
58 BEGIN
59 null;
60 END add_adj_to_deprn;
61
62 PROCEDURE query_balances_int(
63 x_dpr_row IN OUT NOCOPY fa_std_types.fa_deprn_row_struct,
64 x_run_mode VARCHAR2,
65 x_book_type IN VARCHAR2,
66 x_book_id IN NUMBER,
67 x_calling_fn VARCHAR2,
68 x_original_cost IN OUT NOCOPY NUMBER,
69 x_salvage_value IN OUT NOCOPY NUMBER,
70 x_reval_ceiling IN OUT NOCOPY NUMBER,
71 x_reval_reserve IN OUT NOCOPY NUMBER,
72 x_cost IN OUT NOCOPY NUMBER,
73 x_recoverable_cost IN OUT NOCOPY NUMBER,
74 x_transaction_header_id IN NUMBER ) IS
75 BEGIN
76 null;
77 END query_balances_int;
78
79
80 -- This procedure gets info related to the current period:
81 -- period counter, fiscal year, and number of periods in fiscal year
82
83
84
85 PROCEDURE get_period_info(
86 x_book VARCHAR2,
87 x_cur_per_ctr IN OUT NOCOPY NUMBER,
88 x_cur_fy IN OUT NOCOPY NUMBER,
89 x_num_pers_fy IN OUT NOCOPY NUMBER,
90 x_book_type IN VARCHAR2,
91 x_book_id IN NUMBER,
92 x_calling_fn VARCHAR2) IS
93 BEGIN
94 null;
95 END get_period_info;
96
97
98 -- Use this procedure to query summary-level information
99 -- from fa_deprn_summary in given period (or current period if 0)
100
101
102 PROCEDURE query_deprn_summary(
103 x_dpr_row IN OUT NOCOPY fa_std_types.fa_deprn_row_struct,
104 x_found_per_ctr IN OUT NOCOPY NUMBER,
105 x_run_mode VARCHAR2,
106 x_book_type IN VARCHAR2,
107 x_book_id IN NUMBER,
108 x_original_cost IN OUT NOCOPY NUMBER,
109 x_salvage_value IN OUT NOCOPY NUMBER,
110 x_reval_ceiling IN OUT NOCOPY NUMBER,
111 x_reval_reserve IN OUT NOCOPY NUMBER,
112 x_cost IN OUT NOCOPY NUMBER,
113 x_recoverable_cost IN OUT NOCOPY NUMBER,
114 x_calling_fn VARCHAR2) IS
115
116 BEGIN
117 null;
118 END query_deprn_summary;
119
120
121 -- Get info for any adjustments that occurred after the creation of
122 -- the deprn row from which we selected financial info.
123
124 PROCEDURE get_adjustments_info(
125 x_adj_row IN OUT NOCOPY fa_std_types.fa_deprn_row_struct,
126 x_found_per_ctr IN OUT NOCOPY NUMBER,
127 x_run_mode VARCHAR2,
128 x_transaction_header_id NUMBER,
129 x_book_type IN VARCHAR2,
130 x_book_id IN NUMBER,
131 x_calling_fn VARCHAR2) IS
132 BEGIN
133 null;
134 END get_adjustments_info;
135
136 PROCEDURE ar_init_cash_receipts(p_cash_receipt_id IN NUMBER) IS
137 BEGIN
138 null;
139 END;
140
141 PROCEDURE init_invoice(l_inv_id IN NUMBER) IS
142 BEGIN
143 null;
144 END init_invoice;
145
146 PROCEDURE init_payment(l_pay_id IN NUMBER) IS
147
148 BEGIN
149 null;
150 END init_payment;
151
152 PROCEDURE transaction_balances(p_customer_trx_id IN NUMBER) IS
153 BEGIN
154 null;
155 END;
156 END gl_mc_inquiry_pkg;