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_MERGE dependencies on ARP_STANDARD

Line 288: , last_updated_by=arp_standard.profile.user_id

284: cust_account_id=num_col1_new_list(i)
285: ,acct_site_id=num_col2_new_list(i)
286: ,acct_site_use_id=num_col3_new_list(i)
287: , last_update_date=SYSDATE
288: , last_updated_by=arp_standard.profile.user_id
289: , last_update_login=arp_standard.profile.last_update_login
290: WHERE trxnmid=primary_key_id_list(i)
291: AND reqtype IN ('ORAPMTREQ','ORAPMTBATCHREQ')
292: AND status <> 0

Line 289: , last_update_login=arp_standard.profile.last_update_login

285: ,acct_site_id=num_col2_new_list(i)
286: ,acct_site_use_id=num_col3_new_list(i)
287: , last_update_date=SYSDATE
288: , last_updated_by=arp_standard.profile.user_id
289: , last_update_login=arp_standard.profile.last_update_login
290: WHERE trxnmid=primary_key_id_list(i)
291: AND reqtype IN ('ORAPMTREQ','ORAPMTBATCHREQ')
292: AND status <> 0
293:

Line 531: last_updated_by = arp_standard.profile.user_id,

527: FORALL i in 1..ext_payer_from_list.COUNT
528: UPDATE iby_ext_party_pmt_mthds dup
529: SET ext_pmt_party_id = ext_payer_to_list(i),
530: last_update_date = SYSDATE,
531: last_updated_by = arp_standard.profile.user_id,
532: last_update_login = arp_standard.profile.last_update_login
533: WHERE ext_pmt_party_id = ext_payer_from_list(i)
534: AND ext_payer_from_list(i) IS NOT NULL
535: AND ext_payer_to_list(i) IS NOT NULL

Line 532: last_update_login = arp_standard.profile.last_update_login

528: UPDATE iby_ext_party_pmt_mthds dup
529: SET ext_pmt_party_id = ext_payer_to_list(i),
530: last_update_date = SYSDATE,
531: last_updated_by = arp_standard.profile.user_id,
532: last_update_login = arp_standard.profile.last_update_login
533: WHERE ext_pmt_party_id = ext_payer_from_list(i)
534: AND ext_payer_from_list(i) IS NOT NULL
535: AND ext_payer_to_list(i) IS NOT NULL
536: AND NOT EXISTS

Line 550: last_updated_by = arp_standard.profile.user_id,

546: FORALL i in 1..ext_payer_from_list.COUNT
547: UPDATE iby_ext_party_pmt_mthds dup
548: SET inactive_date = SYSDATE,
549: last_update_date = SYSDATE,
550: last_updated_by = arp_standard.profile.user_id,
551: last_update_login = arp_standard.profile.last_update_login
552: WHERE ext_pmt_party_id = ext_payer_from_list(i)
553: AND ext_payer_from_list(i) IS NOT NULL
554: AND ext_payer_to_list(i) IS NOT NULL

Line 551: last_update_login = arp_standard.profile.last_update_login

547: UPDATE iby_ext_party_pmt_mthds dup
548: SET inactive_date = SYSDATE,
549: last_update_date = SYSDATE,
550: last_updated_by = arp_standard.profile.user_id,
551: last_update_login = arp_standard.profile.last_update_login
552: WHERE ext_pmt_party_id = ext_payer_from_list(i)
553: AND ext_payer_from_list(i) IS NOT NULL
554: AND ext_payer_to_list(i) IS NOT NULL
555: AND EXISTS

Line 594: last_updated_by = arp_standard.profile.user_id,

590: FORALL i in 1..ext_payer_from_list.COUNT
591: UPDATE iby_pmt_instr_uses_all dup
592: SET ext_pmt_party_id = ext_payer_to_list(i),
593: last_update_date = SYSDATE,
594: last_updated_by = arp_standard.profile.user_id,
595: last_update_login = arp_standard.profile.last_update_login
596: WHERE ext_pmt_party_id = ext_payer_from_list(i)
597: AND ext_payer_from_list(i) IS NOT NULL
598: AND ext_payer_to_list(i) IS NOT NULL

Line 595: last_update_login = arp_standard.profile.last_update_login

591: UPDATE iby_pmt_instr_uses_all dup
592: SET ext_pmt_party_id = ext_payer_to_list(i),
593: last_update_date = SYSDATE,
594: last_updated_by = arp_standard.profile.user_id,
595: last_update_login = arp_standard.profile.last_update_login
596: WHERE ext_pmt_party_id = ext_payer_from_list(i)
597: AND ext_payer_from_list(i) IS NOT NULL
598: AND ext_payer_to_list(i) IS NOT NULL
599: AND payment_flow = 'FUNDS_CAPTURE'

Line 620: last_updated_by = arp_standard.profile.user_id,

616: FORALL i in 1..ext_payer_from_list.COUNT
617: UPDATE iby_pmt_instr_uses_all dup
618: SET ext_pmt_party_id = ext_payer_to_list(i),
619: last_update_date = SYSDATE,
620: last_updated_by = arp_standard.profile.user_id,
621: last_update_login = arp_standard.profile.last_update_login
622: WHERE ext_pmt_party_id = ext_payer_from_list(i)
623: AND ext_payer_from_list(i) IS NOT NULL
624: AND ext_payer_to_list(i) IS NOT NULL

Line 621: last_update_login = arp_standard.profile.last_update_login

617: UPDATE iby_pmt_instr_uses_all dup
618: SET ext_pmt_party_id = ext_payer_to_list(i),
619: last_update_date = SYSDATE,
620: last_updated_by = arp_standard.profile.user_id,
621: last_update_login = arp_standard.profile.last_update_login
622: WHERE ext_pmt_party_id = ext_payer_from_list(i)
623: AND ext_payer_from_list(i) IS NOT NULL
624: AND ext_payer_to_list(i) IS NOT NULL
625: AND dup.instrument_type = 'CREDITCARD'

Line 651: last_updated_by = arp_standard.profile.user_id,

647: FORALL i in 1..ext_payer_from_list.COUNT
648: UPDATE iby_pmt_instr_uses_all dup
649: SET ext_pmt_party_id = ext_payer_to_list(i),
650: last_update_date = SYSDATE,
651: last_updated_by = arp_standard.profile.user_id,
652: last_update_login = arp_standard.profile.last_update_login
653: WHERE ext_pmt_party_id = ext_payer_from_list(i)
654: AND ext_payer_from_list(i) IS NOT NULL
655: AND ext_payer_to_list(i) IS NOT NULL

Line 652: last_update_login = arp_standard.profile.last_update_login

648: UPDATE iby_pmt_instr_uses_all dup
649: SET ext_pmt_party_id = ext_payer_to_list(i),
650: last_update_date = SYSDATE,
651: last_updated_by = arp_standard.profile.user_id,
652: last_update_login = arp_standard.profile.last_update_login
653: WHERE ext_pmt_party_id = ext_payer_from_list(i)
654: AND ext_payer_from_list(i) IS NOT NULL
655: AND ext_payer_to_list(i) IS NOT NULL
656: AND dup.instrument_type = 'BANKACCOUNT'

Line 680: last_updated_by = arp_standard.profile.user_id,

676: FORALL i in 1..ext_payer_from_list.COUNT
677: UPDATE iby_pmt_instr_uses_all dup
678: SET end_date = SYSDATE,
679: last_update_date = SYSDATE,
680: last_updated_by = arp_standard.profile.user_id,
681: last_update_login = arp_standard.profile.last_update_login
682: WHERE ext_pmt_party_id = ext_payer_from_list(i)
683: AND ext_payer_from_list(i) IS NOT NULL
684: AND ext_payer_to_list(i) IS NOT NULL

Line 681: last_update_login = arp_standard.profile.last_update_login

677: UPDATE iby_pmt_instr_uses_all dup
678: SET end_date = SYSDATE,
679: last_update_date = SYSDATE,
680: last_updated_by = arp_standard.profile.user_id,
681: last_update_login = arp_standard.profile.last_update_login
682: WHERE ext_pmt_party_id = ext_payer_from_list(i)
683: AND ext_payer_from_list(i) IS NOT NULL
684: AND ext_payer_to_list(i) IS NOT NULL
685: AND payment_flow = 'FUNDS_CAPTURE'

Line 703: last_updated_by = arp_standard.profile.user_id,

699: FORALL i in 1..ext_payer_from_list.COUNT
700: UPDATE iby_pmt_instr_uses_all dup
701: SET end_date = SYSDATE,
702: last_update_date = SYSDATE,
703: last_updated_by = arp_standard.profile.user_id,
704: last_update_login = arp_standard.profile.last_update_login
705: WHERE ext_pmt_party_id = ext_payer_from_list(i)
706: AND ext_payer_from_list(i) IS NOT NULL
707: AND ext_payer_to_list(i) IS NOT NULL

Line 704: last_update_login = arp_standard.profile.last_update_login

700: UPDATE iby_pmt_instr_uses_all dup
701: SET end_date = SYSDATE,
702: last_update_date = SYSDATE,
703: last_updated_by = arp_standard.profile.user_id,
704: last_update_login = arp_standard.profile.last_update_login
705: WHERE ext_pmt_party_id = ext_payer_from_list(i)
706: AND ext_payer_from_list(i) IS NOT NULL
707: AND ext_payer_to_list(i) IS NOT NULL
708: AND payment_flow = 'FUNDS_CAPTURE'

Line 729: last_updated_by = arp_standard.profile.user_id,

725: FORALL i in 1..ext_payer_from_list.COUNT
726: UPDATE iby_pmt_instr_uses_all dup
727: SET end_date = SYSDATE,
728: last_update_date = SYSDATE,
729: last_updated_by = arp_standard.profile.user_id,
730: last_update_login = arp_standard.profile.last_update_login
731: WHERE ext_pmt_party_id = ext_payer_from_list(i)
732: AND ext_payer_from_list(i) IS NOT NULL
733: AND ext_payer_to_list(i) IS NOT NULL

Line 730: last_update_login = arp_standard.profile.last_update_login

726: UPDATE iby_pmt_instr_uses_all dup
727: SET end_date = SYSDATE,
728: last_update_date = SYSDATE,
729: last_updated_by = arp_standard.profile.user_id,
730: last_update_login = arp_standard.profile.last_update_login
731: WHERE ext_pmt_party_id = ext_payer_from_list(i)
732: AND ext_payer_from_list(i) IS NOT NULL
733: AND ext_payer_to_list(i) IS NOT NULL
734: AND payment_flow = 'FUNDS_CAPTURE'

Line 954: , last_updated_by=arp_standard.profile.user_id

950: UPDATE IBY_EXTERNAL_PAYERS_ALL yt SET
951: cust_account_id=num_col1_new_list(i)
952: ,acct_site_use_id=num_col2_new_list(i)
953: , last_update_date=SYSDATE
954: , last_updated_by=arp_standard.profile.user_id
955: , last_update_login=arp_standard.profile.last_update_login
956: WHERE ext_payer_id=primary_key_id_list(i)
957: AND primary_key_id_list(i) = ext_payer_from_list(i)
958: AND ext_payer_from_list(i) is not null

Line 955: , last_update_login=arp_standard.profile.last_update_login

951: cust_account_id=num_col1_new_list(i)
952: ,acct_site_use_id=num_col2_new_list(i)
953: , last_update_date=SYSDATE
954: , last_updated_by=arp_standard.profile.user_id
955: , last_update_login=arp_standard.profile.last_update_login
956: WHERE ext_payer_id=primary_key_id_list(i)
957: AND primary_key_id_list(i) = ext_payer_from_list(i)
958: AND ext_payer_from_list(i) is not null
959: AND ext_payer_to_list(i) is null;