DBA Data[Home] [Help]

APPS.XDP_ORDER dependencies on XDP_WI_PARAMETERS

Line 4973: FROM xdp_wi_parameters wip

4969: wip.evaluation_procedure,
4970: wip.default_value,
4971: wip.display_seq,
4972: wip.workitem_id
4973: FROM xdp_wi_parameters wip
4974: WHERE wip.workitem_id = l_wi_id
4975: ORDER BY wip.evaluation_seq;
4976:
4977: -- Index counters

Line 5028: -- ** Loop through all parameters defined for Workitem in table XDP_WI_PARAMETERS using cursor

5024: FOR l_wi_index IN 1..p_fulfill_worklist_list.COUNT LOOP
5025:
5026: -- ** For every WorkItem for the Order line
5027: IF p_service_order_line_list(l_order_line_index).line_item_id = p_fulfill_worklist_list(l_wi_index).line_item_id THEN
5028: -- ** Loop through all parameters defined for Workitem in table XDP_WI_PARAMETERS using cursor
5029: FOR l_param_rec in lc_wi_param (p_fulfill_worklist_list(l_wi_index).workitem_id) LOOP
5030:
5031: l_parameter_found := FALSE;
5032: l_parameter := l_param_rec.parameter_name;

Line 5087: -- Let's add the values we've retrieved from XDP_WI_PARAMETERS to the out structure.

5083: P_WORKITEM_EVAL_PARAM_LIST_OUT(l_eval_param_index_OUT).default_value := l_param_rec.default_value;
5084:
5085: ELSE
5086:
5087: -- Let's add the values we've retrieved from XDP_WI_PARAMETERS to the out structure.
5088:
5089: l_attrib_list_index_OUT := l_attrib_list_index_OUT + 1;
5090: lv_fnd_count := lv_fnd_count + 1;
5091:

Line 5245: END LOOP; -- EMD LOOP through all parameters defined for Workitem in table XDP_WI_PARAMETERS using cursor

5241: END IF ; --END IF for ON_ORDER_RECEIPT
5242: END IF ;
5243: END IF;
5244:
5245: END LOOP; -- EMD LOOP through all parameters defined for Workitem in table XDP_WI_PARAMETERS using cursor
5246: END IF; -- END IF For every WorkItem for the Order line (match of line_item_id in the two lists)
5247: END LOOP; -- END LOOP through all WorkItems in fulfill_worklist_list
5248: ELSE
5249: null;