DBA Data[Home] [Help]

APPS.XDP_OA_UTIL dependencies on XDP_WI_PARAMETERS

Line 123: -- The cursor now fetches the default_value of the param from xdp_wi_parameters

119:
120: --
121: -- Date: 13-Jan-2005 Author: DPUTHIYE. Bug#: 4083708
122: -- Change: Modified the cursor lc_wi_param.
123: -- The cursor now fetches the default_value of the param from xdp_wi_parameters
124: -- and defaults parameter_value with it if parameter_value is null.
125: CURSOR lc_wi_param(l_wi_id NUMBER,l_line_id number) IS
126: select wpr2.parameter_name,
127: -- parameter_value,

Line 134: from xdp_wi_parameters wpr

130: wpr2.evaluation_seq
131: from (select parameter_name,
132: default_value, -- added to fix 4083708
133: evaluation_seq
134: from xdp_wi_parameters wpr
135: where wpr.workitem_id = l_wi_id
136: ) wpr2,
137: XDP_ORDER_LINEITEM_DETS oll
138: where wpr2.parameter_name = oll.line_parameter_name(+) and

Line 321: from xdp_wi_parameters wpr

317: wpr2.evaluation_seq
318: from
319: (select parameter_name,
320: evaluation_seq
321: from xdp_wi_parameters wpr
322: where wpr.workitem_id = l_wi_id --and
323: ) wpr2,
324: XDP_ORDER_LINEITEM_DETS oll
325: where