APPS.JTF_IH_PUB dependencies on JTF_RS_RESOURCE_EXTNS

Line 568: FROM jtf_rs_resource_extns

564: END IF;
565: ELSE
566: BEGIN
567: SELECT count(resource_id) into l_count
568: FROM jtf_rs_resource_extns
569: WHERE resource_id = p_int_val_rec.party_id;
570: IF (l_count <= 0) THEN
571: x_return_status := fnd_api.g_ret_sts_error;
572: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(p_int_val_rec.resource_id),

Line 612: FROM jtf_rs_resource_extns

608: IF ((p_int_val_rec.resource_id IS NOT NULL) AND (p_int_val_rec.resource_id <> fnd_api.g_miss_num)) THEN
609: IF ((p_int_val_rec.touchpoint2_type <> 'PARTY') AND (p_int_val_rec.touchpoint2_type IS NOT NULL)) then
610: BEGIN
611: SELECT count(resource_id) into l_count
612: FROM jtf_rs_resource_extns
613: WHERE resource_id = p_int_val_rec.resource_id;
614: IF (l_count <= 0) THEN
615: x_return_status := fnd_api.g_ret_sts_error;
616: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(p_int_val_rec.resource_id),

Line 3112: FROM jtf_rs_resource_extns

3108: -- Removed by IAleshin 06/04/2002
3109: -- Enh# 2079963
3110: /* IF( p_activities(idx).resource_id IS NOT NULL) AND (p_activities(idx).resource_id <> fnd_api.g_miss_num) THEN
3111: SELECT count(resource_id) into l_count
3112: FROM jtf_rs_resource_extns
3113: WHERE resource_id = p_activities(idx).resource_id;
3114: IF (l_count <= 0) THEN
3115: x_return_status := fnd_api.g_ret_sts_error;
3116: jtf_ih_core_util_pvt.add_invalid_argument_msg(l_api_name_full, to_char(p_activities(idx).resource_id),'resource_id');

Line 5945: FROM jtf_rs_resource_extns

5941: -- Removed by IAleshin 06/04/2002
5942: -- Enh# 2079963
5943: /*IF( p_activity_rec.resource_id IS NOT NULL) AND (p_activity_rec.resource_id <> fnd_api.g_miss_num) THEN
5944: SELECT count(resource_id) into l_count
5945: FROM jtf_rs_resource_extns
5946: WHERE resource_id = p_activity_rec.resource_id;
5947: IF (l_count <= 0) THEN
5948: x_return_status := fnd_api.g_ret_sts_error;
5949: jtf_ih_core_util_pvt.add_invalid_argument_msg(l_api_name_full, to_char(p_activity_rec.resource_id),'resource_id');

Line 6751: FROM jtf_rs_resource_extns

6747: IF(p_activity_rec.resource_id = fnd_api.g_miss_num) THEN
6748: l_resource_id := rc_Activity.resource_id;
6749: ELSE
6750: SELECT count(resource_id) into l_count
6751: FROM jtf_rs_resource_extns
6752: WHERE resource_id = p_activity_rec.resource_id;
6753: IF (l_count <= 0) THEN
6754: x_return_status := fnd_api.g_ret_sts_error;
6755: jtf_ih_core_util_pvt.add_invalid_argument_msg(l_api_name_full, to_char(p_activity_rec.resource_id),'resource_id');