DBA Data[Home] [Help]

PACKAGE: APPS.AR_BFB_UTILS_PVT

Source


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;