1 PACKAGE igs_fi_bill_extract AS
2 /* $Header: IGSFI61S.pls 120.0 2005/06/01 17:49:35 appldev noship $ */
3
4 -- Change History
5 -- Who When What
6 -- jbegum 24-Sep-02 Bug#2564643 Removed the parameter p_n_subaccount_id
7 -- from the list parameters passed in call of procedure
8 -- billing_extract
9 -- Procedure billing_extract generates the Bill Number and consolidates
10 -- the related Billing information into the extract tables.
11 -- o The input parameters to this process identify the Person and the
12 -- Sub Account for which the Billing needs to be done.
13 -- o It also identifies the period, in terms of Cut Off date, for which
14 -- the Billing is to be carried out. All Outstanding Charges and any new
15 -- Credits against the Sub Account, since the last Bill was generated,
16 -- are picked for creating the new Bill.
17 -- o The user specifies the Due Date, Remittance Address and the Bill To
18 -- Address as billing information. A Bill Number is generated by the
19 -- process and stored as reference information against the Transaction
20 -- records (Charges and Credits) which have been identified to be
21 -- included in the Bill.
22 --
23 PROCEDURE billing_extract
24 (
25 p_n_prsid_grp_id IN NUMBER,
26 p_n_person_id IN NUMBER,
27 p_c_test_mode IN VARCHAR2 DEFAULT 'Y',
28 p_d_cutoff_dt IN DATE,
29 p_d_due_dt IN DATE,
30 p_n_remit_prty_site_id IN NUMBER,
31 p_c_site_usg_type_cd_1 IN VARCHAR2,
32 p_c_site_usg_type_cd_2 IN VARCHAR2,
33 p_c_site_usg_type_cd_3 IN VARCHAR2,
34 p_c_org_id IN VARCHAR2,
35 p_c_status OUT NOCOPY VARCHAR2
36 );
37 --
38 END igs_fi_bill_extract;