DBA Data[Home] [Help]

APPS.WIP_WS_TIME_ENTRY dependencies on FND_GLOBAL

Line 147: fnd_global.user_id,

143: p_resource_id,
144: p_resource_seq_num,
145: p_instance_id,
146: p_serial_number,
147: fnd_global.user_id,
148: sysdate,
149: fnd_global.user_id,
150: sysdate,
151: fnd_global.login_id,

Line 149: fnd_global.user_id,

145: p_instance_id,
146: p_serial_number,
147: fnd_global.user_id,
148: sysdate,
149: fnd_global.user_id,
150: sysdate,
151: fnd_global.login_id,
152: l_object_version_num,
153: l_time_entry_mode,

Line 151: fnd_global.login_id,

147: fnd_global.user_id,
148: sysdate,
149: fnd_global.user_id,
150: sysdate,
151: fnd_global.login_id,
152: l_object_version_num,
153: l_time_entry_mode,
154: p_cost_flag,
155: p_add_to_rtg,

Line 236: (fnd_global.user_id,

232: wip_entity_name,
233: employee_id,
234: employee_num)
235: values
236: (fnd_global.user_id,
237: fnd_global.user_name,
238: sysdate,
239: fnd_global.user_id,
240: fnd_global.user_name,

Line 237: fnd_global.user_name,

233: employee_id,
234: employee_num)
235: values
236: (fnd_global.user_id,
237: fnd_global.user_name,
238: sysdate,
239: fnd_global.user_id,
240: fnd_global.user_name,
241: sysdate,

Line 239: fnd_global.user_id,

235: values
236: (fnd_global.user_id,
237: fnd_global.user_name,
238: sysdate,
239: fnd_global.user_id,
240: fnd_global.user_name,
241: sysdate,
242: fnd_global.login_id,
243: p_operation_seq_num,

Line 240: fnd_global.user_name,

236: (fnd_global.user_id,
237: fnd_global.user_name,
238: sysdate,
239: fnd_global.user_id,
240: fnd_global.user_name,
241: sysdate,
242: fnd_global.login_id,
243: p_operation_seq_num,
244: l_organization_code,

Line 242: fnd_global.login_id,

238: sysdate,
239: fnd_global.user_id,
240: fnd_global.user_name,
241: sysdate,
242: fnd_global.login_id,
243: p_operation_seq_num,
244: l_organization_code,
245: p_organization_id,
246: WIP_CONSTANTS.RES_VAL,

Line 369: last_updated_by = fnd_global.user_id,

365: employee_id = p_employee_id,
366: process_status = l_process_status,
367: object_version_number = p_object_version_num + 1,
368: last_update_date = sysdate,
369: last_updated_by = fnd_global.user_id,
370: last_update_login = fnd_global.login_id
371: where time_entry_id = p_time_entry_id;
372:
373: if p_start_date is not null and l_start_date <> p_start_date then

Line 370: last_update_login = fnd_global.login_id

366: process_status = l_process_status,
367: object_version_number = p_object_version_num + 1,
368: last_update_date = sysdate,
369: last_updated_by = fnd_global.user_id,
370: last_update_login = fnd_global.login_id
371: where time_entry_id = p_time_entry_id;
372:
373: if p_start_date is not null and l_start_date <> p_start_date then
374: update_actual_start_dates(p_wip_entity_id => p_wip_entity_id,

Line 442: last_updated_by = fnd_global.user_id,

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,
443: last_update_login = fnd_global.login_id
444: where time_entry_id = p_time_entry_id
445: and process_status <> 4;
446:

Line 443: last_update_login = fnd_global.login_id

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,
443: last_update_login = fnd_global.login_id
444: where time_entry_id = p_time_entry_id
445: and process_status <> 4;
446:
447: update_actual_start_dates(p_wip_entity_id => l_wip_entity_id,

Line 509: last_updated_by = fnd_global.user_id,

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,
510: last_update_login = fnd_global.login_id
511: where wip_entity_id = p_wip_entity_id
512: and operation_seq_num = p_operation_seq_num
513: and employee_id = p_employee_id

Line 510: last_update_login = fnd_global.login_id

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,
510: last_update_login = fnd_global.login_id
511: where wip_entity_id = p_wip_entity_id
512: and operation_seq_num = p_operation_seq_num
513: and employee_id = p_employee_id
514: and process_status <> 4;

Line 569: last_updated_by = fnd_global.user_id,

565: uom_code = l_uom_code,
566: process_status = '3',
567: object_version_number = object_version_number + 1,
568: last_update_date = l_date,
569: last_updated_by = fnd_global.user_id,
570: last_update_login = fnd_global.login_id
571: where wip_entity_id = p_wip_entity_id
572: and operation_seq_num = p_operation_seq_num
573: and process_status <> 4

Line 570: last_update_login = fnd_global.login_id

566: process_status = '3',
567: object_version_number = object_version_number + 1,
568: last_update_date = l_date,
569: last_updated_by = fnd_global.user_id,
570: last_update_login = fnd_global.login_id
571: where wip_entity_id = p_wip_entity_id
572: and operation_seq_num = p_operation_seq_num
573: and process_status <> 4
574: and status_type = 1

Line 660: last_updated_by = fnd_global.user_id,

656: uom_code = l_uom_code,
657: process_status = '3',
658: object_version_number = object_version_number + 1,
659: last_update_date = sysdate,
660: last_updated_by = fnd_global.user_id,
661: last_update_login = fnd_global.login_id
662: where wip_entity_id = p_wip_entity_id
663: and operation_seq_num = p_operation_seq_num
664: and status_type = 1

Line 661: last_update_login = fnd_global.login_id

657: process_status = '3',
658: object_version_number = object_version_number + 1,
659: last_update_date = sysdate,
660: last_updated_by = fnd_global.user_id,
661: last_update_login = fnd_global.login_id
662: where wip_entity_id = p_wip_entity_id
663: and operation_seq_num = p_operation_seq_num
664: and status_type = 1
665: and start_date is not null

Line 697: last_updated_by = fnd_global.user_id,

693: duration = (l_date - start_date)*24,
694: process_status = '3',
695: object_version_number = object_version_number + 1,
696: last_update_date = sysdate,
697: last_updated_by = fnd_global.user_id,
698: last_update_login = fnd_global.login_id
699: where wip_entity_id = p_wip_entity_id
700: and operation_seq_num = p_operation_seq_num
701: and status_type = 1

Line 698: last_update_login = fnd_global.login_id

694: process_status = '3',
695: object_version_number = object_version_number + 1,
696: last_update_date = sysdate,
697: last_updated_by = fnd_global.user_id,
698: last_update_login = fnd_global.login_id
699: where wip_entity_id = p_wip_entity_id
700: and operation_seq_num = p_operation_seq_num
701: and status_type = 1
702: and start_date is not null

Line 733: last_updated_by = fnd_global.user_id,

729: duration = (l_date - start_date)*24,
730: process_status = '3',
731: object_version_number = object_version_number + 1,
732: last_update_date = sysdate,
733: last_updated_by = fnd_global.user_id,
734: last_update_login = fnd_global.login_id
735: where wip_entity_id = p_wip_entity_id
736: and operation_seq_num = p_operation_seq_num
737: and status_type = 1

Line 734: last_update_login = fnd_global.login_id

730: process_status = '3',
731: object_version_number = object_version_number + 1,
732: last_update_date = sysdate,
733: last_updated_by = fnd_global.user_id,
734: last_update_login = fnd_global.login_id
735: where wip_entity_id = p_wip_entity_id
736: and operation_seq_num = p_operation_seq_num
737: and status_type = 1
738: and start_date is not null

Line 1132: last_updated_by = fnd_global.user_id,

1128: add_to_rtg = l_add_to_rtg,
1129: resource_seq_num = l_resource_seq_num,
1130: object_version_number = l_object_version_num + 1,
1131: last_update_date = sysdate,
1132: last_updated_by = fnd_global.user_id,
1133: last_update_login = fnd_global.login_id
1134: where time_entry_id = l_entry_id;
1135: end if;
1136: end if;

Line 1133: last_update_login = fnd_global.login_id

1129: resource_seq_num = l_resource_seq_num,
1130: object_version_number = l_object_version_num + 1,
1131: last_update_date = sysdate,
1132: last_updated_by = fnd_global.user_id,
1133: last_update_login = fnd_global.login_id
1134: where time_entry_id = l_entry_id;
1135: end if;
1136: end if;
1137:

Line 1209: fnd_global.user_id,

1205: wip_entity_name,
1206: employee_id,
1207: employee_num)
1208: values(
1209: fnd_global.user_id,
1210: fnd_global.user_name,
1211: sysdate,
1212: fnd_global.user_id,
1213: fnd_global.user_name,

Line 1210: fnd_global.user_name,

1206: employee_id,
1207: employee_num)
1208: values(
1209: fnd_global.user_id,
1210: fnd_global.user_name,
1211: sysdate,
1212: fnd_global.user_id,
1213: fnd_global.user_name,
1214: sysdate,

Line 1212: fnd_global.user_id,

1208: values(
1209: fnd_global.user_id,
1210: fnd_global.user_name,
1211: sysdate,
1212: fnd_global.user_id,
1213: fnd_global.user_name,
1214: sysdate,
1215: fnd_global.login_id,
1216: p_completed_op,

Line 1213: fnd_global.user_name,

1209: fnd_global.user_id,
1210: fnd_global.user_name,
1211: sysdate,
1212: fnd_global.user_id,
1213: fnd_global.user_name,
1214: sysdate,
1215: fnd_global.login_id,
1216: p_completed_op,
1217: l_organization_code,

Line 1215: fnd_global.login_id,

1211: sysdate,
1212: fnd_global.user_id,
1213: fnd_global.user_name,
1214: sysdate,
1215: fnd_global.login_id,
1216: p_completed_op,
1217: l_organization_code,
1218: l_org_id,
1219: WIP_CONSTANTS.RES_VAL,

Line 1245: last_updated_by = fnd_global.user_id,

1241: status_type = l_completed_status_type,
1242: process_status = l_completed_process_status,
1243: object_version_number = l_object_version_num + 1,
1244: last_update_date = sysdate,
1245: last_updated_by = fnd_global.user_id,
1246: last_update_login = fnd_global.login_id
1247: where time_entry_id = l_entry_id;
1248:
1249: end if;

Line 1246: last_update_login = fnd_global.login_id

1242: process_status = l_completed_process_status,
1243: object_version_number = l_object_version_num + 1,
1244: last_update_date = sysdate,
1245: last_updated_by = fnd_global.user_id,
1246: last_update_login = fnd_global.login_id
1247: where time_entry_id = l_entry_id;
1248:
1249: end if;
1250: end loop;

Line 1272: last_updated_by = fnd_global.user_id,

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
1274: where wip_entity_id = p_wip_entity_id
1275: and operation_seq_num = p_completed_op
1276: and status_type = 1

Line 1273: last_update_login = fnd_global.login_id

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
1274: where wip_entity_id = p_wip_entity_id
1275: and operation_seq_num = p_completed_op
1276: and status_type = 1
1277: and process_status in (2,3);

Line 1856: l_person_id,1,fnd_global.user_id,

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,
1857: sysdate,fnd_global.user_id,sysdate,
1858: fnd_global.login_id,1,null,null,null,
1859: null,null);
1860:

Line 1857: sysdate,fnd_global.user_id,sysdate,

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,
1857: sysdate,fnd_global.user_id,sysdate,
1858: fnd_global.login_id,1,null,null,null,
1859: null,null);
1860:
1861:

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

1854: sysdate,null,null,null,
1855: fnd_profile.value('BOM:HOUR_UOM_CODE'),
1856: l_person_id,1,fnd_global.user_id,
1857: sysdate,fnd_global.user_id,sysdate,
1858: fnd_global.login_id,1,null,null,null,
1859: null,null);
1860:
1861:
1862: l_shift_status := 'S';

Line 2031: p_wip_employee_id,1,fnd_global.user_id,

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,
2032: sysdate,fnd_global.user_id,sysdate,
2033: fnd_global.login_id,1,null,null,null,
2034: null,null);
2035:

Line 2032: sysdate,fnd_global.user_id,sysdate,

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,
2032: sysdate,fnd_global.user_id,sysdate,
2033: fnd_global.login_id,1,null,null,null,
2034: null,null);
2035:
2036:

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

2029: sysdate,null,null,null,
2030: fnd_profile.value('BOM:HOUR_UOM_CODE'),
2031: p_wip_employee_id,1,fnd_global.user_id,
2032: sysdate,fnd_global.user_id,sysdate,
2033: fnd_global.login_id,1,null,null,null,
2034: null,null);
2035:
2036:
2037: l_shift_status := 'S';

Line 2426: last_updated_by = fnd_global.user_id,

2422: uom_code = l_uom_code,
2423: process_status = l_process_status,
2424: object_version_number = l_object_version_num + 1,
2425: last_update_date = l_date,
2426: last_updated_by = fnd_global.user_id,
2427: last_update_login = fnd_global.login_id
2428: where wip_entity_id = p_wip_entity_id
2429: and operation_seq_num = p_operation_seq_num
2430: and resource_id = p_resource_id

Line 2427: last_update_login = fnd_global.login_id

2423: process_status = l_process_status,
2424: object_version_number = l_object_version_num + 1,
2425: last_update_date = l_date,
2426: last_updated_by = fnd_global.user_id,
2427: last_update_login = fnd_global.login_id
2428: where wip_entity_id = p_wip_entity_id
2429: and operation_seq_num = p_operation_seq_num
2430: and resource_id = p_resource_id
2431: and nvl(resource_seq_num, -1) = nvl(p_resource_seq_num, -1)