APPS.EAM_OP_COMP dependencies on EAM_ASSET_STATUS_HISTORY

Line 109: --bug 3572376: pass following parameters to EAM_ASSET_STATUS_HISTORY

105: l_wf_event_seq NUMBER;
106: l_op_sched_end_date DATE;
107: l_wip_entity_name VARCHAR2(240);
108:
109: --bug 3572376: pass following parameters to EAM_ASSET_STATUS_HISTORY
110: l_maintenance_object_type NUMBER := NULL ;
111: l_maintenance_object_id NUMBER := NULL ;
112: l_shutdown_type VARCHAR2(30) :=NULL;
113: CURSOR C IS

Line 188: select asset_status_id from eam_asset_status_history

184: CURSOR CT IS
185: select transaction_id from eam_op_completion_txns
186: where transaction_id = l_transaction_id;
187: CURSOR CH IS
188: select asset_status_id from eam_asset_status_history
189: where asset_status_id = l_status_id;
190:
191: BEGIN
192: x_err_code := 0;

Line 432: UPDATE eam_asset_status_history

428: close CT;
429:
430: -- Enhancemnet Bug 3852846
431: IF NVL(to_number(l_shutdown_type),1) = 2 THEN
432: UPDATE eam_asset_status_history
433: SET enable_flag = 'N'
434: , last_update_date = SYSDATE
435: , last_updated_by = FND_GLOBAL.user_id
436: , last_update_login = FND_GLOBAL.login_id

Line 447: select eam_asset_status_history_s.nextval into l_status_id from dual;

443: -- SHUTDOWN History
444: if (p_shutdown_start_date is not null) or
445: (p_shutdown_end_date is not null) then
446:
447: select eam_asset_status_history_s.nextval into l_status_id from dual;
448:
449: INSERT INTO EAM_ASSET_STATUS_HISTORY(
450: ASSET_STATUS_ID,
451: ASSET_GROUP_ID,

Line 449: INSERT INTO EAM_ASSET_STATUS_HISTORY(

445: (p_shutdown_end_date is not null) then
446:
447: select eam_asset_status_history_s.nextval into l_status_id from dual;
448:
449: INSERT INTO EAM_ASSET_STATUS_HISTORY(
450: ASSET_STATUS_ID,
451: ASSET_GROUP_ID,
452: ASSET_NUMBER,
453: ORGANIZATION_ID,