APPS.OKS_AUTO_REMINDER dependencies on OKS_RENEW_UTIL_PUB

Line 2388: 'oks_renew_util_pub.get_template_set_id(p_contract_id= '||

2384:
2385: BEGIN
2386: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2387: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
2388: 'oks_renew_util_pub.get_template_set_id(p_contract_id= '||
2389: l_k_details_rec.ID||')');
2390: END IF;
2391:
2392: l_template_set_id := oks_renew_util_pub.get_template_set_id(l_k_details_rec.ID);

Line 2392: l_template_set_id := oks_renew_util_pub.get_template_set_id(l_k_details_rec.ID);

2388: 'oks_renew_util_pub.get_template_set_id(p_contract_id= '||
2389: l_k_details_rec.ID||')');
2390: END IF;
2391:
2392: l_template_set_id := oks_renew_util_pub.get_template_set_id(l_k_details_rec.ID);
2393:
2394: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2395: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',
2396: 'oks_renew_util_pub.get_template_set_id(x_template_set_id= '||

Line 2396: 'oks_renew_util_pub.get_template_set_id(x_template_set_id= '||

2392: l_template_set_id := oks_renew_util_pub.get_template_set_id(l_k_details_rec.ID);
2393:
2394: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2395: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',
2396: 'oks_renew_util_pub.get_template_set_id(x_template_set_id= '||
2397: l_template_set_id||')');
2398: END IF;
2399: IF l_template_set_id IS NULL THEN
2400: x_is_eligible := 'N';