APPS.WSH_SHIPMENT_REQUEST_PUB dependencies on WSH_NEW_DEL_INTERFACE

Line 678: wsh_debug_sv.logmsg(l_module_name, 'Inserting into WSH_NEW_DEL_INTERFACE');

674:
675:
676: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
677: IF l_debug_on THEN
678: wsh_debug_sv.logmsg(l_module_name, 'Inserting into WSH_NEW_DEL_INTERFACE');
679: END IF;
680:
681: INSERT INTO WSH_NEW_DEL_INTERFACE(
682: DELIVERY_INTERFACE_ID,

Line 681: INSERT INTO WSH_NEW_DEL_INTERFACE(

677: IF l_debug_on THEN
678: wsh_debug_sv.logmsg(l_module_name, 'Inserting into WSH_NEW_DEL_INTERFACE');
679: END IF;
680:
681: INSERT INTO WSH_NEW_DEL_INTERFACE(
682: DELIVERY_INTERFACE_ID,
683: PLANNED_FLAG,
684: STATUS_CODE,
685: CREATION_DATE,

Line 751: wsh_new_del_interface_s.nextval,

747: CURRENCY_CODE,
748: CLIENT_CODE, -- LSP PROJECT
749: INTERFACE_ACTION_CODE)
750: Values(
751: wsh_new_del_interface_s.nextval,
752: 'N',
753: 'OP',
754: sysdate,
755: FND_GLOBAL.USER_ID,

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

819: )
820: RETURNING DELIVERY_INTERFACE_ID INTO p_shipment_request_info.delivery_interface_id;
821: l_ins_rows := sql%rowcount;
822: IF l_debug_on THEN
823: WSH_DEBUG_SV.log(l_module_name, 'Number of records inserted into WSH_NEW_DEL_INTERFACE',l_ins_rows);
824: WSH_DEBUG_SV.log(l_module_name, 'Number of shipment details',p_shipment_request_info.shipment_details_tab.count);
825: END IF;
826: --}
827: END IF;

Line 1260: AND wie.interface_table_name = 'WSH_NEW_DEL_INTERFACE'

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
1263: FROM WSH_INTERFACE_ERRORS WIE,
1264: wsh_del_assgn_interface WDAI,

Line 1332: WSH_NEW_DEL_INTERFACE WNDI

1328: WNDI.transaction_type_id,
1329: WNDI.price_list_id,
1330: WNDI.client_code -- LSP PROJECT
1331: FROM WSH_TRANSACTIONS_HISTORY WTH,
1332: WSH_NEW_DEL_INTERFACE WNDI
1333: WHERE WTH.document_number = to_char(p_shipment_request_info.document_number)
1334: AND WTH.document_revision = p_shipment_request_info.document_revision
1335: AND WTH.document_type ='SR'
1336: AND WTH.document_direction ='I'

Line 1564: WSH_NEW_DEL_INTERFACE WNDI,

1560:
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'

Line 1571: and wie.interface_table_name(+) = 'WSH_NEW_DEL_INTERFACE'

1567: and WTH.document_revision = p_shipment_request_info.document_revision
1568: and wth.document_type = 'SR'
1569: and wth.document_direction = 'I'
1570: and wie.interface_id(+) = WNDI.delivery_interface_id
1571: and wie.interface_table_name(+) = 'WSH_NEW_DEL_INTERFACE'
1572: and to_number(WTH.entity_number) = WNDI.delivery_interface_id
1573: AND WNDI.Interface_action_code = '94X_STANDALONE'
1574: FOR UPDATE OF wth.transaction_id, wndi.delivery_interface_id ,wie.interface_id NOWAIT;
1575:

Line 1605: l_delivery_interface_id WSH_NEW_DEL_INTERFACE.delivery_interface_id%TYPE;

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;
1606: l_transaction_id WSH_TRANSACTIONS_HISTORY.Transaction_Id%TYPE;
1607: l_del_det_int_tab wsh_util_core.id_tab_type;
1608: l_document_number WSH_TRANSACTIONS_HISTORY.document_number%TYPE;
1609: l_document_revision WSH_TRANSACTIONS_HISTORY.document_revision%TYPE;

Line 1772: wsh_debug_sv.logmsg(l_module_name, 'Updating WSH_NEW_DEL_INTERFACE');

1768:
1769: IF p_action_code ='UPDATE' THEN
1770: --{
1771: IF l_debug_on THEN
1772: wsh_debug_sv.logmsg(l_module_name, 'Updating WSH_NEW_DEL_INTERFACE');
1773: END IF;
1774: UPDATE WSH_NEW_DEL_INTERFACE
1775: SET last_update_date = sysdate,
1776: last_updated_by = FND_GLOBAL.USER_ID,

Line 1774: UPDATE WSH_NEW_DEL_INTERFACE

1770: --{
1771: IF l_debug_on THEN
1772: wsh_debug_sv.logmsg(l_module_name, 'Updating WSH_NEW_DEL_INTERFACE');
1773: END IF;
1774: UPDATE WSH_NEW_DEL_INTERFACE
1775: SET last_update_date = sysdate,
1776: last_updated_by = FND_GLOBAL.USER_ID,
1777: last_update_login = FND_GLOBAL.Login_Id,
1778: program_application_id = FND_GLOBAL.Prog_Appl_Id,

Line 2080: delete from wsh_new_del_interface where delivery_interface_id = l_delivery_interface_id;

2076: CLOSE C_OPEN_DEL_DET;
2077:
2078: IF l_count = 0 THEN --Will be deleting WNDI and WTH records only iof there are no more detail records for the shipment request
2079: ---------
2080: delete from wsh_new_del_interface where delivery_interface_id = l_delivery_interface_id;
2081: l_ins_rows := sql%rowcount;
2082: IF l_debug_on THEN
2083: WSH_DEBUG_SV.log(l_module_name, 'WNDI : Number of records Deleted',l_ins_rows);
2084: END IF;

Line 2094: and interface_table_name = 'WSH_NEW_DEL_INTERFACE';

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
2097: WSH_DEBUG_SV.log(l_module_name, 'WIE : Number of records Deleted',l_ins_rows);
2098: END IF;