1614: l_full_name CONSTANT VARCHAR2(100) := 'ahl.plsql.'||'AHL_UMP_UTIL_PKG'||'.'||'Get_Associated_Fleet';
1615:
1616: BEGIN
1617:
1618: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1619: FND_LOG.string(FND_LOG.level_statement,l_full_name,
1620: 'API Input Dump');
1621: FND_LOG.string(FND_LOG.level_statement,l_full_name,
1622: '****************');
1615:
1616: BEGIN
1617:
1618: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1619: FND_LOG.string(FND_LOG.level_statement,l_full_name,
1620: 'API Input Dump');
1621: FND_LOG.string(FND_LOG.level_statement,l_full_name,
1622: '****************');
1623: FND_LOG.string(FND_LOG.level_statement,l_full_name,
1617:
1618: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1619: FND_LOG.string(FND_LOG.level_statement,l_full_name,
1620: 'API Input Dump');
1621: FND_LOG.string(FND_LOG.level_statement,l_full_name,
1622: '****************');
1623: FND_LOG.string(FND_LOG.level_statement,l_full_name,
1624: 'p_uc_header_id -> '||p_uc_header_id);
1625: FND_LOG.string(FND_LOG.level_statement,l_full_name,
1619: FND_LOG.string(FND_LOG.level_statement,l_full_name,
1620: 'API Input Dump');
1621: FND_LOG.string(FND_LOG.level_statement,l_full_name,
1622: '****************');
1623: FND_LOG.string(FND_LOG.level_statement,l_full_name,
1624: 'p_uc_header_id -> '||p_uc_header_id);
1625: FND_LOG.string(FND_LOG.level_statement,l_full_name,
1626: 'p_assoc_date -> '||p_assoc_date);
1627: FND_LOG.string(FND_LOG.level_statement,l_full_name,
1621: FND_LOG.string(FND_LOG.level_statement,l_full_name,
1622: '****************');
1623: FND_LOG.string(FND_LOG.level_statement,l_full_name,
1624: 'p_uc_header_id -> '||p_uc_header_id);
1625: FND_LOG.string(FND_LOG.level_statement,l_full_name,
1626: 'p_assoc_date -> '||p_assoc_date);
1627: FND_LOG.string(FND_LOG.level_statement,l_full_name,
1628: 'p_plan_id -> '||p_plan_id);
1629: END IF;
1623: FND_LOG.string(FND_LOG.level_statement,l_full_name,
1624: 'p_uc_header_id -> '||p_uc_header_id);
1625: FND_LOG.string(FND_LOG.level_statement,l_full_name,
1626: 'p_assoc_date -> '||p_assoc_date);
1627: FND_LOG.string(FND_LOG.level_statement,l_full_name,
1628: 'p_plan_id -> '||p_plan_id);
1629: END IF;
1630:
1631: IF p_uc_header_id IS NULL OR p_assoc_date IS NULL
1649: OPEN c_get_assoc_fleet(p_uc_header_id,p_assoc_date,l_plan_id);
1650: FETCH c_get_assoc_fleet INTO l_fleet_header_id;
1651: CLOSE c_get_assoc_fleet;
1652:
1653: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1654: FND_LOG.string(FND_LOG.level_statement,l_full_name,
1655: 'l_fleet_header_id -> '||l_fleet_header_id);
1656: END IF;
1657:
1650: FETCH c_get_assoc_fleet INTO l_fleet_header_id;
1651: CLOSE c_get_assoc_fleet;
1652:
1653: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1654: FND_LOG.string(FND_LOG.level_statement,l_full_name,
1655: 'l_fleet_header_id -> '||l_fleet_header_id);
1656: END IF;
1657:
1658: RETURN l_fleet_header_id;