DBA Data[Home] [Help]

APPS.WSH_USA_ACTIONS_PVT dependencies on FND_GLOBAL

Line 612: last_updated_by = FND_GLOBAL.USER_ID,

608: AND (l_prev_source_line_id <> p_changed_attributes(l_counter).original_source_line_id) THEN
609: UPDATE WSH_DELIVERY_DETAILS
610: SET source_line_set_id = p_changed_attributes(l_counter).source_line_set_id,
611: last_update_date = SYSDATE,
612: last_updated_by = FND_GLOBAL.USER_ID,
613: last_update_login = FND_GLOBAL.LOGIN_ID
614: WHERE source_line_id = p_changed_attributes(l_counter).original_source_line_id
615: AND source_code = p_source_code
616: AND container_flag = 'N'

Line 613: last_update_login = FND_GLOBAL.LOGIN_ID

609: UPDATE WSH_DELIVERY_DETAILS
610: SET source_line_set_id = p_changed_attributes(l_counter).source_line_set_id,
611: last_update_date = SYSDATE,
612: last_updated_by = FND_GLOBAL.USER_ID,
613: last_update_login = FND_GLOBAL.LOGIN_ID
614: WHERE source_line_id = p_changed_attributes(l_counter).original_source_line_id
615: AND source_code = p_source_code
616: AND container_flag = 'N'
617: AND released_status <> 'D';

Line 720: last_updated_by = FND_GLOBAL.USER_ID,

716: --
717: UPDATE WSH_DELIVERY_DETAILS
718: SET source_line_id = p_changed_attributes(l_counter).source_line_id,
719: last_update_date = SYSDATE,
720: last_updated_by = FND_GLOBAL.USER_ID,
721: last_update_login = FND_GLOBAL.LOGIN_ID
722: WHERE delivery_detail_id = c.delivery_detail_id;
723:
724: --wrudge

Line 721: last_update_login = FND_GLOBAL.LOGIN_ID

717: UPDATE WSH_DELIVERY_DETAILS
718: SET source_line_id = p_changed_attributes(l_counter).source_line_id,
719: last_update_date = SYSDATE,
720: last_updated_by = FND_GLOBAL.USER_ID,
721: last_update_login = FND_GLOBAL.LOGIN_ID
722: WHERE delivery_detail_id = c.delivery_detail_id;
723:
724: --wrudge
725: -- bug 2121426: keep track of reservation quantity to transfer

Line 2664: last_updated_by = FND_GLOBAL.USER_ID,

2660: nvl(l_ignore_for_planning,nvl(ignore_for_planning,'N'))),
2661: -- Bug 3244272 : Added laste_update_date and last_updated_by in the
2662: -- update statement.
2663: last_update_date = SYSDATE,
2664: last_updated_by = FND_GLOBAL.USER_ID,
2665: last_update_login = FND_GLOBAL.LOGIN_ID
2666: WHERE source_code = p_source_code
2667: AND source_line_id = p_attributes_rec.source_line_id
2668: AND container_flag = 'N'

Line 2665: last_update_login = FND_GLOBAL.LOGIN_ID

2661: -- Bug 3244272 : Added laste_update_date and last_updated_by in the
2662: -- update statement.
2663: last_update_date = SYSDATE,
2664: last_updated_by = FND_GLOBAL.USER_ID,
2665: last_update_login = FND_GLOBAL.LOGIN_ID
2666: WHERE source_code = p_source_code
2667: AND source_line_id = p_attributes_rec.source_line_id
2668: AND container_flag = 'N'
2669: AND delivery_detail_id = decode( p_attributes_rec.delivery_detail_id, FND_API.G_MISS_NUM ,