1 package ar_bfb_utils_pvt as
2 /* $Header: ARBFBUTS.pls 120.4 2006/09/21 08:58:10 apandit noship $ */
3
4 function get_billing_date (p_billing_cycle_id IN NUMBER,
5 p_billing_date IN DATE) RETURN DATE;
6
7 function get_bill_process_date (p_billing_cycle_id IN NUMBER,
8 p_billing_date IN DATE,
9 p_last_bill_date IN DATE DEFAULT SYSDATE) RETURN DATE;
10
11 function get_due_date ( p_billing_date in DATE,
12 p_payment_term_id in NUMBER) RETURN DATE;
13
14 function is_payment_term_bfb( p_payment_term_id IN NUMBER) RETURN VARCHAR2;
15
16 function is_payment_term_bfb( p_payment_term_name IN VARCHAR2) RETURN VARCHAR2;
17
18 function get_bill_level( p_cust_account_id IN NUMBER,
19 p_site_use_id IN NUMBER DEFAULT NULL) RETURN VARCHAR2;
20
21 function get_billing_cycle (p_payment_term_id in NUMBER) RETURN NUMBER;
22
23 function is_valid_billing_date(p_billing_cycle_id IN NUMBER,
24 p_entered_date IN DATE) RETURN VARCHAR2;
25
26 function get_cycle_type (p_bill_cycle_id IN NUMBER) RETURN VARCHAR2;
27
28 function get_open_rec(p_cust_trx_type_id IN NUMBER) RETURN VARCHAR2;
29
30 function get_default_term( p_trx_type_id IN NUMBER,
31 p_trx_date IN DATE,
32 p_org_id IN NUMBER,
33 p_bill_to_site IN NUMBER,
34 p_bill_to_customer IN NUMBER) RETURN NUMBER;
35
36 procedure validate_and_default_term (p_request_id IN NUMBER,
37 p_error_count IN OUT NOCOPY NUMBER);
38
39 procedure populate(p_billing_cycle_id IN NUMBER);
40
41 end ar_bfb_utils_pvt;