1 PACKAGE IEX_COLL_IND AS
2 /* $Header: iexvmtis.pls 120.0 2005/05/10 20:26:47 acaraujo noship $ */
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 END;