APPS.JTF_IH_PUB dependencies on JTF_IH_MEDIA_ITM_LC_SEG_TYS

Line 1357: FROM jtf_ih_media_itm_lc_seg_tys

1353: IF ((p_media_lc_rec.milcs_type_id IS NOT NULL) AND (p_media_lc_rec.milcs_type_id <> fnd_api.g_miss_num)
1354: AND
1355: (p_media_lc_rec.milcs_code IS NOT NULL) AND (p_media_lc_rec.milcs_code <> fnd_api.g_miss_char)) THEN
1356: SELECT count(milcs_type_id) into l_count
1357: FROM jtf_ih_media_itm_lc_seg_tys
1358: WHERE milcs_type_id = p_media_lc_rec.milcs_type_id;
1359: IF (l_count <= 0) THEN
1360: x_return_status := fnd_api.g_ret_sts_error;
1361: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, p_media_lc_rec.milcs_type_id,

Line 1365: FROM jtf_ih_media_itm_lc_seg_tys

1361: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, p_media_lc_rec.milcs_type_id,
1362: 'milcs_type_id');
1363: END IF;
1364: SELECT count(milcs_type_id) into l_count
1365: FROM jtf_ih_media_itm_lc_seg_tys
1366: WHERE milcs_code = p_media_lc_rec.milcs_code;
1367: IF (l_count <= 0) THEN
1368: x_return_status := fnd_api.g_ret_sts_error;
1369: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, p_media_lc_rec.milcs_code,

Line 1379: FROM jtf_ih_media_itm_lc_seg_tys

1375: END IF;
1376: IF (((p_media_lc_rec.milcs_type_id IS NOT NULL) AND (p_media_lc_rec.milcs_type_id <> fnd_api.g_miss_num)) AND
1377: ((p_media_lc_rec.milcs_code IS NULL) OR (p_media_lc_rec.milcs_code = fnd_api.g_miss_char))) THEN
1378: SELECT count(milcs_type_id) into l_count
1379: FROM jtf_ih_media_itm_lc_seg_tys
1380: WHERE milcs_type_id = p_media_lc_rec.milcs_type_id;
1381: IF (l_count <= 0) THEN
1382: x_return_status := fnd_api.g_ret_sts_error;
1383: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, p_media_lc_rec.milcs_type_id,

Line 1390: FROM jtf_ih_media_itm_lc_seg_tys

1386: END IF;
1387: END IF;
1388: IF ((p_media_lc_rec.milcs_code IS NOT NULL) AND (p_media_lc_rec.milcs_code <> fnd_api.g_miss_char)) THEN
1389: SELECT count(milcs_type_id) into l_count
1390: FROM jtf_ih_media_itm_lc_seg_tys
1391: WHERE milcs_code = p_media_lc_rec.milcs_code;
1392: IF (l_count <= 0) THEN
1393: x_return_status := fnd_api.g_ret_sts_error;
1394: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, p_media_lc_rec.milcs_code,

Line 2593: from jtf_ih_media_itm_lc_seg_tys

2589: l_media_lc_rec.milcs_type_id := p_media_lc_rec.milcs_type_id;
2590: IF ((p_media_lc_rec.milcs_type_id IS NULL) OR (p_media_lc_rec.milcs_type_id = FND_API.G_MISS_NUM)) THEN
2591: --select milcs_type_id into l_milcs_type_id
2592: select milcs_type_id into l_media_lc_rec.milcs_type_id
2593: from jtf_ih_media_itm_lc_seg_tys
2594: where milcs_code = p_media_lc_rec.milcs_code;
2595: END IF;
2596:
2597: -- Bug# 2817083

Line 8816: from JTF_IH_MEDIA_ITM_LC_SEG_TYS

8812: IF ((p_media_lc_rec.milcs_type_id IS NULL) OR (p_media_lc_rec.milcs_type_id = fnd_api.g_miss_num)) THEN
8813: select milcs_type_id
8814: --INTO l_milcs_type_id
8815: INTO l_media_lc_rec.milcs_type_id
8816: from JTF_IH_MEDIA_ITM_LC_SEG_TYS
8817: where milcs_code = p_media_lc_rec.milcs_code;
8818: ELSE
8819: --l_milcs_type_id := p_media_lc_rec.milcs_type_id;
8820: l_media_lc_rec.milcs_type_id := p_media_lc_rec.milcs_type_id;