DBA Data[Home] [Help]

APPS.EAM_WORKORDERTRANSACTIONS_PUB dependencies on FND_GLOBAL

Line 385: p_user_id IN NUMBER := fnd_global.user_id,

381: p_wip_entity_id IN NUMBER,
382: p_transaction_type IN NUMBER,
383: p_transaction_date IN DATE,
384: p_instance_id IN NUMBER := null,
385: p_user_id IN NUMBER := fnd_global.user_id,
386: p_request_id IN NUMBER := null,
387: p_application_id IN NUMBER := null,
388: p_program_id IN NUMBER := null,
389: p_reconciliation_code IN VARCHAR2 := null,

Line 1145: , last_updated_by = FND_GLOBAL.user_id

1141: update eam_work_order_details
1142: SET user_defined_status_id = p_new_status
1143: , program_update_date = SYSDATE
1144: , last_update_date = SYSDATE
1145: , last_updated_by = FND_GLOBAL.user_id
1146: , last_update_login = FND_GLOBAL.login_id
1147: WHERE organization_id = p_organization_id
1148: AND WIP_ENTITY_ID IN (SELECT wdct.WIP_ENTITY_ID
1149: FROM WIP_DJ_CLOSE_TEMP wdct, wip_discrete_jobs wdj

Line 1146: , last_update_login = FND_GLOBAL.login_id

1142: SET user_defined_status_id = p_new_status
1143: , program_update_date = SYSDATE
1144: , last_update_date = SYSDATE
1145: , last_updated_by = FND_GLOBAL.user_id
1146: , last_update_login = FND_GLOBAL.login_id
1147: WHERE organization_id = p_organization_id
1148: AND WIP_ENTITY_ID IN (SELECT wdct.WIP_ENTITY_ID
1149: FROM WIP_DJ_CLOSE_TEMP wdct, wip_discrete_jobs wdj
1150: WHERE wdct.ORGANIZATION_ID = p_organization_id

Line 1234: p_last_updated_by => FND_GLOBAL.user_id,

1230: p_event => 'UPDATE',
1231: p_wip_entity_id =>l_workorders_rec.wip_entity_id,
1232: p_organization_id =>l_workorders_rec.organization_id,
1233: p_last_update_date => SYSDATE,
1234: p_last_updated_by => FND_GLOBAL.user_id,
1235: p_last_update_login =>FND_GLOBAL.login_id
1236: );
1237:
1238:

Line 1235: p_last_update_login =>FND_GLOBAL.login_id

1231: p_wip_entity_id =>l_workorders_rec.wip_entity_id,
1232: p_organization_id =>l_workorders_rec.organization_id,
1233: p_last_update_date => SYSDATE,
1234: p_last_updated_by => FND_GLOBAL.user_id,
1235: p_last_update_login =>FND_GLOBAL.login_id
1236: );
1237:
1238:
1239: END LOOP;