DBA Data[Home] [Help]

APPS.EAM_OP_COMP_UTILITY_PVT dependencies on FND_GLOBAL

Line 132: FND_GLOBAL.user_id,

128: p_eam_op_comp_rec.vendor_site_id,
129: p_eam_op_comp_rec.vendor_contact_id,
130: p_eam_op_comp_rec.reason_id,
131: p_eam_op_comp_rec.reference, -- transaction_reference
132: FND_GLOBAL.user_id,
133: sysdate,
134: FND_GLOBAL.user_id,
135: sysdate,
136: FND_GLOBAL.login_id,

Line 134: FND_GLOBAL.user_id,

130: p_eam_op_comp_rec.reason_id,
131: p_eam_op_comp_rec.reference, -- transaction_reference
132: FND_GLOBAL.user_id,
133: sysdate,
134: FND_GLOBAL.user_id,
135: sysdate,
136: FND_GLOBAL.login_id,
137: p_eam_op_comp_rec.attribute_category,
138: p_eam_op_comp_rec.attribute1,

Line 136: FND_GLOBAL.login_id,

132: FND_GLOBAL.user_id,
133: sysdate,
134: FND_GLOBAL.user_id,
135: sysdate,
136: FND_GLOBAL.login_id,
137: p_eam_op_comp_rec.attribute_category,
138: p_eam_op_comp_rec.attribute1,
139: p_eam_op_comp_rec.attribute2,
140: p_eam_op_comp_rec.attribute3,

Line 227: FND_GLOBAL.user_id,

223: p_eam_op_comp_rec.shutdown_start_date,
224: p_eam_op_comp_rec.shutdown_end_date,
225: p_eam_op_comp_rec.wip_entity_id,
226: p_eam_op_comp_rec.operation_seq_num,
227: FND_GLOBAL.user_id,
228: SYSDATE,
229: FND_GLOBAL.user_id,
230: SYSDATE,
231: FND_GLOBAL.login_id,

Line 229: FND_GLOBAL.user_id,

225: p_eam_op_comp_rec.wip_entity_id,
226: p_eam_op_comp_rec.operation_seq_num,
227: FND_GLOBAL.user_id,
228: SYSDATE,
229: FND_GLOBAL.user_id,
230: SYSDATE,
231: FND_GLOBAL.login_id,
232: p_eam_op_comp_rec.attribute_category,
233: p_eam_op_comp_rec.attribute1,

Line 231: FND_GLOBAL.login_id,

227: FND_GLOBAL.user_id,
228: SYSDATE,
229: FND_GLOBAL.user_id,
230: SYSDATE,
231: FND_GLOBAL.login_id,
232: p_eam_op_comp_rec.attribute_category,
233: p_eam_op_comp_rec.attribute1,
234: p_eam_op_comp_rec.attribute2,
235: p_eam_op_comp_rec.attribute3,

Line 300: , last_updated_by = FND_GLOBAL.user_id

296: /*IF NVL(to_number(l_shutdown_type),1) = 2 THEN
297: UPDATE eam_asset_status_history
298: SET enable_flag = 'N'
299: , last_update_date = SYSDATE
300: , last_updated_by = FND_GLOBAL.user_id
301: , last_update_login = FND_GLOBAL.login_id
302: WHERE organization_id = p_eam_op_comp_rec.organization_id
303: AND wip_entity_id = p_eam_op_comp_rec.wip_entity_id
304: AND operation_seq_num = p_eam_op_comp_rec.operation_seq_num

Line 301: , last_update_login = FND_GLOBAL.login_id

297: UPDATE eam_asset_status_history
298: SET enable_flag = 'N'
299: , last_update_date = SYSDATE
300: , last_updated_by = FND_GLOBAL.user_id
301: , last_update_login = FND_GLOBAL.login_id
302: WHERE organization_id = p_eam_op_comp_rec.organization_id
303: AND wip_entity_id = p_eam_op_comp_rec.wip_entity_id
304: AND operation_seq_num = p_eam_op_comp_rec.operation_seq_num
305: AND enable_flag = 'Y' OR enable_flag IS NULL;

Line 315: , last_updated_by = FND_GLOBAL.user_id

311: IF NVL(to_number(l_shutdown_type),1) <> 2 THEN
312: UPDATE eam_asset_status_history
313: SET enable_flag = 'N'
314: , last_update_date = SYSDATE
315: , last_updated_by = FND_GLOBAL.user_id
316: , last_update_login = FND_GLOBAL.login_id
317: WHERE organization_id = p_eam_op_comp_rec.organization_id
318: AND wip_entity_id = p_eam_op_comp_rec.wip_entity_id
319: AND operation_seq_num = p_eam_op_comp_rec.operation_seq_num

Line 316: , last_update_login = FND_GLOBAL.login_id

312: UPDATE eam_asset_status_history
313: SET enable_flag = 'N'
314: , last_update_date = SYSDATE
315: , last_updated_by = FND_GLOBAL.user_id
316: , last_update_login = FND_GLOBAL.login_id
317: WHERE organization_id = p_eam_op_comp_rec.organization_id
318: AND wip_entity_id = p_eam_op_comp_rec.wip_entity_id
319: AND operation_seq_num = p_eam_op_comp_rec.operation_seq_num
320: AND enable_flag = 'Y' OR enable_flag IS NULL;

Line 331: , last_updated_by = FND_GLOBAL.user_id

327: IF NVL(to_number(l_shutdown_type), 1) = 2 THEN
328: UPDATE eam_asset_status_history
329: SET enable_flag = 'Y'
330: , last_update_date = SYSDATE
331: , last_updated_by = FND_GLOBAL.user_id
332: , last_update_login = FND_GLOBAL.login_id
333: WHERE organization_id = p_eam_op_comp_rec.organization_id
334: AND wip_entity_id = p_eam_op_comp_rec.wip_entity_id
335: AND operation_seq_num = p_eam_op_comp_rec.operation_seq_num

Line 332: , last_update_login = FND_GLOBAL.login_id

328: UPDATE eam_asset_status_history
329: SET enable_flag = 'Y'
330: , last_update_date = SYSDATE
331: , last_updated_by = FND_GLOBAL.user_id
332: , last_update_login = FND_GLOBAL.login_id
333: WHERE organization_id = p_eam_op_comp_rec.organization_id
334: AND wip_entity_id = p_eam_op_comp_rec.wip_entity_id
335: AND operation_seq_num = p_eam_op_comp_rec.operation_seq_num
336: AND enable_flag = 'N' OR enable_flag IS NULL;

Line 345: last_updated_by = FND_GLOBAL.user_id,

341: UPDATE wip_operations
342: SET
343: operation_completed = decode(p_eam_op_comp_rec.transaction_type,EAM_PROCESS_WO_PVT.G_OPR_COMPLETE,'Y',EAM_PROCESS_WO_PVT.G_OPR_UNCOMPLETE,'N'),
344: quantity_completed = 1,
345: last_updated_by = FND_GLOBAL.user_id,
346: last_update_date = sysdate,
347: last_update_login = FND_GLOBAL.login_id
348: WHERE
349: wip_entity_id = p_eam_op_comp_rec.wip_entity_id

Line 347: last_update_login = FND_GLOBAL.login_id

343: operation_completed = decode(p_eam_op_comp_rec.transaction_type,EAM_PROCESS_WO_PVT.G_OPR_COMPLETE,'Y',EAM_PROCESS_WO_PVT.G_OPR_UNCOMPLETE,'N'),
344: quantity_completed = 1,
345: last_updated_by = FND_GLOBAL.user_id,
346: last_update_date = sysdate,
347: last_update_login = FND_GLOBAL.login_id
348: WHERE
349: wip_entity_id = p_eam_op_comp_rec.wip_entity_id
350: AND operation_seq_num = p_eam_op_comp_rec.operation_seq_num;
351: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Exiting Package EAM_OP_COMP_UTILITY_PVT.update_row procedure'); END IF;