eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XDPSTATUS dependencies on FND_GLOBAL

Line 2375: last_updated_by = fnd_global.user_id,

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;

Line 2376: last_update_login = fnd_global.login_id

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:

Line 2403: last_updated_by = fnd_global.user_id,

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

Line 2404: last_update_login = fnd_global.login_id

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 ,

Line 2410: last_updated_by = fnd_global.user_id,

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 ;

Line 2411: last_update_login = fnd_global.login_id

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:

Line 2439: last_updated_by = fnd_global.user_id,

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

Line 2440: last_update_login = fnd_global.login_id

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 ,

Line 2447: last_updated_by = fnd_global.user_id,

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:

Line 2448: last_update_login = fnd_global.login_id

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;

Line 2475: last_updated_by = fnd_global.user_id,

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

Line 2476: last_update_login = fnd_global.login_id

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 ,

Line 2483: last_updated_by = fnd_global.user_id,

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:

Line 2484: last_update_login = fnd_global.login_id

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;

Line 2511: last_updated_by = fnd_global.user_id,

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

Line 2512: last_update_login = fnd_global.login_id

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 ,

Line 2519: last_updated_by = fnd_global.user_id,

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 ;

Line 2520: last_update_login = fnd_global.login_id

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: