DBA Data[Home] [Help]

APPS.XDP_DRC_UTIL_PVT dependencies on XDP_ORDER_LINE_ITEMS

Line 98: insert into xdp_order_line_items

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,

Line 121: XDP_ORDER_LINE_ITEMS_S.NextVal,

117:
118: )
119: values
120: (
121: XDP_ORDER_LINE_ITEMS_S.NextVal,
122: x_SDP_ORDER_ID,
123: 1,
124: lv_wi,
125: 'Y',

Line 209: update xdp_order_line_items

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,

Line 225: update xdp_order_line_items

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,