94: FND_GLOBAL.USER_ID,
95: FND_GLOBAL.LOGIN_ID
96: );
97:
98: insert into xdp_order_line_items
99: (
100: line_item_id,
101: order_id,
102: line_number,
117:
118: )
119: values
120: (
121: XDP_ORDER_LINE_ITEMS_S.NextVal,
122: x_SDP_ORDER_ID,
123: 1,
124: lv_wi,
125: 'Y',
205: last_updated_by = FND_GLOBAL.USER_ID,
206: last_update_login = FND_GLOBAL.LOGIN_ID
207: where order_id = x_sdp_order_id;
208:
209: update xdp_order_line_items
210: set status_code = 'COMPLETED',
211: state = 'COMPLETED',
212: last_update_date = sysdate,
213: last_updated_by = FND_GLOBAL.USER_ID,
221: last_updated_by = FND_GLOBAL.USER_ID,
222: last_update_login = FND_GLOBAL.LOGIN_ID
223: where order_id = x_sdp_order_id;
224:
225: update xdp_order_line_items
226: set status_code = 'ERROR',
227: state = 'COMPLETED',
228: last_update_date = sysdate,
229: last_updated_by = FND_GLOBAL.USER_ID,