1 PACKAGE Okl_Stream_Billing_Pvt AUTHID CURRENT_USER AS
2 /* $Header: OKLRBSTS.pls 120.6 2008/02/07 13:15:10 zrehman ship $ */
3
4
5 G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKL_STREAM_BILLING_PVT';
6
7 -- -------------------------------------------------------------------------
8 -- Billing data structure
9 -- -------------------------------------------------------------------------
10 TYPE bill_rec_type IS RECORD (
11 khr_id okc_k_headers_b.id%TYPE,
12 bill_date okl_strm_elements.stream_element_date%TYPE,
13 kle_id okl_streams.kle_id%TYPE,
14 sel_id okl_strm_elements.id%TYPE,
15 sty_id okl_streams.sty_id%TYPE,
16 contract_number okc_k_headers_b.contract_number%TYPE,
17 currency_code okc_k_headers_b.currency_code%TYPE,
18 authoring_org_id okc_k_headers_b.authoring_org_id%TYPE,
19 sty_name okl_strm_type_v.NAME%TYPE,
20 taxable_default_yn okl_strm_type_v.taxable_default_yn%TYPE,
21 amount okl_strm_elements.amount%TYPE,
22 sts_code okc_k_headers_b.sts_code%TYPE);
23
24 TYPE bill_tbl_type IS TABLE OF bill_rec_type
25 INDEX BY BINARY_INTEGER;
26
27 -- ----------------------------------------------------------------
28 -- Procedure Process_bill_tbl to bill outstanding stream elements
29 -- ----------------------------------------------------------------
30 PROCEDURE Process_bill_tbl
31 (p_api_version IN NUMBER
32 ,p_init_msg_list IN VARCHAR2
33 ,x_return_status OUT NOCOPY VARCHAR2
34 ,x_msg_count OUT NOCOPY NUMBER
35 ,x_msg_data OUT NOCOPY VARCHAR2
36 ,p_commit IN VARCHAR2
37 ,p_contract_number IN VARCHAR2 DEFAULT NULL
38 ,p_from_bill_date IN DATE DEFAULT NULL
39 ,p_to_bill_date IN DATE DEFAULT NULL
40 ,p_bill_tbl IN bill_tbl_type
41 ,p_source IN VARCHAR2 DEFAULT 'STREAM_BILLING'
42 ,p_end_of_records IN VARCHAR2 DEFAULT NULL);
43
44 -- ----------------------------------------------------------------
45 -- Procedure BIL_STREAMS to bill outstanding stream elements
46 -- ----------------------------------------------------------------
47 PROCEDURE bill_streams
48 (p_api_version IN NUMBER
49 ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
50 ,x_return_status OUT NOCOPY VARCHAR2
51 ,x_msg_count OUT NOCOPY NUMBER
52 ,x_msg_data OUT NOCOPY VARCHAR2
53 ,p_commit IN VARCHAR2 DEFAULT Fnd_Api.G_FALSE
54 ,p_ia_contract_type IN VARCHAR2 DEFAULT NULL --modified by zrehman for Bug#6788005 on 01-Feb-2008
55 ,p_contract_number IN VARCHAR2 DEFAULT NULL
56 ,p_from_bill_date IN DATE DEFAULT NULL
57 ,p_to_bill_date IN DATE DEFAULT NULL
58 ,p_cust_acct_id IN NUMBER DEFAULT NULL
59 ,p_inv_cust_acct_id IN NUMBER DEFAULT NULL --modified by zrehman for Bug#6788005 on 01-Feb-2008
60 ,p_assigned_process IN VARCHAR2 DEFAULT NULL
61 ,p_source IN VARCHAR2 DEFAULT 'STREAM_BILLING'
62 );
63
64 -- ---------------------------------------------------------------------------
65 -- Function GET_PRINTING_LEAD_DAYS to extract lead days for invoice generation
66 -- ---------------------------------------------------------------------------
67 FUNCTION get_printing_lead_days
68 (p_khr_id NUMBER) RETURN NUMBER;
69
70 PRAGMA RESTRICT_REFERENCES(get_printing_lead_days, WNDS);
71
72 -- ---------------------------------------------------------------------------
73 -- Function GET_BANKRUPTCY_STATUS to get the bankruptcy status of a contract.
74 -- It also returns the disposition code.
75 -- ---------------------------------------------------------------------------
76 FUNCTION get_bankruptcy_status
77 (p_khr_id NUMBER
78 ,x_disposition_code OUT NOCOPY VARCHAR2) RETURN VARCHAR2;
79
80 END Okl_Stream_Billing_Pvt;