APPS.OKS_RENEW_CONTRACT_PVT dependencies on OKS_K_SALES_CREDITS

Line 1434: DELETE FROM oks_k_sales_credits

1430: END IF;
1431: RETURN;
1432: ELSIF (l_prof_enable_sc = 'NO') THEN
1433: --for NO:Drop, delete all existing sales credits and return
1434: DELETE FROM oks_k_sales_credits
1435: WHERE chr_id = p_chr_id;
1436: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
1437: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.end_2', 'Profile OKS_ENABLE_SALES_CREDIT=NO(Drop), deleted sales credits, no fruther processsing');
1438: END IF;

Line 1452: DELETE FROM oks_k_sales_credits

1448: END IF;
1449: FND_MSG_PUB.add;
1450: RAISE FND_API.g_exc_error;
1451: ELSE
1452: DELETE FROM oks_k_sales_credits
1453: WHERE chr_id = p_chr_id;
1454: END IF;
1455: ELSIF (l_prof_enable_sc = 'DRT') THEN
1456: --for DRT:Derive for Revenue Type and Retain Other, delete and derive specified type of sales credit

Line 1466: DELETE FROM oks_k_sales_credits

1462: END IF;
1463: FND_MSG_PUB.add;
1464: RAISE FND_API.g_exc_error;
1465: ELSE
1466: DELETE FROM oks_k_sales_credits
1467: WHERE chr_id = p_chr_id AND sales_credit_type_id1 = l_prof_rev_type;
1468: END IF;
1469: END IF; --of ELSIF (l_prof_enable_sc = 'DRT') THEN
1470:

Line 1712: INSERT INTO oks_k_sales_credits(

1708: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1709: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.hdr_sales_credit', 'creating hdr sales credits with OKS_REVENUE_TYPE_DIST='||l_prof_rev_type_dist);
1710: END IF;
1711:
1712: INSERT INTO oks_k_sales_credits(
1713: id,
1714: percent,
1715: chr_id,
1716: cle_id,

Line 1753: INSERT INTO oks_k_sales_credits(

1749: END IF;
1750:
1751: EXIT WHEN (l_id_tbl.count = 0);
1752: FORALL i in l_id_tbl.first..l_id_tbl.last
1753: INSERT INTO oks_k_sales_credits(
1754: id,
1755: percent,
1756: chr_id,
1757: cle_id,