APPS.XDP_ENGINE dependencies on XDP_WORKLIST_DETAILS

Line 419: xdp_worklist_details wdl

415: decode(parameter_value,NULL,wpr.default_value,wdl.parameter_value) param_value,
416: parameter_ref_value
417: from
418: xdp_wi_parameters wpr,
419: xdp_worklist_details wdl
420: where
421: wpr.parameter_name = wdl.parameter_name and
422: wpr.workitem_id = wdl.workitem_id and
423: wdl.workitem_instance_id = p_wi_instance_id;

Line 2178: xdp_worklist_details wd,

2174: IS
2175: cursor c_GetLatestWiParam is
2176: SELECT parameter_value
2177: FROM
2178: xdp_worklist_details wd,
2179: xdp_fulfill_worklist fw,
2180: xdp_wi_parameters wp
2181: WHERE FW.line_item_id=p_line_item_id
2182: AND FW.workitem_instance_id = wd.workitem_instance_id

Line 2245: from xdp_worklist_details

2241: modified_flag,
2242: parameter_value,
2243: parameter_ref_value,
2244: workitem_id
2245: from xdp_worklist_details
2246: where workitem_instance_id = p_wi_instance_id
2247: and parameter_name = p_parameter_name;
2248:
2249: CURSOR c_GetEvalInfo is

Line 2258: xdp_worklist_details wdl

2254: wpr.default_value,
2255: NVL(wpr.log_in_audit_trail_flag,'Y') audit_trail_flag
2256: from
2257: xdp_wi_parameters wpr,
2258: xdp_worklist_details wdl
2259: where
2260: wpr.workitem_id = wdl.workitem_id and
2261: wpr.parameter_name = p_parameter_name and
2262: wdl.workitem_instance_id = p_wi_instance_id;

Line 2361: xdp_worklist_details

2357: select 'Y' yahoo
2358: from dual
2359: where exists(
2360: select 'x' from
2361: xdp_worklist_details
2362: where workitem_instance_id = p_wi_instance_id and
2363: parameter_name = p_parameter_name);
2364:
2365: lv_exists varchar2(1) := 'N';

Line 2537: INSERT INTO xdp_worklist_details

2533: xdp_fulfill_worklist
2534: WHERE
2535: workitem_instance_id = p_wi_instance_id;
2536: END IF;
2537: INSERT INTO xdp_worklist_details
2538: (
2539: workitem_instance_id,
2540: parameter_name,
2541: workitem_id,

Line 2576: UPDATE xdp_worklist_details

2572: p_parameter_value IN VARCHAR2,
2573: p_parameter_ref_value IN VARCHAR2)
2574: IS
2575: BEGIN
2576: UPDATE xdp_worklist_details
2577: SET
2578: parameter_value = p_parameter_value ,
2579: parameter_ref_value = p_parameter_ref_value,
2580: is_value_evaluated = p_is_value_evaluated,

Line 3377: FROM xdp_worklist_details

3373: FOR v_GetAllWIParams in c_GetAllWIParams LOOP
3374: BEGIN
3375: SELECT parameter_value, parameter_ref_value, is_value_evaluated
3376: INTO l_param_val,l_param_ref_val, l_is_value_evaluated
3377: FROM xdp_worklist_details
3378: WHERE workitem_instance_id = p_wi_instance_id
3379: AND parameter_name = v_GetAllWIParams.parameter_name;
3380: EXCEPTION
3381: WHEN NO_DATA_FOUND THEN