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_WF_PVT dependencies on JTF_CAL_ITEMKEY_S

Line 325: SELECT to_char(jtf_cal_itemkey_s.NEXTVAL) INTO l_item_key

321: /***************************************************************************
322: ** we need an itemkey
323: ***************************************************************************/
324:
325: SELECT to_char(jtf_cal_itemkey_s.NEXTVAL) INTO l_item_key
326: FROM DUAL;
327:
328: /*****************************************************************************
329: ** Look up the Calendar Administrator from the Profile (this should be an

Line 600: SELECT to_char(jtf_cal_itemkey_s.NEXTVAL) INTO l_item_key

596: /***************************************************************************
597: ** we need an itemkey
598: ***************************************************************************/
599:
600: SELECT to_char(jtf_cal_itemkey_s.NEXTVAL) INTO l_item_key
601: FROM DUAL;
602:
603: IF (p_assignment_status_id <> 3 AND p_assignment_status_id <>4) THEN
604: fnd_message.set_name ('JTF', 'JTF_CAL_INVALID_ASSIGNMENT');

Line 1003: SELECT to_char(jtf_cal_itemkey_s.NEXTVAL) INTO l_ItemKey

999:
1000: /*****************************************************************************
1001: ** Get a WF itemkey
1002: *****************************************************************************/
1003: SELECT to_char(jtf_cal_itemkey_s.NEXTVAL) INTO l_ItemKey
1004: FROM DUAL;
1005:
1006: /***************************************************************************
1007: ** Initialize the workflow

Line 1475: )IS SELECT to_char(jtf_cal_itemkey_s.NEXTVAL) ItemKey

1471: ** Cursor to pick up all the invitees for the appointment. Also picks up
1472: ** a itemkey from the sequence, this is needed to start the workflow
1473: *****************************************************************************/
1474: (b_TaskID NUMBER
1475: )IS SELECT to_char(jtf_cal_itemkey_s.NEXTVAL) ItemKey
1476: , jta.task_assignment_id TASK_ASSIGNMENT_ID
1477: , jta.resource_id INVITEE
1478: , jta.resource_type_code INVITEE_CODE
1479: , jtl.task_name TASK_NAME

Line 1722: )IS SELECT to_char(jtf_cal_itemkey_s.NEXTVAL) ItemKey

1718: ** Cursor to pick up all the invitees for the appointment. Also picks up
1719: ** a itemkey from the sequence, this is needed to start the workflow
1720: *****************************************************************************/
1721: (b_TaskID NUMBER, b_INVITEE NUMBER, b_INVITEE_TYPE VARCHAR2
1722: )IS SELECT to_char(jtf_cal_itemkey_s.NEXTVAL) ItemKey
1723: , jta.task_assignment_id TASK_ASSIGNMENT_ID
1724: , jta.resource_id INVITEE
1725: , jta.resource_type_code INVITEE_CODE
1726: , jtl.task_name TASK_NAME

Line 2318: SELECT to_char(jtf_cal_itemkey_s.NEXTVAL) INTO l_ItemKey

2314:
2315: /***************************************************************************
2316: ** we need an itemkey
2317: ***************************************************************************/
2318: SELECT to_char(jtf_cal_itemkey_s.NEXTVAL) INTO l_ItemKey
2319: FROM DUAL;
2320: /***************************************************************************
2321: ** Initialize the workflow
2322: ***************************************************************************/

Line 2450: , to_char(jtf_cal_itemkey_s.NEXTVAL) ItemKey

2446: ** a itemkey from the sequence, this is needed to start the workflow
2447: *****************************************************************************/
2448: (b_TaskID NUMBER
2449: )IS SELECT jta.task_assignment_id TaskAssignmentID
2450: , to_char(jtf_cal_itemkey_s.NEXTVAL) ItemKey
2451: , jta.resource_id INVITEE
2452: , jta.resource_type_code INVITEE_CODE
2453: , jtl.task_name TASK_NAME
2454: , jtl.description TASK_DESCRIPTION