DBA Data[Home] [Help]

APPS.QP_PRICE_BOOK_UTIL dependencies on WF_ENGINE

Line 3882: l_pb_input_header_id := Wf_Engine.GetItemAttrText(itemtype, itemkey, 'PARAMETER1');

3878: l_err_buf VARCHAR2(240);
3879: l_debug VARCHAR2(3);
3880: l_routine VARCHAR2(240):='QP_PRICE_BOOK_UTIL.GENERATE_PUBLISH_PRICE_BOOK_WF:';
3881: BEGIN
3882: l_pb_input_header_id := Wf_Engine.GetItemAttrText(itemtype, itemkey, 'PARAMETER1');
3883: IF (l_pb_input_header_id is null) THEN
3884: wf_core.token('PARAMETER1','NULL');
3885: wf_core.raise('WFSQL_ARGS');
3886: END IF;

Line 3889: l_pricing_perspective_code := Wf_Engine.GetItemAttrText(itemtype, itemkey, 'PARAMETER2');

3885: wf_core.raise('WFSQL_ARGS');
3886: END IF;
3887:
3888: /*
3889: l_pricing_perspective_code := Wf_Engine.GetItemAttrText(itemtype, itemkey, 'PARAMETER2');
3890: IF (l_pricing_perspective_code is null) THEN
3891: wf_core.token('PARAMETER2','NULL');
3892: wf_core.raise('WFSQL_ARGS');
3893: END IF;

Line 3896: l_user_name := Wf_Engine.GetItemAttrText(itemtype, itemkey, 'PARAMETER4');

3892: wf_core.raise('WFSQL_ARGS');
3893: END IF;
3894: */
3895:
3896: l_user_name := Wf_Engine.GetItemAttrText(itemtype, itemkey, 'PARAMETER4');
3897: IF (l_user_name is null) THEN
3898: wf_core.token('PARAMETER4','NULL');
3899: wf_core.raise('WFSQL_ARGS');
3900: END IF;

Line 3917: resultout := wf_engine.eng_completed||':'||wf_engine.eng_null;

3913: IF l_debug = FND_API.G_TRUE THEN
3914: QP_PREQ_GRP.engine_debug(l_routine||'returned from GENERATE_PUBLISH_PRICE_BOOK');
3915: END IF;
3916:
3917: resultout := wf_engine.eng_completed||':'||wf_engine.eng_null;
3918:
3919: EXCEPTION
3920: WHEN OTHERS THEN
3921: Wf_Core.Context('QP_PRICE_BOOK_UTIL', 'GENERATE_PUBLISH_PRICE_BOOK_WF', itemtype, itemkey, to_char(actid), funcmode);

Line 3964: l_org_id := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,

3960: IF l_debug = FND_API.G_TRUE THEN
3961: QP_PREQ_GRP.engine_debug( 'P_FUNCMODE IS TEST_CTX' ) ;
3962: END IF;
3963:
3964: l_org_id := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,
3965: itemkey => p_itemkey,
3966: aname => 'ORG_ID');
3967:
3968: IF l_debug = FND_API.G_TRUE THEN

Line 3988: l_user_id := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,

3984: IF l_debug = FND_API.G_TRUE THEN
3985: QP_PREQ_GRP.engine_debug( 'P_FUNCMODE IS SET_CTX' ) ;
3986: END IF;
3987:
3988: l_user_id := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,
3989: itemkey => p_itemkey,
3990: aname => 'USER_ID');
3991: l_resp_appl_id := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,
3992: itemkey => p_itemkey,

Line 3991: l_resp_appl_id := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,

3987:
3988: l_user_id := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,
3989: itemkey => p_itemkey,
3990: aname => 'USER_ID');
3991: l_resp_appl_id := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,
3992: itemkey => p_itemkey,
3993: aname => 'APPLICATION_ID');
3994: l_resp_id := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,
3995: itemkey => p_itemkey,

Line 3994: l_resp_id := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,

3990: aname => 'USER_ID');
3991: l_resp_appl_id := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,
3992: itemkey => p_itemkey,
3993: aname => 'APPLICATION_ID');
3994: l_resp_id := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,
3995: itemkey => p_itemkey,
3996: aname => 'RESPONSIBILITY_ID');
3997: l_org_id := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,
3998: itemkey => p_itemkey,

Line 3997: l_org_id := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,

3993: aname => 'APPLICATION_ID');
3994: l_resp_id := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,
3995: itemkey => p_itemkey,
3996: aname => 'RESPONSIBILITY_ID');
3997: l_org_id := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,
3998: itemkey => p_itemkey,
3999: aname => 'ORG_ID');
4000:
4001: IF l_debug = FND_API.G_TRUE THEN