126: AND trunc(sysdate) between b.start_date_active and nvl(b.end_date_active, sysdate);
127:
128: is_active_flag c_is_active%rowtype;
129:
130: CURSOR c_jtf_rs_active_grp_mbrs( l_rowid IN ROWID ) IS
131: SELECT 'Y'
132: FROM jtf_rs_active_grp_mbrs
133: WHERE ROWID = l_rowid;
134:
128: is_active_flag c_is_active%rowtype;
129:
130: CURSOR c_jtf_rs_active_grp_mbrs( l_rowid IN ROWID ) IS
131: SELECT 'Y'
132: FROM jtf_rs_active_grp_mbrs
133: WHERE ROWID = l_rowid;
134:
135:
136: BEGIN
418: IF c_is_active%FOUND THEN
419: /* Insert the row into the active group members table by
420: calling the table handler. */
421:
422: jtf_rs_active_grp_mbrs_pkg.insert_row(x_rowid => l_rowid,
423: x_group_member_id => l_group_member_id,
424: x_group_id => l_group_id,
425: x_resource_id => l_resource_id,
426: x_person_id => l_person_id,
431: x_last_update_login => jtf_resource_utl.login_id
432: );
433:
434:
435: OPEN c_jtf_rs_active_grp_mbrs(l_rowid);
436:
437: FETCH c_jtf_rs_active_grp_mbrs INTO l_check_char;
438:
439:
433:
434:
435: OPEN c_jtf_rs_active_grp_mbrs(l_rowid);
436:
437: FETCH c_jtf_rs_active_grp_mbrs INTO l_check_char;
438:
439:
440: IF c_jtf_rs_active_grp_mbrs%NOTFOUND THEN
441:
436:
437: FETCH c_jtf_rs_active_grp_mbrs INTO l_check_char;
438:
439:
440: IF c_jtf_rs_active_grp_mbrs%NOTFOUND THEN
441:
442: fnd_message.set_name('JTF', 'JTF_RS_TABLE_HANDLER_ERROR');
443: fnd_msg_pub.add;
444:
441:
442: fnd_message.set_name('JTF', 'JTF_RS_TABLE_HANDLER_ERROR');
443: fnd_msg_pub.add;
444:
445: IF c_jtf_rs_active_grp_mbrs%ISOPEN THEN
446:
447: CLOSE c_jtf_rs_active_grp_mbrs;
448:
449: END IF;
443: fnd_msg_pub.add;
444:
445: IF c_jtf_rs_active_grp_mbrs%ISOPEN THEN
446:
447: CLOSE c_jtf_rs_active_grp_mbrs;
448:
449: END IF;
450:
451: RAISE fnd_api.g_exc_error;
449: END IF;
450:
451: RAISE fnd_api.g_exc_error;
452: END IF;
453: IF c_jtf_rs_active_grp_mbrs%ISOPEN THEN
454:
455: CLOSE c_jtf_rs_active_grp_mbrs;
456:
457: END IF;
451: RAISE fnd_api.g_exc_error;
452: END IF;
453: IF c_jtf_rs_active_grp_mbrs%ISOPEN THEN
454:
455: CLOSE c_jtf_rs_active_grp_mbrs;
456:
457: END IF;
458: END IF;
459:
1577: );
1578:
1579: -- Delete record in active group members table
1580: BEGIN
1581: jtf_rs_active_grp_mbrs_pkg.delete_row(
1582: x_group_member_id => l_group_member_id
1583: );
1584: EXCEPTION
1585: WHEN no_data_found THEN