DBA Data[Home] [Help]

APPS.WSH_PO_CMG_PVT dependencies on FND_GLOBAL

Line 1015: last_updated_by = FND_GLOBAL.USER_ID,

1011: END IF;
1012: update wsh_delivery_details
1013: set shipping_control = p_line_rec.shipping_control(p_line_rec_index),
1014: last_update_date = SYSDATE,
1015: last_updated_by = FND_GLOBAL.USER_ID,
1016: last_update_login = FND_GLOBAL.LOGIN_ID
1017: WHERE po_shipment_line_id = p_line_rec.po_shipment_line_id(p_line_rec_index)
1018: AND source_header_id = p_line_rec.header_id(p_line_rec_index) AND
1019: source_line_id = p_line_rec.line_id(p_line_rec_index) AND

Line 1016: last_update_login = FND_GLOBAL.LOGIN_ID

1012: update wsh_delivery_details
1013: set shipping_control = p_line_rec.shipping_control(p_line_rec_index),
1014: last_update_date = SYSDATE,
1015: last_updated_by = FND_GLOBAL.USER_ID,
1016: last_update_login = FND_GLOBAL.LOGIN_ID
1017: WHERE po_shipment_line_id = p_line_rec.po_shipment_line_id(p_line_rec_index)
1018: AND source_header_id = p_line_rec.header_id(p_line_rec_index) AND
1019: source_line_id = p_line_rec.line_id(p_line_rec_index) AND
1020: source_code = 'PO' AND

Line 1048: last_updated_by = FND_GLOBAL.USER_ID,

1044:
1045: update wsh_delivery_details
1046: set shipping_control = p_line_rec.shipping_control(p_line_rec_index),
1047: last_update_date = SYSDATE,
1048: last_updated_by = FND_GLOBAL.USER_ID,
1049: last_update_login = FND_GLOBAL.LOGIN_ID
1050: WHERE po_shipment_line_id = p_line_rec.po_shipment_line_id(p_line_rec_index)
1051: AND source_header_id = p_line_rec.header_id(p_line_rec_index) AND
1052: source_line_id = p_line_rec.line_id(p_line_rec_index) AND

Line 1049: last_update_login = FND_GLOBAL.LOGIN_ID

1045: update wsh_delivery_details
1046: set shipping_control = p_line_rec.shipping_control(p_line_rec_index),
1047: last_update_date = SYSDATE,
1048: last_updated_by = FND_GLOBAL.USER_ID,
1049: last_update_login = FND_GLOBAL.LOGIN_ID
1050: WHERE po_shipment_line_id = p_line_rec.po_shipment_line_id(p_line_rec_index)
1051: AND source_header_id = p_line_rec.header_id(p_line_rec_index) AND
1052: source_line_id = p_line_rec.line_id(p_line_rec_index) AND
1053: source_code = 'PO' AND

Line 1517: last_updated_by = FND_GLOBAL.USER_ID,

1513: release_revision_number=p_line_rec.release_revision(p_line_rec_index),
1514: po_shipment_line_number=p_line_rec.po_shipment_line_number(p_line_rec_index),
1515: source_blanket_reference_num=p_line_rec.source_blanket_reference_num(p_line_rec_index),
1516: last_update_date = SYSDATE,
1517: last_updated_by = FND_GLOBAL.USER_ID,
1518: last_update_login = FND_GLOBAL.LOGIN_ID
1519: WHERE po_shipment_line_id = p_line_rec.po_shipment_line_id(p_line_rec_index) AND
1520: delivery_detail_id = nvl(p_dd_id,delivery_detail_id)
1521: AND source_header_id = p_line_rec.header_id(p_line_rec_index) AND

Line 1518: last_update_login = FND_GLOBAL.LOGIN_ID

1514: po_shipment_line_number=p_line_rec.po_shipment_line_number(p_line_rec_index),
1515: source_blanket_reference_num=p_line_rec.source_blanket_reference_num(p_line_rec_index),
1516: last_update_date = SYSDATE,
1517: last_updated_by = FND_GLOBAL.USER_ID,
1518: last_update_login = FND_GLOBAL.LOGIN_ID
1519: WHERE po_shipment_line_id = p_line_rec.po_shipment_line_id(p_line_rec_index) AND
1520: delivery_detail_id = nvl(p_dd_id,delivery_detail_id)
1521: AND source_header_id = p_line_rec.header_id(p_line_rec_index) AND
1522: source_line_id = p_line_rec.line_id(p_line_rec_index) ANd

Line 2341: last_updated_by = FND_GLOBAL.USER_ID,

2337: requested_quantity_uom = decode(l_new_req_qty_uom,NULL,requested_quantity_uom,l_new_req_qty_uom), --HACMS
2338: cancelled_quantity = nvl(cancelled_quantity,0) + nvl(l_cancelled_qty,0), --HACMS
2339: released_status = l_released_status,
2340: last_update_date = SYSDATE,
2341: last_updated_by = FND_GLOBAL.USER_ID,
2342: last_update_login = FND_GLOBAL.LOGIN_ID
2343: WHERE
2344: delivery_detail_id = v_lines_without_rr.delivery_detail_id AND
2345: po_shipment_line_id = p_line_rec.po_shipment_line_id(i) AND

Line 2342: last_update_login = FND_GLOBAL.LOGIN_ID

2338: cancelled_quantity = nvl(cancelled_quantity,0) + nvl(l_cancelled_qty,0), --HACMS
2339: released_status = l_released_status,
2340: last_update_date = SYSDATE,
2341: last_updated_by = FND_GLOBAL.USER_ID,
2342: last_update_login = FND_GLOBAL.LOGIN_ID
2343: WHERE
2344: delivery_detail_id = v_lines_without_rr.delivery_detail_id AND
2345: po_shipment_line_id = p_line_rec.po_shipment_line_id(i) AND
2346: source_header_id = p_line_rec.header_id(i) AND

Line 2653: last_updated_by = FND_GLOBAL.USER_ID,

2649: ignore_for_planning = l_ignore_for_planning,
2650: ship_from_location_id = l_ship_from_location_id,
2651: routing_req_id = l_routing_request_id,
2652: last_update_date = SYSDATE,
2653: last_updated_by = FND_GLOBAL.USER_ID,
2654: last_update_login = FND_GLOBAL.LOGIN_ID
2655: WHERE
2656: delivery_detail_id = v_lines_with_rr.delivery_detail_id AND
2657: po_shipment_line_id = p_line_rec.po_shipment_line_id(i) AND

Line 2654: last_update_login = FND_GLOBAL.LOGIN_ID

2650: ship_from_location_id = l_ship_from_location_id,
2651: routing_req_id = l_routing_request_id,
2652: last_update_date = SYSDATE,
2653: last_updated_by = FND_GLOBAL.USER_ID,
2654: last_update_login = FND_GLOBAL.LOGIN_ID
2655: WHERE
2656: delivery_detail_id = v_lines_with_rr.delivery_detail_id AND
2657: po_shipment_line_id = p_line_rec.po_shipment_line_id(i) AND
2658: source_header_id = p_line_rec.header_id(i) AND

Line 2891: last_updated_by = FND_GLOBAL.USER_ID,

2887: SET
2888: requested_quantity = l_requested_qty + l_qty_to_change,
2889: requested_quantity_uom = decode(l_new_req_qty_uom,NULL,requested_quantity_uom,l_new_req_qty_uom), --HACMS
2890: last_update_date = SYSDATE,
2891: last_updated_by = FND_GLOBAL.USER_ID,
2892: last_update_login = FND_GLOBAL.LOGIN_ID
2893: WHERE delivery_detail_id = l_delivery_detail_id AND
2894: po_shipment_line_id = p_line_rec.po_shipment_line_id(i) AND
2895: source_header_id = p_line_rec.header_id(i) AND

Line 2892: last_update_login = FND_GLOBAL.LOGIN_ID

2888: requested_quantity = l_requested_qty + l_qty_to_change,
2889: requested_quantity_uom = decode(l_new_req_qty_uom,NULL,requested_quantity_uom,l_new_req_qty_uom), --HACMS
2890: last_update_date = SYSDATE,
2891: last_updated_by = FND_GLOBAL.USER_ID,
2892: last_update_login = FND_GLOBAL.LOGIN_ID
2893: WHERE delivery_detail_id = l_delivery_detail_id AND
2894: po_shipment_line_id = p_line_rec.po_shipment_line_id(i) AND
2895: source_header_id = p_line_rec.header_id(i) AND
2896: source_line_id = p_line_rec.line_id(i) ANd

Line 3160: last_updated_by = FND_GLOBAL.USER_ID,

3156: set requested_quantity = l_qty_to_change,
3157: requested_quantity_uom = p_line_rec.requested_quantity_uom(i),
3158: picked_quantity = decode(l_pick_qty,null,picked_quantity,l_pick_qty) ,
3159: last_update_date = SYSDATE,
3160: last_updated_by = FND_GLOBAL.USER_ID,
3161: last_update_login = FND_GLOBAL.LOGIN_ID
3162: WHERE delivery_detail_id = v_lines.delivery_detail_id AND
3163: po_shipment_line_id = p_line_rec.po_shipment_line_id(i) AND
3164: source_header_id = p_line_rec.header_id(i) AND

Line 3161: last_update_login = FND_GLOBAL.LOGIN_ID

3157: requested_quantity_uom = p_line_rec.requested_quantity_uom(i),
3158: picked_quantity = decode(l_pick_qty,null,picked_quantity,l_pick_qty) ,
3159: last_update_date = SYSDATE,
3160: last_updated_by = FND_GLOBAL.USER_ID,
3161: last_update_login = FND_GLOBAL.LOGIN_ID
3162: WHERE delivery_detail_id = v_lines.delivery_detail_id AND
3163: po_shipment_line_id = p_line_rec.po_shipment_line_id(i) AND
3164: source_header_id = p_line_rec.header_id(i) AND
3165: source_line_id = p_line_rec.line_id(i) ANd

Line 3239: last_updated_by = FND_GLOBAL.USER_ID,

3235: --HACMS
3236: source_line_number = p_line_rec.source_line_number(i),
3237: po_shipment_line_number = p_line_rec.po_shipment_line_number(i),
3238: last_update_date = SYSDATE,
3239: last_updated_by = FND_GLOBAL.USER_ID,
3240: last_update_login = FND_GLOBAL.LOGIN_ID
3241: where source_code = 'PO'
3242: AND po_shipment_line_id = p_line_rec.po_shipment_line_id(i)
3243: AND source_header_id = p_line_rec.header_id(i)

Line 3240: last_update_login = FND_GLOBAL.LOGIN_ID

3236: source_line_number = p_line_rec.source_line_number(i),
3237: po_shipment_line_number = p_line_rec.po_shipment_line_number(i),
3238: last_update_date = SYSDATE,
3239: last_updated_by = FND_GLOBAL.USER_ID,
3240: last_update_login = FND_GLOBAL.LOGIN_ID
3241: where source_code = 'PO'
3242: AND po_shipment_line_id = p_line_rec.po_shipment_line_id(i)
3243: AND source_header_id = p_line_rec.header_id(i)
3244: AND source_line_id = p_line_rec.line_id(i)

Line 3560: last_updated_by = FND_GLOBAL.USER_ID,

3556: cancelled_quantity = req_qty_tab(i),
3557: cancelled_quantity2 = req_qty2_tab(i),
3558: released_status = 'D',
3559: last_update_date = SYSDATE,
3560: last_updated_by = FND_GLOBAL.USER_ID,
3561: last_update_login = FND_GLOBAL.LOGIN_ID
3562: WHERE
3563: delivery_detail_id = dd_ids_tab(i) AND
3564: released_status = 'X'

Line 3561: last_update_login = FND_GLOBAL.LOGIN_ID

3557: cancelled_quantity2 = req_qty2_tab(i),
3558: released_status = 'D',
3559: last_update_date = SYSDATE,
3560: last_updated_by = FND_GLOBAL.USER_ID,
3561: last_update_login = FND_GLOBAL.LOGIN_ID
3562: WHERE
3563: delivery_detail_id = dd_ids_tab(i) AND
3564: released_status = 'X'
3565: RETURNING delivery_detail_id BULK COLLECT INTO l_detail_tab; -- Added for DBI Project

Line 3575: last_updated_by = FND_GLOBAL.USER_ID,

3571: FORALL i IN dd_ids_tab.FIRST..dd_ids_tab.LAST
3572: UPDATE wsh_delivery_details
3573: SET released_status = 'L',
3574: last_update_date = SYSDATE,
3575: last_updated_by = FND_GLOBAL.USER_ID,
3576: last_update_login = FND_GLOBAL.LOGIN_ID
3577: WHERE delivery_detail_id = dd_ids_tab(i) AND
3578: released_status = 'X'
3579: RETURNING delivery_detail_id BULK COLLECT INTO l_detail_tab; -- Added for DBI Project

Line 3576: last_update_login = FND_GLOBAL.LOGIN_ID

3572: UPDATE wsh_delivery_details
3573: SET released_status = 'L',
3574: last_update_date = SYSDATE,
3575: last_updated_by = FND_GLOBAL.USER_ID,
3576: last_update_login = FND_GLOBAL.LOGIN_ID
3577: WHERE delivery_detail_id = dd_ids_tab(i) AND
3578: released_status = 'X'
3579: RETURNING delivery_detail_id BULK COLLECT INTO l_detail_tab; -- Added for DBI Project
3580:

Line 3988: p_logging_entity_id => FND_GLOBAL.USER_ID,

3984: x_msg_count => l_exception_msg_count,
3985: x_msg_data => l_exception_msg_data,
3986: x_exception_id => l_dummy_exception_id ,
3987: p_logging_entity => 'SHIPPER',
3988: p_logging_entity_id => FND_GLOBAL.USER_ID,
3989: p_exception_name => p_exception_name,
3990: p_logged_at_location_id => p_location_id,
3991: p_exception_location_id => p_location_id,
3992: p_message => p_message,

Line 4022: p_logging_entity_id => FND_GLOBAL.USER_ID,

4018: x_msg_count => l_exception_msg_count,
4019: x_msg_data => l_exception_msg_data,
4020: x_exception_id => l_dummy_exception_id ,
4021: p_logging_entity => 'SHIPPER',
4022: p_logging_entity_id => FND_GLOBAL.USER_ID,
4023: p_exception_name => p_exception_name,
4024: p_logged_at_location_id => p_location_id,
4025: p_exception_location_id => p_location_id,
4026: p_message => p_message,

Line 4050: p_logging_entity_id => FND_GLOBAL.USER_ID,

4046: x_msg_count => l_exception_msg_count,
4047: x_msg_data => l_exception_msg_data,
4048: x_exception_id => l_dummy_exception_id ,
4049: p_logging_entity => 'SHIPPER',
4050: p_logging_entity_id => FND_GLOBAL.USER_ID,
4051: p_exception_name => p_exception_name,
4052: p_logged_at_location_id => p_location_id,
4053: p_exception_location_id => p_location_id,
4054: p_message => p_message,