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;
3854:
3855: /*
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;
3854:
3855: /*
3856: l_pricing_perspective_code := Wf_Engine.GetItemAttrText(itemtype, itemkey, 'PARAMETER2');
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;
3861: */
3862:
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;
3861: */
3862:
3863: l_user_name := Wf_Engine.GetItemAttrText(itemtype, itemkey, 'PARAMETER4');
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;
3868:
3869: SET_XML_CONTEXT(l_user_name, l_status_code, l_status_text);
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;
3868:
3869: SET_XML_CONTEXT(l_user_name, l_status_code, l_status_text);
3870:
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);
3889: raise;
3890: END GENERATE_PUBLISH_PRICE_BOOK_WF;
3891:
3892: PROCEDURE CATSO_SELECTOR
4000: END IF;
4001:
4002: EXCEPTION
4003: WHEN OTHERS THEN NULL;
4004: WF_CORE.Context('QP_PRICE_BOOK_UTIL', 'CATSO_SELECTOR',
4005: p_itemtype, p_itemkey, p_actid, p_funcmode);
4006: RAISE;
4007:
4008: END CATSO_SELECTOR;