APPS.XDP_ORDER dependencies on XDP_WORKITEMS

Line 182: -- Cursor to select workitem id from xdp_workitems --

178: lv_wi_name VARCHAR2(80) := UPPER(p_workitem_name);
179: lv_wi_version VARCHAR2(80) := UPPER(p_version);
180: e_wi_no_unique_match EXCEPTION ;
181: e_wi_no_config EXCEPTION ;
182: -- Cursor to select workitem id from xdp_workitems --
183: CURSOR lc_wi IS
184: SELECT workitem_id
185: FROM xdp_workitems
186: WHERE workitem_name = lv_wi_name

Line 185: FROM xdp_workitems

181: e_wi_no_config EXCEPTION ;
182: -- Cursor to select workitem id from xdp_workitems --
183: CURSOR lc_wi IS
184: SELECT workitem_id
185: FROM xdp_workitems
186: WHERE workitem_name = lv_wi_name
187: AND sysdate >= valid_date
188: AND sysdate <= NVL(invalid_date,sysdate);
189: BEGIN

Line 202: FROM xdp_workitems

198:
199: IF p_version IS NOT NULL THEN
200: BEGIN
201: SELECT workitem_id into lv_wi_id
202: FROM xdp_workitems
203: WHERE Workitem_name = lv_wi_name
204: AND version = lv_wi_version
205: AND sysdate >= valid_date
206: AND sysdate <= NVL(invalid_date,sysdate + 1);

Line 4401: XDP_WORKITEMS wi

4397: ,wi.PROTECTED_FLAG
4398: ,wi.ROLE_NAME
4399: from XDP_SERVICE_WI_MAP swp,
4400: XDP_SERVICE_VAL_ACTS svn,
4401: XDP_WORKITEMS wi
4402: where swp.service_val_act_id = svn.service_val_act_id and
4403: svn.inventory_item_id = l_inventory_item_id and
4404: svn.organization_id = l_organization_id and
4405: swp.workitem_id = wi.workitem_id and

Line 4476: FROM XDP_WORKITEMS

4472: lv_wf_exec,
4473: lv_time,
4474: lv_protected_flag,
4475: lv_role_name
4476: FROM XDP_WORKITEMS
4477: WHERE Workitem_id= p_service_order_line_list(lv_index).workitem_id;
4478:
4479: EXCEPTION
4480: WHEN OTHERS THEN