1 PACKAGE ar_calc_aging AS
2 /* $Header: ARRECONS.pls 120.6 2006/06/07 08:33:01 salladi ship $ */
3
4 /* Global variables */
5
6 ca_sob_type VARCHAR2(1) := 'P';
7 g_reporting_entity_id NUMBER;
8
9 /*========================================================================+
10 Function which returns the global variable g_reporting_entity_id
11 ========================================================================*/
12
13 FUNCTION get_reporting_entity_id return NUMBER;
14
15 PROCEDURE initialize;
16
17 FUNCTION flex_sql(
18 p_application_id in number,
19 p_id_flex_code in varchar2,
20 p_id_flex_num in number default null,
21 p_table_alias in varchar2,
22 p_mode in varchar2,
23 p_qualifier in varchar2,
24 p_function in varchar2 default null,
25 p_operand1 in varchar2 default null,
26 p_operand2 in varchar2 default null) return varchar2;
27
28
29
30 FUNCTION get_value(
31 p_application_id in number,
32 p_id_flex_code in varchar2,
33 p_id_flex_num in number default NULL,
34 p_qualifier in varchar2,
35 p_ccid in number) return varchar2;
36
37
38
39 FUNCTION get_description(
40 p_application_id in number,
41 p_id_flex_code in varchar2,
42 p_id_flex_num in number default NULL,
43 p_qualifier in varchar2,
44 p_data in varchar2) return varchar2;
45
46 /* Bug 3940958
47 AR Reconciliation Process Enhancements */
48 PROCEDURE aging_as_of(
49 p_as_of_date_from IN DATE,
50 p_as_of_date_to IN DATE,
51 p_reporting_level IN VARCHAR2,
52 p_reporting_entity_id IN NUMBER,
53 p_co_seg_low IN VARCHAR2,
54 p_co_seg_high IN VARCHAR2,
55 p_coa_id IN NUMBER,
56 p_begin_bal OUT NOCOPY NUMBER,
57 p_end_bal OUT NOCOPY NUMBER,
58 p_acctd_begin_bal OUT NOCOPY NUMBER,
59 p_acctd_end_bal OUT NOCOPY NUMBER);
60
61 PROCEDURE adjustment_register(p_gl_date_low IN DATE ,
62 p_gl_date_high IN DATE,
63 p_reporting_level IN VARCHAR2,
64 p_reporting_entity_id IN NUMBER,
65 p_co_seg_low IN VARCHAR2,
66 p_co_seg_high IN VARCHAR2,
67 p_coa_id IN NUMBER,
68 p_fin_chrg_amount OUT NOCOPY NUMBER,
69 p_fin_chrg_acctd_amount OUT NOCOPY NUMBER,
70 p_adj_amount OUT NOCOPY NUMBER,
71 p_adj_acctd_amount OUT NOCOPY NUMBER,
72 p_guar_amount OUT NOCOPY NUMBER,
73 p_guar_acctd_amount OUT NOCOPY NUMBER,
74 p_dep_amount OUT NOCOPY NUMBER,
75 p_dep_acctd_amount OUT NOCOPY NUMBER,
76 p_endorsmnt_amount OUT NOCOPY NUMBER,
77 p_endorsmnt_acctd_amount OUT NOCOPY NUMBER );
78
79 PROCEDURE transaction_register(p_gl_date_low IN DATE,
80 p_gl_date_high IN DATE,
81 p_reporting_level IN VARCHAR2,
82 p_reporting_entity_id IN NUMBER,
83 p_co_seg_low IN VARCHAR2,
84 p_co_seg_high IN VARCHAR2,
85 p_coa_id IN NUMBER,
86 p_non_post_amount OUT NOCOPY NUMBER,
87 p_non_post_acctd_amount OUT NOCOPY NUMBER,
88 p_post_amount OUT NOCOPY NUMBER ,
89 p_post_acctd_amount OUT NOCOPY NUMBER );
90
91 PROCEDURE rounding_diff(l_gl_date_low IN DATE,
92 l_gl_date_high IN DATE,
93 l_rounding_diff OUT NOCOPY NUMBER ) ;
94
95 PROCEDURE cash_receipts_register(p_gl_date_low IN DATE ,
96 p_gl_date_high IN DATE,
97 p_reporting_level IN VARCHAR2,
98 p_reporting_entity_id IN NUMBER,
99 p_co_seg_low IN VARCHAR2,
100 p_co_seg_high IN VARCHAR2,
101 p_coa_id IN NUMBER,
102 p_unapp_amount OUT NOCOPY NUMBER,
103 p_unapp_acctd_amount OUT NOCOPY NUMBER,
104 p_acc_amount OUT NOCOPY NUMBER,
105 p_acc_acctd_amount OUT NOCOPY NUMBER,
106 p_claim_amount OUT NOCOPY NUMBER,
107 p_claim_acctd_amount OUT NOCOPY NUMBER,
108 p_prepay_amount OUT NOCOPY NUMBER,
109 p_prepay_acctd_amount OUT NOCOPY NUMBER,
110 p_app_amount OUT NOCOPY NUMBER,
111 p_app_acctd_amount OUT NOCOPY NUMBER,
112 p_edisc_amount OUT NOCOPY NUMBER,
113 p_edisc_acctd_amount OUT NOCOPY NUMBER,
114 p_unedisc_amount OUT NOCOPY NUMBER,
115 p_unedisc_acctd_amount OUT NOCOPY NUMBER,
116 p_cm_gain_loss OUT NOCOPY NUMBER,
117 p_on_acc_cm_ref_amount OUT NOCOPY NUMBER, /*bug4173702*/
118 p_on_acc_cm_ref_acctd_amount OUT NOCOPY NUMBER ) ;
119
120 PROCEDURE invoice_exceptions( p_gl_date_low IN DATE,
121 p_gl_date_high IN DATE,
122 p_reporting_level IN VARCHAR2,
123 p_reporting_entity_id IN NUMBER,
124 p_co_seg_low IN VARCHAR2,
125 p_co_seg_high IN VARCHAR2,
126 p_coa_id IN NUMBER,
127 p_post_excp_amount OUT NOCOPY NUMBER,
128 p_post_excp_acctd_amount OUT NOCOPY NUMBER,
129 p_nonpost_excp_amount OUT NOCOPY NUMBER,
130 p_nonpost_excp_acctd_amount OUT NOCOPY NUMBER);
131
132 FUNCTION begin_or_end_bal( p_gl_date IN DATE,
133 p_gl_date_closed IN DATE,
134 p_activity_date IN DATE,
135 p_as_of_date IN DATE
136 )RETURN NUMBER;
137
138 PROCEDURE journal_reports( p_gl_date_low IN DATE,
139 p_gl_date_high IN DATE,
140 p_reporting_level IN VARCHAR2,
141 p_reporting_entity_id IN NUMBER,
142 p_co_seg_low IN VARCHAR2,
143 p_co_seg_high IN VARCHAR2,
144 p_coa_id IN NUMBER,
145 p_sales_journal_amt OUT NOCOPY NUMBER,
146 p_sales_journal_acctd_amt OUT NOCOPY NUMBER,
147 p_adj_journal_amt OUT NOCOPY NUMBER,
148 p_adj_journal_acctd_amt OUT NOCOPY NUMBER,
149 p_app_journal_amt OUT NOCOPY NUMBER,
150 p_app_journal_acctd_amt OUT NOCOPY NUMBER,
151 p_unapp_journal_amt OUT NOCOPY NUMBER,
152 p_unapp_journal_acctd_amt OUT NOCOPY NUMBER,
153 p_cm_journal_acctd_amt OUT NOCOPY NUMBER);
154
155 PROCEDURE get_report_heading ( p_reporting_level IN VARCHAR2,
156 p_reporting_entity_id IN NUMBER,
157 p_set_of_books_id IN NUMBER,
158 p_sob_name OUT NOCOPY VARCHAR2,
159 p_functional_currency OUT NOCOPY VARCHAR2,
160 p_coa_id OUT NOCOPY NUMBER,
161 p_precision OUT NOCOPY NUMBER,
162 p_sysdate OUT NOCOPY VARCHAR2,
163 p_organization OUT NOCOPY VARCHAR2,
164 p_bills_receivable_flag OUT NOCOPY VARCHAR2);
165 END ar_calc_aging ;