DBA Data[Home] [Help]

APPS.WMS_DIRECT_SHIP_PVT dependencies on FND_GLOBAL

Line 887: last_updated_by = FND_GLOBAL.USER_ID

883:
884: UPDATE WMS_FREIGHT_COST_TEMP
885: SET freight_cost_id = l_freight_cost_id,
886: last_update_date= SYSDATE,
887: last_updated_by = FND_GLOBAL.USER_ID
888: WHERE rowid = l_row_id;
889:
890: END LOOP;
891: CLOSE delivery_freight;

Line 1817: last_updated_by = FND_GLOBAL.USER_ID

1813: IF l_trip_id IS NOT NULL THEN
1814: UPDATE wms_shipping_transaction_temp
1815: SET trip_id = l_trip_id,
1816: last_update_date = SYSDATE,
1817: last_updated_by = FND_GLOBAL.USER_ID
1818: WHERE delivery_id = p_delivery_id;--l_delivery_id; /* bug 2741857 */
1819: END IF;
1820: EXCEPTION
1821: WHEN NO_DATA_FOUND THEN

Line 2144: ,last_updated_by = FND_GLOBAL.USER_ID

2140:
2141: UPDATE WMS_FREIGHT_COST_TEMP
2142: SET freight_cost_id = l_freight_cost_id
2143: ,last_update_date = SYSDATE
2144: ,last_updated_by = FND_GLOBAL.USER_ID
2145: WHERE rowid = l_row_id;
2146:
2147: END LOOP;
2148: CLOSE trip_freight;

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

2212: p_trip_info.vehicle_organization_id :=l_org_id;
2213: p_trip_info.VEHICLE_NUMBER := p_vehicle_num;
2214: p_trip_info.VEHICLE_NUM_PREFIX := p_vehicle_num_prefix;
2215: p_trip_info.last_update_date := SYSDATE;
2216: p_trip_info.last_updated_by :=FND_GLOBAL.USER_ID;
2217: p_trip_info.last_update_login := FND_GLOBAL.USER_ID;
2218: p_trip_info.ship_method_code :=p_ship_method_code; --Bug 2980013:Updating the Ship Method Code*/
2219:
2220: IF (l_debug = 1) THEN

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

2213: p_trip_info.VEHICLE_NUMBER := p_vehicle_num;
2214: p_trip_info.VEHICLE_NUM_PREFIX := p_vehicle_num_prefix;
2215: p_trip_info.last_update_date := SYSDATE;
2216: p_trip_info.last_updated_by :=FND_GLOBAL.USER_ID;
2217: p_trip_info.last_update_login := FND_GLOBAL.USER_ID;
2218: p_trip_info.ship_method_code :=p_ship_method_code; --Bug 2980013:Updating the Ship Method Code*/
2219:
2220: IF (l_debug = 1) THEN
2221: debug('Call to Create_update_Trip','Update_Trip_Stop');

Line 3485: x_userid := fnd_global.user_id;

3481: x_progress VARCHAR2(3) := NULL;
3482: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
3483: BEGIN
3484: x_progress := 10;
3485: x_userid := fnd_global.user_id;
3486: x_progress := 20;
3487: x_logonid := fnd_global.login_id;
3488: x_progress := 30;
3489: x_last_upd_date := SYSDATE;

Line 3487: x_logonid := fnd_global.login_id;

3483: BEGIN
3484: x_progress := 10;
3485: x_userid := fnd_global.user_id;
3486: x_progress := 20;
3487: x_logonid := fnd_global.login_id;
3488: x_progress := 30;
3489: x_last_upd_date := SYSDATE;
3490: x_progress := 40;
3491: x_current_date := SYSDATE;

Line 3677: , last_updated_by = fnd_global.user_id

3673:
3674: UPDATE wms_freight_cost_temp
3675: SET freight_cost_id = l_freight_cost_id
3676: , last_update_date = SYSDATE
3677: , last_updated_by = fnd_global.user_id
3678: WHERE ROWID = l_lpn_freight.ROWID;
3679: END LOOP;
3680:
3681: CLOSE lpn_freight;

Line 4139: , p_user_id => fnd_global.user_id

4135:
4136: l_succes :=
4137: inv_trx_util_pub.insert_ser_trx(
4138: p_trx_tmp_id => l_explode_detail.transaction_temp_id
4139: , p_user_id => fnd_global.user_id
4140: , p_fm_ser_num => l_explode_detail.fm_serial_number
4141: , p_to_ser_num => l_current_to_serial
4142: , p_serial_attribute_category => l_explode_detail.serial_attribute_category
4143: , p_orgination_date => l_explode_detail.origination_date

Line 4537: , p_user_id => fnd_global.user_id

4533:
4534: l_succes :=
4535: inv_trx_util_pub.insert_ser_trx(
4536: p_trx_tmp_id => p_transaction_temp_id
4537: , p_user_id => fnd_global.user_id
4538: , p_fm_ser_num => l_serial_numbers_table(n)
4539: , p_to_ser_num => l_serial_numbers_table(n)
4540: , x_proc_msg => l_proc_msg
4541: );

Line 8316: g_created_by := fnd_global.user_id;

8312: g_checked_deliveries.DELETE;
8313: l_skipped_line_tab.DELETE;
8314: -- initializa who columns for session
8315: g_creation_date := SYSDATE;
8316: g_created_by := fnd_global.user_id;
8317: g_last_updated_by := g_created_by;
8318: g_last_update_login := fnd_global.login_id;
8319: g_last_update_date := g_creation_date;
8320: -- cleaning temp data if the delivery was backordered for this lpn somethimes in past

Line 8318: g_last_update_login := fnd_global.login_id;

8314: -- initializa who columns for session
8315: g_creation_date := SYSDATE;
8316: g_created_by := fnd_global.user_id;
8317: g_last_updated_by := g_created_by;
8318: g_last_update_login := fnd_global.login_id;
8319: g_last_update_date := g_creation_date;
8320: -- cleaning temp data if the delivery was backordered for this lpn somethimes in past
8321: wms_direct_ship_pvt.cleanup_orphan_rec(p_org_id);
8322: