[Home] [Help]
PACKAGE: APPS.OKL_CONS_BILL
Source
1 PACKAGE Okl_Cons_Bill AUTHID CURRENT_USER AS
2 /* $Header: OKLRKONS.pls 120.7 2006/11/17 10:24:42 zrehman noship $ */
3 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_CONS_BILL';
4 G_APP_NAME CONSTANT VARCHAR2(3) := Okl_Api.G_APP_NAME;
5 G_NO_DATA_FOUND CONSTANT VARCHAR2(200) := 'NO_DATA_FOUND';
6 G_TOO_MANY_ROWS CONSTANT VARCHAR2(200) := 'TOO_MANY_ROWS';
7 G_OTHERS CONSTANT VARCHAR2(200) := 'OTHERS';
8
9 -- ------------------------------
10 -- Commit frequency
11 -- ------------------------------
12 G_Commit_Max CONSTANT NUMBER := 1000;
13
14 -- -------------------------------------------------------------------------
15 -- Consolidated Billing data structure
16 -- -------------------------------------------------------------------------
17 TYPE cons_bill_rec_type IS RECORD (
18 customer_id okl_ext_sell_invs_v.customer_id%TYPE,
19 currency okl_ext_sell_invs_v.currency_code%TYPE,
20 bill_to_site okl_ext_sell_invs_v.customer_address_id%TYPE,
21 payment_method okl_ext_sell_invs_v.receipt_method_id%TYPE,
22 private_label okl_ext_sell_invs_v.xtrx_private_label%TYPE,
23 date_consolidated okl_ext_sell_invs_v.TRX_DATE%TYPE,
24 contract_id okc_k_headers_b.id%TYPE,
25 contract_number okc_k_headers_b.contract_number%TYPE,
26 inf_id okl_invoice_formats_b.id%TYPE,
27 prev_cons_invoice_num okl_cnsld_ar_hdrs_v.consolidated_invoice_number%TYPE,
28 org_id okl_ext_sell_invs_v.org_id%TYPE,
29 set_of_books_id okl_ext_sell_invs_v.set_of_books_id%TYPE,
30 kle_id okc_k_lines_b.id%TYPE,
31 sty_id okl_strm_type_v.id%TYPE,
32 xsi_id okl_ext_sell_invs_v.id%TYPE,
33 xls_id okl_xtl_sell_invs_v.id%TYPE,
34 amount okl_xtl_sell_invs_v.amount%TYPE,
35 sel_id okl_xtl_sell_invs_v.sel_id%TYPE,
36 legal_entity_id okl_ext_sell_invs_v.legal_entity_id%TYPE -- for LE Uptake project 08-11-2006
37 );
38
39 TYPE cons_bill_tbl_type IS TABLE OF cons_bill_rec_type
40 INDEX BY BINARY_INTEGER;
41
42 TYPE saved_bill_rec_type IS RECORD (
43 l_customer_id okl_ext_sell_invs_v.customer_id%TYPE,
44 l_currency okl_ext_sell_invs_v.currency_code%TYPE,
45 l_bill_to_site okl_ext_sell_invs_v.customer_address_id%TYPE,
46 l_payment_method okl_ext_sell_invs_v.receipt_method_id%TYPE,
47 l_private_label okl_ext_sell_invs_v.xtrx_private_label%TYPE,
48 l_date_consolidated okl_ext_sell_invs_v.TRX_DATE%TYPE,
49 l_saved_format_id okl_invoice_formats_v.id%TYPE,
50 l_saved_prev_cons_num okl_cnsld_ar_hdrs_v.consolidated_invoice_number%TYPE,
51 l_prev_khr_id okc_k_headers_b.id%TYPE,
52 l_line_number NUMBER,
53 l_commit_cnt NUMBER,
54 l_overall_status VARCHAR2(1),
55 l_cnr_id NUMBER,
56 l_lln_id NUMBER,
57 l_cons_inv_num okl_cnsld_ar_hdrs_v.consolidated_invoice_number%TYPE);
58
59 TYPE update_rec_type IS RECORD (
60 cnr_id NUMBER,
61 cons_inv_number okl_cnsld_ar_hdrs_b.consolidated_invoice_number%TYPE,
62 lln_id NUMBER,
63 lsm_id NUMBER,
64 asset_number Okl_Xtl_Sell_Invs_tl.XTRX_ASSET%TYPE,
65 invoice_format OKL_INVOICE_FORMATS_V.NAME%TYPE,
66 line_type okl_invc_line_types_v.NAME%TYPE,
67 private_label Okl_Ext_Sell_Invs_tl.xtrx_private_label%TYPE,
68 sty_name okl_strm_type_v.NAME%TYPE,
69 contract_number okc_k_headers_b.contract_number%TYPE,
70 lsm_amount NUMBER,
71 xsi_id NUMBER,
72 xls_id NUMBER
73 );
74
75 TYPE update_tbl_type IS TABLE OF update_rec_type
76 INDEX BY BINARY_INTEGER;
77
78 PROCEDURE create_cons_bill(
79 p_api_version IN NUMBER,
80 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
81 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
82 x_return_status OUT NOCOPY VARCHAR2,
83 x_msg_count OUT NOCOPY NUMBER,
84 x_msg_data OUT NOCOPY VARCHAR2,
85 p_contract_number IN VARCHAR2 DEFAULT NULL,
86 p_inv_msg IN VARCHAR2 DEFAULT 'TRUE',
87 p_assigned_process IN VARCHAR2 DEFAULT NULL
88 );
89
90 PROCEDURE process_cons_bill_tbl(
91 p_contract_number IN VARCHAR2 DEFAULT NULL,
92 p_api_version IN NUMBER,
93 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
94 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
95 x_return_status OUT NOCOPY VARCHAR2,
96 x_msg_count OUT NOCOPY NUMBER,
97 x_msg_data OUT NOCOPY VARCHAR2,
98 p_cons_bill_tbl IN OUT NOCOPY cons_bill_tbl_type,
99 p_saved_bill_rec IN OUT NOCOPY saved_bill_rec_type,
100 p_update_tbl IN OUT NOCOPY update_tbl_type);
101
102 FUNCTION get_invoice_group(p_khr_id NUMBER)
103 RETURN VARCHAR2;
104
105 PRAGMA RESTRICT_REFERENCES(get_invoice_group, WNDS);
106
107 END Okl_Cons_Bill;