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 1230: last_update_login=FND_GLOBAL.login_id,

1226: UPDATE EAM_WORK_ORDER_DETAILS
1227: SET user_defined_status_id=3,
1228: pending_flag='Y',
1229: last_update_date=SYSDATE,
1230: last_update_login=FND_GLOBAL.login_id,
1231: last_updated_by=FND_GLOBAL.user_id
1232: WHERE wip_entity_id= x_wip_entity_id;
1233:
1234:

Line 1231: last_updated_by=FND_GLOBAL.user_id

1227: SET user_defined_status_id=3,
1228: pending_flag='Y',
1229: last_update_date=SYSDATE,
1230: last_update_login=FND_GLOBAL.login_id,
1231: last_updated_by=FND_GLOBAL.user_id
1232: WHERE wip_entity_id= x_wip_entity_id;
1233:
1234:
1235:

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

1259: INSERT INTO EAM_WO_WORKFLOWS
1260: (WIP_ENTITY_ID,WF_ITEM_TYPE,WF_ITEM_KEY,LAST_UPDATE_DATE,LAST_UPDATED_BY,
1261: CREATION_DATE,CREATED_BY,LAST_UPDATE_LOGIN)
1262: VALUES
1263: (x_wip_entity_id,l_workflow_name,l_event_key,SYSDATE,FND_GLOBAL.user_id,
1264: SYSDATE,FND_GLOBAL.user_id,FND_GLOBAL.login_id
1265: );
1266:
1267:

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

1260: (WIP_ENTITY_ID,WF_ITEM_TYPE,WF_ITEM_KEY,LAST_UPDATE_DATE,LAST_UPDATED_BY,
1261: CREATION_DATE,CREATED_BY,LAST_UPDATE_LOGIN)
1262: VALUES
1263: (x_wip_entity_id,l_workflow_name,l_event_key,SYSDATE,FND_GLOBAL.user_id,
1264: SYSDATE,FND_GLOBAL.user_id,FND_GLOBAL.login_id
1265: );
1266:
1267:
1268: -- Add Parameters

Line 1294: p_value =>FND_GLOBAL.USER_NAME ,

1290: Wf_Event.AddParameterToList(p_name =>'WORKFLOW_TYPE',
1291: p_value => TO_CHAR(l_workflow_type),
1292: p_parameterlist => l_parameter_list);
1293: Wf_Event.AddParameterToList(p_name =>'REQUESTOR',
1294: p_value =>FND_GLOBAL.USER_NAME ,
1295: p_parameterlist => l_parameter_list);
1296: Wf_Event.AddParameterToList(p_name =>'WORKFLOW_NAME',
1297: p_value => l_workflow_name,
1298: p_parameterlist => l_parameter_list);

Line 1322: p_last_updated_by => FND_GLOBAL.user_id,

1318: p_event => 'UPDATE',
1319: p_wip_entity_id =>x_wip_entity_id,
1320: p_organization_id =>i_org_id,
1321: p_last_update_date => SYSDATE,
1322: p_last_updated_by => FND_GLOBAL.user_id,
1323: p_last_update_login =>FND_GLOBAL.login_id
1324: );
1325: END IF;
1326:

Line 1323: p_last_update_login =>FND_GLOBAL.login_id

1319: p_wip_entity_id =>x_wip_entity_id,
1320: p_organization_id =>i_org_id,
1321: p_last_update_date => SYSDATE,
1322: p_last_updated_by => FND_GLOBAL.user_id,
1323: p_last_update_login =>FND_GLOBAL.login_id
1324: );
1325: END IF;
1326:
1327: RETURN;

Line 1517: , last_updated_by = FND_GLOBAL.user_id

1513: Hence moved out of IF block mentioned above */
1514: UPDATE eam_asset_status_history
1515: SET enable_flag = 'N'
1516: , last_update_date = SYSDATE
1517: , last_updated_by = FND_GLOBAL.user_id
1518: , last_update_login = FND_GLOBAL.login_id
1519: WHERE organization_id = i_org_id
1520: AND wip_entity_id = x_wip_entity_id
1521: AND operation_seq_num IS NULL

Line 1518: , last_update_login = FND_GLOBAL.login_id

1514: UPDATE eam_asset_status_history
1515: SET enable_flag = 'N'
1516: , last_update_date = SYSDATE
1517: , last_updated_by = FND_GLOBAL.user_id
1518: , last_update_login = FND_GLOBAL.login_id
1519: WHERE organization_id = i_org_id
1520: AND wip_entity_id = x_wip_entity_id
1521: AND operation_seq_num IS NULL
1522: AND (enable_flag = 'Y' OR enable_flag IS null);

Line 1777: last_update_login = fnd_global.login_id

1773: update wip_eam_work_requests
1774: set work_request_status_id = i_work_request_status,
1775: last_update_date = sysdate,
1776: last_updated_by = x_user_id,
1777: last_update_login = fnd_global.login_id
1778: where wip_entity_id = x_wip_entity_id;
1779:
1780: l_statement := 105;
1781: x_statement := l_statement;

Line 1824: p_value =>FND_GLOBAL.USER_NAME ,

1820: Wf_Event.AddParameterToList(p_name =>'WORKFLOW_TYPE',
1821: p_value => TO_CHAR(l_workflow_type),
1822: p_parameterlist => l_parameter_list);
1823: Wf_Event.AddParameterToList(p_name =>'REQUESTOR',
1824: p_value =>FND_GLOBAL.USER_NAME ,
1825: p_parameterlist => l_parameter_list);
1826: Wf_Core.Context('Enterprise Asset Management...','Work Order Staus Changed Event','Raising event');
1827:
1828: Wf_Event.Raise( p_event_name => l_event_name,

Line 1844: p_last_updated_by => FND_GLOBAL.user_id,

1840: p_event => 'UPDATE',
1841: p_wip_entity_id =>x_wip_entity_id,
1842: p_organization_id =>i_org_id,
1843: p_last_update_date => SYSDATE,
1844: p_last_updated_by => FND_GLOBAL.user_id,
1845: p_last_update_login =>FND_GLOBAL.login_id
1846: );
1847:
1848: END IF; --end of check for EAM workorders

Line 1845: p_last_update_login =>FND_GLOBAL.login_id

1841: p_wip_entity_id =>x_wip_entity_id,
1842: p_organization_id =>i_org_id,
1843: p_last_update_date => SYSDATE,
1844: p_last_updated_by => FND_GLOBAL.user_id,
1845: p_last_update_login =>FND_GLOBAL.login_id
1846: );
1847:
1848: END IF; --end of check for EAM workorders
1849: