APPS.OKS_RENEW_CONTRACT_PVT dependencies on OKC_CONTACTS

Line 1647: DELETE FROM okc_contacts

1643: END IF;
1644: END IF;
1645:
1646: --delete any old vendor/merchant contacts based on jtf object OKX_SALEPERS
1647: DELETE FROM okc_contacts
1648: WHERE dnz_chr_id = p_chr_id
1649: AND cpl_id = l_cpl_id
1650: AND cro_code IN (SELECT cro_code FROM okc_contact_sources
1651: WHERE buy_or_sell = 'S' AND rle_code = l_rle_code

Line 1663: INSERT INTO OKC_CONTACTS(

1659: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1660: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.create_contact', 'deleted old contacts, creating new contact for salesrep id='||l_salesrep_id);
1661: END IF;
1662:
1663: INSERT INTO OKC_CONTACTS(
1664: id,
1665: cpl_id,
1666: cro_code,
1667: dnz_chr_id,

Line 4831: FROM okc_contacts ctc, fnd_user fnd,

4827: CURSOR c_k_srep_user(cp_chr_id IN NUMBER, cp_cpl_id IN NUMBER, cp_org_id IN NUMBER) IS
4828: SELECT
4829: --rsc.resource_id, srp.salesrep_id, srp.org_id, ctc.cro_code,
4830: fnd.user_id, fnd.user_name
4831: FROM okc_contacts ctc, fnd_user fnd,
4832: jtf_rs_resource_extns rsc, jtf_rs_salesreps srp
4833: WHERE ctc.dnz_chr_id = cp_chr_id
4834: AND ctc.cpl_id = cp_cpl_id
4835: AND ctc.cro_code IN (SELECT src.cro_code FROM okc_contact_sources src