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_PKG dependencies on WSH_DEL_DETAILS_INTERFACE

Line 1104: WSH_DEBUG_SV.logmsg(l_module_name, 'Locking wsh_del_details_interface, wsh_del_assgn_interface Records');

1100:
1101: --Lock all delivery detail interface records
1102: IF l_debug_on THEN
1103: WSH_DEBUG_SV.logmsg(l_module_name, 'Locked '||SQL%ROWCOUNT||' wsh_new_del_interface Records');
1104: WSH_DEBUG_SV.logmsg(l_module_name, 'Locking wsh_del_details_interface, wsh_del_assgn_interface Records');
1105: END IF;
1106: --
1107:
1108: SELECT wddi.delivery_detail_interface_id, wdai.del_assgn_interface_id

Line 1110: FROM Wsh_Del_Details_Interface wddi,

1106: --
1107:
1108: SELECT wddi.delivery_detail_interface_id, wdai.del_assgn_interface_id
1109: BULK COLLECT INTO l_detail_interface_tbl, l_del_assgn_interface_tbl
1110: FROM Wsh_Del_Details_Interface wddi,
1111: Wsh_Del_Assgn_Interface wdai,
1112: Wsh_Transactions_History wth
1113: WHERE wddi.interface_action_code = g_interface_action_code
1114: AND wdai.interface_action_code = g_interface_action_code

Line 1126: WSH_DEBUG_SV.logmsg(l_module_name, 'Locked '||SQL%ROWCOUNT||' wsh_del_details_interface, wsh_del_assgn_interface Records');

1122: for update of wddi.delivery_detail_interface_id, wdai.del_assgn_interface_id nowait;
1123:
1124: --
1125: IF l_debug_on THEN
1126: WSH_DEBUG_SV.logmsg(l_module_name, 'Locked '||SQL%ROWCOUNT||' wsh_del_details_interface, wsh_del_assgn_interface Records');
1127: WSH_DEBUG_SV.logmsg(l_module_name, 'Locking wsh_interface_errors Records (For Delivery Interface)');
1128: END IF;
1129: --
1130:

Line 1155: WHERE interface_table_name = 'WSH_DEL_DETAILS_INTERFACE'

1151:
1152: SELECT wie.interface_error_id
1153: BULK COLLECT INTO l_det_interface_error_tbl
1154: FROM wsh_interface_errors wie
1155: WHERE interface_table_name = 'WSH_DEL_DETAILS_INTERFACE'
1156: AND interface_action_code = g_interface_action_code
1157: AND interface_id in
1158: ( select wddi.delivery_detail_interface_id
1159: FROM Wsh_Del_Details_Interface wddi,

Line 1159: FROM Wsh_Del_Details_Interface wddi,

1155: WHERE interface_table_name = 'WSH_DEL_DETAILS_INTERFACE'
1156: AND interface_action_code = g_interface_action_code
1157: AND interface_id in
1158: ( select wddi.delivery_detail_interface_id
1159: FROM Wsh_Del_Details_Interface wddi,
1160: Wsh_Del_Assgn_Interface wdai,
1161: wsh_transactions_history wth
1162: WHERE wddi.interface_action_code = g_interface_action_code
1163: AND wdai.interface_action_code = g_interface_action_code

Line 1359: FROM Wsh_Del_Details_Interface wddi,

1355: --Validate Currency Code
1356: BEGIN
1357: SELECT distinct currency_code
1358: INTO l_temp_currency_code
1359: FROM Wsh_Del_Details_Interface wddi,
1360: Wsh_Del_Assgn_Interface wdai
1361: WHERE wddi.interface_action_code = g_interface_action_code
1362: AND wdai.interface_action_code = g_interface_action_code
1363: AND wddi.currency_code is not null

Line 2266: interface_error_rec.p_interface_table_name := 'WSH_DEL_DETAILS_INTERFACE';

2262: IF l_debug_on THEN
2263: WSH_DEBUG_SV.logmsg(l_module_name, 'Populating error for delivery detail interface');
2264: END IF;
2265: --
2266: interface_error_rec.p_interface_table_name := 'WSH_DEL_DETAILS_INTERFACE';
2267: interface_error_rec.p_interface_id := l_line_details_tbl(MOD(l_entity_id,G_BINARY_LIMIT));
2268: ELSE
2269: interface_error_rec.p_interface_table_name := NULL;
2270: END IF;

Line 2376: WHERE interface_table_name = 'WSH_DEL_DETAILS_INTERFACE'

2372:
2373: SELECT wie.interface_error_id
2374: BULK COLLECT INTO l_det_interface_error_tbl
2375: FROM wsh_interface_errors wie
2376: WHERE interface_table_name = 'WSH_DEL_DETAILS_INTERFACE'
2377: AND interface_action_code = g_interface_action_code
2378: AND interface_id in
2379: ( select wddi.delivery_detail_interface_id
2380: FROM Wsh_Del_Details_Interface wddi,

Line 2380: FROM Wsh_Del_Details_Interface wddi,

2376: WHERE interface_table_name = 'WSH_DEL_DETAILS_INTERFACE'
2377: AND interface_action_code = g_interface_action_code
2378: AND interface_id in
2379: ( select wddi.delivery_detail_interface_id
2380: FROM Wsh_Del_Details_Interface wddi,
2381: Wsh_Del_Assgn_Interface wdai
2382: WHERE wddi.interface_action_code = g_interface_action_code
2383: AND wdai.interface_action_code = g_interface_action_code
2384: AND wddi.delivery_detail_interface_id = wdai.delivery_detail_interface_id

Line 3057: wsh_del_details_interface wddi,

3053: cursor c_lock_interface_lines
3054: is
3055: select oel.line_id
3056: from oe_order_lines_all oel,
3057: wsh_del_details_interface wddi,
3058: wsh_del_assgn_interface wdai
3059: where oel.header_id = p_header_id
3060: and oel.line_number = wddi.line_number
3061: and wddi.interface_action_code = g_interface_action_code

Line 3074: from wsh_del_details_interface wddi,

3070: from oe_order_lines_all oel
3071: where oel.header_id = p_header_id
3072: and not exists
3073: ( select '1'
3074: from wsh_del_details_interface wddi,
3075: wsh_del_assgn_interface wdai
3076: where oel.line_number = wddi.line_number
3077: and wddi.interface_action_code = g_interface_action_code
3078: and wdai.interface_action_code = g_interface_action_code

Line 5899: -- populated in Wsh_Del_Details_Interface table.

5895: -- x_return_status => Return Status of API (Either S,E,U)
5896: --
5897: -- COMMENT:
5898: -- API to derive/validate standalone related order line attributes
5899: -- populated in Wsh_Del_Details_Interface table.
5900: --=============================================================================
5901: --
5902: PROCEDURE Derive_Line_Rec(
5903: p_header_id IN NUMBER,

Line 5949: FROM Wsh_Del_Details_Interface wddi,

5945: wddi.cust_po_number,
5946: null, -- Line Id
5947: 'N', -- Schedule Date Changed
5948: 'N' -- Changed Flag
5949: FROM Wsh_Del_Details_Interface wddi,
5950: Wsh_Del_Assgn_Interface wdai,
5951: Wsh_New_Del_Interface wndi
5952: WHERE wddi.interface_action_code = g_interface_action_code
5953: AND wdai.interface_action_code = g_interface_action_code

Line 5962: l_item_number WSH_DEL_DETAILS_INTERFACE.Item_Number%TYPE;

5958:
5959: l_temp_status VARCHAR2(1);
5960: l_return_status VARCHAR2(1);
5961:
5962: l_item_number WSH_DEL_DETAILS_INTERFACE.Item_Number%TYPE;
5963:
5964: l_line_cnt NUMBER;
5965: l_customer_id NUMBER;
5966: l_ship_to_org_id NUMBER;

Line 6310: p_interface_table_name => 'WSH_DEL_DETAILS_INTERFACE',

6306: IF l_temp_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
6307: x_return_status := l_temp_status;
6308: Populate_Error_Records(
6309: p_interface_id => x_details_interface_rec_tab(i).delivery_detail_interface_id,
6310: p_interface_table_name => 'WSH_DEL_DETAILS_INTERFACE',
6311: x_interface_errors_rec_tab => x_interface_error_tab,
6312: x_return_status => l_return_status );
6313: END IF;
6314: END LOOP;

Line 6375: FROM Wsh_Del_Details_Interface wddi,

6371: FROM oe_order_lines_all oel
6372: WHERE header_id = p_om_header_rec_type.header_id
6373: AND NOT EXISTS
6374: ( SELECT 'X'
6375: FROM Wsh_Del_Details_Interface wddi,
6376: Wsh_Del_Assgn_Interface wdai,
6377: Wsh_New_Del_Interface wndi
6378: WHERE wddi.line_number = oel.line_number
6379: AND wddi.interface_action_code = g_interface_action_code

Line 7376: p_interface_table_name => 'WSH_DEL_DETAILS_INTERFACE',

7372: x_return_status := l_temp_status;
7373:
7374: Populate_Error_Records(
7375: p_interface_id => p_details_interface_tab(i).delivery_detail_interface_id,
7376: p_interface_table_name => 'WSH_DEL_DETAILS_INTERFACE',
7377: x_interface_errors_rec_tab => x_interface_error_tab,
7378: x_return_status => l_return_status );
7379: END IF;
7380: END LOOP; --}