eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBY_BILL_PKG dependencies on IBY_TANGIBLE

Line 14: procedure createBill(i_billId in iby_tangible.tangibleid%type,

10: ** billRefInfo, reference information of the bill
11: ** Memo, some kind of note. CurDef, definition of the currency,
12: ** assings the id of the tangible to io_tangibleid.
13: */
14: procedure createBill(i_billId in iby_tangible.tangibleid%type,
15: i_billAmount in iby_tangible.amount%type,
16: i_billCurDef in iby_tangible.currencyNameCode%type,
17: i_billAcct in iby_tangible.acctno%type,
18: i_billRefInfo in iby_tangible.refinfo%type,

Line 15: i_billAmount in iby_tangible.amount%type,

11: ** Memo, some kind of note. CurDef, definition of the currency,
12: ** assings the id of the tangible to io_tangibleid.
13: */
14: procedure createBill(i_billId in iby_tangible.tangibleid%type,
15: i_billAmount in iby_tangible.amount%type,
16: i_billCurDef in iby_tangible.currencyNameCode%type,
17: i_billAcct in iby_tangible.acctno%type,
18: i_billRefInfo in iby_tangible.refinfo%type,
19: i_billMemo in iby_tangible.memo%type,

Line 16: i_billCurDef in iby_tangible.currencyNameCode%type,

12: ** assings the id of the tangible to io_tangibleid.
13: */
14: procedure createBill(i_billId in iby_tangible.tangibleid%type,
15: i_billAmount in iby_tangible.amount%type,
16: i_billCurDef in iby_tangible.currencyNameCode%type,
17: i_billAcct in iby_tangible.acctno%type,
18: i_billRefInfo in iby_tangible.refinfo%type,
19: i_billMemo in iby_tangible.memo%type,
20: i_billOrderMedium IN iby_tangible.Order_Medium%TYPE,

Line 17: i_billAcct in iby_tangible.acctno%type,

13: */
14: procedure createBill(i_billId in iby_tangible.tangibleid%type,
15: i_billAmount in iby_tangible.amount%type,
16: i_billCurDef in iby_tangible.currencyNameCode%type,
17: i_billAcct in iby_tangible.acctno%type,
18: i_billRefInfo in iby_tangible.refinfo%type,
19: i_billMemo in iby_tangible.memo%type,
20: i_billOrderMedium IN iby_tangible.Order_Medium%TYPE,
21: i_billEftAuthMethod IN iby_tangible.Eft_Auth_Method%TYPE,

Line 18: i_billRefInfo in iby_tangible.refinfo%type,

14: procedure createBill(i_billId in iby_tangible.tangibleid%type,
15: i_billAmount in iby_tangible.amount%type,
16: i_billCurDef in iby_tangible.currencyNameCode%type,
17: i_billAcct in iby_tangible.acctno%type,
18: i_billRefInfo in iby_tangible.refinfo%type,
19: i_billMemo in iby_tangible.memo%type,
20: i_billOrderMedium IN iby_tangible.Order_Medium%TYPE,
21: i_billEftAuthMethod IN iby_tangible.Eft_Auth_Method%TYPE,
22: io_mtangibleid in out nocopy iby_tangible.Mtangibleid%type)

Line 19: i_billMemo in iby_tangible.memo%type,

15: i_billAmount in iby_tangible.amount%type,
16: i_billCurDef in iby_tangible.currencyNameCode%type,
17: i_billAcct in iby_tangible.acctno%type,
18: i_billRefInfo in iby_tangible.refinfo%type,
19: i_billMemo in iby_tangible.memo%type,
20: i_billOrderMedium IN iby_tangible.Order_Medium%TYPE,
21: i_billEftAuthMethod IN iby_tangible.Eft_Auth_Method%TYPE,
22: io_mtangibleid in out nocopy iby_tangible.Mtangibleid%type)
23: is

Line 20: i_billOrderMedium IN iby_tangible.Order_Medium%TYPE,

16: i_billCurDef in iby_tangible.currencyNameCode%type,
17: i_billAcct in iby_tangible.acctno%type,
18: i_billRefInfo in iby_tangible.refinfo%type,
19: i_billMemo in iby_tangible.memo%type,
20: i_billOrderMedium IN iby_tangible.Order_Medium%TYPE,
21: i_billEftAuthMethod IN iby_tangible.Eft_Auth_Method%TYPE,
22: io_mtangibleid in out nocopy iby_tangible.Mtangibleid%type)
23: is
24: cursor c_getMtangibleid is

Line 21: i_billEftAuthMethod IN iby_tangible.Eft_Auth_Method%TYPE,

17: i_billAcct in iby_tangible.acctno%type,
18: i_billRefInfo in iby_tangible.refinfo%type,
19: i_billMemo in iby_tangible.memo%type,
20: i_billOrderMedium IN iby_tangible.Order_Medium%TYPE,
21: i_billEftAuthMethod IN iby_tangible.Eft_Auth_Method%TYPE,
22: io_mtangibleid in out nocopy iby_tangible.Mtangibleid%type)
23: is
24: cursor c_getMtangibleid is
25: select iby_tangible_s.nextval

Line 22: io_mtangibleid in out nocopy iby_tangible.Mtangibleid%type)

18: i_billRefInfo in iby_tangible.refinfo%type,
19: i_billMemo in iby_tangible.memo%type,
20: i_billOrderMedium IN iby_tangible.Order_Medium%TYPE,
21: i_billEftAuthMethod IN iby_tangible.Eft_Auth_Method%TYPE,
22: io_mtangibleid in out nocopy iby_tangible.Mtangibleid%type)
23: is
24: cursor c_getMtangibleid is
25: select iby_tangible_s.nextval
26: from dual;

Line 25: select iby_tangible_s.nextval

21: i_billEftAuthMethod IN iby_tangible.Eft_Auth_Method%TYPE,
22: io_mtangibleid in out nocopy iby_tangible.Mtangibleid%type)
23: is
24: cursor c_getMtangibleid is
25: select iby_tangible_s.nextval
26: from dual;
27: begin
28: /*
29: ** close the cursor if it is already open.

Line 43: insert into iby_tangible( mtangibleId, tangibleid, amount,

39: close c_getMtangibleid;
40: /*
41: ** insert tangible information in iby_bill table.
42: */
43: insert into iby_tangible( mtangibleId, tangibleid, amount,
44: currencyNameCode, acctno, refinfo, memo,issuedate,
45: Order_Medium, Eft_Auth_Method,
46: last_update_date, last_updated_by,
47: creation_date, created_by,

Line 59: ** Purpose: retrieves a tangible from iby_tangible table for a given mtangibleid.

55:
56: end createBill;
57: /*
58: ** Function: modBill
59: ** Purpose: retrieves a tangible from iby_tangible table for a given mtangibleid.
60: ** billacct, corresponds to the account number of the payer
61: ** with payee, billAmount is the amount of the bill,
62: ** billRefInfo, reference information of the bill
63: ** Memo, note from biller. CurDef, definition of the currency,

Line 65: procedure modBill( i_mtangibleid in iby_tangible.Mtangibleid%type,

61: ** with payee, billAmount is the amount of the bill,
62: ** billRefInfo, reference information of the bill
63: ** Memo, note from biller. CurDef, definition of the currency,
64: */
65: procedure modBill( i_mtangibleid in iby_tangible.Mtangibleid%type,
66: i_billId in iby_tangible.tangibleid%type,
67: i_billAmount in iby_tangible.amount%type,
68: i_billCurDef in iby_tangible.currencyNameCode%type,
69: i_billAcct in iby_tangible.acctno%type,

Line 66: i_billId in iby_tangible.tangibleid%type,

62: ** billRefInfo, reference information of the bill
63: ** Memo, note from biller. CurDef, definition of the currency,
64: */
65: procedure modBill( i_mtangibleid in iby_tangible.Mtangibleid%type,
66: i_billId in iby_tangible.tangibleid%type,
67: i_billAmount in iby_tangible.amount%type,
68: i_billCurDef in iby_tangible.currencyNameCode%type,
69: i_billAcct in iby_tangible.acctno%type,
70: i_billRefInfo in iby_tangible.refinfo%type,

Line 67: i_billAmount in iby_tangible.amount%type,

63: ** Memo, note from biller. CurDef, definition of the currency,
64: */
65: procedure modBill( i_mtangibleid in iby_tangible.Mtangibleid%type,
66: i_billId in iby_tangible.tangibleid%type,
67: i_billAmount in iby_tangible.amount%type,
68: i_billCurDef in iby_tangible.currencyNameCode%type,
69: i_billAcct in iby_tangible.acctno%type,
70: i_billRefInfo in iby_tangible.refinfo%type,
71: i_billMemo in iby_tangible.memo%type,

Line 68: i_billCurDef in iby_tangible.currencyNameCode%type,

64: */
65: procedure modBill( i_mtangibleid in iby_tangible.Mtangibleid%type,
66: i_billId in iby_tangible.tangibleid%type,
67: i_billAmount in iby_tangible.amount%type,
68: i_billCurDef in iby_tangible.currencyNameCode%type,
69: i_billAcct in iby_tangible.acctno%type,
70: i_billRefInfo in iby_tangible.refinfo%type,
71: i_billMemo in iby_tangible.memo%type,
72: i_billOrderMedium IN iby_tangible.Order_Medium%TYPE,

Line 69: i_billAcct in iby_tangible.acctno%type,

65: procedure modBill( i_mtangibleid in iby_tangible.Mtangibleid%type,
66: i_billId in iby_tangible.tangibleid%type,
67: i_billAmount in iby_tangible.amount%type,
68: i_billCurDef in iby_tangible.currencyNameCode%type,
69: i_billAcct in iby_tangible.acctno%type,
70: i_billRefInfo in iby_tangible.refinfo%type,
71: i_billMemo in iby_tangible.memo%type,
72: i_billOrderMedium IN iby_tangible.Order_Medium%TYPE,
73: i_billEftAuthMethod IN iby_tangible.Eft_Auth_Method%TYPE)

Line 70: i_billRefInfo in iby_tangible.refinfo%type,

66: i_billId in iby_tangible.tangibleid%type,
67: i_billAmount in iby_tangible.amount%type,
68: i_billCurDef in iby_tangible.currencyNameCode%type,
69: i_billAcct in iby_tangible.acctno%type,
70: i_billRefInfo in iby_tangible.refinfo%type,
71: i_billMemo in iby_tangible.memo%type,
72: i_billOrderMedium IN iby_tangible.Order_Medium%TYPE,
73: i_billEftAuthMethod IN iby_tangible.Eft_Auth_Method%TYPE)
74: is

Line 71: i_billMemo in iby_tangible.memo%type,

67: i_billAmount in iby_tangible.amount%type,
68: i_billCurDef in iby_tangible.currencyNameCode%type,
69: i_billAcct in iby_tangible.acctno%type,
70: i_billRefInfo in iby_tangible.refinfo%type,
71: i_billMemo in iby_tangible.memo%type,
72: i_billOrderMedium IN iby_tangible.Order_Medium%TYPE,
73: i_billEftAuthMethod IN iby_tangible.Eft_Auth_Method%TYPE)
74: is
75: begin

Line 72: i_billOrderMedium IN iby_tangible.Order_Medium%TYPE,

68: i_billCurDef in iby_tangible.currencyNameCode%type,
69: i_billAcct in iby_tangible.acctno%type,
70: i_billRefInfo in iby_tangible.refinfo%type,
71: i_billMemo in iby_tangible.memo%type,
72: i_billOrderMedium IN iby_tangible.Order_Medium%TYPE,
73: i_billEftAuthMethod IN iby_tangible.Eft_Auth_Method%TYPE)
74: is
75: begin
76: update iby_tangible

Line 73: i_billEftAuthMethod IN iby_tangible.Eft_Auth_Method%TYPE)

69: i_billAcct in iby_tangible.acctno%type,
70: i_billRefInfo in iby_tangible.refinfo%type,
71: i_billMemo in iby_tangible.memo%type,
72: i_billOrderMedium IN iby_tangible.Order_Medium%TYPE,
73: i_billEftAuthMethod IN iby_tangible.Eft_Auth_Method%TYPE)
74: is
75: begin
76: update iby_tangible
77: set amount = i_billAmount,

Line 76: update iby_tangible

72: i_billOrderMedium IN iby_tangible.Order_Medium%TYPE,
73: i_billEftAuthMethod IN iby_tangible.Eft_Auth_Method%TYPE)
74: is
75: begin
76: update iby_tangible
77: set amount = i_billAmount,
78: currencyNameCode = i_billCurDef,
79: acctno = i_billAcct,
80: refinfo = i_billRefInfo,