APPS.OKS_RENEW_CONTRACT_PVT dependencies on OKC_CONTACTS

Line 1648: DELETE FROM okc_contacts

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

Line 1664: INSERT INTO OKC_CONTACTS(

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

Line 4866: FROM okc_contacts ctc, fnd_user fnd,

4862: CURSOR c_k_srep_user(cp_chr_id IN NUMBER, cp_cpl_id IN NUMBER, cp_org_id IN NUMBER) IS
4863: SELECT
4864: --rsc.resource_id, srp.salesrep_id, srp.org_id, ctc.cro_code,
4865: fnd.user_id, fnd.user_name
4866: FROM okc_contacts ctc, fnd_user fnd,
4867: jtf_rs_resource_extns rsc, jtf_rs_salesreps srp
4868: WHERE ctc.dnz_chr_id = cp_chr_id
4869: AND ctc.cpl_id = cp_cpl_id
4870: AND ctc.cro_code IN (SELECT src.cro_code FROM okc_contact_sources src