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.EAM_COMPLETION dependencies on EAM_ASSET_STATUS_HISTORY

Line 406: -- get the asset_status_id from eam_asset_status_history_s sequence

402: s_wip_entity_id NUMBER DEFAULT NULL ) IS
403:
404: i_asset_status_id NUMBER;
405: BEGIN
406: -- get the asset_status_id from eam_asset_status_history_s sequence
407: SELECT eam_asset_status_history_s.nextval INTO i_asset_status_id FROM dual;
408:
409: -- Enhancement Bug 3852846
410: UPDATE eam_asset_status_history

Line 407: SELECT eam_asset_status_history_s.nextval INTO i_asset_status_id FROM dual;

403:
404: i_asset_status_id NUMBER;
405: BEGIN
406: -- get the asset_status_id from eam_asset_status_history_s sequence
407: SELECT eam_asset_status_history_s.nextval INTO i_asset_status_id FROM dual;
408:
409: -- Enhancement Bug 3852846
410: UPDATE eam_asset_status_history
411: SET enable_flag = 'N'

Line 410: UPDATE eam_asset_status_history

406: -- get the asset_status_id from eam_asset_status_history_s sequence
407: SELECT eam_asset_status_history_s.nextval INTO i_asset_status_id FROM dual;
408:
409: -- Enhancement Bug 3852846
410: UPDATE eam_asset_status_history
411: SET enable_flag = 'N'
412: , last_update_date = SYSDATE
413: , last_updated_by = FND_GLOBAL.user_id
414: , last_update_login = FND_GLOBAL.login_id

Line 420: INSERT INTO eam_asset_status_history(asset_status_id,

416: AND wip_entity_id = s_wip_entity_id
417: AND operation_seq_num IS NULL
418: AND (enable_flag is NULL OR enable_flag = 'Y');
419:
420: INSERT INTO eam_asset_status_history(asset_status_id,
421: organization_id,
422: asset_group_id,
423: asset_number,
424: start_date,

Line 1377: -- eam_asset_status_history table for history purpose

1373: Hence moved out of IF block mentioned above */
1374:
1375: -- Check whether the user provide Shutdown Information or not
1376: -- If the user provide shutdown information, insert the data to
1377: -- eam_asset_status_history table for history purpose
1378: if(x_shutdown_start_date is not null and
1379: x_shutdown_end_date is not null) then
1380: process_shutdown(s_asset_group_id => i_asset_group_id,
1381: s_organization_id => i_org_id,

Line 1468: UPDATE eam_asset_status_history

1464: end if; --end work order check
1465:
1466: /* Bug # 5165813 : Allow shutdown info for rebuild wo also.
1467: Hence moved out of IF block mentioned above */
1468: UPDATE eam_asset_status_history
1469: SET enable_flag = 'N'
1470: , last_update_date = SYSDATE
1471: , last_updated_by = FND_GLOBAL.user_id
1472: , last_update_login = FND_GLOBAL.login_id