DBA Data[Home] [Help]

APPS.WSH_SHIP_CONFIRM_ACTIONS dependencies on FND_GLOBAL

Line 826: FND_GLOBAL.USER_ID,

822: l_quantity(i),
823: l_fm_serial_number(i),
824: l_to_serial_number(i),
825: sysdate,
826: FND_GLOBAL.USER_ID,
827: sysdate,
828: FND_GLOBAL.USER_ID,
829: l_attribute_category(i), -- Bug 3628620
830: l_attribute1(i), l_attribute2(i), l_attribute3(i),

Line 828: FND_GLOBAL.USER_ID,

824: l_to_serial_number(i),
825: sysdate,
826: FND_GLOBAL.USER_ID,
827: sysdate,
828: FND_GLOBAL.USER_ID,
829: l_attribute_category(i), -- Bug 3628620
830: l_attribute1(i), l_attribute2(i), l_attribute3(i),
831: l_attribute4(i), l_attribute5(i), l_attribute6(i),
832: l_attribute7(i), l_attribute8(i), l_attribute9(i),

Line 875: request_id = fnd_global.conc_request_id,

871: UPDATE wsh_delivery_details
872: SET serial_number = NULL,
873: --Added as part of bug 7645262
874: last_update_date = sysdate,
875: request_id = fnd_global.conc_request_id,
876: last_updated_by = fnd_global.user_id,
877: transaction_temp_id = l_transaction_temp_id(i)
878: WHERE delivery_detail_id = l_delivery_detail_id(i);
879:

Line 876: last_updated_by = fnd_global.user_id,

872: SET serial_number = NULL,
873: --Added as part of bug 7645262
874: last_update_date = sysdate,
875: request_id = fnd_global.conc_request_id,
876: last_updated_by = fnd_global.user_id,
877: transaction_temp_id = l_transaction_temp_id(i)
878: WHERE delivery_detail_id = l_delivery_detail_id(i);
879:
880: upd_rows := upd_rows + sql%rowcount;

Line 2032: request_id = fnd_global.conc_request_id,

2028:
2029: -- mark stop as being processed; refresh its LAST_UPDATED info.
2030: UPDATE wsh_trip_stops
2031: SET pending_interface_flag = 'P',
2032: request_id = fnd_global.conc_request_id,
2033: last_updated_by = fnd_global.user_id,
2034: last_update_date = sysdate,
2035: batch_id = l_stop_batch_id
2036: WHERE stop_id = l_stop_id;

Line 2033: last_updated_by = fnd_global.user_id,

2029: -- mark stop as being processed; refresh its LAST_UPDATED info.
2030: UPDATE wsh_trip_stops
2031: SET pending_interface_flag = 'P',
2032: request_id = fnd_global.conc_request_id,
2033: last_updated_by = fnd_global.user_id,
2034: last_update_date = sysdate,
2035: batch_id = l_stop_batch_id
2036: WHERE stop_id = l_stop_id;
2037:

Line 2458: last_updated_by = fnd_global.user_id,

2454: IF l_found THEN
2455: l_action := 'updating';
2456: UPDATE wsh_trip_stops
2457: SET pending_interface_flag = l_new_flag,
2458: last_updated_by = fnd_global.user_id,
2459: last_update_date = sysdate
2460: WHERE batch_id = l_stop_batch_id;
2461: END IF;
2462:

Line 2645: wts.last_updated_by = fnd_global.user_id,

2641: END IF;
2642:
2643: UPDATE wsh_trip_stops wts
2644: SET wts.pending_interface_flag = 'Y',
2645: wts.last_updated_by = fnd_global.user_id,
2646: wts.last_update_date = sysdate
2647: WHERE wts.pending_interface_flag = 'P'
2648: AND EXISTS (SELECT 'request completed'
2649: FROM fnd_concurrent_requests fcr

Line 4804: request_id = fnd_global.conc_request_id,

4800: UPDATE wsh_delivery_details
4801: SET inv_interfaced_flag = c_inv_int_full ,
4802: --Added as part of bug 7645262
4803: last_update_date = sysdate,
4804: request_id = fnd_global.conc_request_id,
4805: last_updated_by = fnd_global.user_id
4806:
4807: WHERE delivery_detail_id = l_delivery_detail_tbl(i)
4808: AND container_flag = 'N';

Line 4805: last_updated_by = fnd_global.user_id

4801: SET inv_interfaced_flag = c_inv_int_full ,
4802: --Added as part of bug 7645262
4803: last_update_date = sysdate,
4804: request_id = fnd_global.conc_request_id,
4805: last_updated_by = fnd_global.user_id
4806:
4807: WHERE delivery_detail_id = l_delivery_detail_tbl(i)
4808: AND container_flag = 'N';
4809: END IF;

Line 5183: request_id = fnd_global.conc_request_id,

5179: update wsh_delivery_details dd
5180: set inv_interfaced_flag = 'N' ,
5181: --Added as part of bug 7645262
5182: last_update_date = sysdate,
5183: request_id = fnd_global.conc_request_id,
5184: last_updated_by = fnd_global.user_id
5185: where inv_interfaced_flag = 'P'
5186: and not exists (
5187: select picking_line_id

Line 5184: last_updated_by = fnd_global.user_id

5180: set inv_interfaced_flag = 'N' ,
5181: --Added as part of bug 7645262
5182: last_update_date = sysdate,
5183: request_id = fnd_global.conc_request_id,
5184: last_updated_by = fnd_global.user_id
5185: where inv_interfaced_flag = 'P'
5186: and not exists (
5187: select picking_line_id
5188: from mtl_transactions_interface mti

Line 6388: request_id = fnd_global.conc_request_id,

6384: update wsh_delivery_details dd
6385: set inv_interfaced_flag = c_inv_int_full ,
6386: --Added as part of bug 7645262
6387: last_update_date = sysdate,
6388: request_id = fnd_global.conc_request_id,
6389: last_updated_by = fnd_global.user_id
6390:
6391: where (exists (
6392: SELECT mmt.picking_line_id

Line 6389: last_updated_by = fnd_global.user_id

6385: set inv_interfaced_flag = c_inv_int_full ,
6386: --Added as part of bug 7645262
6387: last_update_date = sysdate,
6388: request_id = fnd_global.conc_request_id,
6389: last_updated_by = fnd_global.user_id
6390:
6391: where (exists (
6392: SELECT mmt.picking_line_id
6393: FROM mtl_material_transactions mmt

Line 7775: request_id = fnd_global.conc_request_id,

7771: UPDATE wsh_delivery_details dd
7772: SET oe_interfaced_flag = l_oe_interfaced_flag ,
7773: --Added as part of bug 7645262
7774: last_update_date = sysdate,
7775: request_id = fnd_global.conc_request_id,
7776: last_updated_by = fnd_global.user_id
7777: WHERE source_line_id = p_bulk_ship_line.line_id(i)
7778: and container_flag = l_container_flag
7779: and source_code = l_source_code

Line 7776: last_updated_by = fnd_global.user_id

7772: SET oe_interfaced_flag = l_oe_interfaced_flag ,
7773: --Added as part of bug 7645262
7774: last_update_date = sysdate,
7775: request_id = fnd_global.conc_request_id,
7776: last_updated_by = fnd_global.user_id
7777: WHERE source_line_id = p_bulk_ship_line.line_id(i)
7778: and container_flag = l_container_flag
7779: and source_code = l_source_code
7780: and released_status <> l_released_status

Line 7865: request_id = fnd_global.conc_request_id,

7861: UPDATE wsh_delivery_details dd
7862: set oe_interfaced_flag = l_oe_interfaced_flag ,
7863: --Added as part of bug 7645262
7864: last_update_date = sysdate,
7865: request_id = fnd_global.conc_request_id,
7866: last_updated_by = fnd_global.user_id
7867: where delivery_detail_id in (
7868: SELECT da.delivery_detail_id
7869: FROM wsh_delivery_assignments_v da ,

Line 7866: last_updated_by = fnd_global.user_id

7862: set oe_interfaced_flag = l_oe_interfaced_flag ,
7863: --Added as part of bug 7645262
7864: last_update_date = sysdate,
7865: request_id = fnd_global.conc_request_id,
7866: last_updated_by = fnd_global.user_id
7867: where delivery_detail_id in (
7868: SELECT da.delivery_detail_id
7869: FROM wsh_delivery_assignments_v da ,
7870: wsh_delivery_legs dg,

Line 7900: request_id = fnd_global.conc_request_id,

7896: UPDATE wsh_delivery_details dd
7897: SET oe_interfaced_flag = l_oe_interfaced_flag ,
7898: --Added as part of bug 7645262
7899: last_update_date = sysdate,
7900: request_id = fnd_global.conc_request_id,
7901: last_updated_by = fnd_global.user_id
7902:
7903: WHERE source_line_id = p_bulk_ship_line.line_id(i)
7904: and container_flag = l_container_flag

Line 7901: last_updated_by = fnd_global.user_id

7897: SET oe_interfaced_flag = l_oe_interfaced_flag ,
7898: --Added as part of bug 7645262
7899: last_update_date = sysdate,
7900: request_id = fnd_global.conc_request_id,
7901: last_updated_by = fnd_global.user_id
7902:
7903: WHERE source_line_id = p_bulk_ship_line.line_id(i)
7904: and container_flag = l_container_flag
7905: and source_code = l_source_code

Line 7964: request_id = fnd_global.conc_request_id,

7960: UPDATE wsh_delivery_details dd
7961: SET oe_interfaced_flag = Decode(p_bulk_ship_line.error_flag(i),'Y','N','Y') ,
7962: --Added as part of bug 7645262
7963: last_update_date = sysdate,
7964: request_id = fnd_global.conc_request_id,
7965: last_updated_by = fnd_global.user_id
7966: WHERE source_line_id = p_bulk_ship_line.line_id(i)
7967: and container_flag = l_container_flag
7968: and source_code = l_source_code

Line 7965: last_updated_by = fnd_global.user_id

7961: SET oe_interfaced_flag = Decode(p_bulk_ship_line.error_flag(i),'Y','N','Y') ,
7962: --Added as part of bug 7645262
7963: last_update_date = sysdate,
7964: request_id = fnd_global.conc_request_id,
7965: last_updated_by = fnd_global.user_id
7966: WHERE source_line_id = p_bulk_ship_line.line_id(i)
7967: and container_flag = l_container_flag
7968: and source_code = l_source_code
7969: and released_status <> l_released_status

Line 9760: request_id = fnd_global.conc_request_id,

9756: update wsh_delivery_details
9757: set inv_interfaced_flag = 'P' ,
9758: --Added as part of bug 7645262
9759: last_update_date = sysdate,
9760: request_id = fnd_global.conc_request_id,
9761: last_updated_by = fnd_global.user_id
9762:
9763: where delivery_detail_id in (
9764: SELECT da.delivery_detail_id

Line 9761: last_updated_by = fnd_global.user_id

9757: set inv_interfaced_flag = 'P' ,
9758: --Added as part of bug 7645262
9759: last_update_date = sysdate,
9760: request_id = fnd_global.conc_request_id,
9761: last_updated_by = fnd_global.user_id
9762:
9763: where delivery_detail_id in (
9764: SELECT da.delivery_detail_id
9765: FROM wsh_delivery_assignments_v da ,

Line 9836: l_process_online_message := replace(l_process_online_message,fnd_global.local_chr(0), ' ');

9832: if l_process_online_msg_count > 0 then
9833: FOR i in 1 .. l_process_online_msg_count
9834: LOOP
9835: l_process_online_message := fnd_msg_pub.get(i,'T');
9836: l_process_online_message := replace(l_process_online_message,fnd_global.local_chr(0), ' ');
9837: WSH_UTIL_CORE.PrintMsg(l_process_online_message);
9838: IF l_debug_on THEN
9839: WSH_DEBUG_SV.log(l_module_name,'Error txt:',
9840: SUBSTR(l_process_online_message,1,200));