APPS.WMS_DIRECT_SHIP_PVT dependencies on DUAL

Line 1078: open x_missing_item_cur FOR select 1 from dual;

1074: IF (l_debug = 1) THEN
1075: debug('Dummy Cur: Delivery Id : '||p_delivery_id||' Org Id '
1076: ||p_organization_id||' Dock Door '||p_dock_door_id,'Missing_Item_Cur');
1077: END IF;
1078: open x_missing_item_cur FOR select 1 from dual;
1079: return;
1080: END;
1081: END IF;
1082: END MISSING_ITEM_CUR;

Line 4008: FROM DUAL;

4004: * We will use this Transaction temp Id as the group Mark Id aslo.
4005: ********************/
4006: SELECT mtl_material_transactions_s.NEXTVAL
4007: INTO x_transaction_temp_id
4008: FROM DUAL;
4009:
4010: -- Update group_mark_id to reflect newly created transaction_temp_id
4011: l_group_mark_id := x_transaction_temp_id;
4012:

Line 5631: FROM DUAL;

5627:
5628: IF (l_delivery_detail_tab(i).transaction_temp_id IS NULL) THEN
5629: SELECT mtl_material_transactions_s.NEXTVAL
5630: INTO l_delivery_detail_tab(i).transaction_temp_id
5631: FROM DUAL;
5632:
5633: -- update wds with transaction_temp_id, will be used in unload lpn if required bug# 2829514
5634: UPDATE wms_direct_ship_temp
5635: SET transaction_temp_id = l_delivery_detail_tab(i).transaction_temp_id

Line 5900: FROM DUAL;

5896:
5897: IF (l_delivery_detail_tab(i).transaction_temp_id IS NULL) THEN
5898: SELECT mtl_material_transactions_s.NEXTVAL
5899: INTO l_delivery_detail_tab(i).transaction_temp_id
5900: FROM DUAL;
5901:
5902: l_invpcinrectype.transaction_temp_id := l_delivery_detail_tab(i).transaction_temp_id;
5903:
5904: -- update wds with transaction_temp_id, will be used in unload lpn if required bug# 2829514

Line 8001: FROM DUAL

7997: WHEN NO_DATA_FOUND THEN
7998: BEGIN
7999: SELECT 1
8000: INTO l_num
8001: FROM DUAL
8002: WHERE EXISTS(
8003: SELECT 1
8004: FROM wsh_delivery_assignments_v wda, wsh_delivery_details_ob_grp_v wdd
8005: WHERE wdd.delivery_detail_id = wda.delivery_detail_id

Line 8797: FROM DUAL

8793: --Bug 2909327:Changed the call to check wsh_delivery_details instead of oel*/
8794: BEGIN
8795: SELECT 1
8796: INTO l_order_line_status
8797: FROM DUAL
8798: WHERE EXISTS(SELECT delivery_detail_id
8799: FROM wsh_delivery_details_ob_grp_v
8800: WHERE released_status IN('R', 'B')
8801: AND source_line_id = l_order_line_rec.line_id

Line 9110: FROM DUAL;

9106: -- get group_id
9107: BEGIN
9108: SELECT mtl_material_transactions_s.NEXTVAL
9109: INTO g_group_id
9110: FROM DUAL;
9111: EXCEPTION
9112: WHEN NO_DATA_FOUND THEN
9113: g_group_id := 0;
9114: END;

Line 9142: FROM DUAL;

9138: IF (l_processed_lines_tab(l_temp_index).serial_required_flag = 'Y') THEN
9139: BEGIN
9140: SELECT mtl_material_transactions_s.NEXTVAL
9141: INTO l_trx_temp_id
9142: FROM DUAL;
9143: EXCEPTION
9144: WHEN NO_DATA_FOUND THEN
9145: IF (l_debug = 1) THEN
9146: DEBUG('Unable to get transaction_temp_id', 'Process_LPN');

Line 10120: FROM DUAL;

10116: IF (l_serial_required_flag = 'Y') THEN
10117: BEGIN
10118: SELECT mtl_material_transactions_s.NEXTVAL
10119: INTO l_trx_temp_id
10120: FROM DUAL;
10121: EXCEPTION
10122: WHEN NO_DATA_FOUND THEN
10123: IF (l_debug = 1) THEN
10124: DEBUG('Error getting transaction_temp_id', 'Process_Line');