APPS.WSH_TRIP_STOPS_VALIDATIONS dependencies on MTL_INTERORG_PARAMETERS

Line 3149: CURSOR c_mtl_interorg_parameters (c_from_organization_id NUMBER, c_to_organization_id NUMBER) IS

3145: AND pl.requisition_line_id = oel.source_document_line_id
3146: AND pl.destination_organization_id <> pl.source_organization_id;
3147:
3148: -- Need to get intransit type from Shipping Networks
3149: CURSOR c_mtl_interorg_parameters (c_from_organization_id NUMBER, c_to_organization_id NUMBER) IS
3150: SELECT intransit_type
3151: FROM mtl_interorg_parameters
3152: WHERE from_organization_id = c_from_organization_id
3153: AND to_organization_id = c_to_organization_id;

Line 3151: FROM mtl_interorg_parameters

3147:
3148: -- Need to get intransit type from Shipping Networks
3149: CURSOR c_mtl_interorg_parameters (c_from_organization_id NUMBER, c_to_organization_id NUMBER) IS
3150: SELECT intransit_type
3151: FROM mtl_interorg_parameters
3152: WHERE from_organization_id = c_from_organization_id
3153: AND to_organization_id = c_to_organization_id;
3154:
3155: l_prev_dropoff_location_id NUMBER;

Line 4496: OPEN c_mtl_interorg_parameters( l_initial_pu_dlvy_rec.organization_id, l_rec_organization_id);

4492: l_validate_rec_org := TRUE;
4493: ELSE --{
4494: l_validate_rec_org := FALSE;
4495: -- Check Shipping Networks to find the Transit Type
4496: OPEN c_mtl_interorg_parameters( l_initial_pu_dlvy_rec.organization_id, l_rec_organization_id);
4497: FETCH c_mtl_interorg_parameters INTO l_intransit_type;
4498: IF c_mtl_interorg_parameters%FOUND THEN
4499: IF l_debug_on THEN
4500: WSH_DEBUG_SV.log(l_module_name,'Intransit Type', l_intransit_type);

Line 4497: FETCH c_mtl_interorg_parameters INTO l_intransit_type;

4493: ELSE --{
4494: l_validate_rec_org := FALSE;
4495: -- Check Shipping Networks to find the Transit Type
4496: OPEN c_mtl_interorg_parameters( l_initial_pu_dlvy_rec.organization_id, l_rec_organization_id);
4497: FETCH c_mtl_interorg_parameters INTO l_intransit_type;
4498: IF c_mtl_interorg_parameters%FOUND THEN
4499: IF l_debug_on THEN
4500: WSH_DEBUG_SV.log(l_module_name,'Intransit Type', l_intransit_type);
4501: END IF;

Line 4498: IF c_mtl_interorg_parameters%FOUND THEN

4494: l_validate_rec_org := FALSE;
4495: -- Check Shipping Networks to find the Transit Type
4496: OPEN c_mtl_interorg_parameters( l_initial_pu_dlvy_rec.organization_id, l_rec_organization_id);
4497: FETCH c_mtl_interorg_parameters INTO l_intransit_type;
4498: IF c_mtl_interorg_parameters%FOUND THEN
4499: IF l_debug_on THEN
4500: WSH_DEBUG_SV.log(l_module_name,'Intransit Type', l_intransit_type);
4501: END IF;
4502: IF l_intransit_type = 1 THEN

Line 4506: CLOSE c_mtl_interorg_parameters; --}

4502: IF l_intransit_type = 1 THEN
4503: l_validate_rec_org := TRUE;
4504: END IF;
4505: END IF;
4506: CLOSE c_mtl_interorg_parameters; --}
4507: END IF;
4508:
4509: IF l_validate_rec_org THEN --{
4510: -- Check for open inventory period