eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EAM_SCHED_BOTTOM_UP_PVT dependencies on FND_GLOBAL

Line 158: last_updated_by = FND_GLOBAL.user_id ,

154: UPDATE wip_operation_resources
155: SET start_date = l_res_start_date ,
156: completion_date = l_res_end_date ,
157: last_update_date = sysdate ,
158: last_updated_by = FND_GLOBAL.user_id ,
159: creation_date = sysdate ,
160: created_by = FND_GLOBAL.user_id ,
161: last_update_login = FND_GLOBAL.login_id
162: WHERE wip_entity_id = l_wip_id

Line 160: created_by = FND_GLOBAL.user_id ,

156: completion_date = l_res_end_date ,
157: last_update_date = sysdate ,
158: last_updated_by = FND_GLOBAL.user_id ,
159: creation_date = sysdate ,
160: created_by = FND_GLOBAL.user_id ,
161: last_update_login = FND_GLOBAL.login_id
162: WHERE wip_entity_id = l_wip_id
163: AND operation_seq_num = l_op_seq_num
164: AND resource_seq_num = l_res_seq_num;

Line 161: last_update_login = FND_GLOBAL.login_id

157: last_update_date = sysdate ,
158: last_updated_by = FND_GLOBAL.user_id ,
159: creation_date = sysdate ,
160: created_by = FND_GLOBAL.user_id ,
161: last_update_login = FND_GLOBAL.login_id
162: WHERE wip_entity_id = l_wip_id
163: AND operation_seq_num = l_op_seq_num
164: AND resource_seq_num = l_res_seq_num;
165:

Line 171: last_updated_by = FND_GLOBAL.user_id ,

167:
168: UPDATE wip_operation_resource_usage
169: SET start_date = l_res_start_date ,
170: last_update_date = sysdate ,
171: last_updated_by = FND_GLOBAL.user_id ,
172: creation_date = sysdate ,
173: created_by = FND_GLOBAL.user_id ,
174: last_update_login = FND_GLOBAL.login_id
175: WHERE wip_entity_id = l_wip_id

Line 173: created_by = FND_GLOBAL.user_id ,

169: SET start_date = l_res_start_date ,
170: last_update_date = sysdate ,
171: last_updated_by = FND_GLOBAL.user_id ,
172: creation_date = sysdate ,
173: created_by = FND_GLOBAL.user_id ,
174: last_update_login = FND_GLOBAL.login_id
175: WHERE wip_entity_id = l_wip_id
176: AND operation_seq_num = l_op_seq_num
177: AND resource_seq_num = l_res_seq_num

Line 174: last_update_login = FND_GLOBAL.login_id

170: last_update_date = sysdate ,
171: last_updated_by = FND_GLOBAL.user_id ,
172: creation_date = sysdate ,
173: created_by = FND_GLOBAL.user_id ,
174: last_update_login = FND_GLOBAL.login_id
175: WHERE wip_entity_id = l_wip_id
176: AND operation_seq_num = l_op_seq_num
177: AND resource_seq_num = l_res_seq_num
178: AND start_date = ( SELECT MIN(start_date)

Line 193: last_updated_by = FND_GLOBAL.user_id ,

189:
190: UPDATE wip_operation_resource_usage
191: SET completion_date = l_res_end_date ,
192: last_update_date = sysdate ,
193: last_updated_by = FND_GLOBAL.user_id ,
194: creation_date = sysdate ,
195: created_by = FND_GLOBAL.user_id ,
196: last_update_login = FND_GLOBAL.login_id
197: WHERE wip_entity_id = l_wip_id

Line 195: created_by = FND_GLOBAL.user_id ,

191: SET completion_date = l_res_end_date ,
192: last_update_date = sysdate ,
193: last_updated_by = FND_GLOBAL.user_id ,
194: creation_date = sysdate ,
195: created_by = FND_GLOBAL.user_id ,
196: last_update_login = FND_GLOBAL.login_id
197: WHERE wip_entity_id = l_wip_id
198: AND operation_seq_num = l_op_seq_num
199: AND resource_seq_num = l_res_seq_num

Line 196: last_update_login = FND_GLOBAL.login_id

192: last_update_date = sysdate ,
193: last_updated_by = FND_GLOBAL.user_id ,
194: creation_date = sysdate ,
195: created_by = FND_GLOBAL.user_id ,
196: last_update_login = FND_GLOBAL.login_id
197: WHERE wip_entity_id = l_wip_id
198: AND operation_seq_num = l_op_seq_num
199: AND resource_seq_num = l_res_seq_num
200: AND completion_date = ( SELECT MAX(completion_date)

Line 347: last_updated_by = FND_GLOBAL.user_id ,

343: first_unit_completion_date = l_op_end_date,
344: last_unit_start_date = l_op_start_date,
345: last_unit_completion_date = l_op_end_date ,
346: last_update_date = sysdate ,
347: last_updated_by = FND_GLOBAL.user_id ,
348: creation_date = sysdate ,
349: created_by = FND_GLOBAL.user_id ,
350: last_update_login = FND_GLOBAL.login_id
351: WHERE wip_entity_id = l_wip_id

Line 349: created_by = FND_GLOBAL.user_id ,

345: last_unit_completion_date = l_op_end_date ,
346: last_update_date = sysdate ,
347: last_updated_by = FND_GLOBAL.user_id ,
348: creation_date = sysdate ,
349: created_by = FND_GLOBAL.user_id ,
350: last_update_login = FND_GLOBAL.login_id
351: WHERE wip_entity_id = l_wip_id
352: AND operation_seq_num = l_op_seq_num ;
353: END IF ;

Line 350: last_update_login = FND_GLOBAL.login_id

346: last_update_date = sysdate ,
347: last_updated_by = FND_GLOBAL.user_id ,
348: creation_date = sysdate ,
349: created_by = FND_GLOBAL.user_id ,
350: last_update_login = FND_GLOBAL.login_id
351: WHERE wip_entity_id = l_wip_id
352: AND operation_seq_num = l_op_seq_num ;
353: END IF ;
354:

Line 443: last_updated_by = FND_GLOBAL.user_id ,

439: UPDATE wip_discrete_jobs
440: SET scheduled_start_date = l_wo_start_date,
441: scheduled_completion_date = l_wo_end_date ,
442: last_update_date = sysdate ,
443: last_updated_by = FND_GLOBAL.user_id ,
444: creation_date = sysdate ,
445: created_by = FND_GLOBAL.user_id ,
446: last_update_login = FND_GLOBAL.login_id
447: WHERE wip_entity_id = p_curr_op_rec.wip_entity_id

Line 445: created_by = FND_GLOBAL.user_id ,

441: scheduled_completion_date = l_wo_end_date ,
442: last_update_date = sysdate ,
443: last_updated_by = FND_GLOBAL.user_id ,
444: creation_date = sysdate ,
445: created_by = FND_GLOBAL.user_id ,
446: last_update_login = FND_GLOBAL.login_id
447: WHERE wip_entity_id = p_curr_op_rec.wip_entity_id
448: AND organization_id = p_curr_op_rec.organization_id ;
449:

Line 446: last_update_login = FND_GLOBAL.login_id

442: last_update_date = sysdate ,
443: last_updated_by = FND_GLOBAL.user_id ,
444: creation_date = sysdate ,
445: created_by = FND_GLOBAL.user_id ,
446: last_update_login = FND_GLOBAL.login_id
447: WHERE wip_entity_id = p_curr_op_rec.wip_entity_id
448: AND organization_id = p_curr_op_rec.organization_id ;
449:
450:

Line 673: last_updated_by = FND_GLOBAL.user_id ,

669: IF c_instusagemin_date < c_instdates_rec.start_date THEN
670: UPDATE wip_op_resource_instances
671: SET start_date = c_instusagemin_date,
672: last_update_date = sysdate ,
673: last_updated_by = FND_GLOBAL.user_id ,
674: last_update_login = FND_GLOBAL.login_id
675: WHERE wip_entity_id = p_wip_entity_id
676: AND operation_seq_num = c_opresource_rec.operation_seq_num
677: AND resource_seq_num = c_opresource_rec.resource_seq_num

Line 674: last_update_login = FND_GLOBAL.login_id

670: UPDATE wip_op_resource_instances
671: SET start_date = c_instusagemin_date,
672: last_update_date = sysdate ,
673: last_updated_by = FND_GLOBAL.user_id ,
674: last_update_login = FND_GLOBAL.login_id
675: WHERE wip_entity_id = p_wip_entity_id
676: AND operation_seq_num = c_opresource_rec.operation_seq_num
677: AND resource_seq_num = c_opresource_rec.resource_seq_num
678: AND instance_id = c_instdates_rec.instance_id

Line 686: last_updated_by = FND_GLOBAL.user_id ,

682: IF c_instusagemax_date > c_instdates_rec.completion_date THEN
683: UPDATE wip_op_resource_instances
684: SET completion_date = c_instusagemax_date,
685: last_update_date = sysdate ,
686: last_updated_by = FND_GLOBAL.user_id ,
687: last_update_login = FND_GLOBAL.login_id
688: WHERE wip_entity_id = p_wip_entity_id
689: AND operation_seq_num = c_opresource_rec.operation_seq_num
690: AND resource_seq_num = c_opresource_rec.resource_seq_num

Line 687: last_update_login = FND_GLOBAL.login_id

683: UPDATE wip_op_resource_instances
684: SET completion_date = c_instusagemax_date,
685: last_update_date = sysdate ,
686: last_updated_by = FND_GLOBAL.user_id ,
687: last_update_login = FND_GLOBAL.login_id
688: WHERE wip_entity_id = p_wip_entity_id
689: AND operation_seq_num = c_opresource_rec.operation_seq_num
690: AND resource_seq_num = c_opresource_rec.resource_seq_num
691: AND instance_id = c_instdates_rec.instance_id

Line 703: last_updated_by = FND_GLOBAL.user_id ,

699: IF c_resusagemin_date < c_opresource_rec.start_date THEN
700: UPDATE wip_operation_resources
701: SET start_date = c_resusagemin_date,
702: last_update_date = sysdate ,
703: last_updated_by = FND_GLOBAL.user_id ,
704: last_update_login = FND_GLOBAL.login_id
705: WHERE wip_entity_id = p_wip_entity_id
706: AND operation_seq_num = c_opresource_rec.operation_seq_num
707: AND organization_id = p_org_id

Line 704: last_update_login = FND_GLOBAL.login_id

700: UPDATE wip_operation_resources
701: SET start_date = c_resusagemin_date,
702: last_update_date = sysdate ,
703: last_updated_by = FND_GLOBAL.user_id ,
704: last_update_login = FND_GLOBAL.login_id
705: WHERE wip_entity_id = p_wip_entity_id
706: AND operation_seq_num = c_opresource_rec.operation_seq_num
707: AND organization_id = p_org_id
708: AND resource_seq_num = c_opresource_rec.resource_seq_num ;

Line 717: last_updated_by = FND_GLOBAL.user_id ,

713: IF c_resusagemax_date > c_opresource_rec.completion_date THEN
714: UPDATE wip_operation_resources
715: SET completion_date = c_resusagemax_date,
716: last_update_date = sysdate ,
717: last_updated_by = FND_GLOBAL.user_id ,
718: last_update_login = FND_GLOBAL.login_id
719: WHERE wip_entity_id = p_wip_entity_id
720: AND operation_seq_num = c_opresource_rec.operation_seq_num
721: AND organization_id = p_org_id

Line 718: last_update_login = FND_GLOBAL.login_id

714: UPDATE wip_operation_resources
715: SET completion_date = c_resusagemax_date,
716: last_update_date = sysdate ,
717: last_updated_by = FND_GLOBAL.user_id ,
718: last_update_login = FND_GLOBAL.login_id
719: WHERE wip_entity_id = p_wip_entity_id
720: AND operation_seq_num = c_opresource_rec.operation_seq_num
721: AND organization_id = p_org_id
722: AND resource_seq_num = c_opresource_rec.resource_seq_num ;

Line 749: last_updated_by = FND_GLOBAL.user_id ,

745: UPDATE wip_operations
746: SET first_unit_start_date = l_min_res_date,
747: last_unit_start_date = l_min_res_date,
748: last_update_date = sysdate ,
749: last_updated_by = FND_GLOBAL.user_id ,
750: last_update_login = FND_GLOBAL.login_id
751: WHERE wip_entity_id = p_wip_entity_id
752: AND operation_seq_num = c_operation_rec.operation_seq_num ;
753:

Line 750: last_update_login = FND_GLOBAL.login_id

746: SET first_unit_start_date = l_min_res_date,
747: last_unit_start_date = l_min_res_date,
748: last_update_date = sysdate ,
749: last_updated_by = FND_GLOBAL.user_id ,
750: last_update_login = FND_GLOBAL.login_id
751: WHERE wip_entity_id = p_wip_entity_id
752: AND operation_seq_num = c_operation_rec.operation_seq_num ;
753:
754: END IF;

Line 761: last_updated_by = FND_GLOBAL.user_id ,

757: UPDATE wip_operations
758: SET first_unit_completion_date = l_max_res_date ,
759: last_unit_completion_date = l_max_res_date ,
760: last_update_date = sysdate ,
761: last_updated_by = FND_GLOBAL.user_id ,
762: last_update_login = FND_GLOBAL.login_id
763: WHERE wip_entity_id = p_wip_entity_id
764: AND operation_seq_num = c_operation_rec.operation_seq_num ;
765:

Line 762: last_update_login = FND_GLOBAL.login_id

758: SET first_unit_completion_date = l_max_res_date ,
759: last_unit_completion_date = l_max_res_date ,
760: last_update_date = sysdate ,
761: last_updated_by = FND_GLOBAL.user_id ,
762: last_update_login = FND_GLOBAL.login_id
763: WHERE wip_entity_id = p_wip_entity_id
764: AND operation_seq_num = c_operation_rec.operation_seq_num ;
765:
766: END IF;

Line 794: last_updated_by = FND_GLOBAL.user_id ,

790: IF l_min_date < l_scheduled_start_date THEN
791: UPDATE wip_discrete_jobs
792: SET scheduled_start_date = l_min_date,
793: last_update_date = sysdate ,
794: last_updated_by = FND_GLOBAL.user_id ,
795: last_update_login = FND_GLOBAL.login_id
796: WHERE wip_entity_id = p_wip_entity_id
797: AND organization_id = p_org_id ;
798:

Line 795: last_update_login = FND_GLOBAL.login_id

791: UPDATE wip_discrete_jobs
792: SET scheduled_start_date = l_min_date,
793: last_update_date = sysdate ,
794: last_updated_by = FND_GLOBAL.user_id ,
795: last_update_login = FND_GLOBAL.login_id
796: WHERE wip_entity_id = p_wip_entity_id
797: AND organization_id = p_org_id ;
798:
799: END IF;

Line 809: last_updated_by = FND_GLOBAL.user_id ,

805:
806: UPDATE wip_discrete_jobs
807: SET scheduled_completion_date = l_max_date,
808: last_update_date = sysdate ,
809: last_updated_by = FND_GLOBAL.user_id ,
810: last_update_login = FND_GLOBAL.login_id
811: WHERE wip_entity_id = p_wip_entity_id
812: AND organization_id = p_org_id ;
813:

Line 810: last_update_login = FND_GLOBAL.login_id

806: UPDATE wip_discrete_jobs
807: SET scheduled_completion_date = l_max_date,
808: last_update_date = sysdate ,
809: last_updated_by = FND_GLOBAL.user_id ,
810: last_update_login = FND_GLOBAL.login_id
811: WHERE wip_entity_id = p_wip_entity_id
812: AND organization_id = p_org_id ;
813:
814: END IF;

Line 923: , FND_GLOBAL.user_id

919: , NVL( p_eam_res_usage_rec.assigned_units , 1 )
920: , p_eam_res_usage_rec.instance_id
921: , p_eam_res_usage_rec.serial_number
922: , SYSDATE
923: , FND_GLOBAL.user_id
924: , SYSDATE
925: , FND_GLOBAL.user_id
926: , FND_GLOBAL.login_id
927: , p_eam_res_usage_rec.request_id

Line 925: , FND_GLOBAL.user_id

921: , p_eam_res_usage_rec.serial_number
922: , SYSDATE
923: , FND_GLOBAL.user_id
924: , SYSDATE
925: , FND_GLOBAL.user_id
926: , FND_GLOBAL.login_id
927: , p_eam_res_usage_rec.request_id
928: , p_eam_res_usage_rec.program_application_id
929: , p_eam_res_usage_rec.program_id

Line 926: , FND_GLOBAL.login_id

922: , SYSDATE
923: , FND_GLOBAL.user_id
924: , SYSDATE
925: , FND_GLOBAL.user_id
926: , FND_GLOBAL.login_id
927: , p_eam_res_usage_rec.request_id
928: , p_eam_res_usage_rec.program_application_id
929: , p_eam_res_usage_rec.program_id
930: , SYSDATE);

Line 962: last_updated_by = FND_GLOBAL.user_id ,

958: UPDATE WIP_OPERATION_RESOURCE_USAGE
959: SET start_date = p_eam_res_usage_rec.start_date ,
960: completion_date = p_eam_res_usage_rec.completion_date ,
961: last_update_date = sysdate ,
962: last_updated_by = FND_GLOBAL.user_id ,
963: creation_date = sysdate ,
964: created_by = FND_GLOBAL.user_id ,
965: last_update_login = FND_GLOBAL.login_id
966: WHERE wip_entity_id = p_eam_res_usage_rec.wip_entity_id

Line 964: created_by = FND_GLOBAL.user_id ,

960: completion_date = p_eam_res_usage_rec.completion_date ,
961: last_update_date = sysdate ,
962: last_updated_by = FND_GLOBAL.user_id ,
963: creation_date = sysdate ,
964: created_by = FND_GLOBAL.user_id ,
965: last_update_login = FND_GLOBAL.login_id
966: WHERE wip_entity_id = p_eam_res_usage_rec.wip_entity_id
967: AND operation_seq_num = p_eam_res_usage_rec.operation_seq_num
968: AND organization_id = p_eam_res_usage_rec.organization_id

Line 965: last_update_login = FND_GLOBAL.login_id

961: last_update_date = sysdate ,
962: last_updated_by = FND_GLOBAL.user_id ,
963: creation_date = sysdate ,
964: created_by = FND_GLOBAL.user_id ,
965: last_update_login = FND_GLOBAL.login_id
966: WHERE wip_entity_id = p_eam_res_usage_rec.wip_entity_id
967: AND operation_seq_num = p_eam_res_usage_rec.operation_seq_num
968: AND organization_id = p_eam_res_usage_rec.organization_id
969: AND resource_seq_num = p_eam_res_usage_rec.resource_seq_num

Line 980: last_updated_by = FND_GLOBAL.user_id ,

976: UPDATE WIP_OPERATION_RESOURCE_USAGE
977: SET start_date = p_eam_res_usage_rec.start_date ,
978: completion_date = p_eam_res_usage_rec.completion_date ,
979: last_update_date = sysdate ,
980: last_updated_by = FND_GLOBAL.user_id ,
981: creation_date = sysdate ,
982: created_by = FND_GLOBAL.user_id ,
983: last_update_login = FND_GLOBAL.login_id
984: WHERE wip_entity_id = p_eam_res_usage_rec.wip_entity_id

Line 982: created_by = FND_GLOBAL.user_id ,

978: completion_date = p_eam_res_usage_rec.completion_date ,
979: last_update_date = sysdate ,
980: last_updated_by = FND_GLOBAL.user_id ,
981: creation_date = sysdate ,
982: created_by = FND_GLOBAL.user_id ,
983: last_update_login = FND_GLOBAL.login_id
984: WHERE wip_entity_id = p_eam_res_usage_rec.wip_entity_id
985: AND operation_seq_num = p_eam_res_usage_rec.operation_seq_num
986: AND organization_id = p_eam_res_usage_rec.organization_id

Line 983: last_update_login = FND_GLOBAL.login_id

979: last_update_date = sysdate ,
980: last_updated_by = FND_GLOBAL.user_id ,
981: creation_date = sysdate ,
982: created_by = FND_GLOBAL.user_id ,
983: last_update_login = FND_GLOBAL.login_id
984: WHERE wip_entity_id = p_eam_res_usage_rec.wip_entity_id
985: AND operation_seq_num = p_eam_res_usage_rec.operation_seq_num
986: AND organization_id = p_eam_res_usage_rec.organization_id
987: AND resource_seq_num = p_eam_res_usage_rec.resource_seq_num

Line 1132: last_updated_by = FND_GLOBAL.user_id ,

1128: UPDATE wip_op_resource_instances
1129: SET start_date = l_min_start_date,
1130: completion_date = l_max_completion_date ,
1131: last_update_date = sysdate ,
1132: last_updated_by = FND_GLOBAL.user_id ,
1133: creation_date = sysdate ,
1134: created_by = FND_GLOBAL.user_id ,
1135: last_update_login = FND_GLOBAL.login_id
1136: WHERE wip_entity_id = l_wip_entity_id

Line 1134: created_by = FND_GLOBAL.user_id ,

1130: completion_date = l_max_completion_date ,
1131: last_update_date = sysdate ,
1132: last_updated_by = FND_GLOBAL.user_id ,
1133: creation_date = sysdate ,
1134: created_by = FND_GLOBAL.user_id ,
1135: last_update_login = FND_GLOBAL.login_id
1136: WHERE wip_entity_id = l_wip_entity_id
1137: AND operation_seq_num = l_operation_seq_num
1138: AND organization_id = l_org_id

Line 1135: last_update_login = FND_GLOBAL.login_id

1131: last_update_date = sysdate ,
1132: last_updated_by = FND_GLOBAL.user_id ,
1133: creation_date = sysdate ,
1134: created_by = FND_GLOBAL.user_id ,
1135: last_update_login = FND_GLOBAL.login_id
1136: WHERE wip_entity_id = l_wip_entity_id
1137: AND operation_seq_num = l_operation_seq_num
1138: AND organization_id = l_org_id
1139: AND resource_seq_num = l_res_seq_num

Line 1279: last_updated_by = FND_GLOBAL.user_id ,

1275: UPDATE wip_operation_resources
1276: SET start_date = l_min_start_date,
1277: completion_date = l_max_completion_date ,
1278: last_update_date = sysdate ,
1279: last_updated_by = FND_GLOBAL.user_id ,
1280: creation_date = sysdate ,
1281: created_by = FND_GLOBAL.user_id ,
1282: last_update_login = FND_GLOBAL.login_id
1283: WHERE wip_entity_id = l_wip_entity_id

Line 1281: created_by = FND_GLOBAL.user_id ,

1277: completion_date = l_max_completion_date ,
1278: last_update_date = sysdate ,
1279: last_updated_by = FND_GLOBAL.user_id ,
1280: creation_date = sysdate ,
1281: created_by = FND_GLOBAL.user_id ,
1282: last_update_login = FND_GLOBAL.login_id
1283: WHERE wip_entity_id = l_wip_entity_id
1284: AND operation_seq_num = l_operation_seq_num
1285: AND organization_id = l_org_id

Line 1282: last_update_login = FND_GLOBAL.login_id

1278: last_update_date = sysdate ,
1279: last_updated_by = FND_GLOBAL.user_id ,
1280: creation_date = sysdate ,
1281: created_by = FND_GLOBAL.user_id ,
1282: last_update_login = FND_GLOBAL.login_id
1283: WHERE wip_entity_id = l_wip_entity_id
1284: AND operation_seq_num = l_operation_seq_num
1285: AND organization_id = l_org_id
1286: AND resource_seq_num = l_res_seq_num ;

Line 1547: last_updated_by = FND_GLOBAL.user_id ,

1543:
1544: UPDATE wip_operation_resource_usage
1545: SET start_date = l_eam_res_inst_tbl(l_res_inst_tbl_index).start_date ,
1546: last_update_date = sysdate ,
1547: last_updated_by = FND_GLOBAL.user_id ,
1548: creation_date = sysdate ,
1549: created_by = FND_GLOBAL.user_id ,
1550: last_update_login = FND_GLOBAL.login_id
1551: WHERE wip_entity_id = l_wip_entity_id

Line 1549: created_by = FND_GLOBAL.user_id ,

1545: SET start_date = l_eam_res_inst_tbl(l_res_inst_tbl_index).start_date ,
1546: last_update_date = sysdate ,
1547: last_updated_by = FND_GLOBAL.user_id ,
1548: creation_date = sysdate ,
1549: created_by = FND_GLOBAL.user_id ,
1550: last_update_login = FND_GLOBAL.login_id
1551: WHERE wip_entity_id = l_wip_entity_id
1552: AND operation_seq_num = l_op_seq_num
1553: AND resource_seq_num = l_res_seq_num

Line 1550: last_update_login = FND_GLOBAL.login_id

1546: last_update_date = sysdate ,
1547: last_updated_by = FND_GLOBAL.user_id ,
1548: creation_date = sysdate ,
1549: created_by = FND_GLOBAL.user_id ,
1550: last_update_login = FND_GLOBAL.login_id
1551: WHERE wip_entity_id = l_wip_entity_id
1552: AND operation_seq_num = l_op_seq_num
1553: AND resource_seq_num = l_res_seq_num
1554: AND start_date = l_min_date

Line 1564: last_updated_by = FND_GLOBAL.user_id ,

1560:
1561: UPDATE wip_operation_resource_usage
1562: SET completion_date = l_eam_res_inst_tbl(l_res_inst_tbl_index).completion_date ,
1563: last_update_date = sysdate ,
1564: last_updated_by = FND_GLOBAL.user_id ,
1565: creation_date = sysdate ,
1566: created_by = FND_GLOBAL.user_id ,
1567: last_update_login = FND_GLOBAL.login_id
1568: WHERE wip_entity_id = l_wip_entity_id

Line 1566: created_by = FND_GLOBAL.user_id ,

1562: SET completion_date = l_eam_res_inst_tbl(l_res_inst_tbl_index).completion_date ,
1563: last_update_date = sysdate ,
1564: last_updated_by = FND_GLOBAL.user_id ,
1565: creation_date = sysdate ,
1566: created_by = FND_GLOBAL.user_id ,
1567: last_update_login = FND_GLOBAL.login_id
1568: WHERE wip_entity_id = l_wip_entity_id
1569: AND operation_seq_num = l_op_seq_num
1570: AND resource_seq_num = l_res_seq_num

Line 1567: last_update_login = FND_GLOBAL.login_id

1563: last_update_date = sysdate ,
1564: last_updated_by = FND_GLOBAL.user_id ,
1565: creation_date = sysdate ,
1566: created_by = FND_GLOBAL.user_id ,
1567: last_update_login = FND_GLOBAL.login_id
1568: WHERE wip_entity_id = l_wip_entity_id
1569: AND operation_seq_num = l_op_seq_num
1570: AND resource_seq_num = l_res_seq_num
1571: AND completion_date = l_max_date

Line 1652: last_updated_by = FND_GLOBAL.user_id ,

1648:
1649: UPDATE wip_operation_resource_usage
1650: SET start_date = l_eam_res_tbl(l_res_tbl_index).start_date ,
1651: last_update_date = sysdate ,
1652: last_updated_by = FND_GLOBAL.user_id ,
1653: creation_date = sysdate ,
1654: created_by = FND_GLOBAL.user_id ,
1655: last_update_login = FND_GLOBAL.login_id
1656: WHERE wip_entity_id = l_wip_entity_id

Line 1654: created_by = FND_GLOBAL.user_id ,

1650: SET start_date = l_eam_res_tbl(l_res_tbl_index).start_date ,
1651: last_update_date = sysdate ,
1652: last_updated_by = FND_GLOBAL.user_id ,
1653: creation_date = sysdate ,
1654: created_by = FND_GLOBAL.user_id ,
1655: last_update_login = FND_GLOBAL.login_id
1656: WHERE wip_entity_id = l_wip_entity_id
1657: AND operation_seq_num = l_op_seq_num
1658: AND resource_seq_num = l_res_seq_num

Line 1655: last_update_login = FND_GLOBAL.login_id

1651: last_update_date = sysdate ,
1652: last_updated_by = FND_GLOBAL.user_id ,
1653: creation_date = sysdate ,
1654: created_by = FND_GLOBAL.user_id ,
1655: last_update_login = FND_GLOBAL.login_id
1656: WHERE wip_entity_id = l_wip_entity_id
1657: AND operation_seq_num = l_op_seq_num
1658: AND resource_seq_num = l_res_seq_num
1659: AND instance_id IS NULL

Line 1666: last_updated_by = FND_GLOBAL.user_id ,

1662:
1663: UPDATE wip_operation_resource_usage
1664: SET completion_date = l_eam_res_tbl(l_res_tbl_index).completion_date ,
1665: last_update_date = sysdate ,
1666: last_updated_by = FND_GLOBAL.user_id ,
1667: creation_date = sysdate ,
1668: created_by = FND_GLOBAL.user_id ,
1669: last_update_login = FND_GLOBAL.login_id
1670: WHERE wip_entity_id = l_wip_entity_id

Line 1668: created_by = FND_GLOBAL.user_id ,

1664: SET completion_date = l_eam_res_tbl(l_res_tbl_index).completion_date ,
1665: last_update_date = sysdate ,
1666: last_updated_by = FND_GLOBAL.user_id ,
1667: creation_date = sysdate ,
1668: created_by = FND_GLOBAL.user_id ,
1669: last_update_login = FND_GLOBAL.login_id
1670: WHERE wip_entity_id = l_wip_entity_id
1671: AND operation_seq_num = l_op_seq_num
1672: AND resource_seq_num = l_res_seq_num

Line 1669: last_update_login = FND_GLOBAL.login_id

1665: last_update_date = sysdate ,
1666: last_updated_by = FND_GLOBAL.user_id ,
1667: creation_date = sysdate ,
1668: created_by = FND_GLOBAL.user_id ,
1669: last_update_login = FND_GLOBAL.login_id
1670: WHERE wip_entity_id = l_wip_entity_id
1671: AND operation_seq_num = l_op_seq_num
1672: AND resource_seq_num = l_res_seq_num
1673: AND instance_id IS NULL

Line 1692: last_updated_by = FND_GLOBAL.user_id ,

1688:
1689: UPDATE wip_operation_resource_usage
1690: SET start_date = l_eam_res_tbl(l_res_tbl_index).start_date ,
1691: last_update_date = sysdate ,
1692: last_updated_by = FND_GLOBAL.user_id ,
1693: creation_date = sysdate ,
1694: created_by = FND_GLOBAL.user_id ,
1695: last_update_login = FND_GLOBAL.login_id
1696: WHERE wip_entity_id = l_wip_entity_id

Line 1694: created_by = FND_GLOBAL.user_id ,

1690: SET start_date = l_eam_res_tbl(l_res_tbl_index).start_date ,
1691: last_update_date = sysdate ,
1692: last_updated_by = FND_GLOBAL.user_id ,
1693: creation_date = sysdate ,
1694: created_by = FND_GLOBAL.user_id ,
1695: last_update_login = FND_GLOBAL.login_id
1696: WHERE wip_entity_id = l_wip_entity_id
1697: AND operation_seq_num = l_op_seq_num
1698: AND resource_seq_num = l_res_seq_num

Line 1695: last_update_login = FND_GLOBAL.login_id

1691: last_update_date = sysdate ,
1692: last_updated_by = FND_GLOBAL.user_id ,
1693: creation_date = sysdate ,
1694: created_by = FND_GLOBAL.user_id ,
1695: last_update_login = FND_GLOBAL.login_id
1696: WHERE wip_entity_id = l_wip_entity_id
1697: AND operation_seq_num = l_op_seq_num
1698: AND resource_seq_num = l_res_seq_num
1699: AND instance_id = c_instdates_rec.instance_id

Line 1705: last_updated_by = FND_GLOBAL.user_id ,

1701:
1702: UPDATE wip_operation_resource_usage
1703: SET completion_date =l_eam_res_tbl(l_res_tbl_index).completion_date ,
1704: last_update_date = sysdate ,
1705: last_updated_by = FND_GLOBAL.user_id ,
1706: creation_date = sysdate ,
1707: created_by = FND_GLOBAL.user_id ,
1708: last_update_login = FND_GLOBAL.login_id
1709: WHERE wip_entity_id = l_wip_entity_id

Line 1707: created_by = FND_GLOBAL.user_id ,

1703: SET completion_date =l_eam_res_tbl(l_res_tbl_index).completion_date ,
1704: last_update_date = sysdate ,
1705: last_updated_by = FND_GLOBAL.user_id ,
1706: creation_date = sysdate ,
1707: created_by = FND_GLOBAL.user_id ,
1708: last_update_login = FND_GLOBAL.login_id
1709: WHERE wip_entity_id = l_wip_entity_id
1710: AND operation_seq_num = l_op_seq_num
1711: AND resource_seq_num = l_res_seq_num

Line 1708: last_update_login = FND_GLOBAL.login_id

1704: last_update_date = sysdate ,
1705: last_updated_by = FND_GLOBAL.user_id ,
1706: creation_date = sysdate ,
1707: created_by = FND_GLOBAL.user_id ,
1708: last_update_login = FND_GLOBAL.login_id
1709: WHERE wip_entity_id = l_wip_entity_id
1710: AND operation_seq_num = l_op_seq_num
1711: AND resource_seq_num = l_res_seq_num
1712: AND instance_id = c_instdates_rec.instance_id

Line 1753: last_updated_by = FND_GLOBAL.user_id ,

1749:
1750: UPDATE wip_operation_resource_usage
1751: SET start_date = l_eam_res_tbl(l_res_tbl_index).start_date ,
1752: last_update_date = sysdate ,
1753: last_updated_by = FND_GLOBAL.user_id ,
1754: creation_date = sysdate ,
1755: created_by = FND_GLOBAL.user_id ,
1756: last_update_login = FND_GLOBAL.login_id
1757: WHERE wip_entity_id = l_wip_entity_id

Line 1755: created_by = FND_GLOBAL.user_id ,

1751: SET start_date = l_eam_res_tbl(l_res_tbl_index).start_date ,
1752: last_update_date = sysdate ,
1753: last_updated_by = FND_GLOBAL.user_id ,
1754: creation_date = sysdate ,
1755: created_by = FND_GLOBAL.user_id ,
1756: last_update_login = FND_GLOBAL.login_id
1757: WHERE wip_entity_id = l_wip_entity_id
1758: AND operation_seq_num = l_op_seq_num
1759: AND resource_seq_num = l_res_seq_num

Line 1756: last_update_login = FND_GLOBAL.login_id

1752: last_update_date = sysdate ,
1753: last_updated_by = FND_GLOBAL.user_id ,
1754: creation_date = sysdate ,
1755: created_by = FND_GLOBAL.user_id ,
1756: last_update_login = FND_GLOBAL.login_id
1757: WHERE wip_entity_id = l_wip_entity_id
1758: AND operation_seq_num = l_op_seq_num
1759: AND resource_seq_num = l_res_seq_num
1760: AND start_date = l_min_date

Line 1770: last_updated_by = FND_GLOBAL.user_id ,

1766:
1767: UPDATE wip_operation_resource_usage
1768: SET completion_date = l_eam_res_tbl(l_res_tbl_index).completion_date ,
1769: last_update_date = sysdate ,
1770: last_updated_by = FND_GLOBAL.user_id ,
1771: creation_date = sysdate ,
1772: created_by = FND_GLOBAL.user_id ,
1773: last_update_login = FND_GLOBAL.login_id
1774: WHERE wip_entity_id = l_wip_entity_id

Line 1772: created_by = FND_GLOBAL.user_id ,

1768: SET completion_date = l_eam_res_tbl(l_res_tbl_index).completion_date ,
1769: last_update_date = sysdate ,
1770: last_updated_by = FND_GLOBAL.user_id ,
1771: creation_date = sysdate ,
1772: created_by = FND_GLOBAL.user_id ,
1773: last_update_login = FND_GLOBAL.login_id
1774: WHERE wip_entity_id = l_wip_entity_id
1775: AND operation_seq_num = l_op_seq_num
1776: AND resource_seq_num = l_res_seq_num

Line 1773: last_update_login = FND_GLOBAL.login_id

1769: last_update_date = sysdate ,
1770: last_updated_by = FND_GLOBAL.user_id ,
1771: creation_date = sysdate ,
1772: created_by = FND_GLOBAL.user_id ,
1773: last_update_login = FND_GLOBAL.login_id
1774: WHERE wip_entity_id = l_wip_entity_id
1775: AND operation_seq_num = l_op_seq_num
1776: AND resource_seq_num = l_res_seq_num
1777: AND completion_date = l_max_date