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_DETAILS_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 839: INSERT INTO WSH_DEL_DETAILS_INTERFACE(

835: END IF;
836:
837: FOR i IN 1..p_shipment_request_info.shipment_details_tab.count LOOP
838: --{
839: INSERT INTO WSH_DEL_DETAILS_INTERFACE(
840: DELIVERY_DETAIL_INTERFACE_ID,
841: SOURCE_CODE,
842: SOURCE_LINE_ID,
843: CREATION_DATE,

Line 886: wsh_del_details_interface_s.nextval,

882: UNIT_SELLING_PRICE,
883: LINE_DIRECTION,
884: INTERFACE_ACTION_CODE)
885: VALUES(
886: wsh_del_details_interface_s.nextval,
887: 'OE',
888: -1,
889: sysdate,
890: FND_GLOBAL.USER_ID,

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 1008: INSERT INTO WSH_DEL_DETAILS_INTERFACE(

1004: l_unit_selling_price(i) := p_shipment_request_info.shipment_details_tab(i).unit_selling_price;
1005: END LOOP;
1006: --Bug8784331
1007: FORALL i IN 1..p_shipment_request_info.shipment_details_tab.count
1008: INSERT INTO WSH_DEL_DETAILS_INTERFACE(
1009: DELIVERY_DETAIL_INTERFACE_ID,
1010: SOURCE_CODE,
1011: SOURCE_LINE_ID,
1012: CREATION_DATE,

Line 1055: wsh_del_details_interface_s.nextval,

1051: UNIT_SELLING_PRICE,
1052: LINE_DIRECTION,
1053: INTERFACE_ACTION_CODE)
1054: VALUES(
1055: wsh_del_details_interface_s.nextval,
1056: 'OE',
1057: -1,
1058: sysdate,
1059: FND_GLOBAL.USER_ID,

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

1101: '94X_STANDALONE')
1102: RETURNING DELIVERY_DETAIL_INTERFACE_ID BULK COLLECT INTO l_del_det_int_tab;
1103: l_ins_rows := sql%rowcount;
1104: IF l_debug_on THEN
1105: WSH_DEBUG_SV.log(l_module_name, 'Number of records inserted into WSH_DEL_DETAILS_INTERFACE',l_ins_rows );
1106: END IF;
1107:
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);

Line 1265: WSH_DEL_DETAILS_INTERFACE WDDI

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
1269: and WDAI.delivery_interface_id = p_shipment_request_info.delivery_interface_id;

Line 1266: WHERE wie.interface_table_name = 'WSH_DEL_DETAILS_INTERFACE'

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
1269: and WDAI.delivery_interface_id = p_shipment_request_info.delivery_interface_id;
1270:

Line 1374: FROM WSH_DEL_DETAILS_INTERFACE WDDI ,

1370: WDDI.source_header_number,
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';

Line 1579: wsh_del_details_interface wddi,

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
1583: and wie.interface_id(+) = wdai.delivery_detail_interface_id

Line 1584: and wie.interface_table_name(+) = 'WSH_DEL_DETAILS_INTERFACE'

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'
1585: FOR UPDATE OF WDAI.delivery_detail_interface_id, wddi.delivery_detail_interface_id,wie.interface_id NOWAIT;
1586:
1587: CURSOR c_get_del_det_interface_id(c_line_number VARCHAR2) IS
1588: SELECT wdai.delivery_detail_interface_id

Line 1589: FROM wsh_del_details_interface wddi,

1585: FOR UPDATE OF WDAI.delivery_detail_interface_id, wddi.delivery_detail_interface_id,wie.interface_id NOWAIT;
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

Line 1596: and wie.interface_table_name(+) = 'WSH_DEL_DETAILS_INTERFACE'

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
1596: and wie.interface_table_name(+) = 'WSH_DEL_DETAILS_INTERFACE'
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(*)

Line 1856: UPDATE WSH_DEL_DETAILS_INTERFACE

1852: IF l_debug_on THEN
1853: WSH_DEBUG_SV.log(l_module_name, 'updating delivery_detail_interface_id',l_update_sr_info.shipment_details_tab(i).delivery_detail_interface_id );
1854: END IF;
1855: --
1856: UPDATE WSH_DEL_DETAILS_INTERFACE
1857: SET last_update_date = sysdate,
1858: last_updated_by = FND_GLOBAL.USER_ID,
1859: last_update_login = FND_GLOBAL.Login_Id,
1860: program_application_id = FND_GLOBAL.Prog_Appl_Id,

Line 1937: UPDATE WSH_DEL_DETAILS_INTERFACE

1933: l_delivery_detail_interface_id(i):= l_update_sr_info.shipment_details_tab(i).delivery_detail_interface_id;
1934: END LOOP;
1935: --Bug8784331
1936: FORALL i in 1..l_update_sr_info.shipment_details_tab.count
1937: UPDATE WSH_DEL_DETAILS_INTERFACE
1938: SET last_update_date = sysdate,
1939: last_updated_by = FND_GLOBAL.USER_ID,
1940: last_update_login = FND_GLOBAL.Login_Id,
1941: program_application_id = FND_GLOBAL.Prog_Appl_Id,

Line 2022: delete from WSH_DEL_DETAILS_INTERFACE

2018: WSH_DEBUG_SV.log(l_module_name,i||' WDAI : Number of records Deleted',l_ins_rows);
2019: END IF;
2020:
2021:
2022: delete from WSH_DEL_DETAILS_INTERFACE
2023: where delivery_detail_interface_id = l_del_det_int_tab(i);
2024: l_ins_rows := sql%rowcount;
2025: IF l_debug_on THEN
2026: WSH_DEBUG_SV.log(l_module_name,i||' WDDI : Number of records Deleted',l_ins_rows);

Line 2031: and interface_table_name = 'WSH_DEL_DETAILS_INTERFACE';

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

Line 2055: delete from WSH_DEL_DETAILS_INTERFACE

2051: WSH_DEBUG_SV.log(l_module_name, 'WDAI : Number of records Deleted',l_ins_rows);
2052: END IF;
2053:
2054: FORALL i in 1..l_del_det_int_tab.count
2055: delete from WSH_DEL_DETAILS_INTERFACE
2056: where delivery_detail_interface_id = l_del_det_int_tab(i);
2057:
2058: l_ins_rows := sql%rowcount;
2059: IF l_debug_on THEN

Line 2066: and interface_table_name= 'WSH_DEL_DETAILS_INTERFACE';

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