APPS.IBY_SCHED dependencies on IBY_TRXN_SUMMARIES_ALL

Line 26: iby_trxn_summaries_all d

22: select ccnumber,
23: expirydate,
24: accttype
25: from iby_creditcard_v c,
26: iby_trxn_summaries_all d
27: where d.payerinstrid = cin_payerinstrid
28: and d.payerinstrid = c.instrid;
29:
30: cursor c_payeeBankInfo (cin_payeeid in iby_trans_fi_v.payeeid%type) is

Line 36: iby_trxn_summaries_all d

32: b.branch_party_id,
33: b.ext_bank_account_id,
34: b.bank_account_type
35: from iby_ext_bank_accounts_v b,
36: iby_trxn_summaries_all d
37: where d.payeeid = cin_payeeid
38: and d.payeeinstrid = b.ext_bank_account_id;
39:
40: cursor c_tangibleInfo (cin_tangibleid in iby_trans_fi_v.tangibleid%type) is

Line 104: iby_trxn_summaries_all d

100: b.branch_party_id,
101: b.ext_bank_account_id,
102: b.bank_account_type
103: from iby_ext_bank_accounts_v b,
104: iby_trxn_summaries_all d
105: where d.payerinstrid = cin_payerinstrid
106: and d.payerinstrid = b.ext_bank_account_id;
107:
108:

Line 115: iby_trxn_summaries_all d

111: b.branch_party_id,
112: b.ext_bank_account_id,
113: b.bank_account_type
114: from iby_ext_bank_accounts_v b,
115: iby_trxn_summaries_all d
116: where d.payeeid = cin_payeeid
117: and d.payeeinstrid = b.ext_bank_account_id;
118:
119: cursor c_tangibleInfo (cin_tangibleid in iby_trans_fi_v.tangibleid%type) is

Line 253: FROM iby_trxn_summaries_all

249:
250: -- finding the total number of rows
251: SELECT count(*)
252: INTO totalRows
253: FROM iby_trxn_summaries_all
254: WHERE needsupdt IN ('Y','F')
255: AND ecappid = in_ecappid;
256:
257: IF( totalRows < 1 ) THEN

Line 357: UPDATE iby_trxn_summaries_all

353: IN OUT o_statusindiv_Tab;
354:
355: FOR j IN 1..i LOOP
356: if (o_statusindiv_Tab(j) = 'TRUE') then
357: UPDATE iby_trxn_summaries_all
358: SET NeedsUpdt = 'N'
359: WHERE trxnmid = txn_mid_Tab(j);
360: else
361: UPDATE iby_trxn_summaries_all

Line 361: UPDATE iby_trxn_summaries_all

357: UPDATE iby_trxn_summaries_all
358: SET NeedsUpdt = 'N'
359: WHERE trxnmid = txn_mid_Tab(j);
360: else
361: UPDATE iby_trxn_summaries_all
362: SET NeedsUpdt = 'F'
363: WHERE trxnmid = txn_mid_Tab(j);
364: end if;
365:

Line 388: UPDATE iby_trxn_summaries_all

384:
385: EXCEPTION
386: WHEN OTHERS THEN
387: FOR k IN 1..i LOOP
388: UPDATE iby_trxn_summaries_all
389: SET NeedsUpdt = 'F'
390: WHERE trxnmid = txn_mid_Tab(k);
391: END LOOP;
392: commit;

Line 406: update iby_trxn_summaries_all

402: in_refinfo in iby_trxn_fi.referencecode%type)
403: return number -- nonzero if rows were updated.
404: is
405: begin
406: update iby_trxn_summaries_all
407: set status = decode(in_pmtprcst, 'PAID', 0, 'UNPAID', 17, 'FAILED',
408: 16, 'PAYFAILED', 16, 16),
409: updatedate = to_date(in_dtpmtprc,'YYYYMMDD'), needsupdt = 'Y'
410: where trxnmid in

Line 466: UPDATE iby_trxn_summaries_all

462: o_status_arr( l_index ) := c_SUCCESS;
463:
464: BEGIN -- Nested block begins
465:
466: UPDATE iby_trxn_summaries_all
467: SET status = decode( l_status, i_unchanged_status, status, l_status),
468: errorlocation = i_errLoc_arr( l_index ),
469: BEPCode = i_errCode_arr( l_index ),
470: BEPMessage = i_errMsg_arr( l_index ),

Line 485: --FROM IBY_TRXN_SUMMARIES_ALL

481: AUXMSG = i_auxMsg_arr( l_index ),
482: PROCESSFEE = i_fee_arr( l_index )
483: WHERE TRXNMID = i_trxnMId_arr( l_index );
484: --(SELECT TRXNMID
485: --FROM IBY_TRXN_SUMMARIES_ALL
486: --WHERE TANGIBLEID = i_tangibleId_arr( l_index )
487: --);
488:
489: IF ( SQL%NOTFOUND ) THEN