APPS.WMS_CROSSDOCK_GRP dependencies on WMS_XDOCK_UTILS_PVT

Line 49: AND wcc.criterion_type = wms_xdock_utils_pvt.G_CRT_TYPE_PLAN;

45: ) IS
46: SELECT wcc.criterion_id
47: FROM wms_crossdock_criteria wcc
48: WHERE wcc.criterion_id = p_crt_id
49: AND wcc.criterion_type = wms_xdock_utils_pvt.G_CRT_TYPE_PLAN;
50:
51: BEGIN
52: l_api_name := 'validate_planxdock_crt_id';
53: l_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

Line 134: AND wccv.criterion_type = wms_xdock_utils_pvt.G_CRT_TYPE_PLAN;

130: ) IS
131: SELECT wccv.criterion_name
132: FROM wms_crossdock_criteria_vl wccv
133: WHERE wccv.criterion_id = p_crt_id
134: AND wccv.criterion_type = wms_xdock_utils_pvt.G_CRT_TYPE_PLAN;
135:
136: CURSOR c_get_plan_crt_id
137: ( p_crt_name IN VARCHAR2
138: ) IS

Line 142: AND wccv.criterion_type = wms_xdock_utils_pvt.G_CRT_TYPE_PLAN;

138: ) IS
139: SELECT wccv.criterion_id
140: FROM wms_crossdock_criteria_vl wccv
141: WHERE wccv.criterion_name = p_crt_name
142: AND wccv.criterion_type = wms_xdock_utils_pvt.G_CRT_TYPE_PLAN;
143:
144: BEGIN
145: l_api_name := 'chk_planxd_crt_id_name';
146: l_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);