DBA Data[Home] [Help]

APPS.WSH_DELIVERY_DETAILS_ACTIONS dependencies on WSH_LOOKUPS

Line 4060: l_status WSH_LOOKUPS.meaning%TYPE;

4056:
4057: /* H projects: pricing integration csun */
4058: l_scc_unassign_from_del NUMBER := 0;
4059: l_del_tab WSH_UTIL_CORE.Id_Tab_Type;
4060: l_status WSH_LOOKUPS.meaning%TYPE;
4061: l_return_status VARCHAR2(1);
4062:
4063: CURSOR get_lookup (l_code VARCHAR2) IS
4064: SELECT meaning

Line 4065: FROM wsh_lookups

4061: l_return_status VARCHAR2(1);
4062:
4063: CURSOR get_lookup (l_code VARCHAR2) IS
4064: SELECT meaning
4065: FROM wsh_lookups
4066: WHERE lookup_type = 'DELIVERY_STATUS'
4067: AND lookup_code = l_code;
4068:
4069: mark_reprice_error EXCEPTION;

Line 6648: l_status WSH_LOOKUPS.meaning%TYPE;

6644: l_dummy_del_det_id NUMBER;
6645: l_del_det_id NUMBER;
6646:
6647: l_del_tab WSH_UTIL_CORE.Id_Tab_Type;
6648: l_status WSH_LOOKUPS.meaning%TYPE;
6649:
6650: CURSOR get_lookup (l_code VARCHAR2) IS
6651: SELECT meaning
6652: FROM wsh_lookups

Line 6652: FROM wsh_lookups

6648: l_status WSH_LOOKUPS.meaning%TYPE;
6649:
6650: CURSOR get_lookup (l_code VARCHAR2) IS
6651: SELECT meaning
6652: FROM wsh_lookups
6653: WHERE lookup_type = 'DELIVERY_STATUS'
6654: AND lookup_code = l_code;
6655:
6656: