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.CAC_VIEW_WF_PVT dependencies on CAC_VWS_ITEMKEY_S

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

321: /***************************************************************************
322: ** we need an itemkey
323: ***************************************************************************/
324:
325: SELECT to_char(cac_vws_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(cac_vws_itemkey_s.NEXTVAL) INTO l_item_key

596: /***************************************************************************
597: ** we need an itemkey
598: ***************************************************************************/
599:
600: SELECT to_char(cac_vws_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(cac_vws_itemkey_s.NEXTVAL) INTO l_ItemKey

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

Line 1475: )IS SELECT to_char(cac_vws_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(cac_vws_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(cac_vws_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(cac_vws_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 2321: SELECT to_char(cac_vws_itemkey_s.NEXTVAL) INTO l_ItemKey

2317:
2318: /***************************************************************************
2319: ** we need an itemkey
2320: ***************************************************************************/
2321: SELECT to_char(cac_vws_itemkey_s.NEXTVAL) INTO l_ItemKey
2322: FROM DUAL;
2323: /***************************************************************************
2324: ** Initialize the workflow
2325: ***************************************************************************/

Line 2453: , to_char(cac_vws_itemkey_s.NEXTVAL) ItemKey

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

Line 2906: )IS SELECT to_char(cac_vws_itemkey_s.NEXTVAL) ItemKey

2902: ** Cursor to pick up all the invitees for the appointment. Also picks up
2903: ** a itemkey from the sequence, this is needed to start the workflow
2904: *****************************************************************************/
2905: (b_TaskID NUMBER, b_INVITEE NUMBER, b_INVITEE_TYPE VARCHAR2
2906: )IS SELECT to_char(cac_vws_itemkey_s.NEXTVAL) ItemKey
2907: , jta.task_assignment_id TASK_ASSIGNMENT_ID
2908: , jta.resource_id INVITEE
2909: , jta.resource_type_code INVITEE_CODE
2910: , jtl.task_name TASK_NAME

Line 3365: )IS SELECT to_char(cac_vws_itemkey_s.NEXTVAL) ItemKey

3361: ** Cursor to pick up all the invitees for the appointment. Also picks up
3362: ** a itemkey from the sequence, this is needed to start the workflow
3363: *****************************************************************************/
3364: (b_TaskID NUMBER, b_INVITEE NUMBER, b_INVITEE_TYPE VARCHAR2
3365: )IS SELECT to_char(cac_vws_itemkey_s.NEXTVAL) ItemKey
3366: , jta.task_assignment_id TASK_ASSIGNMENT_ID
3367: , jta.resource_id INVITEE
3368: , jta.resource_type_code INVITEE_CODE
3369: , jtl.task_name TASK_NAME