DBA Data[Home] [Help]

APPS.EAM_COMPLETION dependencies on EAM_ASSET_STATUS_HISTORY_S

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'