APPS.WIP_WS_TIME_ENTRY dependencies on WIP_RESOURCE_ACTUAL_TIMES_S

Line 65: select WIP_RESOURCE_ACTUAL_TIMES_S.nextval into l_time_entry_id from dual;

61: l_uom_code := fnd_profile.value('BOM:HOUR_UOM_CODE');
62: l_return_status := 'U';
63:
64: if p_time_entry_id is null then
65: select WIP_RESOURCE_ACTUAL_TIMES_S.nextval into l_time_entry_id from dual;
66: else
67: l_time_entry_id := p_time_entry_id;
68: end if;
69:

Line 346: update wip_resource_actual_times set

342: l_projected_completion_date := p_projected_completion_date;
343: end if;
344:
345: if l_object_version_num = p_object_version_num then
346: update wip_resource_actual_times set
347: organization_id = p_organization_id,
348: wip_entity_id = p_wip_entity_id,
349: operation_seq_num = p_operation_seq_num,
350: resource_id = p_resource_id,

Line 438: update wip_resource_actual_times set

434: if delete_cursor%NOTFOUND then
435: l_return_status := 'U';
436: else
437: if l_object_version_num = p_object_version_num then
438: update wip_resource_actual_times set
439: process_status = l_process_status,
440: object_version_number = p_object_version_num + 1,
441: last_update_date = sysdate,
442: last_updated_by = fnd_global.user_id,

Line 505: update wip_resource_actual_times set

501: l_start_date;
502: if delete_cursor%NOTFOUND then
503: l_return_status := 'U';
504: else
505: update wip_resource_actual_times set
506: process_status = l_process_status,
507: object_version_number = l_object_version_num + 1,
508: last_update_date = sysdate,
509: last_updated_by = fnd_global.user_id,

Line 1269: update wip_resource_actual_times set

1265: and status_type = 1
1266: and process_status = 4;
1267:
1268: /* reset process_status of records of inserted/updated - mark as completed */
1269: update wip_resource_actual_times set
1270: process_status = l_completed_process_status,
1271: last_update_date = sysdate,
1272: last_updated_by = fnd_global.user_id,
1273: last_update_login = fnd_global.login_id

Line 1852: (WIP_RESOURCE_ACTUAL_TIMES_S.nextval,p_org_id,

1848: LAST_UPDATE_LOGIN,OBJECT_VERSION_NUMBER,
1849: ACTION_FLAG,REQUEST_ID,PROGRAM_ID,
1850: PROGRAM_APPLICATION_ID,PROGRAM_UPDATE_DATE)
1851: values
1852: (WIP_RESOURCE_ACTUAL_TIMES_S.nextval,p_org_id,
1853: null,null,null,null,null,null,8,'N','N',null,
1854: sysdate,null,null,null,
1855: fnd_profile.value('BOM:HOUR_UOM_CODE'),
1856: l_person_id,1,fnd_global.user_id,

Line 1913: update wip_resource_actual_times set

1909: else
1910: l_date := sysdate;
1911: l_duration := (l_date - l_start_date)*24;
1912:
1913: update wip_resource_actual_times set
1914: end_date = l_date,
1915: duration = l_duration
1916: where ORGANIZATION_ID=p_org_id
1917: and employee_id =l_person_id

Line 2027: (WIP_RESOURCE_ACTUAL_TIMES_S.nextval,p_org_id,

2023: LAST_UPDATE_LOGIN,OBJECT_VERSION_NUMBER,
2024: ACTION_FLAG,REQUEST_ID,PROGRAM_ID,
2025: PROGRAM_APPLICATION_ID,PROGRAM_UPDATE_DATE)
2026: values
2027: (WIP_RESOURCE_ACTUAL_TIMES_S.nextval,p_org_id,
2028: null,null,null,null,null,null,8,'N','N',null,
2029: sysdate,null,null,null,
2030: fnd_profile.value('BOM:HOUR_UOM_CODE'),
2031: p_wip_employee_id,1,fnd_global.user_id,

Line 2083: update wip_resource_actual_times set

2079: else
2080: l_date := sysdate;
2081: l_duration := (l_date - l_start_date)*24;
2082:
2083: update wip_resource_actual_times set
2084: end_date = l_date,
2085: duration = l_duration
2086: where ORGANIZATION_ID=p_org_id
2087: and employee_id =p_wip_employee_id

Line 2419: update wip_resource_actual_times set

2415: l_clock_status := 'O';
2416: else
2417: l_date := sysdate;
2418: l_duration := (l_date - l_start_date)*24;
2419: update wip_resource_actual_times set
2420: end_date = l_date,
2421: duration = l_duration,
2422: uom_code = l_uom_code,
2423: process_status = l_process_status,