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_PARTY_MERGE dependencies on IBY_PMT_INSTR_USES_ALL

Line 383: l_dup_id iby_pmt_instr_uses_all.instrument_payment_use_id%TYPE := NULL;

379: )
380: IS
381:
382: l_dbg_mod VARCHAR2(100) := G_DEBUG_MODULE || '.pmt_instrument_use_merge';
383: l_dup_id iby_pmt_instr_uses_all.instrument_payment_use_id%TYPE := NULL;
384: l_flow_type iby_pmt_instr_uses_all.payment_flow%TYPE;
385: g_mesg VARCHAR2(1000) := '';
386:
387: CURSOR c_dupinstr

Line 384: l_flow_type iby_pmt_instr_uses_all.payment_flow%TYPE;

380: IS
381:
382: l_dbg_mod VARCHAR2(100) := G_DEBUG_MODULE || '.pmt_instrument_use_merge';
383: l_dup_id iby_pmt_instr_uses_all.instrument_payment_use_id%TYPE := NULL;
384: l_flow_type iby_pmt_instr_uses_all.payment_flow%TYPE;
385: g_mesg VARCHAR2(1000) := '';
386:
387: CURSOR c_dupinstr
388: (ci_use_id IN iby_pmt_instr_uses_all.instrument_payment_use_id%TYPE,

Line 388: (ci_use_id IN iby_pmt_instr_uses_all.instrument_payment_use_id%TYPE,

384: l_flow_type iby_pmt_instr_uses_all.payment_flow%TYPE;
385: g_mesg VARCHAR2(1000) := '';
386:
387: CURSOR c_dupinstr
388: (ci_use_id IN iby_pmt_instr_uses_all.instrument_payment_use_id%TYPE,
389: ci_instr_id IN iby_pmt_instr_uses_all.instrument_id%TYPE,
390: ci_instr_type IN iby_pmt_instr_uses_all.instrument_type%TYPE)
391: IS
392: SELECT mto.instrument_payment_use_id

Line 389: ci_instr_id IN iby_pmt_instr_uses_all.instrument_id%TYPE,

385: g_mesg VARCHAR2(1000) := '';
386:
387: CURSOR c_dupinstr
388: (ci_use_id IN iby_pmt_instr_uses_all.instrument_payment_use_id%TYPE,
389: ci_instr_id IN iby_pmt_instr_uses_all.instrument_id%TYPE,
390: ci_instr_type IN iby_pmt_instr_uses_all.instrument_type%TYPE)
391: IS
392: SELECT mto.instrument_payment_use_id
393: FROM iby_pmt_instr_uses_all mto,

Line 390: ci_instr_type IN iby_pmt_instr_uses_all.instrument_type%TYPE)

386:
387: CURSOR c_dupinstr
388: (ci_use_id IN iby_pmt_instr_uses_all.instrument_payment_use_id%TYPE,
389: ci_instr_id IN iby_pmt_instr_uses_all.instrument_id%TYPE,
390: ci_instr_type IN iby_pmt_instr_uses_all.instrument_type%TYPE)
391: IS
392: SELECT mto.instrument_payment_use_id
393: FROM iby_pmt_instr_uses_all mto,
394: (SELECT ext_pmt_party_id,payment_flow

Line 393: FROM iby_pmt_instr_uses_all mto,

389: ci_instr_id IN iby_pmt_instr_uses_all.instrument_id%TYPE,
390: ci_instr_type IN iby_pmt_instr_uses_all.instrument_type%TYPE)
391: IS
392: SELECT mto.instrument_payment_use_id
393: FROM iby_pmt_instr_uses_all mto,
394: (SELECT ext_pmt_party_id,payment_flow
395: FROM iby_pmt_instr_uses_all
396: WHERE instrument_payment_use_id = ci_use_id) mfrom
397: WHERE

Line 395: FROM iby_pmt_instr_uses_all

391: IS
392: SELECT mto.instrument_payment_use_id
393: FROM iby_pmt_instr_uses_all mto,
394: (SELECT ext_pmt_party_id,payment_flow
395: FROM iby_pmt_instr_uses_all
396: WHERE instrument_payment_use_id = ci_use_id) mfrom
397: WHERE
398: mto.instrument_payment_use_id <> ci_use_id
399: AND mto.payment_flow = mfrom.payment_flow

Line 405: (ci_use_id IN iby_pmt_instr_uses_all.instrument_payment_use_id%TYPE,

401: AND mto.instrument_type = ci_instr_type
402: AND mto.instrument_id = ci_instr_id;
403:
404: CURSOR c_dupeparty
405: (ci_use_id IN iby_pmt_instr_uses_all.instrument_payment_use_id%TYPE,
406: ci_party_id IN iby_pmt_instr_uses_all.ext_pmt_party_id%TYPE,
407: ci_flow_type IN iby_pmt_instr_uses_all.payment_flow%TYPE)
408: IS
409: SELECT mto.instrument_payment_use_id

Line 406: ci_party_id IN iby_pmt_instr_uses_all.ext_pmt_party_id%TYPE,

402: AND mto.instrument_id = ci_instr_id;
403:
404: CURSOR c_dupeparty
405: (ci_use_id IN iby_pmt_instr_uses_all.instrument_payment_use_id%TYPE,
406: ci_party_id IN iby_pmt_instr_uses_all.ext_pmt_party_id%TYPE,
407: ci_flow_type IN iby_pmt_instr_uses_all.payment_flow%TYPE)
408: IS
409: SELECT mto.instrument_payment_use_id
410: FROM iby_pmt_instr_uses_all mto,

Line 407: ci_flow_type IN iby_pmt_instr_uses_all.payment_flow%TYPE)

403:
404: CURSOR c_dupeparty
405: (ci_use_id IN iby_pmt_instr_uses_all.instrument_payment_use_id%TYPE,
406: ci_party_id IN iby_pmt_instr_uses_all.ext_pmt_party_id%TYPE,
407: ci_flow_type IN iby_pmt_instr_uses_all.payment_flow%TYPE)
408: IS
409: SELECT mto.instrument_payment_use_id
410: FROM iby_pmt_instr_uses_all mto,
411: (SELECT instrument_type,instrument_id

Line 410: FROM iby_pmt_instr_uses_all mto,

406: ci_party_id IN iby_pmt_instr_uses_all.ext_pmt_party_id%TYPE,
407: ci_flow_type IN iby_pmt_instr_uses_all.payment_flow%TYPE)
408: IS
409: SELECT mto.instrument_payment_use_id
410: FROM iby_pmt_instr_uses_all mto,
411: (SELECT instrument_type,instrument_id
412: FROM iby_pmt_instr_uses_all
413: WHERE instrument_payment_use_id = ci_use_id) mfrom
414: WHERE

Line 412: FROM iby_pmt_instr_uses_all

408: IS
409: SELECT mto.instrument_payment_use_id
410: FROM iby_pmt_instr_uses_all mto,
411: (SELECT instrument_type,instrument_id
412: FROM iby_pmt_instr_uses_all
413: WHERE instrument_payment_use_id = ci_use_id) mfrom
414: WHERE
415: mto.instrument_payment_use_id <> ci_use_id
416: AND mto.payment_flow = ci_flow_type

Line 460: UPDATE iby_pmt_instr_uses_all

456:
457: g_mesg := 'duplicate instr use:='|| l_dup_id;
458: fnd_file.put_line(fnd_file.log, g_mesg || l_dbg_mod );
459:
460: UPDATE iby_pmt_instr_uses_all
461: SET instrument_id = DECODE(l_dup_id, NULL,p_to_fk_id, instrument_id),
462: end_date = DECODE(l_dup_id, NULL,end_date, SYSDATE),
463: last_update_date = hz_utility_pub.last_update_date,
464: last_updated_by = hz_utility_pub.user_id,

Line 491: UPDATE iby_pmt_instr_uses_all

487:
488: g_mesg := 'duplicate instr use:='|| l_dup_id;
489: fnd_file.put_line(fnd_file.log, g_mesg || l_dbg_mod );
490:
491: UPDATE iby_pmt_instr_uses_all
492: SET ext_pmt_party_id = DECODE(l_dup_id, NULL,p_to_fk_id, ext_pmt_party_id),
493: end_date = DECODE(l_dup_id, NULL,end_date, SYSDATE),
494: last_update_date = hz_utility_pub.last_update_date,
495: last_updated_by = hz_utility_pub.user_id,

Line 676: ELSIF (p_parent_entity_name = 'IBY_PMT_INSTR_USES_ALL') THEN

672: last_updated_by = hz_utility_pub.user_id,
673: last_update_login = hz_utility_pub.last_update_login
674: WHERE (trxn_extension_id = p_from_id);
675:
676: ELSIF (p_parent_entity_name = 'IBY_PMT_INSTR_USES_ALL') THEN
677:
678: UPDATE iby_fndcpt_tx_extensions
679: SET instr_assignment_id = p_to_fk_id,
680: last_update_date = hz_utility_pub.last_update_date,

Line 755: ELSIF (p_parent_entity_name = 'IBY_PMT_INSTR_USES_ALL') THEN

751: last_updated_by = hz_utility_pub.user_id,
752: last_update_login = hz_utility_pub.last_update_login
753: WHERE (trxnmid = p_from_id);
754:
755: ELSIF (p_parent_entity_name = 'IBY_PMT_INSTR_USES_ALL') THEN
756:
757: UPDATE iby_trxn_summaries_all
758: SET payer_instr_assignment_id = p_to_fk_id,
759: last_update_date = hz_utility_pub.last_update_date,