DBA Data[Home] [Help]

APPS.WMS_DIRECT_SHIP_PVT dependencies on FND_GLOBAL

Line 970: last_updated_by = FND_GLOBAL.USER_ID

966:
967: UPDATE WMS_FREIGHT_COST_TEMP
968: SET freight_cost_id = l_freight_cost_id,
969: last_update_date= SYSDATE,
970: last_updated_by = FND_GLOBAL.USER_ID
971: WHERE rowid = l_row_id;
972:
973: END LOOP;
974: CLOSE delivery_freight;

Line 1912: last_updated_by = FND_GLOBAL.USER_ID

1908: IF l_trip_id IS NOT NULL THEN
1909: UPDATE wms_shipping_transaction_temp
1910: SET trip_id = l_trip_id,
1911: last_update_date = SYSDATE,
1912: last_updated_by = FND_GLOBAL.USER_ID
1913: WHERE delivery_id = p_delivery_id;--l_delivery_id; /* bug 2741857 */
1914: END IF;
1915: EXCEPTION
1916: WHEN NO_DATA_FOUND THEN

Line 2240: ,last_updated_by = FND_GLOBAL.USER_ID

2236:
2237: UPDATE WMS_FREIGHT_COST_TEMP
2238: SET freight_cost_id = l_freight_cost_id
2239: ,last_update_date = SYSDATE
2240: ,last_updated_by = FND_GLOBAL.USER_ID
2241: WHERE rowid = l_row_id;
2242:
2243: END LOOP;
2244: CLOSE trip_freight;

Line 2312: p_trip_info.last_updated_by :=FND_GLOBAL.USER_ID;

2308: p_trip_info.vehicle_organization_id :=l_org_id;
2309: p_trip_info.VEHICLE_NUMBER := p_vehicle_num;
2310: p_trip_info.VEHICLE_NUM_PREFIX := p_vehicle_num_prefix;
2311: p_trip_info.last_update_date := SYSDATE;
2312: p_trip_info.last_updated_by :=FND_GLOBAL.USER_ID;
2313: p_trip_info.last_update_login := FND_GLOBAL.USER_ID;
2314: p_trip_info.ship_method_code :=p_ship_method_code; --Bug 2980013:Updating the Ship Method Code*/
2315:
2316: IF (l_debug = 1) THEN

Line 2313: p_trip_info.last_update_login := FND_GLOBAL.USER_ID;

2309: p_trip_info.VEHICLE_NUMBER := p_vehicle_num;
2310: p_trip_info.VEHICLE_NUM_PREFIX := p_vehicle_num_prefix;
2311: p_trip_info.last_update_date := SYSDATE;
2312: p_trip_info.last_updated_by :=FND_GLOBAL.USER_ID;
2313: p_trip_info.last_update_login := FND_GLOBAL.USER_ID;
2314: p_trip_info.ship_method_code :=p_ship_method_code; --Bug 2980013:Updating the Ship Method Code*/
2315:
2316: IF (l_debug = 1) THEN
2317: debug('Call to Create_update_Trip','Update_Trip_Stop');

Line 3675: x_userid := fnd_global.user_id;

3671: x_progress VARCHAR2(3) := NULL;
3672: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
3673: BEGIN
3674: x_progress := 10;
3675: x_userid := fnd_global.user_id;
3676: x_progress := 20;
3677: x_logonid := fnd_global.login_id;
3678: x_progress := 30;
3679: x_last_upd_date := SYSDATE;

Line 3677: x_logonid := fnd_global.login_id;

3673: BEGIN
3674: x_progress := 10;
3675: x_userid := fnd_global.user_id;
3676: x_progress := 20;
3677: x_logonid := fnd_global.login_id;
3678: x_progress := 30;
3679: x_last_upd_date := SYSDATE;
3680: x_progress := 40;
3681: x_current_date := SYSDATE;

Line 3879: , last_updated_by = fnd_global.user_id

3875:
3876: UPDATE wms_freight_cost_temp
3877: SET freight_cost_id = l_freight_cost_id
3878: , last_update_date = SYSDATE
3879: , last_updated_by = fnd_global.user_id
3880: WHERE ROWID = l_lpn_freight.ROWID;
3881: END LOOP;
3882:
3883: CLOSE lpn_freight;

Line 4341: , p_user_id => fnd_global.user_id

4337:
4338: l_succes :=
4339: inv_trx_util_pub.insert_ser_trx(
4340: p_trx_tmp_id => l_explode_detail.transaction_temp_id
4341: , p_user_id => fnd_global.user_id
4342: , p_fm_ser_num => l_explode_detail.fm_serial_number
4343: , p_to_ser_num => l_current_to_serial
4344: , p_serial_attribute_category => l_explode_detail.serial_attribute_category
4345: , p_orgination_date => l_explode_detail.origination_date

Line 4739: , p_user_id => fnd_global.user_id

4735:
4736: l_succes :=
4737: inv_trx_util_pub.insert_ser_trx(
4738: p_trx_tmp_id => p_transaction_temp_id
4739: , p_user_id => fnd_global.user_id
4740: , p_fm_ser_num => l_serial_numbers_table(n)
4741: , p_to_ser_num => l_serial_numbers_table(n)
4742: , x_proc_msg => l_proc_msg
4743: );

Line 9441: g_created_by := fnd_global.user_id;

9437: g_checked_deliveries.DELETE;
9438: l_skipped_line_tab.DELETE;
9439: -- initializa who columns for session
9440: g_creation_date := SYSDATE;
9441: g_created_by := fnd_global.user_id;
9442: g_last_updated_by := g_created_by;
9443: g_last_update_login := fnd_global.login_id;
9444: g_last_update_date := g_creation_date;
9445: -- cleaning temp data if the delivery was backordered for this lpn somethimes in past

Line 9443: g_last_update_login := fnd_global.login_id;

9439: -- initializa who columns for session
9440: g_creation_date := SYSDATE;
9441: g_created_by := fnd_global.user_id;
9442: g_last_updated_by := g_created_by;
9443: g_last_update_login := fnd_global.login_id;
9444: g_last_update_date := g_creation_date;
9445: -- cleaning temp data if the delivery was backordered for this lpn somethimes in past
9446: wms_direct_ship_pvt.cleanup_orphan_rec(p_org_id);
9447: