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_FIPAYMENTS_PKG dependencies on IBY_TRXN_FI

Line 67: i_psreqId in iby_trxn_fi.psreqid%type,

63: i_reqdate in iby_trxn_summaries_all.reqdate%type,
64: i_bepid in iby_trxn_summaries_all.bepid%type,
65: i_bepkey in iby_trxn_summaries_all.bepkey%type,
66: i_pmtmethod in iby_trxn_summaries_all.paymentmethodname%type,
67: i_psreqId in iby_trxn_fi.psreqid%type,
68: i_nlslang in iby_trxn_summaries_all.nlslang%type,
69: i_splitId in iby_trxn_fi.splitId%type,
70: i_org_id in iby_trxn_summaries_all.org_id%type,
71: i_org_type in iby_trxn_summaries_all.org_type%type,

Line 69: i_splitId in iby_trxn_fi.splitId%type,

65: i_bepkey in iby_trxn_summaries_all.bepkey%type,
66: i_pmtmethod in iby_trxn_summaries_all.paymentmethodname%type,
67: i_psreqId in iby_trxn_fi.psreqid%type,
68: i_nlslang in iby_trxn_summaries_all.nlslang%type,
69: i_splitId in iby_trxn_fi.splitId%type,
70: i_org_id in iby_trxn_summaries_all.org_id%type,
71: i_org_type in iby_trxn_summaries_all.org_type%type,
72: i_bnfcryinstrid in iby_trxn_summaries_all.payeeinstrid%type,
73: i_custacctid in iby_trxn_summaries_all.cust_account_id%type,

Line 362: insert into iby_trxn_fi

358: /*
359: ** After everything is successful then create an entry in the
360: ** iby_request table.
361: */
362: insert into iby_trxn_fi
363: (trxnMid, psreqid, splitId,
364: last_update_date, last_updated_by,
365: creation_date, created_by,
366: last_update_login, object_version_number)

Line 454: i_splitId in iby_trxn_fi.splitId%type,

450:
451:
452: Function requestExists(i_payeeid iby_trxn_summaries_all.payeeid%type,
453: i_tangibleid iby_trxn_summaries_all.tangibleid%type,
454: i_splitId in iby_trxn_fi.splitId%type,
455: i_reqtype iby_trxn_summaries_all.reqtype%type)
456: return boolean
457: is
458: l_cnt int;

Line 472: --from iby_trxn_fi f

468: and tangibleid = i_tangibleId
469: and UPPER(reqType) = UPPER(i_reqType)
470: and trxntypeid not in (20);
471: --and i_splitId in ( select splitId
472: --from iby_trxn_fi f
473: --where f.trxnmid = s.trxnmid);
474: -- The 'AND' condition for the splitId is removed as we do not use
475: -- splitId anymore.
476:

Line 536: i_psreqId in iby_trxn_fi.psreqid%type,

532: i_reqdate in iby_trxn_summaries_all.reqdate%type,
533: i_bepid in iby_trxn_summaries_all.bepid%type,
534: i_bepkey in iby_trxn_summaries_all.bepkey%type,
535: i_pmtmethod in iby_trxn_summaries_all.paymentmethodname%type,
536: i_psreqId in iby_trxn_fi.psreqid%type,
537: i_nlslang in iby_trxn_summaries_all.nlslang%type,
538: i_tid in iby_trxn_summaries_all.transactionid%type,
539: i_org_id in iby_trxn_summaries_all.org_id%type)
540: is

Line 558: l_splitId iby_trxn_fi.splitId%type;

554: select mtangibleid , tangibleid
555: from iby_trxn_summaries_all
556: where transactionId = ci_tid
557: group by mtangibleid , tangibleid;
558: l_splitId iby_trxn_fi.splitId%type;
559: begin
560:
561: IF (NVL(i_instrid,0) <> 0) THEN
562: checkInstrId(i_instrid);

Line 629: from iby_trxn_fi

625:
626: -- // pending requests...
627:
628: select splitId into l_splitId
629: from iby_trxn_fi
630: where trxnmid in ( select trxnmid
631: from iby_trxn_summaries_all
632: where transactionId = i_tid)
633: and rownum < 2;

Line 662: ** make an entry in the iby_trxn_fi table, corresponding to

658: fnd_global.login_id, 1,'Y');
659:
660: /*
661: ** After inserting an entry in transactions_summaries_all table,
662: ** make an entry in the iby_trxn_fi table, corresponding to
663: ** the transaction master id.
664: */
665: insert into iby_trxn_fi
666: (trxnMid, psreqid, splitId,

Line 665: insert into iby_trxn_fi

661: ** After inserting an entry in transactions_summaries_all table,
662: ** make an entry in the iby_trxn_fi table, corresponding to
663: ** the transaction master id.
664: */
665: insert into iby_trxn_fi
666: (trxnMid, psreqid, splitId,
667: last_update_date, last_updated_by,
668: creation_date, created_by,
669: last_update_login, object_version_number)

Line 788: insert into iby_trxn_fi

784: from iby_trxn_summaries_all
785: where trxnmid = l_old_tmid;
786:
787:
788: insert into iby_trxn_fi
789: (trxnMid, psreqid, splitId,
790: last_update_date, last_updated_by,
791: creation_date, created_by,
792: last_update_login, object_version_number)

Line 798: from iby_trxn_fi

794: select l_new_tmid, psreqid, splitId,
795: sysdate, fnd_global.user_id,
796: sysdate, fnd_global.user_id,
797: fnd_global.login_id, 1
798: from iby_trxn_fi
799: where trxnmid = l_old_tmid;
800:
801: else
802: -- can't modify/cancel when not pending

Line 955: insert into iby_trxn_fi

951: from iby_trxn_summaries_all
952: where trxnmid = l_old_tmid;
953:
954:
955: insert into iby_trxn_fi
956: (trxnMid, psreqid, splitId,
957: last_update_date, last_updated_by,
958: creation_date, created_by,
959: last_update_login, object_version_number)

Line 965: from iby_trxn_fi

961: select l_new_tmid, psreqid, splitId,
962: sysdate, fnd_global.user_id,
963: sysdate, fnd_global.user_id,
964: fnd_global.login_id, 1
965: from iby_trxn_fi
966: where trxnmid = l_old_tmid;
967:
968: end if;
969: io_trxnmid:=l_new_tmid;