2371: BEGIN
2372: UPDATE xdp_order_bundles
2373: SET status = p_status,
2374: last_update_date = sysdate,
2375: last_updated_by = fnd_global.user_id,
2376: last_update_login = fnd_global.login_id
2377: WHERE order_id = p_order_id
2378: AND bundle_id = p_bundle_id ;
2379: COMMIT;
2372: UPDATE xdp_order_bundles
2373: SET status = p_status,
2374: last_update_date = sysdate,
2375: last_updated_by = fnd_global.user_id,
2376: last_update_login = fnd_global.login_id
2377: WHERE order_id = p_order_id
2378: AND bundle_id = p_bundle_id ;
2379: COMMIT;
2380:
2399: UPDATE xdp_order_headers
2400: SET status_code = p_status ,
2401: completion_date = sysdate ,
2402: last_update_date = sysdate,
2403: last_updated_by = fnd_global.user_id,
2404: last_update_login = fnd_global.login_id
2405: WHERE order_id = p_order_id ;
2406: ELSE
2407: UPDATE xdp_order_headers
2400: SET status_code = p_status ,
2401: completion_date = sysdate ,
2402: last_update_date = sysdate,
2403: last_updated_by = fnd_global.user_id,
2404: last_update_login = fnd_global.login_id
2405: WHERE order_id = p_order_id ;
2406: ELSE
2407: UPDATE xdp_order_headers
2408: SET status_code = p_status ,
2406: ELSE
2407: UPDATE xdp_order_headers
2408: SET status_code = p_status ,
2409: last_update_date = sysdate,
2410: last_updated_by = fnd_global.user_id,
2411: last_update_login = fnd_global.login_id
2412: WHERE order_id = p_order_id ;
2413:
2414: END IF ;
2407: UPDATE xdp_order_headers
2408: SET status_code = p_status ,
2409: last_update_date = sysdate,
2410: last_updated_by = fnd_global.user_id,
2411: last_update_login = fnd_global.login_id
2412: WHERE order_id = p_order_id ;
2413:
2414: END IF ;
2415:
2435:
2436: UPDATE xdp_order_line_items
2437: SET status_code = p_status ,
2438: last_update_date = sysdate,
2439: last_updated_by = fnd_global.user_id,
2440: last_update_login = fnd_global.login_id
2441: WHERE line_item_id = p_line_item_id ;
2442: ELSE
2443: UPDATE xdp_order_line_items
2436: UPDATE xdp_order_line_items
2437: SET status_code = p_status ,
2438: last_update_date = sysdate,
2439: last_updated_by = fnd_global.user_id,
2440: last_update_login = fnd_global.login_id
2441: WHERE line_item_id = p_line_item_id ;
2442: ELSE
2443: UPDATE xdp_order_line_items
2444: SET status_code = p_status ,
2443: UPDATE xdp_order_line_items
2444: SET status_code = p_status ,
2445: completion_date = sysdate ,
2446: last_update_date = sysdate,
2447: last_updated_by = fnd_global.user_id,
2448: last_update_login = fnd_global.login_id
2449: WHERE line_item_id = p_line_item_id ;
2450: END IF ;
2451:
2444: SET status_code = p_status ,
2445: completion_date = sysdate ,
2446: last_update_date = sysdate,
2447: last_updated_by = fnd_global.user_id,
2448: last_update_login = fnd_global.login_id
2449: WHERE line_item_id = p_line_item_id ;
2450: END IF ;
2451:
2452: COMMIT;
2471:
2472: UPDATE xdp_fulfill_worklist
2473: SET status_code = p_status ,
2474: last_update_date = sysdate,
2475: last_updated_by = fnd_global.user_id,
2476: last_update_login = fnd_global.login_id
2477: WHERE workitem_instance_id = p_workitem_instance_id ;
2478: ELSE
2479: UPDATE xdp_fulfill_worklist
2472: UPDATE xdp_fulfill_worklist
2473: SET status_code = p_status ,
2474: last_update_date = sysdate,
2475: last_updated_by = fnd_global.user_id,
2476: last_update_login = fnd_global.login_id
2477: WHERE workitem_instance_id = p_workitem_instance_id ;
2478: ELSE
2479: UPDATE xdp_fulfill_worklist
2480: SET status_code = p_status ,
2479: UPDATE xdp_fulfill_worklist
2480: SET status_code = p_status ,
2481: completion_date = sysdate ,
2482: last_update_date = sysdate,
2483: last_updated_by = fnd_global.user_id,
2484: last_update_login = fnd_global.login_id
2485: WHERE workitem_instance_id = p_workitem_instance_id ;
2486: END IF ;
2487:
2480: SET status_code = p_status ,
2481: completion_date = sysdate ,
2482: last_update_date = sysdate,
2483: last_updated_by = fnd_global.user_id,
2484: last_update_login = fnd_global.login_id
2485: WHERE workitem_instance_id = p_workitem_instance_id ;
2486: END IF ;
2487:
2488: COMMIT;
2507:
2508: UPDATE xdp_fa_runtime_list
2509: SET status_code = p_status ,
2510: last_update_date = sysdate,
2511: last_updated_by = fnd_global.user_id,
2512: last_update_login = fnd_global.login_id
2513: WHERE fa_instance_id = p_fa_instance_id ;
2514: ELSE
2515: UPDATE xdp_fa_runtime_list
2508: UPDATE xdp_fa_runtime_list
2509: SET status_code = p_status ,
2510: last_update_date = sysdate,
2511: last_updated_by = fnd_global.user_id,
2512: last_update_login = fnd_global.login_id
2513: WHERE fa_instance_id = p_fa_instance_id ;
2514: ELSE
2515: UPDATE xdp_fa_runtime_list
2516: SET status_code = p_status ,
2515: UPDATE xdp_fa_runtime_list
2516: SET status_code = p_status ,
2517: completion_date = sysdate ,
2518: last_update_date = sysdate,
2519: last_updated_by = fnd_global.user_id,
2520: last_update_login = fnd_global.login_id
2521: WHERE fa_instance_id = p_fa_instance_id ;
2522:
2523: END IF ;
2516: SET status_code = p_status ,
2517: completion_date = sysdate ,
2518: last_update_date = sysdate,
2519: last_updated_by = fnd_global.user_id,
2520: last_update_login = fnd_global.login_id
2521: WHERE fa_instance_id = p_fa_instance_id ;
2522:
2523: END IF ;
2524: