APPS.IBY_HZ_UNIFICATION_PKG dependencies on IBY_EXTERNAL_PAYERS_ALL

Line 19: l_dup_id iby_external_payers_all.ext_payer_id%TYPE;

15: p_batch_party_id IN NUMBER,
16: x_return_status IN OUT NOCOPY VARCHAR2
17: )
18: IS
19: l_dup_id iby_external_payers_all.ext_payer_id%TYPE;
20:
21: CURSOR c_dupepayer
22: (ci_payer_id IN iby_external_payers_all.ext_payer_id%TYPE,
23: ci_party_id IN iby_external_payers_all.party_id%TYPE)

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

18: IS
19: l_dup_id iby_external_payers_all.ext_payer_id%TYPE;
20:
21: CURSOR c_dupepayer
22: (ci_payer_id IN iby_external_payers_all.ext_payer_id%TYPE,
23: ci_party_id IN iby_external_payers_all.party_id%TYPE)
24: IS
25: SELECT ext_payer_id
26: FROM iby_external_payers_all mto,

Line 23: ci_party_id IN iby_external_payers_all.party_id%TYPE)

19: l_dup_id iby_external_payers_all.ext_payer_id%TYPE;
20:
21: CURSOR c_dupepayer
22: (ci_payer_id IN iby_external_payers_all.ext_payer_id%TYPE,
23: ci_party_id IN iby_external_payers_all.party_id%TYPE)
24: IS
25: SELECT ext_payer_id
26: FROM iby_external_payers_all mto,
27: (SELECT payment_function,ci_party_id,cust_account_id,acct_site_use_id,

Line 26: FROM iby_external_payers_all mto,

22: (ci_payer_id IN iby_external_payers_all.ext_payer_id%TYPE,
23: ci_party_id IN iby_external_payers_all.party_id%TYPE)
24: IS
25: SELECT ext_payer_id
26: FROM iby_external_payers_all mto,
27: (SELECT payment_function,ci_party_id,cust_account_id,acct_site_use_id,
28: org_type,org_id
29: FROM iby_external_payers_all
30: WHERE (ext_payer_id = ci_payer_id)) mfrom

Line 29: FROM iby_external_payers_all

25: SELECT ext_payer_id
26: FROM iby_external_payers_all mto,
27: (SELECT payment_function,ci_party_id,cust_account_id,acct_site_use_id,
28: org_type,org_id
29: FROM iby_external_payers_all
30: WHERE (ext_payer_id = ci_payer_id)) mfrom
31: WHERE mto.ext_payer_id <> ci_payer_id
32: AND mto.payment_function = mfrom.payment_function
33: AND mto.party_id = ci_party_id

Line 61: UPDATE iby_external_payers_all

57: iby_debug_pub.add('duplicate payer:='|| l_dup_id,
58: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
59:
60: IF (l_dup_id IS NULL) THEN
61: UPDATE iby_external_payers_all
62: SET party_id = p_to_fk_id,
63: last_update_date = hz_utility_pub.last_update_date,
64: last_updated_by = hz_utility_pub.user_id,
65: last_update_login = hz_utility_pub.last_update_login

Line 423: OR (p_parent_entity_name = 'IBY_EXTERNAL_PAYERS_ALL')

419: p_to_id := l_dup_id;
420: END IF;
421:
422: ELSIF (p_parent_entity_name = 'IBY_EXTERNAL_PAYEES_ALL')
423: OR (p_parent_entity_name = 'IBY_EXTERNAL_PAYERS_ALL')
424: THEN
425:
426: IF (p_from_fk_id = p_to_fk_id) THEN
427: p_to_id := p_from_id;

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

427: p_to_id := p_from_id;
428: RETURN;
429: END IF;
430:
431: IF (p_parent_entity_name = 'IBY_EXTERNAL_PAYERS_ALL') THEN
432: l_flow_type := 'FUNDS_CAPTURE';
433: ELSE
434: l_flow_type := 'DISBURSEMENTS';
435: END IF;

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

596: p_to_id := p_from_id;
597: RETURN;
598: END IF;
599:
600: IF (p_parent_entity_name = 'IBY_EXTERNAL_PAYERS_ALL') THEN
601: l_flow_type := 'FUNDS_CAPTURE';
602: ELSE
603: l_flow_type := 'DISBURSEMENTS';
604: END IF;

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

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

Line 806: ELSIF (p_parent_entity_name = 'IBY_EXTERNAL_PAYERS_ALL') THEN

802: last_update_login = hz_utility_pub.last_update_login
803: WHERE (document_payable_id = p_from_id)
804: AND (beneficiary_party = p_from_fk_id);
805:
806: ELSIF (p_parent_entity_name = 'IBY_EXTERNAL_PAYERS_ALL') THEN
807:
808: UPDATE iby_docs_payable_all
809: SET ext_payee_id = p_to_fk_id,
810: last_update_date = hz_utility_pub.last_update_date,

Line 894: ELSIF (p_parent_entity_name = 'IBY_EXTERNAL_PAYERS_ALL') THEN

890: last_update_login = hz_utility_pub.last_update_login
891: WHERE (payment_id = p_from_id)
892: AND (payer_party_id = p_from_fk_id);
893:
894: ELSIF (p_parent_entity_name = 'IBY_EXTERNAL_PAYERS_ALL') THEN
895:
896: UPDATE iby_payments_all
897: SET ext_payee_id = p_to_fk_id,
898: last_update_date = hz_utility_pub.last_update_date,