APPS.XDP_OA_UTIL dependencies on XDP_FULFILL_WORKLIST

Line 152: select XDP_FULFILL_WORKLIST_S.nextval

148: where workitem_name = p_workitem_name;
149: */
150: BEGIN
151:
152: select XDP_FULFILL_WORKLIST_S.nextval
153: into lv_instance_id
154: from dual;
155:
156: select order_id,

Line 235: insert into XDP_FULFILL_WORKLIST

231: from xdp_order_line_items
232: where line_item_id = p_line_item_id;
233: end if;
234:
235: insert into XDP_FULFILL_WORKLIST
236: (workitem_instance_id,
237: line_item_id,
238: order_id,
239: line_number,

Line 333: select XDP_FULFILL_WORKLIST_S.nextval

329:
330:
331: BEGIN
332:
333: select XDP_FULFILL_WORKLIST_S.nextval
334: into lv_instance_id
335: from dual;
336:
337: select order_id,line_number into lv_order_id,lv_line_number

Line 358: insert into XDP_FULFILL_WORKLIST

354: from xdp_order_line_items
355: where line_item_id = p_line_item_id;
356: end if;
357:
358: insert into XDP_FULFILL_WORKLIST
359: (workitem_instance_id,
360: line_item_id,
361: order_id,
362: line_number,

Line 615: from XDP_FULFILL_WORKLIST

611:
612: SAVEPOINT lv_order_tag2;
613:
614: select status_code into lv_state
615: from XDP_FULFILL_WORKLIST
616: where workitem_instance_id = p_workitem_instance_id and
617: order_id = p_sdp_order_id;
618:
619: if lv_state IN ('CANCELED','ABORTED') Then

Line 640: update XDP_FULFILL_WORKLIST

636: return_code => return_code,
637: error_description => error_description);
638:
639: IF return_code = 0 THEN
640: update XDP_FULFILL_WORKLIST
641: set last_updated_by = FND_GLOBAL.USER_ID,
642: last_update_date = sysdate,
643: last_update_login = FND_GLOBAL.LOGIN_ID,
644: status_code = 'CANCELED'

Line 649: update XDP_FULFILL_WORKLIST

645: where workitem_instance_id = p_workitem_instance_id;
646: return;
647: ELSIF return_code = -54 THEN /*resource_busy exception */
648: begin
649: update XDP_FULFILL_WORKLIST
650: set last_updated_by = FND_GLOBAL.USER_ID,
651: last_update_date = sysdate,
652: last_update_login = FND_GLOBAL.LOGIN_ID,
653: status_code = 'CANCELED'

Line 1284: from XDP_FULFILL_WORKLIST

1280: return_code := 0;
1281: SAVEPOINT lv_wi_tag;
1282: select status_code,order_id
1283: into lv_curr_state,lv_curr_order_id
1284: from XDP_FULFILL_WORKLIST
1285: where workitem_instance_id = p_curr_wi_instance_id;
1286:
1287: select status_code ,order_id
1288: into lv_rel_state,lv_rel_order_id

Line 1289: from XDP_FULFILL_WORKLIST

1285: where workitem_instance_id = p_curr_wi_instance_id;
1286:
1287: select status_code ,order_id
1288: into lv_rel_state,lv_rel_order_id
1289: from XDP_FULFILL_WORKLIST
1290: where workitem_instance_id = p_related_wi_instance_id;
1291:
1292: IF p_wi_relationship = XDP_TYPES.MERGED_INTO THEN
1293: IF lv_curr_state IN ('CANCELED','ABORTED','SUCCESS','SUCCESS_WITH_OVERRIDE') THEN

Line 1360: UPDATE XDP_FULFILL_WORKLIST

1356: sysdate,
1357: FND_GLOBAL.LOGIN_ID
1358: );
1359:
1360: UPDATE XDP_FULFILL_WORKLIST
1361: SET
1362: last_updated_by = FND_GLOBAL.USER_ID,
1363: last_update_date = sysdate,
1364: last_update_login = FND_GLOBAL.LOGIN_ID,

Line 1379: UPDATE XDP_FULFILL_WORKLIST

1375: WI_RELATIONSHIP = lv_relation
1376: where workitem_instance_id = p_curr_wi_instance_id AND
1377: related_wi_instance_id = p_related_wi_instance_id;
1378:
1379: UPDATE XDP_FULFILL_WORKLIST
1380: SET
1381: last_updated_by = FND_GLOBAL.USER_ID,
1382: last_update_date = sysdate,
1383: last_update_login = FND_GLOBAL.LOGIN_ID,

Line 1592: XDP_FULFILL_WORKLIST fwt,

1588: wi_sequence,
1589: priority,
1590: status_code
1591: from
1592: XDP_FULFILL_WORKLIST fwt,
1593: xdp_workitems wim
1594: where
1595: fwt.workitem_instance_id = p_wi_instance_id and
1596: fwt.workitem_id = wim.workitem_id

Line 1634: XDP_FULFILL_WORKLIST fwt,

1630: wi_sequence,
1631: priority,
1632: status_code
1633: from
1634: XDP_FULFILL_WORKLIST fwt,
1635: xdp_workitems wim
1636: where
1637: fwt.order_id = p_sdp_order_id and
1638: fwt.workitem_id = wim.workitem_id

Line 1997: ' XDP_FULFILL_WORKLIST FWT '||

1993: return;
1994: END IF;
1995:
1996: lv_plsql := 'SELECT DISTINCT FWT.WORKITEM_INSTANCE_ID FROM '||
1997: ' XDP_FULFILL_WORKLIST FWT '||
1998: ' WHERE FWT.ORDER_ID = '||
1999: p_sdp_order_id ||
2000: ' AND ' ||
2001: p_where;