APPS.PQH_SS_WORKFLOW dependencies on WF_ITEM_ACTIVITY_STATUS

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 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 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 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 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 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 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 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