APPS.IBY_PARTY_MERGE dependencies on IBY_CREDITCARD

Line 140: (ci_instr_id IN iby_creditcard.instrid%TYPE,

136: )
137: IS
138:
139: CURSOR c_dupecc
140: (ci_instr_id IN iby_creditcard.instrid%TYPE,
141: ci_owner_id IN iby_creditcard.card_owner_id%TYPE)
142: IS
143: SELECT instrid
144: FROM iby_creditcard mto,

Line 141: ci_owner_id IN iby_creditcard.card_owner_id%TYPE)

137: IS
138:
139: CURSOR c_dupecc
140: (ci_instr_id IN iby_creditcard.instrid%TYPE,
141: ci_owner_id IN iby_creditcard.card_owner_id%TYPE)
142: IS
143: SELECT instrid
144: FROM iby_creditcard mto,
145: (SELECT cc_number_hash1, cc_number_hash2

Line 144: FROM iby_creditcard mto,

140: (ci_instr_id IN iby_creditcard.instrid%TYPE,
141: ci_owner_id IN iby_creditcard.card_owner_id%TYPE)
142: IS
143: SELECT instrid
144: FROM iby_creditcard mto,
145: (SELECT cc_number_hash1, cc_number_hash2
146: FROM iby_creditcard WHERE (instrid = ci_instr_id)) mfrom
147: WHERE
148: mto.card_owner_id = ci_owner_id

Line 146: FROM iby_creditcard WHERE (instrid = ci_instr_id)) mfrom

142: IS
143: SELECT instrid
144: FROM iby_creditcard mto,
145: (SELECT cc_number_hash1, cc_number_hash2
146: FROM iby_creditcard WHERE (instrid = ci_instr_id)) mfrom
147: WHERE
148: mto.card_owner_id = ci_owner_id
149: AND mto.cc_number_hash1 = mfrom.cc_number_hash1
150: AND mto.cc_number_hash2 = mfrom.cc_number_hash2

Line 155: l_dup_id iby_creditcard.instrid%TYPE := NULL;

151: AND NVL(mto.active_flag,'Y') = 'Y'
152: AND (NVL(mto.inactive_date,SYSDATE+10) > SYSDATE);
153:
154: l_merge_reason VARCHAR2(30);
155: l_dup_id iby_creditcard.instrid%TYPE := NULL;
156: l_dbg_mod VARCHAR2(100) := G_DEBUG_MODULE || '.credit_card_merge';
157: g_mesg VARCHAR2(1000) := '';
158:
159: BEGIN

Line 218: UPDATE iby_creditcard

214:
215: g_mesg :='duplicate card:='|| l_dup_id;
216: fnd_file.put_line(fnd_file.log, g_mesg || l_dbg_mod );
217:
218: UPDATE iby_creditcard
219: SET card_owner_id = DECODE(l_dup_id, NULL,p_to_fk_id, card_owner_id),
220: active_flag = DECODE(l_dup_id, NULL,active_flag, 'N'),
221: inactive_date = DECODE(l_dup_id, NULL,inactive_date, SYSDATE),
222: last_update_date = hz_utility_pub.last_update_date,

Line 235: UPDATE iby_creditcard

231: p_to_id := NVL(l_dup_id,p_from_id);
232:
233: ELSIF (p_parent_entity_name = 'HZ_PARTY_SITE_USES') THEN
234:
235: UPDATE iby_creditcard
236: SET addressid = p_to_fk_id,
237: last_update_date = hz_utility_pub.last_update_date,
238: last_updated_by = hz_utility_pub.user_id,
239: last_update_login = hz_utility_pub.last_update_login,

Line 446: IF (p_parent_entity_name = 'IBY_CREDITCARD') THEN

442:
443: IF (c_dupinstr%ISOPEN) THEN CLOSE c_dupinstr; END IF;
444: IF (c_dupeparty%ISOPEN) THEN CLOSE c_dupeparty; END IF;
445:
446: IF (p_parent_entity_name = 'IBY_CREDITCARD') THEN
447:
448: IF (p_from_fk_id = p_to_fk_id) THEN
449: p_to_id := p_from_id;
450: RETURN;

Line 764: ELSIF (p_parent_entity_name = 'IBY_CREDITCARD') THEN

760: last_updated_by = hz_utility_pub.user_id,
761: last_update_login = hz_utility_pub.last_update_login
762: WHERE (trxnmid = p_from_id);
763:
764: ELSIF (p_parent_entity_name = 'IBY_CREDITCARD') THEN
765:
766: UPDATE iby_trxn_summaries_all
767: SET payerinstrid = p_to_fk_id,
768: last_update_date = hz_utility_pub.last_update_date,