DBA Data[Home] [Help]

APPS.EAM_COMPLETION dependencies on FND_GLOBAL

Line 413: , last_updated_by = FND_GLOBAL.user_id

409: -- Enhancement Bug 3852846
410: UPDATE eam_asset_status_history
411: SET enable_flag = 'N'
412: , last_update_date = SYSDATE
413: , last_updated_by = FND_GLOBAL.user_id
414: , last_update_login = FND_GLOBAL.login_id
415: WHERE organization_id = s_organization_id
416: AND wip_entity_id = s_wip_entity_id
417: AND operation_seq_num IS NULL

Line 414: , last_update_login = FND_GLOBAL.login_id

410: UPDATE eam_asset_status_history
411: SET enable_flag = 'N'
412: , last_update_date = SYSDATE
413: , last_updated_by = FND_GLOBAL.user_id
414: , last_update_login = FND_GLOBAL.login_id
415: WHERE organization_id = s_organization_id
416: AND wip_entity_id = s_wip_entity_id
417: AND operation_seq_num IS NULL
418: AND (enable_flag is NULL OR enable_flag = 'Y');

Line 573: x_user_id IN NUMBER := fnd_global.user_id,

569: x_wip_entity_id IN NUMBER,
570: x_rebuild_jobs IN VARCHAR2,
571: x_transaction_type IN NUMBER,
572: x_transaction_date IN DATE,
573: x_user_id IN NUMBER := fnd_global.user_id,
574: x_request_id IN NUMBER := null,
575: x_application_id IN NUMBER := null,
576: x_program_id IN NUMBER := null,
577: x_reconcil_code IN VARCHAR2 := null,

Line 661: x_user_id IN NUMBER := fnd_global.user_id,

657: x_wip_entity_id IN NUMBER,
658: x_rebuild_jobs IN VARCHAR2,
659: x_transaction_type IN NUMBER,
660: x_transaction_date IN DATE,
661: x_user_id IN NUMBER := fnd_global.user_id,
662: x_request_id IN NUMBER := null,
663: x_application_id IN NUMBER := null,
664: x_program_id IN NUMBER := null,
665: x_reconcil_code IN VARCHAR2 := null,

Line 752: x_user_id IN NUMBER := fnd_global.user_id,

748: x_wip_entity_id IN NUMBER,
749: x_rebuild_jobs IN VARCHAR2,
750: x_transaction_type IN NUMBER,
751: x_transaction_date IN DATE,
752: x_user_id IN NUMBER := fnd_global.user_id,
753: x_request_id IN NUMBER := null,
754: x_application_id IN NUMBER := null,
755: x_program_id IN NUMBER := null,
756: x_reconcil_code IN VARCHAR2 := null,

Line 879: x_user_id IN NUMBER := fnd_global.user_id,

875: x_wip_entity_id IN NUMBER,
876: x_rebuild_jobs IN VARCHAR2,
877: x_transaction_type IN NUMBER,
878: x_transaction_date IN DATE,
879: x_user_id IN NUMBER := fnd_global.user_id,
880: x_request_id IN NUMBER := null,
881: x_application_id IN NUMBER := null,
882: x_program_id IN NUMBER := null,
883: x_reconcil_code IN VARCHAR2 := null,

Line 1189: last_update_login=FND_GLOBAL.login_id,

1185: UPDATE EAM_WORK_ORDER_DETAILS
1186: SET user_defined_status_id=3,
1187: pending_flag='Y',
1188: last_update_date=SYSDATE,
1189: last_update_login=FND_GLOBAL.login_id,
1190: last_updated_by=FND_GLOBAL.user_id
1191: WHERE wip_entity_id= x_wip_entity_id;
1192:
1193:

Line 1190: last_updated_by=FND_GLOBAL.user_id

1186: SET user_defined_status_id=3,
1187: pending_flag='Y',
1188: last_update_date=SYSDATE,
1189: last_update_login=FND_GLOBAL.login_id,
1190: last_updated_by=FND_GLOBAL.user_id
1191: WHERE wip_entity_id= x_wip_entity_id;
1192:
1193:
1194:

Line 1222: (x_wip_entity_id,l_workflow_name,l_event_key,SYSDATE,FND_GLOBAL.user_id,

1218: INSERT INTO EAM_WO_WORKFLOWS
1219: (WIP_ENTITY_ID,WF_ITEM_TYPE,WF_ITEM_KEY,LAST_UPDATE_DATE,LAST_UPDATED_BY,
1220: CREATION_DATE,CREATED_BY,LAST_UPDATE_LOGIN)
1221: VALUES
1222: (x_wip_entity_id,l_workflow_name,l_event_key,SYSDATE,FND_GLOBAL.user_id,
1223: SYSDATE,FND_GLOBAL.user_id,FND_GLOBAL.login_id
1224: );
1225:
1226:

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

1219: (WIP_ENTITY_ID,WF_ITEM_TYPE,WF_ITEM_KEY,LAST_UPDATE_DATE,LAST_UPDATED_BY,
1220: CREATION_DATE,CREATED_BY,LAST_UPDATE_LOGIN)
1221: VALUES
1222: (x_wip_entity_id,l_workflow_name,l_event_key,SYSDATE,FND_GLOBAL.user_id,
1223: SYSDATE,FND_GLOBAL.user_id,FND_GLOBAL.login_id
1224: );
1225:
1226:
1227: -- Add Parameters

Line 1253: p_value =>FND_GLOBAL.USER_NAME ,

1249: Wf_Event.AddParameterToList(p_name =>'WORKFLOW_TYPE',
1250: p_value => TO_CHAR(l_workflow_type),
1251: p_parameterlist => l_parameter_list);
1252: Wf_Event.AddParameterToList(p_name =>'REQUESTOR',
1253: p_value =>FND_GLOBAL.USER_NAME ,
1254: p_parameterlist => l_parameter_list);
1255: Wf_Event.AddParameterToList(p_name =>'WORKFLOW_NAME',
1256: p_value => l_workflow_name,
1257: p_parameterlist => l_parameter_list);

Line 1281: p_last_updated_by => FND_GLOBAL.user_id,

1277: p_event => 'UPDATE',
1278: p_wip_entity_id =>x_wip_entity_id,
1279: p_organization_id =>i_org_id,
1280: p_last_update_date => SYSDATE,
1281: p_last_updated_by => FND_GLOBAL.user_id,
1282: p_last_update_login =>FND_GLOBAL.login_id
1283: );
1284: END IF;
1285:

Line 1282: p_last_update_login =>FND_GLOBAL.login_id

1278: p_wip_entity_id =>x_wip_entity_id,
1279: p_organization_id =>i_org_id,
1280: p_last_update_date => SYSDATE,
1281: p_last_updated_by => FND_GLOBAL.user_id,
1282: p_last_update_login =>FND_GLOBAL.login_id
1283: );
1284: END IF;
1285:
1286: RETURN;

Line 1471: , last_updated_by = FND_GLOBAL.user_id

1467: Hence moved out of IF block mentioned above */
1468: UPDATE eam_asset_status_history
1469: SET enable_flag = 'N'
1470: , last_update_date = SYSDATE
1471: , last_updated_by = FND_GLOBAL.user_id
1472: , last_update_login = FND_GLOBAL.login_id
1473: WHERE organization_id = i_org_id
1474: AND wip_entity_id = x_wip_entity_id
1475: AND operation_seq_num IS NULL

Line 1472: , last_update_login = FND_GLOBAL.login_id

1468: UPDATE eam_asset_status_history
1469: SET enable_flag = 'N'
1470: , last_update_date = SYSDATE
1471: , last_updated_by = FND_GLOBAL.user_id
1472: , last_update_login = FND_GLOBAL.login_id
1473: WHERE organization_id = i_org_id
1474: AND wip_entity_id = x_wip_entity_id
1475: AND operation_seq_num IS NULL
1476: AND (enable_flag = 'Y' OR enable_flag IS null);

Line 1730: last_update_login = fnd_global.login_id

1726: update wip_eam_work_requests
1727: set work_request_status_id = i_work_request_status,
1728: last_update_date = sysdate,
1729: last_updated_by = x_user_id,
1730: last_update_login = fnd_global.login_id
1731: where wip_entity_id = x_wip_entity_id;
1732:
1733: l_statement := 105;
1734: x_statement := l_statement;

Line 1777: p_value =>FND_GLOBAL.USER_NAME ,

1773: Wf_Event.AddParameterToList(p_name =>'WORKFLOW_TYPE',
1774: p_value => TO_CHAR(l_workflow_type),
1775: p_parameterlist => l_parameter_list);
1776: Wf_Event.AddParameterToList(p_name =>'REQUESTOR',
1777: p_value =>FND_GLOBAL.USER_NAME ,
1778: p_parameterlist => l_parameter_list);
1779: Wf_Core.Context('Enterprise Asset Management...','Work Order Staus Changed Event','Raising event');
1780:
1781: Wf_Event.Raise( p_event_name => l_event_name,

Line 1797: p_last_updated_by => FND_GLOBAL.user_id,

1793: p_event => 'UPDATE',
1794: p_wip_entity_id =>x_wip_entity_id,
1795: p_organization_id =>i_org_id,
1796: p_last_update_date => SYSDATE,
1797: p_last_updated_by => FND_GLOBAL.user_id,
1798: p_last_update_login =>FND_GLOBAL.login_id
1799: );
1800:
1801: END IF; --end of check for EAM workorders

Line 1798: p_last_update_login =>FND_GLOBAL.login_id

1794: p_wip_entity_id =>x_wip_entity_id,
1795: p_organization_id =>i_org_id,
1796: p_last_update_date => SYSDATE,
1797: p_last_updated_by => FND_GLOBAL.user_id,
1798: p_last_update_login =>FND_GLOBAL.login_id
1799: );
1800:
1801: END IF; --end of check for EAM workorders
1802: