[Home] [Help]
PACKAGE: APPS.IBY_SCHED
Source
1 package iby_sched AUTHID CURRENT_USER as
2 /*$Header: ibyscfis.pls 120.2.12010000.2 2009/07/07 12:30:19 sugottum ship $*/
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 procedure update_ecapp;
40
41 function updPmtStatus (in_psreqid in iby_trxn_fi.psreqid%type,
42 in_dtpmtprc in varchar2, -- YYYMMDD
43 in_pmtprcst in varchar2, -- 'PAID','UNPAID','FAILED','PAYFAILED'
44 in_srvrid in iby_trxn_fi.srvid%type,
45 in_refinfo in iby_trxn_fi.referencecode%type)
46 return number; -- nonzero if rows were updated.
47
48 procedure update_trxn_status( i_unchanged_status IN NUMBER,
49 i_numTrxns IN NUMBER,
50 i_status_arr IN JTF_NUMBER_TABLE,
51 i_errLoc_arr IN JTF_NUMBER_TABLE,
52 i_errCode_arr IN JTF_VARCHAR2_TABLE_100,
53 i_errMsg_arr IN JTF_VARCHAR2_TABLE_300,
54 i_tangibleId_arr IN JTF_VARCHAR2_TABLE_100,
55 i_trxnMId_arr IN JTF_NUMBER_TABLE,
56 i_srvrId_arr IN JTF_VARCHAR2_TABLE_100,
57 i_refCode_arr IN JTF_VARCHAR2_TABLE_100,
58 i_auxMsg_arr IN JTF_VARCHAR2_TABLE_300,
59 i_fee_arr IN JTF_NUMBER_TABLE,
60 o_status_arr OUT NOCOPY JTF_NUMBER_TABLE,
61 o_error_code OUT NOCOPY NUMBER,
62 o_error_msg OUT NOCOPY VARCHAR2
63 );
64
65 end iby_sched;