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 563: actdate := Wf_Item.Active_Date(p_itemType, p_itemKey);

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

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

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

Line 637: wf_item_attribute_values wav

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

Line 1257: UPDATE wf_item_activity_statuses

1253: -- so that only SFL activity is left notified
1254: -- NO DML Operations directly on FND schema.
1255: -- Fix for bug#3578646
1256: /*
1257: UPDATE wf_item_activity_statuses
1258: SET activity_status = 'COMPLETE',
1259: activity_result_code ='#NULL'
1260: WHERE item_type = p_itemType
1261: AND item_key = p_itemKey

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

1909: hr_transaction_api.rollback_transaction
1910: (p_transaction_id => l_transactionId );
1911:
1912: --3099089 change starts
1913: --need to remove transaction_id from wf_item_attribute_values also
1914: wf_engine.setitemattrnumber
1915: (itemtype => itemtype
1916: ,itemkey => itemkey
1917: ,aname => 'TRANSACTION_ID'

Line 2053: FROM wf_item_attribute_values

2049:
2050: -- Cursor to find if the person (selected for RFC) is an additional approver
2051: CURSOR cur_add_appr IS
2052: SELECT 'X'
2053: FROM wf_item_attribute_values
2054: WHERE item_type = p_itemType
2055: AND item_key = p_itemKey
2056: AND name like 'ADDITIONAL_APPROVER_%'
2057: AND number_value = p_userId;

Line 2090: FROM wf_item_attribute_values

2086: )
2087: and approval_history_id > 0
2088: MINUS
2089: SELECT number_value
2090: FROM wf_item_attribute_values
2091: WHERE item_type = p_itemType
2092: AND item_key = p_itemKey
2093: AND name like 'ADDITIONAL_APPROVER_%'
2094: )

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

2966: --
2967: document_type := wf_notification.doc_html;
2968:
2969: -- Document will only have the notification id
2970: -- fetch the wf itemType and key from notification
2971: get_item_type_and_key (
2972: p_ntfId => document_id
2973: ,p_itemType => l_itemType
2974: ,p_itemKey => l_itemKey );

Line 3456: from WF_ITEM_ACTIVITY_STATUSES IAS,

3452: select * from (
3453: select IAS.NOTIFICATION_ID, IAS.ASSIGNED_USER,
3454: A.RESULT_TYPE, IAS.ACTIVITY_RESULT_CODE,
3455: IAS.BEGIN_DATE, IAS.EXECUTION_TIME
3456: from WF_ITEM_ACTIVITY_STATUSES IAS,
3457: WF_ACTIVITIES A,
3458: WF_PROCESS_ACTIVITIES PA,
3459: WF_ITEM_TYPES IT,
3460: WF_ITEMS I

Line 3459: WF_ITEM_TYPES IT,

3455: IAS.BEGIN_DATE, IAS.EXECUTION_TIME
3456: from WF_ITEM_ACTIVITY_STATUSES IAS,
3457: WF_ACTIVITIES A,
3458: WF_PROCESS_ACTIVITIES PA,
3459: WF_ITEM_TYPES IT,
3460: WF_ITEMS I
3461: where IAS.ITEM_TYPE = x_item_type
3462: and IAS.ITEM_KEY = x_item_key
3463: and IAS.NOTIFICATION_ID is not null

Line 3460: WF_ITEMS I

3456: from WF_ITEM_ACTIVITY_STATUSES IAS,
3457: WF_ACTIVITIES A,
3458: WF_PROCESS_ACTIVITIES PA,
3459: WF_ITEM_TYPES IT,
3460: WF_ITEMS I
3461: where IAS.ITEM_TYPE = x_item_type
3462: and IAS.ITEM_KEY = x_item_key
3463: and IAS.NOTIFICATION_ID is not null
3464: and nvl(RESULT_TYPE,'*') NOT IN ( '*','HR_DONE')

Line 3477: from WF_ITEM_ACTIVITY_STATUSES_H IAS,

3473: UNION
3474: select IAS.NOTIFICATION_ID, IAS.ASSIGNED_USER,
3475: A.RESULT_TYPE, IAS.ACTIVITY_RESULT_CODE,
3476: IAS.BEGIN_DATE, IAS.EXECUTION_TIME
3477: from WF_ITEM_ACTIVITY_STATUSES_H IAS,
3478: WF_ACTIVITIES A,
3479: WF_PROCESS_ACTIVITIES PA,
3480: WF_ITEM_TYPES IT,
3481: WF_ITEMS I

Line 3480: WF_ITEM_TYPES IT,

3476: IAS.BEGIN_DATE, IAS.EXECUTION_TIME
3477: from WF_ITEM_ACTIVITY_STATUSES_H IAS,
3478: WF_ACTIVITIES A,
3479: WF_PROCESS_ACTIVITIES PA,
3480: WF_ITEM_TYPES IT,
3481: WF_ITEMS I
3482: where IAS.ITEM_TYPE = x_item_type
3483: and IAS.ITEM_KEY = x_item_key
3484: and IAS.NOTIFICATION_ID is not null

Line 3481: WF_ITEMS I

3477: from WF_ITEM_ACTIVITY_STATUSES_H IAS,
3478: WF_ACTIVITIES A,
3479: WF_PROCESS_ACTIVITIES PA,
3480: WF_ITEM_TYPES IT,
3481: WF_ITEMS I
3482: where IAS.ITEM_TYPE = x_item_type
3483: and IAS.ITEM_KEY = x_item_key
3484: and IAS.NOTIFICATION_ID is not null
3485: and (IAS.ACTIVITY_RESULT_CODE is null or IAS.ACTIVITY_RESULT_CODE not in ('SFL','#NULL'))

Line 3517: from WF_ITEM_ACTIVITY_STATUSES

3513: begin
3514: begin
3515: select ITEM_TYPE, ITEM_KEY, PROCESS_ACTIVITY
3516: into l_itype, l_ikey, l_actid
3517: from WF_ITEM_ACTIVITY_STATUSES
3518: where notification_id = nid;
3519: exception
3520: when NO_DATA_FOUND then
3521: begin

Line 3524: from WF_ITEM_ACTIVITY_STATUSES_H

3520: when NO_DATA_FOUND then
3521: begin
3522: select ITEM_TYPE, ITEM_KEY, PROCESS_ACTIVITY
3523: into l_itype, l_ikey, l_actid
3524: from WF_ITEM_ACTIVITY_STATUSES_H
3525: where notification_id = nid;
3526: exception
3527: when NO_DATA_FOUND then
3528: null; -- raise a notification not exist message

Line 3563: from WF_ITEMS

3559:
3560: begin
3561: select OWNER_ROLE, BEGIN_DATE
3562: into l_owner_role, l_begin_date
3563: from WF_ITEMS
3564: where ITEM_TYPE = l_itype
3565: and ITEM_KEY = l_ikey;
3566: exception
3567: when OTHERS then