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_ASN_RECEIPT_PVT dependencies on FND_GLOBAL

Line 794: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

790: SET gross_weight = NVL(gross_weight,0) - NVL(p_diff_gross_weight,0),
791: net_weight = NVL(net_weight,0) - NVL(p_diff_net_weight,0),
792: volume = NVL(volume,0) - NVL(p_diff_volume,0),
793: LAST_UPDATE_DATE = SYSDATE,
794: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
795: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
796: WHERE delivery_id = p_deliveryId;
797: --
798: --

Line 795: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

791: net_weight = NVL(net_weight,0) - NVL(p_diff_net_weight,0),
792: volume = NVL(volume,0) - NVL(p_diff_volume,0),
793: LAST_UPDATE_DATE = SYSDATE,
794: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
795: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
796: WHERE delivery_id = p_deliveryId;
797: --
798: --
799: IF l_debug_on THEN

Line 961: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

957: SET gross_weight = NVL(gross_weight,0) - NVL(p_diff_gross_weight,0),
958: net_weight = NVL(net_weight,0) - NVL(p_diff_net_weight,0),
959: filled_volume = NVL(filled_volume,0) - NVL(p_diff_volume,0),
960: LAST_UPDATE_DATE = SYSDATE,
961: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
962: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
963: WHERE delivery_detail_id = p_LPNId;
964: --
965: --

Line 962: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

958: net_weight = NVL(net_weight,0) - NVL(p_diff_net_weight,0),
959: filled_volume = NVL(filled_volume,0) - NVL(p_diff_volume,0),
960: LAST_UPDATE_DATE = SYSDATE,
961: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
962: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
963: WHERE delivery_detail_id = p_LPNId;
964: --
965: --
966: IF l_debug_on THEN

Line 2212: last_updated_by = FND_GLOBAL.USER_ID,

2208:
2209: update wsh_delivery_assignments_v
2210: set delivery_id = p_dd_rec.delivery_id_tab(i),
2211: last_update_date = SYSDATE,
2212: last_updated_by = FND_GLOBAL.USER_ID,
2213: last_update_login = FND_GLOBAL.LOGIN_ID
2214: where delivery_detail_id =
2215: p_line_rec.delivery_detail_id(p_dd_rec.shpmt_line_id_idx_tab(i));
2216: END IF;

Line 2213: last_update_login = FND_GLOBAL.LOGIN_ID

2209: update wsh_delivery_assignments_v
2210: set delivery_id = p_dd_rec.delivery_id_tab(i),
2211: last_update_date = SYSDATE,
2212: last_updated_by = FND_GLOBAL.USER_ID,
2213: last_update_login = FND_GLOBAL.LOGIN_ID
2214: where delivery_detail_id =
2215: p_line_rec.delivery_detail_id(p_dd_rec.shpmt_line_id_idx_tab(i));
2216: END IF;
2217: --

Line 2752: last_updated_by = FND_GLOBAL.USER_ID,

2748:
2749: update wsh_delivery_assignments_v
2750: set delivery_id = p_dd_rec.delivery_id_tab(i),
2751: last_update_date = SYSDATE,
2752: last_updated_by = FND_GLOBAL.USER_ID,
2753: last_update_login = FND_GLOBAL.LOGIN_ID
2754: where delivery_detail_id = p_line_rec.delivery_detail_id(p_dd_rec.shpmt_line_id_idx_tab(i));
2755: END IF;
2756: --

Line 2753: last_update_login = FND_GLOBAL.LOGIN_ID

2749: update wsh_delivery_assignments_v
2750: set delivery_id = p_dd_rec.delivery_id_tab(i),
2751: last_update_date = SYSDATE,
2752: last_updated_by = FND_GLOBAL.USER_ID,
2753: last_update_login = FND_GLOBAL.LOGIN_ID
2754: where delivery_detail_id = p_line_rec.delivery_detail_id(p_dd_rec.shpmt_line_id_idx_tab(i));
2755: END IF;
2756: --
2757: p_dd_rec.del_detail_id_tab(i) := p_line_rec.delivery_detail_id(p_dd_rec.shpmt_line_id_idx_tab(i));

Line 3309: last_updated_by = FND_GLOBAL.USER_ID,

3305: volume = NVL(l_update_dd_rec.volume(i), volume),
3306: earliest_pickup_date = NVL(earliest_pickup_date, l_update_dd_rec.shipped_date(i)),
3307: latest_pickup_date = NVL(latest_pickup_date, l_update_dd_rec.shipped_date(i)),
3308: last_update_date = SYSDATE,
3309: last_updated_by = FND_GLOBAL.USER_ID,
3310: last_update_login = FND_GLOBAL.LOGIN_ID
3311: where delivery_detail_id = l_update_dd_rec.delivery_detail_id(i)
3312: and released_status = l_update_dd_rec.released_status_db(i)
3313: AND last_update_date = NVL(l_update_dd_rec.last_update_date(i), last_update_date)

Line 3310: last_update_login = FND_GLOBAL.LOGIN_ID

3306: earliest_pickup_date = NVL(earliest_pickup_date, l_update_dd_rec.shipped_date(i)),
3307: latest_pickup_date = NVL(latest_pickup_date, l_update_dd_rec.shipped_date(i)),
3308: last_update_date = SYSDATE,
3309: last_updated_by = FND_GLOBAL.USER_ID,
3310: last_update_login = FND_GLOBAL.LOGIN_ID
3311: where delivery_detail_id = l_update_dd_rec.delivery_detail_id(i)
3312: and released_status = l_update_dd_rec.released_status_db(i)
3313: AND last_update_date = NVL(l_update_dd_rec.last_update_date(i), last_update_date)
3314: RETURNING delivery_detail_id BULK COLLECT INTO l_detail_tab;

Line 3890: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

3886: shipped_quantity2 = NULL,
3887: received_quantity2 = NULL,
3888: rcv_shipment_line_id = NULL,
3889: LAST_UPDATE_DATE = SYSDATE,
3890: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
3891: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
3892: where delivery_detail_id in (select wdd.delivery_detail_id
3893: from wsh_delivery_details wdd,
3894: wsh_delivery_assignments_v wda,

Line 3891: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

3887: received_quantity2 = NULL,
3888: rcv_shipment_line_id = NULL,
3889: LAST_UPDATE_DATE = SYSDATE,
3890: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
3891: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
3892: where delivery_detail_id in (select wdd.delivery_detail_id
3893: from wsh_delivery_details wdd,
3894: wsh_delivery_assignments_v wda,
3895: wsh_new_deliveries wnd

Line 5007: last_updated_by = FND_GLOBAL.USER_ID,

5003: FORALL i in l_new_trip_ids.FIRST..l_new_trip_ids.LAST
5004: UPDATE WSH_TRIPS
5005: SET carrier_id = l_carrier_id,
5006: last_update_date = SYSDATE,
5007: last_updated_by = FND_GLOBAL.USER_ID,
5008: last_update_login = FND_GLOBAL.LOGIN_ID
5009: WHERE trip_id = l_new_trip_ids(i);
5010: END IF;
5011:

Line 5008: last_update_login = FND_GLOBAL.LOGIN_ID

5004: UPDATE WSH_TRIPS
5005: SET carrier_id = l_carrier_id,
5006: last_update_date = SYSDATE,
5007: last_updated_by = FND_GLOBAL.USER_ID,
5008: last_update_login = FND_GLOBAL.LOGIN_ID
5009: WHERE trip_id = l_new_trip_ids(i);
5010: END IF;
5011:
5012: --collecting unique del ids into a table from a non-contiguous table, to be passed to

Line 6225: last_updated_by = FND_GLOBAL.USER_ID,

6221: IF ((p_bol IS NOT NULL) AND (nvl(p_bol,'$$$$') <> nvl(l_bol,'$$$$'))) THEN
6222: UPDATE wsh_document_instances
6223: SET sequence_number = p_bol,
6224: last_update_date = SYSDATE,
6225: last_updated_by = FND_GLOBAL.USER_ID,
6226: last_update_login = FND_GLOBAL.LOGIN_ID
6227: WHERE entity_name = 'WSH_DELIVERY_LEGS'
6228: AND entity_id = l_delivery_leg_id
6229: AND document_type= 'BOL';

Line 6226: last_update_login = FND_GLOBAL.LOGIN_ID

6222: UPDATE wsh_document_instances
6223: SET sequence_number = p_bol,
6224: last_update_date = SYSDATE,
6225: last_updated_by = FND_GLOBAL.USER_ID,
6226: last_update_login = FND_GLOBAL.LOGIN_ID
6227: WHERE entity_name = 'WSH_DELIVERY_LEGS'
6228: AND entity_id = l_delivery_leg_id
6229: AND document_type= 'BOL';
6230: END IF;

Line 6489: last_updated_by = FND_GLOBAL.USER_ID,

6485: ship_method_code = decode(l_update_smc_flag, 'Y', NULL,nvl(l_ship_method_code, ship_method_code)),
6486: service_level = decode(l_update_smc_flag, 'Y', NULL,service_level),
6487: mode_of_transport = decode(l_update_smc_flag, 'Y', NULL,mode_of_transport),
6488: last_update_date = SYSDATE,
6489: last_updated_by = FND_GLOBAL.USER_ID,
6490: last_update_login = FND_GLOBAL.LOGIN_ID
6491: Where DELIVERY_ID = p_del_ids(i)
6492: RETURNING organization_id into l_organization_id ;
6493:

Line 6490: last_update_login = FND_GLOBAL.LOGIN_ID

6486: service_level = decode(l_update_smc_flag, 'Y', NULL,service_level),
6487: mode_of_transport = decode(l_update_smc_flag, 'Y', NULL,mode_of_transport),
6488: last_update_date = SYSDATE,
6489: last_updated_by = FND_GLOBAL.USER_ID,
6490: last_update_login = FND_GLOBAL.LOGIN_ID
6491: Where DELIVERY_ID = p_del_ids(i)
6492: RETURNING organization_id into l_organization_id ;
6493:
6494: /*CURRENTLY NOT IN USE

Line 6515: last_updated_by = FND_GLOBAL.USER_ID,

6511: UPDATE WSH_NEW_DELIVERIES
6512: SET status_code = 'OP',
6513: Asn_shipment_header_id = NULL,
6514: last_update_date = SYSDATE,
6515: last_updated_by = FND_GLOBAL.USER_ID,
6516: last_update_login = FND_GLOBAL.LOGIN_ID
6517: Where DELIVERY_ID = p_del_ids(i)
6518: RETURNING organization_id into l_organization_id ;
6519:

Line 6516: last_update_login = FND_GLOBAL.LOGIN_ID

6512: SET status_code = 'OP',
6513: Asn_shipment_header_id = NULL,
6514: last_update_date = SYSDATE,
6515: last_updated_by = FND_GLOBAL.USER_ID,
6516: last_update_login = FND_GLOBAL.LOGIN_ID
6517: Where DELIVERY_ID = p_del_ids(i)
6518: RETURNING organization_id into l_organization_id ;
6519:
6520: /*CURRENTLY NOT IN USE

Line 6587: last_updated_by = FND_GLOBAL.USER_ID,

6583: ship_method_code = decode(l_update_smc_flag, 'Y', NULL,nvl(l_ship_method_code, ship_method_code)),
6584: service_level = decode(l_update_smc_flag, 'Y', NULL,service_level),
6585: mode_of_transport = decode(l_update_smc_flag, 'Y', NULL,mode_of_transport),
6586: last_update_date = SYSDATE,
6587: last_updated_by = FND_GLOBAL.USER_ID,
6588: last_update_login = FND_GLOBAL.LOGIN_ID
6589: Where DELIVERY_ID = p_del_ids(i)
6590: RETURNING organization_id into l_organization_id ;
6591:

Line 6588: last_update_login = FND_GLOBAL.LOGIN_ID

6584: service_level = decode(l_update_smc_flag, 'Y', NULL,service_level),
6585: mode_of_transport = decode(l_update_smc_flag, 'Y', NULL,mode_of_transport),
6586: last_update_date = SYSDATE,
6587: last_updated_by = FND_GLOBAL.USER_ID,
6588: last_update_login = FND_GLOBAL.LOGIN_ID
6589: Where DELIVERY_ID = p_del_ids(i)
6590: RETURNING organization_id into l_organization_id ;
6591:
6592: /*CURRENTLY NOT IN USE

Line 7626: last_updated_by = FND_GLOBAL.USER_ID,

7622: UPDATE wsh_document_instances
7623: SET
7624: sequence_number = l_psno,
7625: last_update_date = SYSDATE,
7626: last_updated_by = FND_GLOBAL.USER_ID,
7627: last_update_login = FND_GLOBAL.LOGIN_ID
7628: where
7629: entity_id = l_stored_del_id
7630: AND entity_name = 'WSH_NEW_DELIVERIES'

Line 7627: last_update_login = FND_GLOBAL.LOGIN_ID

7623: SET
7624: sequence_number = l_psno,
7625: last_update_date = SYSDATE,
7626: last_updated_by = FND_GLOBAL.USER_ID,
7627: last_update_login = FND_GLOBAL.LOGIN_ID
7628: where
7629: entity_id = l_stored_del_id
7630: AND entity_name = 'WSH_NEW_DELIVERIES'
7631: AND document_type= 'PACK_TYPE';

Line 7671: last_updated_by = FND_GLOBAL.USER_ID,

7667: wsh_new_deliveries
7668: SET
7669: waybill = l_waybill,
7670: last_update_date = SYSDATE,
7671: last_updated_by = FND_GLOBAL.USER_ID,
7672: last_update_login = FND_GLOBAL.LOGIN_ID
7673: WHERE
7674: delivery_id = l_stored_del_id;
7675: END IF;

Line 7672: last_update_login = FND_GLOBAL.LOGIN_ID

7668: SET
7669: waybill = l_waybill,
7670: last_update_date = SYSDATE,
7671: last_updated_by = FND_GLOBAL.USER_ID,
7672: last_update_login = FND_GLOBAL.LOGIN_ID
7673: WHERE
7674: delivery_id = l_stored_del_id;
7675: END IF;
7676:

Line 7936: last_updated_by = FND_GLOBAL.USER_ID,

7932:
7933: UPDATE wsh_document_instances
7934: SET sequence_number = p_document_number,
7935: last_update_date = SYSDATE,
7936: last_updated_by = FND_GLOBAL.USER_ID,
7937: last_update_login = FND_GLOBAL.LOGIN_ID
7938: WHERE entity_name = p_entity_name
7939: AND entity_id = l_entity_id
7940: AND document_type= l_document_type;

Line 7937: last_update_login = FND_GLOBAL.LOGIN_ID

7933: UPDATE wsh_document_instances
7934: SET sequence_number = p_document_number,
7935: last_update_date = SYSDATE,
7936: last_updated_by = FND_GLOBAL.USER_ID,
7937: last_update_login = FND_GLOBAL.LOGIN_ID
7938: WHERE entity_name = p_entity_name
7939: AND entity_id = l_entity_id
7940: AND document_type= l_document_type;
7941:

Line 8006: , fnd_global.user_id

8002: , null
8003: , p_entity_name
8004: , l_entity_id
8005: , l_doc_sequence_category_id
8006: , fnd_global.user_id
8007: , sysdate
8008: , fnd_global.user_id
8009: , sysdate
8010: , fnd_global.login_id

Line 8008: , fnd_global.user_id

8004: , l_entity_id
8005: , l_doc_sequence_category_id
8006: , fnd_global.user_id
8007: , sysdate
8008: , fnd_global.user_id
8009: , sysdate
8010: , fnd_global.login_id
8011: , l_appl_num --Bug# 3789154
8012: , null

Line 8010: , fnd_global.login_id

8006: , fnd_global.user_id
8007: , sysdate
8008: , fnd_global.user_id
8009: , sysdate
8010: , fnd_global.login_id
8011: , l_appl_num --Bug# 3789154
8012: , null
8013: , null
8014: , null