DBA Data[Home] [Help]

APPS.PA_R_PROJECT_RESOURCES_PVT dependencies on WF_ENGINE

Line 3856: l_save_thresh := wf_engine.threshold ;

3852: -- to change the threshold. So we save the current threshold which
3853: -- will be used later on to change it back to the current threshold.
3854: --
3855:
3856: l_save_thresh := wf_engine.threshold ;
3857:
3858:
3859: IF wf_engine.threshold < 0 THEN
3860: wf_engine.threshold := l_save_thresh ;

Line 3859: IF wf_engine.threshold < 0 THEN

3855:
3856: l_save_thresh := wf_engine.threshold ;
3857:
3858:
3859: IF wf_engine.threshold < 0 THEN
3860: wf_engine.threshold := l_save_thresh ;
3861: END IF;
3862:
3863:

Line 3860: wf_engine.threshold := l_save_thresh ;

3856: l_save_thresh := wf_engine.threshold ;
3857:
3858:
3859: IF wf_engine.threshold < 0 THEN
3860: wf_engine.threshold := l_save_thresh ;
3861: END IF;
3862:
3863:
3864: --

Line 3869: wf_engine.threshold := -1 ;

3865: -- Set the threshold to bellow 0 so that the process will be created
3866: -- in the background
3867: --
3868:
3869: wf_engine.threshold := -1 ;
3870:
3871:
3872: l_process := 'PROCESS_CRM_UPDATE' ;
3873:

Line 3878: wf_engine.CreateProcess( ItemType => ItemType,

3874:
3875: --
3876: -- Create the appropriate process
3877: --
3878: wf_engine.CreateProcess( ItemType => ItemType,
3879: ItemKey => ItemKey,
3880: process => l_process );
3881:
3882: --

Line 3885: wf_engine.SetItemAttrText ( itemtype => itemtype,

3881:
3882: --
3883: -- Initialize workflow item attributes with the parameter values
3884: --
3885: wf_engine.SetItemAttrText ( itemtype => itemtype,
3886: itemkey => itemkey,
3887: aname => 'PROJECT_RESOURCE_ADMINISTRATOR',
3888: avalue => 'PASYSADMIN');
3889:

Line 3890: wf_engine.SetItemAttrDate ( itemtype => itemtype,

3886: itemkey => itemkey,
3887: aname => 'PROJECT_RESOURCE_ADMINISTRATOR',
3888: avalue => 'PASYSADMIN');
3889:
3890: wf_engine.SetItemAttrDate ( itemtype => itemtype,
3891: itemkey => itemkey,
3892: aname => 'ASSIGNMENT_START_DATE',
3893: avalue => p_assignment_start_date);
3894:

Line 3895: wf_engine.SetItemAttrNumber ( itemtype => itemtype,

3891: itemkey => itemkey,
3892: aname => 'ASSIGNMENT_START_DATE',
3893: avalue => p_assignment_start_date);
3894:
3895: wf_engine.SetItemAttrNumber ( itemtype => itemtype,
3896: itemkey => itemkey,
3897: aname => 'PERSON_ID',
3898: avalue => p_person_id);
3899:

Line 3900: wf_engine.StartProcess ( itemtype => itemtype,

3896: itemkey => itemkey,
3897: aname => 'PERSON_ID',
3898: avalue => p_person_id);
3899:
3900: wf_engine.StartProcess ( itemtype => itemtype,
3901: itemkey => itemkey );
3902:
3903: /* -- Insert to PA tables wf process information.
3904: -- This is required for displaying notifications on PA pages.

Line 3925: wf_engine.threshold := l_save_thresh ;

3921: WHEN OTHERS THEN
3922: null;
3923: END; */
3924:
3925: wf_engine.threshold := l_save_thresh ;
3926: EXCEPTION
3927: WHEN OTHERS THEN
3928: null;
3929:

Line 3962: l_person_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

3958: --
3959: -- Get the workflow attribute values
3960: --
3961:
3962: l_person_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
3963: itemkey => itemkey,
3964: aname => 'PERSON_ID' );
3965:
3966: l_assignment_start_date := wf_engine.GetItemAttrDate( itemtype => itemtype,

Line 3966: l_assignment_start_date := wf_engine.GetItemAttrDate( itemtype => itemtype,

3962: l_person_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
3963: itemkey => itemkey,
3964: aname => 'PERSON_ID' );
3965:
3966: l_assignment_start_date := wf_engine.GetItemAttrDate( itemtype => itemtype,
3967: itemkey => itemkey,
3968: aname => 'ASSIGNMENT_START_DATE' );
3969:
3970: --

Line 4015: resultout := wf_engine.eng_completed||':'||'S';

4011: END IF;
4012:
4013: IF l_return_status = 'S' THEN
4014:
4015: resultout := wf_engine.eng_completed||':'||'S';
4016: ELSE
4017:
4018: --
4019: -- Set any error messages

Line 4024: wf_engine.SetItemAttrText

4020: --
4021: l_savepoint := false;
4022: rollback to l_create_future_crm_resource ;
4023:
4024: wf_engine.SetItemAttrText
4025: ( itemtype => itemtype
4026: , itemkey => itemkey
4027: , aname => 'ERROR_MSG'
4028: , avalue => l_msg_data

Line 4031: resultout := wf_engine.eng_completed||':'||'F';

4027: , aname => 'ERROR_MSG'
4028: , avalue => l_msg_data
4029: );
4030:
4031: resultout := wf_engine.eng_completed||':'||'F';
4032:
4033: END IF;
4034:
4035: EXCEPTION

Line 4049: wf_engine.SetItemAttrText ( itemtype => itemtype

4045: If (l_savepoint) then
4046: rollback to l_create_future_crm_resource ;
4047: End if;
4048:
4049: wf_engine.SetItemAttrText ( itemtype => itemtype
4050: , itemkey => itemkey
4051: , aname => 'ERROR_MSG'
4052: , avalue => l_msg_data
4053: );

Line 4054: resultout := wf_engine.eng_completed||':'||'F';

4050: , itemkey => itemkey
4051: , aname => 'ERROR_MSG'
4052: , avalue => l_msg_data
4053: );
4054: resultout := wf_engine.eng_completed||':'||'F';
4055:
4056: END create_future_crm_resource;
4057:
4058: END PA_R_PROJECT_RESOURCES_PVT;