1 package iby_bill_pkg as
2 /*$Header: ibybills.pls 120.2 2005/08/19 01:13:56 jleybovi ship $*/
3
4 G_MAX_TANGIBLEID_LEN CONSTANT NUMBER := 80;
5
6 /*
7 ** Function: createBill
8 ** Purpose: creates a tangible in iby_bill table.
9 ** billacct, corresponds to the account number of the payer
10 ** with payee, billAmount is the amount of the bill,
11 ** billRefInfo, reference information of the bill
12 ** Memo, some kind of note. CurDef, definition of the currency,
13 ** assings the id of the tangible to io_tangibleid.
14 */
15 procedure createBill(i_billId in iby_tangible.tangibleid%type,
16 i_billAmount in iby_tangible.amount%type,
17 i_billCurDef in iby_tangible.currencyNameCode%type,
18 i_billAcct in iby_tangible.acctno%type,
19 i_billRefInfo in iby_tangible.refinfo%type,
20 i_billMemo in iby_tangible.memo%type,
21 i_billOrderMedium IN iby_tangible.Order_Medium%TYPE,
22 i_billEftAuthMethod IN iby_tangible.Eft_Auth_Method%TYPE,
23 io_mtangibleid in out nocopy iby_tangible.Mtangibleid%type);
24 /*
25 ** Function: modBill
26 ** Purpose: retrieves a tangible from iby_tangible table for a given mtangibleid.
27 ** billacct, corresponds to the account number of the payer
28 ** with payee, billAmount is the amount of the bill,
29 ** billRefInfo, reference information of the bill
30 ** Memo, note from biller. CurDef, definition of the currency,
31 */
32 procedure modBill( i_mtangibleid in iby_tangible.Mtangibleid%type,
33 i_billId in iby_tangible.tangibleid%type,
34 i_billAmount in iby_tangible.amount%type,
35 i_billCurDef in iby_tangible.currencyNameCode%type,
36 i_billAcct in iby_tangible.acctno%type,
37 i_billRefInfo in iby_tangible.refinfo%type,
38 i_billMemo in iby_tangible.memo%type,
39 i_billOrderMedium IN iby_tangible.Order_Medium%TYPE,
40 i_billEftAuthMethod IN iby_tangible.Eft_Auth_Method%TYPE);
41 end iby_bill_pkg;