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_NEW_DEL_INTERFACE

Line 5: g_interface_action_code WSH_NEW_DEL_INTERFACE.INTERFACE_ACTION_CODE%TYPE;

1: PACKAGE BODY WSH_SHIPMENT_REQUEST_PKG AS
2: /* $Header: WSHSRPKB.pls 120.7 2010/09/06 09:58:45 selsubra noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'WSH_SHIPMENT_REQUEST_PKG';
5: g_interface_action_code WSH_NEW_DEL_INTERFACE.INTERFACE_ACTION_CODE%TYPE;
6: g_po_total_time NUMBER := 0;
7: g_sold_to_ref VARCHAR2(50) := 'CUST-SOLD-TO-REF';
8: g_ship_to_ref VARCHAR2(50) := 'CUST-SHIP-TO-REF';
9: g_invoice_to_ref VARCHAR2(50) := 'CUST-INVOICE-TO-REF';

Line 243: Wsh_New_Del_Interface wndi

239: wth.Attribute14,
240: wth.Attribute15,
241: NULL -- LSP PROJECT : just added for dependency for client_id
242: FROM Wsh_Transactions_History wth,
243: Wsh_New_Del_Interface wndi
244: WHERE wndi.interface_action_code = g_interface_action_code
245: AND wndi.delivery_interface_id = to_number(wth.entity_number)
246: AND wth.transaction_id = p_transaction_id
247: AND wth.transaction_status = nvl(p_transaction_status, wth.transaction_status);

Line 389: --l_transaction_query := l_transaction_query || ' FROM Wsh_New_Del_Interface wndi, ';

385: l_transaction_query := l_transaction_query || 'wth.Attribute15 ';
386:
387: --FROM Clause
388: l_transaction_query := l_transaction_query || ' FROM Wsh_Transactions_History wth, ';
389: --l_transaction_query := l_transaction_query || ' FROM Wsh_New_Del_Interface wndi, ';
390: l_transaction_query := l_transaction_query || '( SELECT max(wth1.document_revision) document_revision, ';
391: l_transaction_query := l_transaction_query || ' to_char(max(to_number(entity_number))) entity_number, ';
392: l_transaction_query := l_transaction_query || ' document_number, document_type, document_direction ';
393: l_transaction_query := l_transaction_query || ' FROM Wsh_Transactions_History wth1 ';

Line 437: l_transaction_query := l_transaction_query || ' ( SELECT 1 from wsh_new_del_interface wndi ';

433: l_transaction_query := l_transaction_query || 'AND wth.document_revision = MDR.document_revision ';
434: l_transaction_query := l_transaction_query || 'AND wth.document_type = ''SR'' ';
435: l_transaction_query := l_transaction_query || 'AND wth.document_direction = ''I'' ';
436: l_transaction_query := l_transaction_query || 'AND exists ';
437: l_transaction_query := l_transaction_query || ' ( SELECT 1 from wsh_new_del_interface wndi ';
438: l_transaction_query := l_transaction_query || 'WHERE interface_action_code = ''' || g_interface_action_code || '''';
439: -- Modified R12.1.1 LSP PROJECT* :Begin
440: IF p_client_code is not null THEN
441: l_transaction_query := l_transaction_query || ' AND wndi.client_code=:x_client_code ';

Line 1084: WSH_DEBUG_SV.logmsg(l_module_name, 'Locking wsh_new_del_interface Records');

1080:
1081: --Lock all delivery interface records
1082: IF l_debug_on THEN
1083: WSH_DEBUG_SV.logmsg(l_module_name, 'Locked '||SQL%ROWCOUNT||' wsh_transactions_history Records');
1084: WSH_DEBUG_SV.logmsg(l_module_name, 'Locking wsh_new_del_interface Records');
1085: END IF;
1086: --
1087:
1088: SELECT wndi.delivery_interface_id

Line 1090: FROM Wsh_New_Del_Interface wndi,

1086: --
1087:
1088: SELECT wndi.delivery_interface_id
1089: BULK COLLECT INTO l_delivery_interface_tbl
1090: FROM Wsh_New_Del_Interface wndi,
1091: Wsh_Transactions_History wth
1092: WHERE wndi.interface_action_code = g_interface_action_code
1093: AND wndi.delivery_interface_id = to_number(wth.entity_number)
1094: AND wth.transaction_status in ( 'IP', 'AP', 'ER' )

Line 1103: WSH_DEBUG_SV.logmsg(l_module_name, 'Locked '||SQL%ROWCOUNT||' wsh_new_del_interface Records');

1099: for update of wndi.delivery_interface_id nowait;
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:

Line 1135: WHERE wie.interface_table_name = 'WSH_NEW_DEL_INTERFACE'

1131: SELECT wie.interface_error_id
1132: BULK COLLECT INTO l_del_interface_error_tbl
1133: FROM wsh_interface_errors wie,
1134: wsh_transactions_history wth
1135: WHERE wie.interface_table_name = 'WSH_NEW_DEL_INTERFACE'
1136: AND wie.interface_action_code = g_interface_action_code
1137: AND wth.transaction_status in ( 'IP', 'AP', 'ER' )
1138: AND wth.document_type = 'SR'
1139: AND wth.document_direction = 'I'

Line 2256: interface_error_rec.p_interface_table_name := 'WSH_NEW_DEL_INTERFACE';

2252: IF l_debug_on THEN
2253: WSH_DEBUG_SV.logmsg(l_module_name, 'Populating error for delivery interface');
2254: END IF;
2255: --
2256: interface_error_rec.p_interface_table_name := 'WSH_NEW_DEL_INTERFACE';
2257: interface_error_rec.p_interface_id := l_entity_number;
2258: -- LSP PROJECT : For line level errors, l_line_details_tbl stores all dd iface ids.
2259: ELSIF (l_entity_code = 'LINE' AND l_line_details_tbl.exists(MOD(l_entity_id,G_BINARY_LIMIT)))
2260: THEN

Line 2335: p_interface_table_name => 'WSH_NEW_DEL_INTERFACE',

2331: END IF;
2332: --
2333: Populate_Error_Records(
2334: p_interface_id => l_entity_number,
2335: p_interface_table_name => 'WSH_NEW_DEL_INTERFACE',
2336: x_interface_errors_rec_tab => interface_error_tab,
2337: x_return_status => l_return_status );
2338:
2339: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN

Line 2362: WHERE wie.interface_table_name = 'WSH_NEW_DEL_INTERFACE'

2358: --Querying interface errors of Current processing document revision - Start
2359: SELECT wie.interface_error_id
2360: BULK COLLECT INTO l_del_interface_error_tbl
2361: FROM wsh_interface_errors wie
2362: WHERE wie.interface_table_name = 'WSH_NEW_DEL_INTERFACE'
2363: AND wie.interface_action_code = g_interface_action_code
2364: AND wie.interface_id = l_entity_number;
2365:
2366: --

Line 2682: FROM Wsh_New_Del_Interface wndi

2678: null, -- Org Id
2679: null, -- Document Revision
2680: null, -- Order Number
2681: client_code -- LSP PROJECT : client_code
2682: FROM Wsh_New_Del_Interface wndi
2683: WHERE wndi.delivery_interface_id = p_delivery_interface_id;
2684:
2685: l_return_status VARCHAR2(1);
2686:

Line 5500: -- populated in Wsh_New_Del_Interface table.

5496: -- x_return_status => Return Status of API (Either S,E,U)
5497: --
5498: -- COMMENT:
5499: -- API to derive/validate standalone related order header attributes
5500: -- populated in Wsh_New_Del_Interface table.
5501: --=============================================================================
5502: --
5503: PROCEDURE Derive_Header_Rec(
5504: p_om_header_rec IN OUT NOCOPY OM_Header_Rec_Type,

Line 5951: Wsh_New_Del_Interface wndi

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
5954: AND wddi.delivery_detail_interface_id = wdai.delivery_detail_interface_id
5955: AND wdai.delivery_interface_id = wndi.delivery_interface_id

Line 6377: Wsh_New_Del_Interface wndi

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
6380: AND wdai.interface_action_code = g_interface_action_code
6381: AND wddi.delivery_detail_interface_id = wdai.delivery_detail_interface_id