DBA Data[Home] [Help]

APPS.WIP_WS_TIME_ENTRY dependencies on FND_GLOBAL

Line 220: fnd_global.user_id,

216: p_resource_id,
217: p_resource_seq_num,
218: p_instance_id,
219: p_serial_number,
220: fnd_global.user_id,
221: sysdate,
222: fnd_global.user_id,
223: sysdate,
224: fnd_global.login_id,

Line 222: fnd_global.user_id,

218: p_instance_id,
219: p_serial_number,
220: fnd_global.user_id,
221: sysdate,
222: fnd_global.user_id,
223: sysdate,
224: fnd_global.login_id,
225: l_object_version_num,
226: l_time_entry_mode,

Line 224: fnd_global.login_id,

220: fnd_global.user_id,
221: sysdate,
222: fnd_global.user_id,
223: sysdate,
224: fnd_global.login_id,
225: l_object_version_num,
226: l_time_entry_mode,
227: p_cost_flag,
228: p_add_to_rtg,

Line 458: last_updated_by = fnd_global.user_id,

454: employee_id = p_employee_id,
455: process_status = l_process_status,
456: object_version_number = p_object_version_num + 1,
457: last_update_date = sysdate,
458: last_updated_by = fnd_global.user_id,
459: last_update_login = fnd_global.login_id
460: where time_entry_id = p_time_entry_id;
461:
462: if p_start_date is not null and l_start_date <> p_start_date then

Line 459: last_update_login = fnd_global.login_id

455: process_status = l_process_status,
456: object_version_number = p_object_version_num + 1,
457: last_update_date = sysdate,
458: last_updated_by = fnd_global.user_id,
459: last_update_login = fnd_global.login_id
460: where time_entry_id = p_time_entry_id;
461:
462: if p_start_date is not null and l_start_date <> p_start_date then
463: if(l_logLevel <= wip_constants.full_logging) then

Line 564: last_updated_by = fnd_global.user_id,

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,
565: last_update_login = fnd_global.login_id
566: where time_entry_id = p_time_entry_id
567: and process_status <> 4;
568:

Line 565: last_update_login = fnd_global.login_id

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,
565: last_update_login = fnd_global.login_id
566: where time_entry_id = p_time_entry_id
567: and process_status <> 4;
568:
569: if(l_logLevel <= wip_constants.full_logging) then

Line 666: last_updated_by = fnd_global.user_id,

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,
667: last_update_login = fnd_global.login_id
668: where wip_entity_id = p_wip_entity_id
669: and operation_seq_num = p_operation_seq_num
670: and employee_id = p_employee_id

Line 667: last_update_login = fnd_global.login_id

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,
667: last_update_login = fnd_global.login_id
668: where wip_entity_id = p_wip_entity_id
669: and operation_seq_num = p_operation_seq_num
670: and employee_id = p_employee_id
671: and process_status <> 4;

Line 778: last_updated_by = fnd_global.user_id,

774: uom_code = l_uom_code,
775: process_status = '3',
776: object_version_number = object_version_number + 1,
777: last_update_date = l_date,
778: last_updated_by = fnd_global.user_id,
779: last_update_login = fnd_global.login_id
780: where wip_entity_id = p_wip_entity_id
781: and operation_seq_num = p_operation_seq_num
782: and process_status <> 4

Line 779: last_update_login = fnd_global.login_id

775: process_status = '3',
776: object_version_number = object_version_number + 1,
777: last_update_date = l_date,
778: last_updated_by = fnd_global.user_id,
779: last_update_login = fnd_global.login_id
780: where wip_entity_id = p_wip_entity_id
781: and operation_seq_num = p_operation_seq_num
782: and process_status <> 4
783: and status_type = 1

Line 891: last_updated_by = fnd_global.user_id,

887: uom_code = l_uom_code,
888: process_status = '3',
889: object_version_number = object_version_number + 1,
890: last_update_date = sysdate,
891: last_updated_by = fnd_global.user_id,
892: last_update_login = fnd_global.login_id
893: where wip_entity_id = p_wip_entity_id
894: and operation_seq_num = p_operation_seq_num
895: and status_type = 1

Line 892: last_update_login = fnd_global.login_id

888: process_status = '3',
889: object_version_number = object_version_number + 1,
890: last_update_date = sysdate,
891: last_updated_by = fnd_global.user_id,
892: last_update_login = fnd_global.login_id
893: where wip_entity_id = p_wip_entity_id
894: and operation_seq_num = p_operation_seq_num
895: and status_type = 1
896: and start_date is not null

Line 928: last_updated_by = fnd_global.user_id,

924: duration = (l_date - start_date)*24,
925: process_status = '3',
926: object_version_number = object_version_number + 1,
927: last_update_date = sysdate,
928: last_updated_by = fnd_global.user_id,
929: last_update_login = fnd_global.login_id
930: where wip_entity_id = p_wip_entity_id
931: and operation_seq_num = p_operation_seq_num
932: and status_type = 1

Line 929: last_update_login = fnd_global.login_id

925: process_status = '3',
926: object_version_number = object_version_number + 1,
927: last_update_date = sysdate,
928: last_updated_by = fnd_global.user_id,
929: last_update_login = fnd_global.login_id
930: where wip_entity_id = p_wip_entity_id
931: and operation_seq_num = p_operation_seq_num
932: and status_type = 1
933: and start_date is not null

Line 964: last_updated_by = fnd_global.user_id,

960: duration = (l_date - start_date)*24,
961: process_status = '3',
962: object_version_number = object_version_number + 1,
963: last_update_date = sysdate,
964: last_updated_by = fnd_global.user_id,
965: last_update_login = fnd_global.login_id
966: where wip_entity_id = p_wip_entity_id
967: and operation_seq_num = p_operation_seq_num
968: and status_type = 1

Line 965: last_update_login = fnd_global.login_id

961: process_status = '3',
962: object_version_number = object_version_number + 1,
963: last_update_date = sysdate,
964: last_updated_by = fnd_global.user_id,
965: last_update_login = fnd_global.login_id
966: where wip_entity_id = p_wip_entity_id
967: and operation_seq_num = p_operation_seq_num
968: and status_type = 1
969: and start_date is not null

Line 1474: last_updated_by = fnd_global.user_id,

1470: add_to_rtg = l_add_to_rtg,
1471: resource_seq_num = l_resource_seq_num,
1472: object_version_number = l_object_version_num + 1,
1473: last_update_date = sysdate,
1474: last_updated_by = fnd_global.user_id,
1475: last_update_login = fnd_global.login_id
1476: where time_entry_id = l_entry_id;
1477: end if;
1478: end if;

Line 1475: last_update_login = fnd_global.login_id

1471: resource_seq_num = l_resource_seq_num,
1472: object_version_number = l_object_version_num + 1,
1473: last_update_date = sysdate,
1474: last_updated_by = fnd_global.user_id,
1475: last_update_login = fnd_global.login_id
1476: where time_entry_id = l_entry_id;
1477: end if;
1478: end if;
1479:

Line 1513: last_updated_by = fnd_global.user_id,

1509: status_type = l_completed_status_type,
1510: process_status = l_completed_process_status,
1511: object_version_number = l_object_version_num + 1,
1512: last_update_date = sysdate,
1513: last_updated_by = fnd_global.user_id,
1514: last_update_login = fnd_global.login_id
1515: where time_entry_id = l_entry_id;
1516:
1517: end if;

Line 1514: last_update_login = fnd_global.login_id

1510: process_status = l_completed_process_status,
1511: object_version_number = l_object_version_num + 1,
1512: last_update_date = sysdate,
1513: last_updated_by = fnd_global.user_id,
1514: last_update_login = fnd_global.login_id
1515: where time_entry_id = l_entry_id;
1516:
1517: end if;
1518: end loop;

Line 1559: last_updated_by = fnd_global.user_id,

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
1561: where wip_entity_id = p_wip_entity_id
1562: and operation_seq_num = p_completed_op
1563: and status_type = 1

Line 1560: last_update_login = fnd_global.login_id

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
1561: where wip_entity_id = p_wip_entity_id
1562: and operation_seq_num = p_completed_op
1563: and status_type = 1
1564: and process_status in (2,3);

Line 2350: l_person_id,1,fnd_global.user_id,

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,
2351: sysdate,fnd_global.user_id,sysdate,
2352: fnd_global.login_id,1,null,null,null,
2353: null,null);
2354:

Line 2351: sysdate,fnd_global.user_id,sysdate,

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,
2351: sysdate,fnd_global.user_id,sysdate,
2352: fnd_global.login_id,1,null,null,null,
2353: null,null);
2354:
2355: l_shift_status := 'S';

Line 2352: fnd_global.login_id,1,null,null,null,

2348: sysdate,null,null,null,
2349: fnd_profile.value('BOM:HOUR_UOM_CODE'),
2350: l_person_id,1,fnd_global.user_id,
2351: sysdate,fnd_global.user_id,sysdate,
2352: fnd_global.login_id,1,null,null,null,
2353: null,null);
2354:
2355: l_shift_status := 'S';
2356: END IF;

Line 2583: p_wip_employee_id,1,fnd_global.user_id,

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,
2584: sysdate,fnd_global.user_id,sysdate,
2585: fnd_global.login_id,1,null,null,null,
2586: null,null);
2587: l_shift_status := 'S';

Line 2584: sysdate,fnd_global.user_id,sysdate,

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,
2584: sysdate,fnd_global.user_id,sysdate,
2585: fnd_global.login_id,1,null,null,null,
2586: null,null);
2587: l_shift_status := 'S';
2588: END IF;

Line 2585: fnd_global.login_id,1,null,null,null,

2581: sysdate,null,null,null,
2582: fnd_profile.value('BOM:HOUR_UOM_CODE'),
2583: p_wip_employee_id,1,fnd_global.user_id,
2584: sysdate,fnd_global.user_id,sysdate,
2585: fnd_global.login_id,1,null,null,null,
2586: null,null);
2587: l_shift_status := 'S';
2588: END IF;
2589: CLOSE shift_in_cursor;

Line 3113: last_updated_by = fnd_global.user_id,

3109: uom_code = l_uom_code,
3110: process_status = l_process_status,
3111: object_version_number = l_object_version_num + 1,
3112: last_update_date = l_date,
3113: last_updated_by = fnd_global.user_id,
3114: last_update_login = fnd_global.login_id
3115: where wip_entity_id = p_wip_entity_id
3116: and operation_seq_num = p_operation_seq_num
3117: and resource_id = p_resource_id

Line 3114: last_update_login = fnd_global.login_id

3110: process_status = l_process_status,
3111: object_version_number = l_object_version_num + 1,
3112: last_update_date = l_date,
3113: last_updated_by = fnd_global.user_id,
3114: last_update_login = fnd_global.login_id
3115: where wip_entity_id = p_wip_entity_id
3116: and operation_seq_num = p_operation_seq_num
3117: and resource_id = p_resource_id
3118: /*Fix Bug 9721473, remove the filtering on resouce_seq_num from update statement so that

Line 3770: fnd_global.user_id,

3766: activity_id,
3767: activity_name) --Bug 10097774
3768: values(
3769: x_group_id, -- Bug 13481688
3770: fnd_global.user_id,
3771: fnd_global.user_name,
3772: sysdate,
3773: fnd_global.user_id,
3774: fnd_global.user_name,

Line 3771: fnd_global.user_name,

3767: activity_name) --Bug 10097774
3768: values(
3769: x_group_id, -- Bug 13481688
3770: fnd_global.user_id,
3771: fnd_global.user_name,
3772: sysdate,
3773: fnd_global.user_id,
3774: fnd_global.user_name,
3775: sysdate,

Line 3773: fnd_global.user_id,

3769: x_group_id, -- Bug 13481688
3770: fnd_global.user_id,
3771: fnd_global.user_name,
3772: sysdate,
3773: fnd_global.user_id,
3774: fnd_global.user_name,
3775: sysdate,
3776: fnd_global.login_id,
3777: p_operation_seq_num,

Line 3774: fnd_global.user_name,

3770: fnd_global.user_id,
3771: fnd_global.user_name,
3772: sysdate,
3773: fnd_global.user_id,
3774: fnd_global.user_name,
3775: sysdate,
3776: fnd_global.login_id,
3777: p_operation_seq_num,
3778: l_organization_code,

Line 3776: fnd_global.login_id,

3772: sysdate,
3773: fnd_global.user_id,
3774: fnd_global.user_name,
3775: sysdate,
3776: fnd_global.login_id,
3777: p_operation_seq_num,
3778: l_organization_code,
3779: p_organization_id,
3780: --WIP_CONSTANTS.RES_VAL,