DBA Data[Home] [Help]

APPS.OE_ORDER_WF_UTIL dependencies on OE_PROFILE

Line 2190: -- changed call from fnd_profile.value to oe_profile.value to retrieve profile in created_by context

2186: --
2187: IF (funcmode = 'RUN') THEN
2188: l_type := wf_engine.GetActivityAttrText(itemtype, itemkey, actid, 'SOURCE');
2189: IF l_type = 'PROFILE_APPROVER' THEN
2190: -- changed call from fnd_profile.value to oe_profile.value to retrieve profile in created_by context
2191: IF itemtype = 'OEOH' THEN
2192: v_value := oe_profile.value(p_header_id => to_number(itemkey),
2193: p_line_id => null,
2194: p_profile_option_name => 'OE_NOTIFICATION_APPROVER');

Line 2192: v_value := oe_profile.value(p_header_id => to_number(itemkey),

2188: l_type := wf_engine.GetActivityAttrText(itemtype, itemkey, actid, 'SOURCE');
2189: IF l_type = 'PROFILE_APPROVER' THEN
2190: -- changed call from fnd_profile.value to oe_profile.value to retrieve profile in created_by context
2191: IF itemtype = 'OEOH' THEN
2192: v_value := oe_profile.value(p_header_id => to_number(itemkey),
2193: p_line_id => null,
2194: p_profile_option_name => 'OE_NOTIFICATION_APPROVER');
2195: ELSIF itemtype = 'OEOL' THEN
2196: v_value := oe_profile.value(p_header_id => null,

Line 2196: v_value := oe_profile.value(p_header_id => null,

2192: v_value := oe_profile.value(p_header_id => to_number(itemkey),
2193: p_line_id => null,
2194: p_profile_option_name => 'OE_NOTIFICATION_APPROVER');
2195: ELSIF itemtype = 'OEOL' THEN
2196: v_value := oe_profile.value(p_header_id => null,
2197: p_line_id => to_number(itemkey),
2198: p_profile_option_name => 'OE_NOTIFICATION_APPROVER');
2199: END IF;
2200: ELSIF l_type = 'ORDER_CREATED_BY' THEN