APPS.OKS_AUTO_REMINDER dependencies on OKS_AUTO_REMINDER

Line 1: PACKAGE BODY oks_auto_reminder AS

1: PACKAGE BODY oks_auto_reminder AS
2: /* $Header: OKSARNWB.pls 120.26.12010000.2 2008/10/22 12:48:37 ssreekum ship $ */
3: g_pkg_name CONSTANT VARCHAR2 (200)
4: := 'OKS_AUTO_REMINDER';
5: g_level_procedure CONSTANT NUMBER := fnd_log.level_procedure;

Line 4: := 'OKS_AUTO_REMINDER';

1: PACKAGE BODY oks_auto_reminder AS
2: /* $Header: OKSARNWB.pls 120.26.12010000.2 2008/10/22 12:48:37 ssreekum ship $ */
3: g_pkg_name CONSTANT VARCHAR2 (200)
4: := 'OKS_AUTO_REMINDER';
5: g_level_procedure CONSTANT NUMBER := fnd_log.level_procedure;
6: g_module CONSTANT VARCHAR2 (250)
7: := 'oks.plsql.' ||
8: g_pkg_name ||

Line 247: l_err_msg OKS_AUTO_REMINDER.message_rec_tbl;

243: x_err_msg OUT NOCOPY VARCHAR2
244: ) IS
245:
246: l_counter NUMBER;
247: l_err_msg OKS_AUTO_REMINDER.message_rec_tbl;
248:
249: BEGIN
250:
251: OKS_AUTO_REMINDER.create_user(

Line 251: OKS_AUTO_REMINDER.create_user(

247: l_err_msg OKS_AUTO_REMINDER.message_rec_tbl;
248:
249: BEGIN
250:
251: OKS_AUTO_REMINDER.create_user(
252: p_user_name => p_user_name,
253: x_password => x_password,
254: x_return_status => x_return_status,
255: x_err_msg => l_err_msg

Line 324: x_err_msg OUT NOCOPY oks_auto_reminder.message_rec_tbl

320: p_user_name IN VARCHAR2,
321: p_contract_id IN NUMBER,
322: x_password OUT NOCOPY VARCHAR2,
323: x_return_status OUT NOCOPY VARCHAR2,
324: x_err_msg OUT NOCOPY oks_auto_reminder.message_rec_tbl
325: )
326: IS
327: CURSOR l_user_csr (
328: p_user_name IN VARCHAR2

Line 685: oks_auto_reminder.update_contract_status

681: );
682: END IF;
683:
684: IF l_ste_code = 'ENTERED' THEN
685: oks_auto_reminder.update_contract_status
686: (p_chr_id => TO_NUMBER
687: (p_chr_id),
688: p_status => p_status,
689: x_return_status => x_return_status

Line 1554: oks_auto_reminder.log_interaction (p_api_version => 1.0,

1550: p_sent2_email IN VARCHAR2 DEFAULT NULL
1551: )
1552: IS
1553: BEGIN
1554: oks_auto_reminder.log_interaction (p_api_version => 1.0,
1555: p_init_msg_list => 'F',
1556: x_return_status => x_return_status,
1557: x_msg_count => x_msg_count,
1558: x_msg_data => x_msg_data,

Line 1688: 'OKS_AUTO_REMINDER.get_qtoparty_id(p_chr_id= ' ||

1684: fnd_log.STRING (fnd_log.level_event,
1685: g_module ||
1686: l_api_name ||
1687: '.external_call.before',
1688: 'OKS_AUTO_REMINDER.get_qtoparty_id(p_chr_id= ' ||
1689: p_chr_id ||
1690: ')'
1691: );
1692: END IF;

Line 1695: oks_auto_reminder.get_qtoparty_id (p_chr_id => p_chr_id,

1691: );
1692: END IF;
1693:
1694: -- Get the party ID for logging interaction history
1695: oks_auto_reminder.get_qtoparty_id (p_chr_id => p_chr_id,
1696: x_party_id => l_party_id);
1697:
1698: IF fnd_log.level_event >= fnd_log.g_current_runtime_level
1699: THEN

Line 1704: 'OKS_AUTO_REMINDER.get_qtoparty_id(x_party_id= ' ||

1700: fnd_log.STRING (fnd_log.level_event,
1701: g_module ||
1702: l_api_name ||
1703: '.external_call.after',
1704: 'OKS_AUTO_REMINDER.get_qtoparty_id(x_party_id= ' ||
1705: l_party_id ||
1706: ')'
1707: );
1708: END IF;

Line 1809: oks_auto_reminder.get_qto_email (p_chr_id => p_chr_id,

1805: l_kdetails_rec.contract_number_modifier);
1806:
1807: IF p_sent2_email IS NULL
1808: THEN
1809: oks_auto_reminder.get_qto_email (p_chr_id => p_chr_id,
1810: x_qto_email => l_qto_email);
1811:
1812: IF l_qto_email = okc_api.g_miss_char
1813: THEN

Line 2426: 'oks_auto_reminder.get_qto_email(p_chr_id= '||

2422: IF NVL(x_quote_id, x_cover_id) IS NOT NULL AND x_is_eligible = 'Y' THEN
2423: BEGIN
2424: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2425: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
2426: 'oks_auto_reminder.get_qto_email(p_chr_id= '||
2427: l_k_details_rec.ID||')');
2428: END IF;
2429: oks_auto_reminder.get_qto_email
2430: (

Line 2429: oks_auto_reminder.get_qto_email

2425: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
2426: 'oks_auto_reminder.get_qto_email(p_chr_id= '||
2427: l_k_details_rec.ID||')');
2428: END IF;
2429: oks_auto_reminder.get_qto_email
2430: (
2431: p_chr_id => l_k_details_rec.ID,
2432: x_qto_email => x_qto_email
2433: );

Line 2436: 'oks_auto_reminder.get_qto_email(x_qto_email= '||

2432: x_qto_email => x_qto_email
2433: );
2434: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2435: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',
2436: 'oks_auto_reminder.get_qto_email(x_qto_email= '||
2437: x_qto_email||')');
2438: END IF;
2439: IF x_qto_email IS NULL OR x_qto_email = okc_api.g_miss_char THEN
2440: x_is_eligible := 'N';

Line 3495: END oks_auto_reminder;

3491: p_count => x_msg_count,
3492: p_data => x_msg_data
3493: );
3494: END create_sso_user;
3495: END oks_auto_reminder;