APPS.JTF_RS_GROUP_MEMBERS_PVT dependencies on JTF_RS_ACTIVE_GRP_MBRS

Line 130: CURSOR c_jtf_rs_active_grp_mbrs( l_rowid IN ROWID ) IS

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:

Line 132: FROM jtf_rs_active_grp_mbrs

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

Line 422: jtf_rs_active_grp_mbrs_pkg.insert_row(x_rowid => l_rowid,

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,

Line 435: OPEN c_jtf_rs_active_grp_mbrs(l_rowid);

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:

Line 437: FETCH c_jtf_rs_active_grp_mbrs INTO l_check_char;

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:

Line 440: IF c_jtf_rs_active_grp_mbrs%NOTFOUND THEN

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:

Line 445: IF c_jtf_rs_active_grp_mbrs%ISOPEN THEN

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;

Line 447: CLOSE c_jtf_rs_active_grp_mbrs;

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;

Line 453: IF c_jtf_rs_active_grp_mbrs%ISOPEN THEN

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;

Line 455: CLOSE c_jtf_rs_active_grp_mbrs;

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:

Line 1581: jtf_rs_active_grp_mbrs_pkg.delete_row(

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