[Home] [Help]
PACKAGE: APPS.IEX_COLL_IND
Source
1 PACKAGE IEX_COLL_IND AUTHID CURRENT_USER AS
2 /* $Header: iexvmtis.pls 120.2 2011/09/21 09:08:38 pnaveenk ship $ */
3 --
4 --System parameter record can be modified based on info required
5 --
6 TYPE curr_rec_type IS RECORD (
7 set_of_books_id ar_system_parameters.set_of_books_id%TYPE ,
8 base_currency gl_sets_of_books.currency_code%TYPE ,
9 base_precision fnd_currencies.precision%type ,
10 base_min_acc_unit fnd_currencies.minimum_accountable_unit%type ,
11 past_year_from DATE,
12 past_year_to DATE
13 );
14
15 g_curr_rec curr_rec_type;
16
17 FUNCTION GET_WTD_DAYS_LATE(p_party_id IN NUMBER,
18 p_cust_account_id IN NUMBER,
19 p_customer_site_use_id IN NUMBER) RETURN VARCHAR2;
20
21 FUNCTION GET_WTD_DAYS_PAID(p_party_id IN NUMBER,
22 p_cust_account_id IN NUMBER,
23 p_customer_site_use_id IN NUMBER) RETURN VARCHAR2;
24
25 FUNCTION GET_WTD_DAYS_TERMS(p_party_id IN NUMBER,
26 p_cust_account_id IN NUMBER,
27 p_customer_site_use_id IN NUMBER) RETURN VARCHAR2;
28
29 FUNCTION GET_AVG_DAYS_LATE(p_party_id IN NUMBER,
30 p_cust_account_id IN NUMBER,
31 p_customer_site_use_id IN NUMBER) RETURN VARCHAR2;
32
33 FUNCTION GET_CEI(p_party_id IN NUMBER,
34 p_cust_account_id IN NUMBER,
35 p_customer_site_use_id IN NUMBER) RETURN VARCHAR2;
36
37 FUNCTION GET_TRUE_DSO(p_party_id IN NUMBER,
38 p_cust_account_id IN NUMBER,
39 p_customer_site_use_id IN NUMBER) RETURN VARCHAR2;
40
41 FUNCTION GET_CONV_DSO(p_party_id IN NUMBER,
42 p_cust_account_id IN NUMBER,
43 p_customer_site_use_id IN NUMBER) RETURN VARCHAR2;
44
45 FUNCTION GET_NSF_STOP_PMT_COUNT(p_party_id IN NUMBER,
46 p_cust_account_id IN NUMBER,
47 p_customer_site_use_id IN NUMBER) RETURN VARCHAR2;
48
49 FUNCTION GET_NSF_STOP_PMT_AMOUNT(p_party_id IN NUMBER,
50 p_cust_account_id IN NUMBER,
51 p_customer_site_use_id IN NUMBER) RETURN VARCHAR2;
52
53 FUNCTION GET_SALES(p_party_id IN NUMBER,
54 p_cust_account_id IN NUMBER,
55 p_customer_site_use_id IN NUMBER) RETURN VARCHAR2;
56
57 FUNCTION GET_DEDUCTION(p_party_id IN NUMBER,
58 p_cust_account_id IN NUMBER,
59 p_customer_site_use_id IN NUMBER) RETURN VARCHAR2;
60
61 FUNCTION COMP_TOT_REC(p_start_date IN DATE,
62 p_end_date IN DATE,
63 p_party_id IN NUMBER,
64 p_cust_account_id IN NUMBER,
65 p_customer_site_use_id IN NUMBER) RETURN NUMBER;
66
67 FUNCTION COMP_REM_REC(p_start_date IN DATE,
68 p_end_date IN DATE,
69 p_party_id IN NUMBER,
70 p_cust_account_id IN NUMBER,
71 p_customer_site_use_id IN NUMBER) RETURN NUMBER;
72
73 FUNCTION COMP_CURR_REC(p_start_date IN DATE,
74 p_end_date IN DATE,
75 p_party_id IN NUMBER,
76 p_cust_account_id IN NUMBER,
77 p_customer_site_use_id IN NUMBER) RETURN NUMBER;
78
79 FUNCTION GET_APPS_TOTAL(p_payment_schedule_id IN NUMBER,
80 p_to_date IN DATE) RETURN NUMBER;
81
82 FUNCTION GET_ADJ_TOTAL(p_payment_schedule_id IN NUMBER,
83 p_to_date IN DATE) RETURN NUMBER;
84
85 FUNCTION GET_ADJ_FOR_TOT_REC(p_payment_schedule_id IN NUMBER,
86 p_to_date IN DATE) RETURN NUMBER;
87
88 FUNCTION GET_CREDIT_LIMIT(p_party_id IN NUMBER,
89 p_cust_account_id IN NUMBER,
90 p_customer_site_use_id IN NUMBER) RETURN VARCHAR2;
91
92 FUNCTION GET_HIGH_CREDIT_YTD(p_party_id IN NUMBER,
93 p_cust_account_id IN NUMBER,
94 p_customer_site_use_id IN NUMBER) RETURN VARCHAR2;
95 --bug 12546745 PNAVEENK
96 FUNCTION amount_due_org_ocm(p_party_id number,
97
98 p_cust_account_id number,
99
100 p_customer_site_use_id number,
101
102 p_start_date date,
103
104 p_end_date date) RETURN number;
105
106 function get_adj_total_ocm(p_party_id number,
107
108 p_cust_account_id number,
109
110 p_customer_site_use_id number,
111
112 p_start_date date,
113
114 p_end_date date) return number;
115
116 function comp_rem_rec_ocm(p_party_id number,
117
118 p_cust_account_id number,
119
120 p_customer_site_use_id number,
121
122 p_start_date date,
123
124 p_end_date date) return NUMBER;
125
126 PROCEDURE comp_rem_ar(p_party_id number ,
127 p_cust_account_id NUMBER ,
128 p_customer_site_use_id number,
129 p_beg_ar IN OUT NOCOPY NUMBER,
130 p_end_ar IN OUT NOCOPY NUMBER );
131 function comp_tot_rec_ocm(p_party_id number,
132
133 p_cust_account_id number,
134
135 p_customer_site_use_id number,
136
137 p_start_date date,
138
139 p_end_date date) return NUMBER;
140
141 function get_true_dso_ocm(p_party_id number,
142
143 p_cust_account_id number,
144
145 p_customer_site_use_id number) return varchar2;
146
147 FUNCTION get_conv_dso_ocm(p_party_id number,
148
149 p_cust_account_id number,
150
151 p_customer_site_use_id number) RETURN varchar2;
152
153 FUNCTION get_cei_ocm(p_party_id number,
154
155 p_cust_account_id number,
156
157 p_customer_site_use_id number) RETURN varchar2;
158
159 FUNCTION get_sales_ocm(p_party_id number,
160 p_cust_account_id number,
161 p_customer_site_use_id number) RETURN varchar2;
162 FUNCTION get_deduction_ocm(p_party_id number,
163 p_cust_account_id number,
164 p_customer_site_use_id number) RETURN varchar2;
165 FUNCTION GET_NSF_STOP_PMT_COUNT_ocm(p_party_id IN NUMBER,
166 p_cust_account_id IN NUMBER,
167 p_customer_site_use_id IN NUMBER) RETURN VARCHAR2;
168
169 FUNCTION GET_NSF_STOP_PMT_AMOUNT_ocm(p_party_id IN NUMBER,
170 p_cust_account_id IN NUMBER,
171 p_customer_site_use_id IN NUMBER) RETURN VARCHAR2;
172
173 function get_wt_avg_days_paid_late(p_party_id NUMBER ,
174 p_cust_account_id number,
175 p_customer_site_use_id number) RETURN VARCHAR2;
176 -- bug 12546745
177 END;