[Home] [Help]
1254:
1255:
1256: CURSOR c_get_WIE_Rec IS
1257: SELECT p_shipment_request_info.document_number,p_shipment_request_info.document_revision,NULL,wie.error_message
1258: FROM WSH_INTERFACE_ERRORS WIE
1259: WHERE wie.interface_id = p_shipment_request_info.delivery_interface_id
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
1259: WHERE wie.interface_id = p_shipment_request_info.delivery_interface_id
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
1561: CURSOR c_get_Details_DN IS
1562: SELECT wth.document_number,wth.document_revision,wndi.delivery_interface_id,wth.transaction_id
1563: FROM WSH_TRANSACTIONS_HISTORY WTH,
1564: WSH_NEW_DEL_INTERFACE WNDI,
1565: wsh_interface_errors wie
1566: WHERE WTH.document_number = to_char(p_shipment_request_info.document_number)
1567: and WTH.document_revision = p_shipment_request_info.document_revision
1568: and wth.document_type = 'SR'
1569: and wth.document_direction = 'I'
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
1583: and wie.interface_id(+) = wdai.delivery_detail_interface_id
1584: and wie.interface_table_name(+) = 'WSH_DEL_DETAILS_INTERFACE'
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
1595: and wie.interface_id(+) = wdai.delivery_detail_interface_id
2025: IF l_debug_on THEN
2026: WSH_DEBUG_SV.log(l_module_name,i||' WDDI : Number of records Deleted',l_ins_rows);
2027: END IF;
2028:
2029: delete from WSH_INTERFACE_ERRORS
2030: where interface_id = l_del_det_int_tab(i)
2031: and interface_table_name = 'WSH_DEL_DETAILS_INTERFACE';
2032: l_ins_rows := sql%rowcount;
2033: IF l_debug_on THEN
2060: WSH_DEBUG_SV.log(l_module_name, 'WDDI : Number of records Deleted',l_ins_rows);
2061: END IF;
2062:
2063: FORALL i in 1..l_del_det_int_tab.count
2064: delete from WSH_INTERFACE_ERRORS
2065: where interface_id = l_del_det_int_tab(i)
2066: and interface_table_name= 'WSH_DEL_DETAILS_INTERFACE';
2067: l_ins_rows := sql%rowcount;
2068: IF l_debug_on THEN
2088: IF l_debug_on THEN
2089: WSH_DEBUG_SV.log(l_module_name, 'WTH : Number of records Deleted',l_ins_rows);
2090: END IF;
2091: ---------
2092: delete from wsh_interface_errors
2093: where interface_id = l_delivery_interface_id
2094: and interface_table_name = 'WSH_NEW_DEL_INTERFACE';
2095: l_ins_rows := sql%rowcount;
2096: IF l_debug_on THEN