APPS.WSH_DELIVERIES_GRP dependencies on STANDARD

Line 153: AND d1.delivery_type = 'STANDARD'

149: WHERE d1.delivery_id <> c_delivery_id
150: AND s1.stop_id = dl1.pick_up_stop_id
151: AND d1.delivery_id = dl1.delivery_id
152: AND d1.status_code = 'OP'
153: AND d1.delivery_type = 'STANDARD'
154: AND s2.trip_id = s1.trip_id
155: AND s2.stop_id = dl2.pick_up_stop_id
156: AND dl2.delivery_id = c_delivery_id
157: AND rownum = 1;

Line 3137: -- Standard check of p_commit.

3133: WSH_DEBUG_SV.log(l_module_name, 'l_num_warnings', l_num_warnings);
3134: WSH_DEBUG_SV.log(l_module_name, 'l_num_warnings', l_num_warnings);
3135: END IF;
3136:
3137: -- Standard check of p_commit.
3138: IF FND_API.To_Boolean( p_commit ) THEN
3139:
3140: --bug 4070732
3141: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN

Line 3735: IF (nvl(x_rec_attr_tab(l_index).delivery_type,'STANDARD') NOT IN ('STANDARD','CONSOLIDATION')) THEN

3731: END IF;
3732: --
3733: END IF;
3734: --
3735: IF (nvl(x_rec_attr_tab(l_index).delivery_type,'STANDARD') NOT IN ('STANDARD','CONSOLIDATION')) THEN
3736: x_rec_attr_tab(l_index).delivery_type := 'STANDARD';
3737: END IF;
3738: --Bug 5191354
3739: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_LOADING_ORDER_LVL) = 1

Line 3736: x_rec_attr_tab(l_index).delivery_type := 'STANDARD';

3732: --
3733: END IF;
3734: --
3735: IF (nvl(x_rec_attr_tab(l_index).delivery_type,'STANDARD') NOT IN ('STANDARD','CONSOLIDATION')) THEN
3736: x_rec_attr_tab(l_index).delivery_type := 'STANDARD';
3737: END IF;
3738: --Bug 5191354
3739: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_LOADING_ORDER_LVL) = 1
3740: AND (p_action_code = 'CREATE' OR

Line 5283: -- Standard check of p_commit.

5279: ELSE
5280: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
5281: END IF;
5282:
5283: -- Standard check of p_commit.
5284: IF FND_API.To_Boolean( p_commit ) THEN
5285:
5286: --bug 4070732
5287: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN

Line 5713: IF (nvl(p_delivery_info.delivery_type,'STANDARD') NOT IN ('STANDARD','CONSOLIDATED')) THEN

5709: RETURN;
5710: END IF;
5711: END IF;
5712:
5713: IF (nvl(p_delivery_info.delivery_type,'STANDARD') NOT IN ('STANDARD','CONSOLIDATED')) THEN
5714: p_delivery_info.delivery_type := 'STANDARD';
5715:
5716: END IF;
5717:

Line 5714: p_delivery_info.delivery_type := 'STANDARD';

5710: END IF;
5711: END IF;
5712:
5713: IF (nvl(p_delivery_info.delivery_type,'STANDARD') NOT IN ('STANDARD','CONSOLIDATED')) THEN
5714: p_delivery_info.delivery_type := 'STANDARD';
5715:
5716: END IF;
5717:
5718: IF (p_delivery_info.loading_order_flag <> FND_API.G_MISS_CHAR) OR (p_delivery_info.loading_order_desc <> FND_API.G_MISS_CHAR) THEN

Line 6314: -- Standard call to check for call compatibility

6310: --
6311: IF l_debug_on THEN
6312: wsh_debug_sv.push(l_module_name);
6313: END IF;
6314: -- Standard call to check for call compatibility
6315: IF NOT FND_API.Compatible_API_Call
6316: ( l_api_version_number
6317: , p_api_version_number
6318: , l_api_name

Line 6572: -- Standard call to check for call compatibility

6568: IF l_debug_on THEN
6569: wsh_debug_sv.push(l_module_name);
6570: END IF;
6571: --
6572: -- Standard call to check for call compatibility
6573: IF NOT FND_API.Compatible_API_Call
6574: ( l_api_version_number
6575: , p_api_version_number
6576: , l_api_name

Line 7019: -- Standard call to check for call compatibility

7015: wsh_debug_sv.log (l_module_name, 'Entity Type', p_entity_type );
7016: wsh_debug_sv.log (l_module_name, 'Entity Id', p_entity_id );
7017: END IF;
7018: --
7019: -- Standard call to check for call compatibility
7020: IF NOT FND_API.Compatible_API_Call
7021: ( l_api_version_number
7022: , p_api_version_number
7023: , l_api_name