eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_CAL_ITEMS_PVT dependencies on JTF_CAL_ITEMS_TL

Line 165: INSERT INTO JTF_CAL_ITEMS_TL

161: )RETURNING CAL_ITEM_ID INTO l_cal_item_id;
162: /***************************************************************************
163: ** Insert into _TL table
164: ***************************************************************************/
165: INSERT INTO JTF_CAL_ITEMS_TL
166: ( CAL_ITEM_ID
167: , LANGUAGE
168: , SOURCE_LANG
169: , ITEM_NAME

Line 191: FROM JTF_CAL_ITEMS_TL t

187: , p_itm_rec.APPLICATION_ID
188: FROM FND_LANGUAGES l
189: WHERE l.INSTALLED_FLAG IN ('I','B')
190: AND NOT EXISTS ( SELECT NULL
191: FROM JTF_CAL_ITEMS_TL t
192: WHERE t.CAL_ITEM_ID = l_cal_item_id
193: AND t.LANGUAGE = l.LANGUAGE_CODE);
194: /***************************************************************************
195: ** Check whether the insert was succesfull

Line 356: FROM jtf_cal_items_b, jtf_cal_items_tl

352: p_itm_rec.item_name,
353: fnd_api.g_miss_char, item_name,
354: p_itm_rec.item_name
355: ) item_name
356: FROM jtf_cal_items_b, jtf_cal_items_tl
357: WHERE jtf_cal_items_b.cal_item_id = l_cal_item_id
358: AND jtf_cal_items_tl.cal_item_id = jtf_cal_items_b.cal_item_id;
359:
360:

Line 358: AND jtf_cal_items_tl.cal_item_id = jtf_cal_items_b.cal_item_id;

354: p_itm_rec.item_name
355: ) item_name
356: FROM jtf_cal_items_b, jtf_cal_items_tl
357: WHERE jtf_cal_items_b.cal_item_id = l_cal_item_id
358: AND jtf_cal_items_tl.cal_item_id = jtf_cal_items_b.cal_item_id;
359:
360:
361: l_api_name CONSTANT VARCHAR2(30) := 'Update_Row';
362: l_api_version CONSTANT NUMBER := 1.0;

Line 456: UPDATE JTF_CAL_ITEMS_TL

452: IF (SQL%NOTFOUND)THEN
453: RAISE no_data_found;
454: END IF;
455:
456: UPDATE JTF_CAL_ITEMS_TL
457: SET ITEM_NAME = NVL(l_item_rec.ITEM_NAME, ' ')
458: , LAST_UPDATE_DATE = l_item_rec.LAST_UPDATE_DATE
459: , LAST_UPDATED_BY = l_item_rec.LAST_UPDATED_BY
460: , LAST_UPDATE_LOGIN = l_item_rec.LAST_UPDATE_LOGIN

Line 561: DELETE FROM JTF_CAL_ITEMS_TL

557: ** Initialize return status to SUCCESS
558: ***************************************************************************/
559: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
560:
561: DELETE FROM JTF_CAL_ITEMS_TL
562: WHERE CAL_ITEM_ID = p_cal_item_id;
563: /***************************************************************************
564: ** Check whether delete was succesful
565: ***************************************************************************/

Line 824: DELETE FROM JTF_CAL_ITEMS_TL t

820: PROCEDURE Add_Language
821: IS
822: BEGIN
823: -- Delete all records that don't have a base record
824: DELETE FROM JTF_CAL_ITEMS_TL t
825: WHERE NOT EXISTS (SELECT NULL
826: FROM JTF_CAL_ITEMS_B b
827: WHERE b.CAL_ITEM_ID = t.CAL_ITEM_ID
828: );

Line 830: UPDATE JTF_CAL_ITEMS_TL T

826: FROM JTF_CAL_ITEMS_B b
827: WHERE b.CAL_ITEM_ID = t.CAL_ITEM_ID
828: );
829: -- Translate the records that already exists
830: UPDATE JTF_CAL_ITEMS_TL T
831: SET ( ITEM_NAME
832: , ITEM_DESCRIPTION
833: ) = ( SELECT B.ITEM_NAME
834: , B.ITEM_DESCRIPTION

Line 835: FROM JTF_CAL_ITEMS_TL B

831: SET ( ITEM_NAME
832: , ITEM_DESCRIPTION
833: ) = ( SELECT B.ITEM_NAME
834: , B.ITEM_DESCRIPTION
835: FROM JTF_CAL_ITEMS_TL B
836: WHERE B.CAL_ITEM_ID = T.CAL_ITEM_ID
837: AND B.LANGUAGE = T.SOURCE_LANG
838: )
839: WHERE ( T.CAL_ITEM_ID

Line 843: FROM JTF_CAL_ITEMS_TL SUBB

839: WHERE ( T.CAL_ITEM_ID
840: , T.LANGUAGE
841: ) IN ( SELECT SUBT.CAL_ITEM_ID
842: , SUBT.LANGUAGE
843: FROM JTF_CAL_ITEMS_TL SUBB
844: , JTF_CAL_ITEMS_TL SUBT
845: WHERE SUBB.CAL_ITEM_ID = SUBT.CAL_ITEM_ID
846: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
847: AND ( SUBB.ITEM_NAME <> SUBT.ITEM_NAME

Line 844: , JTF_CAL_ITEMS_TL SUBT

840: , T.LANGUAGE
841: ) IN ( SELECT SUBT.CAL_ITEM_ID
842: , SUBT.LANGUAGE
843: FROM JTF_CAL_ITEMS_TL SUBB
844: , JTF_CAL_ITEMS_TL SUBT
845: WHERE SUBB.CAL_ITEM_ID = SUBT.CAL_ITEM_ID
846: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
847: AND ( SUBB.ITEM_NAME <> SUBT.ITEM_NAME
848: OR SUBB.ITEM_DESCRIPTION <> SUBT.ITEM_DESCRIPTION

Line 858: INSERT INTO JTF_CAL_ITEMS_TL

854: )
855: )
856: );
857: -- add records for new languages
858: INSERT INTO JTF_CAL_ITEMS_TL
859: ( CAL_ITEM_ID
860: , CREATED_BY
861: , CREATION_DATE
862: , LAST_UPDATED_BY

Line 881: FROM JTF_CAL_ITEMS_TL B

877: , B.ITEM_DESCRIPTION
878: , L.LANGUAGE_CODE
879: , B.SOURCE_LANG
880: , B.APPLICATION_ID
881: FROM JTF_CAL_ITEMS_TL B
882: , FND_LANGUAGES L
883: WHERE L.INSTALLED_FLAG IN ('I', 'B')
884: AND B.LANGUAGE = USERENV('LANG')
885: AND NOT EXISTS (SELECT NULL

Line 886: FROM JTF_CAL_ITEMS_TL T

882: , FND_LANGUAGES L
883: WHERE L.INSTALLED_FLAG IN ('I', 'B')
884: AND B.LANGUAGE = USERENV('LANG')
885: AND NOT EXISTS (SELECT NULL
886: FROM JTF_CAL_ITEMS_TL T
887: WHERE T.CAL_ITEM_ID = B.CAL_ITEM_ID
888: AND T.LANGUAGE = L.LANGUAGE_CODE
889: );
890: END Add_Language;

Line 916: UPDATE JTF_CAL_ITEMS_TL

912: , p_owner IN VARCHAR2
913: )
914: IS
915: BEGIN
916: UPDATE JTF_CAL_ITEMS_TL
917: SET ITEM_NAME = p_item_name
918: , ITEM_DESCRIPTION = p_item_description
919: , LAST_UPDATE_DATE = SYSDATE
920: , LAST_UPDATED_BY = DECODE(p_owner, 'SEED',1,0)

Line 1026: UPDATE JTF_CAL_ITEMS_TL

1022:
1023: ------------------------------------------------------------------------
1024: -- Try to update the record in the language table
1025: ------------------------------------------------------------------------
1026: UPDATE JTF_CAL_ITEMS_TL
1027: SET ITEM_NAME = p_itm_rec.item_name
1028: , ITEM_DESCRIPTION = p_itm_rec.item_description
1029: , LAST_UPDATE_DATE = SYSDATE
1030: , LAST_UPDATED_BY = l_user_id

Line 1041: INSERT INTO JTF_CAL_ITEMS_TL

1037: -- Apparently the record doesn't exist so create it
1038: ------------------------------------------------------------------------
1039: IF (SQL%NOTFOUND)
1040: THEN
1041: INSERT INTO JTF_CAL_ITEMS_TL
1042: ( CAL_ITEM_ID
1043: , CREATED_BY
1044: , CREATION_DATE
1045: , LAST_UPDATED_BY

Line 1067: FROM JTF_CAL_ITEMS_TL t

1063: , p_itm_rec.application_id
1064: FROM FND_LANGUAGES l
1065: WHERE l.INSTALLED_FLAG IN ('I', 'B')
1066: AND NOT EXISTS( SELECT NULL
1067: FROM JTF_CAL_ITEMS_TL t
1068: WHERE t.CAL_ITEM_ID = p_cal_item_id
1069: AND t.LANGUAGE = l.LANGUAGE_CODE
1070: );
1071: END IF;