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

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

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

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

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

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

Line 620: END complete_wf_activity;

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

Line 716: complete_wf_activity (

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

Line 1299: complete_wf_activity (

1295:
1296: -- Notified activity which must be completed to
1297: -- go the first page of the transaction and fetch it's activity id.
1298: if(l_activityId is not null) then
1299: complete_wf_activity (
1300: p_itemType => p_itemType,
1301: p_itemKey => p_itemKey,
1302: p_activity => l_activityId,
1303: p_otherAct => 'THIS',

Line 1518: complete_wf_activity (

1514: l_newStatus := wf_engine.eng_null;
1515: ELSE
1516: l_newStatus := 'SFL';
1517: END IF;
1518: complete_wf_activity (
1519: p_itemType => p_itemType
1520: ,p_itemKey => p_itemKey
1521: ,p_activity => p_activityId
1522: ,p_otherAct => 'OTHER'

Line 1585: complete_wf_activity (

1581: ,p_txnId => l_transactionId);*/
1582: null;
1583: --
1584: END IF;
1585: complete_wf_activity (
1586: p_itemType => p_itemType
1587: ,p_itemKey => p_itemKey
1588: ,p_activity => p_activityId -- not used because current act is fetched
1589: ,p_otherAct => 'CURR'

Line 3052: complete_wf_activity (

3048: p_itemType => l_itemType
3049: ,p_itemKey => l_itemKey
3050: ,p_ntfId => p_ntfId );
3051:
3052: complete_wf_activity (
3053: p_itemType => l_itemtype,
3054: p_itemKey => l_itemkey,
3055: p_activity => l_activityId,
3056: p_otherAct => 'THIS',

Line 3091: complete_wf_activity (

3087: ,p_itemKey => p_itemKey
3088: ,p_ntfId => l_notificationId
3089: );
3090: --
3091: complete_wf_activity (
3092: p_itemType => p_itemType,
3093: p_itemKey => p_itemKey,
3094: p_activity => l_activity_id,
3095: p_otherAct => 'THIS',