APPS.CN_ROLE_PAY_GROUPS_PVT dependencies on CN_API

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

341: l_pay_group_id cn_role_pay_groups.pay_group_id%TYPE;
342:
343: BEGIN
344:
345: l_role_id := cn_api.get_role_id(p_role_name);
346: l_pay_group_id := get_pg_id(p_pay_group_name,p_org_id);
347:
348: OPEN l_cur(l_role_id, l_pay_group_id, p_start_date, p_end_date);
349: FETCH l_cur INTO l_rec;

Line 411: IF (cn_api.chk_miss_null_char_para

407:
408: -- validate the following issues
409:
410: -- role_name can not be missing or null
411: IF (cn_api.chk_miss_null_char_para
412: (p_char_para => p_role_pay_groups_rec.role_name,
413: p_obj_name => G_ROLE_NAME,
414: p_loading_status => l_loading_status,
415: x_loading_status => x_loading_status) = FND_API.G_TRUE) THEN

Line 420: IF (cn_api.chk_miss_null_char_para

416: RAISE FND_API.G_EXC_ERROR ;
417: END IF;
418:
419: -- pay_group_name can not be missing or null
420: IF (cn_api.chk_miss_null_char_para
421: (p_char_para => p_role_pay_groups_rec.pay_groups_name,
422: p_obj_name => G_PG_NAME,
423: p_loading_status => l_loading_status,
424: x_loading_status => x_loading_status) = FND_API.G_TRUE) THEN

Line 431: IF ( (cn_api.invalid_date_range

427:
428: -- start_date can not be null
429: -- start_date can not be missing
430: -- start_date < end_date if end_date is null
431: IF ( (cn_api.invalid_date_range
432: (p_start_date => p_role_pay_groups_rec.start_date,
433: p_end_date => p_role_pay_groups_rec.end_date,
434: p_end_date_nullable => FND_API.G_TRUE,
435: p_loading_status => l_loading_status,

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

446: END IF;
447: x_loading_status := 'CN_RL_ASGN_ROLE_NOT_EXIST';
448: RAISE fnd_api.g_exc_error;
449: ELSE
450: x_role_id := cn_api.get_role_id(p_role_pay_groups_rec.role_name);
451: END IF;
452: -- pay_group_name must exist in cn_pay_groups
453: IF NOT valid_pay_groups_name(p_role_pay_groups_rec.pay_groups_name,p_role_pay_groups_rec.org_id) THEN
454: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

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

487: END IF;
488:
489: --
490: -- Check for overlapping assignments
491: -- Added new message CN_RL_ROLE_PAY_GROUP_OVERLAP for bug 3152146 and included cn_api.date_range_overlap() for checking date overlap
492: /* SELECT count(1)
493: INTO l_count
494: FROM cn_role_pay_groups
495: WHERE p_role_pay_groups_rec.start_date between start_date AND Nvl(end_date, p_role_pay_groups_rec.start_date)

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

497:
498:
499: FOR l_rec IN l_cur(x_role_id,p_role_pay_groups_rec.org_id)
500: LOOP
501: IF ((cn_api.date_range_overlap(l_rec.start_date,
502: l_rec.end_date,
503: p_role_pay_groups_rec.start_date,
504: p_role_pay_groups_rec.end_date)))
505: THEN

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

943: ,x_object_version_number => p_role_pay_groups_rec.object_version_number);
944:
945: FOR l_rec IN l_srp_cur(l_role_id,p_role_pay_groups_rec.org_id) LOOP
946: SAVEPOINT create_srp_pay_groups;
947: -- Inserted cn_api.date_range_overlap and get_date_range_intersect to check for date intersection
948:
949: IF cn_api.date_range_overlap
950: (a_start_date => l_rec.start_date,
951: a_end_date => l_rec.end_date,

Line 949: IF cn_api.date_range_overlap

945: FOR l_rec IN l_srp_cur(l_role_id,p_role_pay_groups_rec.org_id) LOOP
946: SAVEPOINT create_srp_pay_groups;
947: -- Inserted cn_api.date_range_overlap and get_date_range_intersect to check for date intersection
948:
949: IF cn_api.date_range_overlap
950: (a_start_date => l_rec.start_date,
951: a_end_date => l_rec.end_date,
952: b_start_date => p_role_pay_groups_rec.start_date,
953: b_end_date => p_role_pay_groups_rec.end_date)

Line 957: cn_api.get_date_range_intersect

953: b_end_date => p_role_pay_groups_rec.end_date)
954: THEN
955: /*
956: -- l_rec dates are S-R intersect R-PG dates
957: cn_api.get_date_range_intersect
958: (a_start_date => l_rec.start_date,
959: a_end_date => l_rec.end_date,
960: b_start_date => p_role_pay_groups_rec.start_date,
961: b_end_date => p_role_pay_groups_rec.end_date,

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

1290: RAISE FND_API.G_EXC_ERROR ;
1291: ELSE
1292: -- delete_row
1293:
1294: l_role_id := cn_api.get_role_id(p_role_pay_groups_rec.role_name);
1295: l_pay_group_id := get_pg_id(p_role_pay_groups_rec.pay_groups_name,p_role_pay_groups_rec.org_id);
1296: l_org_id := p_role_pay_groups_rec.org_id;
1297: --check this
1298: cn_role_pay_groups_pkg.delete_row(x_role_pay_group_id => l_role_pay_group_id);