DBA Data[Home] [Help]

APPS.WSH_SC_TRX_INTERFACE dependencies on FND_GLOBAL

Line 410: Last_updated_by = fnd_global.user_id,

406: x_dpw_assigned_flag.
407: */
408: UPDATE SO_PICKING_LINE_DETAILS pld
409: SET Last_update_date = sysdate,
410: Last_updated_by = fnd_global.user_id,
411: Last_update_login = fnd_global.user_id,
412: Warehouse_id = nvl(X_warehouse, warehouse_id),
413: Requested_quantity = requested_quantity + x_requested_quantity,
414: Shipped_quantity = nvl(SHIPPED_QUANTITY,0) + x_shipped_quantity,

Line 411: Last_update_login = fnd_global.user_id,

407: */
408: UPDATE SO_PICKING_LINE_DETAILS pld
409: SET Last_update_date = sysdate,
410: Last_updated_by = fnd_global.user_id,
411: Last_update_login = fnd_global.user_id,
412: Warehouse_id = nvl(X_warehouse, warehouse_id),
413: Requested_quantity = requested_quantity + x_requested_quantity,
414: Shipped_quantity = nvl(SHIPPED_QUANTITY,0) + x_shipped_quantity,
415: Serial_number = nvl(X_SN, serial_number),

Line 585: FND_GLOBAL.USER_ID,

581: , DPW_ASSIGNED_FLAG)
582: SELECT new_pld_id,
583: X_pick_slip_number,
584: SYSDATE,
585: FND_GLOBAL.USER_ID,
586: FND_GLOBAL.USER_ID,
587: SYSDATE,
588: FND_GLOBAL.LOGIN_ID,
589: pld.picking_line_id,

Line 586: FND_GLOBAL.USER_ID,

582: SELECT new_pld_id,
583: X_pick_slip_number,
584: SYSDATE,
585: FND_GLOBAL.USER_ID,
586: FND_GLOBAL.USER_ID,
587: SYSDATE,
588: FND_GLOBAL.LOGIN_ID,
589: pld.picking_line_id,
590: detail_type_code,

Line 588: FND_GLOBAL.LOGIN_ID,

584: SYSDATE,
585: FND_GLOBAL.USER_ID,
586: FND_GLOBAL.USER_ID,
587: SYSDATE,
588: FND_GLOBAL.LOGIN_ID,
589: pld.picking_line_id,
590: detail_type_code,
591: nvl(x_warehouse_id, pld.warehouse_id),
592: x_requested_quantity,

Line 1565: LAST_UPDATED_BY = fnd_global.user_id,

1561: DPW_ASSIGNED_FLAG = NULL,
1562: CONTAINER_ID = nvl(CONTAINER_ID,x_container_id),
1563: WAREHOUSE_ID = nvl(WAREHOUSE_ID,valid_warehouse_id),
1564: LAST_UPDATE_DATE = sysdate,
1565: LAST_UPDATED_BY = fnd_global.user_id,
1566: LAST_UPDATE_LOGIN = fnd_global.user_id
1567: WHERE PICKING_LINE_DETAIL_ID = new_pld_id;
1568:
1569: if sql%notfound then

Line 1566: LAST_UPDATE_LOGIN = fnd_global.user_id

1562: CONTAINER_ID = nvl(CONTAINER_ID,x_container_id),
1563: WAREHOUSE_ID = nvl(WAREHOUSE_ID,valid_warehouse_id),
1564: LAST_UPDATE_DATE = sysdate,
1565: LAST_UPDATED_BY = fnd_global.user_id,
1566: LAST_UPDATE_LOGIN = fnd_global.user_id
1567: WHERE PICKING_LINE_DETAIL_ID = new_pld_id;
1568:
1569: if sql%notfound then
1570: wsh_del_oi_core.println('Could not find record in PLD. pld:'||

Line 1824: X_Created_By := FND_GLOBAL.USER_ID;

1820: BEGIN
1821:
1822: error_code := '0';
1823: X_sysdate := sysdate;
1824: X_Created_By := FND_GLOBAL.USER_ID;
1825: X_login := FND_GLOBAL.LOGIN_ID;
1826: valid_cur_code := null;
1827:
1828: OPEN Freight_Charge_Cursor ;

Line 1825: X_login := FND_GLOBAL.LOGIN_ID;

1821:
1822: error_code := '0';
1823: X_sysdate := sysdate;
1824: X_Created_By := FND_GLOBAL.USER_ID;
1825: X_login := FND_GLOBAL.LOGIN_ID;
1826: valid_cur_code := null;
1827:
1828: OPEN Freight_Charge_Cursor ;
1829: