DBA Data[Home] [Help]

APPS.EAM_WORKORDERTRANSACTIONS_PUB dependencies on FND_GLOBAL

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

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

Line 1143: , last_updated_by = FND_GLOBAL.user_id

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

Line 1144: , last_update_login = FND_GLOBAL.login_id

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

Line 1232: p_last_updated_by => FND_GLOBAL.user_id,

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

Line 1233: p_last_update_login =>FND_GLOBAL.login_id

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