APPS.CN_ROLE_PAY_GROUPS_PVT dependencies on CN_API

Line 322: l_role_id := cn_api.get_role_id(p_role_name);

318: l_pay_group_id cn_role_pay_groups.pay_group_id%TYPE;
319:
320: BEGIN
321:
322: l_role_id := cn_api.get_role_id(p_role_name);
323: l_pay_group_id := get_pg_id(p_pay_group_name,p_org_id);
324:
325: OPEN l_cur(l_role_id, l_pay_group_id, p_start_date, p_end_date);
326: FETCH l_cur INTO l_rec;

Line 388: IF (cn_api.chk_miss_null_char_para

384:
385: -- validate the following issues
386:
387: -- role_name can not be missing or null
388: IF (cn_api.chk_miss_null_char_para
389: (p_char_para => p_role_pay_groups_rec.role_name,
390: p_obj_name => G_ROLE_NAME,
391: p_loading_status => l_loading_status,
392: x_loading_status => x_loading_status) = FND_API.G_TRUE) THEN

Line 397: IF (cn_api.chk_miss_null_char_para

393: RAISE FND_API.G_EXC_ERROR ;
394: END IF;
395:
396: -- pay_group_name can not be missing or null
397: IF (cn_api.chk_miss_null_char_para
398: (p_char_para => p_role_pay_groups_rec.pay_groups_name,
399: p_obj_name => G_PG_NAME,
400: p_loading_status => l_loading_status,
401: x_loading_status => x_loading_status) = FND_API.G_TRUE) THEN

Line 408: IF ( (cn_api.invalid_date_range

404:
405: -- start_date can not be null
406: -- start_date can not be missing
407: -- start_date < end_date if end_date is null
408: IF ( (cn_api.invalid_date_range
409: (p_start_date => p_role_pay_groups_rec.start_date,
410: p_end_date => p_role_pay_groups_rec.end_date,
411: p_end_date_nullable => FND_API.G_TRUE,
412: p_loading_status => l_loading_status,

Line 427: x_role_id := cn_api.get_role_id(p_role_pay_groups_rec.role_name);

423: END IF;
424: x_loading_status := 'CN_RL_ASGN_ROLE_NOT_EXIST';
425: RAISE fnd_api.g_exc_error;
426: ELSE
427: x_role_id := cn_api.get_role_id(p_role_pay_groups_rec.role_name);
428: END IF;
429: -- pay_group_name must exist in cn_pay_groups
430: IF NOT valid_pay_groups_name(p_role_pay_groups_rec.pay_groups_name,p_role_pay_groups_rec.org_id) THEN
431: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

Line 468: -- Added new message CN_RL_ROLE_PAY_GROUP_OVERLAP for bug 3152146 and included cn_api.date_range_overlap() for checking date overlap

464: END IF;
465:
466: --
467: -- Check for overlapping assignments
468: -- Added new message CN_RL_ROLE_PAY_GROUP_OVERLAP for bug 3152146 and included cn_api.date_range_overlap() for checking date overlap
469: /* SELECT count(1)
470: INTO l_count
471: FROM cn_role_pay_groups
472: WHERE p_role_pay_groups_rec.start_date between start_date AND Nvl(end_date, p_role_pay_groups_rec.start_date)

Line 478: IF ((cn_api.date_range_overlap(l_rec.start_date,

474:
475:
476: FOR l_rec IN l_cur(x_role_id,p_role_pay_groups_rec.org_id)
477: LOOP
478: IF ((cn_api.date_range_overlap(l_rec.start_date,
479: l_rec.end_date,
480: p_role_pay_groups_rec.start_date,
481: p_role_pay_groups_rec.end_date)))
482: THEN

Line 897: -- Inserted cn_api.date_range_overlap and get_date_range_intersect to check for date intersection

893: ,x_object_version_number => p_role_pay_groups_rec.object_version_number);
894:
895: FOR l_rec IN l_srp_cur(l_role_id,p_role_pay_groups_rec.org_id) LOOP
896: SAVEPOINT create_srp_pay_groups;
897: -- Inserted cn_api.date_range_overlap and get_date_range_intersect to check for date intersection
898:
899: IF cn_api.date_range_overlap
900: (a_start_date => l_rec.start_date,
901: a_end_date => l_rec.end_date,

Line 899: IF cn_api.date_range_overlap

895: FOR l_rec IN l_srp_cur(l_role_id,p_role_pay_groups_rec.org_id) LOOP
896: SAVEPOINT create_srp_pay_groups;
897: -- Inserted cn_api.date_range_overlap and get_date_range_intersect to check for date intersection
898:
899: IF cn_api.date_range_overlap
900: (a_start_date => l_rec.start_date,
901: a_end_date => l_rec.end_date,
902: b_start_date => p_role_pay_groups_rec.start_date,
903: b_end_date => p_role_pay_groups_rec.end_date)

Line 907: cn_api.get_date_range_intersect

903: b_end_date => p_role_pay_groups_rec.end_date)
904: THEN
905: /*
906: -- l_rec dates are S-R intersect R-PG dates
907: cn_api.get_date_range_intersect
908: (a_start_date => l_rec.start_date,
909: a_end_date => l_rec.end_date,
910: b_start_date => p_role_pay_groups_rec.start_date,
911: b_end_date => p_role_pay_groups_rec.end_date,

Line 1244: l_role_id := cn_api.get_role_id(p_role_pay_groups_rec.role_name);

1240: RAISE FND_API.G_EXC_ERROR ;
1241: ELSE
1242: -- delete_row
1243:
1244: l_role_id := cn_api.get_role_id(p_role_pay_groups_rec.role_name);
1245: l_pay_group_id := get_pg_id(p_role_pay_groups_rec.pay_groups_name,p_role_pay_groups_rec.org_id);
1246: l_org_id := p_role_pay_groups_rec.org_id;
1247: --check this
1248: cn_role_pay_groups_pkg.delete_row(x_role_pay_group_id => l_role_pay_group_id);