APPS.JTF_IH_MEDIA_LC_TY_SEED_PKG dependencies on JTF_IH_MEDIA_ITM_LC_SEG_TYS

Line 17: FROM jtf_ih_media_itm_lc_seg_tys

13: , x_short_description VARCHAR2
14: ) IS
15: CURSOR l_insert IS
16: SELECT ROWID
17: FROM jtf_ih_media_itm_lc_seg_tys
18: WHERE milcs_type_id = x_milcs_type_id;
19: BEGIN
20: INSERT INTO jtf_ih_media_itm_lc_seg_tys (
21: milcs_type_id

Line 20: INSERT INTO jtf_ih_media_itm_lc_seg_tys (

16: SELECT ROWID
17: FROM jtf_ih_media_itm_lc_seg_tys
18: WHERE milcs_type_id = x_milcs_type_id;
19: BEGIN
20: INSERT INTO jtf_ih_media_itm_lc_seg_tys (
21: milcs_type_id
22: , object_version_number
23: , created_by
24: , creation_date

Line 54: DELETE FROM jtf_ih_media_itm_lc_seg_tys

50: PROCEDURE delete_row(
51: x_milcs_type_id NUMBER
52: ) IS
53: BEGIN
54: DELETE FROM jtf_ih_media_itm_lc_seg_tys
55: WHERE milcs_type_id = x_milcs_type_id;
56: IF (SQL%NOTFOUND) THEN
57: RAISE NO_DATA_FOUND;
58: END IF;

Line 71: UPDATE jtf_ih_media_itm_lc_seg_tys

67: , x_milcs_code VARCHAR2
68: , x_short_description VARCHAR2
69: ) IS
70: BEGIN
71: UPDATE jtf_ih_media_itm_lc_seg_tys
72: SET
73: milcs_type_id=DECODE(x_milcs_type_id,FND_API.G_MISS_NUM,NULL,x_milcs_type_id)
74: , object_version_number=DECODE(x_object_version_number,FND_API.G_MISS_NUM,NULL,x_object_version_number)
75: , last_updated_by=DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)

Line 100: FROM jtf_ih_media_itm_lc_seg_tys

96: , x_short_description VARCHAR2
97: ) IS
98: CURSOR l_lock IS
99: SELECT *
100: FROM jtf_ih_media_itm_lc_seg_tys
101: WHERE rowid = x_rowid
102: FOR UPDATE OF milcs_type_id NOWAIT;
103: l_table_rec l_lock%ROWTYPE;
104: BEGIN