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_PROCESS_WO_PVT dependencies on FND_GLOBAL

Line 168: p_value =>FND_GLOBAL.USER_NAME ,

164: Wf_Event.AddParameterToList(p_name =>'WORKFLOW_TYPE',
165: p_value => TO_CHAR(p_eam_wo_rec.workflow_type),
166: p_parameterlist => l_parameter_list);
167: Wf_Event.AddParameterToList(p_name =>'REQUESTOR',
168: p_value =>FND_GLOBAL.USER_NAME ,
169: p_parameterlist => l_parameter_list);
170: Wf_Core.Context('Enterprise Asset Management...','Work Order Creation Event','Raising event');
171:
172: Wf_Event.Raise( p_event_name => l_event_name,

Line 225: p_value =>FND_GLOBAL.USER_NAME ,

221: Wf_Event.AddParameterToList(p_name =>'WORKFLOW_TYPE',
222: p_value => TO_CHAR(p_eam_wo_rec.workflow_type),
223: p_parameterlist => l_parameter_list);
224: Wf_Event.AddParameterToList(p_name =>'REQUESTOR',
225: p_value =>FND_GLOBAL.USER_NAME ,
226: p_parameterlist => l_parameter_list);
227: Wf_Core.Context('Enterprise Asset Management...','Work Order Staus Changed Event','Raising event');
228:
229: Wf_Event.Raise( p_event_name => l_event_name,

Line 267: (p_eam_wo_rec.wip_entity_id,p_workflow_name,l_event_key,SYSDATE,FND_GLOBAL.user_id,

263: INSERT INTO EAM_WO_WORKFLOWS
264: (WIP_ENTITY_ID,WF_ITEM_TYPE,WF_ITEM_KEY,LAST_UPDATE_DATE,LAST_UPDATED_BY,
265: CREATION_DATE,CREATED_BY,LAST_UPDATE_LOGIN)
266: VALUES
267: (p_eam_wo_rec.wip_entity_id,p_workflow_name,l_event_key,SYSDATE,FND_GLOBAL.user_id,
268: SYSDATE,FND_GLOBAL.user_id,FND_GLOBAL.login_id
269: );
270:
271:

Line 268: SYSDATE,FND_GLOBAL.user_id,FND_GLOBAL.login_id

264: (WIP_ENTITY_ID,WF_ITEM_TYPE,WF_ITEM_KEY,LAST_UPDATE_DATE,LAST_UPDATED_BY,
265: CREATION_DATE,CREATED_BY,LAST_UPDATE_LOGIN)
266: VALUES
267: (p_eam_wo_rec.wip_entity_id,p_workflow_name,l_event_key,SYSDATE,FND_GLOBAL.user_id,
268: SYSDATE,FND_GLOBAL.user_id,FND_GLOBAL.login_id
269: );
270:
271:
272: WF_CORE.CONTEXT('Enterprise Asset Management...','Work Order Released change event','Building parameter list');

Line 302: p_value =>FND_GLOBAL.USER_NAME ,

298: Wf_Event.AddParameterToList(p_name =>'WORKFLOW_TYPE',
299: p_value => TO_CHAR(p_eam_wo_rec.workflow_type),
300: p_parameterlist => l_parameter_list);
301: Wf_Event.AddParameterToList(p_name =>'REQUESTOR',
302: p_value =>FND_GLOBAL.USER_NAME ,
303: p_parameterlist => l_parameter_list);
304: Wf_Event.AddParameterToList(p_name =>'WARRANTY_STATUS',
305: p_value => TO_CHAR(p_eam_wo_rec.warranty_claim_status),
306: p_parameterlist => l_parameter_list);

Line 360: p_last_updated_by => FND_GLOBAL.user_id,

356: p_event => 'INSERT',
357: p_wip_entity_id =>p_eam_wo_rec.wip_entity_id,
358: p_organization_id =>p_eam_wo_rec.organization_id,
359: p_last_update_date => SYSDATE,
360: p_last_updated_by => FND_GLOBAL.user_id,
361: p_last_update_login =>FND_GLOBAL.login_id
362: );
363: RETURN;
364: END IF;

Line 361: p_last_update_login =>FND_GLOBAL.login_id

357: p_wip_entity_id =>p_eam_wo_rec.wip_entity_id,
358: p_organization_id =>p_eam_wo_rec.organization_id,
359: p_last_update_date => SYSDATE,
360: p_last_updated_by => FND_GLOBAL.user_id,
361: p_last_update_login =>FND_GLOBAL.login_id
362: );
363: RETURN;
364: END IF;
365:

Line 427: p_last_updated_by => FND_GLOBAL.user_id,

423: p_event => 'UPDATE',
424: p_wip_entity_id =>p_eam_wo_rec.wip_entity_id,
425: p_organization_id =>p_eam_wo_rec.organization_id,
426: p_last_update_date => SYSDATE,
427: p_last_updated_by => FND_GLOBAL.user_id,
428: p_last_update_login =>FND_GLOBAL.login_id
429: );
430: END IF;
431:

Line 428: p_last_update_login =>FND_GLOBAL.login_id

424: p_wip_entity_id =>p_eam_wo_rec.wip_entity_id,
425: p_organization_id =>p_eam_wo_rec.organization_id,
426: p_last_update_date => SYSDATE,
427: p_last_updated_by => FND_GLOBAL.user_id,
428: p_last_update_login =>FND_GLOBAL.login_id
429: );
430: END IF;
431:
432: END UPDATE_INTERMEDIA_INDEX;

Line 3531: ,p_user_id => fnd_global.user_id

3527: ,x_msg_data => l_api_msg_data
3528: ,p_wip_entity_id => l_eam_mat_req_rec.wip_entity_id
3529: ,p_operation_seq_num => l_eam_mat_req_rec.operation_seq_num
3530: ,p_organization_id => l_eam_mat_req_rec.organization_id
3531: ,p_user_id => fnd_global.user_id
3532: ,p_responsibility_id => fnd_global.resp_id
3533: ,p_quantity => l_eam_mat_req_rec.requested_quantity
3534: ,p_unit_price => l_eam_mat_req_rec.unit_price
3535: ,p_category_id => l_purch_cat_id

Line 3532: ,p_responsibility_id => fnd_global.resp_id

3528: ,p_wip_entity_id => l_eam_mat_req_rec.wip_entity_id
3529: ,p_operation_seq_num => l_eam_mat_req_rec.operation_seq_num
3530: ,p_organization_id => l_eam_mat_req_rec.organization_id
3531: ,p_user_id => fnd_global.user_id
3532: ,p_responsibility_id => fnd_global.resp_id
3533: ,p_quantity => l_eam_mat_req_rec.requested_quantity
3534: ,p_unit_price => l_eam_mat_req_rec.unit_price
3535: ,p_category_id => l_purch_cat_id
3536: ,p_item_description => l_description

Line 3630: ,p_user_id => fnd_global.user_id

3626: ,x_msg_data => l_api_msg_data
3627: ,p_wip_entity_id => l_eam_mat_req_rec.wip_entity_id
3628: ,p_operation_seq_num => l_eam_mat_req_rec.operation_seq_num
3629: ,p_organization_id => l_eam_mat_req_rec.organization_id
3630: ,p_user_id => fnd_global.user_id
3631: ,p_responsibility_id => fnd_global.resp_id
3632: ,p_quantity => (l_eam_mat_req_rec.required_quantity
3633: -nvl(l_total_req_qty,0))
3634: ,p_unit_price => l_eam_mat_req_rec.unit_price

Line 3631: ,p_responsibility_id => fnd_global.resp_id

3627: ,p_wip_entity_id => l_eam_mat_req_rec.wip_entity_id
3628: ,p_operation_seq_num => l_eam_mat_req_rec.operation_seq_num
3629: ,p_organization_id => l_eam_mat_req_rec.organization_id
3630: ,p_user_id => fnd_global.user_id
3631: ,p_responsibility_id => fnd_global.resp_id
3632: ,p_quantity => (l_eam_mat_req_rec.required_quantity
3633: -nvl(l_total_req_qty,0))
3634: ,p_unit_price => l_eam_mat_req_rec.unit_price
3635: ,p_category_id => l_purch_cat_id

Line 4360: ,p_user_id => fnd_global.user_id

4356: ,x_msg_data => l_api_msg_data
4357: ,p_wip_entity_id => l_eam_direct_items_rec.wip_entity_id
4358: ,p_operation_seq_num => l_eam_direct_items_rec.operation_seq_num
4359: ,p_organization_id => l_eam_direct_items_rec.organization_id
4360: ,p_user_id => fnd_global.user_id
4361: ,p_responsibility_id => fnd_global.resp_id
4362: ,p_quantity => l_eam_direct_items_rec.requested_quantity
4363: ,p_unit_price => l_eam_direct_items_rec.unit_price
4364: ,p_category_id => l_eam_direct_items_rec.purchasing_category_id

Line 4361: ,p_responsibility_id => fnd_global.resp_id

4357: ,p_wip_entity_id => l_eam_direct_items_rec.wip_entity_id
4358: ,p_operation_seq_num => l_eam_direct_items_rec.operation_seq_num
4359: ,p_organization_id => l_eam_direct_items_rec.organization_id
4360: ,p_user_id => fnd_global.user_id
4361: ,p_responsibility_id => fnd_global.resp_id
4362: ,p_quantity => l_eam_direct_items_rec.requested_quantity
4363: ,p_unit_price => l_eam_direct_items_rec.unit_price
4364: ,p_category_id => l_eam_direct_items_rec.purchasing_category_id
4365: ,p_item_description => l_eam_direct_items_rec.description

Line 4427: ,p_user_id => fnd_global.user_id

4423: ,x_msg_data => l_api_msg_data
4424: ,p_wip_entity_id => l_eam_direct_items_rec.wip_entity_id
4425: ,p_operation_seq_num => l_eam_direct_items_rec.operation_seq_num
4426: ,p_organization_id => l_eam_direct_items_rec.organization_id
4427: ,p_user_id => fnd_global.user_id
4428: ,p_responsibility_id => fnd_global.resp_id
4429: ,p_quantity => (l_eam_direct_items_rec.required_quantity
4430: -nvl(l_total_req_qty,0))
4431: ,p_unit_price => l_eam_direct_items_rec.unit_price

Line 4428: ,p_responsibility_id => fnd_global.resp_id

4424: ,p_wip_entity_id => l_eam_direct_items_rec.wip_entity_id
4425: ,p_operation_seq_num => l_eam_direct_items_rec.operation_seq_num
4426: ,p_organization_id => l_eam_direct_items_rec.organization_id
4427: ,p_user_id => fnd_global.user_id
4428: ,p_responsibility_id => fnd_global.resp_id
4429: ,p_quantity => (l_eam_direct_items_rec.required_quantity
4430: -nvl(l_total_req_qty,0))
4431: ,p_unit_price => l_eam_direct_items_rec.unit_price
4432: ,p_category_id => l_eam_direct_items_rec.purchasing_category_id

Line 8342: last_updated_by = FND_GLOBAL.User_Id,

8338:
8339: UPDATE WIP_DISCRETE_JOBS
8340: SET date_released = l_eam_wo_rec.date_released,
8341: last_update_date = SYSDATE,
8342: last_updated_by = FND_GLOBAL.User_Id,
8343: last_update_login = FND_GLOBAL.Login_Id
8344: WHERE wip_entity_id=l_eam_wo_rec.wip_entity_id
8345: AND organization_id=l_eam_wo_rec.organization_id;
8346:

Line 8343: last_update_login = FND_GLOBAL.Login_Id

8339: UPDATE WIP_DISCRETE_JOBS
8340: SET date_released = l_eam_wo_rec.date_released,
8341: last_update_date = SYSDATE,
8342: last_updated_by = FND_GLOBAL.User_Id,
8343: last_update_login = FND_GLOBAL.Login_Id
8344: WHERE wip_entity_id=l_eam_wo_rec.wip_entity_id
8345: AND organization_id=l_eam_wo_rec.organization_id;
8346:
8347: END IF; --end of check for work order being released

Line 8400: last_updated_by = FND_GLOBAL.User_Id,

8396: THEN
8397: update wip_requirement_operations
8398: set released_quantity=required_quantity,
8399: last_update_date = SYSDATE,
8400: last_updated_by = FND_GLOBAL.User_Id,
8401: last_update_login = FND_GLOBAL.Login_Id
8402: where wip_entity_id=l_eam_wo_rec.wip_entity_id
8403: and organization_id=l_eam_wo_rec.organization_id
8404: and required_quantity > 0;

Line 8401: last_update_login = FND_GLOBAL.Login_Id

8397: update wip_requirement_operations
8398: set released_quantity=required_quantity,
8399: last_update_date = SYSDATE,
8400: last_updated_by = FND_GLOBAL.User_Id,
8401: last_update_login = FND_GLOBAL.Login_Id
8402: where wip_entity_id=l_eam_wo_rec.wip_entity_id
8403: and organization_id=l_eam_wo_rec.organization_id
8404: and required_quantity > 0;
8405:

Line 8528: last_updated_by = FND_GLOBAL.User_Id,

8524: --Set the workorder's estimation status to 'Running' and call online cost estimation API CSTPECEP.Estimate_WorkOrder_Grp
8525: UPDATE WIP_DISCRETE_JOBS
8526: SET estimation_status = 2,
8527: last_update_date = SYSDATE,
8528: last_updated_by = FND_GLOBAL.User_Id,
8529: last_update_login = FND_GLOBAL.Login_Id
8530: WHERE wip_entity_id=l_eam_wo_rec.wip_entity_id
8531: AND organization_id=l_eam_wo_rec.organization_id;
8532:

Line 8529: last_update_login = FND_GLOBAL.Login_Id

8525: UPDATE WIP_DISCRETE_JOBS
8526: SET estimation_status = 2,
8527: last_update_date = SYSDATE,
8528: last_updated_by = FND_GLOBAL.User_Id,
8529: last_update_login = FND_GLOBAL.Login_Id
8530: WHERE wip_entity_id=l_eam_wo_rec.wip_entity_id
8531: AND organization_id=l_eam_wo_rec.organization_id;
8532:
8533: BEGIN

Line 11284: last_update_login=FND_GLOBAL.login_id,

11280: UPDATE EAM_WORK_ORDER_DETAILS
11281: SET user_defined_status_id=3,
11282: pending_flag='Y',
11283: last_update_date=SYSDATE,
11284: last_update_login=FND_GLOBAL.login_id,
11285: last_updated_by=FND_GLOBAL.user_id
11286: WHERE wip_entity_id= l_eam_wo_comp_rec.wip_entity_id;
11287:
11288:

Line 11285: last_updated_by=FND_GLOBAL.user_id

11281: SET user_defined_status_id=3,
11282: pending_flag='Y',
11283: last_update_date=SYSDATE,
11284: last_update_login=FND_GLOBAL.login_id,
11285: last_updated_by=FND_GLOBAL.user_id
11286: WHERE wip_entity_id= l_eam_wo_comp_rec.wip_entity_id;
11287:
11288:
11289:

Line 11317: (l_eam_wo_comp_rec.wip_entity_id,l_workflow_name,l_event_key,SYSDATE,FND_GLOBAL.user_id,

11313: INSERT INTO EAM_WO_WORKFLOWS
11314: (WIP_ENTITY_ID,WF_ITEM_TYPE,WF_ITEM_KEY,LAST_UPDATE_DATE,LAST_UPDATED_BY,
11315: CREATION_DATE,CREATED_BY,LAST_UPDATE_LOGIN)
11316: VALUES
11317: (l_eam_wo_comp_rec.wip_entity_id,l_workflow_name,l_event_key,SYSDATE,FND_GLOBAL.user_id,
11318: SYSDATE,FND_GLOBAL.user_id,FND_GLOBAL.login_id
11319: );
11320:
11321:

Line 11318: SYSDATE,FND_GLOBAL.user_id,FND_GLOBAL.login_id

11314: (WIP_ENTITY_ID,WF_ITEM_TYPE,WF_ITEM_KEY,LAST_UPDATE_DATE,LAST_UPDATED_BY,
11315: CREATION_DATE,CREATED_BY,LAST_UPDATE_LOGIN)
11316: VALUES
11317: (l_eam_wo_comp_rec.wip_entity_id,l_workflow_name,l_event_key,SYSDATE,FND_GLOBAL.user_id,
11318: SYSDATE,FND_GLOBAL.user_id,FND_GLOBAL.login_id
11319: );
11320:
11321:
11322: WF_CORE.CONTEXT('Enterprise Asset Management...','Work Order Released change event','Building parameter list');

Line 11349: p_value =>FND_GLOBAL.USER_NAME ,

11345: Wf_Event.AddParameterToList(p_name =>'WORKFLOW_TYPE',
11346: p_value => TO_CHAR(l_workflow_type),
11347: p_parameterlist => l_parameter_list);
11348: Wf_Event.AddParameterToList(p_name =>'REQUESTOR',
11349: p_value =>FND_GLOBAL.USER_NAME ,
11350: p_parameterlist => l_parameter_list);
11351: Wf_Event.AddParameterToList(p_name =>'WORKFLOW_NAME',
11352: p_value => l_workflow_name,
11353: p_parameterlist => l_parameter_list);

Line 11377: p_last_updated_by => FND_GLOBAL.user_id,

11373: p_event => 'UPDATE',
11374: p_wip_entity_id =>l_eam_wo_comp_rec.wip_entity_id,
11375: p_organization_id =>l_eam_wo_comp_rec.organization_id,
11376: p_last_update_date => SYSDATE,
11377: p_last_updated_by => FND_GLOBAL.user_id,
11378: p_last_update_login =>FND_GLOBAL.login_id
11379: );
11380: END IF; --end of check for maint. obj. source
11381:

Line 11378: p_last_update_login =>FND_GLOBAL.login_id

11374: p_wip_entity_id =>l_eam_wo_comp_rec.wip_entity_id,
11375: p_organization_id =>l_eam_wo_comp_rec.organization_id,
11376: p_last_update_date => SYSDATE,
11377: p_last_updated_by => FND_GLOBAL.user_id,
11378: p_last_update_login =>FND_GLOBAL.login_id
11379: );
11380: END IF; --end of check for maint. obj. source
11381:
11382: RETURN;

Line 12072: p_value =>FND_GLOBAL.USER_NAME ,

12068: Wf_Event.AddParameterToList(p_name =>'WORKFLOW_TYPE',
12069: p_value => TO_CHAR(l_workflow_type),
12070: p_parameterlist => l_parameter_list);
12071: Wf_Event.AddParameterToList(p_name =>'REQUESTOR',
12072: p_value =>FND_GLOBAL.USER_NAME ,
12073: p_parameterlist => l_parameter_list);
12074: Wf_Core.Context('Enterprise Asset Management...','Work Order Staus Changed Event','Raising event');
12075:
12076: Wf_Event.Raise( p_event_name => l_event_name,

Line 12091: p_last_updated_by => FND_GLOBAL.user_id,

12087: p_event => 'UPDATE',
12088: p_wip_entity_id =>l_eam_wo_comp_rec.wip_entity_id,
12089: p_organization_id =>l_eam_wo_comp_rec.organization_id,
12090: p_last_update_date => SYSDATE,
12091: p_last_updated_by => FND_GLOBAL.user_id,
12092: p_last_update_login =>FND_GLOBAL.login_id
12093: );
12094: END IF; --end of check for EAM workorders
12095:

Line 12092: p_last_update_login =>FND_GLOBAL.login_id

12088: p_wip_entity_id =>l_eam_wo_comp_rec.wip_entity_id,
12089: p_organization_id =>l_eam_wo_comp_rec.organization_id,
12090: p_last_update_date => SYSDATE,
12091: p_last_updated_by => FND_GLOBAL.user_id,
12092: p_last_update_login =>FND_GLOBAL.login_id
12093: );
12094: END IF; --end of check for EAM workorders
12095:
12096:

Line 12672: p_value =>FND_GLOBAL.USER_NAME ,

12668: Wf_Event.AddParameterToList(p_name =>'WORKFLOW_TYPE',
12669: p_value => TO_CHAR(l_workflow_type),
12670: p_parameterlist => l_parameter_list);
12671: Wf_Event.AddParameterToList(p_name =>'REQUESTOR',
12672: p_value =>FND_GLOBAL.USER_NAME ,
12673: p_parameterlist => l_parameter_list);
12674:
12675: Wf_Event.Raise( p_event_name => l_op_completed_event,
12676: p_event_key => l_event_key,