DBA Data[Home] [Help]

APPS.WMS_TASK_LOAD dependencies on FND_GLOBAL

Line 1080: , last_updated_by = fnd_global.user_id

1076: -- Bug5659809: update last_update_date and last_update_by as well
1077: UPDATE wms_license_plate_numbers
1078: SET lpn_context = 1
1079: , last_update_date = SYSDATE
1080: , last_updated_by = fnd_global.user_id
1081: WHERE lpn_id = l_lpn_id;
1082:
1083: -- Update remaining MMTT record
1084: UPDATE mtl_material_transactions_temp

Line 1315: , last_updated_by = fnd_global.user_id

1311: -- Bug5659809: update last_update_date and last_update_by as well
1312: UPDATE wms_license_plate_numbers
1313: SET lpn_context = l_lpn_context_packing
1314: , last_update_date = SYSDATE
1315: , last_updated_by = fnd_global.user_id
1316: WHERE lpn_id = l_lpn_match_lpn_id
1317: AND lpn_context = l_lpn_context_inv --, l_transfer_lpn_id)
1318: AND organization_id = p_organization_id;
1319:

Line 1351: , last_updated_by = fnd_global.user_id

1347: -- Bug5659809: update last_update_date and last_update_by as well
1348: UPDATE wms_license_plate_numbers
1349: SET lpn_context = l_lpn_context_packing
1350: , last_update_date = SYSDATE
1351: , last_updated_by = fnd_global.user_id
1352: WHERE lpn_id = l_transfer_lpn_id
1353: AND lpn_context in (l_lpn_context_packing , l_lpn_context_pregenerated)
1354: AND organization_id = p_organization_id;
1355:

Line 5528: , last_updated_by = fnd_global.user_id

5524: -- Bug5659809: update last_update_date and last_update_by as well
5525: UPDATE wms_license_plate_numbers
5526: SET lpn_context = l_lpn_context_PREGENERATED
5527: , last_update_date = SYSDATE
5528: , last_updated_by = fnd_global.user_id
5529: WHERE lpn_id = rec_transfer_lpns.transfer_lpn_id
5530: AND lpn_context <> l_lpn_context_picked;
5531:
5532: IF SQL%NOTFOUND THEN

Line 5551: , last_updated_by = fnd_global.user_id

5547: -- Bug5659809: update last_update_date and last_update_by as well
5548: UPDATE wms_license_plate_numbers
5549: SET lpn_context = l_lpn_context_INV
5550: , last_update_date = SYSDATE
5551: , last_updated_by = fnd_global.user_id
5552: WHERE lpn_id = rec_from_lpns.lpn_id
5553: AND lpn_context = l_lpn_context_packing;
5554:
5555: IF SQL%NOTFOUND THEN

Line 5586: , last_updated_by = fnd_global.user_id

5582: -- Bug5659809: update last_update_date and last_update_by as well
5583: UPDATE wms_license_plate_numbers
5584: SET lpn_context = l_lpn_context_inv
5585: , last_update_date = SYSDATE
5586: , last_updated_by = fnd_global.user_id
5587: WHERE lpn_id = rec_content_lpns.content_lpn_id
5588: AND lpn_context <> l_lpn_context_picked;
5589:
5590: IF SQL%NOTFOUND THEN

Line 10505: mydebug(REPLACE(x_msg_data, fnd_global.local_chr(0), ' '));

10501: END IF;
10502: ELSIF(l_msg_count = 1) THEN
10503: IF (l_debug = 1) THEN
10504: mydebug('check_pack_lpn: Not Successful');
10505: mydebug(REPLACE(x_msg_data, fnd_global.local_chr(0), ' '));
10506: END IF;
10507: ELSE
10508: IF (l_debug = 1) THEN
10509: mydebug('check_pack_lpn: Not Successful2');

Line 10516: mydebug(REPLACE(x_msg_data, fnd_global.local_chr(0), ' '));

10512: FOR i IN 1 .. l_msg_count LOOP
10513: x_msg_data := fnd_msg_pub.get(i, 'F');
10514:
10515: IF (l_debug = 1) THEN
10516: mydebug(REPLACE(x_msg_data, fnd_global.local_chr(0), ' '));
10517: END IF;
10518: END LOOP;
10519: END IF;
10520: