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 7275: last_updated_by = FND_GLOBAL.USER_ID,

7271: FORALL cnt IN 1..g_assign_detail_tab.COUNT
7272: UPDATE wsh_delivery_assignments_v
7273: SET PARENT_DELIVERY_DETAIL_ID = l_contlist(cnt),
7274: last_update_date = SYSDATE,
7275: last_updated_by = FND_GLOBAL.USER_ID,
7276: last_update_login = FND_GLOBAL.LOGIN_ID
7277: WHERE DELIVERY_DETAIL_ID = l_ddlist(cnt);
7278: l_mdc_id_tab.delete;
7279: l_mdc_index_i := l_ddlist.FIRST;

Line 7276: last_update_login = FND_GLOBAL.LOGIN_ID

7272: UPDATE wsh_delivery_assignments_v
7273: SET PARENT_DELIVERY_DETAIL_ID = l_contlist(cnt),
7274: last_update_date = SYSDATE,
7275: last_updated_by = FND_GLOBAL.USER_ID,
7276: last_update_login = FND_GLOBAL.LOGIN_ID
7277: WHERE DELIVERY_DETAIL_ID = l_ddlist(cnt);
7278: l_mdc_id_tab.delete;
7279: l_mdc_index_i := l_ddlist.FIRST;
7280: l_mdc_index_j := 0;

Line 7614: last_updated_by = FND_GLOBAL.USER_ID,

7610: FORALL cnt IN 1..g_new_contid_tab.COUNT
7611: UPDATE wsh_delivery_assignments_v
7612: SET delivery_id = l_dellist1(cnt),
7613: last_update_date = SYSDATE,
7614: last_updated_by = FND_GLOBAL.USER_ID,
7615: last_update_login = FND_GLOBAL.LOGIN_ID
7616: WHERE DELIVERY_DETAIL_ID = l_contlist1(cnt);
7617:
7618:

Line 7615: last_update_login = FND_GLOBAL.LOGIN_ID

7611: UPDATE wsh_delivery_assignments_v
7612: SET delivery_id = l_dellist1(cnt),
7613: last_update_date = SYSDATE,
7614: last_updated_by = FND_GLOBAL.USER_ID,
7615: last_update_login = FND_GLOBAL.LOGIN_ID
7616: WHERE DELIVERY_DETAIL_ID = l_contlist1(cnt);
7617:
7618:
7619: --

Line 7780: last_updated_by = FND_GLOBAL.USER_ID,

7776: SET NET_WEIGHT = l_NetWtlist(cnt),
7777: GROSS_WEIGHT = l_GrossWtlist(cnt),
7778: VOLUME = l_Vollist(cnt),
7779: last_update_date = SYSDATE,
7780: last_updated_by = FND_GLOBAL.USER_ID,
7781: last_update_login = FND_GLOBAL.LOGIN_ID
7782: WHERE DELIVERY_DETAIL_ID = l_ddlist(cnt);
7783:
7784: END IF; -- line_cont_tab.COUNT > 0

Line 7781: last_update_login = FND_GLOBAL.LOGIN_ID

7777: GROSS_WEIGHT = l_GrossWtlist(cnt),
7778: VOLUME = l_Vollist(cnt),
7779: last_update_date = SYSDATE,
7780: last_updated_by = FND_GLOBAL.USER_ID,
7781: last_update_login = FND_GLOBAL.LOGIN_ID
7782: WHERE DELIVERY_DETAIL_ID = l_ddlist(cnt);
7783:
7784: END IF; -- line_cont_tab.COUNT > 0
7785:

Line 12748: last_updated_by = FND_GLOBAL.USER_ID,

12744: party_id = l_dlvy_rec.party_id,
12745: ignore_for_planning = l_dlvy_rec.ignore_for_planning,
12746: tracking_number = NVL(p_waybill_number,tracking_number),
12747: last_update_date = SYSDATE,
12748: last_updated_by = FND_GLOBAL.USER_ID,
12749: last_update_login = FND_GLOBAL.LOGIN_ID
12750: WHERE rowid = l_rowid;
12751: --
12752: -- l_container_instance_id is the delivery_detail_id, use for DBI call

Line 12749: last_update_login = FND_GLOBAL.LOGIN_ID

12745: ignore_for_planning = l_dlvy_rec.ignore_for_planning,
12746: tracking_number = NVL(p_waybill_number,tracking_number),
12747: last_update_date = SYSDATE,
12748: last_updated_by = FND_GLOBAL.USER_ID,
12749: last_update_login = FND_GLOBAL.LOGIN_ID
12750: WHERE rowid = l_rowid;
12751: --
12752: -- l_container_instance_id is the delivery_detail_id, use for DBI call
12753: -- DBI Project

Line 12787: last_updated_by = FND_GLOBAL.USER_ID,

12783: --
12784: UPDATE wsh_delivery_assignments_v
12785: SET delivery_id = p_delivery_id,
12786: last_update_date = SYSDATE,
12787: last_updated_by = FND_GLOBAL.USER_ID,
12788: last_update_login = FND_GLOBAL.LOGIN_ID
12789: WHERE delivery_detail_id = l_container_instance_id;
12790: --
12791: --

Line 12788: last_update_login = FND_GLOBAL.LOGIN_ID

12784: UPDATE wsh_delivery_assignments_v
12785: SET delivery_id = p_delivery_id,
12786: last_update_date = SYSDATE,
12787: last_updated_by = FND_GLOBAL.USER_ID,
12788: last_update_login = FND_GLOBAL.LOGIN_ID
12789: WHERE delivery_detail_id = l_container_instance_id;
12790: --
12791: --
12792: -- Assign lines to container

Line 12798: last_updated_by = FND_GLOBAL.USER_ID,

12794: FORALL i IN p_lines_tbl.FIRST..p_lines_tbl.LAST
12795: UPDATE wsh_delivery_assignments_v
12796: SET parent_delivery_detail_id = l_container_instance_id,
12797: last_update_date = SYSDATE,
12798: last_updated_by = FND_GLOBAL.USER_ID,
12799: last_update_login = FND_GLOBAL.LOGIN_ID
12800: WHERE delivery_detail_id = p_lines_tbl(i);
12801: --
12802: --

Line 12799: last_update_login = FND_GLOBAL.LOGIN_ID

12795: UPDATE wsh_delivery_assignments_v
12796: SET parent_delivery_detail_id = l_container_instance_id,
12797: last_update_date = SYSDATE,
12798: last_updated_by = FND_GLOBAL.USER_ID,
12799: last_update_login = FND_GLOBAL.LOGIN_ID
12800: WHERE delivery_detail_id = p_lines_tbl(i);
12801: --
12802: --
12803: l_cont_tbl(1) := l_container_instance_id;

Line 13063: last_updated_by = FND_GLOBAL.USER_ID,

13059: --
13060: UPDATE wsh_delivery_assignments_v
13061: SET parent_delivery_detail_id = NULL,
13062: last_update_date = SYSDATE,
13063: last_updated_by = FND_GLOBAL.USER_ID,
13064: last_update_login = FND_GLOBAL.LOGIN_ID
13065: WHERE delivery_id = p_delivery_id;
13066: --
13067: --

Line 13064: last_update_login = FND_GLOBAL.LOGIN_ID

13060: UPDATE wsh_delivery_assignments_v
13061: SET parent_delivery_detail_id = NULL,
13062: last_update_date = SYSDATE,
13063: last_updated_by = FND_GLOBAL.USER_ID,
13064: last_update_login = FND_GLOBAL.LOGIN_ID
13065: WHERE delivery_id = p_delivery_id;
13066: --
13067: --
13068: IF l_num_errors > 0