APPS.PQH_SS_WORKFLOW dependencies on WF_ACTIVITY

Line 433: wf_activity_attributes AA,

429: and ias.activity_status = 'NOTIFIED'
430: and ias.process_activity in (
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

Line 460: WF_ACTIVITY_ATTRIBUTES WAA,

456: and ias.activity_status = 'NOTIFIED'
457: and ias.process_activity in (
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

Line 499: PROCEDURE complete_wf_activity (

495: /* ******************************************************
496: -- Complete Workflow Activity
497: --
498: ******************************************************* */
499: PROCEDURE complete_wf_activity (
500: p_itemType IN VARCHAR2,
501: p_itemKey IN VARCHAR2,
502: p_activity IN NUMBER,
503: p_otherAct IN VARCHAR2,

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 567: acttype := Wf_Activity.Instance_Type(l_activity, actdate);

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
571: Wf_Item_Activity_Status.Notification_Status(p_itemType, p_itemKey, l_activity,

Line 619: hr_utility.trace(' exception in '||g_package||'.complete_wf_activity : ' || sqlerrm);

615: --
616: --
617: EXCEPTION
618: WHEN OTHERS THEN
619: hr_utility.trace(' exception in '||g_package||'.complete_wf_activity : ' || sqlerrm);
620: Wf_Core.Context(g_package, 'complete_wf_activity', p_itemType, p_itemKey);
621: raise;
622: --
623: END complete_wf_activity;

Line 620: Wf_Core.Context(g_package, 'complete_wf_activity', p_itemType, p_itemKey);

616: --
617: EXCEPTION
618: WHEN OTHERS THEN
619: hr_utility.trace(' exception in '||g_package||'.complete_wf_activity : ' || sqlerrm);
620: Wf_Core.Context(g_package, 'complete_wf_activity', p_itemType, p_itemKey);
621: raise;
622: --
623: END complete_wf_activity;
624: --

Line 623: END complete_wf_activity;

619: hr_utility.trace(' exception in '||g_package||'.complete_wf_activity : ' || sqlerrm);
620: Wf_Core.Context(g_package, 'complete_wf_activity', p_itemType, p_itemKey);
621: raise;
622: --
623: END complete_wf_activity;
624: --
625: PROCEDURE start_approval_wf (
626: itemtype IN VARCHAR2,
627: itemkey IN VARCHAR2,

Line 719: complete_wf_activity (

715: ,p_result => result );
716:
717: --Complete the Activity in approval flow with Approved (if new or SFL txn)
718: --Or Resubmit if pending or RFC transactions.
719: complete_wf_activity (
720: p_itemType => itemtype,
721: p_itemKey => itemkey,
722: p_activity => actid,
723: p_otherAct => 'OTHER',

Line 1320: complete_wf_activity (

1316:
1317: -- Notified activity which must be completed to
1318: -- go the first page of the transaction and fetch it's activity id.
1319: if(l_activityId is not null) then
1320: complete_wf_activity (
1321: p_itemType => p_itemType,
1322: p_itemKey => p_itemKey,
1323: p_activity => l_activityId,
1324: p_otherAct => 'THIS',

Line 1541: complete_wf_activity (

1537: l_newStatus := wf_engine.eng_null;
1538: ELSE
1539: l_newStatus := 'SFL';
1540: END IF;
1541: complete_wf_activity (
1542: p_itemType => p_itemType
1543: ,p_itemKey => p_itemKey
1544: ,p_activity => l_activity_id -- added for bug 12561019
1545: ,p_otherAct => 'OTHER'

Line 1608: complete_wf_activity (

1604: ,p_txnId => l_transactionId);*/
1605: null;
1606: --
1607: END IF;
1608: complete_wf_activity (
1609: p_itemType => p_itemType
1610: ,p_itemKey => p_itemKey
1611: ,p_activity => l_activity_id -- added for bug 12561019 -- not used because current act is fetched
1612: ,p_otherAct => 'CURR'

Line 3084: complete_wf_activity (

3080: p_itemType => l_itemType
3081: ,p_itemKey => l_itemKey
3082: ,p_ntfId => p_ntfId );
3083:
3084: complete_wf_activity (
3085: p_itemType => l_itemtype,
3086: p_itemKey => l_itemkey,
3087: p_activity => l_activityId,
3088: p_otherAct => 'THIS',

Line 3123: complete_wf_activity (

3119: ,p_itemKey => p_itemKey
3120: ,p_ntfId => l_notificationId
3121: );
3122: --
3123: complete_wf_activity (
3124: p_itemType => p_itemType,
3125: p_itemKey => p_itemKey,
3126: p_activity => l_activity_id,
3127: p_otherAct => 'THIS',