DBA Data[Home] [Help]

APPS.QP_PRICE_BOOK_UTIL dependencies on WF_ENGINE

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

3845: l_err_buf VARCHAR2(240);
3846: l_debug VARCHAR2(3);
3847: l_routine VARCHAR2(240):='QP_PRICE_BOOK_UTIL.GENERATE_PUBLISH_PRICE_BOOK_WF:';
3848: BEGIN
3849: l_pb_input_header_id := Wf_Engine.GetItemAttrText(itemtype, itemkey, 'PARAMETER1');
3850: IF (l_pb_input_header_id is null) THEN
3851: wf_core.token('PARAMETER1','NULL');
3852: wf_core.raise('WFSQL_ARGS');
3853: END IF;

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

3852: wf_core.raise('WFSQL_ARGS');
3853: END IF;
3854:
3855: /*
3856: l_pricing_perspective_code := Wf_Engine.GetItemAttrText(itemtype, itemkey, 'PARAMETER2');
3857: IF (l_pricing_perspective_code is null) THEN
3858: wf_core.token('PARAMETER2','NULL');
3859: wf_core.raise('WFSQL_ARGS');
3860: END IF;

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

3859: wf_core.raise('WFSQL_ARGS');
3860: END IF;
3861: */
3862:
3863: l_user_name := Wf_Engine.GetItemAttrText(itemtype, itemkey, 'PARAMETER4');
3864: IF (l_user_name is null) THEN
3865: wf_core.token('PARAMETER4','NULL');
3866: wf_core.raise('WFSQL_ARGS');
3867: END IF;

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

3880: IF l_debug = FND_API.G_TRUE THEN
3881: QP_PREQ_GRP.engine_debug(l_routine||'returned from GENERATE_PUBLISH_PRICE_BOOK');
3882: END IF;
3883:
3884: resultout := wf_engine.eng_completed||':'||wf_engine.eng_null;
3885:
3886: EXCEPTION
3887: WHEN OTHERS THEN
3888: Wf_Core.Context('QP_PRICE_BOOK_UTIL', 'GENERATE_PUBLISH_PRICE_BOOK_WF', itemtype, itemkey, to_char(actid), funcmode);

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

3927: IF l_debug = FND_API.G_TRUE THEN
3928: QP_PREQ_GRP.engine_debug( 'P_FUNCMODE IS TEST_CTX' ) ;
3929: END IF;
3930:
3931: l_org_id := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,
3932: itemkey => p_itemkey,
3933: aname => 'ORG_ID');
3934:
3935: IF l_debug = FND_API.G_TRUE THEN

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

3951: IF l_debug = FND_API.G_TRUE THEN
3952: QP_PREQ_GRP.engine_debug( 'P_FUNCMODE IS SET_CTX' ) ;
3953: END IF;
3954:
3955: l_user_id := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,
3956: itemkey => p_itemkey,
3957: aname => 'USER_ID');
3958: l_resp_appl_id := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,
3959: itemkey => p_itemkey,

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

3954:
3955: l_user_id := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,
3956: itemkey => p_itemkey,
3957: aname => 'USER_ID');
3958: l_resp_appl_id := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,
3959: itemkey => p_itemkey,
3960: aname => 'APPLICATION_ID');
3961: l_resp_id := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,
3962: itemkey => p_itemkey,

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

3957: aname => 'USER_ID');
3958: l_resp_appl_id := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,
3959: itemkey => p_itemkey,
3960: aname => 'APPLICATION_ID');
3961: l_resp_id := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,
3962: itemkey => p_itemkey,
3963: aname => 'RESPONSIBILITY_ID');
3964: l_org_id := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,
3965: itemkey => p_itemkey,

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

3960: aname => 'APPLICATION_ID');
3961: l_resp_id := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,
3962: itemkey => p_itemkey,
3963: aname => 'RESPONSIBILITY_ID');
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