APPS.IBY_PARTY_MERGE dependencies on IBY_EXTERNAL_PAYERS_ALL

Line 281: (ci_payer_id IN iby_external_payers_all.ext_payer_id%TYPE,

277: )
278: IS
279:
280: CURSOR c_dupepayer
281: (ci_payer_id IN iby_external_payers_all.ext_payer_id%TYPE,
282: ci_party_id IN iby_external_payers_all.party_id%TYPE)
283: IS
284: SELECT ext_payer_id
285: FROM iby_external_payers_all mto,

Line 282: ci_party_id IN iby_external_payers_all.party_id%TYPE)

278: IS
279:
280: CURSOR c_dupepayer
281: (ci_payer_id IN iby_external_payers_all.ext_payer_id%TYPE,
282: ci_party_id IN iby_external_payers_all.party_id%TYPE)
283: IS
284: SELECT ext_payer_id
285: FROM iby_external_payers_all mto,
286: (SELECT payment_function,ci_party_id,cust_account_id,acct_site_use_id,

Line 285: FROM iby_external_payers_all mto,

281: (ci_payer_id IN iby_external_payers_all.ext_payer_id%TYPE,
282: ci_party_id IN iby_external_payers_all.party_id%TYPE)
283: IS
284: SELECT ext_payer_id
285: FROM iby_external_payers_all mto,
286: (SELECT payment_function,ci_party_id,cust_account_id,acct_site_use_id,
287: org_type,org_id
288: FROM iby_external_payers_all
289: WHERE (ext_payer_id = ci_payer_id)) mfrom

Line 288: FROM iby_external_payers_all

284: SELECT ext_payer_id
285: FROM iby_external_payers_all mto,
286: (SELECT payment_function,ci_party_id,cust_account_id,acct_site_use_id,
287: org_type,org_id
288: FROM iby_external_payers_all
289: WHERE (ext_payer_id = ci_payer_id)) mfrom
290: WHERE mto.ext_payer_id <> ci_payer_id
291: AND mto.payment_function = mfrom.payment_function
292: AND mto.party_id = ci_party_id

Line 299: l_dup_id iby_external_payers_all.ext_payer_id%TYPE;

295: AND NVL(mto.org_type,'!') = NVL(mfrom.org_type,'!')
296: AND NVL(mto.org_id,-99) = NVL(mfrom.org_id,-99);
297:
298: l_dbg_mod VARCHAR2(100) := G_DEBUG_MODULE || '.external_payer_merge';
299: l_dup_id iby_external_payers_all.ext_payer_id%TYPE;
300: g_mesg VARCHAR2(1000) := '';
301:
302: BEGIN
303:

Line 341: UPDATE iby_external_payers_all

337: g_mesg := 'duplicate payer:='|| l_dup_id;
338: fnd_file.put_line(fnd_file.log, g_mesg || l_dbg_mod );
339:
340: IF (l_dup_id IS NULL) THEN
341: UPDATE iby_external_payers_all
342: SET party_id = p_to_fk_id,
343: last_update_date = hz_utility_pub.last_update_date,
344: last_updated_by = hz_utility_pub.user_id,
345: last_update_login = hz_utility_pub.last_update_login

Line 474: ELSIF (p_parent_entity_name = 'IBY_EXTERNAL_PAYERS_ALL')

470: ELSE
471: p_to_id := l_dup_id;
472: END IF;
473:
474: ELSIF (p_parent_entity_name = 'IBY_EXTERNAL_PAYERS_ALL')
475: THEN
476:
477: IF (p_from_fk_id = p_to_fk_id) THEN
478: p_to_id := p_from_id;

Line 583: IF (p_parent_entity_name = 'IBY_EXTERNAL_PAYERS_ALL') THEN

579: p_to_id := p_from_id;
580: RETURN;
581: END IF;
582:
583: IF (p_parent_entity_name = 'IBY_EXTERNAL_PAYERS_ALL') THEN
584: l_flow_type := 'FUNDS_CAPTURE';
585:
586: OPEN c_dupemth(p_from_id,p_to_fk_id,l_flow_type);
587: FETCH c_dupemth INTO l_dup_id;

Line 667: IF (p_parent_entity_name = 'IBY_EXTERNAL_PAYERS_ALL') THEN

663: p_to_id := p_from_id;
664: RETURN;
665: END IF;
666:
667: IF (p_parent_entity_name = 'IBY_EXTERNAL_PAYERS_ALL') THEN
668:
669: UPDATE iby_fndcpt_tx_extensions
670: SET ext_payer_id = p_to_fk_id,
671: last_update_date = hz_utility_pub.last_update_date,