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.PQH_SS_WORKFLOW dependencies on WF_ITEM

Line 239: FROM wf_item_activity_statuses

235: ,p_itemKey OUT NOCOPY VARCHAR2 ) IS
236:
237: CURSOR cur_ias IS
238: SELECT item_type, item_key
239: FROM wf_item_activity_statuses
240: WHERE notification_id = p_ntfId;
241:
242: CURSOR cur_not IS
243: SELECT SUBSTR(context,1,INSTR(context,':',1)-1)

Line 312: FROM WF_ITEM_ACTIVITY_STATUSES IAS

308: l_ntfId NUMBER;
309: --
310: CURSOR cur_ntf IS
311: SELECT ias.notification_id
312: FROM WF_ITEM_ACTIVITY_STATUSES IAS
313: WHERE ias.item_type = p_itemType
314: and ias.item_key = p_itemKey
315: and IAS.ACTIVITY_STATUS = 'NOTIFIED'
316: and notification_id is not null

Line 369: FROM WF_ITEM_ACTIVITY_STATUSES IAS

365: l_activityId NUMBER;
366: --
367: CURSOR cur_wf IS
368: SELECT process_activity
369: FROM WF_ITEM_ACTIVITY_STATUSES IAS
370: WHERE ias.item_type = p_itemType
371: and ias.item_key = p_itemKey
372: AND ias.notification_id IS NULL
373: and IAS.ACTIVITY_STATUS = 'NOTIFIED'

Line 378: FROM WF_ITEM_ACTIVITY_STATUSES IAS

374: and rownum < 2;
375: --
376: CURSOR cur_wf_ntfId(p_ntfId VARCHAR2) IS
377: SELECT process_activity
378: FROM WF_ITEM_ACTIVITY_STATUSES IAS
379: WHERE ias.item_type = p_itemType
380: and ias.item_key = p_itemKey
381: and ias.notification_id = p_ntfId
382: and IAS.ACTIVITY_STATUS = 'NOTIFIED'

Line 426: FROM wf_item_activity_statuses ias

422: --
423: CURSOR cur_wf IS
424: -- Fix for bug 3719338
425: /*SELECT ias.process_activity
426: FROM wf_item_activity_statuses ias
427: WHERE ias.item_type = p_itemType
428: and ias.item_key = p_itemKey
429: and ias.activity_status = 'NOTIFIED'
430: and ias.process_activity in (

Line 435: wf_items WI

431: select pa.instance_id
432: FROM wf_process_activities PA,
433: wf_activity_attributes AA,
434: wf_activities WA,
435: wf_items WI
436: WHERE pa.process_item_type = ias.item_type
437: and wa.item_type = pa.process_item_type
438: and wa.name = pa.activity_name
439: and wi.item_type = ias.item_type

Line 453: FROM WF_ITEM_ACTIVITY_STATUSES IAS

449: */
450: SELECT process_activity
451: from
452: (select process_activity
453: FROM WF_ITEM_ACTIVITY_STATUSES IAS
454: WHERE ias.item_type = p_itemType
455: and ias.item_key = p_itemKey
456: and ias.activity_status = 'NOTIFIED'
457: and ias.process_activity in (

Line 462: WF_ITEMS WI

458: select wpa.instance_id
459: FROM WF_PROCESS_ACTIVITIES WPA,
460: WF_ACTIVITY_ATTRIBUTES WAA,
461: WF_ACTIVITIES WA,
462: WF_ITEMS WI
463: WHERE wpa.process_item_type = ias.item_type
464: and wa.item_type = wpa.process_item_type
465: and wa.name = wpa.activity_name
466: and wi.item_type = ias.item_type

Line 518: FROM WF_ITEM_ACTIVITY_STATUSES IAS,

514:
515:
516: CURSOR c_wf IS
517: SELECT instance_label,ias.process_activity actvityId, ias.notification_id ntfId
518: FROM WF_ITEM_ACTIVITY_STATUSES IAS,
519: WF_PROCESS_ACTIVITIES PA
520: WHERE IAS.PROCESS_ACTIVITY = PA.INSTANCE_ID
521: AND ias.item_type = pa.process_item_type
522: and ias.item_type = p_itemType

Line 527: from WF_ACTIVITIES wa, WF_ACTIVITY_ATTRIBUTES waa, WF_ITEMS wi

523: and ias.item_key = p_itemKey
524: and ias.activity_status = 'NOTIFIED'
525: and ias.process_activity <> p_activity
526: and not exists (select 'e'
527: from WF_ACTIVITIES wa, WF_ACTIVITY_ATTRIBUTES waa, WF_ITEMS wi
528: where wa.item_type = pa.process_item_type
529: and wa.name = pa.activity_name
530: and wi.item_type = ias.item_type
531: and wi.item_key = ias.item_key

Line 566: actdate := Wf_Item.Active_Date(p_itemType, p_itemKey);

562: --
563: l_activity_name := wf_engine.getActivityLabel(l_activity);
564:
565: begin
566: actdate := Wf_Item.Active_Date(p_itemType, p_itemKey);
567: acttype := Wf_Activity.Instance_Type(l_activity, actdate);
568:
569: if (acttype = wf_engine.eng_notification) then
570: -- Get notification id

Line 571: Wf_Item_Activity_Status.Notification_Status(p_itemType, p_itemKey, l_activity,

567: acttype := Wf_Activity.Instance_Type(l_activity, actdate);
568:
569: if (acttype = wf_engine.eng_notification) then
570: -- Get notification id
571: Wf_Item_Activity_Status.Notification_Status(p_itemType, p_itemKey, l_activity,
572: notid, user);
573: end if;
574: exception
575: when others then

Line 640: wf_item_attribute_values wav

636: CURSOR cur_sfl IS
637: SELECT nvl(decode(wav.text_value, null, hat.status,
638: decode(hat.status,'S','SUBMIT',hat.status)),'N')
639: FROM hr_api_transactions hat,
640: wf_item_attribute_values wav
641: WHERE hat.item_type = wav.item_Type
642: AND hat.item_key = wav.item_Key
643: AND wav.item_type = itemType
644: AND wav.item_key = itemKey

Line 1278: UPDATE wf_item_activity_statuses

1274: -- so that only SFL activity is left notified
1275: -- NO DML Operations directly on FND schema.
1276: -- Fix for bug#3578646
1277: /*
1278: UPDATE wf_item_activity_statuses
1279: SET activity_status = 'COMPLETE',
1280: activity_result_code ='#NULL'
1281: WHERE item_type = p_itemType
1282: AND item_key = p_itemKey

Line 1936: --need to remove transaction_id from wf_item_attribute_values also

1932: hr_transaction_api.rollback_transaction
1933: (p_transaction_id => l_transactionId );
1934:
1935: --3099089 change starts
1936: --need to remove transaction_id from wf_item_attribute_values also
1937: wf_engine.setitemattrnumber
1938: (itemtype => itemtype
1939: ,itemkey => itemkey
1940: ,aname => 'TRANSACTION_ID'

Line 2076: FROM wf_item_attribute_values

2072:
2073: -- Cursor to find if the person (selected for RFC) is an additional approver
2074: CURSOR cur_add_appr IS
2075: SELECT 'X'
2076: FROM wf_item_attribute_values
2077: WHERE item_type = p_itemType
2078: AND item_key = p_itemKey
2079: AND name like 'ADDITIONAL_APPROVER_%'
2080: AND number_value = p_userId;

Line 2113: FROM wf_item_attribute_values

2109: )
2110: and approval_history_id > 0
2111: MINUS
2112: SELECT number_value
2113: FROM wf_item_attribute_values
2114: WHERE item_type = p_itemType
2115: AND item_key = p_itemKey
2116: AND name like 'ADDITIONAL_APPROVER_%'
2117: )

Line 3002: -- fetch the wf itemType and key from notification

2998: --
2999: document_type := wf_notification.doc_html;
3000:
3001: -- Document will only have the notification id
3002: -- fetch the wf itemType and key from notification
3003: get_item_type_and_key (
3004: p_ntfId => document_id
3005: ,p_itemType => l_itemType
3006: ,p_itemKey => l_itemKey );

Line 3512: FROM wf_item_activity_statuses ias

3508: AND name = 'WF_NOTE'
3509: ) h_comment
3510: ,nvl (ias.end_date
3511: ,ias.begin_date) h_action_date
3512: FROM wf_item_activity_statuses ias
3513: ,wf_activities a
3514: ,wf_process_activities pa
3515: ,wf_items i
3516: ,WF_ITEM_TYPES IT

Line 3515: ,wf_items i

3511: ,ias.begin_date) h_action_date
3512: FROM wf_item_activity_statuses ias
3513: ,wf_activities a
3514: ,wf_process_activities pa
3515: ,wf_items i
3516: ,WF_ITEM_TYPES IT
3517: where IAS.ITEM_TYPE = 'HRSSA'
3518: and IAS.ITEM_KEY = '15018'
3519: and IAS.NOTIFICATION_ID is not null

Line 3516: ,WF_ITEM_TYPES IT

3512: FROM wf_item_activity_statuses ias
3513: ,wf_activities a
3514: ,wf_process_activities pa
3515: ,wf_items i
3516: ,WF_ITEM_TYPES IT
3517: where IAS.ITEM_TYPE = 'HRSSA'
3518: and IAS.ITEM_KEY = '15018'
3519: and IAS.NOTIFICATION_ID is not null
3520: and nvl(RESULT_TYPE,'*') NOT IN ( '*','HR_DONE')

Line 3545: FROM wf_item_activity_statuses_h ias

3541: AND name = 'WF_NOTE'
3542: ) h_comment
3543: ,nvl (ias.end_date
3544: ,ias.begin_date) h_action_date
3545: FROM wf_item_activity_statuses_h ias
3546: ,wf_activities a
3547: ,wf_process_activities pa
3548: ,wf_items i
3549: ,WF_ITEM_TYPES IT

Line 3548: ,wf_items i

3544: ,ias.begin_date) h_action_date
3545: FROM wf_item_activity_statuses_h ias
3546: ,wf_activities a
3547: ,wf_process_activities pa
3548: ,wf_items i
3549: ,WF_ITEM_TYPES IT
3550: where IAS.ITEM_TYPE = 'HRSSA'
3551: and IAS.ITEM_KEY = '15018'
3552: and IAS.NOTIFICATION_ID is not null

Line 3549: ,WF_ITEM_TYPES IT

3545: FROM wf_item_activity_statuses_h ias
3546: ,wf_activities a
3547: ,wf_process_activities pa
3548: ,wf_items i
3549: ,WF_ITEM_TYPES IT
3550: where IAS.ITEM_TYPE = 'HRSSA'
3551: and IAS.ITEM_KEY = '15018'
3552: and IAS.NOTIFICATION_ID is not null
3553: and (IAS.ACTIVITY_RESULT_CODE is null or IAS.ACTIVITY_RESULT_CODE not in ('SFL','#NULL'))

Line 3570: FROM wf_item_activity_statuses ias

3566: ,c.from_role h_from_role
3567: ,wf_core.translate (c.action) h_action
3568: ,c.user_comment h_comment
3569: ,c.comment_date h_action_date
3570: FROM wf_item_activity_statuses ias
3571: ,wf_comments c
3572: WHERE ias.item_type = x_item_type
3573: AND ias.item_key = x_item_key
3574: -- AND ias.process_activity = x_actid

Line 3585: FROM wf_item_activity_statuses_h ias

3581: ,c.from_role h_from_role
3582: ,wf_core.translate (c.action) h_action
3583: ,c.user_comment h_comment
3584: ,c.comment_date h_action_date
3585: FROM wf_item_activity_statuses_h ias
3586: ,wf_comments c
3587: WHERE ias.item_type = x_item_type
3588: AND ias.item_key = x_item_key
3589: -- AND ias.process_activity = x_actid

Line 3658: from WF_ITEMS

3654:
3655: begin
3656: select OWNER_ROLE, BEGIN_DATE
3657: into l_owner_role, l_begin_date
3658: from WF_ITEMS
3659: where ITEM_TYPE = l_itype
3660: and ITEM_KEY = l_ikey;
3661: exception
3662: when OTHERS then

Line 3974: FROM WF_ITEM_ACTIVITY_STATUSES IAS

3970:
3971:
3972: CURSOR cur_wf IS
3973: SELECT process_activity
3974: FROM WF_ITEM_ACTIVITY_STATUSES IAS
3975: WHERE ias.item_type = p_itemType
3976: AND ias.item_key = p_itemKey
3977: AND ias.activity_status = 'NOTIFIED'
3978: ORDER BY begin_date DESC, execution_time DESC;