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_SCHED dependencies on IBY_TANGIBLE

Line 15: out_acctno out nocopy iby_tangible.acctno%type,

11: out_bankid_to out nocopy iby_ext_bank_accounts_v.bank_party_id%type,
12: out_branchid_to out nocopy iby_ext_bank_accounts_v.branch_party_id%type,
13: out_acctid_to out nocopy iby_ext_bank_accounts_v.ext_bank_account_id%type,
14: out_accttype_to out nocopy iby_accttype.accttype%type,
15: out_acctno out nocopy iby_tangible.acctno%type,
16: out_refinfo out nocopy iby_tangible.refinfo%type,
17: out_memo out nocopy iby_tangible.memo%type,
18: out_currency out nocopy iby_tangible.currencynamecode%type)
19: is

Line 16: out_refinfo out nocopy iby_tangible.refinfo%type,

12: out_branchid_to out nocopy iby_ext_bank_accounts_v.branch_party_id%type,
13: out_acctid_to out nocopy iby_ext_bank_accounts_v.ext_bank_account_id%type,
14: out_accttype_to out nocopy iby_accttype.accttype%type,
15: out_acctno out nocopy iby_tangible.acctno%type,
16: out_refinfo out nocopy iby_tangible.refinfo%type,
17: out_memo out nocopy iby_tangible.memo%type,
18: out_currency out nocopy iby_tangible.currencynamecode%type)
19: is
20: cursor c_userCardInfo (cin_payerinstrid in iby_trans_fi_v.payerinstrid%type) is

Line 17: out_memo out nocopy iby_tangible.memo%type,

13: out_acctid_to out nocopy iby_ext_bank_accounts_v.ext_bank_account_id%type,
14: out_accttype_to out nocopy iby_accttype.accttype%type,
15: out_acctno out nocopy iby_tangible.acctno%type,
16: out_refinfo out nocopy iby_tangible.refinfo%type,
17: out_memo out nocopy iby_tangible.memo%type,
18: out_currency out nocopy iby_tangible.currencynamecode%type)
19: is
20: cursor c_userCardInfo (cin_payerinstrid in iby_trans_fi_v.payerinstrid%type) is
21:

Line 18: out_currency out nocopy iby_tangible.currencynamecode%type)

14: out_accttype_to out nocopy iby_accttype.accttype%type,
15: out_acctno out nocopy iby_tangible.acctno%type,
16: out_refinfo out nocopy iby_tangible.refinfo%type,
17: out_memo out nocopy iby_tangible.memo%type,
18: out_currency out nocopy iby_tangible.currencynamecode%type)
19: is
20: cursor c_userCardInfo (cin_payerinstrid in iby_trans_fi_v.payerinstrid%type) is
21:
22: select ccnumber,

Line 45: from iby_tangible t

41: select acctno,
42: refinfo,
43: memo,
44: currencynamecode
45: from iby_tangible t
46: where t.tangibleid = cin_tangibleid;
47: BEGIN
48: -- get the user's credit card information
49: open c_userCardInfo(in_payerinstrid);

Line 92: out_acctno out nocopy iby_tangible.acctno%type,

88: out_bankid_to out nocopy iby_ext_bank_accounts_v.bank_party_id%type,
89: out_branchid_to out nocopy iby_ext_bank_accounts_v.branch_party_id%type,
90: out_acctid_to out nocopy iby_ext_bank_accounts_v.ext_bank_account_id%type,
91: out_accttype_to out nocopy iby_accttype.accttype%type,
92: out_acctno out nocopy iby_tangible.acctno%type,
93: out_refinfo out nocopy iby_tangible.refinfo%type,
94: out_memo out nocopy iby_tangible.memo%type,
95: out_currency out nocopy iby_tangible.currencynamecode%type)
96: is

Line 93: out_refinfo out nocopy iby_tangible.refinfo%type,

89: out_branchid_to out nocopy iby_ext_bank_accounts_v.branch_party_id%type,
90: out_acctid_to out nocopy iby_ext_bank_accounts_v.ext_bank_account_id%type,
91: out_accttype_to out nocopy iby_accttype.accttype%type,
92: out_acctno out nocopy iby_tangible.acctno%type,
93: out_refinfo out nocopy iby_tangible.refinfo%type,
94: out_memo out nocopy iby_tangible.memo%type,
95: out_currency out nocopy iby_tangible.currencynamecode%type)
96: is
97: cursor c_userBankInfo (cin_payerinstrid in iby_trans_fi_v.payerinstrid%type) is

Line 94: out_memo out nocopy iby_tangible.memo%type,

90: out_acctid_to out nocopy iby_ext_bank_accounts_v.ext_bank_account_id%type,
91: out_accttype_to out nocopy iby_accttype.accttype%type,
92: out_acctno out nocopy iby_tangible.acctno%type,
93: out_refinfo out nocopy iby_tangible.refinfo%type,
94: out_memo out nocopy iby_tangible.memo%type,
95: out_currency out nocopy iby_tangible.currencynamecode%type)
96: is
97: cursor c_userBankInfo (cin_payerinstrid in iby_trans_fi_v.payerinstrid%type) is
98:

Line 95: out_currency out nocopy iby_tangible.currencynamecode%type)

91: out_accttype_to out nocopy iby_accttype.accttype%type,
92: out_acctno out nocopy iby_tangible.acctno%type,
93: out_refinfo out nocopy iby_tangible.refinfo%type,
94: out_memo out nocopy iby_tangible.memo%type,
95: out_currency out nocopy iby_tangible.currencynamecode%type)
96: is
97: cursor c_userBankInfo (cin_payerinstrid in iby_trans_fi_v.payerinstrid%type) is
98:
99: select b.bank_party_id,

Line 124: from iby_tangible t

120: select acctno,
121: refinfo,
122: memo,
123: currencynamecode
124: from iby_tangible t
125: where t.tangibleid = cin_tangibleid;
126: begin
127: -- get the user's bank account information
128: open c_userBankInfo (in_payerinstrid);