1 package iby_sched as
2 /*$Header: ibyscfis.pls 120.2 2005/11/17 01:53:35 syidner noship $*/
3
4 procedure cardInfo (in_payerinstrid in iby_trans_fi_v.payerinstrid%type,
5 in_payeeid in iby_trans_fi_v.payeeid%type,
6 in_tangibleid in iby_trans_fi_v.tangibleid%type,
7 out_ccnumber_from out nocopy iby_creditcard_v.ccnumber%type,
8 out_expdate_from out nocopy iby_creditcard_v.expirydate%type,
9 out_accttype_from out nocopy iby_accttype.accttype%type,
10 out_name out nocopy varchar2,
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
20 procedure bankInfo (in_payerinstrid in iby_trans_fi_v.payerinstrid%type,
21 in_payeeid in iby_trans_fi_v.payeeid%type,
22 in_tangibleid in iby_trans_fi_v.tangibleid%type,
23 out_bankid_from out nocopy iby_ext_bank_accounts_v.bank_party_id%type,
24 out_branchid_from out nocopy iby_ext_bank_accounts_v.branch_party_id%type,
25 out_acctid_from out nocopy iby_ext_bank_accounts_v.ext_bank_account_id%type,
26 out_accttype_from out nocopy iby_accttype.accttype%type,
27 out_name out nocopy varchar2,
28 out_bankid_to out nocopy iby_ext_bank_accounts_v.bank_party_id%type,
29 out_branchid_to out nocopy iby_ext_bank_accounts_v.branch_party_id%type,
30 out_acctid_to out nocopy iby_ext_bank_accounts_v.ext_bank_account_id%type,
31 out_accttype_to out nocopy iby_accttype.accttype%type,
32 out_acctno out nocopy iby_tangible.acctno%type,
33 out_refinfo out nocopy iby_tangible.refinfo%type,
34 out_memo out nocopy iby_tangible.memo%type,
35 out_currency out nocopy iby_tangible.currencynamecode%type);
36
37 procedure update_ecapp (in_ecappid in iby_ecapp.ecappid%type);
38
39 function updPmtStatus (in_psreqid in iby_trxn_fi.psreqid%type,
40 in_dtpmtprc in varchar2, -- YYYMMDD
41 in_pmtprcst in varchar2, -- 'PAID','UNPAID','FAILED','PAYFAILED'
42 in_srvrid in iby_trxn_fi.srvid%type,
43 in_refinfo in iby_trxn_fi.referencecode%type)
44 return number; -- nonzero if rows were updated.
45
46 procedure update_trxn_status( i_unchanged_status IN NUMBER,
47 i_numTrxns IN NUMBER,
48 i_status_arr IN JTF_NUMBER_TABLE,
49 i_errLoc_arr IN JTF_NUMBER_TABLE,
50 i_errCode_arr IN JTF_VARCHAR2_TABLE_100,
51 i_errMsg_arr IN JTF_VARCHAR2_TABLE_300,
52 i_tangibleId_arr IN JTF_VARCHAR2_TABLE_100,
53 i_trxnMId_arr IN JTF_NUMBER_TABLE,
54 i_srvrId_arr IN JTF_VARCHAR2_TABLE_100,
55 i_refCode_arr IN JTF_VARCHAR2_TABLE_100,
56 i_auxMsg_arr IN JTF_VARCHAR2_TABLE_300,
57 i_fee_arr IN JTF_NUMBER_TABLE,
58 o_status_arr OUT NOCOPY JTF_NUMBER_TABLE,
59 o_error_code OUT NOCOPY NUMBER,
60 o_error_msg OUT NOCOPY VARCHAR2
61 );
62
63 end iby_sched;