[Home] [Help]
1175: l_count := 0;
1176: IF ((p_act_val_rec.media_id IS NOT NULL) AND (p_act_val_rec.media_id <> fnd_api.g_miss_num)) THEN
1177: BEGIN
1178: SELECT count(media_id) into l_count
1179: FROM jtf_ih_media_items
1180: WHERE media_id = p_act_val_rec.media_id;
1181: IF (l_count <= 0) THEN
1182: x_return_status := fnd_api.g_ret_sts_error;
1183: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(p_act_val_rec.media_id),
1415: END IF;
1416: l_count := 0;
1417: IF ((p_media_lc_rec.media_id IS NOT NULL) AND (p_media_lc_rec.media_id <> fnd_api.g_miss_num)) THEN
1418: SELECT count(media_id) into l_count
1419: FROM jtf_ih_media_items
1420: WHERE media_id = p_media_lc_rec.media_id;
1421: IF (l_count <= 0) THEN
1422: x_return_status := fnd_api.g_ret_sts_error;
1423: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(p_media_lc_rec.media_id),
1588: BEGIN
1589: IF (n_media_id IS NOT NULL) AND (n_media_id <> fnd_api.g_miss_num) THEN
1590: -- Check activity value in the JTF_IH_ACTIVITIES table.
1591: BEGIN
1592: SELECT media_id INTO n_Return FROM jtf_ih_media_items WHERE media_id = n_media_id;
1593: -- If value is presend then return an error (invalid activity_id)
1594: IF n_Return IS NOT NULL THEN
1595: FND_MESSAGE.SET_NAME('JTF','JTF_IH_API_INVALID_MEDIA_ID');
1596: FND_MESSAGE.SET_TOKEN('VALUE', n_media_id);
1603: RETURN n_media_id;
1604: END;
1605: ELSIF ((n_media_id IS NULL) OR (n_media_id = fnd_api.g_miss_num)) THEN
1606: LOOP
1607: SELECT jtf_ih_media_items_s1.NEXTVAL INTO n_Return FROM dual;
1608: BEGIN
1609: SELECT n_media_id INTO n_Dummy FROM jtf_ih_media_items WHERE media_id = n_Return;
1610: EXCEPTION
1611: WHEN NO_DATA_FOUND THEN
1605: ELSIF ((n_media_id IS NULL) OR (n_media_id = fnd_api.g_miss_num)) THEN
1606: LOOP
1607: SELECT jtf_ih_media_items_s1.NEXTVAL INTO n_Return FROM dual;
1608: BEGIN
1609: SELECT n_media_id INTO n_Dummy FROM jtf_ih_media_items WHERE media_id = n_Return;
1610: EXCEPTION
1611: WHEN NO_DATA_FOUND THEN
1612: EXIT;
1613: END;
1680: -- Igor Aleshin 18-JUN-2003 Enh# 1846960 - REQUIRE CONTACT NAME OF
1681: -- ORGANISATION IN INTERACTION HISTORY
1682: -- Igor Aleshin 01-JUL-2003 Added to missed columns to insert statments
1683: -- Igor Aleshin 03-JUL-2003 Enh# 3022511 - Add a column to the
1684: -- jtf_ih_media_items table
1685: -- vekrishn 27-JUL-2004 Perf Fix for literal Usage
1686: --
1687:
1688: PROCEDURE Create_MediaItem
1825: l_int_val_rec.address := p_media.address;
1826: END IF;
1827:
1828: --IF ((p_media.media_id IS NULL) OR (p_media.media_id = fnd_api.g_miss_num)) THEN
1829: -- SELECT jtf_ih_media_items_s1.NEXTVAL INTO l_int_val_rec.media_id FROM dual;
1830: --END IF;
1831: -- Bug# 2817083
1832: l_int_val_rec.media_id := Get_Media_Id(p_media.media_id);
1833: IF l_int_val_rec.media_id = -1 THEN
1834: RAISE fnd_api.g_exc_error;
1835: END IF;
1836:
1837: -- Perf fix for literal Usage
1838: insert into jtf_ih_Media_Items
1839: (
1840: DURATION,
1841: DIRECTION,
1842: END_DATE_TIME,
2070: -- Igor Aleshin 18-APR-2001 Fix for bugdb 2323210 - 1157.6RI:API
2071: -- ERR:JTF_IH_PUB.CLOSE_INTERACTION:WHEN DISAGREE WITH OKC IN IBE
2072: -- Igor Aleshin 24-FEB-2003 Fixed bug# 2817083 - Error loggin interactions
2073: -- Igor Aleshin 29-MAY-2003 Enh# 2940473 - IH Bulk API Changes
2074: -- Igor Aleshin 03-JUL-2003 Enh# 3022511 - Add a column to the jtf_ih_media_items table
2075: -- vekrishn 27-JUL-2004 Perf Fix for literal Usage
2076: --
2077: --
2078:
2260: l_media_rec.address := p_media_rec.address;
2261: END IF;
2262:
2263:
2264: --SELECT jtf_ih_media_items_s1.NEXTVAL INTO l_media_id FROM dual;
2265: --l_media_id := Get_Media_Id(NULL);
2266: l_media_rec.media_id := Get_Media_Id(NULL);
2267:
2268: -- DBMS_OUTPUT.PUT_LINE('PAST generate PK in JTF_IH_PUB.Create_MediaItem');
2265: --l_media_id := Get_Media_Id(NULL);
2266: l_media_rec.media_id := Get_Media_Id(NULL);
2267:
2268: -- DBMS_OUTPUT.PUT_LINE('PAST generate PK in JTF_IH_PUB.Create_MediaItem');
2269: insert into jtf_ih_Media_Items
2270: (
2271: DURATION,
2272: DIRECTION,
2273: END_DATE_TIME,
7514: -- THE END_DATE_TIME VALUE.
7515: -- Igor Aleshin 21-MAY-2002 Removed decode function from Source_Item_Create_Date_Time in Insert
7516: -- statement
7517: -- Igor Aleshin 24-FEB-2003 Fixed bug# 2817083 - Error loggin interactions
7518: -- Igor Aleshin 03-JUL-2003 Enh# 3022511 - Add a column to the jtf_ih_media_items table
7519: -- vekrishn 27-JUL-2004 Perf Fix for literal Usage
7520: --
7521: --
7522:
7706: l_media_rec.address := p_media_rec.address;
7707: END IF;
7708:
7709: -- Bug# 2817083
7710: --SELECT JTF_IH_MEDIA_ITEMS_S1.NextVal into l_media_id FROM dual;
7711: --l_media_id := Get_Media_Id(NULL);
7712: l_media_rec.media_id := Get_Media_Id(NULL);
7713:
7714: INSERT INTO jtf_ih_media_items
7710: --SELECT JTF_IH_MEDIA_ITEMS_S1.NextVal into l_media_id FROM dual;
7711: --l_media_id := Get_Media_Id(NULL);
7712: l_media_rec.media_id := Get_Media_Id(NULL);
7713:
7714: INSERT INTO jtf_ih_media_items
7715: (
7716: CREATED_BY,
7717: CREATION_DATE,
7718: LAST_UPDATED_BY,
7775: decode( l_media_rec.address, fnd_api.g_miss_char, null, l_media_rec.address),
7776: l_ao_update_pending_perf,
7777: l_soft_closed_perf
7778: );
7779: -- DBMS_OUTPUT.PUT_LINE('PAST INSERT INTO jtf_ih_media_items in JTF_IH_PUB.Open_MediaItem');
7780:
7781:
7782: --
7783: -- Set OUT value
7862: -- Igor Aleshin 07-MAY-2002 Bug# 2338832 - 1156-1157: IH API G_MISS CLEAN-UP REPLACEMENT PATCH
7863: -- Igor Aleshin 09-MAY-2002 Bug# 2363404 - IH API: ITEM NOT ALLOWING NULLS
7864: -- Igor Aleshin 20-MAY-2002 Modified duration Calculation
7865: -- Igor Aleshin 29-MAY-2003 Enh# 2940473 - IH Bulk API Changes
7866: -- Igor Aleshin 03-JUL-2003 Enh# 3022511 - Add a column to the jtf_ih_media_items table
7867: -- Igor Aleshin 15-MAR-2004 Enh# 3491849 - JTH.R: IH CHANGES TO SUPPORT FTC ABANDONMENT REGULATIONS
7868: --
7869:
7870: PROCEDURE Update_MediaItem
7912: b_Duration BOOLEAN := FALSE;
7913:
7914: CURSOR c_MediaItem_csr IS
7915: SELECT *
7916: FROM JTF_IH_MEDIA_ITEMS
7917: WHERE media_id = p_media_rec.media_id
7918: FOR UPDATE;
7919: l_MediaItem_rec c_MediaItem_csr%ROWTYPE;
7920:
8261: RAISE fnd_api.g_exc_error;
8262: END IF;
8263: -- DBMS_OUTPUT.PUT_LINE('PAST Validate_MediaItem_Record in JTF_IH_PUB.Update_MediaItem');
8264:
8265: UPDATE JTF_IH_MEDIA_ITEMS
8266: SET source_id = l_media_rec.source_id,
8267: direction = l_media_rec.direction,
8268: duration = l_media_rec.duration,
8269: end_date_time = l_media_rec.end_date_time,
8513: -- Get current values for ao_update_pending and soft_closed columns and end_date_time
8514: --
8515: SELECT ao_update_pending, direction, media_item_type, end_date_time
8516: INTO l_ao_update_pending, l_direction, l_media_item_type, l_end_date_time
8517: FROM JTF_IH_MEDIA_ITEMS WHERE Media_Id = p_media_rec.media_id;
8518:
8519: -- Check end_date_time parameter.
8520: --
8521: IF p_media_rec.end_date_time <> fnd_api.g_miss_date AND p_media_rec.end_date_time IS NOT NULL THEN
8552: --
8553: IF l_direction = 'OUTBOUND' AND l_media_item_type = 'TELEPHONE' THEN
8554: IF l_ao_update_pending = 'Y' THEN
8555: -- Soft close the MI
8556: UPDATE JTF_IH_MEDIA_ITEMS
8557: SET SOFT_CLOSED = l_soft_closed_perf
8558: WHERE MEDIA_ID = p_media_rec.media_id;
8559: ELSE
8560: -- hard close the MI
8557: SET SOFT_CLOSED = l_soft_closed_perf
8558: WHERE MEDIA_ID = p_media_rec.media_id;
8559: ELSE
8560: -- hard close the MI
8561: UPDATE JTF_IH_MEDIA_ITEMS
8562: SET ACTIVE = l_active_perf
8563: WHERE MEDIA_ID = p_media_rec.media_id;
8564: END IF;
8565: ELSE
8563: WHERE MEDIA_ID = p_media_rec.media_id;
8564: END IF;
8565: ELSE
8566: -- hard close the MI
8567: UPDATE JTF_IH_MEDIA_ITEMS
8568: set ACTIVE = l_active_perf
8569: WHERE MEDIA_ID = p_media_rec.media_id;
8570: END IF;
8571: