APPS.OKS_RENEW_CONTRACT_PVT dependencies on OKS_K_SALES_CREDITS

Line 1435: DELETE FROM oks_k_sales_credits

1431: END IF;
1432: RETURN;
1433: ELSIF (l_prof_enable_sc = 'NO') THEN
1434: --for NO:Drop, delete all existing sales credits and return
1435: DELETE FROM oks_k_sales_credits
1436: WHERE chr_id = p_chr_id;
1437: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
1438: 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');
1439: END IF;

Line 1453: DELETE FROM oks_k_sales_credits

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

Line 1467: DELETE FROM oks_k_sales_credits

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

Line 1720: INSERT INTO oks_k_sales_credits(

1716: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1717: 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);
1718: END IF;
1719:
1720: INSERT INTO oks_k_sales_credits(
1721: id,
1722: percent,
1723: chr_id,
1724: cle_id,

Line 1761: INSERT INTO oks_k_sales_credits(

1757: END IF;
1758:
1759: EXIT WHEN (l_id_tbl.count = 0);
1760: FORALL i in l_id_tbl.first..l_id_tbl.last
1761: INSERT INTO oks_k_sales_credits(
1762: id,
1763: percent,
1764: chr_id,
1765: cle_id,