DBA Data[Home] [Help]

APPS.CN_SRP_PMT_PLANS_PVT dependencies on CN_API

Line 197: IF ( (cn_api.invalid_date_range

193: -- Check if date range invalid
194: -- will check : if start_date is null
195: -- if start_date/end_date is missing
196: -- if start_date > end_date
197: IF ( (cn_api.invalid_date_range
198: (p_start_date => p_start_date,
199: p_end_date => p_end_date,
200: p_end_date_nullable => FND_API.G_TRUE,
201: p_loading_status => x_loading_status,

Line 803: fnd_message.set_token('FIELD', cn_api.get_lkup_meaning(p_field, 'CN_NOTE_FIELDS'));

799:
800: l_note_msg VARCHAR2(240);
801: BEGIN
802: fnd_message.set_name('CN', 'CN_SPP_UPD_NOTE');
803: fnd_message.set_token('FIELD', cn_api.get_lkup_meaning(p_field, 'CN_NOTE_FIELDS'));
804: fnd_message.set_token('OLD', p_old_value);
805: fnd_message.set_token('NEW', p_new_value);
806: l_note_msg := fnd_message.get;
807:

Line 1768: /* if cn_api.date_range_overlap(

1764: x_start_date => l_start_date,
1765: x_end_date => l_end_date);
1766:
1767:
1768: /* if cn_api.date_range_overlap(
1769: a_start_date => l_srp_start_date,
1770: a_end_date => l_srp_end_date,
1771: b_start_date => l_pp_start_date,
1772: b_end_date => l_pp_end_date

Line 1775: cn_api.get_date_range_intersect(

1771: b_start_date => l_pp_start_date,
1772: b_end_date => l_pp_end_date
1773: ) THEN
1774:
1775: cn_api.get_date_range_intersect(
1776: a_start_date => l_srp_start_date,
1777: a_end_date => l_srp_end_date,
1778: b_start_date => l_pp_start_date,
1779: b_end_date => l_pp_end_date,

Line 2015: if cn_api.date_range_overlap(

2011: l_end_date_new := NULL;
2012:
2013: x_return_status := FND_API.G_RET_STS_SUCCESS;
2014:
2015: if cn_api.date_range_overlap(
2016: a_start_date => l_srp_start_date_new,
2017: a_end_date => l_srp_end_date_new,
2018: b_start_date => l_pp_start_date_new,
2019: b_end_date => l_pp_end_date_new

Line 2333: (cn_api.date_range_within(

2329: IF ((l_salesrep_id IS NOT NULL)
2330:
2331: AND
2332:
2333: (cn_api.date_range_within(
2334: a_start_date => l_start_date,
2335: a_end_date => l_end_date,
2336: b_start_date => l_role_pp_start_date,
2337: b_end_date => l_role_pp_end_date