DBA Data[Home] [Help]

APPS.IBY_PARTY_MERGE dependencies on IBY_ACCOUNT_OWNERS

Line 19: l_dup_id iby_account_owners.account_owner_party_id%TYPE := NULL;

15: p_batch_party_id IN NUMBER,
16: x_return_status IN OUT NOCOPY VARCHAR2
17: )
18: IS
19: l_dup_id iby_account_owners.account_owner_party_id%TYPE := NULL;
20: l_merge_reason VARCHAR2(30);
21: l_dbg_mod VARCHAR2(100) := G_DEBUG_MODULE || '.acct_owner_merge';
22: g_mesg VARCHAR2(1000) := '';
23:

Line 25: (ci_owner_id IN iby_account_owners.account_owner_id%TYPE,

21: l_dbg_mod VARCHAR2(100) := G_DEBUG_MODULE || '.acct_owner_merge';
22: g_mesg VARCHAR2(1000) := '';
23:
24: CURSOR c_dupeba
25: (ci_owner_id IN iby_account_owners.account_owner_id%TYPE,
26: ci_party_id IN iby_account_owners.account_owner_party_id%TYPE)
27: IS
28: SELECT account_owner_id
29: FROM iby_account_owners mto,

Line 26: ci_party_id IN iby_account_owners.account_owner_party_id%TYPE)

22: g_mesg VARCHAR2(1000) := '';
23:
24: CURSOR c_dupeba
25: (ci_owner_id IN iby_account_owners.account_owner_id%TYPE,
26: ci_party_id IN iby_account_owners.account_owner_party_id%TYPE)
27: IS
28: SELECT account_owner_id
29: FROM iby_account_owners mto,
30: ( SELECT ext_bank_account_id

Line 29: FROM iby_account_owners mto,

25: (ci_owner_id IN iby_account_owners.account_owner_id%TYPE,
26: ci_party_id IN iby_account_owners.account_owner_party_id%TYPE)
27: IS
28: SELECT account_owner_id
29: FROM iby_account_owners mto,
30: ( SELECT ext_bank_account_id
31: FROM iby_account_owners
32: WHERE (account_owner_id = ci_owner_id) ) mfrom
33: WHERE mto.account_owner_party_id = ci_party_id

Line 31: FROM iby_account_owners

27: IS
28: SELECT account_owner_id
29: FROM iby_account_owners mto,
30: ( SELECT ext_bank_account_id
31: FROM iby_account_owners
32: WHERE (account_owner_id = ci_owner_id) ) mfrom
33: WHERE mto.account_owner_party_id = ci_party_id
34: AND mto.ext_bank_account_id = mfrom.ext_bank_account_id;
35:

Line 94: UPDATE iby_account_owners

90:
91: g_mesg := 'duplicate account owner:='|| l_dup_id;
92: fnd_file.put_line(fnd_file.log, g_mesg || l_dbg_mod );
93:
94: UPDATE iby_account_owners
95: SET account_owner_party_id = DECODE(l_dup_id, NULL,p_to_fk_id, account_owner_party_id),
96: end_date = DECODE(l_dup_id, NULL,end_date, SYSDATE),
97: last_update_date = hz_utility_pub.last_update_date,
98: last_updated_by = hz_utility_pub.user_id,