APPS.JTF_IH_PUB_PS dependencies on JTF_IH_MEDIA_ITEMS

Line 509: FROM jtf_ih_media_items

505: l_count := 0;
506: IF ((p_act_val_rec.media_id IS NOT NULL) AND (p_act_val_rec.media_id <> fnd_api.g_miss_num)) THEN
507: BEGIN
508: SELECT count(*) into l_count
509: FROM jtf_ih_media_items
510: WHERE media_id = p_act_val_rec.media_id;
511: IF (l_count <= 0) THEN
512: x_return_status := fnd_api.g_ret_sts_error;
513: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(p_act_val_rec.media_id),

Line 677: FROM jtf_ih_media_items

673: END IF;
674: l_count := 0;
675: IF ((p_media_lc_rec.media_id IS NOT NULL) AND (p_media_lc_rec.media_id <> fnd_api.g_miss_num)) THEN
676: SELECT count(*) into l_count
677: FROM jtf_ih_media_items
678: WHERE media_id = p_media_lc_rec.media_id;
679: IF (l_count <= 0) THEN
680: x_return_status := fnd_api.g_ret_sts_error;
681: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(p_media_lc_rec.media_id),

Line 822: SELECT jtf_ih_media_items_s1.NEXTVAL INTO l_int_val_rec.media_id FROM dual;

818: RAISE fnd_api.g_exc_error;
819: END IF;
820: Default_Media_Item_Record(l_int_val_rec);
821: IF ((p_media.media_id IS NULL) OR (p_media.media_id = fnd_api.g_miss_num)) THEN
822: SELECT jtf_ih_media_items_s1.NEXTVAL INTO l_int_val_rec.media_id FROM dual;
823: END IF;
824:
825: insert into jtf_ih_Media_Items
826: (

Line 825: insert into jtf_ih_Media_Items

821: IF ((p_media.media_id IS NULL) OR (p_media.media_id = fnd_api.g_miss_num)) THEN
822: SELECT jtf_ih_media_items_s1.NEXTVAL INTO l_int_val_rec.media_id FROM dual;
823: END IF;
824:
825: insert into jtf_ih_Media_Items
826: (
827: DURATION,
828: DIRECTION,
829: END_DATE_TIME,

Line 1029: SELECT jtf_ih_media_items_s1.NEXTVAL INTO l_media_id FROM dual;

1025: END IF;
1026:
1027: ----DBMS_OUTPUT.PUT_LINE('PAST Validate_Media_Item in JTF_IH_PUB_PS.Create_MediaItem');
1028:
1029: SELECT jtf_ih_media_items_s1.NEXTVAL INTO l_media_id FROM dual;
1030:
1031: ----DBMS_OUTPUT.PUT_LINE('PAST generate PK in JTF_IH_PUB_PS.Create_MediaItem');
1032: insert into jtf_ih_Media_Items
1033: (

Line 1032: insert into jtf_ih_Media_Items

1028:
1029: SELECT jtf_ih_media_items_s1.NEXTVAL INTO l_media_id FROM dual;
1030:
1031: ----DBMS_OUTPUT.PUT_LINE('PAST generate PK in JTF_IH_PUB_PS.Create_MediaItem');
1032: insert into jtf_ih_Media_Items
1033: (
1034: DURATION,
1035: DIRECTION,
1036: END_DATE_TIME,