DBA Data[Home] [Help]

APPS.WSH_DELIVERY_DETAILS_ACTIONS dependencies on WSH_LOOKUPS

Line 4207: l_status WSH_LOOKUPS.meaning%TYPE;

4203:
4204: /* H projects: pricing integration csun */
4205: l_scc_unassign_from_del NUMBER := 0;
4206: l_del_tab WSH_UTIL_CORE.Id_Tab_Type;
4207: l_status WSH_LOOKUPS.meaning%TYPE;
4208: l_return_status VARCHAR2(1);
4209:
4210: CURSOR get_lookup (l_code VARCHAR2) IS
4211: SELECT meaning

Line 4212: FROM wsh_lookups

4208: l_return_status VARCHAR2(1);
4209:
4210: CURSOR get_lookup (l_code VARCHAR2) IS
4211: SELECT meaning
4212: FROM wsh_lookups
4213: WHERE lookup_type = 'DELIVERY_STATUS'
4214: AND lookup_code = l_code;
4215:
4216: mark_reprice_error EXCEPTION;

Line 6802: l_status WSH_LOOKUPS.meaning%TYPE;

6798: l_dummy_del_det_id NUMBER;
6799: l_del_det_id NUMBER;
6800:
6801: l_del_tab WSH_UTIL_CORE.Id_Tab_Type;
6802: l_status WSH_LOOKUPS.meaning%TYPE;
6803:
6804: CURSOR get_lookup (l_code VARCHAR2) IS
6805: SELECT meaning
6806: FROM wsh_lookups

Line 6806: FROM wsh_lookups

6802: l_status WSH_LOOKUPS.meaning%TYPE;
6803:
6804: CURSOR get_lookup (l_code VARCHAR2) IS
6805: SELECT meaning
6806: FROM wsh_lookups
6807: WHERE lookup_type = 'DELIVERY_STATUS'
6808: AND lookup_code = l_code;
6809:
6810: