APPS.WSH_SHIPMENT_REQUEST_PKG dependencies on WSH_DEL_ASSGN_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 1111: Wsh_Del_Assgn_Interface wdai,

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
1115: AND wddi.delivery_detail_interface_id = wdai.delivery_detail_interface_id

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 1160: Wsh_Del_Assgn_Interface wdai,

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
1164: AND wddi.delivery_detail_interface_id = wdai.delivery_detail_interface_id

Line 1360: Wsh_Del_Assgn_Interface wdai

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
1364: AND wddi.delivery_detail_interface_id = wdai.delivery_detail_interface_id

Line 2381: Wsh_Del_Assgn_Interface wdai

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
2385: AND wdai.delivery_interface_id = l_entity_number );

Line 3058: wsh_del_assgn_interface wdai

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
3062: and wdai.interface_action_code = g_interface_action_code

Line 3075: wsh_del_assgn_interface wdai

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
3079: and wddi.delivery_detail_interface_id = wdai.delivery_detail_interface_id

Line 5950: Wsh_Del_Assgn_Interface wdai,

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

Line 6376: Wsh_Del_Assgn_Interface wdai,

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