DBA Data[Home] [Help]

APPS.ENG_WORKFLOW_PUB dependencies on WF_ENGINE

Line 142: l_adhoc_party_list := WF_ENGINE.GetItemAttrText( itemtype

138: --
139: if (funcmode = 'RUN') then
140:
141: -- Get Adhoc Party List
142: l_adhoc_party_list := WF_ENGINE.GetItemAttrText( itemtype
143: , itemkey
144: , 'ADHOC_PARTY_LIST');
145:
146: IF l_adhoc_party_list IS NULL THEN

Line 162: WF_ENGINE.SetItemAttrText( itemtype

158: LOOP
159:
160: l_adhoc_party_list := i.adhoc_party_list ;
161:
162: WF_ENGINE.SetItemAttrText( itemtype
163: , itemkey
164: , 'ADHOC_PARTY_LIST'
165: , l_adhoc_party_list );
166:

Line 1719: ( nid => WF_ENGINE.context_nid

1715:
1716:
1717:
1718: l_response_code := WF_NOTIFICATION.GetAttrText
1719: ( nid => WF_ENGINE.context_nid
1720: , aname => 'RESULT'
1721: );
1722:
1723: -- Record Action

Line 1730: , p_notification_id => WF_ENGINE.context_nid

1726: , x_msg_count => l_msg_count
1727: , x_msg_data => l_msg_data
1728: , p_item_type => itemtype
1729: , p_item_key => itemkey
1730: , p_notification_id => WF_ENGINE.context_nid
1731: , p_action_type => Eng_Workflow_Util.G_ACT_REPLIED
1732: , x_action_id => l_created_action_id
1733: , p_raise_event_flag => FND_API.G_TRUE -- R12
1734: ) ;

Line 1757: , p_responded_ntf_id => WF_ENGINE.context_nid

1753: Eng_Workflow_Util.START_RESPONSE_FYI_PROCESS
1754: ( p_itemtype => itemtype
1755: , p_itemkey => itemkey
1756: , p_orig_response_option => NULL
1757: , p_responded_ntf_id => WF_ENGINE.context_nid
1758: , p_responded_comment_id => l_created_action_id
1759: , x_msg_count => l_msg_count
1760: , x_msg_data => l_msg_data
1761: , x_return_status => l_return_status

Line 1818: l_nid := wf_engine.context_nid;

1814: return;
1815: end if;
1816: -- Bug 10033738 to make Comment text input required in Change Action 'request comment' notification
1817: if (funcmode = 'VALIDATE') then
1818: l_nid := wf_engine.context_nid;
1819: -- Retrieve the respond attribute value
1820: l_attr_value := wf_notification.GetAttrText(l_nid,'WF_NOTE');
1821:
1822: -- Use WF_CORE API to raise a translated error message back to the

Line 1960: ( nid => WF_ENGINE.context_nid

1956: , l_debug_filename || actid ) ;
1957: END IF ;
1958:
1959: l_response_code := WF_NOTIFICATION.GetAttrText
1960: ( nid => WF_ENGINE.context_nid
1961: , aname => 'RESULT'
1962: );
1963:
1964: -- Record Route Response

Line 1971: , p_notification_id => WF_ENGINE.context_nid

1967: , x_msg_count => l_msg_count
1968: , x_msg_data => l_msg_data
1969: , p_item_type => itemtype
1970: , p_item_key => itemkey
1971: , p_notification_id => WF_ENGINE.context_nid
1972: , p_response_code => l_response_code
1973: , p_actid => actid
1974: , p_funcmode => funcmode
1975: ) ;

Line 2018: , p_notification_id => WF_ENGINE.context_nid

2014: , x_msg_count => l_msg_count
2015: , x_msg_data => l_msg_data
2016: , p_item_type => itemtype
2017: , p_item_key => itemkey
2018: , p_notification_id => WF_ENGINE.context_nid
2019: , p_reassign_mode => funcmode);
2020: result := 'COMPLETE';
2021: return;
2022:

Line 2170: ( nid => WF_ENGINE.context_nid

2166:
2167:
2168:
2169: l_response_code := WF_NOTIFICATION.GetAttrText
2170: ( nid => WF_ENGINE.context_nid
2171: , aname => 'RESULT'
2172: );
2173:
2174: -- Record Route Response

Line 2181: , p_notification_id => WF_ENGINE.context_nid

2177: , x_msg_count => l_msg_count
2178: , x_msg_data => l_msg_data
2179: , p_item_type => itemtype
2180: , p_item_key => itemkey
2181: , p_notification_id => WF_ENGINE.context_nid
2182: , p_response_code => Eng_Workflow_Util.G_RT_REPLIED
2183: , p_actid => actid
2184: , p_funcmode => funcmode
2185: ) ;

Line 2219: , p_responded_ntf_id => WF_ENGINE.context_nid

2215: Eng_Workflow_Util.START_RESPONSE_FYI_PROCESS
2216: ( p_itemtype => itemtype
2217: , p_itemkey => itemkey
2218: , p_orig_response_option => NULL
2219: , p_responded_ntf_id => WF_ENGINE.context_nid
2220: , p_responded_comment_id => l_created_action_id
2221: , x_msg_count => l_msg_count
2222: , x_msg_data => l_msg_data
2223: , x_return_status => l_return_status

Line 2260: , p_notification_id => WF_ENGINE.context_nid

2256: , x_msg_count => l_msg_count
2257: , x_msg_data => l_msg_data
2258: , p_item_type => itemtype
2259: , p_item_key => itemkey
2260: , p_notification_id => WF_ENGINE.context_nid
2261: , p_reassign_mode => funcmode);
2262: result := 'COMPLETE';
2263: return;
2264:

Line 2424: ( nid => WF_ENGINE.context_nid

2420: , l_debug_filename || actid ) ;
2421: END IF ;
2422:
2423: l_response_code := WF_NOTIFICATION.GetAttrText
2424: ( nid => WF_ENGINE.context_nid
2425: , aname => 'RESULT'
2426: );
2427:
2428: -- Record Route Response

Line 2435: , p_notification_id => WF_ENGINE.context_nid

2431: , x_msg_count => l_msg_count
2432: , x_msg_data => l_msg_data
2433: , p_item_type => itemtype
2434: , p_item_key => itemkey
2435: , p_notification_id => WF_ENGINE.context_nid
2436: , p_response_code => l_response_code
2437: , p_actid => actid
2438: , p_funcmode => funcmode
2439: ) ;

Line 2496: -- , p_responded_ntf_id => WF_ENGINE.context_nid

2492: -- , x_return_status => l_return_status
2493: -- , x_val_def_item_key => l_val_def_item_key
2494: -- , p_step_item_type => itemtype
2495: -- , p_step_item_key => itemkey
2496: -- , p_responded_ntf_id => WF_ENGINE.context_nid
2497: -- , p_route_id => l_route_id
2498: -- , p_route_step_id => l_route_step_id
2499: -- , p_val_def_item_type => Eng_Workflow_Util.G_CHANGE_ROUTE_STEP_ITEM_TYPE
2500: -- , p_val_def_process_name => Eng_Workflow_Util.G_VALIDATE_DEFINITION_PROC

Line 2541: , p_notification_id => WF_ENGINE.context_nid

2537: , x_msg_count => l_msg_count
2538: , x_msg_data => l_msg_data
2539: , p_item_type => itemtype
2540: , p_item_key => itemkey
2541: , p_notification_id => WF_ENGINE.context_nid
2542: , p_reassign_mode => funcmode);
2543: result := 'COMPLETE';
2544: return;
2545:

Line 2705: ( nid => WF_ENGINE.context_nid

2701: , l_debug_filename || actid ) ;
2702: END IF ;
2703:
2704: l_response_code := WF_NOTIFICATION.GetAttrText
2705: ( nid => WF_ENGINE.context_nid
2706: , aname => 'RESULT'
2707: );
2708:
2709: -- Record Route Response

Line 2716: , p_notification_id => WF_ENGINE.context_nid

2712: , x_msg_count => l_msg_count
2713: , x_msg_data => l_msg_data
2714: , p_item_type => itemtype
2715: , p_item_key => itemkey
2716: , p_notification_id => WF_ENGINE.context_nid
2717: , p_response_code => l_response_code
2718: , p_actid => actid
2719: , p_funcmode => funcmode
2720: ) ;

Line 2782: -- , p_responded_ntf_id => WF_ENGINE.context_nid

2778: -- , x_return_status => l_return_status
2779: -- , x_val_def_item_key => l_val_def_item_key
2780: -- , p_step_item_type => itemtype
2781: -- , p_step_item_key => itemkey
2782: -- , p_responded_ntf_id => WF_ENGINE.context_nid
2783: -- , p_route_id => l_route_id
2784: -- , p_route_step_id => l_route_step_id
2785: -- , p_val_def_item_type => Eng_Workflow_Util.G_CHANGE_ROUTE_STEP_ITEM_TYPE
2786: -- , p_val_def_process_name => Eng_Workflow_Util.G_VALIDATE_DEFINITION_PROC

Line 2829: , p_notification_id => WF_ENGINE.context_nid

2825: , x_msg_count => l_msg_count
2826: , x_msg_data => l_msg_data
2827: , p_item_type => itemtype
2828: , p_item_key => itemkey
2829: , p_notification_id => WF_ENGINE.context_nid
2830: , p_reassign_mode => funcmode);
2831: result := 'COMPLETE';
2832: return;
2833:

Line 2975: ( nid => WF_ENGINE.context_nid

2971: END IF ;
2972:
2973:
2974: l_response_code := WF_NOTIFICATION.GetAttrText
2975: ( nid => WF_ENGINE.context_nid
2976: , aname => 'RESULT'
2977: );
2978:
2979:

Line 3149: ( nid => WF_ENGINE.context_nid

3145:
3146:
3147:
3148: l_response_code := WF_NOTIFICATION.GetAttrText
3149: ( nid => WF_ENGINE.context_nid
3150: , aname => 'RESULT'
3151: );
3152:
3153: --

Line 3164: , p_notification_id => WF_ENGINE.context_nid

3160: , x_msg_count => l_msg_count
3161: , x_msg_data => l_msg_data
3162: , p_item_type => itemtype
3163: , p_item_key => itemkey
3164: , p_notification_id => WF_ENGINE.context_nid
3165: , p_response_code => l_response_code
3166: , p_actid => actid
3167: , p_funcmode => funcmode
3168: ) ;

Line 3202: , p_responded_ntf_id => WF_ENGINE.context_nid

3198: Eng_Workflow_Util.START_RESPONSE_FYI_PROCESS
3199: ( p_itemtype => itemtype
3200: , p_itemkey => itemkey
3201: , p_orig_response_option => NULL
3202: , p_responded_ntf_id => WF_ENGINE.context_nid
3203: , p_responded_comment_id => l_created_action_id
3204: , x_msg_count => l_msg_count
3205: , x_msg_data => l_msg_data
3206: , x_return_status => l_return_status

Line 3243: , p_notification_id => WF_ENGINE.context_nid

3239: , x_msg_count => l_msg_count
3240: , x_msg_data => l_msg_data
3241: , p_item_type => itemtype
3242: , p_item_key => itemkey
3243: , p_notification_id => WF_ENGINE.context_nid
3244: , p_reassign_mode => funcmode);
3245: result := 'COMPLETE';
3246: return;
3247:

Line 4905: -- result := wf_engine.eng_notified ||':'||

4901: return;
4902:
4903: -- Based on your result, you can launch another workflow
4904: -- and make this activity DEFFERED
4905: -- result := wf_engine.eng_notified ||':'||
4906: -- wf_engine.eng_null ||':'||
4907: -- wf_engine.eng_null;
4908: --
4909: -- Then your another workflow, continue to this activity

Line 4906: -- wf_engine.eng_null ||':'||

4902:
4903: -- Based on your result, you can launch another workflow
4904: -- and make this activity DEFFERED
4905: -- result := wf_engine.eng_notified ||':'||
4906: -- wf_engine.eng_null ||':'||
4907: -- wf_engine.eng_null;
4908: --
4909: -- Then your another workflow, continue to this activity
4910: -- using wf_engine.CompleteActivity api

Line 4907: -- wf_engine.eng_null;

4903: -- Based on your result, you can launch another workflow
4904: -- and make this activity DEFFERED
4905: -- result := wf_engine.eng_notified ||':'||
4906: -- wf_engine.eng_null ||':'||
4907: -- wf_engine.eng_null;
4908: --
4909: -- Then your another workflow, continue to this activity
4910: -- using wf_engine.CompleteActivity api
4911: --

Line 4910: -- using wf_engine.CompleteActivity api

4906: -- wf_engine.eng_null ||':'||
4907: -- wf_engine.eng_null;
4908: --
4909: -- Then your another workflow, continue to this activity
4910: -- using wf_engine.CompleteActivity api
4911: --
4912: -- Or just return False
4913: -- set result
4914: -- result := 'COMPLETE:' || FND_API.G_FALSE;

Line 5632: WF_ENGINE.SetItemAttrText( itemtype

5628:
5629: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
5630:
5631: -- for Notification
5632: WF_ENGINE.SetItemAttrText( itemtype
5633: , itemkey
5634: , 'STATUS_MONITOR_URL'
5635: , l_url);
5636:

Line 5716: l_text_attr_name_tbl WF_ENGINE.NameTabTyp;

5712: l_return_status VARCHAR2(1);
5713: l_msg_count NUMBER ;
5714: l_msg_data VARCHAR2(200);
5715:
5716: l_text_attr_name_tbl WF_ENGINE.NameTabTyp;
5717: l_text_attr_value_tbl WF_ENGINE.TextTabTyp;
5718:
5719: l_num_attr_name_tbl WF_ENGINE.NameTabTyp;
5720: l_num_attr_value_tbl WF_ENGINE.NumTabTyp;

Line 5717: l_text_attr_value_tbl WF_ENGINE.TextTabTyp;

5713: l_msg_count NUMBER ;
5714: l_msg_data VARCHAR2(200);
5715:
5716: l_text_attr_name_tbl WF_ENGINE.NameTabTyp;
5717: l_text_attr_value_tbl WF_ENGINE.TextTabTyp;
5718:
5719: l_num_attr_name_tbl WF_ENGINE.NameTabTyp;
5720: l_num_attr_value_tbl WF_ENGINE.NumTabTyp;
5721:

Line 5719: l_num_attr_name_tbl WF_ENGINE.NameTabTyp;

5715:
5716: l_text_attr_name_tbl WF_ENGINE.NameTabTyp;
5717: l_text_attr_value_tbl WF_ENGINE.TextTabTyp;
5718:
5719: l_num_attr_name_tbl WF_ENGINE.NameTabTyp;
5720: l_num_attr_value_tbl WF_ENGINE.NumTabTyp;
5721:
5722: l_date_attr_name_tbl WF_ENGINE.NameTabTyp;
5723: l_date_attr_value_tbl WF_ENGINE.DateTabTyp;

Line 5720: l_num_attr_value_tbl WF_ENGINE.NumTabTyp;

5716: l_text_attr_name_tbl WF_ENGINE.NameTabTyp;
5717: l_text_attr_value_tbl WF_ENGINE.TextTabTyp;
5718:
5719: l_num_attr_name_tbl WF_ENGINE.NameTabTyp;
5720: l_num_attr_value_tbl WF_ENGINE.NumTabTyp;
5721:
5722: l_date_attr_name_tbl WF_ENGINE.NameTabTyp;
5723: l_date_attr_value_tbl WF_ENGINE.DateTabTyp;
5724:

Line 5722: l_date_attr_name_tbl WF_ENGINE.NameTabTyp;

5718:
5719: l_num_attr_name_tbl WF_ENGINE.NameTabTyp;
5720: l_num_attr_value_tbl WF_ENGINE.NumTabTyp;
5721:
5722: l_date_attr_name_tbl WF_ENGINE.NameTabTyp;
5723: l_date_attr_value_tbl WF_ENGINE.DateTabTyp;
5724:
5725: I PLS_INTEGER ;
5726:

Line 5723: l_date_attr_value_tbl WF_ENGINE.DateTabTyp;

5719: l_num_attr_name_tbl WF_ENGINE.NameTabTyp;
5720: l_num_attr_value_tbl WF_ENGINE.NumTabTyp;
5721:
5722: l_date_attr_name_tbl WF_ENGINE.NameTabTyp;
5723: l_date_attr_value_tbl WF_ENGINE.DateTabTyp;
5724:
5725: I PLS_INTEGER ;
5726:
5727: l_event_name VARCHAR2(200) ;

Line 5767: l_event_key := WF_ENGINE.GetItemAttrText( itemtype

5763:
5764:
5765:
5766: -- Get Adhoc Party List
5767: l_event_key := WF_ENGINE.GetItemAttrText( itemtype
5768: , itemkey
5769: , 'EVENT_KEY');
5770:
5771: l_event_name := WF_ENGINE.GetItemAttrText( itemtype

Line 5771: l_event_name := WF_ENGINE.GetItemAttrText( itemtype

5767: l_event_key := WF_ENGINE.GetItemAttrText( itemtype
5768: , itemkey
5769: , 'EVENT_KEY');
5770:
5771: l_event_name := WF_ENGINE.GetItemAttrText( itemtype
5772: , itemkey
5773: , 'EVENT_NAME');
5774:
5775:

Line 5779: l_event_t := WF_ENGINE.GetItemAttrEvent(

5775:
5776: --
5777: -- Get the Event Item Attribute
5778: --
5779: l_event_t := WF_ENGINE.GetItemAttrEvent(
5780: itemtype => itemtype,
5781: itemkey => itemkey,
5782: name => 'EVENT_MESSAGE' );
5783:

Line 5908: WF_ENGINE.SetItemAttrTextArray

5904: || '&changeId=-&CHANGE_ID-' ;
5905: END IF ;
5906:
5907: -- Set Text Attributes
5908: WF_ENGINE.SetItemAttrTextArray
5909: ( itemtype => itemtype
5910: , itemkey => itemkey
5911: , aname => l_text_attr_name_tbl
5912: , avalue => l_text_attr_value_tbl

Line 5935: WF_ENGINE.SetItemAttrNumberArray

5931: l_num_attr_name_tbl(I) := 'BATCH_ID' ;
5932: l_num_attr_value_tbl(I) := l_batch_id ;
5933:
5934: -- Set Number Attributes
5935: WF_ENGINE.SetItemAttrNumberArray
5936: ( itemtype => itemtype
5937: , itemkey => itemkey
5938: , aname => l_num_attr_name_tbl
5939: , avalue => l_num_attr_value_tbl

Line 6040: l_waiting_activity := UPPER(Wf_Engine.GetActivityAttrText(

6036: Eng_Workflow_Util.Write_Debug('Get activity params . . . ' ) ;
6037: END IF ;
6038:
6039:
6040: l_waiting_activity := UPPER(Wf_Engine.GetActivityAttrText(
6041: itemtype, itemkey, actid,'WAITING_ACTIVITY'));
6042: l_waiting_flow_type := UPPER(Wf_Engine.GetActivityAttrText(
6043: itemtype, itemkey, actid,'WAITING_FLOW_TYPE'));
6044:

Line 6042: l_waiting_flow_type := UPPER(Wf_Engine.GetActivityAttrText(

6038:
6039:
6040: l_waiting_activity := UPPER(Wf_Engine.GetActivityAttrText(
6041: itemtype, itemkey, actid,'WAITING_ACTIVITY'));
6042: l_waiting_flow_type := UPPER(Wf_Engine.GetActivityAttrText(
6043: itemtype, itemkey, actid,'WAITING_FLOW_TYPE'));
6044:
6045: IF l_debug_flag THEN
6046: Eng_Workflow_Util.Write_Debug('WAITING_ACTIVITY : ' || l_waiting_activity ) ;

Line 6174: l_continuation_activity := UPPER(WF_ENGINE.GETACTIVITYATTRTEXT(

6170: --
6171: if (funcmode = 'RUN') then
6172:
6173:
6174: l_continuation_activity := UPPER(WF_ENGINE.GETACTIVITYATTRTEXT(
6175: itemtype, itemkey, actid,
6176: 'CONTINUATION_ACTIVITY'));
6177:
6178:

Line 6179: l_continuation_flow_type := UPPER(WF_ENGINE.GetActivityAttrText(

6175: itemtype, itemkey, actid,
6176: 'CONTINUATION_ACTIVITY'));
6177:
6178:
6179: l_continuation_flow_type := UPPER(WF_ENGINE.GetActivityAttrText(
6180: itemtype,itemkey,actid,
6181: 'CONTINUATION_FLOW_TYPE'));
6182:
6183: -- Currently we are supporting only for Line Route Approval Flow.

Line 6232: result := wf_engine.eng_null ;

6228: -- your cancel code goes here
6229: null;
6230:
6231: -- no result needed
6232: result := wf_engine.eng_null ;
6233: return;
6234: end if;
6235:
6236: --