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_SHIPMENT_REQUEST_PUB dependencies on WSH_DEL_ASSGN_INTERFACE

Line 834: wsh_debug_sv.logmsg(l_module_name, 'Inserting into WSH_DEL_DETAILS_INTERFACE and WSH_DEL_ASSGN_INTERFACE');

830: IF p_shipment_request_info.shipment_details_tab.count > 0 AND
831: p_shipment_request_info.shipment_details_tab.count < 4 THEN
832: --{
833: IF l_debug_on THEN
834: wsh_debug_sv.logmsg(l_module_name, 'Inserting into WSH_DEL_DETAILS_INTERFACE and WSH_DEL_ASSGN_INTERFACE');
835: END IF;
836:
837: FOR i IN 1..p_shipment_request_info.shipment_details_tab.count LOOP
838: --{

Line 933: INSERT INTO WSH_DEL_ASSGN_INTERFACE(

929: 'O',
930: '94X_STANDALONE')
931: RETURNING DELIVERY_DETAIL_INTERFACE_ID INTO p_shipment_request_info.shipment_details_tab(i).delivery_detail_interface_id;
932:
933: INSERT INTO WSH_DEL_ASSGN_INTERFACE(
934: DEL_ASSGN_INTERFACE_ID,
935: DELIVERY_DETAIL_INTERFACE_ID,
936: CREATION_DATE,
937: CREATED_BY,

Line 949: wsh_del_assgn_interface_s.nextval,

945: DELIVERY_INTERFACE_ID,
946: INTERFACE_ACTION_CODE
947: )
948: VALUES(
949: wsh_del_assgn_interface_s.nextval,
950: p_shipment_request_info.shipment_details_tab(i).delivery_detail_interface_id,
951: sysdate,
952: FND_GLOBAL.USER_ID,
953: sysdate,

Line 965: wsh_debug_sv.logmsg(l_module_name, 'Done Inserting into WSH_DEL_DETAILS_INTERFACE and WSH_DEL_ASSGN_INTERFACE'||p_shipment_request_info.shipment_details_tab(i).delivery_detail_interface_id);

961: '94X_STANDALONE'
962: );
963:
964: IF l_debug_on THEN
965: wsh_debug_sv.logmsg(l_module_name, 'Done Inserting into WSH_DEL_DETAILS_INTERFACE and WSH_DEL_ASSGN_INTERFACE'||p_shipment_request_info.shipment_details_tab(i).delivery_detail_interface_id);
966: END IF;
967:
968: --}
969: END LOOP;

Line 1112: INSERT INTO WSH_DEL_ASSGN_INTERFACE(

1108: FOR I IN 1..l_del_det_int_tab.Count LOOP
1109: p_shipment_request_info.shipment_details_tab(i).delivery_detail_interface_id := l_del_det_int_tab(i);
1110: END LOOP;
1111: FORALL i IN 1..p_shipment_request_info.shipment_details_tab.count
1112: INSERT INTO WSH_DEL_ASSGN_INTERFACE(
1113: DEL_ASSGN_INTERFACE_ID,
1114: DELIVERY_DETAIL_INTERFACE_ID,
1115: CREATION_DATE,
1116: CREATED_BY,

Line 1128: wsh_del_assgn_interface_s.nextval,

1124: DELIVERY_INTERFACE_ID,
1125: INTERFACE_ACTION_CODE
1126: )
1127: VALUES(
1128: wsh_del_assgn_interface_s.nextval,
1129: l_del_det_int_tab(i), --Bug8784331
1130: sysdate,
1131: FND_GLOBAL.USER_ID,
1132: sysdate,

Line 1144: WSH_DEBUG_SV.log(l_module_name, 'Number of records inserted into WSH_DEL_ASSGN_INTERFACE',l_ins_rows );

1140: '94X_STANDALONE'
1141: );
1142: l_ins_rows := sql%rowcount;
1143: IF l_debug_on THEN
1144: WSH_DEBUG_SV.log(l_module_name, 'Number of records inserted into WSH_DEL_ASSGN_INTERFACE',l_ins_rows );
1145: END IF;
1146: --}
1147: END IF;--(if count >0)
1148:

Line 1264: wsh_del_assgn_interface WDAI,

1260: AND wie.interface_table_name = 'WSH_NEW_DEL_INTERFACE'
1261: UNION
1262: SELECT p_shipment_request_info.document_number,p_shipment_request_info.document_revision,wddi.line_number,wie.error_message
1263: FROM WSH_INTERFACE_ERRORS WIE,
1264: wsh_del_assgn_interface WDAI,
1265: WSH_DEL_DETAILS_INTERFACE WDDI
1266: WHERE wie.interface_table_name = 'WSH_DEL_DETAILS_INTERFACE'
1267: AND wie.interface_id = WDAI.delivery_detail_interface_id
1268: AND wddi.delivery_detail_interface_id = WDAI.delivery_detail_interface_id

Line 1375: WSH_DEL_ASSGN_INTERFACE WDAI

1371: WDDI.source_line_number,
1372: WDDI.src_requested_quantity,
1373: WDDI.src_requested_quantity_uom
1374: FROM WSH_DEL_DETAILS_INTERFACE WDDI ,
1375: WSH_DEL_ASSGN_INTERFACE WDAI
1376: WHERE WDDI.delivery_detail_interface_id = WDAI.delivery_detail_interface_id
1377: AND WDAI.delivery_interface_id = p_shipment_request_info.delivery_interface_id
1378: AND WDDI.Interface_action_code = '94X_STANDALONE';
1379:

Line 1578: FROM WSH_DEL_ASSGN_INTERFACE wdai,

1574: FOR UPDATE OF wth.transaction_id, wndi.delivery_interface_id ,wie.interface_id NOWAIT;
1575:
1576: CURSOR c_get_all_del_det_interface_id IS
1577: SELECT wdai.delivery_detail_interface_id
1578: FROM WSH_DEL_ASSGN_INTERFACE wdai,
1579: wsh_del_details_interface wddi,
1580: wsh_interface_errors wie
1581: WHERE wdai.delivery_interface_id = p_shipment_request_info.delivery_interface_id
1582: and wddi.delivery_detail_interface_id = wdai.delivery_detail_interface_id

Line 1590: wsh_del_assgn_interface wdai,

1586:
1587: CURSOR c_get_del_det_interface_id(c_line_number VARCHAR2) IS
1588: SELECT wdai.delivery_detail_interface_id
1589: FROM wsh_del_details_interface wddi,
1590: wsh_del_assgn_interface wdai,
1591: wsh_interface_errors wie
1592: WHERE wddi.delivery_detail_interface_id = wdai.delivery_detail_interface_id
1593: AND wdai.delivery_interface_id= p_shipment_request_info.delivery_interface_id
1594: AND wddi.line_number = c_line_number

Line 1601: from wsh_del_assgn_interface wdai

1597: FOR UPDATE OF WDAI.delivery_detail_interface_id, wddi.delivery_detail_interface_id,wie.interface_id NOWAIT;
1598:
1599: CURSOR C_OPEN_DEL_DET IS
1600: SELECT Count(*)
1601: from wsh_del_assgn_interface wdai
1602: where wdai.delivery_interface_id= p_shipment_request_info.delivery_interface_id;
1603:
1604: --
1605: l_delivery_interface_id WSH_NEW_DEL_INTERFACE.delivery_interface_id%TYPE;

Line 2014: delete from wsh_del_assgn_interface

2010: WSH_DEBUG_SV.log(l_module_name, 'Deleting in non-bulk mode', l_del_det_int_tab.count);
2011: END IF;
2012: --
2013: FOR i in 1..l_del_det_int_tab.count LOOP
2014: delete from wsh_del_assgn_interface
2015: where delivery_detail_interface_id = l_del_det_int_tab(i);
2016: l_ins_rows := sql%rowcount;
2017: IF l_debug_on THEN
2018: WSH_DEBUG_SV.log(l_module_name,i||' WDAI : Number of records Deleted',l_ins_rows);

Line 2046: delete from wsh_del_assgn_interface

2042: WSH_DEBUG_SV.log(l_module_name, 'Deleting in bulk mode', l_del_det_int_tab.count);
2043: END IF;
2044: --
2045: FORALL i in 1..l_del_det_int_tab.count
2046: delete from wsh_del_assgn_interface
2047: where delivery_detail_interface_id = l_del_det_int_tab(i);
2048:
2049: l_ins_rows := sql%rowcount;
2050: IF l_debug_on THEN