APPS.WSH_DELIVERY_DETAILS_INV dependencies on MTL_INTERORG_PARAMETERS

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

5142: AND pl.requisition_line_id = pd.requisition_line_id;
5143:
5144: l_po_info c_po_info%ROWTYPE;
5145:
5146: CURSOR c_mtl_interorg_parameters (c_from_organization_id NUMBER , c_to_organization_id NUMBER) IS
5147: SELECT intransit_type
5148: FROM mtl_interorg_parameters
5149: WHERE from_organization_id = c_from_organization_id AND
5150: to_organization_id = c_to_organization_id;

Line 5148: FROM mtl_interorg_parameters

5144: l_po_info c_po_info%ROWTYPE;
5145:
5146: CURSOR c_mtl_interorg_parameters (c_from_organization_id NUMBER , c_to_organization_id NUMBER) IS
5147: SELECT intransit_type
5148: FROM mtl_interorg_parameters
5149: WHERE from_organization_id = c_from_organization_id AND
5150: to_organization_id = c_to_organization_id;
5151: l_intransit_type NUMBER;
5152:

Line 5207: OPEN c_mtl_interorg_parameters( l_po_info.source_organization_id,

5203: (l_po_info.source_organization_id = l_po_info.destination_organization_id) THEN
5204: x_transaction_type_id := 50 /* Subinv_xfer */;
5205: ELSIF (l_po_info.destination_organization_id <> l_po_info.source_organization_id) THEN
5206:
5207: OPEN c_mtl_interorg_parameters( l_po_info.source_organization_id,
5208: l_po_info.destination_organization_id);
5209: FETCH c_mtl_interorg_parameters INTO l_intransit_type;
5210:
5211: IF c_mtl_interorg_parameters%NOTFOUND THEN

Line 5209: FETCH c_mtl_interorg_parameters INTO l_intransit_type;

5205: ELSIF (l_po_info.destination_organization_id <> l_po_info.source_organization_id) THEN
5206:
5207: OPEN c_mtl_interorg_parameters( l_po_info.source_organization_id,
5208: l_po_info.destination_organization_id);
5209: FETCH c_mtl_interorg_parameters INTO l_intransit_type;
5210:
5211: IF c_mtl_interorg_parameters%NOTFOUND THEN
5212: /* default to intransit */
5213: x_transaction_type_id := 62; /* intransit_shpmnt */

Line 5211: IF c_mtl_interorg_parameters%NOTFOUND THEN

5207: OPEN c_mtl_interorg_parameters( l_po_info.source_organization_id,
5208: l_po_info.destination_organization_id);
5209: FETCH c_mtl_interorg_parameters INTO l_intransit_type;
5210:
5211: IF c_mtl_interorg_parameters%NOTFOUND THEN
5212: /* default to intransit */
5213: x_transaction_type_id := 62; /* intransit_shpmnt */
5214: ELSE
5215: IF l_intransit_type = 1 THEN

Line 5221: CLOSE c_mtl_interorg_parameters;

5217: ELSE
5218: x_transaction_type_id := 62; /* intransit_shpmnt */
5219: END IF;
5220: END IF;
5221: CLOSE c_mtl_interorg_parameters;
5222: END IF;
5223: ELSE
5224: x_transaction_type_id := 33;
5225: END IF;

Line 5252: IF c_mtl_interorg_parameters%isopen THEN

5248: END IF;
5249: IF c_po_info%isopen THEN
5250: CLOSE c_po_info;
5251: END IF;
5252: IF c_mtl_interorg_parameters%isopen THEN
5253: CLOSE c_mtl_interorg_parameters;
5254: END IF;
5255: IF l_debug_on THEN
5256: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 5253: CLOSE c_mtl_interorg_parameters;

5249: IF c_po_info%isopen THEN
5250: CLOSE c_po_info;
5251: END IF;
5252: IF c_mtl_interorg_parameters%isopen THEN
5253: CLOSE c_mtl_interorg_parameters;
5254: END IF;
5255: IF l_debug_on THEN
5256: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
5257: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');