eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_CONTAINER_ACTIONS dependencies on FND_GLOBAL

Line 7189: last_updated_by = FND_GLOBAL.USER_ID,

7185: FORALL cnt IN 1..g_assign_detail_tab.COUNT
7186: UPDATE wsh_delivery_assignments_v
7187: SET PARENT_DELIVERY_DETAIL_ID = l_contlist(cnt),
7188: last_update_date = SYSDATE,
7189: last_updated_by = FND_GLOBAL.USER_ID,
7190: last_update_login = FND_GLOBAL.LOGIN_ID
7191: WHERE DELIVERY_DETAIL_ID = l_ddlist(cnt);
7192: l_mdc_id_tab.delete;
7193: l_mdc_index_i := l_ddlist.FIRST;

Line 7190: last_update_login = FND_GLOBAL.LOGIN_ID

7186: UPDATE wsh_delivery_assignments_v
7187: SET PARENT_DELIVERY_DETAIL_ID = l_contlist(cnt),
7188: last_update_date = SYSDATE,
7189: last_updated_by = FND_GLOBAL.USER_ID,
7190: last_update_login = FND_GLOBAL.LOGIN_ID
7191: WHERE DELIVERY_DETAIL_ID = l_ddlist(cnt);
7192: l_mdc_id_tab.delete;
7193: l_mdc_index_i := l_ddlist.FIRST;
7194: l_mdc_index_j := 0;

Line 7484: last_updated_by = FND_GLOBAL.USER_ID,

7480: FORALL cnt IN 1..g_new_contid_tab.COUNT
7481: UPDATE wsh_delivery_assignments_v
7482: SET delivery_id = l_dellist1(cnt),
7483: last_update_date = SYSDATE,
7484: last_updated_by = FND_GLOBAL.USER_ID,
7485: last_update_login = FND_GLOBAL.LOGIN_ID
7486: WHERE DELIVERY_DETAIL_ID = l_contlist1(cnt);
7487:
7488: -- OTM R12 : assign delivery detail

Line 7485: last_update_login = FND_GLOBAL.LOGIN_ID

7481: UPDATE wsh_delivery_assignments_v
7482: SET delivery_id = l_dellist1(cnt),
7483: last_update_date = SYSDATE,
7484: last_updated_by = FND_GLOBAL.USER_ID,
7485: last_update_login = FND_GLOBAL.LOGIN_ID
7486: WHERE DELIVERY_DETAIL_ID = l_contlist1(cnt);
7487:
7488: -- OTM R12 : assign delivery detail
7489: IF (l_gc3_is_installed = 'Y') THEN

Line 7651: last_updated_by = FND_GLOBAL.USER_ID,

7647: SET NET_WEIGHT = l_NetWtlist(cnt),
7648: GROSS_WEIGHT = l_GrossWtlist(cnt),
7649: VOLUME = l_Vollist(cnt),
7650: last_update_date = SYSDATE,
7651: last_updated_by = FND_GLOBAL.USER_ID,
7652: last_update_login = FND_GLOBAL.LOGIN_ID
7653: WHERE DELIVERY_DETAIL_ID = l_ddlist(cnt);
7654:
7655: END IF; -- line_cont_tab.COUNT > 0

Line 7652: last_update_login = FND_GLOBAL.LOGIN_ID

7648: GROSS_WEIGHT = l_GrossWtlist(cnt),
7649: VOLUME = l_Vollist(cnt),
7650: last_update_date = SYSDATE,
7651: last_updated_by = FND_GLOBAL.USER_ID,
7652: last_update_login = FND_GLOBAL.LOGIN_ID
7653: WHERE DELIVERY_DETAIL_ID = l_ddlist(cnt);
7654:
7655: END IF; -- line_cont_tab.COUNT > 0
7656:

Line 12598: last_updated_by = FND_GLOBAL.USER_ID,

12594: party_id = l_dlvy_rec.party_id,
12595: ignore_for_planning = l_dlvy_rec.ignore_for_planning,
12596: tracking_number = NVL(p_waybill_number,tracking_number),
12597: last_update_date = SYSDATE,
12598: last_updated_by = FND_GLOBAL.USER_ID,
12599: last_update_login = FND_GLOBAL.LOGIN_ID
12600: WHERE rowid = l_rowid;
12601: --
12602: -- l_container_instance_id is the delivery_detail_id, use for DBI call

Line 12599: last_update_login = FND_GLOBAL.LOGIN_ID

12595: ignore_for_planning = l_dlvy_rec.ignore_for_planning,
12596: tracking_number = NVL(p_waybill_number,tracking_number),
12597: last_update_date = SYSDATE,
12598: last_updated_by = FND_GLOBAL.USER_ID,
12599: last_update_login = FND_GLOBAL.LOGIN_ID
12600: WHERE rowid = l_rowid;
12601: --
12602: -- l_container_instance_id is the delivery_detail_id, use for DBI call
12603: -- DBI Project

Line 12637: last_updated_by = FND_GLOBAL.USER_ID,

12633: --
12634: UPDATE wsh_delivery_assignments_v
12635: SET delivery_id = p_delivery_id,
12636: last_update_date = SYSDATE,
12637: last_updated_by = FND_GLOBAL.USER_ID,
12638: last_update_login = FND_GLOBAL.LOGIN_ID
12639: WHERE delivery_detail_id = l_container_instance_id;
12640: --
12641: --

Line 12638: last_update_login = FND_GLOBAL.LOGIN_ID

12634: UPDATE wsh_delivery_assignments_v
12635: SET delivery_id = p_delivery_id,
12636: last_update_date = SYSDATE,
12637: last_updated_by = FND_GLOBAL.USER_ID,
12638: last_update_login = FND_GLOBAL.LOGIN_ID
12639: WHERE delivery_detail_id = l_container_instance_id;
12640: --
12641: --
12642: -- Assign lines to container

Line 12648: last_updated_by = FND_GLOBAL.USER_ID,

12644: FORALL i IN p_lines_tbl.FIRST..p_lines_tbl.LAST
12645: UPDATE wsh_delivery_assignments_v
12646: SET parent_delivery_detail_id = l_container_instance_id,
12647: last_update_date = SYSDATE,
12648: last_updated_by = FND_GLOBAL.USER_ID,
12649: last_update_login = FND_GLOBAL.LOGIN_ID
12650: WHERE delivery_detail_id = p_lines_tbl(i);
12651: --
12652: --

Line 12649: last_update_login = FND_GLOBAL.LOGIN_ID

12645: UPDATE wsh_delivery_assignments_v
12646: SET parent_delivery_detail_id = l_container_instance_id,
12647: last_update_date = SYSDATE,
12648: last_updated_by = FND_GLOBAL.USER_ID,
12649: last_update_login = FND_GLOBAL.LOGIN_ID
12650: WHERE delivery_detail_id = p_lines_tbl(i);
12651: --
12652: --
12653: l_cont_tbl(1) := l_container_instance_id;

Line 12913: last_updated_by = FND_GLOBAL.USER_ID,

12909: --
12910: UPDATE wsh_delivery_assignments_v
12911: SET parent_delivery_detail_id = NULL,
12912: last_update_date = SYSDATE,
12913: last_updated_by = FND_GLOBAL.USER_ID,
12914: last_update_login = FND_GLOBAL.LOGIN_ID
12915: WHERE delivery_id = p_delivery_id;
12916: --
12917: --

Line 12914: last_update_login = FND_GLOBAL.LOGIN_ID

12910: UPDATE wsh_delivery_assignments_v
12911: SET parent_delivery_detail_id = NULL,
12912: last_update_date = SYSDATE,
12913: last_updated_by = FND_GLOBAL.USER_ID,
12914: last_update_login = FND_GLOBAL.LOGIN_ID
12915: WHERE delivery_id = p_delivery_id;
12916: --
12917: --
12918: IF l_num_errors > 0