32: SET
33: wip_entity_id = p_eam_request_rec.wip_entity_id,
34: work_request_status_id = 4,
35: last_update_date = sysdate,
36: last_updated_by = FND_GLOBAL.user_id,
37: last_update_login = fnd_global.login_id
38: WHERE work_request_id = p_eam_request_rec.request_id
39: AND organization_id = p_eam_request_rec.organization_id;
40:
33: wip_entity_id = p_eam_request_rec.wip_entity_id,
34: work_request_status_id = 4,
35: last_update_date = sysdate,
36: last_updated_by = FND_GLOBAL.user_id,
37: last_update_login = fnd_global.login_id
38: WHERE work_request_id = p_eam_request_rec.request_id
39: AND organization_id = p_eam_request_rec.organization_id;
40:
41: END IF;
75: p_eam_request_rec.organization_id,
76: p_eam_request_rec.wip_entity_id,
77: p_eam_request_rec.request_id,
78: sysdate,
79: FND_GLOBAL.USER_ID,
80: FND_GLOBAL.LOGIN_ID,
81: null,--fnd_global.conc_program_id,
82: null,
83: null,
76: p_eam_request_rec.wip_entity_id,
77: p_eam_request_rec.request_id,
78: sysdate,
79: FND_GLOBAL.USER_ID,
80: FND_GLOBAL.LOGIN_ID,
81: null,--fnd_global.conc_program_id,
82: null,
83: null,
84: null,
77: p_eam_request_rec.request_id,
78: sysdate,
79: FND_GLOBAL.USER_ID,
80: FND_GLOBAL.LOGIN_ID,
81: null,--fnd_global.conc_program_id,
82: null,
83: null,
84: null,
85: null,
94: null,
95: null,
96: null,
97: null,
98: fnd_global.user_id,
99: sysdate,
100: 'Y'); -- Fix for 3773450
101: END IF;
102:
115: UPDATE WIP_EAM_WORK_REQUESTS
116: SET wip_entity_id = null,
117: work_request_status_id = 3,
118: last_update_date = sysdate,
119: last_updated_by = FND_GLOBAL.user_id
120: WHERE work_request_id = p_eam_request_rec.request_id
121: AND organization_id = p_eam_request_rec.organization_id;
122: END IF;
123:
125:
126: UPDATE EAM_WO_SERVICE_ASSOCIATION -- Fix for 3773450
127: SET enable_flag = 'N',
128: last_update_date = sysdate,
129: last_updated_by = FND_GLOBAL.user_id,
130: last_update_login = FND_GLOBAL.login_id
131: WHERE service_request_id = p_eam_request_rec.request_id
132: AND wip_entity_id = p_eam_request_rec.wip_entity_id
133: AND maintenance_organization_id = p_eam_request_rec.organization_id
126: UPDATE EAM_WO_SERVICE_ASSOCIATION -- Fix for 3773450
127: SET enable_flag = 'N',
128: last_update_date = sysdate,
129: last_updated_by = FND_GLOBAL.user_id,
130: last_update_login = FND_GLOBAL.login_id
131: WHERE service_request_id = p_eam_request_rec.request_id
132: AND wip_entity_id = p_eam_request_rec.wip_entity_id
133: AND maintenance_organization_id = p_eam_request_rec.organization_id
134: AND (enable_flag IS NULL or enable_flag = 'Y');