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_B

Line 21: FROM jtf_cal_items_b

17: ** Cursor to lock the record
18: ***************************************************************************/
19: ( b_cal_item_id IN NUMBER
20: )IS SELECT object_version_number
21: FROM jtf_cal_items_b
22: WHERE cal_item_id = b_cal_item_id
23: FOR UPDATE OF object_version_number NOWAIT;
24:
25: l_object_version_number NUMBER;

Line 90: FROM JTF_CAL_ITEMS_B

86:
87: CURSOR c_record_exists
88: (b_cal_item_id NUMBER
89: )IS SELECT ROWID
90: FROM JTF_CAL_ITEMS_B
91: WHERE cal_item_id = b_cal_item_id;
92:
93: BEGIN
94: SAVEPOINT create_calitems_pvt;

Line 123: INSERT INTO JTF_CAL_ITEMS_B

119: ** Insert into table. Generate the ID from the
120: ** sequence and return it
121: ***************************************************************************/
122:
123: INSERT INTO JTF_CAL_ITEMS_B
124: ( CAL_ITEM_ID
125: , RESOURCE_ID
126: , RESOURCE_TYPE
127: , ITEM_TYPE

Line 323: fnd_api.g_miss_num, jtf_cal_items_b.created_by,

319: p_itm_rec.url
320: ) url,
321: DECODE (
322: p_itm_rec.created_by,
323: fnd_api.g_miss_num, jtf_cal_items_b.created_by,
324: p_itm_rec.created_by
325: ) created_by,
326: DECODE (
327: p_itm_rec.creation_date,

Line 328: fnd_api.g_miss_date, jtf_cal_items_b.creation_date,

324: p_itm_rec.created_by
325: ) created_by,
326: DECODE (
327: p_itm_rec.creation_date,
328: fnd_api.g_miss_date, jtf_cal_items_b.creation_date,
329: p_itm_rec.creation_date
330: ) creation_date,
331: DECODE (
332: p_itm_rec.last_updated_by,

Line 333: fnd_api.g_miss_num, jtf_cal_items_b.last_updated_by,

329: p_itm_rec.creation_date
330: ) creation_date,
331: DECODE (
332: p_itm_rec.last_updated_by,
333: fnd_api.g_miss_num, jtf_cal_items_b.last_updated_by,
334: p_itm_rec.last_updated_by
335: ) last_updated_by,
336: DECODE (
337: p_itm_rec.last_update_date,

Line 338: fnd_api.g_miss_date, jtf_cal_items_b.last_update_date,

334: p_itm_rec.last_updated_by
335: ) last_updated_by,
336: DECODE (
337: p_itm_rec.last_update_date,
338: fnd_api.g_miss_date, jtf_cal_items_b.last_update_date,
339: p_itm_rec.last_update_date
340: ) last_update_date,
341: DECODE (
342: p_itm_rec.last_update_login,

Line 343: fnd_api.g_miss_num, jtf_cal_items_b.last_update_login,

339: p_itm_rec.last_update_date
340: ) last_update_date,
341: DECODE (
342: p_itm_rec.last_update_login,
343: fnd_api.g_miss_num, jtf_cal_items_b.last_update_login,
344: p_itm_rec.last_update_login
345: ) last_update_login,
346: DECODE (
347: p_itm_rec.application_id,

Line 348: fnd_api.g_miss_num, jtf_cal_items_b.application_id,

344: p_itm_rec.last_update_login
345: ) last_update_login,
346: DECODE (
347: p_itm_rec.application_id,
348: fnd_api.g_miss_num, jtf_cal_items_b.application_id,
349: p_itm_rec.application_id
350: ) application_id,
351: DECODE (
352: p_itm_rec.item_name,

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 357: WHERE jtf_cal_items_b.cal_item_id = l_cal_item_id

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:
361: l_api_name CONSTANT VARCHAR2(30) := 'Update_Row';

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 432: UPDATE JTF_CAL_ITEMS_B

428: l_url := GetUrl(l_item_rec.source_code);
429: /***************************************************************************
430: ** Update the record
431: ***************************************************************************/
432: UPDATE JTF_CAL_ITEMS_B
433: SET RESOURCE_ID = l_item_rec.resource_id
434: , RESOURCE_TYPE = l_item_rec.resource_type
435: , SOURCE_CODE = l_item_rec.source_code
436: , SOURCE_ID = l_item_rec.source_id

Line 577: DELETE FROM JTF_CAL_ITEMS_B

573: Lock_Row( p_cal_item_id
574: , p_object_version_number
575: );
576:
577: DELETE FROM JTF_CAL_ITEMS_B
578: WHERE CAL_ITEM_ID = p_cal_item_id;
579: /***************************************************************************
580: ** Check whether delete was succesful
581: ***************************************************************************/

Line 642: FROM JTF_CAL_ITEMS_B

638:
639: CURSOR c_cal_item
640: (b_cal_item_id NUMBER
641: )IS SELECT object_version_number
642: FROM JTF_CAL_ITEMS_B
643: WHERE cal_item_id = b_cal_item_id;
644:
645: BEGIN
646: /***************************************************************************

Line 808: -- Description : Additional Language processing for JTF_CAL_ITEMS_B and

804: --------------------------------------------------------------------------
805: -- Start of comments
806: -- API Name : Add_Language
807: -- Type : Private
808: -- Description : Additional Language processing for JTF_CAL_ITEMS_B and
809: -- _TL tables. Used by JTFNLINS.sql
810: -- Pre-reqs : None
811: -- Parameters : None
812: -- Version : Current version 1.0

Line 826: FROM JTF_CAL_ITEMS_B b

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: );
829: -- Translate the records that already exists
830: UPDATE JTF_CAL_ITEMS_TL T

Line 896: -- Description : Additional Language processing for JTF_CAL_ITEMS_B and

892: --------------------------------------------------------------------------
893: -- Start of comments
894: -- API Name : Translate_Row
895: -- Type : Private
896: -- Description : Additional Language processing for JTF_CAL_ITEMS_B and
897: -- _TL tables. Used in the FNDLOAD definition file (.lct)
898: -- Pre-reqs : None
899: -- Parameters : None
900: -- Version : Current version 1.0

Line 931: -- Description : Additional Language processing for JTF_CAL_ITEMS_B and

927: --------------------------------------------------------------------------
928: -- Start of comments
929: -- API Name : Load_Row
930: -- Type : Private
931: -- Description : Additional Language processing for JTF_CAL_ITEMS_B and
932: -- _TL tables. Used in the FNDLOAD definition file (.lct)
933: -- Pre-reqs : None
934: -- Parameters : None
935: -- Version : Current version 1.0

Line 965: UPDATE JTF_CAL_ITEMS_B

961:
962: ------------------------------------------------------------------------
963: -- Try to update the record in the base table
964: ------------------------------------------------------------------------
965: UPDATE JTF_CAL_ITEMS_B
966: SET ITEM_TYPE = p_itm_rec.ITEM_TYPE
967: , ITEM_TYPE_CODE = p_itm_rec.ITEM_TYPE_CODE
968: , SOURCE_CODE = p_itm_rec.SOURCE_CODE
969: , SOURCE_ID = p_itm_rec.SOURCE_ID

Line 986: INSERT INTO JTF_CAL_ITEMS_B

982: -- Apparently the record doesn't exist so create it
983: ------------------------------------------------------------------------
984: IF (SQL%NOTFOUND)
985: THEN
986: INSERT INTO JTF_CAL_ITEMS_B
987: ( CAL_ITEM_ID
988: , ITEM_TYPE
989: , ITEM_TYPE_CODE
990: , SOURCE_CODE