APPS.WIP_WS_TIME_ENTRY dependencies on WIP_RESOURCE_ACTUAL_TIMES_S

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

121: l_uom_code := fnd_profile.value('BOM:HOUR_UOM_CODE');
122: l_return_status := 'U';
123:
124: if p_time_entry_id is null then
125: select WIP_RESOURCE_ACTUAL_TIMES_S.nextval into l_time_entry_id from dual;
126: else
127: l_time_entry_id := p_time_entry_id;
128: end if;
129:

Line 435: update wip_resource_actual_times set

431: if l_object_version_num = p_object_version_num then
432: if(l_logLevel <= wip_constants.full_logging) then
433: wip_logger.log('updating wip_resource_actual_times', l_return_status);
434: end if;
435: update wip_resource_actual_times set
436: organization_id = p_organization_id,
437: wip_entity_id = p_wip_entity_id,
438: operation_seq_num = p_operation_seq_num,
439: resource_id = p_resource_id,

Line 560: update wip_resource_actual_times set

556: if l_object_version_num = p_object_version_num then
557: if(l_logLevel <= wip_constants.full_logging) then
558: wip_logger.log('updating wip_resource_actual_times', l_return_status);
559: end if;
560: update wip_resource_actual_times set
561: process_status = l_process_status,
562: object_version_number = p_object_version_num + 1,
563: last_update_date = sysdate,
564: last_updated_by = fnd_global.user_id,

Line 662: update wip_resource_actual_times set

658: else
659: if(l_logLevel <= wip_constants.full_logging) then
660: wip_logger.log('updating wip_resource_actual_times', l_return_status);
661: end if;
662: update wip_resource_actual_times set
663: process_status = l_process_status,
664: object_version_number = l_object_version_num + 1,
665: last_update_date = sysdate,
666: last_updated_by = fnd_global.user_id,

Line 1556: update wip_resource_actual_times set

1552: and status_type = 1
1553: and process_status = 4;
1554:
1555: /* reset process_status of records of inserted/updated - mark as completed */
1556: update wip_resource_actual_times set
1557: process_status = l_completed_process_status,
1558: last_update_date = sysdate,
1559: last_updated_by = fnd_global.user_id,
1560: last_update_login = fnd_global.login_id

Line 2346: (WIP_RESOURCE_ACTUAL_TIMES_S.nextval,p_org_id,

2342: LAST_UPDATE_LOGIN,OBJECT_VERSION_NUMBER,
2343: ACTION_FLAG,REQUEST_ID,PROGRAM_ID,
2344: PROGRAM_APPLICATION_ID,PROGRAM_UPDATE_DATE)
2345: values
2346: (WIP_RESOURCE_ACTUAL_TIMES_S.nextval,p_org_id,
2347: null,null,null,null,null,null,8,'N','N',null,
2348: sysdate,null,null,null,
2349: fnd_profile.value('BOM:HOUR_UOM_CODE'),
2350: l_person_id,1,fnd_global.user_id,

Line 2425: update wip_resource_actual_times set

2421: else
2422: l_date := sysdate;
2423: l_duration := (l_date - l_start_date)*24;
2424:
2425: update wip_resource_actual_times set
2426: end_date = l_date,
2427: duration = l_duration
2428: where ORGANIZATION_ID=p_org_id
2429: and employee_id =l_person_id

Line 2579: (WIP_RESOURCE_ACTUAL_TIMES_S.nextval,p_org_id,

2575: LAST_UPDATE_LOGIN,OBJECT_VERSION_NUMBER,
2576: ACTION_FLAG,REQUEST_ID,PROGRAM_ID,
2577: PROGRAM_APPLICATION_ID,PROGRAM_UPDATE_DATE)
2578: values
2579: (WIP_RESOURCE_ACTUAL_TIMES_S.nextval,p_org_id,
2580: null,null,null,null,null,null,8,'N','N',null,
2581: sysdate,null,null,null,
2582: fnd_profile.value('BOM:HOUR_UOM_CODE'),
2583: p_wip_employee_id,1,fnd_global.user_id,

Line 2653: update wip_resource_actual_times set

2649: else
2650: l_date := sysdate;
2651: l_duration := (l_date - l_start_date)*24;
2652:
2653: update wip_resource_actual_times set
2654: end_date = l_date,
2655: duration = l_duration
2656: where ORGANIZATION_ID=p_org_id
2657: and employee_id =p_wip_employee_id

Line 3106: update wip_resource_actual_times set

3102: wip_logger.log('updating wip_resource_actual_times', x_status);
3103: end if;
3104: l_date := sysdate;
3105: l_duration := (l_date - l_start_date)*24;
3106: update wip_resource_actual_times set
3107: end_date = l_date,
3108: duration = l_duration,
3109: uom_code = l_uom_code,
3110: process_status = l_process_status,