APPS.IBY_HZ_UNIFICATION_PKG dependencies on IBY_CREDITCARD

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

232: x_return_status IN OUT NOCOPY VARCHAR2
233: )
234: IS
235: CURSOR c_dupecc
236: (ci_instr_id IN iby_creditcard.instrid%TYPE,
237: ci_owner_id IN iby_creditcard.card_owner_id%TYPE)
238: IS
239: SELECT instrid
240: FROM iby_creditcard mto,

Line 237: ci_owner_id IN iby_creditcard.card_owner_id%TYPE)

233: )
234: IS
235: CURSOR c_dupecc
236: (ci_instr_id IN iby_creditcard.instrid%TYPE,
237: ci_owner_id IN iby_creditcard.card_owner_id%TYPE)
238: IS
239: SELECT instrid
240: FROM iby_creditcard mto,
241: (SELECT cc_number_hash1, cc_number_hash2

Line 240: FROM iby_creditcard mto,

236: (ci_instr_id IN iby_creditcard.instrid%TYPE,
237: ci_owner_id IN iby_creditcard.card_owner_id%TYPE)
238: IS
239: SELECT instrid
240: FROM iby_creditcard mto,
241: (SELECT cc_number_hash1, cc_number_hash2
242: FROM iby_creditcard WHERE (instrid = ci_instr_id)) mfrom
243: WHERE
244: mto.card_owner_id = ci_owner_id

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

238: IS
239: SELECT instrid
240: FROM iby_creditcard mto,
241: (SELECT cc_number_hash1, cc_number_hash2
242: FROM iby_creditcard WHERE (instrid = ci_instr_id)) mfrom
243: WHERE
244: mto.card_owner_id = ci_owner_id
245: AND mto.cc_number_hash1 = mfrom.cc_number_hash1
246: AND mto.cc_number_hash2 = mfrom.cc_number_hash2

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

247: AND NVL(mto.active_flag,'Y') = 'Y'
248: AND (NVL(mto.inactive_date,SYSDATE+10) > SYSDATE);
249:
250: l_merge_reason VARCHAR2(30);
251: l_dup_id iby_creditcard.instrid%TYPE := NULL;
252:
253: l_dbg_mod VARCHAR2(100) := G_DEBUG_MODULE || '.credit_card_merge';
254: BEGIN
255: iby_debug_pub.add('Enter',iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);

Line 293: UPDATE iby_creditcard

289:
290: iby_debug_pub.add('duplicate card:='|| l_dup_id,
291: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
292:
293: UPDATE iby_creditcard
294: SET card_owner_id = DECODE(l_dup_id, NULL,p_to_fk_id, card_owner_id),
295: active_flag = DECODE(l_dup_id, NULL,active_flag, 'N'),
296: inactive_date = DECODE(l_dup_id, NULL,inactive_date, SYSDATE),
297: last_update_date = hz_utility_pub.last_update_date,

Line 310: UPDATE iby_creditcard

306: p_to_id := NVL(l_dup_id,p_from_id);
307:
308: ELSIF (p_parent_entity_name = 'HZ_PARTY_SITE_USES') THEN
309:
310: UPDATE iby_creditcard
311: SET addressid = p_to_fk_id,
312: last_update_date = hz_utility_pub.last_update_date,
313: last_updated_by = hz_utility_pub.user_id,
314: last_update_login = hz_utility_pub.last_update_login,

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

390: x_return_status := FND_API.G_RET_STS_SUCCESS;
391:
392: IF (c_dupinstr%ISOPEN) THEN CLOSE c_dupinstr; END IF;
393:
394: IF (p_parent_entity_name = 'IBY_CREDITCARD') THEN
395:
396: IF (p_from_fk_id = p_to_fk_id) THEN
397: p_to_id := p_from_id;
398: RETURN;

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

735: last_updated_by = hz_utility_pub.user_id,
736: last_update_login = hz_utility_pub.last_update_login
737: WHERE (trxnmid = p_from_id);
738:
739: ELSIF (p_parent_entity_name = 'IBY_CREDITCARD') THEN
740:
741: UPDATE iby_trxn_summaries_all
742: SET payerinstrid = p_to_fk_id,
743: last_update_date = hz_utility_pub.last_update_date,