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 FND_GLOBAL

Line 350: sysdate, sysdate, fnd_global.user_id,

346: i_payerid, i_instrid, i_billamount,
347: i_billcurDef, i_reqdate, l_reqtype,
348: l_status, i_scheddate, l_mtangibleid, i_nlslang,
349: 'BANKACCOUNT', 'ACH',
350: sysdate, sysdate, fnd_global.user_id,
351: sysdate, fnd_global.user_id,
352: fnd_global.login_id, 1, l_reference_code, l_reference_amount,
353: i_custacctid, i_acctsiteid, i_acctsiteuseid,
354: l_settle_cust_ref, l_first_trx_flag, i_profilecode,

Line 351: sysdate, fnd_global.user_id,

347: i_billcurDef, i_reqdate, l_reqtype,
348: l_status, i_scheddate, l_mtangibleid, i_nlslang,
349: 'BANKACCOUNT', 'ACH',
350: sysdate, sysdate, fnd_global.user_id,
351: sysdate, fnd_global.user_id,
352: fnd_global.login_id, 1, l_reference_code, l_reference_amount,
353: i_custacctid, i_acctsiteid, i_acctsiteuseid,
354: l_settle_cust_ref, l_first_trx_flag, i_profilecode,
355: l_trxntypeid,'Y'

Line 352: fnd_global.login_id, 1, l_reference_code, l_reference_amount,

348: l_status, i_scheddate, l_mtangibleid, i_nlslang,
349: 'BANKACCOUNT', 'ACH',
350: sysdate, sysdate, fnd_global.user_id,
351: sysdate, fnd_global.user_id,
352: fnd_global.login_id, 1, l_reference_code, l_reference_amount,
353: i_custacctid, i_acctsiteid, i_acctsiteuseid,
354: l_settle_cust_ref, l_first_trx_flag, i_profilecode,
355: l_trxntypeid,'Y'
356: );

Line 368: sysdate, fnd_global.user_id,

364: last_update_date, last_updated_by,
365: creation_date, created_by,
366: last_update_login, object_version_number)
367: values ( l_tmid, i_psreqid, i_splitId,
368: sysdate, fnd_global.user_id,
369: sysdate, fnd_global.user_id,
370: fnd_global.login_id, 1);
371: io_tid := l_tid;
372:

Line 369: sysdate, fnd_global.user_id,

365: creation_date, created_by,
366: last_update_login, object_version_number)
367: values ( l_tmid, i_psreqid, i_splitId,
368: sysdate, fnd_global.user_id,
369: sysdate, fnd_global.user_id,
370: fnd_global.login_id, 1);
371: io_tid := l_tid;
372:
373: else

Line 370: fnd_global.login_id, 1);

366: last_update_login, object_version_number)
367: values ( l_tmid, i_psreqid, i_splitId,
368: sysdate, fnd_global.user_id,
369: sysdate, fnd_global.user_id,
370: fnd_global.login_id, 1);
371: io_tid := l_tid;
372:
373: else
374: -- Update iby_tangible table

Line 406: last_updated_by = fnd_global.user_id,

402: acct_site_id = i_acctsiteid,
403: acct_site_use_id = i_acctsiteuseid,
404: last_update_date = sysdate,
405: updatedate = sysdate,
406: last_updated_by = fnd_global.user_id,
407: creation_date = sysdate,
408: created_by = fnd_global.user_id,
409: last_update_login = fnd_global.user_id,
410: object_version_number = object_version_number+1,

Line 408: created_by = fnd_global.user_id,

404: last_update_date = sysdate,
405: updatedate = sysdate,
406: last_updated_by = fnd_global.user_id,
407: creation_date = sysdate,
408: created_by = fnd_global.user_id,
409: last_update_login = fnd_global.user_id,
410: object_version_number = object_version_number+1,
411: settlement_customer_reference = l_settle_cust_ref,
412: first_trxn_flag = l_first_trx_flag

Line 409: last_update_login = fnd_global.user_id,

405: updatedate = sysdate,
406: last_updated_by = fnd_global.user_id,
407: creation_date = sysdate,
408: created_by = fnd_global.user_id,
409: last_update_login = fnd_global.user_id,
410: object_version_number = object_version_number+1,
411: settlement_customer_reference = l_settle_cust_ref,
412: first_trxn_flag = l_first_trx_flag
413: WHERE trxnmid = l_old_tmid;

Line 618: last_updated_by = fnd_global.user_id,

614: update iby_trxn_summaries_all
615: set status = -99,
616: last_update_date = sysdate,
617: updatedate = sysdate,
618: last_updated_by = fnd_global.user_id,
619: last_update_login = fnd_global.login_id,
620: object_version_number = 1
621: where transactionId = i_tid
622: and (reqtype = 'ORAPMTREQ' or reqtype = 'ORAPMTCREDIT')

Line 619: last_update_login = fnd_global.login_id,

615: set status = -99,
616: last_update_date = sysdate,
617: updatedate = sysdate,
618: last_updated_by = fnd_global.user_id,
619: last_update_login = fnd_global.login_id,
620: object_version_number = 1
621: where transactionId = i_tid
622: and (reqtype = 'ORAPMTREQ' or reqtype = 'ORAPMTCREDIT')
623: and status = 100;

Line 656: sysdate, sysdate, fnd_global.user_id,

652: i_payerid, i_instrid,
653: i_billamount, i_billcurDef, i_reqdate,
654: l_reqtype, 100, i_scheddate, l_mtangibleid, i_nlslang,
655: 'BANKACCOUNT',
656: sysdate, sysdate, fnd_global.user_id,
657: sysdate, fnd_global.user_id,
658: fnd_global.login_id, 1,'Y');
659:
660: /*

Line 657: sysdate, fnd_global.user_id,

653: i_billamount, i_billcurDef, i_reqdate,
654: l_reqtype, 100, i_scheddate, l_mtangibleid, i_nlslang,
655: 'BANKACCOUNT',
656: sysdate, sysdate, fnd_global.user_id,
657: sysdate, fnd_global.user_id,
658: fnd_global.login_id, 1,'Y');
659:
660: /*
661: ** After inserting an entry in transactions_summaries_all table,

Line 658: fnd_global.login_id, 1,'Y');

654: l_reqtype, 100, i_scheddate, l_mtangibleid, i_nlslang,
655: 'BANKACCOUNT',
656: sysdate, sysdate, fnd_global.user_id,
657: sysdate, fnd_global.user_id,
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

Line 671: sysdate, fnd_global.user_id,

667: last_update_date, last_updated_by,
668: creation_date, created_by,
669: last_update_login, object_version_number)
670: values ( l_tmid, i_psreqid, l_splitId,
671: sysdate, fnd_global.user_id,
672: sysdate, fnd_global.user_id,
673: fnd_global.login_id, 1);
674: else
675: /*

Line 672: sysdate, fnd_global.user_id,

668: creation_date, created_by,
669: last_update_login, object_version_number)
670: values ( l_tmid, i_psreqid, l_splitId,
671: sysdate, fnd_global.user_id,
672: sysdate, fnd_global.user_id,
673: fnd_global.login_id, 1);
674: else
675: /*
676: ** if modification is not allowed then raise an exception.

Line 673: fnd_global.login_id, 1);

669: last_update_login, object_version_number)
670: values ( l_tmid, i_psreqid, l_splitId,
671: sysdate, fnd_global.user_id,
672: sysdate, fnd_global.user_id,
673: fnd_global.login_id, 1);
674: else
675: /*
676: ** if modification is not allowed then raise an exception.
677: */

Line 752: last_updated_by = fnd_global.user_id,

748: update iby_trxn_summaries_all
749: set status = -99,
750: last_update_date = sysdate,
751: updatedate = sysdate,
752: last_updated_by = fnd_global.user_id,
753: last_update_login = fnd_global.login_id,
754: object_version_number = 1
755: where transactionId = i_tid
756: and (reqtype = 'ORAPMTREQ' or reqtype = 'ORAPMTCREDIT');

Line 753: last_update_login = fnd_global.login_id,

749: set status = -99,
750: last_update_date = sysdate,
751: updatedate = sysdate,
752: last_updated_by = fnd_global.user_id,
753: last_update_login = fnd_global.login_id,
754: object_version_number = 1
755: where transactionId = i_tid
756: and (reqtype = 'ORAPMTREQ' or reqtype = 'ORAPMTCREDIT');
757:

Line 781: sysdate, sysdate, fnd_global.user_id,

777: payerid, payerinstrid,
778: amount, currencyNameCode,
779: sysdate, 'ORAPMTCANC', 14,
780: mtangibleId, nlslang, 'BANKACCOUNT',
781: sysdate, sysdate, fnd_global.user_id,
782: sysdate, fnd_global.user_id,
783: fnd_global.login_id, 1,'Y'
784: from iby_trxn_summaries_all
785: where trxnmid = l_old_tmid;

Line 782: sysdate, fnd_global.user_id,

778: amount, currencyNameCode,
779: sysdate, 'ORAPMTCANC', 14,
780: mtangibleId, nlslang, 'BANKACCOUNT',
781: sysdate, sysdate, fnd_global.user_id,
782: sysdate, fnd_global.user_id,
783: fnd_global.login_id, 1,'Y'
784: from iby_trxn_summaries_all
785: where trxnmid = l_old_tmid;
786:

Line 783: fnd_global.login_id, 1,'Y'

779: sysdate, 'ORAPMTCANC', 14,
780: mtangibleId, nlslang, 'BANKACCOUNT',
781: sysdate, sysdate, fnd_global.user_id,
782: sysdate, fnd_global.user_id,
783: fnd_global.login_id, 1,'Y'
784: from iby_trxn_summaries_all
785: where trxnmid = l_old_tmid;
786:
787:

Line 795: sysdate, fnd_global.user_id,

791: creation_date, created_by,
792: last_update_login, object_version_number)
793:
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;

Line 796: sysdate, fnd_global.user_id,

792: last_update_login, object_version_number)
793:
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:

Line 797: fnd_global.login_id, 1

793:
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

Line 905: last_updated_by = fnd_global.user_id,

901: amount=i_amount,
902: proc_reference_code=l_reference_code,
903: last_update_date = sysdate,
904: updatedate = sysdate,
905: last_updated_by = fnd_global.user_id,
906: last_update_login = fnd_global.user_id,
907: object_version_number = 1
908: where trxnmid=l_new_tmid;
909: else

Line 906: last_update_login = fnd_global.user_id,

902: proc_reference_code=l_reference_code,
903: last_update_date = sysdate,
904: updatedate = sysdate,
905: last_updated_by = fnd_global.user_id,
906: last_update_login = fnd_global.user_id,
907: object_version_number = 1
908: where trxnmid=l_new_tmid;
909: else
910:

Line 946: sysdate, sysdate, fnd_global.user_id,

942: payerid, payerinstrid,
943: i_amount, i_currencycode,
944: sysdate, 'ORAPMTRETURN', 9,
945: mtangibleId, nlslang, 'BANKACCOUNT',
946: sysdate, sysdate, fnd_global.user_id,
947: sysdate, fnd_global.user_id,
948: fnd_global.login_id, 1,
949: proc_reference_code, amount, 5, bepkey,'Y'
950: , payment_channel_code,settledate,settlement_due_date

Line 947: sysdate, fnd_global.user_id,

943: i_amount, i_currencycode,
944: sysdate, 'ORAPMTRETURN', 9,
945: mtangibleId, nlslang, 'BANKACCOUNT',
946: sysdate, sysdate, fnd_global.user_id,
947: sysdate, fnd_global.user_id,
948: fnd_global.login_id, 1,
949: proc_reference_code, amount, 5, bepkey,'Y'
950: , payment_channel_code,settledate,settlement_due_date
951: from iby_trxn_summaries_all

Line 948: fnd_global.login_id, 1,

944: sysdate, 'ORAPMTRETURN', 9,
945: mtangibleId, nlslang, 'BANKACCOUNT',
946: sysdate, sysdate, fnd_global.user_id,
947: sysdate, fnd_global.user_id,
948: fnd_global.login_id, 1,
949: proc_reference_code, amount, 5, bepkey,'Y'
950: , payment_channel_code,settledate,settlement_due_date
951: from iby_trxn_summaries_all
952: where trxnmid = l_old_tmid;

Line 962: sysdate, fnd_global.user_id,

958: creation_date, created_by,
959: last_update_login, object_version_number)
960:
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;

Line 963: sysdate, fnd_global.user_id,

959: last_update_login, object_version_number)
960:
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:

Line 964: fnd_global.login_id, 1

960:
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;

Line 999: last_updated_by = fnd_global.user_id,

995: bepcode = i_bepcode,
996: bepmessage = i_bepmessage,
997: errorlocation = i_errorlocation,
998: last_update_date = sysdate,
999: last_updated_by = fnd_global.user_id,
1000: last_update_login = fnd_global.user_id,
1001: object_version_number = 1,
1002: proc_reference_code = i_referencecode
1003: WHERE trxnmid = i_trxnmid;

Line 1000: last_update_login = fnd_global.user_id,

996: bepmessage = i_bepmessage,
997: errorlocation = i_errorlocation,
998: last_update_date = sysdate,
999: last_updated_by = fnd_global.user_id,
1000: last_update_login = fnd_global.user_id,
1001: object_version_number = 1,
1002: proc_reference_code = i_referencecode
1003: WHERE trxnmid = i_trxnmid;
1004: